Hello,
I'm trying to use an Exasol IMDB data source to create a package with framework manager 11.0.6. I have created Exasol data server connection in Cognos 11.0.6 and successfully tested it. Now, if I try too use this connection in framework manager I get an error: BMT-IMP-0002 Failed to execute metadata request. invalidDriverLocationCAF-WRN-2082 An error has occurred. Please contact your administrator.
It seems, FM cannot detect Exasol jdbc driver, but the driver is inside "drivers" folder and like I said, testing the connection from Cognos Analytics was successful. I also tested FM witch SQL Server and had no problems using the connection and creating a package.
I know Exasol is somewhat exotic DB, but it was Cognos certified and should be working.
Best regards
Quote from: eroor on 28 Jun 2017 06:51:25 AM
Hello,
I'm trying to use an Exasol IMDB data source to create a package with framework manager 11.0.6. I have created Exasol data server connection in Cognos 11.0.6 and successfully tested it. Now, if I try too use this connection in framework manager I get an error: BMT-IMP-0002 Failed to execute metadata request. invalidDriverLocationCAF-WRN-2082 An error has occurred. Please contact your administrator.
It seems, FM cannot detect Exasol jdbc driver, but the driver is inside "drivers" folder and like I said, testing the connection from Cognos Analytics was successful. I also tested FM witch SQL Server and had no problems using the connection and creating a package.
I know Exasol is somewhat exotic DB, but it was Cognos certified and should be working.
Best regards
Hi,
Can you check to see if you have the "Import relational metadata" capability granted, as per the below technote:
http://www-01.ibm.com/support/docview.wss?uid=swg21624136
Cheers!
MF.
It worked! Thank you very much MF!