Gateways, Oracle Lite, Oracle DB Mob. Server, TimesTen (MOSC)

MOSC Banner

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)"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center