[Roger Leon]

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.

[Federico Cristina]

Buenas,

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

Slds,
Federico

[Roger Leon]

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.

[Matías Nerón Cap]

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

[Roger Leon]

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