Error received when performing a migration:
"Warning! Unable to check locks in staging target. Error is: SQLCODE - 0, SQLDBCode = 942, SQLRows = 0, SQLErrText = ORA-00942: table or view does not exist"
PS staging table STAT_STAGE_CNTRL has not been created in the staging database.
Have you recently upgrade or refreshed the staging database?
The error message indicates that the PS staging table STAT_STAGE_CNTRL is missing from the PS Staging database.
Login to your staging database via SQL Plus and run the following command:
DESCR STAT_STAGE_CNTRL
If this table does not exist, then the script to create the stage control table has not been executed.
To execute this script, navigate to the directory where the Stat client is installed and locate <Stat_Home>\Scripts\Oracle\Staging. The appropriate staging script needs to be run on each PeopleSoft staging db.
