# 21:12:52.671 PackIn.startElement: reference Button [15] # 21:12:52.671 PackIn.startElement: column Processed [15] # 21:12:52.750 PackIn.createcolumn: ALTER TABLE A_Depreciation ADD Processed CHAR( # 1) DEFAULT Y NOT NULL [15] # ===========> DB.executeUpdate: ALTER TABLE A_Depreciation ADD Processed CHAR(1) # DEFAULT Y NOT NULL [SvrProcess_da59cbd6-1201-48e4-b5dd-d24b4dcb2b22] [15] # java.sql.SQLException: ORA-00984: column not allowed here # ; State=42000; ErrorCode=984 # at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java # :125) # at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) # at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) # at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623) # at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement. # java:181) # at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedS # tatement.java:543) # at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme # nt.java:1028) # at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatem # ent.java:3753) # at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate # (OraclePreparedStatement.java:8829) # at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep # aredStatement.java:2886) # at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar # edStatement.java:2960) # at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement # .java:190) # at org.compiere.util.DB.executeUpdate(DB.java:969) # at org.compiere.util.DB.executeUpdate(DB.java:902) # at org.adempiere.pipo.PackInHandler.createcolumn(PackInHandler.java:3642 # ) # at org.adempiere.pipo.PackInHandler.startElement(PackInHandler.java:1335 # ) # at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Sour # ce) # at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unkn # own Source) # at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElemen # t(Unknown Source) # at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContent # Dispatcher.dispatch(Unknown Source) # at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Un # known Source) # # ===========> DB.saveError: DBExecuteError - ORA-00984: column not allowed here # [15] # 21:12:53.140 PackIn.startElement: reference Memo [15] # 21:12:53.156 PackIn.startElement: column Text [15] # 21:12:53.265 PackIn.createcolumn: ALTER TABLE A_Depreciation ADD Text NVARCHAR2( # 2000) [15] # 21:15:43.890 PackIn.startElement: column A_Asset_Acct_ID [15] # 21:15:44.015 PackIn.createcolumn: ALTER TABLE A_Asset_Acct ADD A_Asset_Acct_ID N # UMBER(10) NOT NULL; ALTER TABLE A_Asset_Acct ADD CONSTRAINT A_Asset_Acct_Key PRI # MARY KEY (A_Asset_Acct_ID) [15] # ===========> DB.executeUpdate: ALTER TABLE A_Asset_Acct ADD CONSTRAINT A_Asset_A # cct_Key PRIMARY KEY (A_Asset_Acct_ID) [SvrProcess_da59cbd6-1201-48e4-b5dd-d24b4d # cb2b22] [15] # java.sql.SQLException: ORA-02260: table can have only one primary key # ; State=42000; ErrorCode=2260 # at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java # :125) # at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) # at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) # at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623) # at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement. # java:181) # at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedS # tatement.java:543) # at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme # nt.java:1028) # at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatem # ent.java:3753) # at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate # (OraclePreparedStatement.java:8829) # at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep # aredStatement.java:2886) # at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar # edStatement.java:2960) # at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement # .java:190) # at org.compiere.util.DB.executeUpdate(DB.java:969) # at org.compiere.util.DB.executeUpdate(DB.java:902) # at org.adempiere.pipo.PackInHandler.createcolumn(PackInHandler.java:3649 # ) # at org.adempiere.pipo.PackInHandler.startElement(PackInHandler.java:1335 # ) # at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Sour # ce) # at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unkn # own Source) # at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElemen # t(Unknown Source) # at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContent # Dispatcher.dispatch(Unknown Source) # at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Un # known Source) # # ===========> DB.saveError: DBExecuteError - ORA-02260: table can have only one p # rimary key # [15] # 21:15:44.312 PackIn.startElement: reference Table Direct [15] # 21:15:44.312 PackIn.startElement: reference AD_Client [15] # 21:15:44.312 PackIn.startElement: referencetable [15] # 21:15:44.312 PackIn.startElement: column AD_Client_ID [15] # 21:15:44.406 PackIn.createcolumn: ALTER TABLE A_Asset_Acct MODIFY AD_Client_ID N # UMBER(10) DEFAULT NULL [15] # 21:17:49.218 PackIn.startElement: column Processed [15] # 21:17:49.296 PackIn.createcolumn: ALTER TABLE A_Depreciation_Method ADD Processe # d CHAR(1) DEFAULT Y NOT NULL [15] # ===========> DB.executeUpdate: ALTER TABLE A_Depreciation_Method ADD Processed C # HAR(1) DEFAULT Y NOT NULL [SvrProcess_da59cbd6-1201-48e4-b5dd-d24b4dcb2b22] [15] # # java.sql.SQLException: ORA-00984: column not allowed here # ; State=42000; ErrorCode=984 # at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java # :125) # at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) # at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) # at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623) # at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement. # java:181) # at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedS # tatement.java:543) # at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme # nt.java:1028) # at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatem # ent.java:3753) # at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate # (OraclePreparedStatement.java:8829) # at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep # aredStatement.java:2886) # at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar # edStatement.java:2960) # at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement # .java:190) # at org.compiere.util.DB.executeUpdate(DB.java:969) # at org.compiere.util.DB.executeUpdate(DB.java:902) # at org.adempiere.pipo.PackInHandler.createcolumn(PackInHandler.java:3642 # ) # at org.adempiere.pipo.PackInHandler.startElement(PackInHandler.java:1335 # ) # at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Sour # ce) # at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unkn # own Source) # at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElemen # t(Unknown Source) # at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContent # Dispatcher.dispatch(Unknown Source) # at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Un # known Source) # # ===========> DB.saveError: DBExecuteError - ORA-00984: column not allowed here # [15] # 21:17:49.484 PackIn.startElement: reference Date+Time [15] # 21:17:49.484 PackIn.startElement: column Updated [15] # 21:17:49.593 PackIn.createcolumn: ALTER TABLE A_Depreciation_Method ADD Updated # DATE NOT NULL [15] # 21:17:49.671 PackIn.startElement: reference Table [15] # 21:17:49.671 PackIn.startElement: reference AD_User [15] # 21:17:49.671 PackIn.startElement: referencetable [15] # 21:17:49.671 PackIn.startElement: column UpdatedBy [15] # 21:17:49.218 PackIn.startElement: column Processed [15] # 21:17:49.296 PackIn.createcolumn: ALTER TABLE A_Depreciation_Method ADD Processe # d CHAR(1) DEFAULT Y NOT NULL [15] # ===========> DB.executeUpdate: ALTER TABLE A_Depreciation_Method ADD Processed C # HAR(1) DEFAULT Y NOT NULL [SvrProcess_da59cbd6-1201-48e4-b5dd-d24b4dcb2b22] [15] # # java.sql.SQLException: ORA-00984: column not allowed here # ; State=42000; ErrorCode=984 # at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java # :125) # at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) # at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) # at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623) # at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement. # java:181) # at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedS # tatement.java:543) # at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme # nt.java:1028) # at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatem # ent.java:3753) # at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate # (OraclePreparedStatement.java:8829) # at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep # aredStatement.java:2886) # at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar # edStatement.java:2960) # at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement # .java:190) # at org.compiere.util.DB.executeUpdate(DB.java:969) # at org.compiere.util.DB.executeUpdate(DB.java:902) # at org.adempiere.pipo.PackInHandler.createcolumn(PackInHandler.java:3642 # ) # at org.adempiere.pipo.PackInHandler.startElement(PackInHandler.java:1335 # ) # at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Sour # ce) # at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unkn # own Source) # at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElemen # t(Unknown Source) # at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContent # Dispatcher.dispatch(Unknown Source) # at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Un # known Source) # # ===========> DB.saveError: DBExecuteError - ORA-00984: column not allowed here # [15] # 21:17:49.484 PackIn.startElement: reference Date+Time [15] # 21:17:49.484 PackIn.startElement: column Updated [15] # 21:17:49.593 PackIn.createcolumn: ALTER TABLE A_Depreciation_Method ADD Updated # DATE NOT NULL [15] # 21:17:49.671 PackIn.startElement: reference Table [15] # 21:17:49.671 PackIn.startElement: reference AD_User [15] # 21:17:49.671 PackIn.startElement: referencetable [15] # 21:17:49.671 PackIn.startElement: column UpdatedBy [15] # 21:21:14.968 PackIn.startElement: reference Table Direct [15] # 21:21:14.968 PackIn.startElement: processpara Organization [15] # 21:21:16.046 PackIn.startElement: role FA User [15] # 21:21:16.859 PackIn.startElement: userrole [15] # ===========> DB.executeUpdate: Insert INTO AD_User_Roles(AD_Client_ID, CreatedB # y, UpdatedBy, AD_User_ID, AD_Role_ID, AD_Org_ID, isActive) VALUES( 0, 100, 100, # 100, 1000000, 11, 'Y') [SvrProcess_da59cbd6-1201-48e4-b5dd-d24b4dcb2b22] [15] # java.sql.SQLException: ORA-00001: unique constraint (ADEMPIERE_CUST.AD_USER_ROLE # _KEY) violated # ; State=23000; ErrorCode=1 # at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java # :125) # at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) # at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) # at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623) # at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement. # java:181) # at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedS # tatement.java:543) # at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme # nt.java:1028) # at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatem # ent.java:3753) # at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate # (OraclePreparedStatement.java:8829) # at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep # aredStatement.java:2886) # at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar # edStatement.java:2960) # at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement # .java:190) # at org.compiere.util.DB.executeUpdate(DB.java:969) # at org.compiere.util.DB.executeUpdate(DB.java:876) # at org.adempiere.pipo.PackInHandler.startElement(PackInHandler.java:1473 # ) # at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Sour # ce) # at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unkn # own Source) # at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElemen # t(Unknown Source) # at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContent # Dispatcher.dispatch(Unknown Source) # at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Un # known Source) # at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) # # ===========> DB.saveError: DBExecuteError - ORA-00001: unique constraint (ADEMPI # ERE_CUST.AD_USER_ROLE_KEY) violated # [15] # 21:21:19.390 PackIn.startElement: Insert to user roles failed [15] # 21:21:19.390 PackIn.startElement: userrole [15] # 21:21:24.484 CacheMgt.reset: AD_Column: #1 (0) [15] # 21:21:24.515 PackIn.createcolumn: ALTER TABLE GL_JournalLine MODIFY Description # NVARCHAR2(255) DEFAULT NULL ; ALTER TABLE GL_JournalLine MODIFY Description NOT # NULL [15] # ===========> DB.executeUpdate: ALTER TABLE GL_JournalLine MODIFY Description NOT # NULL [SvrProcess_da59cbd6-1201-48e4-b5dd-d24b4dcb2b22] [15] # java.sql.SQLException: ORA-02296: cannot enable (ADEMPIERE_CUST.) - null values # found # ; State=23000; ErrorCode=2296 # at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java # :125) # at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) # at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) # at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623) # at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement. # java:181) # at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedS # tatement.java:543) # at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme # nt.java:1028) # at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatem # ent.java:3753) # at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate # (OraclePreparedStatement.java:8829) # at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep # aredStatement.java:2886) # at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar # edStatement.java:2960) # at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement # .java:190) # at org.compiere.util.DB.executeUpdate(DB.java:969) # at org.compiere.util.DB.executeUpdate(DB.java:902) # at org.adempiere.pipo.PackInHandler.createcolumn(PackInHandler.java:3649 # ) # at org.adempiere.pipo.PackInHandler.startElement(PackInHandler.java:1335 # ) # at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Sour # ce) # at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unkn # own Source) # at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElemen # t(Unknown Source) # at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContent # Dispatcher.dispatch(Unknown Source) # at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Un # known Source) # # ===========> DB.saveError: DBExecuteError - ORA-02296: cannot enable (ADEMPIERE_ # CUST.) - null values found # [15] # 21:21:24.718 PackIn.startElement: reference Date [15] # 21:21:24.718 PackIn.startElement: column DateAcct [15] # 21:21:47.031 PackIn.startElement: codesnipit [15] # ===========> PackIn.importXML: importXML: [15] # java.lang.NullPointerException # at org.adempiere.pipo.PackInHandler.startElement(PackInHandler.java:1996 # ) # at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Sour # ce) # at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unkn # own Source) # at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElemen # t(Unknown Source) # at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContent # Dispatcher.dispatch(Unknown Source) # at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Un # known Source) # at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) # at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) # at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) # at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) # at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Sour # ce) # at javax.xml.parsers.SAXParser.parse(SAXParser.java:375) # at javax.xml.parsers.SAXParser.parse(SAXParser.java:311) # at org.adempiere.pipo.PackIn.importXML(PackIn.java:83) # at org.adempiere.pipo.PackIn.doIt(PackIn.java:144) # at org.compiere.process.SvrProcess.process(SvrProcess.java:133) # at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:91) # at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:556) # at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:322) # # 21:21:47.281 Trx.commit: **** SvrProcess_da59cbd6-1201-48e4-b5dd-d24b4dcb2b22 [1 # 5] # 21:21:47.375 CacheMgt.reset: AD_Process: #1 (1) [15] # 21:21:47.406 GridTable.dataRefresh: Row=0 [11] # 21:21:47.421 APanel.dataStatusChanged: 1/1 [11] # 21:21:47.437 APanel.dataStatusChanged: 1/1 [11]