Page 1 of 1

Column Analysis failure/Connection refused

Posted: Tue Feb 26, 2013 12:03 pm
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

Posted: Tue Feb 26, 2013 2:51 pm
by ray.wurlod
Have you moved the "table definition" into the project?

Have you moved the "table definition" into the pro

Posted: Tue Feb 26, 2013 3:19 pm
by william.eller@ed.gov
I manually defined the file layout using Metadata Manager then, associated the file to the project