Sync issue with mSync Tool
Oracle Database Mobile Server
While running the Msync getting the below error message during snapshot creation of table CUSTOMER_ACCOUNT
''SqliteException: Sqlite database error (see the cause) <- SqliteException: duplicate column name: ARCHAR2(32)[Diagnostics: dbName="
It is getting the duplicate column name error for datatype.
below are the values for field columns.
"'PREMISE_NUMBER' VARCHAR2(32)","'NAME' VARCHAR2(50)","'HOUSE_NUMBER' VARCHAR2(16)","'DIRECTIONAL_PREFIX' VARCHAR2(4)","'STREET_NAME' VARCHAR2(32)","'STREET_SUFFIX' VARCHAR2(10)","'DIRECTIONAL_SUFFIX' VARCHAR2(4)","'UNIT_NUMBER' VARCHAR2(10)","'TOWN' VARCHAR2(32)","'ZIP' VARCHAR2(5)","'ZIP_4' VARCHAR2(4)","'HOME_AREA_CODE' VARCHAR2(3)","'HOME_PHONE_NUMBER' VARCHAR2(7)","'ACCOUNT_CLASS' VARCHAR2(32)","'ACCOUNT_TYPE' VARCHAR2(32)","'GAS_SUPPLIER' VARCHAR2(32)","'GAS_TYPE_OF_DEMAND' VARCHAR2(32)","'GAS_SUMMER_PEAK_LOAD' VARCHAR2(32)","'GAS_WINTER_PEAK_LOAD' VARCHAR2(32)","'GAS_DIVERSITY_FACTOR' VARCHAR2(16)","'GAS_USAGE_MONTH_1' VARCHAR2(16)","'GAS_USAGE_MONTH_2' VARCHAR2(16)","'GAS_USAGE_MONTH_3' VARCHAR2(16)","'GAS_USAGE_MONTH_4' VARCHAR2(16)","'GAS_USAGE_MONTH_5' VARCHAR2(16)","'GAS_USAGE_MONTH_6' VARCHAR2(16)","'GAS_USAGE_MONTH_7' VARCHAR2(16)","'GAS_USAGE_MONTH_8' VARCHAR2(16)","'GAS_USAGE_MONTH_9' VARCHAR2(16)","'GAS_USAGE_MONTH_10' VARCHAR2(16)","'GAS_USAGE_MONTH_11' VARCHAR2(16)","'GAS_USAGE_MONTH_12' VARCHAR2(16)","'STATE_ABBR' CHAR(2)","'SITE_STATUS_CD' CHAR(2)","'SITE_STATUS_DT' DATE","'ADDR_BLDG_NUM' VARCHAR2(8)","'ADDR_OVFL_AD' VARCHAR2(23)","'REVENUE_CLASS_CD' CHAR(2)","'RATE_CD' CHAR(2)","'METER_STATUS_CD' CHAR(2)"