Project and Portfolio Management Support and News Forum
Showing results for 
Search instead for 
Do you mean 

Exceptions data in databse

Regular Advisor

Exceptions data in databse

Hi,

 

Can any one please let me know how to get exceptions data from data base and how to relate with project tasks. Please find the attachment which will let you know what exactly I was asking.

 

Thanks,

Bhuvan.

5 REPLIES

Re: Exceptions data in databse

Try this out.. It should give you what you're looking for..!!

 

select ke.source_id, kert.rule_type_name, ke.EXCEPTION_MESSAGE, ke.VIOLATION
from
KNTA_EXCEPTIONS ke,
KNTA_EXCEPTION_RULES ker,
KNTA_EXCEPTION_RULE_TYPES kert
where ke.EXCEPTION_RULE_ID = ker.EXCEPTION_RULE_ID
and ker.EXCEPTION_RULE_TYPE_ID = kert.EXCEPTION_RULE_TYPE_ID
and ke.SOURCE_ENTITY_ID = 59 -- For Tasks
and ke.SOURCE_ID = 000000 -- Task ID

----------------------------------------------------------------
++ Remember to give Kudos to answers..! (click the KUDOS star)

Regular Advisor

Re: Exceptions data in databse

Hi Shiva,

 

Query provided did not work. Any ideas or modifications to the query?

Thanks,

Vamsee.

Re: Exceptions data in databse

I'm assuming you've tried by replacing the '000000' with your task id from the wp_tasks table..? What version of the tool are you using..? It works fine for me on v 9.14...

 

Are you receiving any error when running the SQL or is it just not giving you the expected result..?

----------------------------------------------------------------
++ Remember to give Kudos to answers..! (click the KUDOS star)

Highlighted
Regular Advisor

Re: Exceptions data in databse

Hi Shiva,

 

I am using PPM 8.04.

 

Yes I tried replacing the '000000' with the Task id. Not sure if we have to use different query for 8.04 version.

 

Please let me know if you have any suggestion or ideas.

 

Thanks,

Vamsee.  

Regular Advisor

Re: Exceptions data in databse

Hi Shiva,

 

Any suggestions. We are on 8.04 version.


Thanks,
Vamsee.