SourceForge has been redesigned. Learn more.
Close

"Comlimenti a chi ci capisce"

2005-03-17
2013-05-02
  • Fares Gianluca

    Fares Gianluca - 2005-03-17

    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.

     
    • Roberto Onnis

      Roberto Onnis - 2005-03-21

      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

       

Log in to post a comment.