SourceForge has been redesigned. Learn more.
Close

Compiere no Ubuntu 7.04

2007-10-09
2013-05-02
  • Walmiro Muzzi

    Walmiro Muzzi - 2007-10-09

    PessoAll

    Estou configurando o cliente do Compiere no Ubuntu 7.04. Os testes estão OK mas estou com um pequeno problema na hora de me conectar ao servidor.

    Executo "sh RUN_Compiere2.sh", abre a tela de conexão, digito o usuário e a senha. Quando mando conectar não sai da tela e também não trava. O log me dá o seguinte:

    #####################################################################################################################################
    walmiro@sein:/Compiere2$ sh RUN_Compiere2.sh
    Compiere Client
    *** 2007-10-09 11:21:04.584 Compiere Log (CLogConsole) ***
    11:21:04.583 Compiere.startup: Compiere(r) Release 2.6.1_2007-05-10 - Smart ERP & CRM - (c) 1999-2007 Compiere (r); Implementation: 2.6.1 20070512-1103 - ComPiere, Inc.
    11:21:04.584 Compiere.startup: /Compiere2 - Java HotSpot(TM) Client VM 1.5.0_11-b03 - Linux 2.6.20-16-generic unknown
    11:21:07.564 Ini.loadProperties: /home/walmiro/Compiere.properties #24
    OnlineHelp.Worker.run (e) java.lang.NullPointerException
    -----------> CConnection.getStatusEjbStub: jnp://192.168.160.165:1099
    - javax.naming.CommunicationException: Receive timed out [Root exception is java.net.SocketTimeoutException: Receive timed out]
    - {java.naming.provider.url=jnp://192.168.160.165:1099, java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, jnp.discoveryTimeout=2000, jnp.timeout=2000, java.naming.factory.url.pkgs=org.jboss.naming.client, jnp.sotimeout=2000}
    ===========> POInfo.loadInfo: SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL, c.IsEncrypted FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e  ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y' [11]
    java.sql.SQLException: ORA-00904: "C"."COLUMNSQL": invalid identifier
    ; State=42000; ErrorCode=904
            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:138)
            at org.compiere.model.POInfo.loadInfo(POInfo.java:123)
            at org.compiere.model.POInfo.<init>(POInfo.java:74)
            at org.compiere.model.POInfo.getPOInfo(POInfo.java:50)
            at org.compiere.model.X_AD_System.initPO(X_AD_System.java:86)
            at org.compiere.model.PO.<init>(PO.java:115)
            at org.compiere.model.PO.<init>(PO.java:89)
            at org.compiere.model.X_AD_System.<init>(X_AD_System.java:62)
            at org.compiere.model.MSystem.<init>(MSystem.java:107)
            at org.compiere.model.MSystem.get(MSystem.java:51)
            at org.compiere.model.MIssue.create(MIssue.java:44)
            at org.compiere.util.CLogErrorBuffer.publish(CLogErrorBuffer.java:200)

    ===========> POInfo.loadInfo: SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL, c.IsEncrypted FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e  ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y' [11]
    java.sql.SQLException: ORA-00904: "C"."COLUMNSQL": invalid identifier
    ; State=42000; ErrorCode=904
            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:138)
            at org.compiere.model.POInfo.loadInfo(POInfo.java:123)
            at org.compiere.model.POInfo.<init>(POInfo.java:74)
            at org.compiere.model.POInfo.getPOInfo(POInfo.java:53)
            at org.compiere.model.X_AD_System.initPO(X_AD_System.java:86)
            at org.compiere.model.PO.<init>(PO.java:115)
            at org.compiere.model.PO.<init>(PO.java:89)
            at org.compiere.model.X_AD_System.<init>(X_AD_System.java:62)
            at org.compiere.model.MSystem.<init>(MSystem.java:107)
            at org.compiere.model.MSystem.get(MSystem.java:51)
            at org.compiere.model.MIssue.create(MIssue.java:44)
            at org.compiere.util.CLogErrorBuffer.publish(CLogErrorBuffer.java:200)

    Exception occurred during event dispatching:
    java.lang.IllegalArgumentException: Invalid PO Info - POInfo[null,AD_Table_ID=531]
            at org.compiere.model.PO.<init>(PO.java:117)
            at org.compiere.model.PO.<init>(PO.java:89)
            at org.compiere.model.X_AD_System.<init>(X_AD_System.java:62)
            at org.compiere.model.MSystem.<init>(MSystem.java:107)
            at org.compiere.model.MSystem.get(MSystem.java:51)
            at org.compiere.model.MIssue.create(MIssue.java:44)
            at org.compiere.util.CLogErrorBuffer.publish(CLogErrorBuffer.java:200)
            at java.util.logging.Logger.log(Logger.java:452)
            at java.util.logging.Logger.doLog(Logger.java:474)
            at java.util.logging.Logger.log(Logger.java:563)
            at org.compiere.model.POInfo.loadInfo(POInfo.java:166)
            at org.compiere.model.POInfo.<init>(POInfo.java:74)
            at org.compiere.model.POInfo.getPOInfo(POInfo.java:50)
            at org.compiere.model.X_AD_System.initPO(X_AD_System.java:86)
            at org.compiere.model.PO.<init>(PO.java:115)
            at org.compiere.model.PO.<init>(PO.java:89)
            at org.compiere.model.X_AD_System.<init>(X_AD_System.java:62)
            at org.compiere.model.MSystem.<init>(MSystem.java:107)
            at org.compiere.model.MSystem.get(MSystem.java:51)
            at org.compiere.util.Login.getRoles(Login.java:219)
            at org.compiere.util.Login.getRoles(Login.java:196)
            at org.compiere.apps.ALogin.tryConnection(ALogin.java:559)
            at org.compiere.apps.ALogin.connectionOK(ALogin.java:437)
            at org.compiere.apps.ALogin.actionPerformed(ALogin.java:403)
            at org.compiere.apps.AppsAction.actionPerformed(AppsAction.java:266)
            at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
            at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
            at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
            at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
            at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
            at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:231)
            at java.awt.Component.processMouseEvent(Component.java:5501)
            at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
            at java.awt.Component.processEvent(Component.java:5266)
            at java.awt.Container.processEvent(Container.java:1966)
            at java.awt.Component.dispatchEventImpl(Component.java:3968)
            at java.awt.Container.dispatchEventImpl(Container.java:2024)
            at java.awt.Component.dispatchEvent(Component.java:3803)
            at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
            at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
            at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
            at java.awt.Container.dispatchEventImpl(Container.java:2010)
            at java.awt.Window.dispatchEventImpl(Window.java:1778)
            at java.awt.Component.dispatchEvent(Component.java:3803)
            at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
            at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
            at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
            at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:153)
            at java.awt.Dialog$1.run(Dialog.java:525)
            at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
            at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
            at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
            at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
            at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
            at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
            at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
    #####################################################################################################################################

    Não tenho experiência com Java e estou tendo dificuldades para identificar e resolver o problema.

    Podem me ajudar?

    Muito obrigado!

    []s
    Walmiro Muzzi

     
    • Walmiro Muzzi

      Walmiro Muzzi - 2007-10-10

      Problema resolvido.

      A versão do Java deve ser 1.4.2

      []s
      Walmiro Muzzi

       

Log in to post a comment.