If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Stored Procedure not available in Event Studio

Started by kramben, 02 Mar 2012 04:28:07 PM

Previous topic - Next topic

kramben


I am not able to select my package from the dropdown in Event Studio and add a 'Update a database' trying call a stored procedure from the package.  I don't see my package in the dropdown.

These are the steps I have already done.

  • Added Stored Proc to Framework  Manager as Data Modification
  • Tested and Validated Procedure in FM
  • Published Package
  • Create New Event
  • Select package with Procedure in it
  • Attempt to add 'Update a database'

Has anyone run into this issue before?  Is there a configuration setting to allow the package with the procedure to be made available in the Event Studio Dropdown?  Permissions?  I have tried this in 2 different environments with no luck.

All suggestions are appreciated.

~M

Environment - Oracle 10~ish, Cognos 8

kramben

After going through previous posts more thoroughly I found reference to an issue similar to mine.  I needed to publish the package in the root directory of Public Folders and not in a folder (which mine was). 

Procedure was made available and worked fine.

http://www.cognoise.com/community/index.php/topic,6878.0.html

~M