AES Upgrade 7.2 database issues
Hi,
I am upgrading AES to level 7.2
When importing I'm asked to update the database.
One of the statements results in an error..
ALTER TABLE PEGA_DATA.pegaam_action_work ADD COLUMN "CURRENTWEEKKPI" DECIMAL (32, 9); ALTER TABLE PEGA_DATA.pegaam_action_work ADD COLUMN "LASTWEEKKPI" DECIMAL (32, 9);
Error: SQL0604N The length, precision, or scale attribute for column, distinct type, structured type, array type, attribute of structured type, routine, cast target type, type mapping, or global variable "DECIMAL (32, 9)" is not valid. SQLSTATE=42611 (State:42611, Native Code: FFFFFDA4)
We are running on DB2 V10.
What's going wrong?
Kind regards,
Arjan Maus
Techmahindra
IN
Hello Arjan,
In the past we have seen some issues with DB2 Database as the decimal precision is shorter in DB2 when compared to other DB.
Could you provide the describe table of pegaam_action_work or the create syntax of this table.
Also confirm from which version of AES are you upgrading?
Regards,
Shanthini Charles
Pegasystems Inc.
IN
Hi Arjun
In DB2 database server "Numeric" data type has a precision of 31, in other database servers like postgres and Oracle precision is more than 31.
Alter the DDL statements to match the precision of the target database and re-run the statements.
Best Practice: As a best practice, define the data type within 0-31 precision range, which will eliminate issue with other database servers, thus allowing the RAP or other operations within different database servers to be consistent.
Best Regards
Saran Kolla
Achmea
NL
Hi,
We've changed the SQL statements and created the tables as stated with a size of 31.
This didn't do the job for us, unfortunately.
When trying to import the AES_07_14_01 archive I still get prompted to change the database
--execute on the database specified by Data-Admin-DB-Name PegaRULES:
ALTER TABLE PEGA_DATA.pegaam_action_work ALTER COLUMN "CURRENTWEEKKPI" SET DATA TYPE DECIMAL (32, 9)
@
--execute on the database specified by Data-Admin-DB-Name PegaRULES:
CALL SYSPROC.ADMIN_CMD('REORG TABLE PEGA_DATA.pegaam_action_work')
@
--execute on the database specified by Data-Admin-DB-Name PegaRULES:
ALTER TABLE PEGA_DATA.pegaam_action_work ALTER COLUMN "LASTWEEKKPI" SET DATA TYPE DECIMAL (32, 9)
@
--execute on the database specified by Data-Admin-DB-Name PegaRULES:
CALL SYSPROC.ADMIN_CMD('REORG TABLE PEGA_DATA.pegaam_action_work
Can anybody give me advice about what to do now?
Kind regards,
Arjan Maus
PS: We are now running on AES 07_13_01