Project and Portfolio Management Practitioners Forum
cancel

Issue on financial webservice (update Forecast Line Userdata)

Highlighted
Mikia
Trusted Contributor.

Issue on financial webservice (update Forecast Line Userdata)

Hi,
we are in PPM 9.14.

When I call a custom financial webservice I receive this error:
-------------------------------------------------
Exception in thread "main" org.apache.axis2.AxisFault: Unable to validate user data 2: PL10A05020 . Make sure that the user data field is defined.
 at org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:271)
 at org.apache.axis2.description.OutInAxisOperationClient.execute(OutInAxisOperation.java:202)
 at com.mercury.itg.ws.fm.client.FinanceServiceStub.updateFinancialSummary(FinanceServiceStub.java:328)
 at Merck.InsertFinancialLine.insertFinancialSummaryLines(InsertFinancialLine.java:226)
 at Merck.InsertFinancialLine.doRun(InsertFinancialLine.java:153)
 at Merck.InsertFinancialLine.main(InsertFinancialLine.java:137)
-------------------------------------------------

This webservice insert new financial line with Forecast Line Userdata.

We use this webservice to update a lot of Forecast Line Userdata and it's works fine.
The validation under userdata in which we receive the error contains userdata token ( '[UD.P_FUNDING_CMG]'); if I don't use this token everything works fine.

Please, help me!

Mara

10 REPLIES
d4y4n4
Honored Contributor.

Re: Issue on financial webservice (update Forecast Line Userdata)

Hi Mara,

We have seen some issues on web services with the same error messages having to do with caching from the database after user data fields are remapped or changed. Can you please run the following command and re-test your web service call after it?

Please navigate to your $PPM_HOME/bin folder and run the command as follows:
sh kRunCacheManager.sh A

Please do not forget the letter A.

Repeat the procedure from any additional physical servers (PPM_HOMEs) that you may have


Regards,
Dayana Campos
AlexSavencu
Acclaimed Contributor.

Re: Issue on financial webservice (update Forecast Line Userdata)

Hi,

if your validation is a list which you update in the database, make sure to set last_update_date = sysdate. In this approach, cache will automatically be refreshed without the need for full refresh, which may have undesired effects in a live environment.

cheers
Alex

--remember to kudos people who helped solve your problem
Mikia
Trusted Contributor.

Re: Issue on financial webservice (update Forecast Line Userdata)

Hi Alex and Dayana,

I'm not use a pl/sql procedure, but a custom webservice; so I run cacheManager but it don't solve my problem..

 

I think it's a bug, because if I update other forecast line user data the webservice works fine.

 

 

Mara

Kerim KILIC
Honored Contributor.

Re: Issue on financial webservice (update Forecast Line Userdata)

i didnt use financial webservices, but a suggestion in my code for project module i used parameter field rather than token

 

UserDataInfo uti = task.addNewUserData();
uti.setUserData1(taskType);

 

can you try with using userdata1 2 etc like this if available. 

 

Regards

Mikia
Trusted Contributor.

Re: Issue on financial webservice (update Forecast Line Userdata)

Hi,

thanks for your answer.

 

I'm using (similar to your code):

UserDataInfo userDataInfo = UserDataInfo.Factory.newInstance();

userDataInfo.setVisUserData2((String)

row.get("V_FUN_COST"));

userDataInfo.setUserData2((String)

row.get("V_FUN_COST"));

 

it's works fine, only for userdata2 i get an error..

 

Mara

 

Kerim KILIC
Honored Contributor.

Re: Issue on financial webservice (update Forecast Line Userdata)

you need to update either visible or nonvisible token based on validation. if you comment userdata set lines and update visible field; you see the userdata fields empty in financial? 

Mikia
Trusted Contributor.

Re: Issue on financial webservice (update Forecast Line Userdata)

Hi Kerim,

If I update only visible userdata I get the same error.. :(

 

 

Mara

Kerim KILIC
Honored Contributor.

Re: Issue on financial webservice (update Forecast Line Userdata)

if you set only userdata not visible still same error?
Mikia
Trusted Contributor.

Re: Issue on financial webservice (update Forecast Line Userdata)

yes, the same error :(

Kerim KILIC
Honored Contributor.

Re: Issue on financial webservice (update Forecast Line Userdata)

can you change the validation of user data to text field and then update only user data? i think it stucks at validation.