Skip to Content
0
Jan 10, 2013 at 12:05 PM

SUPPersistenceException: (null) when synchronizing SUPDB how to find error?

30 Views

I am building an application on iOS consuming MBOs from SUP 2.1.3PL2. I connect to SUP via a Relay Server.

When I use a simple Mobile Application containing only one MBO I can synchronize the data to my device without a problem.

Now I try using similar code and synchronizing data from another Mobile Application using 3 MBOs filled per DCN.

After [MySUPDB synchronize] the following entry is displayed in the log:

[sup_ul_db_DatabaseManagerImpl.mm151] create schema directly...

SUPPersistenceException: (null)

I guess the error is related to a problem with my MBOs but how can I debug the synchronize processs or find more info about it?

I already examined the iAnywhere Database but could not find a problem there. I have three MBOs, one of it contains 2 entries, the others are empty.

I also had a look into the app data (esp. the mocaLog.txt) but could not spot a hint either. In the documents folder there is a file named myApp1_0.udb.new in relation to a file myOtherApp1_0.udb where the synch is working. So there seems to be a problem when creating the local database on the device but how can I find this error?

Message was edited by: Mark Teichmann I now enabled the trace in the SUPConnectionProfile and got following trace info: 2013-01-10 14:33:08.391 MoMa3[3424:907] [SQL TRACE][DEBUG] create database :/var/mobile/Applications/F12A3425-3E62-4603-B7B7-2CB1DE3858A4/Documents/moMa21_0.udb 2013-01-10 14:33:08.426 MoMa3[3424:907] [SQL TRACE][DEBUG] {thread:0x1ed185a0}: connecting to database: /var/mobile/Applications/F12A3425-3E62-4603-B7B7-2CB1DE3858A4/Documents/moMa21_0.udb.new, returned dbhandle:0x1f8966a0 2013-01-10 14:33:08.433 MoMa3[3424:907] [DEBUG] [sup_ul_db_DatabaseManagerImpl.mm:151] create schema directly... 2013-01-10 14:33:08.435 MoMa3[3424:907] [SQL TRACE][DEBUG] create table "moma2_1_0_almorder_os" ("a" varchar(48) null,"b" varchar(160) null,"c" date null,"d" date null,"e" varchar(160) null,"f" varchar(72) null,"g" varchar(160) null,"h" varchar(32) null,"i" varchar(40) null,"j" varchar(140) null,"l" varchar(140) null,"m" varchar(40) null,"n" varchar(140) null,"o" varchar(64) null,"_pf" tinyint null default 'N',"_pc" char(1) null,"_rp" decimal(20,0) null,"_rf" decimal(20,0) null,"p" decimal(20,0) null,"_rc" decimal(20,0) null,"_ds" tinyint null, primary key ("p", "_pf") ,SYNCHRONIZE DOWNLOAD) 2013-01-10 14:33:08.446 MoMa3[3424:907] [SQL TRACE][ERROR] {thread:0x1ed185a0,dbConn:0x1f8966a0}: ERROR: -110 (ERROR) %1:moma2_1_0_almorder_os 2013-01-10 14:33:08.615 MoMa3[3424:907] 0 MoMa3 0x00277327 +[SUPSqlTrace error:withThrow:withMessage:] + 178 2013-01-10 14:33:08.617 MoMa3[3424:907] 1 MoMa3 0x0027725f +[SUPSqlTrace throwableError::] + 106 2013-01-10 14:33:08.619 MoMa3[3424:907] 2 MoMa3 0x002c56ef -[sup_ul_db_ConnectionWrapperImpl traceError:] + 110 2013-01-10 14:33:08.620 MoMa3[3424:907] 3 MoMa3 0x002c5653 -[sup_ul_db_ConnectionWrapperImpl throwPersistenceException] + 102 2013-01-10 14:33:08.621 MoMa3[3424:907] 4 MoMa3 0x002c599f -[sup_ul_db_ConnectionWrapperImpl executeNonQuery:] + 126 2013-01-10 14:33:08.622 MoMa3[3424:907] 5 MoMa3 0x002c6471 -[sup_ul_db_DatabaseManagerImpl createDatabase::] + 700 2013-01-10 14:33:08.622 MoMa3[3424:907] 6 MoMa3 0x0028025f -[SUPAbstractDBRBS getConnectionWrapper] + 398 2013-01-10 14:33:08.623 MoMa3[3424:907] 7 MoMa3 0x00257361 -[SUPKeyGenerator findAll::] + 552 2013-01-10 14:33:08.624 MoMa3[3424:907] 8 MoMa3 0x002577d5 -[SUPKeyGenerator findAll] + 28 2013-01-10 14:33:08.625 MoMa3[3424:907] 9 MoMa3 0x0027a94d -[SUPSynchronizationGroupImpl getClientId:] + 104 2013-01-10 14:33:08.626 MoMa3[3424:907] 10 MoMa3 0x0027a599 -[SUPSynchronizationGroupImpl init::] + 168 2013-01-10 14:33:08.627 MoMa3[3424:907] 11 MoMa3 0x0027a4c9 +[SUPSynchronizationGroupImpl getInstance:withDBDelegate:] + 44 2013-01-10 14:33:08.628 MoMa3[3424:907] 12 MoMa3 0x00220aef -[SUPDatabaseDelegate getSynchronizationGroup:] + 214 2013-01-10 14:33:08.629 MoMa3[3424:907] 13 MoMa3 0x00224133 -[SUPDatabaseDelegate synchronizeWithCallback:withListener:withUserContext:withJson:] + 458 2013-01-10 14:33:08.630 MoMa3[3424:907] 14 MoMa3 0x00223f5d -[SUPDatabaseDelegate synchronize:withListener:withUserContext:] + 88 2013-01-10 14:33:08.631 MoMa3[3424:907] 15 MoMa3 0x00223efd -[SUPDatabaseDelegate synchronize:withListener:] + 40 2013-01-10 14:33:08.632 MoMa3[3424:907] 16 MoMa3 0x00223ec9 -[SUPDatabaseDelegate synchronizeWithListener:] + 52 2013-01-10 14:33:08.633 MoMa3[3424:907] 17 MoMa3 0x001b3acf +[iagMoMa2DB synchronizeWithListener:] + 54 2013-01-10 14:33:08.634 MoMa3[3424:907] 18 MoMa3 0x0002dad9 -[iagAppDelegate onConnectSuccess:] + 1128 2013-01-10 14:33:08.635 MoMa3[3424:907] 19 CoreFoundation 0x3a302037 _CFXNotificationPost + 1426 2013-01-10 14:33:08.636 MoMa3[3424:907] 20 MoMa3 0x00031ed9 -[CallbackHandler sendNotification:] + 72 2013-01-10 14:33:08.637 MoMa3[3424:907] 21 Foundation 0x3569e8ed + 460 2013-01-10 14:33:08.638 MoMa3[3424:907] 22 CoreFoundation 0x3a386683 + 14 2013-01-10 14:33:08.638 MoMa3[3424:907] 23 CoreFoundation 0x3a385ee9 + 212 2013-01-10 14:33:08.639 MoMa3[3424:907] 24 CoreFoundation 0x3a384cb7 + 646 2013-01-10 14:33:08.640 MoMa3[3424:907] 25 CoreFoundation 0x3a2f7ebd CFRunLoopRunSpecific + 356 2013-01-10 14:33:08.641 MoMa3[3424:907] 26 CoreFoundation 0x3a2f7d49 CFRunLoopRunInMode + 104 2013-01-10 14:33:08.642 MoMa3[3424:907] 27 Foundation 0x355f178f + 254 2013-01-10 14:33:08.643 MoMa3[3424:907] 28 Foundation 0x355fa54f + 86 2013-01-10 14:33:08.644 MoMa3[3424:907] 29 MoMa3 0x0002f65f -[iagAppDelegate initializeMoMa] + 4778 2013-01-10 14:33:08.645 MoMa3[3424:907] 30 MoMa3 0x0002c24d -[iagAppDelegate alertView:clickedButtonAtIndex:] + 444 2013-01-10 14:33:08.646 MoMa3[3424:907] 31 UIKit 0x38512b71 + 296 2013-01-10 14:33:08.647 MoMa3[3424:907] 32 UIKit 0x384a60a5 + 72 2013-01-10 14:33:08.648 MoMa3[3424:907] 33 UIKit 0x384a6057 + 30 2013-01-10 14:33:08.648 MoMa3[3424:907] 34 UIKit 0x384a6035 + 44 2013-01-10 14:33:08.649 MoMa3[3424:907] 35 UIKit 0x384a58eb + 502 2013-01-10 14:33:08.650 MoMa3[3424:907] 36 UIKit 0x384a5de1 + 488 2013-01-10 14:33:08.651 MoMa3[3424:907] 37 UIKit 0x383ce5f1 + 524 2013-01-10 14:33:08.652 MoMa3[3424:907] 38 UIKit 0x383bb801 + 380 2013-01-10 14:33:08.653 MoMa3[3424:907] 39 UIKit 0x383bb11b + 6154 2013-01-10 14:33:08.654 MoMa3[3424:907] 40 GraphicsServices 0x3c1f85a3 + 590 2013-01-10 14:33:08.655 MoMa3[3424:907] 41 GraphicsServices 0x3c1f81d3 + 34 2013-01-10 14:33:08.656 MoMa3[3424:907] 42 CoreFoundation 0x3a386173 + 34 2013-01-10 14:33:08.656 MoMa3[3424:907] 43 CoreFoundation 0x3a386117 + 138 2013-01-10 14:33:08.657 MoMa3[3424:907] 44 CoreFoundation 0x3a384f99 + 1384 2013-01-10 14:33:08.658 MoMa3[3424:907] 45 CoreFoundation 0x3a2f7ebd CFRunLoopRunSpecific + 356 2013-01-10 14:33:08.659 MoMa3[3424:907] 46 CoreFoundation 0x3a2f7d49 CFRunLoopRunInMode + 104 2013-01-10 14:33:08.660 MoMa3[3424:907] 47 GraphicsServices 0x3c1f72eb GSEventRunModal + 74 2013-01-10 14:33:08.661 MoMa3[3424:907] 48 UIKit 0x3840f2f9 UIApplicationMain + 1120 2013-01-10 14:33:08.662 MoMa3[3424:907] 49 MoMa3 0x0002c069 main + 96 2013-01-10 14:33:08.663 MoMa3[3424:907] 50 libdyld.dylib 0x3c691b20 + 0 2013-01-10 14:33:08.669 MoMa3[3424:907] SUPPersistenceException: (null) Is there anybody out there who finds the error here?