#6 250d and translations ORA-00904: "M_AD_MENU_ID":

closed-fixed
nobody
None
7
2015-01-26
2003-11-10
jaume teixi
No

with 250d translations can't load because of:

09:59:28.108 MRole: addAccessSQL - SELECT
m_AD_Menu_ID,
t.Name,t.Description,m.IsSummary,m.Action,
m.AD_Window_ID, m.AD_Process_ID, m.AD_Form_ID,
m.AD_Workflow_ID, m.AD_Task_ID, m.AD_Workbench_ID FROM
AD_Menu m, AD_Menu_Trl t WHERE
m.AD_Menu_ID=t.AD_Menu_ID AND t.AD_Language='fr_FR' AND
m.IsActive='Y' AND m.AD_Client_ID=0 AND m.AD_Org_ID=0
09:59:28.109 MTree: getNodeDetails - SELECT
m_AD_Menu_ID,
t.Name,t.Description,m.IsSummary,m.Action,
m.AD_Window_ID, m.AD_Process_ID, m.AD_Form_ID,
m.AD_Workflow_ID, m.AD_Task_ID, m.AD_Workbench_ID FROM
AD_Menu m, AD_Menu_Trl t WHERE
m.AD_Menu_ID=t.AD_Menu_ID AND t.AD_Language='fr_FR' AND
m.IsActive='Y' AND m.AD_Client_ID=0 AND m.AD_Org_ID=0
===========> CompiereStatement: remote_getRowSet -
CompiereStatementVO[SELECT m_AD_Menu_ID,
t.Name,t.Description,m.IsSummary,m.Action,
m.AD_Window_ID, m.AD_Process_ID, m.AD_Form_ID,
m.AD_Workflow_ID, m.AD_Task_ID, m.AD_Workbench_ID FROM
AD_Menu m, AD_Menu_Trl t WHERE
m.AD_Menu_ID=t.AD_Menu_ID AND t.AD_Language='fr_FR' AND
m.IsActive='Y' AND m.AD_Client_ID=0 AND m.AD_Org_ID=0]
java.sql.SQLException: ORA-00904: "M_AD_MENU_ID":
invalid identifier

at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
at
oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:3989)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:623)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527)
at
org.compiere.util.CompiereStatement.remote_getRowSet(CompiereStatement.java:889)
at org.compiere.util.DB.getRowSet(DB.java:1262)
at
org.compiere.model.MTree.getNodeDetails(MTree.java:394)
at
org.compiere.model.MTree.loadNodes(MTree.java:197)
at org.compiere.model.MTree.<init>(MTree.java:45)
at
org.compiere.grid.tree.VTreePanel.initTree(VTreePanel.java:99)
at org.compiere.apps.AMenu.<init>(AMenu.java:76)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at
java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at java.lang.Class.newInstance0(Class.java:306)
at java.lang.Class.newInstance(Class.java:259)
at org.compiere.Compiere.main(Compiere.java:524)
Cannot start: org.compiere.apps.AMenu -
java.lang.RuntimeException: java.sql.SQLException:
ORA-00904: "M_AD_MENU_ID": invalid identifier

java.lang.RuntimeException: java.sql.SQLException:
ORA-00904: "M_AD_MENU_ID": invalid identifier

at
org.compiere.util.CompiereStatement.remote_getRowSet(CompiereStatement.java:901)
at org.compiere.util.DB.getRowSet(DB.java:1262)
at
org.compiere.model.MTree.getNodeDetails(MTree.java:394)
at
org.compiere.model.MTree.loadNodes(MTree.java:197)
at org.compiere.model.MTree.<init>(MTree.java:45)
at
org.compiere.grid.tree.VTreePanel.initTree(VTreePanel.java:99)
at org.compiere.apps.AMenu.<init>(AMenu.java:76)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at
java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at java.lang.Class.newInstance0(Class.java:306)
at java.lang.Class.newInstance(Class.java:259)
at org.compiere.Compiere.main(Compiere.java:524)
Caused by: java.sql.SQLException: ORA-00904:
"M_AD_MENU_ID": invalid identifier

at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
at
oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:3989)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:623)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527)
at
org.compiere.util.CompiereStatement.remote_getRowSet(CompiereStatement.java:889)
... 13 more

Discussion

  • jaume teixi

    jaume teixi - 2003-11-10

    Logged In: YES
    user_id=575821

    this sql should start with :
    MRole: addAccessSQL - SELECT m.AD_Menu_ID

     
  • jaume teixi

    jaume teixi - 2003-11-10

    Logged In: YES
    user_id=575821

    for instance AD_Language_ID again is setted as key column in
    AD_Language

     
  • jaume teixi

    jaume teixi - 2003-11-10

    Logged In: YES
    user_id=575821

    for instance AD_Language_ID again is setted as key column in
    AD_Language

     
  • jaume teixi

    jaume teixi - 2003-11-10
    • labels: 503629 -->
    • milestone: 310856 -->
    • priority: 5 --> 7
    • status: open --> open-fixed
     
  • jaume teixi

    jaume teixi - 2003-11-10

    Logged In: YES
    user_id=575821

    solution: base/src/org/compiere/model/MTree.java v 1.6
    correct line 348 with:
    sqlNode.append("SELECT m.AD_Menu_ID,
    t.Name,t.Description,m.IsSummary,m.Action, "

     
  • Jorg Janke

    Jorg Janke - 2003-12-30
    • status: open-fixed --> closed-fixed
     

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

Sign up for the SourceForge newsletter:





No, thanks