Column Analysis failure/Connection refused

This forum contains ProfileStage posts and now focuses at newer versions Infosphere Information Analyzer.

Moderators: chulett, rschirm

Post Reply
william.eller@ed.gov
Participant
Posts: 19
Joined: Fri Aug 03, 2012 11:06 am

Column Analysis failure/Connection refused

Post by william.eller@ed.gov »

New to IA -
DSN established. QETXT.INI in place. Can see flat file, have configured file layout for it. When I run column analysis job on flat file - I get the following error (server blanked out for security purposes):

"java.sql.SQLNonTransientConnectionException:[IBM][Oracle JDBC Driver]Error establishing socket to host and port:xxxxxxx.xx.xxx:1521. Reason:Connection refused"

Not sure why Oracle Listener port being utilized for analysis of a flat file on the Linux directory. Any help for a mid-level techie would be appreciated. thanks :D
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Have you moved the "table definition" into the project?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
william.eller@ed.gov
Participant
Posts: 19
Joined: Fri Aug 03, 2012 11:06 am

Have you moved the "table definition" into the pro

Post by william.eller@ed.gov »

I manually defined the file layout using Metadata Manager then, associated the file to the project
Post Reply