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

Cannot fill stored procedure arguments

Started by Ross Beehler, 03 Aug 2009 11:01:03 AM

Previous topic - Next topic

Ross Beehler

I setup an event to update the database via a data modification stored procedure, but event studio will not allow me to set the value of the arguments.  It actually reads all arguments just fine, but the Method dropdowns and Value text boxes are disabled.  When I preview the event, I get this statement:

The stored procedure for this database update does not accept arguments. It would run once using the default task execution rules. However, when this agent runs, it will perform this task only for the events that meet the specified execution rules: 'New events; Ongoing events'.

Attached is what I see in event studio.

Note that even framework manager sees the arguments as 'in'.

This is for Cognos 8.4.

Anyone know what I'm missing?

Thanks!
Ross

Ross Beehler

Found the solution: http://www.cognoise.com/community/index.php/topic,982.0.html

I did not have a parameter defined in the value of the argument within framework manager.  Would be nice if event studio's help would list that as a requirement too...