Author Topic: Error in FM CA 11.0.7 with Oracle JDBC  (Read 323 times)

Offline cognos810

  • Community Leader
  • *****
  • Join Date: Aug 2014
  • Posts: 246
  • Forum Citizenship: +18/-0
Error in FM CA 11.0.7 with Oracle JDBC
« on: 12 Oct 2017 11:38:20 am »
Hi All,
Please suggest if anyone has seen this error with CA 11.0.7, or any earlier versions with DQM.

Environment Details
Database: Oracle 12c 64 bit 12.1.0.2.0
JDBC Driver: ojdbc8.jar (Also tried ojdbc6.jar)

Scenario:
  • Cogos 10.2 FM Model upgraded to CA 11.0.7
  • Enabled JDBC connectivity for the Oracle datasource, after placing the ojdbc8.jar file in the <CA11.0.7 root>/drivers folder for the one and only application tier
  • At the project level, switched from Compatible to Dynamic
  • Verifed the entire model
  • Tested some query subjects and made sure data was being returned
  • Published the package

All reports are working fine against the newly published package.

Issue
When attempting to import metadata from FM using the same JDBC enabled data source (Run Meta data wizard), I get the error as attached as image. The text of the Error says:
BMT-IMP-0002 Failed to execute metadata request. Unable to parse command block
Same error shows up when creating a brand new model against the same data source.

Stumbled upon one of the IBM KBs which suggests providing access to "Import Relational Metadata" capability. I went ahead and gave "Everyone" role R/W/E/T privileges on this capability. Moreover, I am using a system admin's login to logon to FM. Issue still persists.

Please let me know if you have seen this error in the past and have resolved the issue, or if you have any suggestions for me to try.

Regards,
Cognos810
« Last Edit: 12 Oct 2017 11:43:37 am by cognos810 »

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 9,898
  • Forum Citizenship: +598/-9
  • Cognos Software Muppet
Re: Error in FM CA 11.0.7 with Oracle JDBC
« Reply #1 on: 13 Oct 2017 03:19:51 am »
Hi All,
Please suggest if anyone has seen this error with CA 11.0.7, or any earlier versions with DQM.

Environment Details
Database: Oracle 12c 64 bit 12.1.0.2.0
JDBC Driver: ojdbc8.jar (Also tried ojdbc6.jar)

Scenario:
  • Cogos 10.2 FM Model upgraded to CA 11.0.7
  • Enabled JDBC connectivity for the Oracle datasource, after placing the ojdbc8.jar file in the <CA11.0.7 root>/drivers folder for the one and only application tier
  • At the project level, switched from Compatible to Dynamic
  • Verifed the entire model
  • Tested some query subjects and made sure data was being returned
  • Published the package

All reports are working fine against the newly published package.

Issue
When attempting to import metadata from FM using the same JDBC enabled data source (Run Meta data wizard), I get the error as attached as image. The text of the Error says:
BMT-IMP-0002 Failed to execute metadata request. Unable to parse command block
Same error shows up when creating a brand new model against the same data source.

Stumbled upon one of the IBM KBs which suggests providing access to "Import Relational Metadata" capability. I went ahead and gave "Everyone" role R/W/E/T privileges on this capability. Moreover, I am using a system admin's login to logon to FM. Issue still persists.

Please let me know if you have seen this error in the past and have resolved the issue, or if you have any suggestions for me to try.

Regards,
Cognos810

Hi,

The "Unable to parse command block" part makes me wonder if you have something odd in your data source connection? Have you checked the "JDBC Connection Parameters" field to make sure it's empty, and/or made sure that the connection has no Open Connection commands / Open Session commands / Close Session commands / Close Connection commands?

Is the data source defined using the traditional Admin Console method, or using the new Manage > Data Server Connections dialog?

Cheers!

MF.
Meep!

Offline cognos810

  • Community Leader
  • *****
  • Join Date: Aug 2014
  • Posts: 246
  • Forum Citizenship: +18/-0
Re: Error in FM CA 11.0.7 with Oracle JDBC
« Reply #2 on: 13 Oct 2017 11:21:39 am »
Hi MFGF,
By the verbage of the error, that is what we thought too, and as this was an upgrade from C10, we went in and checked the Command blocks for both the data source and the connection within. There is nothing specified in the Command blocks.
JDBC connection parameters is also empty.
Finally, the data source was configured using the traditional Admin console method and not via the  Manage > Data Server Connections dialog. However, as a part of the troubleshooting we did enable the "Allow web based modeling" on the data source property, but in vain.

Some more info: The JDBC connectivity to Oracle is using "Service ID" and Driver Type is "Thin". Attached a screenshot as well.

Regards,
Cognos810

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 9,898
  • Forum Citizenship: +598/-9
  • Cognos Software Muppet
Re: Error in FM CA 11.0.7 with Oracle JDBC
« Reply #3 on: 16 Oct 2017 02:37:38 am »
Hi MFGF,
By the verbage of the error, that is what we thought too, and as this was an upgrade from C10, we went in and checked the Command blocks for both the data source and the connection within. There is nothing specified in the Command blocks.
JDBC connection parameters is also empty.
Finally, the data source was configured using the traditional Admin console method and not via the  Manage > Data Server Connections dialog. However, as a part of the troubleshooting we did enable the "Allow web based modeling" on the data source property, but in vain.

Some more info: The JDBC connectivity to Oracle is using "Service ID" and Driver Type is "Thin". Attached a screenshot as well.

Regards,
Cognos810

Hi,

So your instance is upgraded from 10.2.2 to 11.0.7? Have you checked that you don't still have old Oracle jdbc driver files in webapps\p2pd\lib and/or v5dataserver\lib?

Cheers!

MF.
Meep!

Offline cognos810

  • Community Leader
  • *****
  • Join Date: Aug 2014
  • Posts: 246
  • Forum Citizenship: +18/-0
Re: Error in FM CA 11.0.7 with Oracle JDBC
« Reply #4 on: 16 Oct 2017 03:40:45 pm »
Hi MFGF,
Yes, the content store was upgraded. The CA11.0.7 install was a fresh install in a new location. Since we needed DQM we placed the ojdbc8.jar in the <CA_ROOT>/drivers folder. There is no other jdbc in that location or webapps\p2pd\lib and/or v5dataserver\lib.

We do see OracleJDBCAdaptor.jar that came in with the install and is located in webapps\p2pd\lib. We tried removing it and restarting the services with no success.

Regards,
Cognos810

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 9,898
  • Forum Citizenship: +598/-9
  • Cognos Software Muppet
Re: Error in FM CA 11.0.7 with Oracle JDBC
« Reply #5 on: 17 Oct 2017 02:12:33 am »
Hi MFGF,
Yes, the content store was upgraded. The CA11.0.7 install was a fresh install in a new location. Since we needed DQM we placed the ojdbc8.jar in the <CA_ROOT>/drivers folder. There is no other jdbc in that location or webapps\p2pd\lib and/or v5dataserver\lib.

We do see OracleJDBCAdaptor.jar that came in with the install and is located in webapps\p2pd\lib. We tried removing it and restarting the services with no success.

Regards,
Cognos810

I think that is probably there for where you are using a content store in Oracle?

MF.
Meep!

Offline the6campbells

  • Community Leader
  • *****
  • Join Date: Jan 2012
  • Posts: 80
  • Forum Citizenship: +5/-0
Re: Error in FM CA 11.0.7 with Oracle JDBC
« Reply #6 on: 19 Oct 2017 09:19:18 pm »
Do NOT delete the OracleJDBCAdaptor.jar, that is NOT an ORACLE JDBC driver file.

Enable web based modelling simply denotes if the connection can be seen/used from a Data Module.

The error message implies your connection has one or more connection command blocks are triggering the error.



 


       
Twittear