Hello All,
Please help. I cannot get a new MySQL database to be usable with Datastage 8.7. I have tried using the 32 bit and 64 bit odbc driver that comes with MySQL.
I can get past the first part of the import, the connection and table list get populated. The issue is when I try to import ODBC metadata from a particular table from the new MySQL database, it causes this error: Error calling subroutine: DSR_IMPORT (Action=3); check DataStage is set up correctly in project STREAM_DASHBOARD_Dev.
MySQL: Installed on a 64 bit Redhat OS. MySQL is the free version which is not supported by IBM's Wire Protocol driver.
Datastage 8.7 is installed on 64 bit Redhat.
I have edited the uvodbc.config file:
[ODBC DATA SOURCES]
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = localhost
<MySQL_QM_Stage>
DBMSTYPE = ODBC
<MySQL_QM_DataMart>
DBMSTYPE = ODBC
<IADB>
DBMSTYPE = ODBC
<DB2_XMeta>
DBMSTYPE = ODBC
I have edited the .odbc.ini file:
[MySQL_QM_Stage]
Driver=/usr/lib64/libmyodbc5.so
#Driver=/usr/lib64/libmyodbc3_r-3.51.26.so
Description=Connector/ODBC 3.51 Driver DSN
SERVER=##.#.##.#
PORT=3306
USER=
Password=
Database=BMI_QM_STAGE
OPTION=3
SOCKET=
DriverUnicodeType=1
ERROR FROM THE METADATA IMPORT:
(The connection is broken (81002))
This error occurred on 7/13/2012 at 3:25 PM (Standard format: 2012/07/13 15:25:15)
Product Version: 8.7.0.0
Client tag: 229cd8ac-ce03-4570-8a46-ede2eaba2d56
See log: C:\IBM\InformationServer\Clients\Classic\%USERPROFILE%\ds_logs\dstage_wrapper_trace_20.log
Application: dsdesign.exe (PID 5112)
Operating System: Windows 7 6.1 Service Pack 1
Detected: WOW64 (windows running on Windows 64-bit)
.NET Framework version: 4.0.30319.269
Machine Name: WIN7-105
User Name: me...
Language: English (United States)
Time Zone: Central Daylight Time
Error message:
Error calling subroutine: DSR_IMPORT (Action=3); check DataStage is set up correctly in project STREAM_DASHBOARD_Dev
(The connection is broken (81002))
New MySQL ODBC Connection Not Working
Moderators: chulett, rschirm, roy
New MySQL ODBC Connection Not Working
Regards - Ken Breetz
Keep me in the circle of trust
Keep me in the circle of trust
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What datatypes does this table contain? Can you try to import a sample tabel with just integer and varchar columns to check whether it might have something to do with datatypes. I had a similar problem this past week where the import crashed and I found that there was a column of type "pdf" hidden in there which caused my abort/crash.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>