I also developed it using webservices for 7.5 and than use in 9.1 with small changes.
But not long time ago we became to get error. Project is created and in the first step it must create staffing profile, failed with following error, and cannot forward workflow manually, also cannot create staffing profile manually for some time.
I also have open HP Case. In this forum I found some topics with same error.
Does anybody have information about this error? Is it bug or what we have to control?
We never get same error on Test enviroment which is copy of PROD.
One or more references in this Request is being updated by another DB session.
PPM Web Service. Contact PPM Center support with the detailed information if the problem persists. (KNTA-11186) Details: org.hibernate.StaleStateException: Batch update returned unexpected row count from update; actual row count: 1; expected: 3 for SQL: update itg_trustee set version=?, is_enabled_flag=?, created_by=?, creation_date=?, last_updated_by=?, last_update_date=?, trustee_type_code=? where trustee_id=? and version=? GUID=F822F9E7-808E-1BD4-9228-B258F1AA3CE9
I am having a similar requirement. We want to create blank staffing profiles when a work request (Treated as a proposal) reaches a certain step. We just want to create a SP header and access control list.
So we want to write a web service and then invoke it from a certain step in the workflow. Is it possible?
Secondly, it is for the first time we are developing a web service. I tried to go through the web service for staffing profile guide, but could not under
My solved problem with database session during creation of sp, it was about jsp errors, database problems but affected many things in ppm.
So we have request which in certain step call web service to create staffing profile and assign resource (soft booked).
Kiran, as Alex said there is good example in ppm webservice toolkit just to create SP header and assign managers to it (full java code: StaffingProfileServiceClient.java), you just have to make few changes on it and than make bat file or make class call it from command in workflow.