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.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"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"},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
More support for:
IBM Cognos Analytics
Component:
Data Source, Modeling->Framework Manager
Software version:
All Versions
Document number:
7145178
Modified date:
06 May 2025
UID
ibm17145178
Manage My Notification Subscriptions