error PinstanceNotFound in Fyracle

  • Peter

    Peter - 2006-05-19

    I have set up Compiere with Firebird database and have been able to use it to create the accounts, partners, etc. I have run into a problem when I attempt to create a price list.

    In the Compiere client log I get the error message “PinstanceNotFound:SQL Error message FIXME”. This goes into an infinite loop and the only way to stop it is to stop the Compiere client

    I had a look in the database and found that I have AD_PInstance and it has three entries. Not sure if this is the area it is complaining about.

    Set up:
    - Windows XP Professional
    - Firebird for Oracle (Fryacle)
    - Compiere v2.5.3a

    Any suggestions on what the problem could be or where I could look would be appreciated.


    • PAscal

      PAscal - 2006-05-22


      Dev team is working on correcting the displayed value returned by SQLERRM: "SQL Error message FIXME".

      The previous message seems to be returned by the following statement:

          UPDATE AD_PInstance
          SET Created = SysDate,
              IsProcessing = 'Y'
          WHERE AD_PInstance_ID=PInstance_ID;

      More instiguations are under progress for the infinite loop ...

    • PAscal

      PAscal - 2006-05-26


      the problem regarding the infinite loop is already fixed, you just have to download:
      copy it to the fyracle bin directory and restart fyracle service.


      NB: please post this kind of bug reports to fyracle forum for a beter response time

    • Peter

      Peter - 2006-05-29

      Hi PAscal,
      Thanks for the update and advice.

      I copied the new version to the Fryacle bin directory and restarted the service. However, I'm still getting the same error of FIXME repeatedly. I then rebooted the machine, but received the same errors. The executable is 1,545 KB. I tried a third time, by downloanding the fbserver from the above link, however the error continued.

      I'll post these comments over in the Fryacle forum as well.



Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks