Note 1995803 occurs in build 16.0.0 1948

[former_member329524]

Hello, all

I have just encountered the specified bug when running on build 1948.

Can someone confirm that the issue has been fixed (supposed to have been in build 1801), and, if yes, which file should I replace on the server?

SAP Note 1995803 - SQLCODE -1325 incorrectly thrown when defining two publications with multiple mat...

Thank you

Arcady

[chris_keating · Accepted solution]

There is a typo in the note.The fix is in 16.0.0 build 1803 or later based on the CR number referenced in the note.

You can simply apply the SP to update the environment.  To deploy just the server, this documentation outlines the requirements:

http://dcx.sybase.com/index.html#sa160/en/dbprogramming/server-deploy.html*d5e55688

Message was edited by: Jeff Albion Fixed version number.

[jeff_albion]

Hi Arcady,

I have fixed your URL reference and have updated the fix version on our SAP support site. You should download and apply the latest Support Package for SQL Anywhere from the support portal.

Thanks,

Jeff Albion

SAP Active Global Support

[former_member329524]

So, the correct build is SA16_Windows.1600_2014_EBF ?

Because, I cannot find reference to 16.0.1 anywhere....

[jeff_albion]

Hi Arcady,

You are correct - 16.0.1 doesn't exist, and 16.0.0 is only available.

'SQLANYW160021_0-11013189.ZIP' (SP 21, 16.0.0.2018 - SAP Note) is currently the latest patch available for SQL Anywhere 16 (Windows x86/x64) on http://support.sap.com/.

Regards,

Jeff Albion

SAP Active Global Support

[former_member329524]

OK, after the upgrade the problem appears to persist.

I created 2 publications, one for upload and 1 for download.

The subscription for the upload was created without a problem.

When I tried to create the subscription for the download publication, I got the same error as before.

The problematic table is t006_reservation_master (shown in bold red)

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

CREATE PUBLICATION "DBA"."Hotel_Upload"

(

  TABLE "DBA"."G4_cached_search_response_multi_prices" ("c_hotel_id","c_from_date","c_to_date","c_pms_room_type","c_pms_price_code","c_pms_plan","c_adults","c_children","c_isLocal","c_total_price","c_availability","c_valid","c_wing") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."G4_cached_search_response_packages" ("c_hotel_id","c_from_date","c_to_date","c_package_id","c_adults","c_children","c_isLocal","c_total_price","c_availability","c_valid","c_pms_room_type","c_pms_price_code","c_pms_plan","c_wing") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t001_hotel_sync_timestamp" ("c_hotel_id","c_sync_start","c_sync_end","c_sync_comment","c_avail_sync","c_price_sync","c_clerk_sync","c_package_sync","c_policies_sync","c_discount_sync","c_channel_sync","c_promo_inventory_sync","c_restr_sync") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t001_Hotels" ("c_hotel_id","c_hotel_name","c_description","c_chain_id","c_grade","c_creator_id","c_local_price_code_id","c_tourist_price_code_id","c_DisplaySortOrder","c_CityCode","c_CountryCode","c_BookingDisplayRuleString","c_thumbnail_path","c_image_path","c_alt","c_VatPercent","c_VatIncluded","c_DefaultCurrencyCode","c_AllowRestrictionsForPackages","c_NoMinimumNightsForTourists","c_DiscountIfTourist","c_DefaultLanguage","c_MaxBookingID","c_monitor_flag","c_OldMaxBookingID","c_PrimaryHotelID","c_wing","c_OverrideShabbatPriceOnFridayArrival","c_IncludeVatForTourists","c_IsActive","c_IsDeactivateAllowed","c_LastRetrieveBookingsTime","c_IsOpenForSale","c_cancellation_succeeded","c_PreferredClearingCompany","c_UseNewRetrieval","c_SellRoomsWhileHotelIsNotClosed","c_region_pms_code","c_region_pms_name","c_region_id","c_ml_user","c_goc_org_id","c_pms_hotel_code","c_use_mix_price_code_module","c_OverrideSaturdayPriceForTourists","c_parallel_processing_option") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t001_hotels_channels_customers" ("c_hotel_id","c_customer_id","c_saleschannelid","c_hotel_name","c_description","c_chain_id","c_grade","c_region_id","c_displaysortorder","c_citycode","c_countrycode","c_vatpercent","c_vatincluded","c_DefaultCurrencyCode","c_primary_hotel_id","c_pms_hotel_code","c_use_mix_price_code_module","c_parallel_processing_option") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t002_room_type_pax" ("c_serial","c_pms_cattype","c_hotel_id","c_adults","c_children","c_babies","c_user_update","c_timestamp","c_pms_serial","c_primary_hotel_id") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t002_room_types" ("c_hotel_id","c_name","c_max_avail","c_description","c_creator_id","c_pms_cattype","c_thumbnail_path","c_image_path","c_alt","c_wing","c_active","c_sort_order","c_created","c_last_modified","c_pms_category","c_pms_room_type","c_connecting_room","c_requested_room","c_min_price_room") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t003g4_availability" ("c_date","c_pms_cattype","c_available_for_sale","c_timestamp","c_hotel_id") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."T006_RESERVATION_MASTER" ("C_MASTER_ID","c_pms_master_id","c_hotel_id","c_pms_update_time") WHERE "get_sync_user"("c_primary_hotel_id") = 'fattal',

  TABLE "DBA"."t016h_credit_card_hotels" ("c_card_code","c_hotel_id") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t018h_customers_hotels" ("c_customer_id","c_hotel_id","c_login_allowed","c_credit_type","c_Pms_Customer_Key","c_Discount","c_InBlackList") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t023_special_services" ("c_hotel_id","c_service_code","c_service_code_name","c_description","c_display_order","c_deleted","c_price_per_room","c_price","c_price_per_pax","c_price_adult","c_price_child","c_price_baby","c_first_night_only","c_first_night","c_day_of_departure","c_per_adult","c_per_child","c_per_baby","c_complimentry_flag","c_currency","c_price_per_night") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "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") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t027dp_price_code_days_all" ("c_price_code","c_price_code_serial_number","c_plan","c_date","c_cattype","c_yield_level","c_del","c_cancel_days","c_price_single","c_price_adult","c_price_double","c_price_child","c_manual","c_update_user","c_price_baby","c_price_two_onec","c_price_two_twoc","c_price_three","c_price_twoc","c_price_threec","c_price_two_threec","c_price_two_fourc","c_one_active","c_two_onec_active","c_two_twoc_active","c_three_active","c_twoc_active","c_threec_active","c_two_threec_active","c_two_fourc_active","c_price_four","c_four_active","c_price_single_onec","c_price_single_twoc","c_price_single_threec","c_price_single_fourc","c_single_onec_active","c_single_twoc_active","c_single_threec_active","c_single_fourc_active","c_4_child","c_4_child_active","c_internet_discount","c_close_for_sale","c_close_for_arrivals","c_close_for_departures","c_min_days_for_sale","c_max_days_for_sale","c_calc_by_arrive_or_stay","c_hotel_id","c_baby_active","c_price_3ad_1ch","c_price_3ad_1ch_active","c_price_4ad_1ch","c_price_4ad_1ch_active","c_price_2ad_5ch","c_price_2ad_5ch_active","c_price_5ad","c_price_5ad_active") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t027i_internet_discounts" ("c_price_code","c_plan_code","c_from_date","c_to_date","c_hotel_id","c_web","c_percent_or_amount","c_global_discount","c_discount_day1","c_discount_day2","c_discount_day3","c_discount_day4","c_discount_day5","c_discount_day6","c_discount_day7","c_optima","c_pms_serial","c_calc_by_day") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t027p_price_code_policy" ("c_Hotel_ID","c_price_code","c_Date","c_cattype","c_PolicyCode","c_DaysToCancel","c_IsGuaranteed","c_Day1","c_Day2","c_Day3","c_Day4","c_Day5","c_Day6","c_Day7","c_InsertedOn") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t027ppl_price_codes_plans" ("c_hotel_id","c_pms_price_code","c_pms_plan") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t027w_price_codes_web" ("c_hotel_id","c_pms_internet_price_code","c_pms_price_code","c_description","c_lead_time_to_arrive","c_can_days","c_sort_order","c_discount_percent","c_promo_only","c_key","c_reason_code","c_min_days","c_max_days") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t030_plans" ("c_pms_plan_code","c_hotel_id","c_plan_name","c_description","c_creator_id","c_thumbnail_path","c_image_path","c_alt","c_sort_order","c_created","c_last_modified","c_is_active") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."T064_CUSTOMER_CLERKS" ("c_customer_ID","C_LAST_NAME","C_FIRST_NAME","C_TITLE","c_department","c_phone","c_fax","C_E_MAIL","C_LAST_RESERVATION_DATE","C_RECEIVES_BONUS","c_web_pass","c_web_price_code","c_promo_code","c_phone2","c_mobile","c_position","c_contact_id","c_timestamp","c_modified_by","c_enrollment_date","c_club_code","c_price_code_for_club_gain","c_price_code_for_club_use","c_allocation_name","c_clerk_key","c_clerk_number","c_deleted","c_hotel_id","c_pms_customer_key","c_credit_type","c_inblackList","c_discount") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t066_Customers_Packages" ("c_Customer_ID","c_package_id","c_hotel_id","c_currency","c_isLocal") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t066_Customers_PriceCodes" ("c_Customer_ID","c_Price_Code","c_hotel_id","c_currency","c_isLocal") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t068_packages" ("c_hotel_id","c_package_id","c_promotion_name","c_description","c_price_code","c_plan","c_start_date","c_end_date","c_display_from_date","c_display_end_date","c_valid_on_sun","c_valid_on_mon","c_valid_on_tue","c_valid_on_wed","c_valid_on_thu","c_valid_on_fri","c_valid_on_sat","c_arrive_sun","c_arrive_mon","c_arrive_tue","c_arrive_wed","c_arrive_thu","c_arrive_fri","c_arrive_sat","c_max_bulk","c_open_sale","c_display_order","c_min_los","c_max_los","c_charge_1st_night","c_old_price_single","c_old_price_double","c_single_only","c_pms_cattype","c_agent_id","c_discount_day01","c_discount_day02","c_discount_day03","c_discount_day04","c_discount_day05","c_discount_day06","c_discount_day07","c_created","c_last_modified_date","c_consider_agents_discount","c_consider_home_site_discount","c_parent_package","c_wing","c_currency","c_categories","c_local_currency","c_price_for_show","c_old_price_for_show") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t068a_package_services" ("c_package_id","c_hotel_id","c_special_service_code") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t068b_package_languages" ("c_package_id","c_hotel_id","c_language_id","c_description","c_package_name","c_short_desc","c_pms_language","c_pic1_url","c_pic2_url") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t068c_package_prices" ("c_package_id","c_hotel_id","c_adults","c_children","c_infants","c_price","c_baby_price","c_currency","c_original_price_baby","c_original_price","c_valid_pax") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t068ca_category" ("c_category_id","c_category_code","c_short_desc","c_description","c_hotel_id","c_del","c_display_order") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t162h_SalesChannels_Hotels" ("c_SalesChannelID","c_HotelID","DefaultCustomertID","Pms_SalesChannel_Key","c_ext_hotel_id") WHERE "get_sync_user"("c_hotelid") = 'fattal',

  TABLE "DBA"."t168_hotel_email_addresses" ("c_hotel_id","c_addr_type","c_address","c_msg_type","c_daily_rep") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t501_hotel_products" ("c_hotel_id","c_pms_cattype","c_pms_price_code","c_pms_plan_code","c_leaddaystoarrive","c_currency","c_local_currency","c_LeadDaysToCancel","c_reason_code","c_primary_hotel_id","c_wing","c_promo_only","c_pms_room_category","c_max_lead_days") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."t503h_hotel_cache_pax_list" ("c_adults","c_children","c_wait_ms","c_hotel_id","c_forever") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."tr000_hotel_parameters" ("c_hotel_id","c_language_id","c_hotel_name","c_city","c_address1","c_address2","c_hotel_short_desc","c_hotel_long_desc","c_hotel_url","c_hotel_logo_url","c_iswing") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."tr002_cattype" ("c_hotel_id","c_language_id","c_cattype","c_name","c_description","c_pic1_url","c_pic2_url","c_iswing") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."tr023_special_service_codes" ("c_hotel_id","c_language_id","c_special_service_code","c_name","c_description","c_iswing") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."tr027w_price_codes_web" ("c_pms_price_code","c_language_id","c_name","c_description","c_hotel_id","c_iswing","c_pic1_url","c_pic2_url") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."tr030_plans" ("c_hotel_id","c_language_id","c_plan_code","c_name","c_description","c_iswing") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."tr068ca_category" ("c_hotel_id","c_language_id","c_category_id","c_short_desc","c_long_desc","c_pic1_url","c_pic2_url","c_iswing") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."tr233_group_policy" ("c_hotel_id","c_language_id","c_policy_code","c_name","c_description","c_iswing") WHERE "get_sync_user"("c_hotel_id") = 'fattal',

  TABLE "DBA"."TranslationsForErrors" ("c_LanguageID","c_ErrorID","c_Name","c_hotel_id") WHERE "get_sync_user"("c_hotel_id") = 'fattal'

);

CREATE PUBLICATION "DBA"."Common_RSV_Download" FOR DOWNLOAD ONLY

(

  TABLE "DBA"."Sources" ("SourceID","SourceName","SourceDescription","last_modified"),

  TABLE "DBA"."t005_guest_invoice_detail" ("c_guest_id","c_last_name","c_first_name","c_title","c_customer_code","c_address1","c_address2","c_state","c_country","c_city","c_zip","c_vat_number","last_modified"),

  TABLE "DBA"."T005_GUEST_PROFILE" ("C_GUEST_ID","c_last_name","c_first_name","c_title","c_address1","c_address2","c_city","c_state","c_zip","c_country_code","c_nationality_code","c_language","C_PHONE","C_FAX","C_E_MAIL","C_FIRM_NAME","C_PASSPORT","C_DRIVERS_LICENCE","C_DRIVERS_STATE","C_GUEST_CATEGORY","C_CLUB_MEMBER","C_OPENED_DATE","C_OPENED_CLERK","C_CHANGED_DATE","C_CHANGED_CLERK","C_BLACKLIST","C_CREDIT_LIMIT","C_PROFESSION","C_DATE_OF_BIRTH","C_SPOUSE_NAME","C_SPOUSE_DATE_OF_BIRTH","C_COMMENTS","C_SALUTATION","c_phone2","c_car_number","c_club_member_number","c_mail_femail","c_web_pass","c_club_enrollment_date","c_club_end_date","c_club_numeric","c_hotel_id","c_timestamp","c_global_guest_id","c_pms_guest_id","C_CREDIT_CARD","C_CREDIT_CARD_NUM","C_CREDIT_CARD_EXPIRY_DATE"),

  TABLE "DBA"."t005d_guest_family" ("c_guest_id","c_guest_serial","c_last_name","c_first_name","c_title","c_passport","c_date_of_birth","c_phone","c_place_of_phone","c_phone2","c_place_of_phone2","c_email","c_street_number","c_street_name","c_building","c_locality","c_city","c_state","c_zip","c_free_address1","c_free_address2","c_country","c_comments","c_first_name2","c_last_name2","c_opened_date","c_entery_visa_number","c_entry_visa_expiry_date","c_id_card","c_gender","c_place_of_birth"),

  TABLE "DBA"."T006_RESERVATION_MASTER" ("C_MASTER_ID","C_COMPANY_id","C_TAKEN_DATE_TIME","C_CHANGE_DATE_TIME","C_NAME","c_timestamp","c_total_price","c_pms_master_id","c_hotel_id","c_agent_id","c_status","c_guest_remarks","c_pms_update_time","c_voucher_number","c_pms_retrieve_date","c_ACD_CompanyName","c_ACD_ContactName","c_ACD_ContactEmail","c_ACD_ContactPhone","c_ACD_ContactAddress","c_booking_language","c_sales_channel_id","c_clerk_key","c_TravelAgencyName","c_TravelAgentName","c_TravelAgentPhone","c_voucher_updated","c_voucher_last_update_time","c_source_id","last_modified","c_payment_flag","c_guaranteed","c_primary_hotel_id"),

  TABLE "DBA"."t006i_booking_pms_integration" ("c_id","c_master_id","c_hotel_id","c_time_inserted","c_pms_master_id","c_retrieved_time","c_integrated_time","c_success","c_rsv_status","last_modified","c_primary_hotel_id"),

  TABLE "DBA"."t009_reservation_detail" ("c_master_id","c_reservation_id","c_arrival_date","c_departure_date","c_adults","c_children","c_infants","c_reservation_status","c_price_amount","c_hotel_id","c_customer_price_remarks","c_guest_room_remarks","c_cancelled_datetime","c_pms_retrieve_time","c_pms_update_time","c_guest_id","c_pms_cattype","c_pms_plan","c_pms_price_code","last_modified","c_sharing","c_pms_package_id","c_room_comments","c_cancel_days","c_pms_policy_code","C_PRICE_CURRENCY","c_pms_guest_id","c_027w_price_code","c_reason_code","c_reason_type"),

  TABLE "DBA"."t009ca_credit_card_check" ("c_serial","c_master_id","c_reservatoin_id","c_credit_card_type","c_credit_card_num","c_valid_until","c_check_time","c_limit","c_confirm_num","c_terminal","c_vat","c_currency","c_folio_id","c_used","c_hold_serial","c_voucher","c_token","c_print","c_lang","c_timestamp","c_payment_serial","int_out_str","c_id","c_used_amount","last_modified","c_hotel_id","c_credit_card_name","c_cvv"),

  TABLE "DBA"."t009g_rsv_companions" ("c_master_id","c_reservation_id","c_hotel_id","c_guest_id","c_guest_serial"),

  TABLE "DBA"."T010_RESERVATION_DATES" ("C_MASTER_ID","c_reservation_id","C_DATE","c_price_amount","c_hotel_id","c_price_code","c_plan","c_cattype","last_modified","c_price_currency","c_vat_percent","c_price_without_vat","c_inventory_code"),

  TABLE "DBA"."T011_RSV_SPECIAL_SERVICES" ("C_MASTER_ID","c_reservation_id","c_special_service_code","C_PRICE","C_AMOUNT","c_part_of_plan","C_COMPLIMENTARY_FLAG","c_hotel_id","last_modified","c_price_currency","c_vat_percent","c_price_without_vat","c_unit_price","c_price_adult","c_price_child","c_price_baby"),

  TABLE "DBA"."t016_credit_cards" ("c_card_code","c_description","c_currency","c_creator_id","last_modified"),

  TABLE "DBA"."T017_nationalities" ("c_country_CODE","C_country_name","C_LANGUAGE","C_GEOGRAPHICAL_AREA","C_DEFAULT_NEWSPAPER","C_BMP","c_display_order","c_geographical_area2","c_geographical_area1","c_local_nationality","c_default_currency","c_default_invoice_type","c_description_number","c_bonus","c_deleted","c_global_code","c_iso2_code","c_iso3_code","c_after_checkout_hours","c_before_checkin_hours","last_modified"),

  TABLE "DBA"."t018_customers" ("c_ID","c_NAME","c_ContactInfo","c_IsCompany","c_IsAgent","c_IsActive","c_ParentCustomerID","last_modified"),

  TABLE "DBA"."t025_Languages" ("c_id","c_Language_Name","c_Language_Code","pms_id","GoogleID","last_modified"),

  TABLE "DBA"."t033_reasons" ("c_reason_type","c_reason_code","c_reason","c_hotel","c_reason_eng","c_deleted","last_modified"),

  TABLE "DBA"."t035_currency_codes" ("c_currency_code","c_currency_name","c_currency_symbol","c_currency_html_symbol","c_creator_id","c_PMS_currency_code","last_modified"),

  TABLE "DBA"."t043_hotel_grades" ("c_code","c_short_descr","c_long_descr","c_sort_order","last_modified"),

  TABLE "DBA"."T045_STATUS" ("C_STATUS_FOR_TABLE","c_status_code","c_short_desc","c_long_desc","C_MANUAL","c_order","c_swap_order","c_del","last_modified"),

  TABLE "DBA"."T055_STATES" ("C_STATE","C_SHORT_DESC","C_LONG_DESC","c_country_code","last_modified"),

  TABLE "DBA"."t056_Cities" ("c_CityCode","c_CityName","c_CountryCode","c_RegionID","last_modified","c_vat_percent"),

  TABLE "DBA"."t069_Chains" ("c_ID","c_NAME","c_DefaultLanguage","c_creator_id","c_IsVip","c_TermsOfUseUrl","c_PrivacyTermsUrl"),

  TABLE "DBA"."t162_SalesChannels" ("c_ID","c_NAME","LoginName","LoginPass","DataFileExportRequired","LastExportTime","FileExportInterval","FileExportErrorInterval","FileExportDirectory","IsHotelUser","FileExportErrorsBeforeAlert","FileExportErrorAlertReceivers","FileIndex","FileExportFormatVersion","FileExportProcessBoth","RatesProcedureVersion","RestrictionsProcedureVersion","UsingGOCWebSerivce","last_modified","c_is_home_site"),

  TABLE "DBA"."t162c_SalesChannels_Customers" ("c_customer_id","c_saleschannel_id","c_active"),

  TABLE "DBA"."t162s_SalesChannels_Sources" ("c_SalesChannel_ID","c_Source_ID","c_Username","c_Password","last_modified"),

  TABLE "DBA"."tblB2BConfig" ("c_hotel_id","c_max_rooms_availabilty_in_req","c_sales_channel_id","c_max_nights_availabilty_in_req","c_max_days_availability_req","c_hotel_dsn","c_heart_beat_timeout","c_max_available_rooms","c_allow_control_on_showerrors","c_show_hotel_wings"),

  TABLE "DBA"."TranslationsForChains" ("c_LanguageID","c_ChainID","c_Name","c_Description","creator_id"),

  TABLE "DBA"."TranslationsForCities" ("c_LanguageID","c_CityCode","c_CityName","last_modified"),

  TABLE "DBA"."TranslationsForCountries" ("c_LanguageID","c_CountryCode","c_CountryName","last_modified"),

  TABLE "DBA"."TranslationsForStatuses" ("c_LanguageID","c_StatusID","c_Name","c_Description","creator_id","last_modified")

);

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