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
Type mismatch when i try to open Oracle connector stage
Moderators: chulett, rschirm, roy
-
satheesh_color
- Participant
- Posts: 182
- Joined: Thu Jun 16, 2005 2:05 am
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
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