Skip to Content
0
Nov 03, 2014 at 06:47 AM

Trouble with Mobilink sync

24 Views

Hello, all

I was wondering if someone can help me with this strange error in the Mobilink sync.

The table in question is only supposed to be for upload, no download.

Why does Mobilink try to download data from table, when the table is only supposed to be for upload?

//-----------------------------------------------

I. 2014-11-03 08:37:16. <Main> System event on shared administrative connection:

SELECT idx, name, type FROM ml_column WHERE version_id = ? AND table_id = ? ORDER BY idx DESC

I. 2014-11-03 08:37:16. <Main> Translated SQL:

SELECT idx, name, type FROM ml_column WHERE version_id = ? AND table_id = ? ORDER BY idx DESC

I. 2014-11-03 08:37:16. <Main> System event on shared administrative connection:

SELECT table_id FROM ml_table WHERE name = ?

I. 2014-11-03 08:37:16. <Main> Translated SQL:

SELECT table_id FROM ml_table WHERE name = ?

I. 2014-11-03 08:37:16. <Main> System event on shared administrative connection:

SELECT t.event, s.script_language, s.script FROM ml_table_script t, ml_script s WHERE t.table_id = ? AND t.version_id = ? AND t.script_id = s.script_id

I. 2014-11-03 08:37:16. <Main> Translated SQL:

SELECT t.event, s.script_language, s.script FROM ml_table_script t, ml_script s WHERE t.table_id = ? AND t.version_id = ? AND t.script_id = s.script_id

I. 2014-11-03 08:37:16. <1> download_cursor t027_room_price_codes_master

--{ml_ignore}

I. 2014-11-03 08:37:16. <1> download_delete_cursor t027_room_price_codes_master

--{ml_ignore}

I. 2014-11-03 08:37:16. <1> upload_delete t027_room_price_codes_master

/* Delete the row from the consolidated database. */

DELETE FROM "DBA"."t027_room_price_codes_master"

WHERE "c_pms_price_code" = {ml r."c_pms_price_code"}

AND "c_hotel_id" = {ml r."c_hotel_id"}

I. 2014-11-03 08:37:16. <1> upload_insert t027_room_price_codes_master

/* Insert the row into the consolidated database. */

INSERT INTO "DBA"."t027_room_price_codes_master" ( "c_pms_price_code", "c_hotel_id", "c_Name", "c_Description", "c_StartDate", "c_EndDate", "c_MaxLOS", "c_MinLOS", "c_IsActive", "c_IsDeleted", "c_WeekMaskV", "c_Currency", "c_WeekMaskA", "c_LeadDaysToArrive", "c_LeadDaysToCancel", "c_DisplaySortOrder", "c_Created", "c_LastModified", "c_PolicyCode", "c_local_currency", "c_reason_code", "c_promo_code_only", c_max_lead_days )

on existing update

VALUES ( {ml r."c_pms_price_code"}, {ml r."c_hotel_id"}, {ml r."c_Name"}, {ml r."c_Description"}, {ml r."c_StartDate"}, {ml r."c_EndDate"}, {ml r."c_MaxLOS"}, {ml r."c_MinLOS"},

{ml r."c_IsActive"}, {ml r."c_IsDeleted"}, {ml r."c_WeekMaskV"}, {ml r."c_Currency"}, {ml r."c_WeekMaskA"}, {ml r."c_LeadDaysToArrive"}, {ml r."c_LeadDaysToCancel"}, {ml r."c_DisplaySortOrder"}, {ml r."c_Created"}, {ml r."c_LastModified"}, {ml r."c_PolicyCode"}, {ml r."c_local_currency"},

{ml r."c_reason_code"}, {ml r."c_promo_code_only"},{ml r."c_max_lead_days"} )

I. 2014-11-03 08:37:16. <1> upload_update t027_room_price_codes_master

/* Update the row in the consolidated database. */

INSERT INTO "DBA"."t027_room_price_codes_master" ( "c_pms_price_code", "c_hotel_id", "c_Name", "c_Description", "c_StartDate", "c_EndDate", "c_MaxLOS", "c_MinLOS", "c_IsActive", "c_IsDeleted", "c_WeekMaskV", "c_Currency", "c_WeekMaskA", "c_LeadDaysToArrive", "c_LeadDaysToCancel", "c_DisplaySortOrder", "c_Created", "c_LastModified", "c_PolicyCode", "c_local_currency", "c_reason_code", "c_promo_code_only", c_max_lead_days )

on existing update

VALUES ( {ml r."c_pms_price_code"}, {ml r."c_hotel_id"}, {ml r."c_Name"}, {ml r."c_Description"}, {ml r."c_StartDate"}, {ml r."c_EndDate"}, {ml r."c_MaxLOS"}, {ml r."c_MinLOS"},

{ml r."c_IsActive"}, {ml r."c_IsDeleted"}, {ml r."c_WeekMaskV"}, {ml r."c_Currency"}, {ml r."c_WeekMaskA"}, {ml r."c_LeadDaysToArrive"}, {ml r."c_LeadDaysToCancel"}, {ml r."c_DisplaySortOrder"}, {ml r."c_Created"}, {ml r."c_LastModified"}, {ml r."c_PolicyCode"}, {ml r."c_local_currency"},

{ml r."c_reason_code"}, {ml r."c_promo_code_only"},{ml r."c_max_lead_days"} )

I. 2014-11-03 08:37:16. <Main> System event on shared administrative connection:

SELECT idx, name, type FROM ml_column WHERE version_id = ? AND table_id = ? ORDER BY idx DESC

I. 2014-11-03 08:37:16. <Main> Translated SQL:

SELECT idx, name, type FROM ml_column WHERE version_id = ? AND table_id = ? ORDER BY idx DESC

E. 2014-11-03 08:37:16. <1> [-10019] Error fetching table script t027_room_price_codes_master.download_cursor

I. 2014-11-03 08:37:16. <1> Synchronization failed

//-----------------------------------------------