Skip to main content
Solved

Mobile flatfile db not created

  • April 4, 2022
  • 1 reply
  • 101 views

Forum|alt.badge.img+7
  • Do Gooder (Customer)

Hi,

We have an issue when initializing the mobile app. The initialization starts, however, the flatfile db, which should be created on the mobile server, is not created. We also gets this error message. Any suggestions to what could be wrong?:

EXCEPTION Message: SQL logic error
table mm_keys already exists ... Stack Trace: at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
at Metrix.BusinessServer.BusinessPolicies.SharedTablesComponent.MobileManager.CreateSQLiteSystemSchema(SQLiteConnection theSQLiteDB, StringBuilder& theDelayedSchemaStringBuilder)
at Metrix.BusinessServer.BusinessPolicies.SharedTablesComponent.MobileManager.CreateMobileDatabase(String personIdIn, String deviceSequenceIn, String messageIn)

 

Using FSM6U13. This works in Production environment, however, it is in test environment that this issue occurs.

Best answer by sinyb

Turned out there were a column modified_dttm on request_ext as well as request, and that caused the issue.

1 reply

Forum|alt.badge.img+7
  • Author
  • Do Gooder (Customer)
  • Answer
  • April 7, 2022

Turned out there were a column modified_dttm on request_ext as well as request, and that caused the issue.