|
When putting together a brain-dead-simple demo using the Version 12 demo database, with one new row inserted into each and every table in a fresh empty copy of a remote database generated by the MobiLink Model, the first sync threw a referential integrity error when processing one of the upload_inserts. The second attempt to sync DID work after I put this statement in the begin_connection event: SET TEMPORARY OPTION WAIT_FOR_COMMIT = 'ON'; Volker: Is this a behavior change, too? :) Here is most of the MobiLink server log for failed sync... I. 2011-03-08 10:25:49. SQL Anywhere MobiLink Server Version 12.0.1.3152
I. 2011-03-08 10:25:49.
I. 2011-03-08 10:25:49. Copyright © 2001-2011, iAnywhere Solutions, Inc.
I. 2011-03-08 10:25:49. Portions copyright © 1988-2011, Sybase, Inc. All rights reserved.
I. 2011-03-08 10:25:49. Use of this software is governed by the Sybase License Agreement.
I. 2011-03-08 10:25:49. Refer to http://www.sybase.com/softwarelicenses.
I. 2011-03-08 10:25:49.
I. 2011-03-08 10:25:49. This server is licensed to:
I. 2011-03-08 10:25:49. Developer Edition
I. 2011-03-08 10:25:49. Restricted Use
I. 2011-03-08 10:25:49. Running Windows 7 Build 7600 on X86_64
I. 2011-03-08 10:25:49. Server built for X86_64 processor architecture
I. 2011-03-08 10:25:49. Option 1: -c
I. 2011-03-08 10:25:49. Option 2: DRIVER=SQL Anywhere 12;ENG=demo;DBN=demo;UID=dba;pwd=********
I. 2011-03-08 10:25:49. Option 3: -o
I. 2011-03-08 10:25:49. Option 4: mlsrv12_log_demo.txt
I. 2011-03-08 10:25:49. Option 5: -os
I. 2011-03-08 10:25:49. Option 6: 10M
I. 2011-03-08 10:25:49. Option 7: -ppv
I. 2011-03-08 10:25:49. Option 8: 60
I. 2011-03-08 10:25:49. Option 9: -vcefhkmnopstuU
I. 2011-03-08 10:25:49. Option 10: -zu+
I. 2011-03-08 10:25:49. Verbose logging: show script names when invoked
I. 2011-03-08 10:25:49. Verbose logging: show script contents when invoked
I. 2011-03-08 10:25:49. Verbose logging: show schema for each table
I. 2011-03-08 10:25:49. Verbose logging: show an error when the first read of a synchronization fails
I. 2011-03-08 10:25:49. Verbose logging: show translated SQL for prepared statements
I. 2011-03-08 10:25:49. Verbose logging: show rowcount values
I. 2011-03-08 10:25:49. Cache size: 52428800 bytes
I. 2011-03-08 10:25:49. Download cache directory size: 10485760 bytes
I. 2011-03-08 10:25:49. Local file for remote synchronization logs: 'mlsrv.mle'
I. 2011-03-08 10:25:49. Starting cache sizes: min of 52428800 bytes; max of 5961467904 bytes; initial size of 52064256 bytes
I. 2011-03-08 10:25:49. Individual database connections will be closed after synchronization errors
I. 2011-03-08 10:25:49. Maximum number of BLOB bytes to compare: 4294967295
I. 2011-03-08 10:25:49. Maximum number of database connections: 5
I. 2011-03-08 10:25:49. Maximum number of deadlock retries: 10
I. 2011-03-08 10:25:49. Timeout for inactive database connections: 60 minutes
I. 2011-03-08 10:25:49. Maximum delay between retries after deadlock: 30 seconds
I. 2011-03-08 10:25:49. Rowset size: 10
I. 2011-03-08 10:25:49. Number of database worker threads: 5
W. 2011-03-08 10:25:49. [10064] Unknown users will be added automatically (when there is no authenticate_user script)
I. 2011-03-08 10:25:49. Shared administrative connection connected
I. 2011-03-08 10:25:49. ODBC DBMS Name: SQL Anywhere
I. 2011-03-08 10:25:49. ODBC DBMS Version: 12.00.0001
I. 2011-03-08 10:25:49. ODBC DBMS Driver Version: 12.00.0001
I. 2011-03-08 10:25:49. ODBC Version supported by the driver: 3.52
I. 2011-03-08 10:25:49. Collation sequence of the consolidated database is 'windows-1252'
I. 2011-03-08 10:25:49. System event on shared administrative connection:
select db_property( 'Capabilities' )
I. 2011-03-08 10:25:49. Translated SQL:
select db_property( 'Capabilities' )
I. 2011-03-08 10:25:49. ODBC DBMS Type: SQL Anywhere
I. 2011-03-08 10:25:49. System event on shared administrative connection:
set temporary option chained = 'ON'
I. 2011-03-08 10:25:49. Translated SQL:
set temporary option chained = 'ON'
I. 2011-03-08 10:25:49. System event on shared administrative connection:
set temporary option st_geometry_asbinary_format = 'WKB( endian=little )'
I. 2011-03-08 10:25:49. Translated SQL:
set temporary option st_geometry_asbinary_format = 'WKB( endian=little )'
I. 2011-03-08 10:25:49. ODBC isolation set to: Read Committed
...
I. 2011-03-08 10:25:57. (,1) COMMIT Transaction: begin_synchronization
I. 2011-03-08 10:25:57. (,1) System event on synchronization connection:
{ CALL ml_lock_rid( ?, ?, ? ) }
I. 2011-03-08 10:25:57. (,1) Translated SQL:
CALL ml_lock_rid( ?, ?, ? )
I. 2011-03-08 10:25:57. (,1) begin_upload (no script)
I. 2011-03-08 10:25:57. (,1) begin_upload SpatialShapes (no script)
I. 2011-03-08 10:25:57. (,1) begin_upload SpatialContacts (no script)
I. 2011-03-08 10:25:57. (,1) begin_upload SalesOrders (no script)
I. 2011-03-08 10:25:57. (,1) begin_upload SalesOrderItems (no script)
I. 2011-03-08 10:25:57. (,1) begin_upload Products (no script)
I. 2011-03-08 10:25:57. (,1) begin_upload MarketingInformation (no script)
I. 2011-03-08 10:25:57. (,1) begin_upload FinancialData (no script)
I. 2011-03-08 10:25:57. (,1) begin_upload FinancialCodes (no script)
I. 2011-03-08 10:25:57. (,1) begin_upload Employees (no script)
I. 2011-03-08 10:25:57. (,1) begin_upload Departments (no script)
I. 2011-03-08 10:25:57. (,1) begin_upload Customers (no script)
I. 2011-03-08 10:25:57. (,1) begin_upload Contacts (no script)
I. 2011-03-08 10:25:57. (,1) handle_UploadData (no script)
I. 2011-03-08 10:25:57. (,1) begin_upload_rows SpatialShapes (no script)
I. 2011-03-08 10:25:57. (,1) upload_insert SpatialShapes
/* Insert the row into the consolidated database. */ INSERT INTO "GROUPO"."SpatialShapes" ( "ShapeID", "Description", "Shape" ) VALUES ( {ml r."ShapeID"}, {ml r."Description"}, ST_Geometry::ST_GeomFromBinary( {ml r."Shape":data}, {ml r."Shape":srid} ) )
I. 2011-03-08 10:25:57. (,1) Translated SQL:
INSERT INTO "GROUPO"."SpatialShapes" ( "ShapeID", "Description", "Shape" ) VALUES ( ?, ?, ST_Geometry::ST_GeomFromBinary( ?, ? ) )
I. 2011-03-08 10:25:57. (,1) end_upload_rows SpatialShapes (no script)
I. 2011-03-08 10:25:57. (,1) begin_upload_rows SpatialContacts (no script)
I. 2011-03-08 10:25:57. (,1) System event on synchronization connection:
savepoint it1
I. 2011-03-08 10:25:57. (,1) Translated SQL:
savepoint it1
I. 2011-03-08 10:25:57. (,1) upload_insert SpatialContacts
/* Insert the row into the consolidated database. */ INSERT INTO "GROUPO"."SpatialContacts" ( "ID", "Surname", "GivenName", "Street", "City", "State", "Country", "PostalCode" ) VALUES ( {ml r."ID"}, {ml r."Surname"}, {ml r."GivenName"}, {ml r."Street"}, {ml r."City"}, {ml r."State"}, {ml r."Country"}, {ml r."PostalCode"} )
I. 2011-03-08 10:25:57. (,1) Translated SQL:
INSERT INTO "GROUPO"."SpatialContacts" ( "ID", "Surname", "GivenName", "Street", "City", "State", "Country", "PostalCode" ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ? )
I. 2011-03-08 10:25:57. (,1) System event on synchronization connection:
release savepoint it1
I. 2011-03-08 10:25:57. (,1) Translated SQL:
release savepoint it1
I. 2011-03-08 10:25:57. (,1) end_upload_rows SpatialContacts (no script)
I. 2011-03-08 10:25:57. (,1) begin_upload_rows SalesOrders (no script)
I. 2011-03-08 10:25:57. (,1) System event on synchronization connection:
savepoint it2
I. 2011-03-08 10:25:57. (,1) Translated SQL:
savepoint it2
I. 2011-03-08 10:25:57. (,1) upload_insert SalesOrders
/* Insert the row into the consolidated database. */ INSERT INTO "GROUPO"."SalesOrders" ( "ID", "CustomerID", "OrderDate", "FinancialCode", "Region", "SalesRepresentative" ) VALUES ( {ml r."ID"}, {ml r."CustomerID"}, {ml r."OrderDate"}, {ml r."FinancialCode"}, {ml r."Region"}, {ml r."SalesRepresentative"} )
I. 2011-03-08 10:25:57. (,1) Translated SQL:
INSERT INTO "GROUPO"."SalesOrders" ( "ID", "CustomerID", "OrderDate", "FinancialCode", "Region", "SalesRepresentative" ) VALUES ( ?, ?, ?, ?, ?, ? )
E. 2011-03-08 10:25:57. (,1) [-10002] Consolidated database server or ODBC error: ODBC: [Sybase][ODBC Driver][SQL Anywhere]No primary key value for foreign key 'FK_CustomerID_ID' in table 'SalesOrders' (ODBC State = 23000, Native error code = -194)
I. 2011-03-08 10:25:57. (,1) System event on synchronization connection:
rollback to savepoint it2
I. 2011-03-08 10:25:57. (,1) Translated SQL:
rollback to savepoint it2
W. 2011-03-08 10:25:57. (,1) [10039] Error detected during multi-row operation, performing rollback before retrying in single row mode
I. 2011-03-08 10:25:57. (,1) upload_insert SalesOrders
/* Insert the row into the consolidated database. */ INSERT INTO "GROUPO"."SalesOrders" ( "ID", "CustomerID", "OrderDate", "FinancialCode", "Region", "SalesRepresentative" ) VALUES ( {ml r."ID"}, {ml r."CustomerID"}, {ml r."OrderDate"}, {ml r."FinancialCode"}, {ml r."Region"}, {ml r."SalesRepresentative"} )
I. 2011-03-08 10:25:57. (,1) Translated SQL:
INSERT INTO "GROUPO"."SalesOrders" ( "ID", "CustomerID", "OrderDate", "FinancialCode", "Region", "SalesRepresentative" ) VALUES ( ?, ?, ?, ?, ?, ? )
E. 2011-03-08 10:25:57. (,1) [-10002] Consolidated database server or ODBC error: ODBC: [Sybase][ODBC Driver][SQL Anywhere]No primary key value for foreign key 'FK_CustomerID_ID' in table 'SalesOrders' (ODBC State = 23000, Native error code = -194)
E. 2011-03-08 10:25:57. (,1) [-10072] Unable to insert into table 'SalesOrders' using upload_insert
I. 2011-03-08 10:25:57. (,1) Error Context:
I. 2011-03-08 10:25:57. (,1) Remote ID: a9f48827-4ac0-4dc4-aa32-54792611eeb3
I. 2011-03-08 10:25:57. (,1) User Name: 1
I. 2011-03-08 10:25:57. (,1) Modified User Name: 1
I. 2011-03-08 10:25:57. (,1) Transaction: upload
I. 2011-03-08 10:25:57. (,1) Table Name: SalesOrders
I. 2011-03-08 10:25:57. (,1) Insert Row:
I. 2011-03-08 10:25:57. (,1) 99
I. 2011-03-08 10:25:57. (,1) 99
I. 2011-03-08 10:25:57. (,1) 2011-03-08
I. 2011-03-08 10:25:57. (,1) x
I. 2011-03-08 10:25:57. (,1) x
I. 2011-03-08 10:25:57. (,1) 99
I. 2011-03-08 10:25:57. (,1) Script Version: v1
I. 2011-03-08 10:25:57. (,1) Script: /* Insert the row into the consolidated database. */ INSERT INTO "GROUPO"."SalesOrders" ( "ID", "CustomerID", "OrderDate", "FinancialCode", "Region", "SalesRepresentative" ) VALUES ( {ml r."ID"}, {ml r."CustomerID"}, {ml r."OrderDate"}, {ml r."FinancialCode"}, {ml r."Region"}, {ml r."SalesRepresentative"} )
I. 2011-03-08 10:25:57. (,1) End of Error Context
I. 2011-03-08 10:25:57. (,1) handle_error (no script)
I. 2011-03-08 10:25:57. (,1) report_error (no script)
I. 2011-03-08 10:25:57. (,1) handle_odbc_error (no script)
I. 2011-03-08 10:25:57. (,1) report_odbc_error (no script)
W. 2011-03-08 10:25:57. (,1) [10010] No handle_error script is defined. The default action code (3000) will decide the error behavior
E. 2011-03-08 10:25:57. (,1) [-10061] An error occurred while uploading an insert row into table 'SalesOrders'. The inserted column values are as follows:
I. 2011-03-08 10:25:57. (,1) end_upload_rows SalesOrders (no script)
I. 2011-03-08 10:25:57. (,1) end_upload SpatialShapes (no script)
I. 2011-03-08 10:25:57. (,1) end_upload SpatialContacts (no script)
I. 2011-03-08 10:25:57. (,1) end_upload SalesOrders (no script)
I. 2011-03-08 10:25:57. (,1) end_upload SalesOrderItems (no script)
I. 2011-03-08 10:25:57. (,1) end_upload Products (no script)
I. 2011-03-08 10:25:57. (,1) end_upload MarketingInformation (no script)
I. 2011-03-08 10:25:57. (,1) end_upload FinancialData (no script)
I. 2011-03-08 10:25:57. (,1) end_upload FinancialCodes (no script)
I. 2011-03-08 10:25:57. (,1) end_upload Employees (no script)
I. 2011-03-08 10:25:57. (,1) end_upload Departments (no script)
I. 2011-03-08 10:25:57. (,1) end_upload Customers (no script)
I. 2011-03-08 10:25:57. (,1) end_upload Contacts (no script)
I. 2011-03-08 10:25:57. (,1) end_upload (no script)
I. 2011-03-08 10:25:57. (,1) ROLLBACK Transaction: end_upload
...
|
|
My fault... I never expected the demo database would include a schema curiosity that breaks MobiLink, but here it is (from the MobiLink client log)... I. 2011-03-08 10:25:56. Cycle of foreign key references found. Cannot guarantee referential integrity during upload. I. 2011-03-08 10:25:56. Tables involved in cycle: I. 2011-03-08 10:25:56. GROUPO.Employees I. 2011-03-08 10:25:56. GROUPO.Departments Sooooo... putting SET TEMPORARY OPTION WAIT_FOR_COMMIT = 'ON' into the begin_connection script on the MobiLink server side does seem like the simplest solution (manually setting the table order has never worked for me). Here is the full MobiLink client log... I. 2011-03-08 10:25:55. SQL Anywhere MobiLink Client Version 12.0.1.3152 I. 2011-03-08 10:25:55. I. 2011-03-08 10:25:55. Copyright © 2001-2011, iAnywhere Solutions, Inc. I. 2011-03-08 10:25:55. Portions copyright © 1988-2011, Sybase, Inc. All rights reserved. I. 2011-03-08 10:25:55. Use of this software is governed by the Sybase License Agreement. I. 2011-03-08 10:25:55. Refer to http://www.sybase.com/softwarelicenses. I. 2011-03-08 10:25:55. I. 2011-03-08 10:25:55. 1: -c I. 2011-03-08 10:25:55. 2: *********************************************** I. 2011-03-08 10:25:55. 3: -e I. 2011-03-08 10:25:55. 4: adr='host=localhost';sv=v1 I. 2011-03-08 10:25:55. 5: -o I. 2011-03-08 10:25:55. 6: dbmlsync_log_demo_remote.txt I. 2011-03-08 10:25:55. 7: -os I. 2011-03-08 10:25:55. 8: 10M I. 2011-03-08 10:25:55. 9: -vnosu I. 2011-03-08 10:25:55. 10: -x I. 2011-03-08 10:25:55. Connecting to remote database I. 2011-03-08 10:25:55. Loading synchronization information I. 2011-03-08 10:25:55. Begin synchronizing subscription(s) 'demo_1' I. 2011-03-08 10:25:55. Options for this synchronization: I. 2011-03-08 10:25:55. SV=v1,CTP=TCPIP,ADR='host=localhost' I. 2011-03-08 10:25:55. Log scan starting at offset 0000551330 I. 2011-03-08 10:25:55. Processing transaction logs from directory "C:\$ blogs and websites\blog SQLAnywhere\20110309 Celebrating STRING, LIST and UNLOAD\MobiLink demo 12\" I. 2011-03-08 10:25:55. Processing transactions from active transaction log I. 2011-03-08 10:25:55. Transaction log renamed to: 110308AA.LOG I. 2011-03-08 10:25:56. Processing transaction logs from directory "C:\$ blogs and websites\blog SQLAnywhere\20110309 Celebrating STRING, LIST and UNLOAD\MobiLink demo 12\" I. 2011-03-08 10:25:56. Processing transactions from active transaction log I. 2011-03-08 10:25:56. Hovering at end of active log I. 2011-03-08 10:25:56. Log scan ended at offset 0000558002 I. 2011-03-08 10:25:56. Cycle of foreign key references found. Cannot guarantee referential integrity during upload. I. 2011-03-08 10:25:56. Tables involved in cycle: I. 2011-03-08 10:25:56. GROUPO.Employees I. 2011-03-08 10:25:56. GROUPO.Departments I. 2011-03-08 10:25:56. Connecting to MobiLink server at 'host=localhost' using 'TCPIP' I. 2011-03-08 10:25:56. Begin upload I. 2011-03-08 10:25:56. Character set: windows-1252 I. 2011-03-08 10:25:56. MobiLink user name: 1 I. 2011-03-08 10:25:56. Script version: v1 I. 2011-03-08 10:25:56. Remote ID: a9f48827-4ac0-4dc4-aa32-54792611eeb3 I. 2011-03-08 10:25:56. Subscription 'demo_1' - Synchronizing - Log offset 0000551330 - Last download time 1900-01-01 00:00:00.0. I. 2011-03-08 10:25:56. Subscription 'demo_1' has never been synchronized. Progress offsets will not be checked. I. 2011-03-08 10:25:56. Processor is little-endian I. 2011-03-08 10:25:56. Article table: SpatialShapes I. 2011-03-08 10:25:56. Article column: integer ShapeID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:56. Article column: char Description(32) NULL I. 2011-03-08 10:25:56. Article column: st_geometry Shape NULL I. 2011-03-08 10:25:56. Article table: SpatialContacts I. 2011-03-08 10:25:56. Article column: integer ID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:56. Article column: char Surname(20) NOT NULL I. 2011-03-08 10:25:56. Article column: char GivenName(20) NOT NULL I. 2011-03-08 10:25:56. Article column: char Street(30) NOT NULL I. 2011-03-08 10:25:56. Article column: char City(20) NOT NULL I. 2011-03-08 10:25:56. Article column: char State(16) NULL I. 2011-03-08 10:25:56. Article column: char Country(16) NULL I. 2011-03-08 10:25:56. Article column: char PostalCode(10) NULL I. 2011-03-08 10:25:56. Article table: SalesOrders I. 2011-03-08 10:25:56. Article column: integer ID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:56. Article column: integer CustomerID NOT NULL I. 2011-03-08 10:25:56. Article column: date OrderDate NOT NULL I. 2011-03-08 10:25:56. Article column: char FinancialCode(2) NULL I. 2011-03-08 10:25:56. Article column: char Region(7) NULL I. 2011-03-08 10:25:56. Article column: integer SalesRepresentative NOT NULL I. 2011-03-08 10:25:56. Article table: SalesOrderItems I. 2011-03-08 10:25:56. Article column: integer ID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:56. Article column: smallint LineID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:56. Article column: integer ProductID NOT NULL I. 2011-03-08 10:25:56. Article column: integer Quantity NOT NULL I. 2011-03-08 10:25:56. Article column: date ShipDate NOT NULL I. 2011-03-08 10:25:56. Article table: Products I. 2011-03-08 10:25:56. Article column: integer ID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:56. Article column: char Name(15) NOT NULL I. 2011-03-08 10:25:56. Article column: char Description(30) NOT NULL I. 2011-03-08 10:25:56. Article column: char Size(18) NOT NULL I. 2011-03-08 10:25:56. Article column: char Color(18) NOT NULL I. 2011-03-08 10:25:56. Article column: integer Quantity NOT NULL I. 2011-03-08 10:25:56. Article column: numeric UnitPrice(15,2) NOT NULL I. 2011-03-08 10:25:56. Article column: long binary Photo NULL I. 2011-03-08 10:25:56. Article table: MarketingInformation I. 2011-03-08 10:25:56. Article column: integer ID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:56. Article column: integer ProductID NOT NULL I. 2011-03-08 10:25:56. Article column: long varchar Description NULL I. 2011-03-08 10:25:56. Article table: FinancialData I. 2011-03-08 10:25:56. Article column: char Year(4) NOT NULL PRIMARY KEY I. 2011-03-08 10:25:56. Article column: char Quarter(2) NOT NULL PRIMARY KEY I. 2011-03-08 10:25:56. Article column: char Code(2) NOT NULL PRIMARY KEY I. 2011-03-08 10:25:56. Article column: numeric Amount(9,0) NULL I. 2011-03-08 10:25:56. Article table: FinancialCodes I. 2011-03-08 10:25:56. Article column: char Code(2) NOT NULL PRIMARY KEY I. 2011-03-08 10:25:56. Article column: char Type(10) NOT NULL I. 2011-03-08 10:25:56. Article column: char Description(50) NULL I. 2011-03-08 10:25:56. Article table: Employees I. 2011-03-08 10:25:56. Article column: integer EmployeeID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:56. Article column: integer ManagerID NULL I. 2011-03-08 10:25:56. Article column: char Surname(20) NOT NULL I. 2011-03-08 10:25:56. Article column: char GivenName(20) NOT NULL I. 2011-03-08 10:25:56. Article column: integer DepartmentID NOT NULL I. 2011-03-08 10:25:56. Article column: char Street(30) NOT NULL I. 2011-03-08 10:25:56. Article column: char City(20) NOT NULL I. 2011-03-08 10:25:56. Article column: char State(16) NULL I. 2011-03-08 10:25:56. Article column: char Country(16) NULL I. 2011-03-08 10:25:56. Article column: char PostalCode(10) NULL I. 2011-03-08 10:25:56. Article column: char Phone(13) NULL I. 2011-03-08 10:25:56. Article column: char Status(2) NULL I. 2011-03-08 10:25:56. Article column: char SocialSecurityNumber(11) NULL I. 2011-03-08 10:25:56. Article column: numeric Salary(20,3) NOT NULL I. 2011-03-08 10:25:56. Article column: date StartDate NOT NULL I. 2011-03-08 10:25:56. Article column: date TerminationDate NULL I. 2011-03-08 10:25:56. Article column: date BirthDate NULL I. 2011-03-08 10:25:56. Article column: bit BenefitHealthInsurance NULL I. 2011-03-08 10:25:56. Article column: bit BenefitLifeInsurance NULL I. 2011-03-08 10:25:56. Article column: bit BenefitDayCare NULL I. 2011-03-08 10:25:56. Article column: char Sex(2) NULL I. 2011-03-08 10:25:56. Article table: Departments I. 2011-03-08 10:25:56. Article column: integer DepartmentID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:56. Article column: char DepartmentName(40) NOT NULL I. 2011-03-08 10:25:56. Article column: integer DepartmentHeadID NULL I. 2011-03-08 10:25:56. Article table: Customers I. 2011-03-08 10:25:56. Article column: integer ID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:56. Article column: char Surname(20) NOT NULL I. 2011-03-08 10:25:56. Article column: char GivenName(20) NOT NULL I. 2011-03-08 10:25:56. Article column: char Street(30) NOT NULL I. 2011-03-08 10:25:56. Article column: char City(20) NOT NULL I. 2011-03-08 10:25:56. Article column: char State(16) NULL I. 2011-03-08 10:25:56. Article column: char Country(16) NULL I. 2011-03-08 10:25:56. Article column: char PostalCode(10) NULL I. 2011-03-08 10:25:56. Article column: char Phone(13) NOT NULL I. 2011-03-08 10:25:56. Article column: char CompanyName(32) NULL I. 2011-03-08 10:25:56. Article table: Contacts I. 2011-03-08 10:25:56. Article column: integer ID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:56. Article column: char Surname(20) NOT NULL I. 2011-03-08 10:25:56. Article column: char GivenName(20) NOT NULL I. 2011-03-08 10:25:56. Article column: varchar Title(34) NULL I. 2011-03-08 10:25:56. Article column: char Street(30) NULL I. 2011-03-08 10:25:56. Article column: char City(20) NULL I. 2011-03-08 10:25:56. Article column: char State(16) NULL I. 2011-03-08 10:25:56. Article column: char Country(16) NULL I. 2011-03-08 10:25:56. Article column: char PostalCode(10) NULL I. 2011-03-08 10:25:56. Article column: char Phone(13) NULL I. 2011-03-08 10:25:56. Article column: char Fax(13) NULL I. 2011-03-08 10:25:56. Article column: integer CustomerID NULL I. 2011-03-08 10:25:56. Table Upload Order: SpatialShapes,SpatialContacts,SalesOrders,SalesOrderItems,Products,MarketingInformation,FinancialData,FinancialCodes,Employees,Departments,Customers,Contacts I. 2011-03-08 10:25:56. Uploading table operations I. 2011-03-08 10:25:56. # rows inserted in table SpatialShapes : 1 I. 2011-03-08 10:25:56. # rows deleted in table SpatialShapes : 0 I. 2011-03-08 10:25:56. # rows updated in table SpatialShapes : 0 I. 2011-03-08 10:25:56. # rows inserted in table SpatialContacts : 1 I. 2011-03-08 10:25:56. # rows deleted in table SpatialContacts : 0 I. 2011-03-08 10:25:56. # rows updated in table SpatialContacts : 0 I. 2011-03-08 10:25:56. # rows inserted in table SalesOrders : 1 I. 2011-03-08 10:25:56. # rows deleted in table SalesOrders : 0 I. 2011-03-08 10:25:56. # rows updated in table SalesOrders : 0 I. 2011-03-08 10:25:56. # rows inserted in table SalesOrderItems : 1 I. 2011-03-08 10:25:56. # rows deleted in table SalesOrderItems : 0 I. 2011-03-08 10:25:56. # rows updated in table SalesOrderItems : 0 I. 2011-03-08 10:25:56. # rows inserted in table Products : 1 I. 2011-03-08 10:25:56. # rows deleted in table Products : 0 I. 2011-03-08 10:25:56. # rows updated in table Products : 0 I. 2011-03-08 10:25:56. # rows inserted in table MarketingInformation : 1 I. 2011-03-08 10:25:56. # rows deleted in table MarketingInformation : 0 I. 2011-03-08 10:25:56. # rows updated in table MarketingInformation : 0 I. 2011-03-08 10:25:56. # rows inserted in table FinancialData : 1 I. 2011-03-08 10:25:56. # rows deleted in table FinancialData : 0 I. 2011-03-08 10:25:56. # rows updated in table FinancialData : 0 I. 2011-03-08 10:25:56. # rows inserted in table FinancialCodes : 1 I. 2011-03-08 10:25:56. # rows deleted in table FinancialCodes : 0 I. 2011-03-08 10:25:56. # rows updated in table FinancialCodes : 0 I. 2011-03-08 10:25:56. # rows inserted in table Employees : 1 I. 2011-03-08 10:25:56. # rows deleted in table Employees : 0 I. 2011-03-08 10:25:56. # rows updated in table Employees : 0 I. 2011-03-08 10:25:56. # rows inserted in table Departments : 1 I. 2011-03-08 10:25:56. # rows deleted in table Departments : 0 I. 2011-03-08 10:25:56. # rows updated in table Departments : 0 I. 2011-03-08 10:25:56. # rows inserted in table Customers : 1 I. 2011-03-08 10:25:56. # rows deleted in table Customers : 0 I. 2011-03-08 10:25:56. # rows updated in table Customers : 0 I. 2011-03-08 10:25:56. # rows inserted in table Contacts : 1 I. 2011-03-08 10:25:56. # rows deleted in table Contacts : 0 I. 2011-03-08 10:25:56. # rows updated in table Contacts : 0 I. 2011-03-08 10:25:56. Waiting for MobiLink to apply upload I. 2011-03-08 10:25:56. Sending schema information to MobiLink server. I. 2011-03-08 10:25:56. Processor is little-endian I. 2011-03-08 10:25:56. Article table: SpatialShapes I. 2011-03-08 10:25:56. Article column: integer ShapeID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:56. Article column: char Description(32) NULL I. 2011-03-08 10:25:57. Article column: st_geometry Shape NULL I. 2011-03-08 10:25:57. Article table: SpatialContacts I. 2011-03-08 10:25:57. Article column: integer ID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:57. Article column: char Surname(20) NOT NULL I. 2011-03-08 10:25:57. Article column: char GivenName(20) NOT NULL I. 2011-03-08 10:25:57. Article column: char Street(30) NOT NULL I. 2011-03-08 10:25:57. Article column: char City(20) NOT NULL I. 2011-03-08 10:25:57. Article column: char State(16) NULL I. 2011-03-08 10:25:57. Article column: char Country(16) NULL I. 2011-03-08 10:25:57. Article column: char PostalCode(10) NULL I. 2011-03-08 10:25:57. Article table: SalesOrders I. 2011-03-08 10:25:57. Article column: integer ID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:57. Article column: integer CustomerID NOT NULL I. 2011-03-08 10:25:57. Article column: date OrderDate NOT NULL I. 2011-03-08 10:25:57. Article column: char FinancialCode(2) NULL I. 2011-03-08 10:25:57. Article column: char Region(7) NULL I. 2011-03-08 10:25:57. Article column: integer SalesRepresentative NOT NULL I. 2011-03-08 10:25:57. Article table: SalesOrderItems I. 2011-03-08 10:25:57. Article column: integer ID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:57. Article column: smallint LineID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:57. Article column: integer ProductID NOT NULL I. 2011-03-08 10:25:57. Article column: integer Quantity NOT NULL I. 2011-03-08 10:25:57. Article column: date ShipDate NOT NULL I. 2011-03-08 10:25:57. Article table: Products I. 2011-03-08 10:25:57. Article column: integer ID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:57. Article column: char Name(15) NOT NULL I. 2011-03-08 10:25:57. Article column: char Description(30) NOT NULL I. 2011-03-08 10:25:57. Article column: char Size(18) NOT NULL I. 2011-03-08 10:25:57. Article column: char Color(18) NOT NULL I. 2011-03-08 10:25:57. Article column: integer Quantity NOT NULL I. 2011-03-08 10:25:57. Article column: numeric UnitPrice(15,2) NOT NULL I. 2011-03-08 10:25:57. Article column: long binary Photo NULL I. 2011-03-08 10:25:57. Article table: MarketingInformation I. 2011-03-08 10:25:57. Article column: integer ID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:57. Article column: integer ProductID NOT NULL I. 2011-03-08 10:25:57. Article column: long varchar Description NULL I. 2011-03-08 10:25:57. Article table: FinancialData I. 2011-03-08 10:25:57. Article column: char Year(4) NOT NULL PRIMARY KEY I. 2011-03-08 10:25:57. Article column: char Quarter(2) NOT NULL PRIMARY KEY I. 2011-03-08 10:25:57. Article column: char Code(2) NOT NULL PRIMARY KEY I. 2011-03-08 10:25:57. Article column: numeric Amount(9,0) NULL I. 2011-03-08 10:25:57. Article table: FinancialCodes I. 2011-03-08 10:25:57. Article column: char Code(2) NOT NULL PRIMARY KEY I. 2011-03-08 10:25:57. Article column: char Type(10) NOT NULL I. 2011-03-08 10:25:57. Article column: char Description(50) NULL I. 2011-03-08 10:25:57. Article table: Employees I. 2011-03-08 10:25:57. Article column: integer EmployeeID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:57. Article column: integer ManagerID NULL I. 2011-03-08 10:25:57. Article column: char Surname(20) NOT NULL I. 2011-03-08 10:25:57. Article column: char GivenName(20) NOT NULL I. 2011-03-08 10:25:57. Article column: integer DepartmentID NOT NULL I. 2011-03-08 10:25:57. Article column: char Street(30) NOT NULL I. 2011-03-08 10:25:57. Article column: char City(20) NOT NULL I. 2011-03-08 10:25:57. Article column: char State(16) NULL I. 2011-03-08 10:25:57. Article column: char Country(16) NULL I. 2011-03-08 10:25:57. Article column: char PostalCode(10) NULL I. 2011-03-08 10:25:57. Article column: char Phone(13) NULL I. 2011-03-08 10:25:57. Article column: char Status(2) NULL I. 2011-03-08 10:25:57. Article column: char SocialSecurityNumber(11) NULL I. 2011-03-08 10:25:57. Article column: numeric Salary(20,3) NOT NULL I. 2011-03-08 10:25:57. Article column: date StartDate NOT NULL I. 2011-03-08 10:25:57. Article column: date TerminationDate NULL I. 2011-03-08 10:25:57. Article column: date BirthDate NULL I. 2011-03-08 10:25:57. Article column: bit BenefitHealthInsurance NULL I. 2011-03-08 10:25:57. Article column: bit BenefitLifeInsurance NULL I. 2011-03-08 10:25:57. Article column: bit BenefitDayCare NULL I. 2011-03-08 10:25:57. Article column: char Sex(2) NULL I. 2011-03-08 10:25:57. Article table: Departments I. 2011-03-08 10:25:57. Article column: integer DepartmentID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:57. Article column: char DepartmentName(40) NOT NULL I. 2011-03-08 10:25:57. Article column: integer DepartmentHeadID NULL I. 2011-03-08 10:25:57. Article table: Customers I. 2011-03-08 10:25:57. Article column: integer ID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:57. Article column: char Surname(20) NOT NULL I. 2011-03-08 10:25:57. Article column: char GivenName(20) NOT NULL I. 2011-03-08 10:25:57. Article column: char Street(30) NOT NULL I. 2011-03-08 10:25:57. Article column: char City(20) NOT NULL I. 2011-03-08 10:25:57. Article column: char State(16) NULL I. 2011-03-08 10:25:57. Article column: char Country(16) NULL I. 2011-03-08 10:25:57. Article column: char PostalCode(10) NULL I. 2011-03-08 10:25:57. Article column: char Phone(13) NOT NULL I. 2011-03-08 10:25:57. Article column: char CompanyName(32) NULL I. 2011-03-08 10:25:57. Article table: Contacts I. 2011-03-08 10:25:57. Article column: integer ID NOT NULL PRIMARY KEY I. 2011-03-08 10:25:57. Article column: char Surname(20) NOT NULL I. 2011-03-08 10:25:57. Article column: char GivenName(20) NOT NULL I. 2011-03-08 10:25:57. Article column: varchar Title(34) NULL I. 2011-03-08 10:25:57. Article column: char Street(30) NULL I. 2011-03-08 10:25:57. Article column: char City(20) NULL I. 2011-03-08 10:25:57. Article column: char State(16) NULL I. 2011-03-08 10:25:57. Article column: char Country(16) NULL I. 2011-03-08 10:25:57. Article column: char PostalCode(10) NULL I. 2011-03-08 10:25:57. Article column: char Phone(13) NULL I. 2011-03-08 10:25:57. Article column: char Fax(13) NULL I. 2011-03-08 10:25:57. Article column: integer CustomerID NULL I. 2011-03-08 10:25:57. Table Upload Order: SpatialShapes,SpatialContacts,SalesOrders,SalesOrderItems,Products,MarketingInformation,FinancialData,FinancialCodes,Employees,Departments,Customers,Contacts I. 2011-03-08 10:25:57. The user authentication value is 1000. E. 2011-03-08 10:25:57. Error code from MobiLink server: -10002 E. 2011-03-08 10:25:57. Server error: Message: ODBC: [Sybase][ODBC Driver][SQL Anywhere]No primary key value for foreign key 'FK_CustomerID_ID' in table 'SalesOrders' (ODBC State = 23000, Native error code = -194). Table Name: SalesOrders. Primary Key(s): 99 E. 2011-03-08 10:25:57. Error code from MobiLink server: -10002 E. 2011-03-08 10:25:57. Server error: Message: ODBC: [Sybase][ODBC Driver][SQL Anywhere]No primary key value for foreign key 'FK_CustomerID_ID' in table 'SalesOrders' (ODBC State = 23000, Native error code = -194). Table Name: SalesOrders. Primary Key(s): 99 I. 2011-03-08 10:25:57. End synchronizing subscription(s) 'demo_1' I. 2011-03-08 10:25:57. Disconnecting from MobiLink server I. 2011-03-08 10:25:58. Complete log scan required. I. 2011-03-08 10:25:58. Synchronization completed I. 2011-03-08 10:25:58. Disconnecting from remote database |
dbmlsync should determine the table order based on the remote's foreign keys. Are the foreign keys defined on the remote? If for some reason the client is generating the wrong table order, you can override it with the -tor extended option.
http://dcx.sybase.com/index.html#1201en/mlclient/mc-syncclient-s-608170621a977.html
@Bill: The remote database was created by the MobiLink Model wizard. It has the same foreign key structure. FWIW the rows were inserted on the remote in out-of-foreign-key order using WAIT_FOR_COMMIT = ON... but that shouldn't matter, should it? The transaction log order for the inserts is not used for the upload processing order.
We'll need a verbose dbmlsync log to see why the table order is wrong. Please add -vnosu to your dbmlsync command line and post the log.