E1: UPGTC: AS400 Platform -Table Conversion Error - "SQL0913 - Row or object F0007 in CRPDTA type *FILE in use" and TCE009128 Error
Last updated on MAY 30, 2017
Applies to:JD Edwards EnterpriseOne Tools - Version SP24 and later
IBM i on POWER Systems
AS400 iSeries Enterprise Server. In this scenario, customer doing an upgrade from JD Edwards EnterpriseOne XE to 9.0 application release level. They are trying to run the business data Table Conversions under the Table Conversion Workbench. Of the first ones that run on the deployment server, the *ALTER and *MERGE ones have finished successfully.
Customer having trouble with the R89* TC jobs. In the table conversion logs, it says the conversion was done successfully, but the last line of the logs has statement "DropTable failed".
When they go look at the object locks on the table on the AS400, customer can see that their QZDASOINIT job is not releasing its lock so it can drop the table.
There were no locks on the table before starting the conversion.
The following is found for the JDE.LOG:
Customer doing an EnterpriseOne software upgrade and running the Table Conversion Workbench.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms