COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: RickC on 21 Apr 2009 04:28:23 PM

Title: Can no longer monitor some of the Applications
Post by: RickC on 21 Apr 2009 04:28:23 PM
After running a GTP, I click on Job Management to see how the job is progressing.  However, for two of my applications, no data is appearing.

So, I thought that they must have somehow been deleted from the Monitored Applications in the Job Server Cluster.  But they seem OK (likewise, OK in the Monitoring Console).  So, to be sure, I tried to add them but it says there is nothing to add since I am already monitoring everything.  Next, I decided to remove the monitoring of these applications and then add it back.  Still no change.

Any suggestions?
Title: Re: Can no longer monitor some of the Applications
Post by: jan.herout on 22 Apr 2009 01:22:47 AM
Accesss rights within database on object level in locked down environment?
Title: Re: Can no longer monitor some of the Applications
Post by: RickC on 22 Apr 2009 10:29:09 AM
Sorry, but I am not positive I understand your question. 

These Applications have been GTPed and had the workflow state changed to "Locked".  Is this what you think is causing the problem?

As far as the databases themselves, we have them developed by our DBAs.  Thus, I am not sure what rights I have with those files.
Title: Re: Can no longer monitor some of the Applications
Post by: jan.herout on 29 Apr 2009 09:13:49 AM
My question was related to the access rights on database level. For example, on Oracle, common situation is that the user used as content store owner does NOT have access rights needed to create objects in other schemas. This is sometimes called locked down environment.

When creating new application, does CAC generate DDL for the application? If so, you are most likely in locked down environment.

For proper function of CAC, user owning content store (or planning store, if you created one) needs to have READ privilege on database level to certain objects within application container. Perhaps you lost somehow this privilege?
Title: Re: Can no longer monitor some of the Applications
Post by: nedcpa on 29 Apr 2009 10:01:43 AM
It sounds like you are able to see the applications on the Monitor screen. If data is not showing up in the application, then it sounds like a different issue. Were all jobs ran successfully (import, GTP etc)? Can you ask your dba to check ie_cube tables (application database) and check out rejected records? Also check your access tables and see if they are blocking proper data load.

Hope it helps...
Title: Re: Can no longer monitor some of the Applications
Post by: RickC on 29 Apr 2009 11:03:51 AM
The application/model is running well and I am getting all the correct data/results on the web-site.  It's just that I can no longer monitor the GTP.  Not sure why since nothing has changed other than we copied the models to our Archive folder and ran a GTP to Lock the data (this is what we do when we want to "archive" the model so no changes can be made to it).

I did this for 10 models ... but one Application within our regular Production and one Application within our archive can no longer be monitored even thought they are still a part of the Monitored Applications.

Obviously this is not a huge show stopper, but it is annoying because the one application runs approx 40 to 80 minutes and it is bothersome trying to guess how it is progressing and when it will be done.