PSIcapture Migration Error: Database Migration to IBM DB2 using ODBC

Problem:

User is using automation to Migrate to an IBM DB2. The Batch is checked in at the Migration step and did not successfully migrate to the database.

You look in the logs and find this error.

[2/5/2015 10:59:30 AM - Error - v5.3.1.5]
Migration processing was cancelled. Error migrating Batch.

Batch: 20150205.105841 (Auto Import)
Migration: Database
Error: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Solution:

User DSN is being utilized in ODBC connection settings. Have the user remove the User DSN entry for the iSeries Access ODBC Driver. They will need to rebuild the same connection settings under System DNS in order for Automation to correctly Migrate the files.

When you use User DSN it only allows the user that physically created the connection to access it. This will not allow the Capture Services Service to access the connection. When you setup a connection under system it allows multiple users to utilize that connection.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.