When running the JTX post installation against an Oracle database, the following error message displays:
“Unable to create FiLE_DATA in the table JTX.JTX_STEP_TYPE. Underlying DBMS error [Underlying DBMS error[ORA-01754: a table may contain only one column of type LONG] [JTX Table name]]”.
In Oracle, there may only be one column of type LONG. Oracle throws an error when another LONG field is about to get added to the table. This error may occur when migrating from 9.1 to 9.3 SDE.
This applies to users that have previously installed ArcSDE 9.1 and are upgrading their ArcSDE to an older version.
In ArcSDE 9.1, the binary’s default is defaulted to use LONG. In Oracle, there may only be one column of type LONG. There is a chance that there may be more than one LONG field in a table when the JTX post installation is run. This causes an error and it will cause the post installation to fail.