The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Error while searching projects,requests,project types etc.

Highlighted
kndlny
Regular Collector

Error while searching projects,requests,project types etc.

Hi,

 

We are using PPM v9.10. Everything was working just fine but after a PPM server restart, suddenly we were unable to search projects, requests, projct types etc.

 

When we try to search a project, we get a RuntimeBaseExeption.

When we try to search a request, standard search screen is displayed bu after clicking search, we get an Error 500.

(Screenshots of both errors can be found in the attachments)

 

This i what it says in the serverlog:

 

SystemErr:2012/03/26-09:00:40.957 VET: com.mercury.itg.exceptions.InfrastructureException: unable to return region for user Admin User


Caused by: org.hibernate.ObjectNotFoundException: No row with the given identifier exists:[com.mercury.itg.core.impl.RegionImpl#-1]

 

Anyone knows what might cause this problem?

 

 

Thanks,

3 REPLIES
Utkarsh_Mishra
Honored Contributor

Re: Error while searching projects,requests,project types etc.

You need to set Currency and Region for user Admin. If still issue persit then.. there is one solution in self-solve..

 

http://support.openview.hp.com/selfsolve/document/KM1235771

 

Is says..

 

 Cause

Investigations showed that there were no currency and thus also no base currency enabled. While it is not possible to use a fantasy-abbreviation for a region during the use of the install wizard, in this case a new region code should have been used that was changed between versions. The region used was Turkey for this case. Old code before: TRL. New code now: TRY
 
This left the table KCST_CURRENCIES without any currency enabled, no base currency was shown either.


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

 

Fix


Enable one language as a first step – take the Euro as an example:
 
1)            Check table KCST_CURRENCIES and note the ID of the currency that is needed and the one that needs to be enabled. In our example we went to enable the EUR.
EUR : CURRENCY_ID = 25
 
2)            Run the following query to enable the Euro as Currency:
UPDATE KCST_CURRENCIES SET ENABLED_FLAG = 'Y' WHERE CURRENCY_CODE = ‘EUR’;
 
3)            Run the following query to ‘activate’ the Euro as Base Currency:
UPDATE KCST_CURRENCIES SET BASE_CURRENCY_FLAG = 'Y' WHERE CURRENCY_CODE = ‘EUR’;
 
4)            If any other currencies need to be enabled, set to Y for ENABLED_FLAG appropriately as in step 2)
 
However, we then also need to set the base currency in at LEAST this other place:
 
5)            UPDATE KNTA_SERVER_PARAMETERS set value = 25 where description = ‘System Base Currency ID’;
 
6)            Commit;
 
Last parameter and value of course also dependent on the currency chosen as base in step 3.
Whichever base currency is checked therefore, choose the value for that in the table KCST_CURRENCIES.
 
BE AWARE that after you have set this currency and you have financial data in the database, you will NEVER AGAIN be able to change this value otherwise you’ll corrupt the financial data for the whole application. EVERYTHING is stored in base currency and if you change that after having worked with the instance, everything will corrupt in respect to that financial data.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
kndlny
Regular Collector

Re: Error while searching projects,requests,project types etc.

Hello Utkarsh,

 

Thanks for such a detailed reply.

 

I have checked the currency and region and everything seems correct.

 

System Base Currency is TRY with currencyID 94. Its enabled_flag and set_base_currency_flag is "Y" and region

 

is also enabled.

 

Thanks,

 

 

kndlny
Regular Collector

Re: Error while searching projects,requests,project types etc.

Hello Utkarsh,

 

I have just found out that ragion_id cloumn of KNTA_USERS is -1.

 

After and update statement it works fine.

 

thanks

//Add this to "OnDomLoad" event