#59 R252 Function Migration

R2.5.2
closed
7
2005-02-15
2005-02-15
Jorg Janke
No

The migration sometimes does not run the
DatabaseBuild.sql script correctly (which creates the
functions).

The error indicator is something like the below when
processing invloices or payments:

===========> MPayment.getAllocatedAmt:
getAllocatedAmt
java.sql.SQLException: ORA
00904: "CURRENCYCONVERT": invalid identifier;
State=42000; ErrorCode=904

Discussion

  • Jorg Janke

    Jorg Janke - 2005-02-15

    Logged In: YES
    user_id=87038

    Fix: Execute DatabaseBuild.sql manually

    1) Download DatabaseBuild.sql from CVS:
    http://cvs.sourceforge.net/viewcvs.py/compiere/db/database/
    DatabaseBuild.sql?rev=1.145&view=log

    2) Apply via:
    sqlplus compiere/compiere @DatabaseBuild.sql

     
  • Jorg Janke

    Jorg Janke - 2005-02-15
    • milestone: --> R2.5.2
     
  • Jorg Janke

    Jorg Janke - 2005-02-15
    • status: open --> closed
     
  • Jorg Janke

    Jorg Janke - 2005-02-15

    Logged In: YES
    user_id=87038

    The migration program did not run the migration scripts! The
    published patch will allow you to continue, but depending on
    the version you migrated from, you will have problems.

    Please
    - Re-download the distribution from your Assets(!)
    - RE-RUN the Migration

     

Log in to post a comment.

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

Sign up for the SourceForge newsletter:





No, thanks