Quiet errors in the log

[maria.kyselova]

Hi All,

I get a lot of these in my server log when opening forms (they never pop up, I can only see them in the server log or java console):

Code: Select all

org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for table "systeygroup_has_securitypolicy"
     Position: 207
       at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
       at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
       at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
       at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
       at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
       at java.lang.reflect.Method.invoke(Unknown Source)
       at com.servoy.j2db.datasource.Zg.invoke(Zg.java:8)
       at $Proxy1.executeQuery(Unknown Source)
       at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
       at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
       at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
       at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
       at com.servoy.j2db.dataprocessing.Zv.Za(Zv.java:887)
       at com.servoy.j2db.dataprocessing.Zv.Za(Zv.java:741)
       at com.servoy.j2db.dataprocessing.Zv.Za(Zv.java:511)
       at com.servoy.j2db.dataprocessing.Zv.performQuery(Zv.java:1351)
       at sun.reflect.GeneratedMethodAccessor193.invoke(Unknown Source)
       at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
       at java.lang.reflect.Method.invoke(Unknown Source)
       at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
       at sun.rmi.transport.Transport$1.run(Unknown Source)
       at sun.rmi.transport.Transport$1.run(Unknown Source)
       at java.security.AccessController.doPrivileged(Native Method)
       at sun.rmi.transport.Transport.serviceCall(Unknown Source)
       at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
       at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(Unknown Source)
       at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
       at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
       at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
       at java.lang.Thread.run(Unknown Source)


Here is the error mesage above the stack trace:

Code: Select all

2012-10-24 11:36   RMI TCP Connection(2)-127.0.0.1   ERROR   com.servoy.j2db.util.Debug   select systeygroup_has_securitypolicy.idsystem_securitygroup_has_securitypolicy from system_securitygroup_has_securitypolicy right outer join system_securitygroup_has_user system_securitygroup_has_user on systeygroup_has_securitypolicy.idsystem_securitygroup=system_securitygroup_has_user.idsystem_securitygroup and system_securitygroup_has_user.idsystem_organization = ? and systeygroup_has_securitypolicy.policy_type = ? where system_securitygroup_has_user.idsystem_uzer = ? and systeygroup_has_securitypolicy.idsystem_organization = ? order by system_securitygroup_has_user.idsystem_securitygroup_has_user asc parameters: ['E24390E8-09B1-467F-B82E-7A4023A28D94' ,type: java.lang.String, 0 ,type: java.lang.Integer, 'FE6FC249-93DA-42A8-AD8A-1250652E9A9D' ,type: java.lang.String, 'E24390E8-09B1-467F-B82E-7A4023A28D94' ,type: java.lang.String]


What does it all mean?

Cheers,
Maria

[tgs]

Hi Maria,

I think the log entry does it say. Probably you have a SQL statement in your function at code line 207 with a missing FROM clause? I would check this.

Regards,

[maria.kyselova]

Hi Maria,

I think the log entry does it say. Probably you have a SQL statement in your function at code line 207 with a missing FROM clause? I would check this.

Regards,

I don't have any SQL queries in my code, Thomas. That would be the first thing I'd check
The queries output by Servoy are internal based on my relations (you can tell because the table names are chopped).
So, no, unfortunately it's not my queries that cause the errors.

Cheers,
Maria

[maria.kyselova]

I'd really appreciate more suggestions on this matter, guys.
I don't have queries on those tables, it all is handled via relations and I'm wondering if it's a Servoy bug or something is wrong in my relations (or elsewhere).

Cheers,
Maria

[rgansevles]

Maria,

Which version of Servoy are you running?
I think this issue has been fixed in release 6.1.1 already.

Rob

[maria.kyselova]

Maria,

Which version of Servoy are you running?
I think this issue has been fixed in release 6.1.1 already.

Rob

Hi Rob,

Thanks for the tip. My server was 6.1.0. Upgraded to 6.1.2 and the issue seems to be gone.

Cheers,
Maria