Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
swades
Premium Member
Posts: 323 Joined: Mon Dec 04, 2006 11:52 pm
Post
by swades » Mon Apr 07, 2008 7:19 am
Hi All,
I am getting following error log while loading to SQL server DB using DRS stage.
Dynamic_RDBMS_8,0: Warning: Audit_job.Dynamic_RDBMS_8: [DataDirect][ODBC SQL Server Driver]20172
Dynamic_RDBMS_8,0: Failure during execution of operator logic.
Dynamic_RDBMS_8,0: Fatal Error: Fatal: SQLBindParameter: Failed to bind a parameter.
node_node1: operator [Dynamic_RDBMS_8], partition 0 of 1, processID 16849 on node1, player 2 terminated unexpectedly.
Any idea please?
Thanks.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Apr 07, 2008 9:33 am
User-defined SQL?
-craig
"You can never have too many knives" -- Logan Nine Fingers
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Mon Apr 07, 2008 9:36 am
Do you have BigInt as any of your target datatypes?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
swades
Premium Member
Posts: 323 Joined: Mon Dec 04, 2006 11:52 pm
Post
by swades » Mon Apr 07, 2008 9:40 am
chulett wrote: User-defined SQL?
I tried
both way USER DEFINED and AUTO GENERATED SQL
swades
Premium Member
Posts: 323 Joined: Mon Dec 04, 2006 11:52 pm
Post
by swades » Mon Apr 07, 2008 9:42 am
DSguru2B wrote: Do you have BigInt as any of your target datatypes?
I Have Int(10), varchar(50), char(5),
timestamp(32)
swades
Premium Member
Posts: 323 Joined: Mon Dec 04, 2006 11:52 pm
Post
by swades » Sat Apr 26, 2008 5:34 pm
This issue has been resolved :D . Actually in my Target SQL server table two columns are defined as datetime , Before, I was defining this two column as Timestamp in my DS job. I changed to char now its working fine.
I created new server job.
SQL type :- Auto Generated