Project and Portfolio Management Practitioners Forum
cancel

PPM issue after 11gR2 upgrade

Highlighted
Raj Ghimire
Outstanding Contributor.

PPM issue after 11gR2 upgrade

Hello Everyone,

I am sure there are a lot f users here who have been using their PPM 7.5 with Oracle 11gR2. I was wonderding if anyone has experienced any similar kind of issue like ours.

 

We have recently upgraded our DB software from Oracle 10.2 to 11gR2(11.2.0.1) . And a few days after that we are intermittently receiving reports of  Sytem becoming unreachable for users for just a "Few second" with "503 - Service Temporarily Unavailable" Message. Sytem somes back to normal again within few seconds. 

Verified that No network issues. And DBA mentions that she cannot see anything on the DB side as well. , verified with Supoprt that Nothing much on PPM server log as well.  Not sure why else would be a good place to look.

So, was wondering if anyone else had experience with similar issue in the past . If so, can you please suggest something.

 

Thanks.

-Raj

2 REPLIES
Raj Ghimire
Outstanding Contributor.

Re: PPM issue after 11gR2 upgrade

Here is one Error we notice Everytime in PPM  server log when such issues apprear.
I wonder if anyone else has had experience with similar error before.

Thanks in advance.

-Raj

 

==============

JSESSIONID=231CAE668098630D28E1F517908D95C9.kintana,USERNAME=melvinp server:TP-Processor14:SystemOut:2011/07/27-08:19:52.295 CDT:  query = SELECT COMPONENT_NAME, VALIDATION_PROFILE_ID, FROM KNTA_VALIDATION_PROFILES VPWHERE COMPONENT_NAME like 'IsHp%'
JSESSIONID=21C4D43DF24E5E98135FE4DC663A1CAB.kintana,USERNAME=samson server:TP-Processor29:SystemOut:2011/07/27-08:54:58.908 CDT:  query = SELECT COMPONENT_NAME, VALIDATION_PROFILE_ID, FROM KNTA_VALIDATION_PROFILES VPWHERE COMPONENT_NAME like 'IsHp%'
server:Notification Service:com.kintana.core.notifications:2011/07/27-08:55:00.741 CDT: EmailNotificationAgent: querynotificationImmediateOnly: ERROR: parent without recipients
server:Notification Service:com.kintana.core.notifications:2011/07/27-08:55:00.762 CDT: EmailNotificationAgent: querynotificationImmediateOnly: ERROR: parent ID = 136655

dirkf
Acclaimed Contributor.

Re: PPM issue after 11gR2 upgrade

Hi Raj,

 

For the first issue:

 

 

JSESSIONID=231CAE668098630D28E1F517908D95C9.kintana,USERNAME=melvinp server:TP-Processor14:SystemOut:2011/07/27-08:19:52.295 CDT:  query = SELECT COMPONENT_NAME, VALIDATION_PROFILE_ID, FROM KNTA_VALIDATION_PROFILES VPWHERE COMPONENT_NAME like 'IsHp%'

 

You can see the last line showing ‘VPWHERE’ which is a syntax error, which should read ‘VP WHERE’

Whenever a user uses make a copy option and creates new request then this query is getting logged in Server Logs.

There’s a defect open for this: QCCR1L29444 – unfortunately still in ‘new’-status.

 

 

The other one:

 

server:Notification Service:com.kintana.core.notifications:2011/07/27-08:55:00.741 CDT: EmailNotificationAgent: querynotificationImmediateOnly: ERROR: parent without recipients

 

Is about failing (timesheet) notifications, most likely. Make sure that the following server.conf params have valid entries:

com.kintana.core.server.EMAIL_NOTIFICATION_SENDER=user@domain.com
com.kintana.core.server.SMTP_SERVER=smtp.domain.com
com.kintana.core.server.TMG_DATE_NOTIFICATION_INTERVAL=

Also make sure that the column "notification_sent_flag" is set to "N" in the knta_notif_txn_parents table, which means that the notification was correctly created but rejected by the mail server.

If this happens for all notifications sent, make sure you can ping the mailserver from the PPM-server also.

 

However, none of these explain a 503-error and I haven’t found anything that relates to this error. 

 

Best regards,

Dirk