Q
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.

    ==================================
    MORE INFORMATION ON THIS TOPIC
    ==================================

    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.

    This was last published in July 2005

    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.

    -ADS BY GOOGLE

    SearchDataCenter

    • How do I size a UPS unit?

      Your data center UPS sizing needs are dependent on a variety of factors. Develop configurations and determine the estimated UPS ...

    • How to enhance FTP server security

      If you still use FTP servers in your organization, use IP address whitelists, login restrictions and data encryption -- and just ...

    • 3 ways to approach cloud bursting

      With different cloud bursting techniques and tools from Amazon, Zerto, VMware and Oracle, admins can bolster cloud connections ...

    Close