Saturday, April 24, 2010

Notification Mailer Issue - Unable to approve/reject leave/PO using Outlook

Hello All,

Few days back , HRMS Team enabled the functionality to Approve/Reject the Employee's Leave through Mail ; But the User started complaining that the functionality is not working for few employees.

So after analysing the issue, we found out that the employees/managers who approve/reject the leave through "Webmail" were able to approve/reject the leave ; The employees/manager who use Outlook were able to view the Approve / Reject buttons but functionality was not working.

So after drilling down the issue , we have found that the one of the "Template" was not supporting the Outlook Header.
To fix the issue , we changed the Template "Open Notification (Direct Response Parsing)" to "Workflow Open Mail (Direct)" and bounced the Notification Mailer.

Navigation :
Login as Sysadmin > System Administration > OAM > Notification Mailer > Edit > Advanced > Step 4 of 8 > Templates section.

Thanks to metalink... :)

Sunday, April 4, 2010

Unable to login into ERP through SSO -- 500 Internal Server Error

Hi All,

Few days back , Users started complaining that they are unable to login into ERP.

Our Current Setup :
When the user enters the credentials , it is authenticated by IDM [with Sun LDAP ] and generates the token and once IDM authenticates , the request is forwarded to OID with the token , OID accepts the token and checks the user accounts in OID.

Error :
When the User enters the login details in SSO page, we used to get token , but also the error "500 Internal Server Error".

Error in ssoServer.log :
[ERROR] AJPRequestHandler-ApplicationServerThread-5 Audit log insertion exception: ORA-01536: space quota exceeded for tablespace 'IAS_META'
ORA-06512: at "ORASSO.WWSSO_AUDIT_LOG", line 248
ORA-06512: at "ORASSO.WWSSO_AUDIT_LOG", line 203
ORA-06512: at line 1



Cause :
The default schema , ORASSO allocated quota on tablespace was full , which didnt allow users to login into ERP.
Unable to execute/trigger the procedure "ORASSO.WWSSO_AUDIT_LOG" .

The ORASSO.WWSSO_AUDIT_LOG_TABLE_T table keeps track of SSO transactions in the Oracle Portal.
The WWSSO_AUDIT_LOG_TABLE_T table is very useful and is owned by the ORASSO user. It contains very important information about the Single Sign On transactions.


Solution:
We checked the Apache log file , it showed us the message of received token , but no error.
So , we changed the quota to unlimited , which resolved the issue.

-Avadhut