Servoy Forum

Discuss Servoy here!
https://forum.servoy.com/

Errors using native SQL Anywhere 17 driver

https://forum.servoy.com/viewtopic.php?f=8&t=22735

Page 1 of 1

Errors using native SQL Anywhere 17 driver

PostPosted: Mon Mar 23, 2020 6:29 pm
by huber
I am using the latest native driver (sajdbc4.jar) with SAP SQL Anywhere 17 (17.0.10.5853), Servoy Developer 8.3.3 and Java 1.8.0_221.

I am getting on some menus in our application an error. There seem to be 2 types of errors. One is always showing a table '#TMP_<number>' not found (error) and the other saying invalid statement. Both types of errors say: Unknown errorCode 100. Looking at http://dcx.sap.com/sqla170/en/html/8113 ... 88d75.html
there is an error code 100, meaning: Row not found.

These errors do not occur with the Java jconn3.jar driver.

Any idea what this could be?

Code: Select all
StaProbation setFoundsetForClassCourse: periodFractionName = HS
StaProbation setFoundsetForClassCourse: periodSchoolYear = 2019
StaProbation setFoundsetForClassCourse: level = 1
StaProbation setFoundsetForClassCourse: classSign = fa
StaProbation setFoundsetForClassCourse: subjectCode = D
JavaException: com.servoy.j2db.dataprocessing.DataException: Unknown errorCode 100
[SAP][JDBC Driver][SQL Anywhere]Table '#TMP_4971128484' not found
   at Hades/forms/StaProbation/setFoundsetForClassCourse:909 (setFoundsetForClassCourse)
   at Hades/forms/StaProbation/getClassCoursesBoxPlotChartDefinition:261 (getClassCoursesBoxPlotChartDefinition)
   at Hades/forms/StaProbation/showChart:148 (showChart)
   at Hades/forms/StaProbation/onShow:135 (onShow)


Other type of error:

Code: Select all
Mar 23, 2020 3:17:39 PM com.servoy.j2db.util.Debug error
SEVERE: There is a problem with an aggregate
   at HadesTeachingAllotments/forms/TeaExperts/refresh:108 (refresh)
   at HadesTeachingAllotments/forms/TeaExperts/onShow:58 (onShow)

Context: FoundSet[Table:persons,Size: 241,CachedRecords: 1,SELECTED INDEX: 0]
com.servoy.j2db.dataprocessing.DataException: Unknown errorCode 100
[SAP][JDBC Driver][SQL Anywhere]Invalid statement
NextException: SQL Error: -130, SQLState: HY000, Message: [SAP][JDBC Driver][SQL Anywhere]Invalid statement
NextException: SQL Error: -130, SQLState: HY000, Message: [SAP][JDBC Driver][SQL Anywhere]Invalid statement
NextException: SQL Error: -130, SQLState: HY000, Message: [SAP][JDBC Driver][SQL Anywhere]Invalid statement

NextException: SQL Error: -130, SQLState: HY000, Message: [SAP][JDBC Driver][SQL Anywhere]Invalid statement
   at com.servoy.j2db.dblayer.Zb.Za(Zb.java:335)
   at com.servoy.j2db.server.Za.Zo.Za(Zo.java:135)
   at com.servoy.j2db.server.dataprocessing.Zx.Za(Zx.java:1102)
   at com.servoy.j2db.server.dataprocessing.Zx.Za(Zx.java:1064)
   at com.servoy.j2db.server.dataprocessing.Zx.performQuery(Zx.java:919)
   at sun.reflect.GeneratedMethodAccessor432.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:498)
   at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:357)
   at sun.rmi.transport.Transport$1.run(Transport.java:200)
   at sun.rmi.transport.Transport$1.run(Transport.java:197)
   at java.security.AccessController.doPrivileged(Native Method)
   at sun.rmi.transport.Transport.serviceCall(Transport.java:196)
   at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:573)
   at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:834)
   at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:688)
   at java.security.AccessController.doPrivileged(Native Method)
   at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:687)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
   at java.lang.Thread.run(Thread.java:748)
   at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:283)
   at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:260)
   at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:161)
   at java.rmi.server.RemoteObjectInvocationHandler.invokeRemoteMethod(RemoteObjectInvocationHandler.java:227)
   at java.rmi.server.RemoteObjectInvocationHandler.invoke(RemoteObjectInvocationHandler.java:179)
   at com.sun.proxy.$Proxy18.performQuery(Unknown Source)
   at com.servoy.j2db.dataprocessing.FoundSet.performQuery(FoundSet.java:6995)
   at com.servoy.j2db.dataprocessing.FoundSet.queryForAggregate(FoundSet.java:4015)
   at com.servoy.j2db.dataprocessing.FoundSet.getAggregateValue(FoundSet.java:3920)
   at com.servoy.j2db.dataprocessing.FoundSet.getDataProviderValue(FoundSet.java:3910)
   at com.servoy.j2db.dataprocessing.Record.getValue(Record.java:244)
   at com.servoy.j2db.dataprocessing.Record.getValue(Record.java:185)
   at com.servoy.j2db.dataprocessing.DataAdapterList.getValueObject(DataAdapterList.java:900)
   at com.servoy.j2db.dataprocessing.DataAdapterList.getValueObject(DataAdapterList.java:877)
   at com.servoy.j2db.dataprocessing.DataAdapterList.getStringValue(DataAdapterList.java:838)
   at com.servoy.base.util.TagParser.processTags(TagParser.java:86)
   at com.servoy.j2db.util.Text.processTags(Text.java:35)
   at com.servoy.j2db.smart.dataui.DataLabel.setValueObject(DataLabel.java:193)
   at com.servoy.j2db.dataprocessing.DisplaysAdapter.setValueToDisplays(DisplaysAdapter.java:230)
   at com.servoy.j2db.dataprocessing.DisplaysAdapter.setRecord(DisplaysAdapter.java:134)
   at com.servoy.j2db.dataprocessing.DataAdapterList.setRecord(DataAdapterList.java:410)
   at com.servoy.j2db.smart.dataui.DataRenderer.refreshRecord(DataRenderer.java:667)
   at com.servoy.j2db.FormController.refreshAllPartRenderers(FormController.java:715)
   at com.servoy.j2db.BasicFormController.valueChanged(BasicFormController.java:507)
   at javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:184)
   at com.servoy.j2db.util.model.AlwaysRowSelectedSelectionModel.fireValueChanged(AlwaysRowSelectedSelectionModel.java:260)
   at javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSelectionModel.java:154)
   at com.servoy.j2db.util.model.AlwaysRowSelectedSelectionModel.setSelectedRows(AlwaysRowSelectedSelectionModel.java:243)
   at com.servoy.j2db.util.model.AlwaysRowSelectedSelectionModel.setSelectedRow(AlwaysRowSelectedSelectionModel.java:208)
   at com.servoy.j2db.util.model.AlwaysRowSelectedSelectionModel.setSelectedRow(AlwaysRowSelectedSelectionModel.java:176)
   at com.servoy.j2db.dataprocessing.SwingFoundSet.setSelectedIndex(SwingFoundSet.java:134)
   at com.servoy.j2db.dataprocessing.TableAndListEventDelegate$1.run(TableAndListEventDelegate.java:153)
   at com.servoy.j2db.dataprocessing.TableAndListEventDelegate.fireTableAndListEvent(TableAndListEventDelegate.java:180)
   at com.servoy.j2db.dataprocessing.SwingFoundSet.fireFoundSetEvent(SwingFoundSet.java:152)
   at com.servoy.j2db.dataprocessing.FoundSet.fireFoundSetEvent(FoundSet.java:5535)
   at com.servoy.j2db.dataprocessing.FoundSet.fireDifference(FoundSet.java:5270)
   at com.servoy.j2db.dataprocessing.FoundSet.loadExternalPKList(FoundSet.java:2422)
   at com.servoy.j2db.dataprocessing.FoundSet.js_loadRecords(FoundSet.java:1304)
   at sun.reflect.GeneratedMethodAccessor206.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:498)
   at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:138)
   at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:292)
   at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:32)
   at org.mozilla.javascript.gen.HadesTeachingAllotments_forms_TeaExperts_refresh_1263._c_refresh_0(HadesTeachingAllotments/forms/TeaExperts/refresh:108)
   at org.mozilla.javascript.gen.HadesTeachingAllotments_forms_TeaExperts_refresh_1263.call(HadesTeachingAllotments/forms/TeaExperts/refresh)
   at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:74)
   at org.mozilla.javascript.gen.HadesTeachingAllotments_forms_TeaExperts_onShow_1262._c_onShow_0(HadesTeachingAllotments/forms/TeaExperts/onShow:58)
   at org.mozilla.javascript.gen.HadesTeachingAllotments_forms_TeaExperts_onShow_1262.call(HadesTeachingAllotments/forms/TeaExperts/onShow)
   at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:399)
   at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3534)
   at org.mozilla.javascript.gen.HadesTeachingAllotments_forms_TeaExperts_onShow_1262.call(HadesTeachingAllotments/forms/TeaExperts/onShow)
   at com.servoy.j2db.scripting.ScriptEngine.executeFunction(ScriptEngine.java:665)
   at com.servoy.j2db.BasicFormController.executeFunction(BasicFormController.java:1067)
   at com.servoy.j2db.BasicFormController.executeFormMethod(BasicFormController.java:786)
   at com.servoy.j2db.BasicFormController.executeOnShowMethod(BasicFormController.java:655)
   at com.servoy.j2db.BasicFormController.access$2(BasicFormController.java:649)
   at com.servoy.j2db.BasicFormController$1.run(BasicFormController.java:386)
   at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
   at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
   at java.awt.EventQueue.access$500(EventQueue.java:97)
   at java.awt.EventQueue$3.run(EventQueue.java:709)
   at java.awt.EventQueue$3.run(EventQueue.java:703)
   at java.security.AccessController.doPrivileged(Native Method)
   at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
   at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
   at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205)
   at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
   at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
   at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
   at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
   at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

Re: Errors using native SQL Anywhere 17 driver

PostPosted: Mon Mar 23, 2020 7:58 pm
by kwpsd
Hi, Robert.

We no longer use SQL Anywhere (since 2012), but I vaguely seem to recall from days of yore that error #100 had something to do with the primary key not being defined (in the dbi file, I think). if you follow your SAP link by clicking on the error #100 in their table:

http://dcx.sap.com/sqla170/en/html/80c0bc8b6ce210148caff078e1c4aceb.html

the following is stated:

You positioned a cursor beyond the beginning or past the end of the query. There is no row at that position.


which, I believe, further substantiates my recollection. Keep in mind that you getting advice from a septuagenarian. :D

I hope this helps!

Re: Errors using native SQL Anywhere 17 driver

PostPosted: Tue Mar 24, 2020 9:13 am
by huber
Hi Kim

Many thanks for your tip, will debug and see if I find the problem. I am going to check for the primary keys in the dpi file. Also thanks for the link. Your memory is still extremely well if you remember by heart errors that happened eight years ago :-))

Best regards,

Re: Errors using native SQL Anywhere 17 driver

PostPosted: Wed Jul 15, 2020 3:14 pm
by huber
I could not find any problem with the primary key (not being defined) in the dpi file. The log states invalid SQL statement, but the insert statement shown in the Server Log is correct and can be successful executed, except the #TMP_<number> table does NOT seem to be there? I also don't know what's going on with this #TMP table?

Servoy, any help what this #TMP table is and a hint where to look at?

Thanks and regards,
All times are UTC + 1 hour [ DST ]
Page 1 of 1