Author Topic: Can't update record from PlayBook  (Read 3456 times)

Weeno IT

  • Newbie
  • *
  • Posts: 6
    • View Profile
Can't update record from PlayBook
« on: April 10, 2012, 02:41:47 PM »
We are hoping that this software is the answer to all of our problems, although the sync only seems to work from the computer to the PlayBook and not the other way around.

If we update the record on the PlayBook after some time the record turns red and gives an error message in the 'View Status' screen.

I have copied this error message from the SyncServiceBackSyncLog file.

We get the following:

<22:26:54> <1> start ThreadprocForBackSync
<22:26:54> <0> Start CheckAppRegEvaluation().
<22:26:54> <0> End CheckAppRegEvaluation().
<22:26:54> <0> Start Interval For Back Sync.
<22:26:54> <1> start Process Ack From Desktop Table
<22:26:54> <1>  End Process Ack From Desktop Table
<22:26:54> <1> start Process For Back Sync
<22:26:54> <-1> CItnernetSession::GetHttpConnection() Success.
<22:26:54> <-1> CHttpConnection::OpenRequest() Success.
<22:26:55> <-1> CHttpFile::SendRequest() Success.
<22:26:55> <-1> Length of file : 793
<22:26:55> <-1> Number of bytes read = 1930
<22:26:55> <89> In GetDataForDesktop, B64Length : 1560.
<22:26:55> <90> In GetDataForDesktop, DLength : 1170.
<22:26:55> <73> In MessType Loop, MsgType = 4.
<22:26:55> <74> In Record ADD/Update, nProfileID = 11.
<22:26:55> <-1> In Record Add/Update, nRecordSource : 1, nRecordIndex : 56.
<22:26:55> <76> In Record Add/Update, Read Record.
<22:26:55> <79> In Record Add/Update, recDataLen = 1090.
<22:26:55> <80> In Record Add/Update, Read Record Data.
<22:26:55> <-1> In Record Add/Update, DeviceID : 501AECA2
<22:26:55> <-1> Column Name "ID" (Column No 1) is AutoNumber.
<22:26:56> <-1> In Record Update, RecordSource : 1 & RecordIndex : 56
<22:26:56> <14> Failed to update Record with key .SQLSTATE:HY000
 Native Error Code:-20169
 Driver Message:=' [Microsoft][ODBC Microsoft Access Driver] You cannot modify the replication system object 's_GUID'. '

<22:26:56> <92> In AckFromDesktop, OLength : 410.
<22:26:56> <84> In AckFromDesktop, ELength : 416.
<22:26:56> <94> In AckFromDesktop, B64Length : 624.
<22:26:56> <-1> CItnernetSession::GetHttpConnection() Success.
<22:26:56> <-1> CHttpConnection::OpenRequest() Success.
<22:26:56> <-1> CHttpFile::SendRequest() Success.
<22:26:56> <-1> Length of file : 369
<22:26:56> <-1> Number of bytes read = 369
<22:26:57> <64> In AckFromDesktop, Send Request Result : ***1|2|XXX|
<22:26:57> <1> End Process For Back Sync
<22:26:57> <1> End Interval For Back Sync.

Please help!

CellicaTeam

  • Administrator
  • Hero Member
  • *****
  • Posts: 693
    • View Profile
Re: Can't update record from PlayBook
« Reply #1 on: April 10, 2012, 08:54:45 PM »
Log shows that you have s_GUID column datatype. Please edit that profile in Profile Manager in Desktop Application and uncheck s_GUID column. GUID column does not support updating the record.

Once you remove this column, try to update data from PlayBook.

Weeno IT

  • Newbie
  • *
  • Posts: 6
    • View Profile
Re: Can't update record from PlayBook
« Reply #2 on: April 11, 2012, 01:37:29 AM »
Thank you very much for your reply.

We will try this today and let you know if it works.


Weeno IT

  • Newbie
  • *
  • Posts: 6
    • View Profile
Re: Can't update record from PlayBook
« Reply #3 on: April 11, 2012, 01:50:34 AM »
We made the change, but unfortunately it still doesn't work.

We now get the following error:

<09:49:09> <1> start ThreadprocForBackSync
<09:49:09> <0> Start CheckAppRegEvaluation().
<09:49:09> <0> End CheckAppRegEvaluation().
<09:49:09> <0> Start Interval For Back Sync.
<09:49:09> <1> start Process Ack From Desktop Table
<09:49:09> <1>  End Process Ack From Desktop Table
<09:49:10> <1> start Process For Back Sync
<09:49:10> <-1> CItnernetSession::GetHttpConnection() Success.
<09:49:10> <-1> CHttpConnection::OpenRequest() Success.
<09:49:10> <-1> CHttpFile::SendRequest() Success.
<09:49:10> <-1> Length of file : 793
<09:49:10> <-1> Number of bytes read = 1846
<09:49:10> <89> In GetDataForDesktop, B64Length : 1476.
<09:49:10> <90> In GetDataForDesktop, DLength : 1106.
<09:49:10> <73> In MessType Loop, MsgType = 4.
<09:49:11> <74> In Record ADD/Update, nProfileID = 14.
<09:49:11> <-1> In Record Add/Update, nRecordSource : 1, nRecordIndex : 56.
<09:49:11> <76> In Record Add/Update, Read Record.
<09:49:11> <79> In Record Add/Update, recDataLen = 1024.
<09:49:11> <80> In Record Add/Update, Read Record Data.
<09:49:11> <-1> In Record Add/Update, DeviceID : 501AECA2
<09:49:11> <-1> Column Name "ID" (Column No 1) is AutoNumber.
<09:49:11> <-1> In Record Update, RecordSource : 1 & RecordIndex : 56
<09:49:11> <14> Failed to update Record with key .SQLSTATE:HY000
 Native Error Code:-20169
 Driver Message:=' [Microsoft][ODBC Microsoft Access Driver] You cannot modify the replication system object 'Gen_TempField*0'. '

<09:49:11> <92> In AckFromDesktop, OLength : 428.
<09:49:11> <84> In AckFromDesktop, ELength : 448.
<09:49:12> <94> In AckFromDesktop, B64Length : 664.
<09:49:12> <-1> CItnernetSession::GetHttpConnection() Success.
<09:49:12> <-1> CHttpConnection::OpenRequest() Success.
<09:49:12> <-1> CHttpFile::SendRequest() Success.
<09:49:12> <-1> Length of file : 369
<09:49:12> <-1> Number of bytes read = 369
<09:49:12> <64> In AckFromDesktop, Send Request Result : ***1|2|XXX|
<09:49:12> <1> End Process For Back Sync
<09:49:12> <1> End Interval For Back Sync.

Weeno IT

  • Newbie
  • *
  • Posts: 6
    • View Profile
Re: Can't update record from PlayBook
« Reply #4 on: April 11, 2012, 02:06:09 AM »
Additionally, we see the following within the DesktopLog

<10:04:47> <0> Threadproc start
<10:04:47> <0> Start Change Detection Interval.
<10:04:47> <0> Start Process Profile Changes
<10:04:47> <0> End Process Profile Changes
<10:04:47> <0> Start Process New Profiles
<10:04:47> <0> End Process New Profiles
<10:04:47> <0> Start Process Profile Finish
<10:04:47> <0> End Process Profile Finish
<10:04:47> <0> Start Process Record Changes
<10:04:47> <41> Profile BBHOUSEKEEPERTOCUSTOMER with ProfileID 16 is to Process for DBChange.
<10:04:47> <54> Failed to Connect User's Profile Database.Failed to connect to database.

ODBC Reports :

 SQLSTATE:IM002
 Native Error Code:0
 Driver Message:=' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified '
<10:04:47> <41> Profile MaidsinWaitingclientTable with ProfileID 17 is to Process for DBChange.
<10:04:47> <54> Failed to Connect User's Profile Database.Failed to connect to database.

ODBC Reports :

 SQLSTATE:IM002
 Native Error Code:0
 Driver Message:=' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified '
<10:04:47> <41> Profile HKINFO with ProfileID 18 is to Process for DBChange.
<10:04:47> <54> Failed to Connect User's Profile Database.Failed to connect to database.

ODBC Reports :

 SQLSTATE:IM002
 Native Error Code:0
 Driver Message:=' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified '
<10:04:48> <0> End Process Record Changes
<10:04:48> <0> Start Process Form Changes
<10:04:48> <0> End Process Form Changes
<10:04:48> <0> Start Process New Forms
<10:04:48> <0> End Process New Forms
<10:04:48> <0> Start Process Form Finish
<10:04:48> <0> End Process Form Finish
<10:04:48> <1> End Change Detection Interval.

CellicaTeam

  • Administrator
  • Hero Member
  • *****
  • Posts: 693
    • View Profile
Re: Can't update record from PlayBook
« Reply #5 on: April 11, 2012, 03:00:48 AM »
 Log shows that you have s_Generation, s_GUID and s_Lineage column datatype. Please edit that profile in Profile Manager in Desktop Application and uncheck s_Generation, s_GUID and s_Lineage columns.  These not support updating the record.

Once you remove these column, try to update data from PlayBook.

Weeno IT

  • Newbie
  • *
  • Posts: 6
    • View Profile
Re: Can't update record from PlayBook
« Reply #6 on: April 11, 2012, 03:47:56 AM »
Thank you for your continued support.

To simplify the situation, I created a brand new database with just a couple of records.

I was able to sync in both directions without any problem.

That shows that the only problem is with our main database and the way it has been written/used.

Would you be prepared to try to get it working with us? We have tried all of your suggestions so far but it hasn't worked.

Weeno IT

  • Newbie
  • *
  • Posts: 6
    • View Profile
Re: Can't update record from PlayBook
« Reply #7 on: April 11, 2012, 04:04:16 AM »
SOLVED!

We unchecked additional fields that were being flagged in the error logs.

Sync now works with our main database in both directions.

Thank you for your help.

 ;D ;D ;D ;D