Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

SQL Error -504 during Import (Fyracle)

iselwa
2006-07-07
2013-05-02
  • iselwa
    iselwa
    2006-07-07

    during import (tried Product and BP) each timeI press the "Import" button only ONE record is procesed. Pressing "Import" again, the next record is imported.

    Found the following error within the logs:

    05:17:21.875     MBPartner.saveNew: [SvrProcess_1152155841171] - C_BPartner - C_BPartner_ID=1000009 [28]
    05:17:22.281         MBPartner.load: C_BPartner_ID=1000009 [28]
    05:17:22.296         MBPartner.load: (rs) [28]
    05:17:22.296         MBPartner.setKeyInfo: (PK) C_BPartner_ID=1000009 [28]
    05:17:22.390     MBPartner.insert_Tree: #1 - TreeType=BP [28]
    05:17:22.500     MBPartner.insert_Accounting: #1 [28]
    05:17:22.562     MBPartner.insert_Accounting: #1 [28]
    05:17:22.671     MBPartner.insert_Accounting: #1 [28]
    05:17:22.671         ImportBPartner.doIt: Insert BPartner [28]
    05:17:22.687         MSequence.getNextID: AC=false, RO=false - Isolation=2(2) - RSType=1003(1005), RSConcur=1008(1008) [28]
    05:17:22.687         MSequence.getNextID: 1000010 - Table=C_Location [null] [28]
    05:17:22.734         ImportBPartner.doIt: Insert Location = 1 [28]
    05:17:22.734         MSequence.getNextID: AC=false, RO=false - Isolation=2(2) - RSType=1003(1005), RSConcur=1008(1008) [28]
    05:17:22.750         MSequence.getNextID: 1000009 - Table=C_BPartner_Location [null] [28]
    05:17:22.765         ImportBPartner.doIt: Insert BP Location = 1 [28]
    05:17:22.781         MSequence.getNextID: AC=false, RO=false - Isolation=2(2) - RSType=1003(1005), RSConcur=1008(1008) [28]
    05:17:22.781         MSequence.getNextID: 1000008 - Table=AD_User [null] [28]
    05:17:22.828         ImportBPartner.doIt: Insert BP Contact = 1 [28]
    05:17:22.875 Trx.commit: **** SvrProcess_1152155841171 [28]
    ===========> ImportBPartner.doIt:  [28]
    org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
    SQL error code = -504
    Cursor  ; State=HY000; ErrorCode=335544569
    at org.firebirdsql.jdbc.FBStatementFetcher.fetch(FBStatementFetcher.java:198)
    at org.firebirdsql.jdbc.FBStatementFetcher.next(FBStatementFetcher.java:127)
    at org.firebirdsql.jdbc.FBResultSet.next(FBResultSet.java:223)
    at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at org.firebirdsql.pool.ResultSetHandler.invoke(ResultSetHandler.java:70)
    at $Proxy2.next(Unknown Source)
    at org.compiere.process.ImportBPartner.doIt(ImportBPartner.java:318)
    at org.compiere.process.SvrProcess.process(SvrProcess.java:103)
    at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:80)
    at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:444)
    at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:228)

    05:17:22.921 Trx.rollback: **** SvrProcess_1152155841171 [28]
    05:17:22.953 Trx.start: **** SvrProcess_1152155841171 [28]
    05:17:22.953 ImportBPartner.addLog: 0 - null - 1 - @Errors@ [28]
    05:17:22.953 ImportBPartner.addLog: 0 - null - 1 - @C_BPartner_ID@: @Inserted@ [28]
    05:17:22.953 ImportBPartner.addLog: 0 - null - 0 - @C_BPartner_ID@: @Updated@ [28]

    need more history ?

    thanks for Help in advance
    erich