Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Token for Program ID in validaton

Highlighted
JudyZhu
Regular Collector

Token for Program ID in validaton

I am tring to create a validation for a Program User Data. Within the validation, I have to use a token to refer to program id:

 

---------------------------------------------------------------------

select fud.datum1_code, fud.datum1_VISIBLE
from
PGM_PROGRAMS pgm,
FM_FINANCIAL_SUMMARY ffs,
FM_FORECAST_ACTUALS ffa,
FM_USER_DATA fud
where
pgm.program_id = '[PRG.PROGRAM_ID]'

and pgm.financial_summary_id = ffs.financial_summary_id
and ffa.forecast_actual_id=ffs.forecast_actual_id
and fud.user_data_id=ffa.user_data_id

---------------------------------------------------------------------

 

The validation failed since the token is not parsable.

 

Can someone help me on this?

 

Judy

 

 

6 REPLIES
Celil
Esteemed Contributor

Re: Token for Program ID in validaton

Hi Judy,

 

Has the token more than one pogram ID ?

Celil

IT Governance Professional
& PPM Solution Architect
JudyZhu
Regular Collector

Re: Token for Program ID in validaton

Hi Celil,

 

I think one programs should have unique program id.

 

When the validation is running for a Program User Data field for a specified program, the program id should be unique.

 

Judy

Celil
Esteemed Contributor

Re: Token for Program ID in validaton

Hi Judy,

There is not enough data to solve it. Can you provide me; When you run this validation, what did report in server logs? can you send us the server logs which consist validation error? In addition to that can you try to get the token return what ?
Celil

IT Governance Professional
& PPM Solution Architect
JudyZhu
Regular Collector

Re: Token for Program ID in validaton

Hi Celil,

 

Here is the error in the server log:

 

----------------------------------------------------------------------

ERROR JSESSIONID=F0840052740173521E814C29305D378E.HPPPM_PWC_DEV,USERNAME=xzhu015 server:http-0.0.0.0-8080-Processor19:com.kintana.core.fields.autocomplete:2012/08/03-10:46:19.058 EDT: select fud.datum1_code, fud.datum1_VISIBLE
from
PGM_PROGRAMS pgm,
FM_FINANCIAL_SUMMARY ffs,
FM_FORECAST_ACTUALS ffa,
FM_USER_DATA fud
where
pgm.program_id = [PRG.PROGRAM_ID]
and pgm.financial_summary_id = ffs.financial_summary_id
and ffa.forecast_actual_id=ffs.forecast_actual_id
and fud.user_data_id=ffa.user_data_id
ERROR JSESSIONID=F0840052740173521E814C29305D378E.HPPPM_PWC_DEV,USERNAME=xzhu015 server:http-0.0.0.0-8080-Processor19:com.kintana.web:2012/08/03-10:46:19.089 EDT: One of the tokens in the validation was unparseable. This can be caused by an invalid token name or missing data from the field the token represents. (KNTA-10073)
nested detail:select fud.datum1_code, fud.datum1_VISIBLE
from
PGM_PROGRAMS pgm,
FM_FINANCIAL_SUMMARY ffs,
FM_FORECAST_ACTUALS ffa,
FM_USER_DATA fud
where
pgm.program_id = [PRG.PROGRAM_ID]
and pgm.financial_summary_id = ffs.financial_summary_id
and ffa.forecast_actual_id=ffs.forecast_actual_id
and fud.user_data_id=ffa.user_data_id

-------------------------------------------------------------------------------------------------

 

Judy

Celil
Esteemed Contributor

Re: Token for Program ID in validaton

Hi Judy,

Could you please config your PPM maximum verbose mode. My purpose capture the token value.
Celil

IT Governance Professional
& PPM Solution Architect
Mohit_Agrawal
Frequent Visitor

Re: Token for Program ID in validaton

Hi Judy,

 

Just try like below...


pgm.program_id = '[PRG.P.PROGRAM_ID]'

 

Thanks

Mohit Agrawal

 

 

//Add this to "OnDomLoad" event