Re: Updating Table Components via Web Service or PL/SQL (362 Views)
Reply
Occasional Contributor
onalcem
Posts: 3
Registered: ‎07-03-2013
Message 1 of 5 (499 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

 

Please use plain text.
Honored Contributor
Utkarsh_Mishra
Posts: 686
Registered: ‎07-13-2010
Message 2 of 5 (469 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)
Please use plain text.
Occasional Contributor
onalcem
Posts: 3
Registered: ‎07-03-2013
Message 3 of 5 (464 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.

Please use plain text.
HP Expert
Etienne_Canaud
Posts: 161
Registered: ‎10-15-2010
Message 4 of 5 (431 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.

Please use plain text.
Honored Contributor
AlexSavencu
Posts: 593
Registered: ‎04-30-2010
Message 5 of 5 (362 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
Please use plain text.
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