Skip to content

Instantly share code, notes, and snippets.

@andreyvit
Created September 29, 2008 13:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save andreyvit/13602 to your computer and use it in GitHub Desktop.
Save andreyvit/13602 to your computer and use it in GitHub Desktop.
java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
java.rmi.RemoteException: unable to execute statement; nested exception is:
java.sql.SQLException: ORA-02291: Integrit?ts-Constraint (KTPS_ALLESKLAR.ASS_TARGET_ELM_ID_2_ELM_ID) verletzt - ?bergeordneter Schl?ssel nicht gefunden
ORA-06512: in "KTPS_ALLESKLAR.PCK_RELATION", Zeile 252
ORA-06512: in "KTPS_ALLESKLAR.PCK_RELATION", Zeile 343
ORA-06512: in "KTPS_ALLESKLAR.PCK_RELATION", Zeile 319
ORA-06512: in Zeile 2
at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
at sun.rmi.transport.Transport$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(Unknown Source)
at sun.rmi.transport.StreamRemoteCall.executeCall(Unknown Source)
at sun.rmi.server.UnicastRef.invoke(Unknown Source)
at org.opencube.data.rmi.data.OMSRMIDataServer_Stub.executeCall(Unknown Source)
at org.opencube.data.rmi.data.OMSRMIDataServerClient.executeCall(OMSRMIDataServerClient.java:100)
at org.opencube.data.rmi.data.OMSRMIDataServerClient.executeCall(OMSRMIDataServerClient.java:271)
at org.opencube.oms.DBHelper.executeStatement(DBHelper.java:1002)
at org.opencube.oms.DBHelper.executeOnResource(DBHelper.java:970)
at org.opencube.oms.DBHelper.appendAssociation(DBHelper.java:437)
at org.opencube.oms.DBHelper.saveAssociation(DBHelper.java:1045)
at org.opencube.oms.DBHelper.createAssociations(DBHelper.java:1703)
at org.opencube.oms.OMSData.saveOMSStructure(OMSData.java:425)
at org.opencube.oms.repository.Repository.saveChanges(Repository.java:179)
at org.opencube.oms.repository.Repository.saveAndCommitChanges(Repository.java:285)
at de.allesklar.wsimport.ImportService.commitChanges(ImportService.java:327)
at de.allesklar.wsimport.ImportService.importProducts(ImportService.java:170)
at de.allesklar.wsimport.client.SampleClient.main(SampleClient.java:219)
Caused by: java.rmi.RemoteException: unable to execute statement; nested exception is:
java.sql.SQLException: ORA-02291: Integrit?ts-Constraint (KTPS_ALLESKLAR.ASS_TARGET_ELM_ID_2_ELM_ID) verletzt - ?bergeordneter Schl?ssel nicht gefunden
ORA-06512: in "KTPS_ALLESKLAR.PCK_RELATION", Zeile 252
ORA-06512: in "KTPS_ALLESKLAR.PCK_RELATION", Zeile 343
ORA-06512: in "KTPS_ALLESKLAR.PCK_RELATION", Zeile 319
ORA-06512: in Zeile 2
at org.opencube.data.rmi.data.OMSRMIDataServer.executeCall(OMSRMIDataServer.java:230)
at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
at sun.rmi.transport.Transport$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: ORA-02291: Integrit?ts-Constraint (KTPS_ALLESKLAR.ASS_TARGET_ELM_ID_2_ELM_ID) verletzt - ?bergeordneter Schl?ssel nicht gefunden
ORA-06512: in "KTPS_ALLESKLAR.PCK_RELATION", Zeile 252
ORA-06512: in "KTPS_ALLESKLAR.PCK_RELATION", Zeile 343
ORA-06512: in "KTPS_ALLESKLAR.PCK_RELATION", Zeile 319
ORA-06512: in Zeile 2
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1094)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2132)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2015)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2877)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:608)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:684)
at org.opencube.data.Database.executeCall(Database.java:419)
at org.opencube.data.Database.executeCall(Database.java:197)
at org.opencube.data.rmi.data.OMSRMIDataServer.executeCall(OMSRMIDataServer.java:209)
... 10 more
org.opencube.data.rmi.data.OMSRMIDataServerException
at org.opencube.data.rmi.data.OMSRMIDataServerClient.buildException(OMSRMIDataServerClient.java:76)0 [main] ERROR org.opencube.oms.OMSData - Error while tree saving: Exception while appending association: id = '10.37.130.3:1c821b70:11caed492ac:-7ffa', key = 'product-{83361F45-3C7E-4F7B-92CA-8B710A9F0235}'; source element: id = '3673040,displayName='Sektkelch', bookmark = 'product-{563B229E-DB89-4E8A-848A-1C6CC9CCA8A9}', ', scheme = '/application/keytec/ktps/plugin/keytec.ktts/product/ExtendedProduct'; target element: id = '3672973,displayName='Sektk?hler', bookmark = 'product-{83361F45-3C7E-4F7B-92CA-8B710A9F0235}', ', scheme = '/application/keytec/ktps/plugin/keytec.ktts/product/ExtendedProduct'; attribute: id = '5001', type = 'a', name = '/application/keytec/ktps/plugin/keytec.ktts/product/Product.relatedProducts' : Exception thrown while executing statement: 'begin
:out_int_id := pck_relation.appendAssociation
(
:in_int_source_id,
:in_int_cat_id,
:in_int_target_id,
:in_string_key,
:in_int_creater_id
);
end;': null
java.lang.Exception: Exception while appending association: id = '10.37.130.3:1c821b70:11caed492ac:-7ffa', key = 'product-{83361F45-3C7E-4F7B-92CA-8B710A9F0235}'; source element: id = '3673040,displayName='Sektkelch', bookmark = 'product-{563B229E-DB89-4E8A-848A-1C6CC9CCA8A9}', ', scheme = '/application/keytec/ktps/plugin/keytec.ktts/product/ExtendedProduct'; target element: id = '3672973,displayName='Sektk?hler', bookmark = 'product-{83361F45-3C7E-4F7B-92CA-8B710A9F0235}', ', scheme = '/application/keytec/ktps/plugin/keytec.ktts/product/ExtendedProduct'; attribute: id = '5001', type = 'a', name = '/application/keytec/ktps/plugin/keytec.ktts/product/Product.relatedProducts' : Exception thrown while executing statement: 'begin
:out_int_id := pck_relation.appendAssociation
(
:in_int_source_id,
:in_int_cat_id,
:in_int_target_id,
:in_string_key,
:in_int_creater_id
);
end;': null
at org.opencube.oms.DBHelper.appendAssociation(DBHelper.java:443)
at org.opencube.oms.DBHelper.saveAssociation(DBHelper.java:1045)
at org.opencube.oms.DBHelper.createAssociations(DBHelper.java:1703)
at org.opencube.oms.OMSData.saveOMSStructure(OMSData.java:425)
at org.opencube.oms.repository.Repository.saveChanges(Repository.java:179)
at org.opencube.oms.repository.Repository.saveAndCommitChanges(Repository.java:285)
at de.allesklar.wsimport.ImportService.commitChanges(ImportService.java:327)
at de.allesklar.wsimport.ImportService.importProducts(ImportService.java:170)
at de.allesklar.wsimport.client.SampleClient.main(SampleClient.java:219)
Caused by: java.lang.Exception: Exception thrown while executing statement: 'begin
:out_int_id := pck_relation.appendAssociation
(
:in_int_source_id,
:in_int_cat_id,
:in_int_target_id,
:in_string_key,
:in_int_creater_id
);
end;': null
at org.opencube.oms.DBHelper.executeStatement(DBHelper.java:1009)
at org.opencube.oms.DBHelper.executeOnResource(DBHelper.java:970)
at org.opencube.oms.DBHelper.appendAssociation(DBHelper.java:437)
... 8 more
Caused by: org.opencube.data.rmi.data.OMSRMIDataServerException
at org.opencube.data.rmi.data.OMSRMIDataServerClient.buildException(OMSRMIDataServerClient.java:76)
at org.opencube.data.rmi.data.OMSRMIDataServerClient.executeCall(OMSRMIDataServerClient.java:120)
at org.opencube.data.rmi.data.OMSRMIDataServerClient.executeCall(OMSRMIDataServerClient.java:271)
at org.opencube.oms.DBHelper.executeStatement(DBHelper.java:1002)
... 10 more
at org.opencube.data.rmi.data.OMSRMIDataServerClient.executeCall(OMSRMIDataServerClient.java:120)
at org.opencube.data.rmi.data.OMSRMIDataServerClient.executeCall(OMSRMIDataServerClient.java:271)
at org.opencube.oms.DBHelper.executeStatement(DBHelper.java:1002)
at org.opencube.oms.DBHelper.executeOnResource(DBHelper.java:970)
at org.opencube.oms.DBHelper.appendAssociation(DBHelper.java:437)
at org.opencube.oms.DBHelper.saveAssociation(DBHelper.java:1045)
at org.opencube.oms.DBHelper.createAssociations(DBHelper.java:1703)
at org.opencube.oms.OMSData.saveOMSStructure(OMSData.java:425)
at org.opencube.oms.repository.Repository.saveChanges(Repository.java:179)
at org.opencube.oms.repository.Repository.saveAndCommitChanges(Repository.java:285)
at de.allesklar.wsimport.ImportService.commitChanges(ImportService.java:327)
at de.allesklar.wsimport.ImportService.importProducts(ImportService.java:170)
at de.allesklar.wsimport.client.SampleClient.main(SampleClient.java:219)
de.allesklar.wsimport.ImportFailedException: Error working with repository: java.lang.Exception: Exception while appending association: id = '10.37.130.3:1c821b70:11caed492ac:-7ffa', key = 'product-{83361F45-3C7E-4F7B-92CA-8B710A9F0235}'; source element: id = '3673040,displayName='Sektkelch', bookmark = 'product-{563B229E-DB89-4E8A-848A-1C6CC9CCA8A9}', ', scheme = '/application/keytec/ktps/plugin/keytec.ktts/product/ExtendedProduct'; target element: id = '3672973,displayName='Sektk?hler', bookmark = 'product-{83361F45-3C7E-4F7B-92CA-8B710A9F0235}', ', scheme = '/application/keytec/ktps/plugin/keytec.ktts/product/ExtendedProduct'; attribute: id = '5001', type = 'a', name = '/application/keytec/ktps/plugin/keytec.ktts/product/Product.relatedProducts' : Exception thrown while executing statement: 'begin
:out_int_id := pck_relation.appendAssociation
(
:in_int_source_id,
:in_int_cat_id,
:in_int_target_id,
:in_string_key,
:in_int_creater_id
);
end;': null
at de.allesklar.wsimport.ImportService.translateException(ImportService.java:255)
at de.allesklar.wsimport.ImportService.importProducts(ImportService.java:180)
at de.allesklar.wsimport.client.SampleClient.main(SampleClient.java:219)
Caused by: org.opencube.oms.repository.RepositoryRequestFailed: java.lang.Exception: Exception while appending association: id = '10.37.130.3:1c821b70:11caed492ac:-7ffa', key = 'product-{83361F45-3C7E-4F7B-92CA-8B710A9F0235}'; source element: id = '3673040,displayName='Sektkelch', bookmark = 'product-{563B229E-DB89-4E8A-848A-1C6CC9CCA8A9}', ', scheme = '/application/keytec/ktps/plugin/keytec.ktts/product/ExtendedProduct'; target element: id = '3672973,displayName='Sektk?hler', bookmark = 'product-{83361F45-3C7E-4F7B-92CA-8B710A9F0235}', ', scheme = '/application/keytec/ktps/plugin/keytec.ktts/product/ExtendedProduct'; attribute: id = '5001', type = 'a', name = '/application/keytec/ktps/plugin/keytec.ktts/product/Product.relatedProducts' : Exception thrown while executing statement: 'begin
:out_int_id := pck_relation.appendAssociation
(
:in_int_source_id,
:in_int_cat_id,
:in_int_target_id,
:in_string_key,
:in_int_creater_id
);
end;': null
at org.opencube.oms.repository.Repository.saveChanges(Repository.java:181)
at org.opencube.oms.repository.Repository.saveAndCommitChanges(Repository.java:285)
at de.allesklar.wsimport.ImportService.commitChanges(ImportService.java:327)
at de.allesklar.wsimport.ImportService.importProducts(ImportService.java:170)
... 1 more
Caused by: java.lang.Exception: Exception while appending association: id = '10.37.130.3:1c821b70:11caed492ac:-7ffa', key = 'product-{83361F45-3C7E-4F7B-92CA-8B710A9F0235}'; source element: id = '3673040,displayName='Sektkelch', bookmark = 'product-{563B229E-DB89-4E8A-848A-1C6CC9CCA8A9}', ', scheme = '/application/keytec/ktps/plugin/keytec.ktts/product/ExtendedProduct'; target element: id = '3672973,displayName='Sektk?hler', bookmark = 'product-{83361F45-3C7E-4F7B-92CA-8B710A9F0235}', ', scheme = '/application/keytec/ktps/plugin/keytec.ktts/product/ExtendedProduct'; attribute: id = '5001', type = 'a', name = '/application/keytec/ktps/plugin/keytec.ktts/product/Product.relatedProducts' : Exception thrown while executing statement: 'begin
:out_int_id := pck_relation.appendAssociation
(
:in_int_source_id,
:in_int_cat_id,
:in_int_target_id,
:in_string_key,
:in_int_creater_id
);
end;': null
at org.opencube.oms.DBHelper.appendAssociation(DBHelper.java:443)
at org.opencube.oms.DBHelper.saveAssociation(DBHelper.java:1045)
at org.opencube.oms.DBHelper.createAssociations(DBHelper.java:1703)
at org.opencube.oms.OMSData.saveOMSStructure(OMSData.java:425)
at org.opencube.oms.repository.Repository.saveChanges(Repository.java:179)
... 4 more
Caused by: java.lang.Exception: Exception thrown while executing statement: 'begin
:out_int_id := pck_relation.appendAssociation
(
:in_int_source_id,
:in_int_cat_id,
:in_int_target_id,
:in_string_key,
:in_int_creater_id
);
end;': null
at org.opencube.oms.DBHelper.executeStatement(DBHelper.java:1009)
at org.opencube.oms.DBHelper.executeOnResource(DBHelper.java:970)
at org.opencube.oms.DBHelper.appendAssociation(DBHelper.java:437)
... 8 more
Caused by: org.opencube.data.rmi.data.OMSRMIDataServerException
at org.opencube.data.rmi.data.OMSRMIDataServerClient.buildException(OMSRMIDataServerClient.java:76)
at org.opencube.data.rmi.data.OMSRMIDataServerClient.executeCall(OMSRMIDataServerClient.java:120)
at org.opencube.data.rmi.data.OMSRMIDataServerClient.executeCall(OMSRMIDataServerClient.java:271)
at org.opencube.oms.DBHelper.executeStatement(DBHelper.java:1002)
... 10 more
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment