St simulando un flusso Richiesta d'offerta -> Ordine d'Acquisto -> Entrata Merci -> Ricezione Fattura -> Pagamento Fattura e fino all'ordine d'acquisto tutto andato bene, ma quando provo a fare l'entrata merci di ordine d'acquisto ecco quello che succede:
#################################
Lato server
##################################
19:06:54,362 INFO [ServerBean] workflow[4] 117
19:06:54,405 WARN [MWFProcess] saveUpdate - No Session found
19:06:54,470 INFO [MWFActivity] run - MWFNode[187-(Start),Action=Sleep:WaitTime=0]
19:06:54,471 WARN [MWFActivity] saveUpdate - No Session found
19:06:54,478 WARN [MWFEventAudit] saveUpdate - No Session found
19:06:54,486 INFO [MWFProcess] checkActivities (117) - OR
19:06:54,490 INFO [MWFActivity] performWork - MWFNode[187-(Start),Action=Sleep:WaitTime=0] [WF_1111082814490]
19:06:54,491 WARN [MWFActivity] saveUpdate - No Session found
19:06:54,498 WARN [MWFEventAudit] saveUpdate - No Session found
19:06:54,510 INFO [MWFProcess] checkActivities (117) - OR
19:06:54,514 WARN [MWFActivity] saveUpdate - No Session found
19:06:54,574 INFO [MWFActivity] run - MWFNode[189-(DocPrepare),Action=DocumentAction=PR]
19:06:54,575 WARN [MWFActivity] saveUpdate - No Session found
19:06:54,582 WARN [MWFEventAudit] saveUpdate - No Session found
19:06:54,590 INFO [MWFProcess] checkActivities (117) - OR
19:06:54,594 INFO [MWFActivity] performWork - MWFNode[189-(DocPrepare),Action=DocumentAction=PR] [WF_1111082814594]
19:06:54,599 INFO [MInOut] **** Action=PR (Prc=PR/Doc=CO) MInOut[1000003-1000003,DocStatus=IP]
19:06:54,600 INFO [MInOut] prepareIt - MInOut[1000003-1000003,DocStatus=IP]
19:06:54,640 INFO [Trx] start **** WF_1111082814594
19:06:54,646 WARN [MInOut] saveUpdate - No Session found
19:06:54,652 WARN [MWFActivity] saveUpdate - No Session found
19:06:54,662 WARN [MWFEventAudit] saveUpdate - No Session found
19:06:54,670 INFO [MWFProcess] checkActivities (117) - OR
19:06:54,675 WARN [MWFActivity] saveUpdate - No Session found
19:06:54,746 INFO [MWFActivity] run - MWFNode[190-(DocComplete),Action=DocumentAction=CO]
19:06:54,747 WARN [MWFActivity] saveUpdate - No Session found
19:06:54,750 INFO [Trx] commit **** WF_1111082814594
19:06:54,759 WARN [MWFEventAudit] saveUpdate - No Session found
19:06:54,766 INFO [MWFProcess] checkActivities (117) - OR
19:06:54,770 INFO [MWFActivity] performWork - MWFNode[190-(DocComplete),Action=DocumentAction=CO] [WF_1111082814770]
19:06:54,775 INFO [MInOut] **** Action=CO (Prc=CO/Doc=CO) MInOut[1000003-1000003,DocStatus=IP]
19:06:54,776 INFO [MInOut] prepareIt - MInOut[1000003-1000003,DocStatus=IP]
19:06:54,816 INFO [Trx] start **** WF_1111082814770
19:06:54,826 INFO [MInOut] approveIt - MInOut[1000003-1000003,DocStatus=IP]
19:06:54,827 INFO [MInOut] completeIt - MInOut[1000003-1000003,DocStatus=IP]
19:06:54,831 INFO [MInOut] completeIt - Line=10 - Qty=1
19:06:54,836 WARN [MStorage] saveUpdate - No Session found
19:06:54,857 ERROR [DB] executeUpdate - INSERT INTO M_Transaction (AD_Client_ID,AD_Org_ID,Created,CreatedBy,IsActive,M_AttributeSetInstance_ID,M_InOutLine_ID,M_Locator_ID,M_Product_ID,M_Transaction_ID,MovementDate,MovementQty,MovementType,Updated,UpdatedBy) VALUES (1000000,1000000,TO_DATE('2005-03-17 19:06:54','YYYY-MM-DD HH24:MI:SS'),1000000,'Y',0,1000004,1000000,1000002,1000000,TO_DATE('2005-03-17','YYYY-MM-DD'),1,'V+',TO_DATE('2005-03-17 19:06:54','YYYY-MM-DD HH24:MI:SS'),1000000) [WF_1111082814770]
java.sql.SQLException: ORA-00001: unique constraint (COMPIERE.M_TRANSACTION_KEY) violated
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(T4CPreparedStatement.java:543)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:3753)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:8829)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2886)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2960)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:159)
at org.compiere.util.DB.executeUpdate(DB.java:1288)
at org.compiere.util.DB.executeUpdate(DB.java:1254)
at org.compiere.model.PO.saveNew(PO.java:1822)
at org.compiere.model.PO.save(PO.java:1423)
at org.compiere.model.PO.save(PO.java:1471)
at org.compiere.model.MInOut.completeIt(MInOut.java:1042)
at org.compiere.process.DocumentEngine.completeIt(DocumentEngine.java:385)
at org.compiere.process.DocumentEngine.processIt(DocumentEngine.java:240)
at org.compiere.process.DocumentEngine.processIt(DocumentEngine.java:205)
at org.compiere.model.MInOut.processIt(MInOut.java:811)
at org.compiere.wf.MWFActivity.performWork(MWFActivity.java:718)
at org.compiere.wf.MWFActivity.run(MWFActivity.java:653)
at java.lang.Thread.run(Thread.java:534)
19:06:54,860 ERROR [Log] DBExecuteError - ORA-00001: unique constraint (COMPIERE.M_TRANSACTION_KEY) violated
19:06:54,861 ERROR [MTransaction] PO.saveNew [WF_1111082814770] - Not inserted - INSERT INTO M_Transaction (AD_Client_ID,AD_Org_ID,Created,CreatedBy,IsActive,M_AttributeSetInstance_ID,M_InOutLine_ID,M_Locator_ID,M_Product_ID,M_Transaction_ID,MovementDate,MovementQty,MovementType,Updated,UpdatedBy) VALUES (1000000,1000000,TO_DATE('2005-03-17 19:06:54','YYYY-MM-DD HH24:MI:SS'),1000000,'Y',0,1000004,1000000,1000002,1000000,TO_DATE('2005-03-17','YYYY-MM-DD'),1,'V+',TO_DATE('2005-03-17 19:06:54','YYYY-MM-DD HH24:MI:SS'),1000000)
19:06:54,862 WARN [MInOut] saveUpdate - No Session found
19:06:54,867 INFO [Trx] rollback **** WF_1111082814770
19:06:54,874 ERROR [MWFActivity] run
java.lang.Exception: Could not create Material Transaction
at org.compiere.wf.MWFActivity.performWork(MWFActivity.java:739)
at org.compiere.wf.MWFActivity.run(MWFActivity.java:653)
at java.lang.Thread.run(Thread.java:534)
19:06:54,876 WARN [MWFActivity] saveUpdate - No Session found
19:06:54,886 WARN [MWFEventAudit] saveUpdate - No Session found
19:06:54,898 INFO [MWFProcess] checkActivities (117) - OR
19:06:54,902 WARN [MWFActivity] saveUpdate - No Session found
19:06:54,911 WARN [MWFProcess] saveUpdate - No Session found
Sapete darmi una mano ???
Grazie in anticipo.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Probabilmente si verificato un disallineamento fra l' ID della tabella M_Transaction e quello di riferimento della tabella AD_Sequence. Per risolvere il problema prova a far partire il processo Sequence Check come System Administrator.
A presto
-----------------------
Roberto Onnis
ComplIT Project Administrator
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
St simulando un flusso Richiesta d'offerta -> Ordine d'Acquisto -> Entrata Merci -> Ricezione Fattura -> Pagamento Fattura e fino all'ordine d'acquisto tutto andato bene, ma quando provo a fare l'entrata merci di ordine d'acquisto ecco quello che succede:
#################################
Lato client
##################################
19:07:11.551 MTable: needSave - Row=-2, Changed=-1/false
19:07:13.217 MTab: setValue - DocAction=CO for row=0
19:07:13.217 MTable: dataSave - Row=0, Changed=-1/false
19:07:13.299 MTable: needSave - Row=-2, Changed=-1/false
19:07:13.299 ProcessCtl: process - WindowNo=3 - ProcessInfo[Lo stato obbiettivo del documento,Process_ID=109,Record_ID=1000003,Error=false,Summary=,Log=0]
19:07:13.356 MPInstance: saveNew - AD_PInstance - AD_PInstance_ID=1000042
19:07:13.391 MPInstance: getAD_InstanceID = 1000042
19:07:13.452 ProcessCtl: run - AD_PInstance_ID=1000042, Record_ID=1000003
19:07:13.542 ProcessCtl: lock
19:07:13.575 ProcessCtl: startWorkflow - 117 - ProcessInfo[Elaborare Spedizioni ,Process_ID=109,AD_PInstance_ID=1000042,Record_ID=1000003,Error=false,Summary=,Log=0]
19:07:14.765 ProcessCtl: unlock -
19:07:14.796 MTab: dataRefresh #0 - row=0
19:07:14.796 MTable: dataRefresh 0
19:07:14.796 MTable: dataIgnore - Inserting=false
19:07:14.797 MTable: dataIgnore - Nothing to ignore
19:07:14.838 MTab: dataStatusChanged #0 - DataStatusEvent - Refreshed : 0/4
19:07:14.839 MTab: fireDataStatusChanged - DataStatusEvent - Refreshed : 1/4
19:07:15.187 MTab: setCurrentRow = 0 - fire=true
19:07:15.196 MTab: fireDataStatusChanged - DataStatusEvent - Refreshed : 1/4
#################################
Lato server
##################################
19:06:54,362 INFO [ServerBean] workflow[4] 117
19:06:54,405 WARN [MWFProcess] saveUpdate - No Session found
19:06:54,470 INFO [MWFActivity] run - MWFNode[187-(Start),Action=Sleep:WaitTime=0]
19:06:54,471 WARN [MWFActivity] saveUpdate - No Session found
19:06:54,478 WARN [MWFEventAudit] saveUpdate - No Session found
19:06:54,486 INFO [MWFProcess] checkActivities (117) - OR
19:06:54,490 INFO [MWFActivity] performWork - MWFNode[187-(Start),Action=Sleep:WaitTime=0] [WF_1111082814490]
19:06:54,491 WARN [MWFActivity] saveUpdate - No Session found
19:06:54,498 WARN [MWFEventAudit] saveUpdate - No Session found
19:06:54,510 INFO [MWFProcess] checkActivities (117) - OR
19:06:54,514 WARN [MWFActivity] saveUpdate - No Session found
19:06:54,574 INFO [MWFActivity] run - MWFNode[189-(DocPrepare),Action=DocumentAction=PR]
19:06:54,575 WARN [MWFActivity] saveUpdate - No Session found
19:06:54,582 WARN [MWFEventAudit] saveUpdate - No Session found
19:06:54,590 INFO [MWFProcess] checkActivities (117) - OR
19:06:54,594 INFO [MWFActivity] performWork - MWFNode[189-(DocPrepare),Action=DocumentAction=PR] [WF_1111082814594]
19:06:54,599 INFO [MInOut] **** Action=PR (Prc=PR/Doc=CO) MInOut[1000003-1000003,DocStatus=IP]
19:06:54,600 INFO [MInOut] prepareIt - MInOut[1000003-1000003,DocStatus=IP]
19:06:54,640 INFO [Trx] start **** WF_1111082814594
19:06:54,646 WARN [MInOut] saveUpdate - No Session found
19:06:54,652 WARN [MWFActivity] saveUpdate - No Session found
19:06:54,662 WARN [MWFEventAudit] saveUpdate - No Session found
19:06:54,670 INFO [MWFProcess] checkActivities (117) - OR
19:06:54,675 WARN [MWFActivity] saveUpdate - No Session found
19:06:54,746 INFO [MWFActivity] run - MWFNode[190-(DocComplete),Action=DocumentAction=CO]
19:06:54,747 WARN [MWFActivity] saveUpdate - No Session found
19:06:54,750 INFO [Trx] commit **** WF_1111082814594
19:06:54,759 WARN [MWFEventAudit] saveUpdate - No Session found
19:06:54,766 INFO [MWFProcess] checkActivities (117) - OR
19:06:54,770 INFO [MWFActivity] performWork - MWFNode[190-(DocComplete),Action=DocumentAction=CO] [WF_1111082814770]
19:06:54,775 INFO [MInOut] **** Action=CO (Prc=CO/Doc=CO) MInOut[1000003-1000003,DocStatus=IP]
19:06:54,776 INFO [MInOut] prepareIt - MInOut[1000003-1000003,DocStatus=IP]
19:06:54,816 INFO [Trx] start **** WF_1111082814770
19:06:54,826 INFO [MInOut] approveIt - MInOut[1000003-1000003,DocStatus=IP]
19:06:54,827 INFO [MInOut] completeIt - MInOut[1000003-1000003,DocStatus=IP]
19:06:54,831 INFO [MInOut] completeIt - Line=10 - Qty=1
19:06:54,836 WARN [MStorage] saveUpdate - No Session found
19:06:54,857 ERROR [DB] executeUpdate - INSERT INTO M_Transaction (AD_Client_ID,AD_Org_ID,Created,CreatedBy,IsActive,M_AttributeSetInstance_ID,M_InOutLine_ID,M_Locator_ID,M_Product_ID,M_Transaction_ID,MovementDate,MovementQty,MovementType,Updated,UpdatedBy) VALUES (1000000,1000000,TO_DATE('2005-03-17 19:06:54','YYYY-MM-DD HH24:MI:SS'),1000000,'Y',0,1000004,1000000,1000002,1000000,TO_DATE('2005-03-17','YYYY-MM-DD'),1,'V+',TO_DATE('2005-03-17 19:06:54','YYYY-MM-DD HH24:MI:SS'),1000000) [WF_1111082814770]
java.sql.SQLException: ORA-00001: unique constraint (COMPIERE.M_TRANSACTION_KEY) violated
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(T4CPreparedStatement.java:543)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:3753)
at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:8829)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2886)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2960)
at org.compiere.util.CPreparedStatement.executeUpdate(CPreparedStatement.java:159)
at org.compiere.util.DB.executeUpdate(DB.java:1288)
at org.compiere.util.DB.executeUpdate(DB.java:1254)
at org.compiere.model.PO.saveNew(PO.java:1822)
at org.compiere.model.PO.save(PO.java:1423)
at org.compiere.model.PO.save(PO.java:1471)
at org.compiere.model.MInOut.completeIt(MInOut.java:1042)
at org.compiere.process.DocumentEngine.completeIt(DocumentEngine.java:385)
at org.compiere.process.DocumentEngine.processIt(DocumentEngine.java:240)
at org.compiere.process.DocumentEngine.processIt(DocumentEngine.java:205)
at org.compiere.model.MInOut.processIt(MInOut.java:811)
at org.compiere.wf.MWFActivity.performWork(MWFActivity.java:718)
at org.compiere.wf.MWFActivity.run(MWFActivity.java:653)
at java.lang.Thread.run(Thread.java:534)
19:06:54,860 ERROR [Log] DBExecuteError - ORA-00001: unique constraint (COMPIERE.M_TRANSACTION_KEY) violated
19:06:54,861 ERROR [MTransaction] PO.saveNew [WF_1111082814770] - Not inserted - INSERT INTO M_Transaction (AD_Client_ID,AD_Org_ID,Created,CreatedBy,IsActive,M_AttributeSetInstance_ID,M_InOutLine_ID,M_Locator_ID,M_Product_ID,M_Transaction_ID,MovementDate,MovementQty,MovementType,Updated,UpdatedBy) VALUES (1000000,1000000,TO_DATE('2005-03-17 19:06:54','YYYY-MM-DD HH24:MI:SS'),1000000,'Y',0,1000004,1000000,1000002,1000000,TO_DATE('2005-03-17','YYYY-MM-DD'),1,'V+',TO_DATE('2005-03-17 19:06:54','YYYY-MM-DD HH24:MI:SS'),1000000)
19:06:54,862 WARN [MInOut] saveUpdate - No Session found
19:06:54,867 INFO [Trx] rollback **** WF_1111082814770
19:06:54,874 ERROR [MWFActivity] run
java.lang.Exception: Could not create Material Transaction
at org.compiere.wf.MWFActivity.performWork(MWFActivity.java:739)
at org.compiere.wf.MWFActivity.run(MWFActivity.java:653)
at java.lang.Thread.run(Thread.java:534)
19:06:54,876 WARN [MWFActivity] saveUpdate - No Session found
19:06:54,886 WARN [MWFEventAudit] saveUpdate - No Session found
19:06:54,898 INFO [MWFProcess] checkActivities (117) - OR
19:06:54,902 WARN [MWFActivity] saveUpdate - No Session found
19:06:54,911 WARN [MWFProcess] saveUpdate - No Session found
Sapete darmi una mano ???
Grazie in anticipo.
Probabilmente si verificato un disallineamento fra l' ID della tabella M_Transaction e quello di riferimento della tabella AD_Sequence. Per risolvere il problema prova a far partire il processo Sequence Check come System Administrator.
A presto
-----------------------
Roberto Onnis
ComplIT Project Administrator