Error: Unable to create FILE_DATA in table JTX.JTX_STEP_TYPE. Underlying DBMS error
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.
Solution or Workaround
Update the dbtune file to use BLOB as the default Attribute_Binary data type.
- Launch the command line prompt and export the dbtune file using the command sdedbtune -o export -f <specify export location> -u <database user name>.
- Open the dbtune file in a text editor and update the ATTRIBUTE_BINARY “LONG” to read ATTRIBUTE_BINARY “BLOB”.
- Import the dbtune file using the command sdedbtune -o import -f <specify the file name>.