Brudertac
2008-08-19T12:30:00Z
Hi,

we have some Errors in the Sync Protocol.
Those happens always on "Load All".

For Example:

WARNING:20080819 11:57:39 ModificationTime Conflict Item

"Item Text"

Outlook overrules Database changes.
ERROR:20080819 11:58:10 Database call:
UPDATE "dbo"."Calendar" SET "gc_Unread"='N',"gc_LastModificationTime"={ts '2008-07-23 16:53:17'} WHERE "gc_id"='F4F9304F-FF1A-40E4-A7FE-BAFABEEA8592'

S1T00 [Microsoft][ODBC SQL Server Driver]Timeout abgelaufen (0)

Any Ideas where i can start searching for a Solution ?

Thanks !

best regards
Danny
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
Administrator
2008-08-19T12:37:00Z
This is not an error, but warning about Modification Time Conflict.

When Conflict resolution is ON, GeniusConnect compares data based on LastModifiaction.
Assign Table->Options->Advanced

https://www.geniusconnec...lderAdvancedOptions.html 
NewItem8.png

Click to View Image26 View(s)

Brudertac
2008-08-19T12:41:00Z
Conflict Resolution is on. (newest wins)
But shouldn´t the UPDATE Statement work so that this "Warning" will not come again on this Item ?
The Timeout says that the Update is not done.
Administrator
2008-08-19T12:45:00Z
When you get time out, update fails, so same conflict occurs on next Load
Brudertac
2008-08-19T13:00:00Z
Yes. Thats right.
Brudertac
2008-08-21T08:39:00Z
Any News on this ?
Administrator
2008-08-21T11:12:00Z
On what? the Timeout ? You have to check your database/datamodel. You table can be locked?
Brudertac
2008-08-21T11:53:00Z
I don´t think that there is a general Problem.
Insert and Delete works fine.
(And Updates too)

Update:
I did some tests...

Press "Load All" gives on some Items the Timeout error. (every Time i use Load All those Items have this error.)

Now i open one of those Items in Outlook for some changes.
GeniusConnect see the change (Autosave on Outlook change is ON) AND Update the Database Record without any error.
This is exactly what it should do on "Load All".

So is this a Bug or is something wrong here ?

Thanks again.
Administrator
2008-08-21T13:51:00Z
There is no known bug related to timeouts, what is your time out setting?
Brudertac
2008-08-21T14:15:00Z
Timeout was set to 30 Seconds. I have increased it to 60 Seconds but this doesn´t help...
Administrator
2008-08-21T16:08:00Z
Can you send us your DB (scripted) and your settings (Assign Table->Export)
Brudertac
2008-08-21T16:32:00Z
Sure, i will send you a PM.

EDIT: PM is bad, i will send an eMail to
TechSupport@geniusconnect.com.

thx