Linkedin Youtube
Descargar Libertya ERP
  • Este debate está vacío.
Viendo 5 entradas - de la 1 a la 5 (de un total de 5)
  • Autor
    Entradas
  • 18 septiembre, 2011 a las 6:07 am #31876
    Roger Leon
    Miembro

    Hola como estan, tengo pasado el test de applicacion, pero al momento de intentar entrar al sistema con el usuario AdminLibertya con misma clave me tira el mensaje de usuario o contrasenia no coninciden.

    Espero puedan ayudarme. graciass.

    20 septiembre, 2011 a las 7:25 pm #36089
    Federico Cristina
    Superadministrador

    Buenas,

    Has ingresado correctamente las mayúsculas y minúsculas? Por otro lado, presenta algún error adicional en consola?

    Slds,
    Federico

    21 septiembre, 2011 a las 7:44 pm #36092
    Roger Leon
    Miembro

    Buenas,gracias por responder.

    Bueno tuve mucho cuidado con mayusculas y minisculas pero nada,revisando en los logs al levantar el servidor con IniciarServidor.bat se genera las siguientes excepciones:

    *** 2011-09-21 08:28:55.209 OpenXpertya Log (CLogFile) ***
    ===========> MClient.getAll: getAll
    org.postgresql.util.PSQLException: ERROR: relation “ad_client” does not exist
    Position: 15; State=42P01; ErrorCode=0
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
    at $Proxy48.executeQuery(Unknown Source)
    at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:187)
    at org.openXpertya.model.MClient.getAll(MClient.java:378)
    at org.openXpertya.model.ModelValidationEngine.(ModelValidationEngine.java:72)
    at org.openXpertya.model.ModelValidationEngine.get(ModelValidationEngine.java:381)
    at org.openXpertya.OpenXpertya.startupEnvironment(OpenXpertya.java:582)
    at org.openXpertya.OpenXpertya.startup(OpenXpertya.java:560)
    at org.openXpertya.util.WebEnv.initWeb(WebEnv.java:193)
    at org.openXpertya.www.WFilter.init(WFilter.java:70)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:225)

    ===========> MSystem.get: get
    org.postgresql.util.PSQLException: ERROR: relation “ad_system” does not exist
    Position: 15; State=42P01; ErrorCode=0
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
    at $Proxy48.executeQuery(Unknown Source)
    at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:187)
    at org.openXpertya.model.MSystem.get(MSystem.java:183)
    at org.openXpertya.OpenXpertya.startupEnvironment(OpenXpertya.java:586)
    at org.openXpertya.OpenXpertya.startup(OpenXpertya.java:560)
    at org.openXpertya.util.WebEnv.initWeb(WebEnv.java:193)
    at org.openXpertya.www.WFilter.init(WFilter.java:70)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:225)
    at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:308)
    at org.apache.catalina.core.ApplicationFilterConfig.(ApplicationFilterConfig.java:79)

    > OpenXpertya.startupEnvironment: Problemas con las variables de entorno: java.lang.NullPointerException
    ===========> DB.getSQLValue: SELECT AD_Table_ID FROM AD_Table WHERE tablename = ? – Param1=C_Invoice
    org.postgresql.util.PSQLException: No value specified for parameter 1.; State=22023; ErrorCode=0
    at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:174)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
    at $Proxy48.executeQuery(Unknown Source)
    at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:187)
    at org.openXpertya.util.DB.getSQLValue(DB.java:1244)
    at org.openXpertya.model.M_Table.getTableID(M_Table.java:849)
    at org.openXpertya.model.M_Table.getTableID(M_Table.java:844)
    at org.openXpertya.model.X_C_Invoice.(X_C_Invoice.java:62)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:169)
    at $Proxy59.    (Unknown Source)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

    ===========> DB.getSQLValue: SELECT AD_Reference_ID FROM AD_Reference WHERE name = ? – Param1=AD_Org (Trx)
    org.postgresql.util.PSQLException: No value specified for parameter 1.; State=22023; ErrorCode=0
    at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:174)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
    at $Proxy48.executeQuery(Unknown Source)
    at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:187)
    at org.openXpertya.util.DB.getSQLValue(DB.java:1244)
    at org.openXpertya.model.MReference.getReferenceID(MReference.java:20)
    at org.openXpertya.model.X_C_Invoice.(X_C_Invoice.java:81)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:169)
    at $Proxy59.    (Unknown Source)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

    ===========> DB.getSQLValue: SELECT AD_Reference_ID FROM AD_Reference WHERE name = ? – Param1=C_Charge
    org.postgresql.util.PSQLException: No value specified for parameter 1.; State=22023; ErrorCode=0
    at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:174)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
    at $Proxy48.executeQuery(Unknown Source)
    at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:187)
    at org.openXpertya.util.DB.getSQLValue(DB.java:1244)
    at org.openXpertya.model.MReference.getReferenceID(MReference.java:20)
    at org.openXpertya.model.X_C_Invoice.(X_C_Invoice.java:293)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:169)
    at $Proxy59.    (Unknown Source)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

    ===========> DB.getSQLValue: SELECT AD_Reference_ID FROM AD_Reference WHERE name = ? – Param1=C_DocType
    org.postgresql.util.PSQLException: No value specified for parameter 1.; State=22023; ErrorCode=0
    at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:174)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
    at $Proxy48.executeQuery(Unknown Source)
    at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:187)
    at org.openXpertya.util.DB.getSQLValue(DB.java:1244)
    at org.openXpertya.model.MReference.getReferenceID(MReference.java:20)
    at org.openXpertya.model.X_C_Invoice.(X_C_Invoice.java:354)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:169)
    at $Proxy59.    (Unknown Source)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

    ===========> DB.getSQLValue: SELECT AD_Reference_ID FROM AD_Reference WHERE name = ? – Param1=C_Invoice
    org.postgresql.util.PSQLException: No value specified for parameter 1.; State=22023; ErrorCode=0
    at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:174)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
    at $Proxy48.executeQuery(Unknown Source)
    at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:187)
    at org.openXpertya.util.DB.getSQLValue(DB.java:1244)
    at org.openXpertya.model.MReference.getReferenceID(MReference.java:20)
    at org.openXpertya.model.X_C_Invoice.(X_C_Invoice.java:397)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:169)
    at $Proxy59.    (Unknown Source)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

    ===========> DB.getSQLValue: SELECT AD_Reference_ID FROM AD_Reference WHERE name = ? – Param1=_Document Action
    org.postgresql.util.PSQLException: No value specified for parameter 1.; State=22023; ErrorCode=0
    at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:174)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
    at $Proxy48.executeQuery(Unknown Source)
    at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:187)
    at org.openXpertya.util.DB.getSQLValue(DB.java:1244)
    at org.openXpertya.model.MReference.getReferenceID(MReference.java:20)
    at org.openXpertya.model.X_C_Invoice.(X_C_Invoice.java:676)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:169)
    at $Proxy59.    (Unknown Source)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

    ===========> DB.getSQLValue: SELECT AD_Reference_ID FROM AD_Reference WHERE name = ? – Param1=_Document Status
    org.postgresql.util.PSQLException: No value specified for parameter 1.; State=22023; ErrorCode=0
    at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:174)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
    at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
    at $Proxy48.executeQuery(Unknown Source)
    at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:187)
    at org.openXpertya.util.DB.getSQLValue(DB.java:1244)
    at org.openXpertya.model.MReference.getReferenceID(MReference.java:20)
    at org.openXpertya.model.X_C_Invoice.(X_C_Invoice.java:725)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:169)
    at $Proxy59.    (Unknown Source)
    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:513)

    ===========> DB.getSQLValue: SELECT AD_Reference_ID FROM AD_Reference WHERE name = ? – Param1=All_Payment Rule
    org.postgresql.util.PSQLException: No value specified for parameter 1.; State=22023; ErrorCode=0
    at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:174)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
    at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
    at $Proxy48.executeQuery(Unknown Source)
    at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:187)
    at org.openXpertya.util.DB.getSQLValue(DB.java:1244)
    at org.openXpertya.model.MReference.getReferenceID(MReference.java:20)
    at org.openXpertya.model.X_C_Invoice.(X_C_Invoice.java:1141)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:169)
    at $Proxy59.    (Unknown Source)
    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:513)

    ===========> DB.getSQLValue: SELECT AD_Reference_ID FROM AD_Reference WHERE name = ? – Param1=C_Invoice
    org.postgresql.util.PSQLException: No value specified for parameter 1.; State=22023; ErrorCode=0
    at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:174)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
    at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
    at $Proxy48.executeQuery(Unknown Source)
    at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:187)
    at org.openXpertya.util.DB.getSQLValue(DB.java:1244)
    at org.openXpertya.model.MReference.getReferenceID(MReference.java:20)
    at org.openXpertya.model.X_C_Invoice.(X_C_Invoice.java:1261)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:169)
    at $Proxy59.    (Unknown Source)
    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:513)

    ===========> DB.getSQLValue: SELECT AD_Reference_ID FROM AD_Reference WHERE name = ? – Param1=AD_User – SalesRep
    org.postgresql.util.PSQLException: No value specified for parameter 1.; State=22023; ErrorCode=0
    at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:174)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
    at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
    at $Proxy48.executeQuery(Unknown Source)
    at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:187)
    at org.openXpertya.util.DB.getSQLValue(DB.java:1244)
    at org.openXpertya.model.MReference.getReferenceID(MReference.java:20)
    at org.openXpertya.model.X_C_Invoice.(X_C_Invoice.java:1276)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:169)
    at $Proxy59.    (Unknown Source)
    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:513)

    ===========> DB.getSQLValue: SELECT AD_Reference_ID FROM AD_Reference WHERE name = ? – Param1=Account_ID – User1
    org.postgresql.util.PSQLException: No value specified for parameter 1.; State=22023; ErrorCode=0
    at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:174)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
    at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
    at $Proxy48.executeQuery(Unknown Source)
    at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:187)
    at org.openXpertya.util.DB.getSQLValue(DB.java:1244)
    at org.openXpertya.model.MReference.getReferenceID(MReference.java:20)
    at org.openXpertya.model.X_C_Invoice.(X_C_Invoice.java:1326)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:169)
    at $Proxy59.    (Unknown Source)
    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:513)

    ===========> DB.getSQLValue: SELECT AD_Reference_ID FROM AD_Reference WHERE name = ? – Param1=Account_ID – User2
    org.postgresql.util.PSQLException: No value specified for parameter 1.; State=22023; ErrorCode=0
    at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:174)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
    at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
    at $Proxy48.executeQuery(Unknown Source)
    at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:187)
    at org.openXpertya.util.DB.getSQLValue(DB.java:1244)
    at org.openXpertya.model.MReference.getReferenceID(MReference.java:20)
    at org.openXpertya.model.X_C_Invoice.(X_C_Invoice.java:1343)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:169)
    at $Proxy59.    (Unknown Source)
    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:513)

    ===========> 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 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’
    org.postgresql.util.PSQLException: No value specified for parameter 1.; State=22023; ErrorCode=0
    at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:174)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
    at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
    at $Proxy48.executeQuery(Unknown Source)
    at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:187)
    at org.openXpertya.model.POInfo.loadInfo(POInfo.java:135)
    at org.openXpertya.model.POInfo.(POInfo.java:96)
    at org.openXpertya.model.POInfo.getPOInfo(POInfo.java:575)
    at org.openXpertya.model.X_AD_Session.initPO(X_AD_Session.java:40)
    at org.openXpertya.model.PO.initialize(PO.java:206)
    at org.openXpertya.model.PO.    (PO.java:202)
    at org.openXpertya.model.PO.    (PO.java:153)
    at org.openXpertya.model.X_AD_Session.    (X_AD_Session.java:15)
    at org.openXpertya.model.MSession.    (MSession.java:87)
    at org.openXpertya.model.MSession.    (MSession.java:64)
    at org.openXpertya.model.MSession.get(MSession.java:245)
    at org.openXpertya.server.ServidorMgrOXP.startEnvironment(ServidorMgrOXP.java:110)
    at org.openXpertya.server.ServidorMgrOXP.    (ServidorMgrOXP.java:79)
    at org.openXpertya.server.ServidorMgrOXP.get(ServidorMgrOXP.java:56)
    at org.openXpertya.web.MonitorOXP.init(MonitorOXP.java:884)

    ===========> 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 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’
    org.postgresql.util.PSQLException: No value specified for parameter 1.; State=22023; ErrorCode=0
    at org.postgresql.core.v3.SimpleParameterList.checkAllParametersSet(SimpleParameterList.java:174)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:246)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
    at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$StatementHandler.invoke(AbstractJdbc23PooledConnection.java:455)
    at $Proxy48.executeQuery(Unknown Source)
    at org.openXpertya.util.CPreparedStatement.executeQuery(CPreparedStatement.java:187)
    at org.openXpertya.model.POInfo.loadInfo(POInfo.java:135)
    at org.openXpertya.model.POInfo.(POInfo.java:96)
    at org.openXpertya.model.POInfo.getPOInfo(POInfo.java:580)
    at org.openXpertya.model.X_AD_Session.initPO(X_AD_Session.java:40)
    at org.openXpertya.model.PO.initialize(PO.java:206)
    at org.openXpertya.model.PO.    (PO.java:202)
    at org.openXpertya.model.PO.    (PO.java:153)
    at org.openXpertya.model.X_AD_Session.    (X_AD_Session.java:15)
    at org.openXpertya.model.MSession.    (MSession.java:87)
    at org.openXpertya.model.MSession.    (MSession.java:64)
    at org.openXpertya.model.MSession.get(MSession.java:245)
    at org.openXpertya.server.ServidorMgrOXP.startEnvironment(ServidorMgrOXP.java:110)
    at org.openXpertya.server.ServidorMgrOXP.    (ServidorMgrOXP.java:79)
    at org.openXpertya.server.ServidorMgrOXP.get(ServidorMgrOXP.java:56)
    at org.openXpertya.web.MonitorOXP.init(MonitorOXP.java:884)

    Bueno las primeras hacen referencia a que no existirian algunas tablas, pero si estan en la base de datos. La instalacion la realize todo manualmente.

    Quisiera saber como poner el servidor en modo debug para poder visualizar algun mensaje cuando intento el logueo haber si me lanza algun error.

    gracias.

    21 septiembre, 2011 a las 8:00 pm #36096
    Matías Nerón Cap
    Superadministrador

    Una pregunta…configuraste con el archivo Configurar.bat antes de iniciar el servidor?
    Otra cosa que puede estar pasando es que no te estés conectando a la base de datos con el usuario libertya, sino con otro. Probá configurar nuevamente, colocando bien la base de datos (el Configurar.bat no chequea que exista la base de datos) y el usuario de conexión a la base debe ser libertya.

    Saludos
    Cacho

    21 septiembre, 2011 a las 10:00 pm #36097
    Roger Leon
    Miembro

    Muchas gracias ya pude solucionar el problema.

    Bueno efectivamente parecio ser el usuario con el cual me conectaba a la base de datos. Al crear la misma atravez del scritp Crear_DB_Postgresql.bat vi que creo la base de datos con el nombre openxp y un usuario con el mismo nombre en lugar del usuario libertya, al ejecutar Configurar.exe ya cargaba por defecto esa configuracion y al comprobar los parametros me daba ok.

    Bueno ahora registre el rol de acceso libertya y con eso ya pude accesder al sistema.

    Muchas Gracias por la ayuda.

  • Autor
    Entradas
Viendo 5 entradas - de la 1 a la 5 (de un total de 5)
  • Debes estar registrado para responder a este debate.

Libertya - Oficina
Comercial Argentina

Rondeau 2858   
Piso 5 Oficina B
Distrito Tecnológico
C1262ABL CABA
Argentina
+54 11 3220 3493 / 94

SOBRE LIBERTYA ERP
SERVICIOS
PARTNERS
COMUNIDAD