Getting SQL Anywhere Error (141) when synchronizing data on device

[Former Member]

Hi, everyone.

I've developed a SUP mobile and deployed it on a BlackBerry device. The single MBO is built based on the sampledb customer table. When I start the app, it should load data from this table through HTTP connection, from the Unwired Server deployed business package. Got this from the log file:

2011-06-08 18:02:04.216 INFO DataServices Thread-187 [com.sybase.vader.cache.SimpleRefreshManager] b830c1d8-c30b-11b6-2100-000a00000000 supAdmin d1_sumatest01.1_0 (Thread-187) com.sybase.vader.cache.SimpleRefreshManager::refreshLoadGroups:618 - Starting refresh Load Groups for cache Default 2011-06-08 18:02:04.373 ERROR MMS Thread-187 [com.sybase.djc.log.SystemExceptionLog] java.lang.RuntimeException was thrown by transaction com.sybase.djc.transaction.TransactionContext.AnonymousTransactionnjava.lang.RuntimeException: com.sybase.vader.ai.impl.SPSQLException: "The statement [ SELECT id, fname, lname, address, city, state, zip, phone, company_name FROM sampledb.dba.customer ] failed to execute with parameters [SPStatementInfo: SQLString: SELECT id, fname, lname, address, city, state, zip, phone, company_name FROM sampledb.dba.customer

Method Name: d1_sumatest01_1_0_custo_70065.loadAll
Quoted String Delimiter: 
Return Value: false
ResultSet Type: java.sql.ResultSet.TYPE_FORWARD_ONLY
0 parameters:

]." at com.sybase.vader.da.jdbc.JdbcRootInteractionOperation.execute(JdbcRootInteractionOperation.java:97) at com.sybase.vader.statistics.MonitoringOperation.execute(MonitoringOperation.java:65) at com.sybase.vader.service.interaction.BranchingInteractionOperation.getRootRecord(BranchingInteractionOperation.java:65) at com.sybase.vader.service.interaction.BranchingInteractionOperation.execute(BranchingInteractionOperation.java:41) at com.sybase.vader.core.vdb.interaction.InteractionQueryOperation.executeQuery(InteractionQueryOperation.java:53) at com.sybase.vader.cache.VTFindAllQueryOperation.executeQuery(VTFindAllQueryOperation.java:20) at com.sybase.vader.cache.PKMergeProcessor.executeCurrentQuery(PKMergeProcessor.java:234) at com.sybase.vader.cache.PKMergeProcessor.accumulateDeltas(PKMergeProcessor.java:310) at com.sybase.vader.cache.PKMergeProcessor.accumulateDeltas(PKMergeProcessor.java:620) at com.sybase.vader.cache.MonitoringMergeProcessor.accumulateDeltas(MonitoringMergeProcessor.java:102) at com.sybase.vader.cache.SimpleRefreshManager.accumulateDeltas(SimpleRefreshManager.java:818) at com.sybase.vader.cache.SimpleRefreshManager.refreshLoadGroups(SimpleRefreshManager.java:630) at com.sybase.vader.cache.SimpleRefreshManager.access$300(SimpleRefreshManager.java:21) at com.sybase.vader.cache.SimpleRefreshManager$2.invoke(SimpleRefreshManager.java:225) at com.sybase.vader.djc.environment.MmsDjcTransactionManager.internalInvoke(MmsDjcTransactionManager.java:46) at com.sybase.vader.djc.environment.MmsDjcTransactionManager.access$000(MmsDjcTransactionManager.java:8) at com.sybase.vader.djc.environment.MmsDjcTransactionManager$1.invoke(MmsDjcTransactionManager.java:22) at com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:845) at com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:747) at com.sybase.vader.djc.environment.MmsDjcTransactionManager.invokeRequiresNew(MmsDjcTransactionManager.java:25) at com.sybase.vader.cache.SimpleRefreshManager.refreshAsNeeded(SimpleRefreshManager.java:254) at com.sybase.vader.cache.SimpleRefreshManager.refreshAsNeeded(SimpleRefreshManager.java:940) at com.sybase.vader.cache.CacheStatisticsRefreshManager.refreshAsNeeded(CacheStatisticsRefreshManager.java:214) at com.sybase.vader.cache.CompositeRefreshManager.refreshAsNeeded(CompositeRefreshManager.java:144) at com.sybase.vader.mms.DataServiceImpl.beforeDownload(DataServiceImpl.java:478) 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 com.sybase.vader.mms.TimedDataServiceImpl.invoke(TimedDataServiceImpl.java:53) at $Proxy8.beforeDownload(Unknown Source) at SUMATest01.server.SUMATest01DB.refreshCache(SUMATest01DB.java:143) 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 com.sybase.sup.server.mbs.SUPPackageUtil.invokeStatic(SUPPackageUtil.java:241) at com.sybase.sup.server.mbs.SUPPackageUtil.invokeDBClassStaticMethod(SUPPackageUtil.java:96) at com.sybase.sup.server.mbs.SUPPackageUtil.invokeDBClassStaticMethod(SUPPackageUtil.java:117) at com.sybase.djc.mobilink.DownloadHandler.beginDownloadConnection(DownloadHandler.java:181) at com.sybase.djc.mobilink.DownloadHandler_DJC.access$001(DownloadHandler_DJC.java:4) at com.sybase.djc.mobilink.DownloadHandler_DJC$1.invoke(DownloadHandler_DJC.java:29) at com.sybase.djc.transaction.TransactionManager.invokeNotSupported1(TransactionManager.java:670) at com.sybase.djc.transaction.TransactionManager.invokeNotSupported(TransactionManager.java:632) at com.sybase.djc.mobilink.DownloadHandler_DJC.beginDownloadConnection(DownloadHandler_DJC.java:43) at com.sybase.djc.mobilink.EventHandler.beginDownloadConnection(EventHandler.java:421) 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 ianywhere.ml.script.MethodInfo.invoke(MethodInfo.java:9836) Caused by: com.sybase.vader.ai.impl.SPSQLException: "The statement [ SELECT id, fname, lname, address, city, state, zip, phone, company_name FROM sampledb.dba.customer ] failed to execute with parameters [SPStatementInfo: SQLString: SELECT id, fname, lname, address, city, state, zip, phone, company_name FROM sampledb.dba.customer

Method Name: d1_sumatest01_1_0_custo_70065.loadAll
Quoted String Delimiter: 
Return Value: false
ResultSet Type: java.sql.ResultSet.TYPE_FORWARD_ONLY
0 parameters:

]." at com.sybase.vader.ai.impl.SPPreparedStatementRequest.execute(SPPreparedStatementRequest.java:41) at com.sybase.vader.da.jdbc.JdbcRootInteractionOperation.execute(JdbcRootInteractionOperation.java:86) ... 50 more Caused by: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -141: Table 'customer' not found at com.sybase.jdbc3.tds.Tds.a(Unknown Source) at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.executeLoop(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.execute(Unknown Source) at com.sybase.jdbc3.jdbc.SybPreparedStatement.execute(Unknown Source) at com.sybase.vader.ai.impl.SPPreparedStatementRequest.execute(SPPreparedStatementRequest.java:36) ... 51 more

Do you know what can be causing this error? Since the MBO is built from the table, I am confused about how it could not find the table on the database, mainly because the profiles (to the database and to the Unwired server) are ok.

Thanks in advance for your help and time.

Regards, Pedro

[philippefbertrand]

I think you would be better off asking this question in an SUP forum. It looks then it is the SUP generated MobiLink scripts or caused by an SUP query.

I'll post where to get SUP support as soon as I find the info.