warnings after run the job

harithay · Post by **harithay** » Tue May 17, 2005 10:39 am

Hi all;

my job is aborting after 50 warnings .

nsartable..Transformer_1.DSLink11: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO uci.dbo.nsar(nsar_id, total_net_assets, change_in_tot_assets, foreign_exposure, diversified_fund, open_end_fund, fund_name, borrowing_name, cik, as_of_date, created_dtm, created_by, last_upd_dtm, last_upd_by) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)
SQLSTATE=01004, DBMS.CODE=0
[DataStage][SQL Client]Data has been truncated
SQLSTATE=22005, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver]Invalid character value for cast specification

i could not able to identify the error .

thanks

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue May 17, 2005 10:42 am

Try writing the output to a seq file. Also try removing selected cols at a time to see when this error disappears. That will give you a head start.

harithay · Post by **harithay** » Tue May 17, 2005 10:56 am

Hi sainath

i tried using sequential file in the target;(dslink3 is input to transformer)

i am getting floowing error

textfile..Sequential_File_0.DSLink3: read_delimited() - invalid quotes, column FUND_NAME = "DOGS"

what does it mean

thanks

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue May 17, 2005 11:13 am

It means your input file has quote character as part of the data.

But my assumption was that your source was fine but only the target was problem.

harithay · Post by **harithay** » Tue May 17, 2005 11:31 am

thanks sainath

my target database is sqlserver, for target i am using ODBC stage.

the input and output columns are matching except their length.

for 1st warning i am getting the following message.

nsartable..Transformer_1.DSLink11: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO uci.dbo.nsar(nsar_id, total_net_assets, change_in_tot_assets, foreign_exposure, diversified_fund, open_end_fund, fund_name, borrowing_name, cik, as_of_date, created_dtm, created_by, last_upd_dtm, last_upd_by) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)
SQLSTATE=01004, DBMS.CODE=0
[DataStage][SQL Client]Data has been truncated
SQLSTATE=23000, DBMS.CODE=2627
[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK__nsar__6FE99F9F'. Cannot insert duplicate key in object 'nsar'.
SQLSTATE=01000, DBMS.CODE=3621
[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

nsar_id = 1
total_net_assets = 1248430
change_in_tot_assets = 0
foreign_exposure = "N"
diversified_fund = "Y"
open_end_fund = "N"
fund_name = "THE ADAMS EXPRESS COMPANY"
borrowing_name = "THE ADAMS EXPRESS COMPANY"
cik = "0000002230"
as_of_date = "2004-06-30 00:00:00.000"
created_dtm = "2005-05-17 13:21:37.000"
created_by = "dbo"
last_upd_dtm = "2005-05-17 13:21:37.000"
last_upd_by = "dbo"

can please give some advice to remove this warning

harithay · Post by **harithay** » Tue May 17, 2005 11:47 am

Hi

in my input file

CIK is one of the fields ,its length is 10, sql type is integer

dataformat is 0000004567 (example)

In out put file

CIK is one of the fields its length is 8, sqltype is varchar

.

if it's length is 8 it will truncate the data.

i think my job is getting aborted because of above reason?

is this ryt?