Automic Workload Automation

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

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

    Posted 03-27-2018 04:29 AM
    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'