We are currently upgrading Stat from Version 5.6.2 to Version 5.7.0.
The STAT DB is on Sql Server and the PS is on DB2. The upgrade has been completed and the necessary JDBC drivers and configuration settings for DB2 PS connections have been updated.
While attempting to create a new Archive set, the archive set fails to complete with
"Error Creating SQL: Database type not supported".
We trying changing the DBMS/Sytax overide to both DB2 and UDB and the error persists.
From PeopleSoft Connect window.
Check the column - Other Database Parameters and make sure it looks like:
currentSchema=..... instead of CURRENTSCHEMA=......
RESOLUTION:
1. Verify From PeopleSoft Connect window.
Check the column - Other Database Parameters and make sure it looks like:
currentSchema=..... instead of CURRENTSCHEMA=......
2. Logout of Stat Windows Client then login again then perform new archive set and migration to verify
