DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
ffsw13



Group memberships:
Premium Members

Joined: 01 Feb 2016
Posts: 31
Location: USA
Points: 363

Post Posted: Tue Aug 15, 2017 3:06 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Greetings,

Have not seen this one before; imported a table def into an Oracle connector and pushing the output to a peek stage for starters and to eliminate any other logic issues. The job compiles fine but when I go to run it the job aborts and in the log file I find an informational message saying "no design time SQL datatype provided for field_name", followed by a fatal message saying "field_name" not a valid field. When I compare the metadata against the database it looks right. Any ideas?

TIA,

ff

_________________
The UNIVERSE is vast and expansive
I never Metadata I didn't like
ffsw13



Group memberships:
Premium Members

Joined: 01 Feb 2016
Posts: 31
Location: USA
Points: 363

Post Posted: Wed Aug 16, 2017 10:21 am Reply with quote    Back to top    

Got to the bottom of this; for whatever reason although the columns and datatypes all lined up with the table in the database, once I imported a fresh table def from the database itself into DataStage and pulled that into my Oracle connector, problem went away! Gotta love those DSEE red herring messages... not sure if they boys in Milton Keynes are still doing designer client development, but a better error would be my product management request, then again been asking for that kind of thing since 7.5 Rolling Eyes Laughing

_________________
The UNIVERSE is vast and expansive
I never Metadata I didn't like
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