Errors restoring database

Eoin Wren
2009-03-04
2013-05-02
  • Eoin Wren
    Eoin Wren
    2009-03-04

    Hi,

    I have just started with Compiere, and have tried exporting my db  (that only has 2 tenants and a couple of sales orders) and restoring it into a different install of Compiere (same version).

    I was doing this to test how easy it might be to deploy different instances of databases.

    When I execute the Run_dbrestore.bat file I get the following errors:
    Has anybody else come across this? I am a bit worried that the Compiere database got corrupt so easily.

    many thanks!

    DBA_Cleanup
    > AD_SYNCHRONIZE <
    ERROR
    Statistics computed: 654

    PL/SQL procedure successfully completed.

    PL/SQL procedure successfully completed.

    Type
    -------------------
    Invalid
    --------------------------------------------------------------------------------

    STATUS
    -------
    PROCEDURE
    AD_SYNCHRONIZE
    INVALID

    no rows selected

    no rows selected

    NAME                           TYPE           SEQUENCE       LINE   POSITION
    ------------------------------ ------------ ---------- ---------- ----------
    TEXT
    --------------------------------------------------------------------------------

    ATTRIBUTE MESSAGE_NUMBER
    --------- --------------
    AD_SYNCHRONIZE                 PROCEDURE             1          1       8349
    PL/SQL: ORA-00904: "W"."ISSOTRX": invalid identifier
    ERROR                  0

    AD_SYNCHRONIZE                 PROCEDURE             2          1       7364
    PL/SQL: SQL Statement ignored
    ERROR                  0

    NAME                           TYPE           SEQUENCE       LINE   POSITION
    ------------------------------ ------------ ---------- ---------- ----------
    TEXT
    --------------------------------------------------------------------------------

    ATTRIBUTE MESSAGE_NUMBER
    --------- --------------

    AD_SYNCHRONIZE                 PROCEDURE             3          1      10154
    PL/SQL: ORA-00904: "W"."ISSOTRX": invalid identifier
    ERROR                  0

    AD_SYNCHRONIZE                 PROCEDURE             4          1       8487
    PL/SQL: SQL Statement ignored

    NAME                           TYPE           SEQUENCE       LINE   POSITION
    ------------------------------ ------------ ---------- ---------- ----------
    TEXT
    --------------------------------------------------------------------------------