Project and Portfolio Management Practitioners Forum
cancel

Backend updates to KNTA_NOTE_ENTRIES broken due to upgrade from 6.0.15 to 7.1

Highlighted
MidrangeTeam
Regular Contributor.

Backend updates to KNTA_NOTE_ENTRIES broken due to upgrade from 6.0.15 to 7.1

Hi All

Currently we are facing an issue where we have note entered in knta_note_entries table manually through the database without using the interface. These notes should become visible immediately (like they do in our production system (6.0.15)). but they aren't.


This the procedure we are using in adding the notes in for both our production system and our test bed for the upgrade

procedure add_note(p_request_id Varchar2,
p_user_name Varchar2,
p_authored_date Date default sysdate,
p_note CLOB,
--p_note varchar2,
o_status out varchar2,
o_status_message out varchar2) is

ln_status_id Number;
ln_user_id Number;



Begin
ln_status_id := null;
ln_user_id := null;


-- get the kintana user id from the SSO or kintana user name
ln_user_id := GE_WEBSERVICE_HELPER.GET_KNTA_USERID(p_user_name);

ln_status_id:= GE_WEBSERVICE_HELPER.get_status_id(p_request_id);

insert into knta_note_entries (note_entry_id,
creation_date,
created_by,
last_update_date,
last_updated_by,
parent_entity_id,
parent_entity_primary_key,
author_id,
authored_date,
note_context_value,
note_context_visible_value
,note
)
values (knta_note_entries_s.nextval,
sysdate,
ln_user_id,
sysdate,
ln_user_id,
GE_WEBSERVICE_HELPER.get_knta_entity_id(gv_request_entity),
p_request_id,
ln_user_id, -- author
p_authored_date,
ln_status_id,
GE_WEBSERVICE_HELPER.get_status_name(ln_status_id)
,p_note
);

COMMIT;




-- set success flag
o_status := gv_success;
o_status_message := null;

exception when others then
-- Exception raised so signal failure
o_status := gv_failed;
o_status_message := substr(sqlerrm,1,250);
end add_note;


In the Technical Reference Manual (http://support.openview.hp.com/selfsolve/document/KM248463/binary/PPM_Center-PPM_v7.1-TRM_pdf) for 7.1 it states that you shouldn't do it this way as it is unreliable that it will work.

I was wondering if anyone new if there is a JAVA Kintana GUI interface API for adding notes that I can use which will result in real time updates?

I have a case with the support but they can't help me as this type of thing isn't supported, I have asked for a HP R&D specialist but this will take sometime.

Hopefully someone can help me out!

Regards
Charles
8 REPLIES
Erik Cole
Acclaimed Contributor.

Re: Backend updates to KNTA_NOTE_ENTRIES broken due to upgrade from 6.0.15 to 7.1

You might be able to leverage the KWFL_REQUEST_HOOKS.Update_Parent_Note procedure...? Think you can also do this via web services using addRequestNotes operation, but we don't have web services running here so I can't give an example.
MidrangeTeam
Regular Contributor.

Re: Backend updates to KNTA_NOTE_ENTRIES broken due to upgrade from 6.0.15 to 7.1

Thanks for the update, but using KWFL_REQUEST_HOOKS.update_parent_note doesn't work, it inserts the note into the knta_note_entries table but it still doesn't make it visible in the GUI.

I was wondering what this webservice is about, do you have anymore information?
VijayVignesh
Frequent Contributor.

Re: Backend updates to KNTA_NOTE_ENTRIES broken due to upgrade from 6.0.15 to 7.1

Yes, You can add notes via webservices. Its simple and reliable.

b4 that, is webservice enabled in ur PPMC.
Erik Cole
Acclaimed Contributor.

Re: Backend updates to KNTA_NOTE_ENTRIES broken due to upgrade from 6.0.15 to 7.1

For web service info, look up the SOA guide on the support site.

Are you also updating the Request's last_update_date when you insert into knta_note_entries? If not, I'd try that as well. Usually if you're making changes without updating this, then PPM doesn't know that the request was updated and continues to display the cached data instead of what actually exists in the database.
MidrangeTeam
Regular Contributor.

Re: Backend updates to KNTA_NOTE_ENTRIES broken due to upgrade from 6.0.15 to 7.1

Hi All

Has anyone ever tried to use the webservices with a Siteminder plugin installed?
MidrangeTeam
Regular Contributor.

Re: Backend updates to KNTA_NOTE_ENTRIES broken due to upgrade from 6.0.15 to 7.1

Hi All

Nevermind, worked my way around it for now.

By the way, the update to the Authored date didn't work either.

I am now trying to use the webservices, just doing a test at the moment from my machine to the test instance I have sitting on a server but when ever I try to run the Webservice toolkit examples I get


INFO: Discarding unexpected response: HTTP/1.1 100 Continue
Exception in thread "main" org.apache.axis2.AxisFault: HTTP Transport error : '405' - 'HTTP method POST is not supported by this URL';

When trying to run the DemandServiceClient as recommended in the documentation. run_client.bat examples.dm.DemandServiceClient http:///ppmservices/DemandService

Regards
Charles

MidrangeTeam
Regular Contributor.

Re: Backend updates to KNTA_NOTE_ENTRIES broken due to upgrade from 6.0.15 to 7.1

Ok, I have worked out what I was doing wrong missed the /ITG in the url.

I was wondering if anyone knew how to get rid of the 'the originally entered by ' from the notes when using the webservice?

Regards
Charles
MidrangeTeam
Regular Contributor.

Re: Backend updates to KNTA_NOTE_ENTRIES broken due to upgrade from 6.0.15 to 7.1

Resolved issue using Webservices toolkit, thanks for all your help.