APAR status
Closed as program error.
Error description
Getting errors when using 'Test' or 'View Data' in ODBC Common Connector (note same problem with other CC as well) 'StageType object(s) could not be found for connection type ODBCConnector.' No problems with Runtime. Also cannot use Connector Import Wizard, as it produces a blank Connector selection list.
Local fix
Have to manually uninstall and reinstall all the common connectors. i.e Before uninstalling, copy the installation jar from <InformationServer>/Server/StagingArea/Installed/ODBCConnector/C C_ODBC_*_installation.jar to a safe location. To uninstall: 1) Source dsenv -- for Unix installations only 2) Run dscompinst -username user -password pwd -remove ODBCConnector To reinstall: 1) Source dsenv 2) Run dscompinst -username user -password pwd -skipstagecheck -install -force <saved_jar_location>/CC_ODBC_*_installation.jar For other connectors re-install in the same way. The connector name to use in the uninstall and reinstall command are: DB2Connector OracleConnector TeradataConnector WebSphereMQConnector DTStage
Problem summary
There is an issue on IBM Information Server 8.5 with Common Connectors (CC) whereby you will not be able to 1. Browse data using any CC. 2. Use Test button to validate connection details for CC Both of the above would report errors of 'StageType object(s) could not be found for connection type XXXXConnector (for example ODBCConnector) 3. Not able to import Metadata - due to getting a blank CC listing.
Problem conclusion
Connect IBM InfoSphere Information Server Support to get Repair tool patch_JR38573_client_windows_8500.zip to fix the issue.
Temporary fix
Comments
APAR Information
APAR number
JR38573
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
850
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-12-31
Closed date
2011-02-23
Last modified date
2011-02-23
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R850 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
23 February 2011