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



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2623
Location: USA
Points: 19433

Post Posted: Fri Sep 22, 2017 5:40 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: 11.5.0.2 + Service Pack 2
Is it possible to run analysis against a text file? I have an ODBC text file driver setup and imported into IMAM, identified the file, and then imported its metadata into IMAM, then ran quality analysis from the IA thin client. It failed and I found the following fatal message in the corresponding DataStage job log:

Code:
pxbridge(0): ODBC function "SQLPrepare" reported:  SQLSTATE = 42S02: Native Error Code = 1,509: Msg = [IBM(DataDirect OEM)][ODBC Text driver]File not found '/path/project/source/`file.txt'. (CC_OdbcDBStatement::dbsPrepare, file CC_OdbcDBStatement.cpp, line 362)


I noticed a tick mark was introduced between the path and file name. Not sure where that came from, but I was able to View Data Sample OK from the IA workbench. Column analysis run from the workbench fails with the same error. I have opened a PMR.

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54007
Location: Sydney, Australia
Points: 293017

Post Posted: Fri Sep 22, 2017 6:12 pm Reply with quote    Back to top    

Is this reproducible? Is the character always a back-tick? Any idea where it comes from? Are your ODBC drivers up to date?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
rjdickson
Participant



Joined: 16 Jun 2003
Posts: 373
Location: Chicago, USA
Points: 2488

Post Posted: Mon Sep 25, 2017 5:18 am Reply with quote    Back to top    

Did you really put your file in “'/path/project/source/”, or is that a default that was left set?

Can you ‘View’ from the thick client?

What ODBC parameters did you use in .odbc.ini?

_________________
Regards,
Robert
Rate this response:  
Not yet rated
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2623
Location: USA
Points: 19433

Post Posted: Mon Sep 25, 2017 7:10 am Reply with quote    Back to top    

No idea where the back-tick came from. It happens consistently.

As far as I know, we are using the ODBC drivers that shipped with 11.5.0.2 but I will need to double check to be sure. Definitely not using drivers older than that...

I am able to "View Data Sample" on this file from the IA workbench with no issues.

/path/project/source is not the actual path. I have to substitute generic values in place of real values when posting online.

Here is the .odbc.ini header section entry:

Code:
MYPOC=DataDirect TextFile(*.*) Driver


Here is the .odbc.ini driver section entry (it's got mostly default settings):

Code:
[MYPOC]
Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMtxt00.so
Description=DataDirect TextFile(*.*) Driver
AllowUpdateAndDelete=0
ApplicationUsingThreads=1
CacheSize=4
CenturyBoundary=20
Database=/path/project/source
DataFileExtension=TXT
DecimalSymbol=.
Delimiter=
FileOpenCache=0
FirstLineNames=0
IntlSort=0
ScanRows=25
TableType=Comma
UndefinedTable=GUESS


Here is the /path/project/source/QETXT.INI file that was automatically built:

Code:
[Defined Tables]
file.txt=file.txt
[file.txt]
FILE=file.txt
FLN=0
DC=|
TT=CHARACTER
Charset=ANSI
DS=.
FIELD1=colA,VARCHAR,255,0,255,0,

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
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