Skip to main content
Solved

Mobile flatfile db not created

  • April 4, 2022
  • 1 reply
  • 98 views

Forum|alt.badge.img+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.

Best answer by sinyb

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

View original
Did this topic help you find an answer to your question?

1 reply

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

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings