We are trying to run a column analysis on Teradata table and it is failing with the below error.I am using Teradata Version 12.
pxbridge: Error when checking operator: [IIS-CONN-ODBC-000036] Could not obtain error message from driver (function=SQLPrepare) (CC_OdbcDBStatement::dbsPrepare, file CC_OdbcDBStatement.cpp, line 217)
Any idea what is the issue?
Thanks In Advance.
Error on Column Analysis
Error on Column Analysis
Rao V
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Looks like you are using the ODBC connector, have you tried profiling the same table via the Teradata connector? If you check the analysis settings option to "retain scripts" it will save the DataStage job that performs the column analysis in the AnalyzerProject and you look through the Director logs. Looks like something went wrong in the SQL select.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Only ODBC Connector is supported with Information Analyzer Version 8.0.1.But i tried with Teradata connector and it is saying not supported with this version.
I went and checked in Datastage director for this job and it is having the same error message what ever i posted earlier.But Here I am pasting some of the Informationa messages from the Datastage director.
pxbridge: No design time SQL datatype provided for field CountyCode
No design time SQL datatype provided for field CountyName
No design time SQL datatype provided for field StateCode
Is it gives any information.
I went and checked in Datastage director for this job and it is having the same error message what ever i posted earlier.But Here I am pasting some of the Informationa messages from the Datastage director.
pxbridge: No design time SQL datatype provided for field CountyCode
No design time SQL datatype provided for field CountyName
No design time SQL datatype provided for field StateCode
Is it gives any information.
Rao V
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: