We have several jobs which update some tables in SQL Server through ODBC Stage.
These jobs are working perfectly fine in the Development Environment. (With DS version 7.0.1) and loading alll the tables as expected.
But in the Test Environment (DS Version 7.0.0.65 - Client insists on testing in this environment ) , the same update jobs are not able to update all the records.
So of the records are not getting update and a wrning comes with each such failure to update.
Code: Select all
CopyOfCASHDB5040UpdateAccountContact..Null_Handling_2.CashDB_ConatctDim: DSD.BCIPut call to SQLExecute failed.
SQL statement:UPDATE WC_CASH_PERSON_D SET CSH_PER_TITLE = ?, FULL_NAME = ?, FST_NAME = ?, LAST_NAME = ?, SEX_MF = ?, WORK_PHONE = ?, ST_ADDRESS = ?, CITY = ?, STATE = ?, COUNTRY = ?, ZIPCODE = ?, EMAIL_ADDR = ?, DOB = ?, SUPPRESS_CALL_FLG = ?, SUPPRESS_EMAIL_FLG = ?, SUPPRESS_FAX_FLG = ?, CSH_SUPPRESS_SMS_FLG = ?, CSH_RETURNED_MAIL_FLG = ?, CSH_INVALID_ADD_FLG = ?, CSH_INVALID_MOBILE_FLG = ?, CSH_INVALID_WORK_PHONE_FLG = ?, CSH_INVALID_EMAIL_FLG = ?, Field_1 = ?, Field_2 = ?, Field_3 = ?, Field_4 = ?, Field_5 = ?, Field_6 = ?, Field_7 = ?, Field_8 = ?, Field_9 = ?, Field_10 = ?, JOB_TITLE = ?, AUGMENTATION_FLG = ? WHERE (ROW_WID = ?)
ROW_WID = 26
CSH_PER_TITLE = Title
FULL_NAME = First Name Last Name
FST_NAME = First Name
LAST_NAME = Last Name
SEX_MF = G
WORK_PHONE = Phone Number
ST_ADDRESS = Street Address
CITY = City
STATE = State
COUNTRY = Country
ZIPCODE = Zipcode
EMAIL_ADDR = NULL
DOB = "2000-01-01"
SUPPRESS_CALL_FLG = S
SUPPRESS_EMAIL_FLG = S
SUPPRESS_FAX_FLG = S
CSH_SUPPRESS_SMS_FLG = S
CSH_RETURNED_MAIL_FLG = R
CSH_INVALID_ADD_FLG = I
CSH_INVALID_MOBILE_FLG = I
CSH_INVALID_WORK_PHONE_FLG = I
CSH_INVALID_EMAIL_FLG = I
Field_1 = ????????7A
Field_2 = ????????7B
Field_3 = ????????7C
Field_4 = ????????7D
Field_5 = ????????7E
Field_6 = ????????7F
Field_7 = ????????7G
Field_8 = ????????7H
Field_9 = ????????7I
Field_10 = ????????7J
JOB_TITLE = Title
AUGMENTATION_FLG = C
The same records which get updated in the development environment are not getting updated even though the record to fulfil the Where is present for records.
We also tried updation through Stored Procedures.
Same ran fine in development environment but in Test Environment it gave the following warning and didnt update the table as desired.
Code: Select all
CASHDBUpdateAccountContact..ODBC_2.IDENT1.Account: DSD.BCIPut call to SQLExecute failed.
SQL statement:{call APCASHTST2.dbo.Update_DataClean_LocalLang_Account(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
SQLSTATE=S1C00, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver]Optional feature not implemented
ROW_WID = 168
NAME = Company Name
ST_ADDRESS = Street Address
CITY = City
STATE = State
COUNTRY = Country
ZIPCODE = Zipcode
MAIN_PH_NUM = Phone Number
Field_1 = ?????????
Field_2 = ?????????
Field_3 = ?????????
Field_4 = ?????????
Field_5 = ?????????
Field_6 = ?????????
Field_7 = ?????????
Field_8 = ?????????
Field_9 = ?????????
Field_10 = ?????????
CSH_MOBILE_NO = Mobile Number
LINE_OF_BUSINESS = Industry
AUGMENTATION_FLG = C
ACCOUNT_CLEANED_DT = 2005-02-15
CLEANING_TEMPLATE = Account_Contact_Data_Update.txt
We have tried many things like Use of
Thanks in advance
Mrinal[/code][/b]