Page 1 of 1

Type mismatch when i try to open Oracle connector stage

Posted: Tue Feb 10, 2015 3:43 am
by satheesh_color
Hi All,

I have newly installed Datastage9.1 version. Once it gets done, when i try to open oracle connector stage a pop-up window opens and say "Type mismatch" after couple of ok's it will open the connector stage, but can't able to see any property tab values and able to see the column metadata and advance tab values.

Kindly assist me to resolve the issue.


Note: Currently i dont have any other Datastage versions on my machine.

Thanks,
Satheesh.R

Posted: Tue Feb 10, 2015 1:19 pm
by cppwiz
Did these tables have timestamp columns?
Did you upgrade to v9.1.2 or apply Fix Pack 1 to the base v9.1 installation?
Did you apply this Oracle Connector patch listed below after upgrading to v9.1?

InfoSphere Information Server DataStage Oracle Connector corrupting Timestamp(microseconds) data when using multiple SQL statements.
http://www-01.ibm.com/support/docview.w ... wg21626884

http://www-933.ibm.com/support/fixcentr ... nction=all