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

asked 09 Jun '11, 14:43

Pedro%20Brigatto's gravatar image

Pedro Brigatto
1111
accept rate: 0%

edited 05 Jul '13, 13:02

Mark%20Culp's gravatar image

Mark Culp
23.4k9132275


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.

permanent link

answered 09 Jun '11, 15:13

PhilippeBertrand%20_SAP_'s gravatar image

PhilippeBert...
1.5k41735
accept rate: 22%

edited 09 Jun '11, 15:15

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×86
×77
×1

question asked: 09 Jun '11, 14:43

question was seen: 2,644 times

last updated: 05 Jul '13, 13:02