Troubleshooting
Problem
Microsoft SQL JDBC driver 12.6.0 includes changes that can cause stored procedures to not execute from Cognos Analytics..
An error may occur when a stored procedure is declared with at least one "in" argument and one "out" argument, and these arguments have no values defined in the Framework Manager query subject definition.
When the procedure is tested or validated in Framework manager an error similar to the following appears.
The formal parameter "@parameter_name" was not declared as an OUTPUT parameter, but the actual parameter passed in requested output.
Cause
The parameters defined in Framework Manager do not specific a value. As Dynamic Query executes the stored procedure, it attempts to pass a null value for those parameters. This results in the exception thrown by the Microsoft SQL Server JDBC driver.
Resolving The Problem
For environments using Cognos Analyics 12.0.2 or earlier, replace the Microsoft SQL Server JDBC driver with a version earlier than 12.6.0.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl6nAAC","label":"Data Source"},{"code":"a8m50000000Cl4NAAS","label":"Modeling-\u003EFramework Manager"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
23 April 2024
UID
ibm17145178