Paul_Smith_9332

AWA Version 10 and higher with Oracle numeric data types 'INTEGER'.

Discussion created by Paul_Smith_9332 on Mar 27, 2018
Customer's Question:
We have upgraded to Version 12 and our Oracle numeric data types are still 'INTEGER'. Is this an error?

Answer:
If you have migrated from an AWA (Automic Workload Automation) version 9 or lower to a more current version and you are using Oracle as your database, you may have noticed that your data types are still set to 'INTEGER' instead of 'NUMBER(38,0)' as in a scratch installation.
Oracle changed the default data type for numeric values from 'INTEGER' to 'NUMBER(38,0)' between the Oracle Releases 9i/10g/11/12.

This is not an issue unless you are planning to use ILM.

If you plan to use ILM and your data types are still 'INTEGER', you can convert them using a script - DBM_number_ILM.sql, which is provided in the installation image. To be exact, you can find the script in the folder 'db/oracle'.

If you install ILM and you have not converted your numeric data types to NUMBER(38,0), you will receive the following error message:
U0003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR', ",'ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION'

Outcomes