Large backlog Upload transactions waiting to be processed
Error in log file:
2013-06-10 14:21:50.7937 Error username Ivara.OTAssert [26] File: Dbtrans.cpp(116) : Failed Assert: oDBTransaction::oDBTransaction() - We are attempting to create a new oDBTransaction when the current transaction is rolled back.
2013-06-10 14:21:50.7937 Error username Ivara.OTAssert [26] File: oqtempl.h(3583) : Failed Assert: oPersistent::privatePersist() - An instance of UploadTransaction (oid = 24686) is being persisted, yet the database transaction will be rolled back. Exiting and returning FALSE.
2013-06-10 14:36:56.4598 Warn username Ivara.Server.ServerMessageBoxCallback [31] File: COMGenKern.cpp(83) : ClassID: 1077 ObjectID: 9 Message: The 'Site' field is blank. You must enter a value in this field.
2013-06-10 14:36:56.4598 Error username Ivara.OTAssert [31] File: Caxcntr.cpp(4958) : Failed Assert: SynchronizationError::Process -- Upload transaction 00024686 could not be persisted - ClassID - 1000004597 - ObjectID- 24686
Site-> The 'Site' field is blank. You must enter a value in this field.
SQL to identify indicators on upload transaction with null sites:
select i.indicatornam,u.transdate_dttm, u.mobilepc_oi from fnd.uploadtransaction u, mnt.indicatorreading r, mnt.conditionindicator iwhere u.site_oi is null and u.instanceoid = r.indicatorreadingoi and indicat_oi = i.indicatoroi
SQL to fix upload transaction with null sites:
update fnd.uploadtransaction set vers = vers + 1, site_oi = ( select mpc.site_oi from fnd.mobilepc mpc where mpc.mobilepcoi = nnn) where site_oi is null;
Replace 'nnn' with mobilepc_oi
NOTE: Always run query updates in a test environment to verify desired outcome. Always backup production database before running an update query.
Fixed in 7.2