Hi everyone,
does anyone know where the errormessage "Error quering for new pks in relatedfoundset" comes from.
one of the users reported this the other day, but I really have no idea how to reproduce it.
Error quering for new pks in relatedfoundset
> com.servoy.j2db.dataprocessing.DataException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
..................
...........
2011-01-04 14:01:13,921 ERROR [pool-5-thread-356] com.servoy.j2db.util.Debug - Throwable
com.servoy.j2db.dataprocessing.DataException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
at com.servoy.j2db.dblayer.Zb.Za(Zb.java:104)
at com.servoy.j2db.server.Zc.Zo.Za(Zo.java:974)
at com.servoy.j2db.dataprocessing.Zu.Za(Zu.java:270)
at com.servoy.j2db.dataprocessing.Zu.performQuery(Zu.java:786)
at com.servoy.j2db.dataprocessing.DataServerProxy.performQuery(DataServerProxy.java:138)
at com.servoy.j2db.dataprocessing.RelatedFoundSet.checkQueryForUpdates(RelatedFoundSet.java:899)
at com.servoy.j2db.dataprocessing.RelatedFoundSet.getSize(RelatedFoundSet.java:407)
at com.servoy.j2db.dataprocessing.SwingRelatedFoundSet.getSize(SwingRelatedFoundSet.java:180)
at com.servoy.j2db.dataprocessing.FoundSet.getRelatedFoundSet(FoundSet.java:4646)
at com.servoy.j2db.dataprocessing.Record.getRelatedFoundSet(Record.java:658)
at com.servoy.j2db.smart.dataui.CellAdapter$ASynchonizedCellLoad.run(CellAdapter.java:835)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
..................
...........
Are you sure that the first time you show exactly the same data? Is there somehow a related data that goes to a different server that is not configured correctly?
this can happen in multiply threads at once, it goes it big blocks, so it could be that there are multiply connections needed at once so i guess in your case a new connection is being made (or tried)
and that fails because sybase tells us that. So some how sybase doesnt allow that login anymore
Maybe because that login can only have X number of connections??
bobpee wrote:Johan can you maybe explain the last part a little bit more? I am curious about what's happening. Something limits and or break my db connection and it's either on my back-end db side or on the Servoy side.
bobpee wrote:I have 3 db instances(db server connections) apart from apart from "servoy-repository" in my solution's set-up. I expect these db instances to be able to handle all connections to and from my back-end dbs, which is the normal experience I am used to. Question: can something be done on my Servoy-Eclipse side to increase the numbers of connections to my dbs?
bobpee wrote:When I login to my solution and I navigate from form-to-form, where some of the forms also use related foundsets, everything runs smoothly. I come to one particular solutionModel generated form for the 1st time and, it also loads nicely. I navigate away from that form and, go to any other form and nothing unexpected happens.
All this time, the fact could be that my back-end db allows me some limited no. of concurrent connections. Now, my 2nd visit to my generated form suddenly throws an "Error quering for new pks in relatedfoundset" error. If the reason is that my back-end db's concurrent connection limit is exceeded as a result of probably some multi-threading processing to generate form that requires more db connections , then what is still strange to me is that why didn't the 1st visit throw this same "Error quering for new pks in relatedfoundset" error?
Could it probably be that the threads generated on my 1st visit to my gen. form were never terminated when I left it?
Return to Programming with Servoy
Users browsing this forum: No registered users and 35 guests