Re: Updating Table Components via Web Service or PL/SQL (643 Views)
Reply
Occasional Contributor
onalcem
Posts: 3
Registered: ‎07-03-2013
Message 1 of 6 (678 Views)
Accepted Solution

Updating Table Components via Web Service or PL/SQL

[ Edited ]

Hi,

 

While trying to update the table component via Web Service using "setRequestFields" operation, I'm having a problem due to the fact that while it's supported to send "SimpleFields, references, notes, table" at the creation of the request, on the other hand updating is only supported for "SimpleFields".

 

Actually it's a bit weird not being able to update table components. 

 

Webprogrammers document doesn't include any clue driving me to the solution. Could you please advise any method/trick that I can use for updating table component?

 

I'm using a PL/SQL function for Add/Update/delete operations, however the subsequent use of this function for several times causes problems such that either it doesn't add the number of records vigorously or doesn't delete the records as expected. Thus, I'm performing a "flush cache" after add...

 

You can also find the sample code I want to use as follows:

 

DemandWebService.Table [] tablo = new DemandWebService.Table[1];
tablo[0] = new DemandWebService.Table();
tablo[0].token = "REQD.VP.FAKE_STAFFING_PROFILE";
tablo[0].columns = new Column[4];
tablo[0].columns[0] = new Column();
tablo[0].columns[0].token = "T.FAKE_STAFFING_PROFILE.RESOURCE_POOL";
tablo[0].columns[0].values = new String[] { "HELLO", "WORLD" };

tablo[0].columns[1] = new Column();
tablo[0].columns[1].token = "T.FAKE_STAFFING_PROFILE.MANAGER";
tablo[0].columns[1].values = new String[] { "X", "Y" };

tablo[0].columns[2] = new Column();
tablo[0].columns[2].token = "T.FAKE_STAFFING_PROFILE.MAN_DAY";
tablo[0].columns[2].values = new String[] { "0", "0" };

tablo[0].columns[3] = new Column();
tablo[0].columns[3].token = "T.FAKE_STAFFING_PROFILE.MAN_DAY2";
tablo[0].columns[3].values = new String[] { "0", "0" };

 

 

 

I'm operating on PPM 9.14.

 

Swift reply will be appreciated.

 

Thanks in advance,

 

Cem ÖNAL

 

Honored Contributor
Utkarsh_Mishra
Posts: 714
Registered: ‎07-13-2010
Message 2 of 6 (648 Views)

Re: Updating Table Components via Web Service or PL/SQL

You also need to set these column and table object.

 

tablo[0].addNewColumns()

and 

column.setValuesArray()

 

 

 

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Occasional Contributor
onalcem
Posts: 3
Registered: ‎07-03-2013
Message 3 of 6 (643 Views)

Re: Updating Table Components via Web Service or PL/SQL

Thank you for answering Utkarsh but I'm developing my project with C#. By the way as I said web service doesn't support to update Table Components. Table component fields can be set only when you create a request. That's my main problem.

HP Expert
Etienne_Canaud
Posts: 183
Registered: ‎10-15-2010
Message 4 of 6 (610 Views)

Re: Updating Table Components via Web Service or PL/SQL

That's indeed a documented limitation of PPM SOAP Web Services.

 

If you want to update a request table component after its creation, you'll have to use the DM REST Web Services introduced in PPM 9.20. 

An upgrade is required, as the REST interface is not publicly available in PPM 9.14.

 

Kind Regards,

Etienne.

Honored Contributor
AlexSavencu
Posts: 595
Registered: ‎04-30-2010
Message 5 of 6 (541 Views)

Re: Updating Table Components via Web Service or PL/SQL

Hi,

Unfortunately for PPM 9.x will have to update via PL/SQL and flush the server cache.

Cheers
Alex

--remember to kudos people who helped solve your problem
Occasional Advisor
Kushalch
Posts: 7
Registered: ‎09-23-2013
Message 6 of 6 (33 Views)

Re: Updating Table Components via Web Service or PL/SQL

hi,

 

related to the updation, we have a requiremnent where we want to add a new row in a table in 1 request from a table in request 2. the rows are added fine when we add a row in the last but not when we add somewhre in the table ie in middle.

 

please let me know how to handle this.

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.