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

User Reports Run Whenever ReportNet Server Is Rebooted

Started by Sheldon, 10 May 2011 01:56:22 PM

Previous topic - Next topic

Sheldon

The following started a few weeks ago -
Whenever our ReportNet server is rebooted, which happens automatically every night, three reports are run and sent to a user who claims she never set them up and doesn't want them.
I'm the administrator and I've looked in many places but cannot see where this is "scheduled" (if reports kicking off whenever the server is rebooted could even be considered "scheduled").  In any case, does anyone have a suggestion on where to look to find this and end it?
It would make one admin and one customer VERY happy.  Thanks.

Sheldon

AussiePete2011

WHich version of Cognos are you using

Assuming c8.4, logon as the administrator and select Launch then "IBM Cognos Administration"
Select "Schedules"
In the Filters, set the "Schedule by" to the user suspected of running the report.
It should bring back any schedules by this user.

The only other way is to actually logon as that user and select "My Activities and Schedules" and look under
"Past activities", then "Schedules" to see what come up.
Most likely there is a report thats been scheduled in "My Folders" at some point.  Which is what I've been working on.

As yet another option, I believe that BSP also have this capability to capture this information

See how you get on.
Cheers
Peter B

Sheldon

Thanks for the suggestions Peter.  We are running Cognos 8.4 and I had previously tried all three items that you suggested and didn't find anything but I will try again.
And surprisingly, I didn't find anything when logging on with the customer's id & password.
I didn't realize an event could even be scheduled to occur each time the server is rebooted but, if that's the case, I thought I should be able to see that event when logged on as the administrator, and didn't.  I'll report back to this forum if I discover anything.

Sheldon

Sheldon

Searched again but do not see any scheduled or trigger events anywhere.  Does anyone know where I'd look on the server to see what makes it "know" there are three scheduled jobs to run every night?  Didn't see any trigger events either.

Thanks, Sheldon

AussiePete2011

Hi there,

Ok so this looks like it might be an orphan of a deleted job which does happen occassionally.
Next steps would be as follows

1.  Make sure you have a current backup of the content store db schema
2.  Perform an export of the entire content store
3.  In 8.4, run a consistency check by running the sub steps below
     a.  Logon to Cognos Connection (CC) as a system admin
     b.  Press Launch, then select "IBM Cognos Administration"
     c.  Select the "Configuration" tab
     d.  Select "Content Administration" on the left
     e.  Select the icon with the yellow cog on it to see the Maintenance tasks.
     f.   Select "New Consistency Check"

You'll need to play with this if you haven;t used it before as it creates a job for the selections you make and generates a report.  The is an option to fix the problems as part of the job.  It would be wise to run the consistency check without this first, then again with the option set.

After you've done this the next step would be to drop the NC tables.
There's a script under the ../<c8install>/configuration/schemas/delivery/<DB> called NC_Drop_<DB>.sql that you can run to drop the Notification Store tables.  You will then need to open the Cognos configuration (Content Manager) and restart to regenerate the NC tables.  There are a few technotes on this.
IBM Cognos Technote:  Report execution using trigger.bat does not run - Reference #:​ 1445803

See how you go.
Cheers
Peter B