minDB can not find database file

[former_member79518]

Hi

We have a mobile application running on PDA devices. We are using minDB and occasionally we get this error. In this example it couldn't find file .....1595 and if I look in the folder all files up till 1594 are there but not 1595.

When this happens it is impossible to use the application any further.

Does anyone have any idea why this might happen. We are running on Windows Mobile 6.5. Could it be possible that it is running out of file handles?

thanks

Andrew

<r id="1310630891883" t="04:08:11" d="2011-07-14" s="E" c="000" u="MI001" g="en" m="Cannot create extract message --&gt; java.sql.SQLException: java.io.FileNotFoundException: /MI/data/dba/CFS_OUT_Q/CFS_OUT_Q_1595.lob

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

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

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

at com.sap.sdb.minDB.dataAccess.Catalog.newSQLExceptionCausedByIO()

at com.sap.sdb.minDB.dataAccess.Catalog.createLargeObjFile()

at com.sap.sdb.minDB.dataAccess.TableRow.setColumnValue()

at com.sap.sdb.minDB.sql.SetClauseHandler.updateColumnValues()

at com.sap.sdb.minDB.sql.InsertHandler.executeSQL()

at com.sap.sdb.minDB.sql.PrepStmtHandler.executeDelInsUpd()

at com.sap.sdb.minDB.sql.PrepStmtHandler.execute()

at com.sap.sdb.minDB.sql.PrepStmtEmbeddedMinDB.execute()

at com.sap.tc.mobile.cfs.sync.OutQueueHelper.createNewMessage()

at com.sap.tc.mobile.cfs.sync.Extractor.extract()

at com.sap.tc.mobile.cfs.sync.Extractor.extract()

at com.sap.tc.mobile.cfs.sync.Extractor.extract()

at com.sap.tc.mobile.cfs.sync.ChangeListenerImpl.beforeCommit()

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

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

at com.sap.tc.mobile.cfs.compat.Context.commit()

at com.sap.tc.mobile.sf.OcaRoot.commit()

at ..........................impl.StocktakeService.AddOrUpdateItem()

[Former Member]

Hi Andy,

yes, this happened to me - solution - use DB2e on PDA or MaxDB on PC instead.

Do you have a large amount of data or do you use the device for a long period of time? For me it was the amount of data that caused this issue. I am not sure about the exact number, but it was the amount of files per folder.

Hope this helps.

Regards,

Oliver