09-21-2009 01:12 AM - edited 09-21-2009 04:54 AM
Sage provided us with Hot Fix 25 (SyncServer.exe 7.5.1.1779) for testing. It lists the following defects:
1-68145 Synchronization fails with error: “Invalid column name.” This issue originally fixed in 7.5.1 Hot Fix 7.
1-69384 Conflict resolution fails when only rule is Remote user wins and more than one remote user makes updates.
But it didn't solve the problem. We still have thousands of Failed TEF statements like this:
ERROR: ParamSQLUpd - Error applying ParamSQL transaction A1M0Q5F : List index out of bounds (0). SQL: SELECT STARTDATE,ALARMTIME FROM ACTIVITY WHERE ACTIVITYID = 'VNZYQA005GOJ'
or
ERROR: Unknown Error
(Blob size : 253)
Activity Related
Activity Users = |UNZYQA00009W|
Table Name = USER_ACTIVITY
SQL = UPDATE USER_ACTIVITY SET CONFIRMED = 'F' WHERE (ACTIVITYID = 'VNZYQA003VDI') AND NOT (USERID IN ('UNZYQA00009W', 'UNZYQA00009W'))
or
ERROR: An unknown or internal error has occurred
(Blob size : 279)
Activity Related
Activity Users = |U6UJ9A00007R|
Table Name = USER_ACTIVITY
SQL = UPDATE USER_ACTIVITY SET ALARM = 'T', ALARMTIME = '20090909 12:55:34' WHERE ACTIVITYID ='VNZYQA0065TX' AND USERID = 'U6UJ9A00007R'
Conflicts Resolution is set to "made the most recent change" and retain updates for 7 days.
Are there any news on this? Could other BPs fix this?
11-24-2010 12:54 PM