Error while running the sample file provided with HighCharts package 

Error while running the sample file provided with HighCharts package 

  
Internal 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
 
   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
   at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
   at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
   at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
   at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
   at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
   at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999)
   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
   at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1822)
   at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1787)
   at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:280)
   at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:242)
   at com.sun.proxy.$Proxy1.executeUpdate(Unknown Source)
   at outsystems.hubedition.runtimeplatform.db.DbCommand.execute(Unknown Source)
   at outsystems.hubedition.runtimeplatform.DBHelper.executeNonQueryDontCleanParameters(Unknown Source)
   at outsystems.hubedition.runtimeplatform.DBHelper.$rec(Unknown Source)
   at outsystems.hubedition.runtimeplatform.DBHelper.executeNonQuery(Unknown Source)
   at outsystems.hubedition.runtimeplatform.DBHelper.executeNonQuery(Unknown Source)
   at outsystems.hubedition.deploymentcontroller.DBCompilerService.executeInlineStatementWithTimeout(Unknown Source)
   at outsystems.hubedition.deploymentcontroller.Compiler.$mfd(Unknown Source)
   at outsystems.hubedition.deploymentcontroller.Compiler.$zvc(Unknown Source)
   at outsystems.hubedition.deploymentcontroller.Compiler.$eed(Unknown Source)
   at outsystems.hubedition.deploymentcontroller.Compiler.deployEspaceUpdateDB(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor166.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:303)
   at sun.rmi.transport.Transport$1.run(Transport.java:159)
   at java.security.AccessController.doPrivileged(Native Method)
   at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
   at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
   at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)
   at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
   at java.lang.Thread.run(Thread.java:662)
SQL:
DECLARE
                v_Record_Id number(10);
                v_record_count number(10);
BEGIN
                SELECT Count(1) INTO v_record_count FROM "OSADMIN"."OSUSR_PKI_CHARTZO6" WHERE "VALUE" = 'xy';
                IF v_record_count> 0 THEN
                                UPDATE "OSADMIN"."OSUSR_PKI_CHARTZO6" SET "LABEL"='XY' WHERE "VALUE"='xy';
                ELSE
                                INSERT INTO "OSADMIN"."OSUSR_PKI_CHARTZO6"("LABEL", "VALUE") VALUES ('XY', 'xy');
                END IF;
                INSERT INTO "OSADMIN".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', 43, 1);
 
                SELECT Count(1) INTO v_record_count FROM "OSADMIN"."OSUSR_PKI_CHARTZO6" WHERE "VALUE" = 'x';
                IF v_record_count> 0 THEN
                                UPDATE "OSADMIN"."OSUSR_PKI_CHARTZO6" SET "LABEL"='X' WHERE "VALUE"='x';
                ELSE
                                INSERT INTO "OSADMIN"."OSUSR_PKI_CHARTZO6"("LABEL", "VALUE") VALUES ('X', 'x');
                END IF;
                INSERT INTO "OSADMIN".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', 43, 1);
 
                SELECT Count(1) INTO v_record_count FROM "OSADMIN"."OSUSR_PKI_CHARTZO6" WHERE "VALUE" = 'y';
                IF v_record_count> 0 THEN
                                UPDATE "OSADMIN"."OSUSR_PKI_CHARTZO6" SET "LABEL"='Y' WHERE "VALUE"='y';
                ELSE
                                INSERT INTO "OSADMIN"."OSUSR_PKI_CHARTZO6"("LABEL", "VALUE") VALUES ('Y', 'y');
                END IF;
                INSERT INTO "OSADMIN".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', 43, 1);
 
                SELECT Count(1) INTO v_record_count FROM "OSADMIN"."OSUSR_PKI_CHARTZO6" WHERE "VALUE" = '';
                IF v_record_count> 0 THEN
                                UPDATE "OSADMIN"."OSUSR_PKI_CHARTZO6" SET "LABEL"='None' WHERE "VALUE"='';
                ELSE
                                INSERT INTO "OSADMIN"."OSUSR_PKI_CHARTZO6"("LABEL", "VALUE") VALUES ('None', ' ');
                END IF;
                INSERT INTO "OSADMIN".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', 43, 1);
 
END;
 
.
Exception Details:
[1] Internal 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
 
   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
   at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
   at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
   at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
   at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
   at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
   at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999)
   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
   at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1822)
   at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1787)
   at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:280)
   at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:242)
   at com.sun.proxy.$Proxy1.executeUpdate(Unknown Source)
   at outsystems.hubedition.runtimeplatform.db.DbCommand.execute(Unknown Source)
   at outsystems.hubedition.runtimeplatform.DBHelper.executeNonQueryDontCleanParameters(Unknown Source)
   at outsystems.hubedition.runtimeplatform.DBHelper.$rec(Unknown Source)
   at outsystems.hubedition.runtimeplatform.DBHelper.executeNonQuery(Unknown Source)
   at outsystems.hubedition.runtimeplatform.DBHelper.executeNonQuery(Unknown Source)
   at outsystems.hubedition.deploymentcontroller.DBCompilerService.executeInlineStatementWithTimeout(Unknown Source)
   at outsystems.hubedition.deploymentcontroller.Compiler.$mfd(Unknown Source)
   at outsystems.hubedition.deploymentcontroller.Compiler.$zvc(Unknown Source)
   at outsystems.hubedition.deploymentcontroller.Compiler.$eed(Unknown Source)
   at outsystems.hubedition.deploymentcontroller.Compiler.deployEspaceUpdateDB(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor166.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:303)
   at sun.rmi.transport.Transport$1.run(Transport.java:159)
   at java.security.AccessController.doPrivileged(Native Method)
   at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
   at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
   at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)
   at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
   at java.lang.Thread.run(Thread.java:662)
SQL:
DECLARE
                v_Record_Id number(10);
                v_record_count number(10);
BEGIN
                SELECT Count(1) INTO v_record_count FROM "OSADMIN"."OSUSR_PKI_CHARTZO6" WHERE "VALUE" = 'xy';
                IF v_record_count> 0 THEN
                                UPDATE "OSADMIN"."OSUSR_PKI_CHARTZO6" SET "LABEL"='XY' WHERE "VALUE"='xy';
                ELSE
                                INSERT INTO "OSADMIN"."OSUSR_PKI_CHARTZO6"("LABEL", "VALUE") VALUES ('XY', 'xy');
                END IF;
                INSERT INTO "OSADMIN".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', 43, 1);
 
                SELECT Count(1) INTO v_record_count FROM "OSADMIN"."OSUSR_PKI_CHARTZO6" WHERE "VALUE" = 'x';
                IF v_record_count> 0 THEN
                                UPDATE "OSADMIN"."OSUSR_PKI_CHARTZO6" SET "LABEL"='X' WHERE "VALUE"='x';
                ELSE
                                INSERT INTO "OSADMIN"."OSUSR_PKI_CHARTZO6"("LABEL", "VALUE") VALUES ('X', 'x');
                END IF;
                INSERT INTO "OSADMIN".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', 43, 1);
 
                SELECT Count(1) INTO v_record_count FROM "OSADMIN"."OSUSR_PKI_CHARTZO6" WHERE "VALUE" = 'y';
                IF v_record_count> 0 THEN
                                UPDATE "OSADMIN"."OSUSR_PKI_CHARTZO6" SET "LABEL"='Y' WHERE "VALUE"='y';
                ELSE
                                INSERT INTO "OSADMIN"."OSUSR_PKI_CHARTZO6"("LABEL", "VALUE") VALUES ('Y', 'y');
                END IF;
                INSERT INTO "OSADMIN".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', 43, 1);
 
                SELECT Count(1) INTO v_record_count FROM "OSADMIN"."OSUSR_PKI_CHARTZO6" WHERE "VALUE" = '';
                IF v_record_count> 0 THEN
                                UPDATE "OSADMIN"."OSUSR_PKI_CHARTZO6" SET "LABEL"='None' WHERE "VALUE"='';
                ELSE
                                INSERT INTO "OSADMIN"."OSUSR_PKI_CHARTZO6"("LABEL", "VALUE") VALUES ('None', ' ');
                END IF;
                INSERT INTO "OSADMIN".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', 43, 1);
 
END;
 
.
   at outsystems.hubedition.deploymentcontroller.Compiler.$mfd(Unknown Source)
   at outsystems.hubedition.deploymentcontroller.Compiler.$zvc(Unknown Source)
   at outsystems.hubedition.deploymentcontroller.Compiler.$eed(Unknown Source)
   at outsystems.hubedition.deploymentcontroller.Compiler.deployEspaceUpdateDB(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor166.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:303)
   at sun.rmi.transport.Transport$1.run(Transport.java:159)
   at java.security.AccessController.doPrivileged(Native Method)
   at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
   at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
   at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)
   at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
   at java.lang.Thread.run(Thread.java:662)
[2] java.sql.SQLIntegrityConstraintViolationException:ORA-01400: cannot insert NULL into ("OSADMIN"."OSSYS_ENTITY_RECORD"."DATA_ID")
ORA-06512: at line 1
 
   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
   at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
   at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
   at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
   at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
   at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
   at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999)
   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
   at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1822)
   at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1787)
   at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:280)
   at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:242)
   at com.sun.proxy.$Proxy1.executeUpdate(Unknown Source)
   at outsystems.hubedition.runtimeplatform.db.DbCommand.execute(Unknown Source)
   at outsystems.hubedition.runtimeplatform.DBHelper.executeNonQueryDontCleanParameters(Unknown Source)
   at outsystems.hubedition.runtimeplatform.DBHelper.$rec(Unknown Source)
   at outsystems.hubedition.runtimeplatform.DBHelper.executeNonQuery(Unknown Source)
   at outsystems.hubedition.runtimeplatform.DBHelper.executeNonQuery(Unknown Source)
   at outsystems.hubedition.deploymentcontroller.DBCompilerService.executeInlineStatementWithTimeout(Unknown Source)
   at outsystems.hubedition.deploymentcontroller.Compiler.$mfd(Unknown Source)
   at outsystems.hubedition.deploymentcontroller.Compiler.$zvc(Unknown Source)
   at outsystems.hubedition.deploymentcontroller.Compiler.$eed(Unknown Source)
   at outsystems.hubedition.deploymentcontroller.Compiler.deployEspaceUpdateDB(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor166.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:303)
   at sun.rmi.transport.Transport$1.run(Transport.java:159)
   at java.security.AccessController.doPrivileged(Native Method)
   at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
   at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
   at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)
   at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
   at java.lang.Thread.run(Thread.java:662)
Hello Rajni,

Can you let us know exactly what you are doing to get these errors? What version of the OutSystems Platform are you using? What are you trying to publish?
Hi,

The problem is that the "" is not a valid value for the Id of an entity.
In the eSpace there is a static entity with a "" value for the identifier of the "None" record. Change that to a non-empty value like "n". (Didn't look at the eSpace to actually see if the Id was being read, but since it's something that shouldn't be used directly i'll assume so)

Regards,
João Rosado
Ricardo Silva wrote:
Hello Rajni,

Can you let us know exactly what you are doing to get these errors? What version of the OutSystems Platform are you using? What are you trying to publish?
 Hi Ricardo, 

I have attached the oml file I was trying to publish (http://www.outsystems.com/forge/Component_Detail.aspx?ProjectId=196&ProjectName=high-chart-jquery-charting-component ). I am on OutSystems version 7. I dint not make any changes to given file. Let me know if you know anything helpful.

Thanks