User is getting error when migrating PeopleSoft objects through the PeopleSoft Staging installed on a DB2 database inside a Mainframe server. (4288893)

User is getting error when migrating PeopleSoft objects through the PeopleSoft Staging installed on a DB2 database inside a Mainframe server.

The error is:

DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=IBTRANSACTIONID, DRIVER=3.65.97

PeopleTools 8.54 - The table PSDOCLOURITMPL did not need to be included in the Stat DB2 Staging script. Because during that time the column IB_DESCRLONG did allow nulls.

PeopleTools 8.55 - In this release the column IB_DESCRLONG was changed to NOT NULL which required a script change, but the new column IBTRANSACTIONID was left off PeopleTools 8.55 - the same issue was then carried forward into the following script (along with new column IB_CUST_INDICATOR left off).

PeopleTools 8.56 - Please read the section above.

Attached are the 2 revised script (with a "b" added to the end just to tell the scripts apart from the old ones) StageDB2-OS390-855b.sql StageDB2-OS390-856b.sql