DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
bhanuvlakshmi
Participant



Joined: 22 Oct 2010
Posts: 23

Points: 222

Post Posted: Wed Jul 03, 2013 1:50 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Windows
HI I have one migration project from 8.1 version to 8.5 Version. In that project one to the job is used to trigger Sp from SQL Server 2005. It was woring fine in the 8.1 version and DB as well. The purpose of the SP is to populate the staging area data to target tables. The target tables are having the primary and foriegn key constraints while the staging area is not. In 8.5 it is not woring and throwing the error as :

Conversion failed when converting character string to smalldatetime data type., Error Procedure: ETLClm, Error Line: 118. Please help me .. how to resolve this..

I tried both in server and parallel jobs in 8.5 still getting the error where as the same code is working fine in 8.1 version.

_________________
Thanks & Regards,
Bhanu
prasson_ibm



Group memberships:
Premium Members

Joined: 11 Oct 2007
Posts: 536
Location: Bangalore
Points: 4830

Post Posted: Wed Jul 03, 2013 3:44 am Reply with quote    Back to top    

Hi,
Which stored procedure is this...source,target or transform.

_________________
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id=61317902&trk=hb_tab_pro_top
Blog:- http://dsshar.blogspot.com/
Rate this response:  
Not yet rated
bhanuvlakshmi
Participant



Joined: 22 Oct 2010
Posts: 23

Points: 222

Post Posted: Wed Jul 03, 2013 4:03 am Reply with quote    Back to top    

When i tried in parallel job i used Transform type.

When tried in server job i used T/F stage as input and ODBC stage as output stage and there i choose the option stored procedure and gave the exec command in the Enter SQL tab.

_________________
Thanks & Regards,
Bhanu
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43085
Location: Denver, CO
Points: 222463

Post Posted: Wed Jul 03, 2013 7:12 am Reply with quote    Back to top    

Exclamation Let's get you into the proper forum... not really a "FAQ Discussion" post.

_________________
-craig

"You can never have too many knives" -- Logan Nine Fingers
Rate this response:  
Not yet rated
prasson_ibm



Group memberships:
Premium Members

Joined: 11 Oct 2007
Posts: 536
Location: Bangalore
Points: 4830

Post Posted: Wed Jul 03, 2013 10:43 am Reply with quote    Back to top    

Try to manully run the procedure and check if it is working fine.I thing your procedure is failing due to data type issue.

_________________
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id=61317902&trk=hb_tab_pro_top
Blog:- http://dsshar.blogspot.com/
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours