Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
Bronze Super Contributor
Posts: 176
Registered: ‎04-28-2009

Re: SLX 7.5.1 sync errors - list index out of bound (0)

[ Edited ]

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?

Message Edited by mtamborini on 09-21-2009 01:54 PM
---------------------------
Ambit AG, Switzerland
New Member
Posts: 10
Registered: ‎08-28-2009

Re: SLX 7.5.1 sync errors - list index out of bound (0)

Ambit, This is seen with some regularity in my v7.2.1 as well. Sorry to see that over a year later, I am your only reply.

Michael