[HighChartsComponent] HighChartsComponent in Java Stack

[HighChartsComponent] HighChartsComponent in Java Stack

  
Forge Component
(21)
Published on 30 Aug by J.
21 votes
Published on 30 Aug by J.

There seems to be an issue installing the current HighChartsComponent 1.1.0 into the Java Stack.

Tried on On-Prem Install on Java Stack, Platform 9.1.501

Same error with Cloud Install on Java Stack, Platform 9.1.0.20

More details on the error:

.....

Upgrading Database: Updating static entity records of module 'HighChartsInclude'

(Error) Upgrade Error: Generic SQL Error. ORA-01400: cannot insert NULL into ("OSADMIN"."OSSYS_ENTITY_RECORD"."DATA_ID")

ORA-06512: at line 1

java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("OSADMIN"."OSSYS_ENTITY_RECORD"."DATA_ID")

ORA-06512: at line 1

......

(Error) Deployment Aborted: The deployment was aborted due to errors. No applications or modules were deployed.

....

Upgrade Error
Message:
ORA-01400: cannot insert NULL into ("OSADMIN_DEV1"."OSSYS_ENTITY_RECORD"."DATA_ID")
ORA-06512: at line 1
Environment Information
Stack:
While executing:
DECLARE tmpVarExistsInTable NUMBER(10); v_Record_Id NUMBER(10); BEGIN SELECT  Count(1) INTO tmpVarExistsInTable FROM "OSADMIN_DEV1"."OSUSR_565_CHARTZOO" WHERE "VALUE" = 'xy'; IF tmpVarExistsInTable>0 THEN  UPDATE "OSADMIN_DEV1"."OSUSR_565_CHARTZOO" SET "LABEL"='XY' WHERE "VALUE"='xy'; ELSE  INSERT INTO "OSADMIN_DEV1"."OSUSR_565_CHARTZOO" ("LABEL", "VALUE") VALUES ('XY', 'xy') ; END IF; INSERT INTO "OSADMIN_DEV1"."OSSYS_ENTITY_RECORD" ("DATA_ID", "NAME", "SS_KEY", "ENTITY_SS_KEY", "ESPACE_ID", "IS_ACTIVE") VALUES ('xy', 'XY', '026768b7-a760-4e18-b430-0777c618f50f', '0c7f4eda-cd24-4b75-be73-8f976bad95d4', 276, 1) ; SELECT  Count(1) INTO tmpVarExistsInTable FROM "OSADMIN_DEV1"."OSUSR_565_CHARTZOO" WHERE "VALUE" = 'x'; IF tmpVarExistsInTable>0 THEN  UPDATE "OSADMIN_DEV1"."OSUSR_565_CHARTZOO" SET "LABEL"='X' WHERE "VALUE"='x'; ELSE  INSERT INTO "OSADMIN_DEV1"."OSUSR_565_CHARTZOO" ("LABEL", "VALUE") VALUES ('X', 'x') ; END IF; INSERT INTO "OSADMIN_DEV1"."OSSYS_ENTITY_RECORD" ("DATA_ID", "NAME", "SS_KEY", "ENTITY_SS_KEY", "ESPACE_ID", "IS_ACTIVE") VALUES ('x', 'X', '181d9add-593e-41dc-b07b-d0c0508a8e2d', '0c7f4eda-cd24-4b75-be73-8f976bad95d4', 276, 1) ; SELECT  Count(1) INTO tmpVarExistsInTable FROM "OSADMIN_DEV1"."OSUSR_565_CHARTZOO" WHERE "VALUE" = 'y'; IF tmpVarExistsInTable>0 THEN  UPDATE "OSADMIN_DEV1"."OSUSR_565_CHARTZOO" SET "LABEL"='Y' WHERE "VALUE"='y'; ELSE  INSERT INTO "OSADMIN_DEV1"."OSUSR_565_CHARTZOO" ("LABEL", "VALUE") VALUES ('Y', 'y') ; END IF; INSERT INTO "OSADMIN_DEV1"."OSSYS_ENTITY_RECORD" ("DATA_ID", "NAME", "SS_KEY", "ENTITY_SS_KEY", "ESPACE_ID", "IS_ACTIVE") VALUES ('y', 'Y', '5585cb45-7b56-49bd-9de6-c752e98db2ea', '0c7f4eda-cd24-4b75-be73-8f976bad95d4', 276, 1) ; SELECT  Count(1) INTO tmpVarExistsInTable FROM "OSADMIN_DEV1"."OSUSR_565_CHARTZOO" WHERE "VALUE" = ''; IF tmpVarExistsInTable>0 THEN  UPDATE "OSADMIN_DEV1"."OSUSR_565_CHARTZOO" SET "LABEL"='None' WHERE "VALUE"=''; ELSE  INSERT INTO "OSADMIN_DEV1"."OSUSR_565_CHARTZOO" ("LABEL", "VALUE") VALUES ('None', ' ') ; END IF; INSERT INTO "OSADMIN_DEV1"."OSSYS_ENTITY_RECORD" ("DATA_ID", "NAME", "SS_KEY", "ENTITY_SS_KEY", "ESPACE_ID", "IS_ACTIVE") VALUES ('', 'None', 'da7d6fa9-4d9d-4a17-bb64-7b7879b307bc', '0c7f4eda-cd24-4b75-be73-8f976bad95d4', 276, 1) ; END;

from file 'UpdateStaticEntityRecords.sql' of module 'HighChartsInclude'.

-----

Deployment aborted due to database upgrade errors.






The problem and a solution is in the HighChartsInclude the CHARTZOOMTYPE static entity has "" for the Value for the None record. You need something between the quotes or Oracle assumes this as NULL which you can't have for an Identity field.