Troubleshoot: unable to connect to Payments database

 

Problem

After migrating your Payments instance, you cannot connect to the Payments database or run SQL correctly against the database.

 

Solution

Verify that the database is owned by the correct owner (QPYMSVR). If not, grant appropriate ownership to the instance library and its tables by running the following CL commands:

CHGOBJOWN OBJ(schemaName) OBJTYPE(*LIB) NEWOWN(owner)

CHGOWN OBJ('/QSYS.LIB/schemaName.LIB/*') NEWOWN(owner)

Where

• SchemaName is the schema name of the migrated instance. If you did not specify WPM_SCHEMA_NAME during application tier migration, the schema name is equal to the migrated Payments instance name.

• Owner is one of the following entities:

1. If your instance library resides on the system where WebSphere Commerce is installed, set the owner to QPYMSVR.

2. If you are using a remote database (the instance library and the Payments instance are on separate machines) set the owner to the database user ID specified during instance and database tier migration.

Related tasks

Migrate Payments database