I have a sever, which have the IDMS database and SQL sever native client database. I am doing a sync from connx web interface :9500/datasync/transofrmation. I created mutliple Transformations (one for each column in the table). Surprisingly all columns Sync are successful,
expect for 4 columns.
This below error is for all failed columns, posted one below:
error:
Source Table = SELECT “t1”.“Column1” FROM “DB1”.“dbo” “TB1” “t1”: Unable to copy contents of source table to destination (Insert/SelectFull) Unable to get record from table (TB1). >>> STAT:2 ERR:-2147467259 SQLSTATE:S1000 Microsoft OLE DB Provider for ODBC Drivers: [CA]ICA IDMS ODBC Driver]Restricted data type attribute violation SQL is : insert into “DB2”.“dbo”. “v_Column1” (“Column1”) SELECT “1” “Column1” FROM “DB1”.“dbo” “TB1” “t” {fn commitcount 1000} {bulkmode) {fn insertselectcount 119857912}
Can anyone help me understand what the root cause might be?
#webMethods#ApplinX#Mainframe-Integration#CONNX