Author Topic: Cannot fill stored procedure arguments  (Read 1445 times)

Offline Ross Beehler

  • Associate
  • **
  • Posts: 3
  • Forum Citizenship: +0/-0
Cannot fill stored procedure arguments
« on: 03 Aug 2009 10:01:03 am »
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
« Last Edit: 03 Aug 2009 10:03:25 am by Ross Beehler »

Offline Ross Beehler

  • Associate
  • **
  • Posts: 3
  • Forum Citizenship: +0/-0
Re: Cannot fill stored procedure arguments
« Reply #1 on: 03 Aug 2009 10:22:51 am »
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...