Troubleshooting: Warning message in migratedb log
An SQL exception is logged during database migration.
Problem
After running the migratedb
script,
you see the following message in the migratedb log:
Info : select max(columnname) from tablename where columnname>=
0 and columnname<= 2147483648
Warning: SQLException: ORA-00904: "columnname": invalid identifier
Solution
Perform the following steps to correct the column name in your KEYS table:
- Find out the correct column name which is used as the unique ID for the table.
- Connect to your database.
- Run the following
SQL script to update the KEYS table to have the correct
columnname:
update KEYS set COLUMNNAME =columnname where tablename=yourtablename
- Run the following SQL script to get the max
value of columnname:
select counter, lowerbound, upperbound from KEYS where tablename=yourtablename; select max(columnname) from yourtablename where columnname>= lowerbound and columnname<= upperbound
- If the max value of the column is larger than
the counter value, run
the following SQL to update the counter value in the KEYS table:
update KEYS set COUNTER=maxvalue where tablename=yourtablename