Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unknown SQL Process from Cognos 8

Status
Not open for further replies.
atomictortoise

atomictortoise

Programmer
Aug 9, 2001
9
GB
I am getting a process running on my SQL Server (2005) which is obviously kicked off by Cognos 8. This process consumes 100% of the CPU for over 3 hours before ending itself. It then kicks off again approx 1 hour later. This repeats constantly. The SQL statement that it runs is as follows....

select o.CMID from CMOBJECTS o where o.CLASSID =140 and o.CMID not in (select REFCMID from CMREFNOORD1) and o.CMID not in (select REFCMID from CMREFNOORD2) and o.CMID not in (select REFCMID from CMREFORD1) and o.CMID not in (select REFCMID from CMREFORD2)

Any ideas what is causing this and if so How do I stop it??
 
Status
Not open for further replies.

Similar threads

beegeeblueboy
  • Locked
  • Question
cdate function Impromptu 7.5 SQL script not recognised by SQL Server
Replies
0
Views
424
beegeeblueboy
beegeeblueboy
tushargaurav
  • Locked
  • Question
date time prompt not working in arabic language in cognos
Replies
0
Views
375
tushargaurav
tushargaurav
Goutham3835
  • Locked
  • Question
Dateset in Cognos framework
Replies
0
Views
326
Goutham3835
Goutham3835
Emperatriz Stredel
  • Locked
  • Question
Two Cognos reports with two Models (Framework Manager)
Replies
0
Views
351
Emperatriz Stredel
Emperatriz Stredel
NileshDhande
  • Locked
  • Question
Can I use web api as data source to cognos?
Replies
0
Views
359
NileshDhande
NileshDhande

Part and Inventory Search

Sponsor

Back
Top