Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

HELP!! URGENT

Highlighted
RRK_19
Regular Collector

HELP!! URGENT

Hi,

 

Does anyone know in which table the values under "References"  & "Notes" section will be stored in PPM.

 

Can we alter / add manual entries to these sections using a SQL query?

 

Pls help, URGENT!!

 

 

Thanks,

Roopesh Kumar

 

7 REPLIES
TurboMan
Member

Re: HELP!! URGENT

Hi,

 

ITG_NOTES table has all the note details.

Mohit_Agrawal
Frequent Visitor

Re: HELP!! URGENT

Hi Roopesh,

 

The notes are stored in KNTA_FIELD_CHANGE_NOTES. And references are stored in KNTA_REFERENCES.

 

And it's possible to update these tables.

 

Thanks!!

Mohit Agrawal

::Please Give KUDOS if you like this and Mark it as Accepted Solution if this resolved your query::

Raj Ghimire
Occasional Visitor

Re: HELP!! URGENT

Actually,

Data from the "Notes" section is probably is stored in  KNTA_NOTE_ENTRIES Table. 

And Primary table for References is KNTA_REFERENCES  but there could be other associated tables as well depending on what kind of info you are looking for or want to populate.

Thansk.

-Raj

 

RRK_19
Regular Collector

Re: HELP!! URGENT

Hi ,

 

We are currently having two fields in 'Details' section, Attachment (Component type: ATTACHMENT) and URL(Component type: Web Address (URL)).

But now our requirement is to remove these fields from this section, so we are planning to move the attachments & URL present in these fields to the Refernce section using a sql script manually for all existing requests in PPM.

 

I need to know for doing this, which all tables needs to be updated ?

 

As far as my analysis, 1. for URL ---> if we insert in KNTA_REFERENCES it is working

2. for Attachments ---> we need to insert in KNTA_DOCUMENTS & KNTA_REFERENCES. Is this enough or some other tables also needs to be updated?

 

Thanks.

 

 

Raj Ghimire
Occasional Visitor

Re: HELP!! URGENT

Yes, KNTA_REFERENCES shhould be the Primary tabel for References in case of URL value but you may also want to take a look at KNTA_REF_RELATIONSHIPS_NLS  as well to make sure the value is refereced properly.

 

Moving an attachement may be a little tricky & Risky !

What are you using for your document management in PPM? There could be various ways: simple filesystem storage, Documentum or PPM DMS. 

 

 

I have never moved an attachment itself ever since we moved off of the filesystem storage to DMS. So, I would strongly suggest you to make sure about this with HP Support so that the move doesn't break any request attacment relationship as some could be critical docs. In either case, Depending on how you are storing and whether or not Versioning  is enabled, the attachments in Reference probably would involve KNTA_REFERENCES,  KNTA_REF_RELATIONSHIPS_NLS, KNTA_DOCUMENTS, KNTA_DOCUMENT_VERSION, KNTA_DOCUMENT-TIP_CONTENTS, and KNTA_DOCUMENT_HISTORY_CONTENTS tables.

 

And of couse you should not forget about the KCRT_REQUESTS Table in Both the cases to make sure you don't run into any possible cache issues.

 

-Raj

 

Sowmya_21
Acclaimed Contributor

Re: HELP!! URGENT

Hi Raj,

 

Need your help further to know , when a request is created and data is filled in the notes section, where is this stored in the DB.Thanks in advance.

Raj Ghimire
Occasional Visitor

Re: HELP!! URGENT

Data from the "Notes" Section is stored in KNTA_NOTE_ENTRIES Table. The column parent_entity_primary_key stores the request id.  Here is script you can use to insert notes. Hopefully this can help you ... 

Thanks.

-Raj

 

 

INSERT INTO knta_main.KNTA_NOTE_ENTRIES(
note_entry_id,
parent_entity_primary_key,
note,
last_update_date,
last_updated_by,
creation_date,
created_by,
parent_entity_id,
author_id,
authored_date,
note_context_value,
note_context_visible_value)
select knta_main.KNTA_NOTE_ENTRIES_S.nextval,request_id
,'Put your Notes here',
sysdate - (1/(24 *60*60)),
1,
sysdate - (1/(24 *60 *60)),
1,
20, --parent_entity_id for Request is 20
1,
sysdate - (1/(24 *60 *60)),30242,
'Request Status Value here'
from kcrt_requests  
where
request_id in (Request IDs separated by commas);

//Add this to "OnDomLoad" event