Problem solve Get help with specific problems with your technologies, process and projects.

Suffering intermittent errors after upgrade

This user recently upgraded his iSeries to V5R3 and is now suffering intermittent errors in SQL Server DTS packages.

We upgraded our iSeries to V5R3 recently and we are suffering intermittent errors in SQL Server DTS packages. That is packages which have worked successfully for years now work for six out of seven days or every other day.

We are receiving the following error message:

 [IBM][iSeries Access ODBC Driver][DB2 UDB]PWS0001 - Function did not complete successfully.      Error source:  Microsoft OLE DB Provider for ODBC Drivers      Help file:        Help context:  0      DTSRun OnError:  DTSStep_DTSExecutePackageTask_1, Error = -2147220440 (80040428)      Error string:  DTSStep_DTSExecutePackageTask_1: (2:ODS_agRepICBS_Account) SubStep 'DTSStep_DTSDataPumpTask_3' failed with the following error:...  Process Exit Code 1.  The step failed.
The Client Access ODBC version being used is V5R2. Can you advice us on this situation?
I can not determine from the message the exact reason for the failure. However, here are two things you need to do:

  • Upgrade iSeries access to version 5.3 -- it has better support for OLEDB.
  • Delete all relevant SQL packages from the iSeries (or go to the data source and set the extended dynamic property to no.)
  • That should help.


    Visit the ITKnowledge Exchange and get answers to your connectivity questions fast.

    The Best Web Links: Tips, tutorials and more.

    PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.

    Dig Deeper on iSeries upgrades and modernization

    Have a question for an expert?

    Please add a title for your question

    Get answers from a TechTarget expert on whatever's puzzling you.

    You will be able to add details on the next page.

    Start the conversation

    Send me notifications when other members comment.

    Please create a username to comment.