DSXchange

Same error even after renaming the file to A3.txt IA identified both the files 3.txt as well as A3.txt (through identify flat file feature). Then I clicked on identify next level option in IA and it also worked fine but when I clicked on "Import" button, I got the same error which was repo...

Thank you for your response Mike.

There is no special character in the file name. The file name is 3.txt

I have used "identify flat files" option in IA tasks menu which is populating QETXT.INI correctly. I tried to import through metadata asset manager but got the same error as mentioned below. Errorx [CDIMR3790E] An error occurred while importing data from bridge or connector (CAS/ODBCConnec...

Found the below technote but it didn't resolve the reported issue.

http://www-01.ibm.com/support/docview.w ... wg21395196

Hi Experts, Getting below error while trying to import metadata of flat files in information analyzer. Flat files are located on datastage server itself. Error Message : "Failed while importing". Please see log files for details. I browsed to webconsole to the below path and this is what I...

Thanks for your inputs.

This issue has been fixed now. I just changed the odbc driver from libcacheodbc.so to libcacheodbc35.so and tested the job again and it worked fine. Marking the topic as resolved now.

I am connecting to "InterSystems Cache Database" through odbc connector stage.

Hi Experts, I am trying to connect to Cache database through datastage ODBC connector stage. Here is my job design. ODBC Connector Stage ---> Sequential File Stage. I am able to test the ODBC DSN connection from the properties of the ODBC Connector stage in the parallel job. I am also able to view d...

Thanks Guys for your valuable inputs. I will consult Cache DB admin and will post the resolution steps if I get any.

Hi Experts, My requirement is to do data profiling on "Cache database tables" by using information analyzer tool. I have installed cache odbc drivers on datastage server successfully and have created below ODBC DSN as well in .odbc.ini file. Cache_DSN Driver=/opt/datastage/cache-client/bin...

Does your datastage job read or write any dataset?

If yes, delete those datasets manually before running the datastage job.

Thanks Ray.

Marking the post as resolved.

Solution : Create a new database schema for IADB on a new DB server(by using the scripts supplied by IBM as a part of product install), then create a new DSN and change the analysis settings. Thats all.

Hi Experts, I would like to ask one question regarding information analyzer. Can we use Information Analyzer 9.1.2 to do data profiling on oracle source databases that have Advanced Security/encryption applied to them? If yes, do we need to do any configuration on information server(AIX) to do this?...

Hi Experts, We have information analyzer database IADB configured in our existing 9.1.2 environment. Now our requirement is to do data profiling on huge number of tables and existing IADB oracle database server is not having enough capacity to support the requirement. We can not increase the capacit...

http://www-01.ibm.com/support/docview.w ... wg27016910

read Planning, Installation, and Configuration Guide