Solved

CWBC01049 The iseries server application is not started.

Posted on 2010-09-17
2
7,592 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
2 Comments
 
LVL 34

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction Often we come across situations wherein our batch files would be needing to reboot Windows for a variety of reasons. A few of them would be like: (1) Setup files have been updated whose changes can take effect only after a reboot …
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.

867 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now