These issues happen when users try to use the new mobile version that was deployed on their mobile device. The mobile changes are made in Designer, published, and deployed to the mobile server. There are no errors or issues we see with the publishing or deployment to the server. However, when those revision updates being sent to devices from server, below problems occurs.
All issues below need to be fixed by reinstalling the app from scratch.
1. When the user finishes initializing, sometimes their FSM does not display any jobs, customers, their name, or the pm list. Reinstalling fixes the issue.
2. Sometimes when the user initializes, their FSM password that worked the day prior now mysteriously stops working. Only after reinstalling the app does the password start working again as intended.
Approximately 10% of users are affected.
These are the log entries that i have found.
10/24/2022 11:03:39 PM; EX; 2378473; UpdateMessageCache; EXCEPTION Message: The following system level exception was generated by the application: Violation of PRIMARY KEY constraint 'mm_message_cache_pk'. Cannot insert duplicate key in object 'dbo.mm_message_cache'. The duplicate key value is (SUPPLIER_PART).The statement has been terminated.Contact your system administrator for assistance.
10/24/2022 11:06:43 PM; EX; 2380252; PerformReplicationForTableAndPerson; EXCEPTION Message: Thread was being aborted. ... Stack Trace: at Metrix.BusinessServer.BusinessPolicyInterface.SelectBuilder.ProcessSelectRequest(XmlElement root, UserSession session, Dictionary`2 attachments, Boolean checkForSqlInjection, Boolean bypassTableAccessCheck, Boolean& responseIsException)
10/24/2022 11:06:43 PM; EX; 2380445; PerformMmMessageErrorInsert; EXCEPTION Message: Thread was being aborted. ... Stack Trace: at Metrix.BusinessServer.BusinessPolicies.SharedTablesComponent.MobileManager.PerformReplicationForTableAndPerson(String tableNameIn, String personIdIn, Boolean truncateTableIn, String deviceSequenceIn, SQLiteCommand sqliteCommandIn, mm_process_defRow syncRuleIn, Dictionary`2 tableColumnsDictionaryIn)
10/24/2022 11:06:43 PM; EX; 2380445; PerformMmMessageErrorInsert; EXCEPTION Message: Thread was being aborted. ... Stack Trace: at Metrix.BusinessServer.BusinessPolicies.SharedTablesComponent.MobileManager.PerformInitializeMobileDevice(String personId, String deviceSequence, String message, SQLiteConnection theSQLiteDB, Dictionary`2 theSyncRuleTableColumnsDictionary)