The forum will be down for scheduled maintenance on Saturday, March 4 beginning at 10am EST. Actual downtime is unknown but may be several hours.

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
...

asked 08 Mar '11, 15:48

Breck%20Carter's gravatar image

Breck Carter
26.8k422580826
accept rate: 20%

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

(08 Mar '11, 17:34) Bill Somers

@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.

(08 Mar '11, 18:39) Breck Carter

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.

(09 Mar '11, 15:49) Bill Somers

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
permanent link

answered 10 Mar '11, 13:00

Breck%20Carter's gravatar image

Breck Carter
26.8k422580826
accept rate: 20%

@Breck: I guess I remember a statement about you and the so-called "Gods of Demo":)

(10 Mar '11, 15:39) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×101

question asked: 08 Mar '11, 15:48

question was seen: 894 times

last updated: 11 Mar '11, 06:38