Got this warning when RUN_ImportReference

2003-11-07
2003-11-08
  • Sureeraya Limpaibul

    IMP-00041: Warning: object created with compilation warnings
    "CREATE FORCE VIEW "REFERENCE"."RV_CASH_DETAIL"                       ("C_CA"
    "SH_ID","C_CASHLINE_ID","AD_CLIENT_ID","AD_ORG_ID","ISACTIVE","CREATED","CRE"
    "ATEDBY","UPDATED","UPDATEDBY","C_CASHBOOK_ID","NAME","STATEMENTDATE","DATEA"
    "CCT","PROCESSED","POSTED","LINE","DESCRIPTION","CASHTYPE","C_CURRENCY_ID",""
    "AMOUNT","CONVERTEDAMT","C_BANKACCOUNT_ID","C_INVOICE_ID","C_CHARGE_ID") AS "
    "SELECT cl.C_Cash_ID, cl.C_CashLine_ID,"
    "      c.AD_Client_ID, c.AD_Org_ID, cl.IsActive, cl.Created, cl.CreatedBy, cl.U
    pd"
    "ated, cl.UpdatedBy,"
    "      c.C_CashBook_ID, c.Name, c.StatementDate, c.DateAcct, c.Processed, c.Pos
    te"
    "d,"

     
    • Marco LOMBARDO

      Marco LOMBARDO - 2003-11-08

      Those kind of messages do not matter.

      explanation:
      With oracle you can FORCE the creation of a view, view that at creation time could have some error, but at execution time must be correct.
      Oracle recompile every invalid object at  execution time by default. Anyway Compiere have a script (AfterImport.sql) that recompile and verify that there are no invalid objects.

       

Log in to post a comment.

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

Sign up for the SourceForge newsletter:





No, thanks