Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

SQL-Error FIXME (Fyracle) PriceList generatio

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

    Hello,

    During generation of PriceLists the Java-CMD Windows starts endless(?) loop with "FIXME Sql error message".

    Last entries in Client-Log

    --------------------------
    18:03:13.740     ProcessCtl.process: WindowNo=2 - ProcessInfo[Create Prices based on parameters of this version,Process_ID=103,Record_ID=1000000,Error=false,Summary=,Log=0] [11]
    18:03:13.801         MPInstance.load: ID=0 [11]
    18:03:13.801         MPInstance.setKeyInfo: (PK) AD_PInstance_ID=0 [11]
    18:03:13.811         MPInstance.set_Value: IsProcessing = false [11]
    18:03:13.811         MPInstance.set_Value: AD_Process_ID = 103 [11]
    18:03:13.811         MPInstance.set_ValueNoCheck: Record_ID = 1000000 (java.lang.Integer) [11]
    18:03:13.811         MPInstance.set_Value: AD_User_ID = 100 [11]
    18:03:13.821         MPInstance.set_Value: IsProcessing = false [11]
    18:03:13.821         MSequence.getNextID: AC=false, RO=false - Isolation=2(2) - RSType=1003(1005), RSConcur=1008(1008) [11]
    18:03:13.861         MSequence.getNextID: 1000018 - Table=AD_PInstance [null] [11]
    18:03:13.861         MPInstance.set_ValueNoCheck: AD_PInstance_ID = 1000018 (java.lang.Integer) [11]
    18:03:13.871     MPInstance.saveNew: AD_PInstance - AD_PInstance_ID=1000018 [11]
    18:03:13.911         MPInstance.load: AD_PInstance_ID=1000018 [11]
    18:03:13.991         MPInstance.load: (rs) [11]
    18:03:13.991         MPInstance.setKeyInfo: (PK) AD_PInstance_ID=1000018 [11]
    18:03:14.051   ProcessParameter.initDialog:  [11]
    18:03:14.191     MField.getDefault: [DefaultValue] DeleteOld=N [11]
    18:03:14.191       Env.setContext: Context(2) DeleteOld==N [11]
    18:03:18.908   ProcessParameter.saveParameters:  [11]
    18:03:18.978         MPInstancePara.load: ID=0 [11]
    18:03:18.998         MPInstancePara.setKeyInfo: (FK) AD_PInstance_ID=null [11]
    18:03:18.998         MPInstancePara.setKeyInfo: (FK) SeqNo=null [11]
    18:03:19.008         MPInstancePara.set_ValueNoCheck: AD_PInstance_ID = 1000018 (java.lang.Integer) [11]
    18:03:19.018         MPInstancePara.set_ValueNoCheck: SeqNo = 0 (java.lang.Integer) [11]
    18:03:19.028         MPInstancePara.set_Value: ParameterName = DeleteOld [11]
    18:03:19.028         MPInstancePara.set_Value: P_String = N [11]
    18:03:19.038         MPInstancePara.set_Value: Info = No [11]
    18:03:19.048     MPInstancePara.saveNew: AD_PInstance_Para - AD_PInstance_ID=1000018 AND SeqNo='0' [11]
    18:03:19.148         MPInstancePara.load: AD_PInstance_ID=1000018 AND SeqNo='0' [11]
    18:03:19.258         MPInstancePara.load: (rs) [11]
    18:03:19.268         MPInstancePara.setKeyInfo: (FK) AD_PInstance_ID=1000018 [11]
    18:03:19.278         MPInstancePara.setKeyInfo: (FK) SeqNo=0 [11]
    18:03:19.288     ProcessParameter.saveParameters: MPInstancePara[1000018-DeleteOld(s)=N(p)=0 - 0] [11]
    18:03:19.328   AWindow.setBusy: AWindow_146 - false [11]
    18:03:19.359     ProcessCtl.run: AD_PInstance_ID=1000018, Record_ID=1000000 [26]
    18:03:19.399   AGlassPane.setBusyTimer: AGlassPane.setBusyTimer - 5 [26]
    18:03:19.799     ProcessCtl.startDBProcess: M_PriceList_Create(1000018) [26]
    18:03:20.610       ProcessCtl.run: lock [11]

    *** 2006-07-17 18:03:22.473 Compiere Log (CLogFile) ***
    ----------------------------------------

    Did I miss anything to setup or wrong sequence ?

    thanks in advance
    erich