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
warnings after run the job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
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
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
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?
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?