Strange error while loading through ODBC

MOHAMMAD.ISSAQ · Post by **MOHAMMAD.ISSAQ** » Tue May 13, 2008 3:58 am

I'm working on Datastage 7.5 with Sybase as the Database.

I'm using an ODBC stage to load data into the sybase table.
It's properly loading data into it but on the link it's showing as "0 rows,0 rows/sec".
But in director this warning is coming:

*************************************************************
JT513Lod_Tbillingw_polinst_NB_1..Gld_tbillingw_polinst.IDENT1.To_Gld_tbillingw_polinst: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO schema.table(wip_no, wip_iteration_no, billing_cycle_seq_no, inst_num, inst_billing_date, inst_billed_date, inst_due_date, new_prem_written_amt, old_prem_written_amt, delta_prem_written_amt, new_charge_amt, old_charge_amt, delta_charge_amt, new_tax_amt, old_tax_amt, delta_tax_amt, new_billable_amt, old_billable_amt, delta_billable_amt, inst_prem_amt_collected, inst_collected_date, payment_ref, timestamp, reserved1, reserved2, reserved3, reserved4, reserved5, reserved6) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
0 Rows affected.

wip_no = "0011100029"
wip_iteration_no = "1"
billing_cycle_seq_no = 1
inst_num = 1
inst_billing_date = "2006-10-26 00:00:00"
inst_billed_date = "2006-10-26 00:00:00"
inst_due_date = "2006-10-26 00:00:00"
new_prem_written_amt = 0.0000
old_prem_written_amt = 0.0000
delta_prem_written_amt = 0.0000
new_charge_amt = 0.0000
old_charge_amt = 0.0000
delta_charge_amt = 0.0000
new_tax_amt = 0.0000
old_tax_amt = 0.0000
delta_tax_amt = 0.0000
new_billable_amt = 0.0000
old_billable_amt = 0.0000
delta_billable_amt = 0.0000
inst_prem_amt_collected = 0.0000
inst_collected_date = NULL
payment_ref = NULL
timestamp = "2008-05-13 15:19:40"
reserved1 = NULL
reserved2 = NULL
reserved3 = NULL
reserved4 = NULL
reserved5 = NULL
reserved6 = NULL
*************************************************************

Could anyone pls provide pointers to this..

DSRajesh · Post by **DSRajesh** » Tue May 13, 2008 4:06 am

Hi

The datastage engine is failing to execute the insert statement when you try to execute the datastage job.

Can you try the same INSERT statement at database level whether working or not?

MOHAMMAD.ISSAQ · Post by **MOHAMMAD.ISSAQ** » Tue May 13, 2008 4:20 am

But the problem is datastage is propely loading data into the table but it's throwing such warnings.

I inserted data at the database level also it's working properly.

DSRajesh · Post by **DSRajesh** » Tue May 13, 2008 4:49 am

some times i also used to see this type of errors

MOHAMMAD.ISSAQ · Post by **MOHAMMAD.ISSAQ** » Tue May 13, 2008 5:26 am

The problem is resolved i increased the array size..