Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

Compiere Libero on OS/2

Bart
2005-04-07
2013-05-02
  • Bart
    Bart
    2005-04-07

    That "Get the total freedom" thread was getting kind of long, so I started my own :-)

    Changing the run_setup.bat for OS/2 was as simple as  changing the extension to .cmd, but the Run_server2.bat file is a little more compicated:

    1) The first line of run_server2.bat calls myenvironment.bat, but that file does not exist. (there is a file myenvironmenttemplate.bat).  Are we suppose to rename it?

    2) In myenvironmenttemplate.bat,  I don't understand lines like:
    SET COMPIERE_HOME=@COMPIERE_HOME@
    What are those "@" symbols for?

    Thanks

    Bart

     
    • Marco LOMBARDO
      Marco LOMBARDO
      2005-04-08

      Hi,
      some files are *template and have @XXXXXX@ inside because after you run RUN_setup some ant tasks are executed to replace the parameters yuo enter in the RUN_setup window inside several files. So:

      1. myenvironmenttemplate.bat will be renamed by RUN_setup
      2. @COMPIERE_HOME@ will be substituted with the COMPIERE_HOME path

      Regards,

      Mar
      Compilo subAdministrator
      compilo.sf.net

       
    • Bart
      Bart
      2005-04-08

      Thank you Mar,
      I have executed Run_setup successfully, but there was NO renamed myenvironmenttemplate.bat
      Should I rename it myself and fix all the @XXX@ templates?
      Or is this even neccessary. Can I REM the
      "Call myenvironmenttemplate.bat " statement out of Run_server2 since all these settings are in the .preferences files created by Run_setup?

      Thanks

      Bart
      Toronto

       
    • Bart
      Bart
      2005-04-11

      The documentation says to point your browser to http://dev/compiere.html, but the only place i can find it is in the temporary files area:
      D:\Compiere2\jboss\server\compiere\tmp\deploy\tmp54615compiereRoot.ear-contents\compiereRoot.war\compiere.html

      And of course it does not work. Can someone help me out?

      Thanks

      Bart

       
      • Marco LOMBARDO
        Marco LOMBARDO
        2005-04-12

        Just point your browser to the ip:port address you specify during setup. You will find the link to run Compiere throu java Web start there.

        regards,

        Mar
        Compilo subAdministrator
        compilo.sf.net

         
    • Bart
      Bart
      2005-04-11

      D:\Compiere2\jboss\server\compiere\tmp\deploy\tmp54615compiereRoot.ear-contents\compiereRoot.war\compiere.html

      D:\Compiere2\jboss\server\compiere\log\boot.log has no errors but server.log and the compiere log have some notices. Would someone be so kind as to explain what is going wrong here? Thank you very much.

      D:\Compiere2\jboss\server\compiere\log\server.log:
      java.lang.ClassNotFoundException: No ClassLoaders found for: org.apache.tomcat.util.net.puretls.PureTLSImplementation
          at org.jboss.mx.loading.LoadMgr3.beginLoadTask(LoadMgr3.java:161)
          at org.jboss.mx.loading.UnifiedClassLoader3.loadClassImpl(UnifiedClassLoader3.java:169)
         
      2005-04-11 13:09:30,319 DEBUG [org.apache.tomcat.util.net.SSLImplementation] Error creating org.apache.tomcat.util.net.puretls.PureTLSImplementation
      java.lang.ClassNotFoundException: Error loading SSL Implementation org.apache.tomcat.util.net.puretls.PureTLSImplementation :java.lang.ClassNotFoundException: No ClassLoaders found for: org.apache.tomcat.util.net.puretls.PureTLSImplementation
          at org.apache.tomcat.util.net.SSLImplementation.getInstance(SSLImplementation.java:121)
          at org.apache.tomcat.util.net.SSLImplementation.getInstance(SSLImplementation.java:90)
         
      java.lang.ClassNotFoundException: org.jboss.invocation.http.servlet.ReadOnlyAccessFilter
          at java.net.URLClassLoader$1.run(URLClassLoader.java:198)
          at java.security.AccessController.doPrivileged(Native Method)
         
      SEVERE: Java HotSpot(TM) Server VM - 1.4.1_07(untested)  <>  1.4.2
      (No need to explain this notice)

      javax.servlet.ServletException: Servlet.init() for servlet CompiereMonitor threw exception
          at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:963)
          at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:823)
      2005-04-11 13:11:52,067 ERROR [org.jboss.web.localhost.Engine] ----- Root Cause -----
      java.lang.IllegalArgumentException: Invalid PO Info - POInfo[null,AD_Table_ID=566]
          at org.compiere.model.PO.<init>(PO.java:104)
          at org.compiere.model.PO.<init>(PO.java:64)
      2005-04-11 13:14:54,477 INFO  [org.jboss.system.server.Server] JBoss (MX MicroKernel) [3.2.3 (build: CVSTag=JBoss_3_2_3 date=200311301445)] Started in 6m:21s:668ms

      D:\Compiere2\log\2005-04-11_0.log:
      *** 2005-04-11 13:10:33.701 Compiere Log (CLogFile) ***
      13:10:33.696   CLogMgt.addHandler: addHandler=CLogFile[D:\Compiere2\log\2005-04-11_0.log,Level=ALL]
      13:10:33.819 Compiere.startup: Compiere(r) Release 2.5.2b_2005-02-26 - Smart ERP & CRM - (c) 1999-2005 Compiere (r); Implementation: e-Evolution,S.C. 20050321-1502 - Supported
      13:10:33.824 Compiere.startup: D:\Compiere2 - Java HotSpot(TM) Server VM 1.4.1_07-fcs-gcd-b42-20040728 - OS/2 20.45 unknown
      13:10:33.850 Ini.loadProperties: D:\Compiere2\Compiere.properties #22
      ===========> MClient.getAll: getAll
      java.sql.SQLException: ERROR: relation "ad_client" does not exist; State=42P01; ErrorCode=0
          at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
          at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
          etc.
          etc.
      ===========> MSystem.get: get
      java.sql.SQLException: ERROR: relation "ad_system" does not exist; State=42P01; ErrorCode=0
          at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
          at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
          etc.
          etc.

      ===========> WebEnv.initWeb: initWeb
      java.lang.NullPointerException
          at org.compiere.model.MSystem.get(MSystem.java:67)
          at org.compiere.Compiere.startupEnvironment(Compiere.java:459)
          etc.
          etc.

      ===========> 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 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'
      java.sql.SQLException: ERROR: relation "ad_table" does not exist; State=42P01; ErrorCode=0
          at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
          at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
          etc.
          etc.

      ===========> 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 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'
      java.sql.SQLException: ERROR: relation "ad_table" does not exist; State=42P01; ErrorCode=0
          at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
          at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
          etc.
          etc.

      *** 2005-04-11 17:14:17.967 Compiere Log (CLogFile) ***

       
    • Bart
      Bart
      2005-04-12

      Thanks Mar, that works fine.

      BTW, regarding my error list in another message,
      my postmaster.log has:
      ERROR:  relation "ad_client" does not exist
      ERROR:  relation "ad_system" does not exist
      ERROR:  relation "ad_table" does not exist

      Ccan someone please tell me what is going wrong here?

       
    • Bart
      Bart
      2005-04-14

      It appears from my errors that the tables need to be created.

      I would really appreciate some direction here so I can complete the installation.

      Thanks

      Bart