#4390 Views and functions not migrated in Migration

R2.6.0
closed
nobody
7
2007-05-22
2007-04-13
contract16
No

I was migrating the database which was on 8th April database to 10th April database. In this upgrade AD_Field_V view was updated. But this view was not migrated to my database. I need to re create the view.
Also the CurrencyBase, CurrencyConversion and CurrencyRate Functions were also not compiled. I had to recreate them as well. (After firing following queries
update C_CONVERSION_RATE set C_CURRENCY_TO_ID = 100 where C_CURRENCY_ID <> 100;
update C_CONVERSION_RATE set C_CURRENCY_TO_ID = 102 where C_CURRENCY_ID = 100;
update c_invoice set C_Invoice_id=109,C_currency_id=102 where documentno=100000
update c_invoice set C_Invoice_id=102,C_currency_id=100 where documentno=10000000
update c_invoice set C_Invoice_id=104,C_currency_id=100 where documentno=10000001
update c_invoice set C_Invoice_id=105,C_currency_id=100 where documentno=10000002
update c_invoice set C_Invoice_id=106,C_currency_id=100 where documentno=10000003
update c_invoice set C_Invoice_id=101,C_currency_id=100 where documentno=200001
update c_invoice set C_Invoice_id=103,C_currency_id=100 where documentno=200002
)

I need to fire these queries may be because my garden world data is not updated.

Discussion

  • Kathy Pink

    Kathy Pink - 2007-04-13
    • assigned_to: kmpink --> nobody
     
  • Jorg Janke

    Jorg Janke - 2007-04-13
    • status: open --> pending
     
  • Jorg Janke

    Jorg Janke - 2007-04-13

    Logged In: YES
    user_id=87038
    Originator: NO

    1. Updating the database via sql is not supported - and I don't see an relationship to the AD_Field_v issue
    2. What you are saying that the target DB was not updated completely - this happenes if the internet connection is not reliable or dropped - just run it again.

     
  • Yves Sandfort

    Yves Sandfort - 2007-04-15
    • status: pending --> open
     
  • Yves Sandfort

    Yves Sandfort - 2007-04-15

    Logged In: YES
    user_id=467647
    Originator: NO

    See other issues.

    Without these SQLs, functions etc. not longer work.

     
  • Jorg Janke

    Jorg Janke - 2007-04-16

    Logged In: YES
    user_id=87038
    Originator: NO

    Well, the validity and definition of Views and Functions have nothing to do with data!
    On Oracle run "Recompile Objects" to fix - Checked the reference database - and the data is valid there. If you had to execute the above statements, someone messed around with the database. As the documents are processed, you had to go through the back door to change the data.
    I recommend using a "fresh" database as you probably caused all sorts of other data integrity issues with whatever you did.

     
  • Jorg Janke

    Jorg Janke - 2007-04-16
    • status: open --> pending
     
  • contract16

    contract16 - 2007-04-17

    Logged In: YES
    user_id=1742483
    Originator: YES

    On latest build(15th April dmp file) these problems are not fixed.

     
  • contract16

    contract16 - 2007-04-17
    • status: pending --> closed
     
  • contract16

    contract16 - 2007-04-25

    Logged In: YES
    user_id=1742483
    Originator: YES

    Following Error genrated while pressing create lines from button in Material Receipt

    09:58:13.816 MIssue.create: SELECT COUNT(*) FROM M_ProductLocator_v pl WHERE pl.M_Locator_ID=? AND pl.M_Product_ID=? [12]
    09:58:13.897 MIssue.saveNew: AD_Issue - AD_Issue_ID=1005087 [12]
    ===========> MLocator.isProductCanStored: SELECT COUNT(*) FROM M_ProductLocator_v pl WHERE pl.M_Locator_ID=? AND pl.M_Product_ID=? [12]
    java.sql.SQLException: ORA-00942: table or view does not exist
    ; State=42000; ErrorCode=942
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
    at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:420)
    at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896)
    at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2929)
    at org.compiere.util.CPreparedStatement.executeQuery(CPreparedStatement.java:137)
    at org.compiere.model.MLocator.isProductCanStored(MLocator.java:305)
    at org.compiere.model.MLocatorLookup.isValid(MLocatorLookup.java:309)
    at org.compiere.model.MLocatorLookup.isValid(MLocatorLookup.java:290)
    at org.compiere.model.MLocatorLookup.getData(MLocatorLookup.java:439)
    at org.compiere.model.Lookup.fillComboBox(Lookup.java:266)
    at org.compiere.grid.ed.VLocatorDialog.initLocator(VLocatorDialog.java:214)
    at org.compiere.grid.ed.VLocatorDialog.<init>(VLocatorDialog.java:68)
    at org.compiere.grid.ed.VLocator.actionPerformed(VLocator.java:358)

     
  • contract16

    contract16 - 2007-05-10
    • priority: 5 --> 7
    • status: closed --> open
     
  • contract16

    contract16 - 2007-05-10

    Logged In: YES
    user_id=1742483
    Originator: YES

    This time we ran the migration with -DINCLUDETYPE=SPDK. The entries in AD_TABLE are migrated. But still views are not migrated although its entry in AD_TABLE is migrated. Also we have a new function in the database which is not migrated.

    We are close to our release so increased the priority.

     
  • Jorg Janke

    Jorg Janke - 2007-05-14
    • status: open --> pending
     
  • Jorg Janke

    Jorg Janke - 2007-05-14

    Logged In: YES
    user_id=87038
    Originator: NO

    Maybe to clarify
    1) "Views not migrated": What does it mean?
    -- Views are not there
    -- Custom Views were deleted
    -- Views not "up-to-date"
    Note that you just need to run http://svn.compiere.org/core/trunk/db/database/DatabaseBuild.sql to update the views.

    2) View M_ProductLocator_v not existing
    It seems that you have connection instabilties [or a too eager firewall] that should be execited. I suggest to exclude any connections to www.compiere.com and svn.compiere.org from any firewall rules. Fix: see 1)

    3) The problems with the CurrencyRate is fixed in the current mightly build, but there is NO need to do any SQL updates.

     
  • SourceForge Robot

    Logged In: YES
    user_id=1312539
    Originator: NO

    This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 7 days (the time period specified by
    the administrator of this Tracker).

     
  • SourceForge Robot

    • status: pending --> closed
     

Log in to post a comment.