Solved

CWBC01049 The iseries server application is not started.

Posted on 2010-09-17
2
8,631 Views
Last Modified: 2013-12-06
I have a client the is using ODBC to import/export shipping information from the UPS Worldship.  This has work for them for years, until recently we had to replace their AS400.  They went from a 170 V4R5 to another 170 V5R1.  Only the user libraries were restored to the replacement everything else like the profiles and devices had to be manually configured.

So after everything was set back up on the replacement we tested the import/export on the UPS and it still work with no problem, except every once in awhile the export (UPS --> AS400) pops up the error "CWBC01049 The iseries server application is not started." and that shipment information does not reach the AS400.

There is no specific day or time when this happens.  Sometimes it will not happen for a week or two and sometimes it will happen a few times a day a few times a week.

Has anyone ever had this problem or ell me where to begin to look.  I've tried looking through jobs logs but can not seem to find what is causing the connection issue.

Thank You
0
Comment
Question by:DCS12
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 35

Accepted Solution

by:
Gary Patterson earned 500 total points
ID: 33703796
This usually just happens when one or more of the Client Access service jobs that run on the AS/400 aren't started.  Usual cure is to start the missing services using STRHOSTSVR command.  A lot of shops just include the STRHOSTSVR *ALL command int heir system startup program.  

Maybe the old startup program didn't get migrated to the new system, or the QSTRUPPGM system value didn't get pointed to the correct startup program.

Maybe some process runs at night that needs the host servers without restarting them, or maybe you have a bug (did you apply the most recent cume PTF for V5R1 when swapping systems?) that is causing the server jobs to crash?

Open System i Navigator (iseries navigator, navigator, whatever it is called in your version, and navigate to your system.  Select Network - Servers - System i Access (varies by version), and look at the status of the various Client Access server jobs.  Odds are a critical one is Not Started.  In your case, it will probably be Database, Sign On, or Server Mapper.

Start the necessary services.  If something is shutting them down, you can probably find an indication on the system history log, the QSYSOPR message queue, or in the job log from one of the completed server jobs (ODBC server jobs are named QZDASOINIT).

WRKJOB QZDASOINIT to view a list of started database server jobs, plus jobs that ended but left a job log.

http://www-03.ibm.com/systems/i/software/access/linux/guide/cwbcoer.html 

- Gary Patterson
0
 

Author Closing Comment

by:DCS12
ID: 33859191
Sorry for not getting back so soon.  
I had already checked the things you had mentioned and there was nothing when looking at the jobs.  I think maybe the problem was on the UPS PC side and I think (hope) I have fixed it by re-creating everything from scratch.  

I deleted the Maps in UPS software, the ODBC data source on the PC, the SQL package on the AS/400 and the journal over the export file.  After re-creating everything they have had no problems since.

Thanks
0

Featured Post

[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.
Suggested Courses

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question