I have a support case in on this - C131989 - but figured I’d ask here as well. I have an existing workspace that’s been running fine every night for months. All it does is access several tables in an AS/400 DB2 database (via an ODBC connection) and export these to a SQL Server database. This is about as simple as an FME workspace can be i.e. one reader to one writer for several tables, no transformers. I now need to add a new table. When I try to import the feature type from the reader, I get the list of tables, select the one I want, and then get the following error:
Opening ODBC 3.x Reader
ODBC 3.x Reader: Dataset = GTCOUNTY.HTEDTA. Username = citywork. Password = ************
Connecting to database...
ODBC 3.x Reader: The DBMS name fetched by ODBC driver is 'DB2/400 SQL'
ODBC 3.x Reader: The DBMS version fetched by ODBC driver is '07.01.0015'
ODBC 3.x Reader: Database version is '7.1.15'
ODBC 3.x Reader: Current schema is 'citywork'
ODBC 3.x Reader: Now reading schema for LMASREP
Database Generated Error Information:
Database Error Message: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0501 - Cursor SQL_CUR04D2E820 not open.
Database SQL Statement Text: SELECT * FROM "LMASREP" WHERE 1=0
SQL State: 07005
Variable Information:
ODBC 3.x Reader: Failed to get schema for feature type 'LMASREP'. Continuing with next feature type in the list
Closing ODBC 3.x Reader
I’ve also tried re-adding the existing tables and adding other tables and get the same error. So this isn’t table specific. It appears to be with all listed tables.
Finally, I have setup a linked server in the target SQL Server instance and can access these tables using the same user and ODBC connection.
Any ideas?
- Brooks