Solved

Mobile flatfile db not created

  • 4 April 2022
  • 1 reply
  • 89 views

Userlevel 2
Badge +7
  • Do Gooder (Customer)
  • 10 replies

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.

icon

Best answer by sinyb 7 April 2022, 12:10

View original

1 reply

Userlevel 2
Badge +7

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

Reply