E1: UPGTC: AS400 Platform -Table Conversion Error - "SQL0913 - Row or object F0007 in CRPDTA type *FILE in use" and TCE009128 Error (Doc ID 641382.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version SP24 and later
IBM i on POWER Systems

Symptoms

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:

  

Changes

 Customer doing an EnterpriseOne software upgrade and running the Table Conversion Workbench.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms