DSR_IMPORT (Action=2) error- metadata imp from Netezza ODBC

shin0066 · Post by **shin0066** » Wed Apr 16, 2008 11:48 am

I am getting following error when i try to get the metadata using ODBC.

Error calling subroutine: DSR_IMPORT (Action=2); check DataStage is set up correctly in project <project name>
(The connection is broken (81002))

I am trying to connect newly created Netezza database via ODBC. Tested the Netezza odbc via datastage and it worked fine. The issue only with when i try to get the metadata using table definitions.

Same metadata extraction using ODBC for other Databases is it working fine.

Any help.

thanks

ray.wurlod · Post by **ray.wurlod** » Wed Apr 16, 2008 5:08 pm

Can you connect to Netezza using DS_CONNECT test utility?

shin0066 · Post by **shin0066** » Thu Apr 17, 2008 9:23 am

Yes, i did connect using DS_CONNECT Utility.

Do we need any patch for this?

Thanks

ray.wurlod · Post by **ray.wurlod** » Thu Apr 17, 2008 2:53 pm

Your support provider can be tasked with determining whether there are any patches related to getting metadata from Netezza.