rendered paste body#
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]