SQLException while deployment of an OCA PDA application

[Former Member]

Hi all,

i have a Problem while the deployment of my pda application. The simulator in the nwds starts normal but in the trace-file i found this:

<r id="1239789462813" t="11:57:42" d="2009-04-15" s="E" c="000" u="" g="" m="java.util.MissingResourceException: Can&apos;t find resource for bundle com.sap.ip.me.api.services.MEResourceBundle$MEPropertyResourceBundle, key START_MOBILE_CLIENT">

<f n="LocationName" v=" (com.sap.ip.me.api.services.MEResourceBundle:handle get object missing resource exception )"/>

<f n="ThreadName" v="main"/>

</r>

<r id="1239789462860" t="11:57:42" d="2009-04-15" s="I" c="000" u="" g="" m="Protokollierung initialisiert">

<f n="LocationName" v=" (com.sap.tc.mobile.logging.impl.FileLogger:)"/>

<f n="ThreadName" v="main"/>

</r>

<r id="1239789462861" t="11:57:42" d="2009-04-15" s="I" c="000" u="" g="" m="Protokollierung initialisiert">

<f n="LocationName" v=" (com.sap.tc.mobile.logging.impl.FileLogger:)"/>

<f n="ThreadName" v="main"/>

</r>

<r id="1239789463110" t="11:57:43" d="2009-04-15" s="E" c="000" u="" g="" m="java.sql.SQLException: Statement is closed">

<f n="LocationName" v=" (com.sap.tc.mobile.cfs.pers.PersistenceManagerImpl:execute)"/>

<f n="ThreadName" v="main"/>

</r>

.

.

.

<r id="1239789463924" t="11:57:43" d="2009-04-15" s="E" c="000" u="" g="" m="Error executing SQL &apos;CREATE TABLE M20T_LOGENTRIES ( CFS_EXTRACTKEY CHAR(32), CFS_STATUS SMALLINT DEFAULT 0, CFS_TX_ID INTEGER DEFAULT 0, &apos;ARRIVAL_DATE&apos; DATE,&apos;ARRIVAL_LOC&apos; VARCHAR(90) UNICODE DEFAULT &apos;&apos;,&apos;ARRIVAL_TIME&apos; VARCHAR(6) UNICODE DEFAULT &apos;&apos;,&apos;DEPARTURE_DATE&apos; DATE,&apos;DEPARTURE_LOC&apos; VARCHAR(90) UNICODE DEFAULT &apos;&apos;,&apos;DEPARTURE_TIME&apos; VARCHAR(6) UNICODE DEFAULT &apos;&apos;,&apos;DRIVER_ID&apos; INTEGER DEFAULT 0,&apos;ENTRY_COMPLETED&apos; SMALLINT DEFAULT &apos;&apos;,&apos;LICENCE_NUMBER&apos; VARCHAR(17) UNICODE DEFAULT &apos;&apos;,&apos;LOGENTRY_ID&apos; INTEGER DEFAULT 0,&apos;MILEAGE_NEW&apos; INTEGER DEFAULT 0,&apos;MILEAGE_OLD&apos; INTEGER DEFAULT 0,&apos;PSYNCKEY&apos; CHAR(32),&apos;RIDE_INTENTION&apos; VARCHAR(132) UNICODE DEFAULT &apos;&apos;,&apos;SYNCKEY_MMW&apos; CHAR(32) PRIMARY KEY,CFS_SERVER_STATE_ID CHAR(32), CFS_SEND_BITS VARCHAR(64), CFS_SENT_SEND_BITS VARCHAR(64))&apos; --&gt; java.sql.SQLException: Cannot convert into numeric value: char

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

at com.sap.sdb.minDB.util.ErrorMsg.conversionError(Unknown Source)

at com.sap.sdb.minDB.common.ColumnType.convertIntoLong(Unknown Source)

at com.sap.sdb.minDB.common.ColumnType.convertObject(Unknown Source)

at com.sap.sdb.minDB.common.ColumnDesc.defineDefaultValue(Unknown Source)

at com.sap.sdb.minDB.sql.CreateTable.setDefault(Unknown Source)

at com.sap.sdb.minDB.sql.CreateTable.parseColumn(Unknown Source)

at com.sap.sdb.minDB.sql.CreateTable.parseSQL(Unknown Source)

at com.sap.sdb.minDB.sql.PrepStmtHandler.&lt;init&gt;(Unknown Source)

at com.sap.sdb.minDB.sql.PrepStmtEmbeddedMinDB.&lt;init&gt;(Unknown Source)

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

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

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

at com.sap.sdb.minDB.common.StatementImpl.execute(Unknown Source)

at com.sap.tc.mobile.cfs.pers.PersistenceManagerImpl.execute(PersistenceManagerImpl.java:74)

.

.

.

at com.sap.tc.mobile.cfs.deploy.DeploymentManager.processInbox(DeploymentManager.java:205)

at com.sap.tc.mobile.cfs.init.FrameworkInitializer.init(FrameworkInitializer.java:192)

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:585)

at com.sap.tc.mobile.cfs.startup.pda.Startup.main(Unknown Source)

">

<f n="ThreadName" v="main"/>

</r>

When i try to start the application i got this error:

Error starting the framework

java.lang.reflect.InvocationTargetException

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:585)

at com.sap.tc.mobile.cfs.startup.pda.Startup.main(Unknown Source)

....

Thanks and many regards,

Dirk

Edited by: Dirk Hirschmann on Apr 15, 2009 12:37 PM

[Former Member]

Hi Dirk

Does this happen after you deploy service component?

Regards

Vidyadhar

[Former Member]

Yes after i deploy the service component i got this error.

[Former Member]

Hi Dirk

Please reset your client. Launch the client once. Then deploy the components.

Please start the client once before you deploy the components for the first time.

By this way we can know whether the table creation is failing because of the application or because of the mobile framework.

Regards

Vidyadhar

[Former Member]

Hi Vidyadhar,

i do the following steps:

1. reset the client from nwds

2. start client and create a new user

3. close client

4. start client and logon

5. close Client

6. deploy application from nwds

7. start client

Now i have 3 trace files in my log folder. The first and the second one contains this exception message, they also looks like this

.

.

<r id="1239879989902" t="13:06:29" d="2009-04-16" s="E" c="000" u="" g="" m="java.util.MissingResourceException: Can&apos;t find resource for bundle com.sap.ip.me.api.services.MEResourceBundle$MEPropertyResourceBundle, key START_MOBILE_CLIENT">

<f n="LocationName" v=" (com.sap.ip.me.api.services.MEResourceBundle:handle get object missing resource exception )"/>

<f n="ThreadName" v="main"/>

</r>

<r id="1239879989980" t="13:06:29" d="2009-04-16" s="I" c="000" u="" g="" m="Protokollierung initialisiert">

<f n="LocationName" v=" (com.sap.tc.mobile.logging.impl.FileLogger:)"/>

<f n="ThreadName" v="main"/>

</r>

<r id="1239879989981" t="13:06:29" d="2009-04-16" s="I" c="000" u="" g="" m="Protokollierung initialisiert">

<f n="LocationName" v=" (com.sap.tc.mobile.logging.impl.FileLogger:)"/>

<f n="ThreadName" v="main"/>

</r>

<r id="1239879990183" t="13:06:30" d="2009-04-16" s="E" c="000" u="" g="" m="java.sql.SQLException: Statement is closed">

<f n="LocationName" v=" (com.sap.tc.mobile.cfs.pers.PersistenceManagerImpl:execute)"/>

<f n="ThreadName" v="main"/>

</r>

.

.

But in the third trace-file there is the SQLException shown in my first entry.

Edited by: Dirk Hirschmann on Apr 16, 2009 1:23 PM

[Former Member]

Hi Dirk

The MissingResourceException will not cause any problem. When you reset the client, please delete the log files in the log folder inside MI. So the next time the client runs there will be fresh logs.

In the Data -> dba folder inside MI please check if M20.... table folder is present.

Regards

Vidyadhar

[Former Member]

Hi Vidyadhar,

in my dba was no folder like "M20...." created. But i found there a folder for my header structure (M19I_TOP) of my DO but the folder for my item structure is always missing.

[Former Member]

edit