MI 7.1 Sync error

[asdasd_asdasd]

hello experts, to synchronize I get the following error:

Sync.jsp -- sequenceNo:96

java.lang.RuntimeException: Cannot create extract message

at com.sap.tc.mobile.cfs.sync.SyncManager.synchronize()

at com.sap.tc.mobile.cfs.jspui.MainServlet$SyncThread.run()

at java.lang.Thread.run()

any ideas?

regards.

[Former Member]

Hi,

This information is not sufficient to find out the root cause.

Set the trace level to ALL, reproduce the issue and copy paste the error shown in the latest trace file.

Best Regards,

Amit

[asdasd_asdasd]

Hi experts,

Trace is as follows:

...

Sync.jsp -- sequenceNo:90

2010-10-15 17:34:04 ... (com.sap.tc.mobile.cfs.agent.AgentManager:AgentManager -- Update) Thread: Thread-33 Info: URL created :http://bsassapmiprd.nidera.com.ar:8000/sap/bc/mmw_device_sync?sap-client=300

2010-10-15 17:34:04 ... (com.sap.tc.mobile.cfs.conf.Configuration:setConfiguration) Thread: Thread-33 Info: set com.sap.tc.mobile.sync.http.service.url = http://bsassapmiprd.nidera.com.ar:8000/sap/bc/doe_timeservice?sap-client=300

2010-10-15 17:34:04 ... (com.sap.tc.mobile.cfs.conf.Configuration:setConfiguration) Thread: Thread-33 Info: set com.sap.ip.mi.sync.TimeOfLastSync = 1287174841030

2010-10-15 17:34:04 ... (com.sap.tc.mobile.cfs.pers.PersistenceManagerImpl:execute) Thread: Thread-33 Debug: UPDATE CFS_CONFIGURATION SET CONF_VALUE='1287174841030' WHERE CONF_KEY='com.sap.ip.mi.sync.TimeOfLastSync'

2010-10-15 17:34:04 ... (com.sap.tc.mobile.cfs.pers.PersistenceManagerImpl:execute) Thread: Thread-33 Error: java.sql.SQLException: Statement is closed

2010-10-15 17:34:05 ... (com.sap.tc.mobile.cfs.pers.PersistenceManager:commit) Thread: Thread-33 Debug: Commit called

2010-10-15 17:34:05 ... (com.sap.tc.mobile.cfs.pers.PersistenceManagerImpl:execute) Thread: Thread-33 Debug: SELECT C_VALUE FROM CFS_COUNTER WHERE C_ID = 0

2010-10-15 17:34:05 ... (com.sap.tc.mobile.cfs.pers.PersistenceManagerImpl:execute) Thread: Thread-33 Debug: UPDATE CFS_COUNTER SET C_VALUE = 116 WHERE C_ID = 0

2010-10-15 17:34:05 ... (com.sap.tc.mobile.cfs.pers.PersistenceManagerImpl:execute) Thread: Thread-33 Error: java.sql.SQLException: Statement is closed

2010-10-15 17:34:05 ... (com.sap.tc.mobile.cfs.sync.SyncManager:synchronize) Thread: Thread-33 Info: synchronization completed

2010-10-15 17:34:07 ... (com.sap.tc.mobile.cfs.jspui.MainServlet:doPost) Thread: Thread-20 Debug: doPost Called

2010-10-15 17:34:07 ... (com.sap.tc.mobile.cfs.jspui.MainServlet:doPost) Thread: Thread-20 Debug: syncRequest

2010-10-15 17:34:07 ... (com.sap.tc.mobile.cfs.jspui.MainServlet:doGet) Thread: Thread-20 Debug: doGet Called

2010-10-15 17:34:08 ... (com.sap.tc.mobile.cfs.jspui.MainServlet:doGet) Thread: Thread-20 Debug: syncRequest

2010-10-15 17:34:08 ... (com.sap.tc.mobile.cfs.jspui.MainServlet:doHandleEvent) Thread: Thread-20 Debug: MainServlet -- sequenceNo maintained by servlet:90

2010-10-15 17:34:08 ... (com.sap.tc.mobile.cfs.jspui.MainServlet:doHandleEvent) Thread: Thread-20 Debug: MainServlet -- sequenceNo sent by jsp:90

2010-10-15 17:34:08 ... (com.sap.tc.mobile.cfs.jspui.MainServlet:doHandleEvent) Thread: Thread-20 Debug: MainServlet -- EventName:syncRequest

Sync.jsp -- sequenceNo:91

2010-10-15 17:34:23 ... (com.sap.tc.mobile.cfs.pers.PersistenceManager:execute) Thread: Thread-20 Debug: SELECT SYNCKEY_MMW FROM M16SYSMSGHEADER WHERE EXPIRY_DATE < 1287174848873

2010-10-15 17:34:23 ... Thread: Thread-20 Error: Error executing SQL 'SELECT SYNCKEY_MMW FROM M16SYSMSGHEADER WHERE EXPIRY_DATE < 1287174848873' --> java.sql.SQLException: Connection is closed

at com.sap.sdb.minDB.util.ErrorMsg.newSQLException()

at com.sap.sdb.minDB.util.ErrorMsg.invalidStmt()

at com.sap.sdb.minDB.dataAccess.ConnectionImpl.checkConnection()

at com.sap.sdb.minDB.sql.ConnectionHandle.createPreparedStmt()

at com.sap.sdb.minDB.common.ConnectionDummy.prepareStatement()

at com.sap.sdb.minDB.common.StatementImpl.createPreparedStmt()

at com.sap.sdb.minDB.common.StatementImpl.executeQuery()

at com.sap.tc.mobile.cfs.pers.PersistenceManager.executeQuery()

at com.sap.tc.mobile.cfs.pers.PersistenceManager.delete()

at com.sap.tc.mobile.cfs.sysmsg.impl.SystemMessageListener.deleteExpiredMessages()

at com.sap.tc.mobile.cfs.sysmsg.impl.NewsImpl.getIterator()

at com.sap.tc.mobile.cfs.sysmsg.impl.NewsImpl.messagesAvailable()

at jsp.sync._jspService()

at org.apache.jasper.runtime.HttpJspBase.service()

at javax.servlet.http.HttpServlet.service()

at org.apache.tomcat.core.ServletWrapper.doService()

at org.apache.tomcat.core.Handler.service()

at org.apache.tomcat.core.ServletWrapper.service()

at org.apache.tomcat.facade.RequestDispatcherImpl.doForward()

at org.apache.tomcat.facade.RequestDispatcherImpl.access$000()

at org.apache.tomcat.facade.RequestDispatcherImpl$1.run()

at org.apache.tomcat.facade.RequestDispatcherImpl.forward()

at com.sap.ip.me.api.runtime.jsp.AbstractMEHttpServlet.dispatchRequest()

at com.sap.ip.me.api.runtime.jsp.AbstractMEHttpServlet.doGetThreadSafe()

at com.sap.ip.me.api.runtime.jsp.AbstractMEHttpServlet.doGet()

at com.sap.tc.mobile.cfs.jspui.MainServlet.doGet()

at com.sap.ip.me.api.runtime.jsp.AbstractMEHttpServlet.doPost()

at com.sap.tc.mobile.cfs.jspui.MainServlet.doPost()

at com.sap.ip.me.api.runtime.jsp.AbstractMEHttpServlet.service()

at javax.servlet.http.HttpServlet.service()

at org.apache.tomcat.core.ServletWrapper.doService()

at org.apache.tomcat.core.Handler.service()

at org.apache.tomcat.core.ServletWrapper.service()

at org.apache.tomcat.core.ContextManager.internalService()

at org.apache.tomcat.core.ContextManager.service()

at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection()

at org.apache.tomcat.service.TcpWorkerThread.runIt()

at org.apache.tomcat.util.ThreadPool$ControlRunnable.run()

at java.lang.Thread.run()

java.lang.RuntimeException: Cannot create extract message

at com.sap.tc.mobile.cfs.sync.SyncManager.synchronize()

at com.sap.tc.mobile.cfs.jspui.MainServlet$SyncThread.run()

at java.lang.Thread.run()

...

Regards.