Import stored procedure metadata error (METAGETA-4516)

[johanhamelinck]

Environment
Server : Windows 2008R2
Datastage : 8.5fp2 and 8.7

Problem :
When I try to import a stored procedure from a MS SQL 2008R2 database over a ODBC connection (tested with MS ODBC & IBM ODBC driver) I receive following error :

DSR.MetaGeta: Connot read result file DS_METATEMP record METAGETA-4516 from GetMetaData

I'm having this error using the "Import" and "Details" button on the Import Meta Data (Stored Procedures) screen.

Importing table definitions using the same connection works fine.

Anyone who has a solution for this problem ?

Thanks !

[qt_ky]

Here's an 8.5 IBM tech note on the same error / different error number / different stage type. Research the patch and contact support if need be.

JR41480: Importing a stored procedure from a Netezza database causes DSR.MetaGeta Cannot read result file DS_METATEMP record

[johanhamelinck]

Is not the solution since it involves another odbc driver....

[johanhamelinck]

possible solution (but still testing...)

Use the DataDirect V7.0 drivers.

IBM supplies the V6.0 drivers with DataStage 8.5 but these seems te be not compatible with MS SQL 2008R2.

The MS supplied ODBC driver v10 & 11 have the same issue.

After downloading & installation of the trial edition of the v7 drivers the import of stored procedures seems to work correctly.

To be continued...