Backgraound Job EMAIL DISPATCHER

[Former Member]

Hi ,

We run the background job EMAIL DISPATCHER in access enforcer. The problem is that we have stopped getting email for one of the stage ( SEC_APPROVAL for NEXT APPROVER ).

When i looked at the system log in access enforcer, i found the following -

____________________________________________________

2008-10-22 17:22:54,120 [Thread-40] INFO Job ID id :EMAIL DISPATCHER

2008-10-22 17:22:54,150 [SAPEngine_Application_Thread[impl:3]_32] INFO pStrKey :9603~en

2008-10-22 17:22:54,150 [SAPEngine_Application_Thread[impl:3]_32] INFO pStrKey :9601~en

2008-10-22 17:22:54,150 [SAPEngine_Application_Thread[impl:3]_32] INFO pStrKey :9602~en

2008-10-22 17:22:54,151 [SAPEngine_Application_Thread[impl:3]_32] INFO pStrKey :9624~en

2008-10-22 17:22:54,151 [SAPEngine_Application_Thread[impl:3]_32] INFO desc isPlease enter a valid \"#_!FIELD_NAME#_!\".

2008-10-22 17:22:54,151 [SAPEngine_Application_Thread[impl:3]_32] INFO pStrKey :9625~en

2008-10-22 17:22:54,151 [SAPEngine_Application_Thread[impl:3]_32] INFO desc isPlease enter a valid \"#_!FIELD_NAME#_!\". Only digits are allowed.

2008-10-22 17:22:54,151 [SAPEngine_Application_Thread[impl:3]_32] INFO pStrKey :9626~en

2008-10-22 17:22:54,151 [SAPEngine_Application_Thread[impl:3]_32] INFO desc isPlease enter a valid \"#_!FIELD_NAME#_!\".

2008-10-22 17:22:54,151 [SAPEngine_Application_Thread[impl:3]_32] INFO pStrKey :9627~en

2008-10-22 17:22:54,151 [SAPEngine_Application_Thread[impl:3]_32] INFO desc isPlease enter a valid \"#_!FIELD_NAME#_!\".

2008-10-22 17:22:54,151 [SAPEngine_Application_Thread[impl:3]_32] INFO pStrKey :9628~en

2008-10-22 17:22:54,151 [SAPEngine_Application_Thread[impl:3]_32] INFO desc isPlease enter a valid \"#_!FIELD_NAME#_!\".

2008-10-22 17:22:54,151 [SAPEngine_Application_Thread[impl:3]_32] INFO pStrKey :9628~en

2008-10-22 17:22:54,151 [SAPEngine_Application_Thread[impl:3]_32] INFO desc isPlease enter a valid \"#_!FIELD_NAME#_!\".

2008-10-22 17:22:54,151 [SAPEngine_Application_Thread[impl:3]_32] INFO pStrKey :9623~en

2008-10-22 17:22:54,151 [SAPEngine_Application_Thread[impl:3]_32] INFO desc isPlease enter a valid \"#_!FIELD_NAME#_!\". Only Alpha-numeric, Space or Underscore characters are allowed.

2008-10-22 17:22:54,151 [SAPEngine_Application_Thread[impl:3]_32] INFO pStrKey :9622~en

2008-10-22 17:22:54,151 [SAPEngine_Application_Thread[impl:3]_32] INFO desc isPlease enter a valid name \"#_!FIELD_NAME#_!\" (Firstname Lastname).

2008-10-22 17:22:54,151 [SAPEngine_Application_Thread[impl:3]_32] INFO pStrKey :9630~en

2008-10-22 17:22:54,151 [SAPEngine_Application_Thread[impl:3]_32] INFO pStrKey :9629~en

2008-10-22 17:22:54,152 [SAPEngine_Application_Thread[impl:3]_32] INFO pStrKey :9566~en

2008-10-22 17:22:57,697 [SAPEngine_Application_Thread[impl:3]_38] INFO com.virsa.ae.accessrequests.actions.RequestViewAction : checkRoleValidity() : : INTO the method

2008-10-22 17:22:57,700 [SAPEngine_Application_Thread[impl:3]_38] WARN Ignoring null, setting to default value : 0

2008-10-22 17:22:57,701 [SAPEngine_Application_Thread[impl:3]_38] INFO com.virsa.ae.accessrequests.bo.RequestAuditHelper : logMajorAction() : : intHstId : 70141

2008-10-22 17:22:57,715 [SAPEngine_Application_Thread[impl:3]_38] INFO com.virsa.ae.workflow.bo.WorkFlowBO : saveNewWorkflow() : : INTO the method

2008-10-22 17:22:57,715 [SAPEngine_Application_Thread[impl:3]_38] INFO com.virsa.ae.workflow.bo.WorkFlowBO : saveNewWorkflow() : : OUT of the method

2008-10-22 17:22:57,726 [SAPEngine_Application_Thread[impl:3]_38] WARN Ignoring null, setting to default value : 0

2008-10-22 17:22:57,727 [SAPEngine_Application_Thread[impl:3]_38] INFO com.virsa.ae.accessrequests.bo.RequestAuditHelper : logMajorAction() : : intHstId : 70143

2008-10-22 17:22:57,762 [SAPEngine_Application_Thread[impl:3]_38] INFO Users Context is OU=users

2008-10-22 17:22:57,763 [SAPEngine_Application_Thread[impl:3]_38] ERROR LDAP_ADAM_PRD error reading search results

javax.naming.NameNotFoundException: [LDAP: error code 32 - 0000208D: NameErr: DSID-031001D2, problem 2001 (NO_OBJECT), data 0, best match of:

'CN=esso,DC=bsci,DC=com'

]; remaining name 'OU=users'

at com.sun.jndi.ldap.LdapCtx.mapErrorCode(LdapCtx.java:3030)

at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:2951)

at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:2757)

at com.sun.jndi.ldap.LdapCtx.searchAux(LdapCtx.java:1828)

at com.sun.jndi.ldap.LdapCtx.c_search(LdapCtx.java:1751)

at com.sun.jndi.ldap.LdapCtx.c_search(LdapCtx.java:1743)

at com.sun.jndi.toolkit.ctx.ComponentDirContext.p_search(ComponentDirContext.java:362)

at com.sun.jndi.toolkit.ctx.PartialCompositeDirContext.search(PartialCompositeDirContext.java:312)

at com.sun.jndi.toolkit.ctx.PartialCompositeDirContext.search(PartialCompositeDirContext.java:296)

at javax.naming.directory.InitialDirContext.search(InitialDirContext.java:234)

at javax.naming.directory.InitialDirContext.search(InitialDirContext.java:234)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.getUserByDN(LDAPSearchUser.java:234)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.setManagerDetails(LDAPSearchUser.java:745)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.getUsers(LDAPSearchUser.java:605)

at com.virsa.ae.service.umi.ldap.LDAPSearchUser.getUserById(LDAPSearchUser.java:719)

at com.virsa.ae.search.bo.SearchUserBO.getUserById(SearchUserBO.java:192)

at com.virsa.ae.workflow.bo.WorkFlowBOMailHelper.getEmailId(WorkFlowBOMailHelper.java:1652)

at com.virsa.ae.workflow.bo.WorkFlowBOMailHelper.sendStageLevelEmail(WorkFlowBOMailHelper.java:905)

at com.virsa.ae.workflow.bo.WorkFlowBOMailHelper.sendStageApproveEmail(WorkFlowBOMailHelper.java:781)

at com.virsa.ae.workflow.bo.WorkFlowBOHelper.runWorkflowForApprove(WorkFlowBOHelper.java:342)

at com.virsa.ae.workflow.bo.WorkFlowRequestApproveHelper.approveRequest(WorkFlowRequestApproveHelper.java:197)

at com.virsa.ae.workflow.bo.WorkFlowBO.approveRequest(WorkFlowBO.java:266)

at com.virsa.ae.accessrequests.bo.RequestBO.approveRequest(RequestBO.java:5311)

at com.virsa.ae.accessrequests.bo.RequestBO.approveRequest(RequestBO.java:5208)

at com.virsa.ae.accessrequests.actions.RequestViewAction.confirmRequestApproval(RequestViewAction.java:801)

at com.virsa.ae.accessrequests.actions.RequestViewAction.execute(RequestViewAction.java:88)

at com.virsa.ae.commons.utils.framework.NavigationEngine.execute(NavigationEngine.java:229)

at com.virsa.ae.commons.utils.framework.servlet.AEFrameworkServlet.service(AEFrameworkServlet.java:423)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:387)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:365)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:944)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:266)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:175)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(AccessController.java:215)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170)

2008-10-22 17:22:57,763 [SAPEngine_Application_Thread[impl:3]_38] ERROR Ignoring Exception in getting the manager details : com.virsa.ae.service.umi.UMIException: LDAP_ADAM_PRD error reading search results

com.virsa.ae.service.umi.UMIException: LDAP_ADAM_PRD error reading search results

_____________________________________________________

I'm new to GRC , kindly help me out in troubleshooting this issue.

Thanks,

NK

[Former Member]

THe problem was not in SAP, but the problem was with the exchange server for this user id and hence the mails were not going. Thank you all for your help.

[Former Member]

HI NK,

Are you using LDAP as search and User details data source in AE ?

If this is true , then test your ldap connecting @ Configuration > Connector > Available Connectors > Choose your Ldap connector as selected in User data source . Click on test connection .

If this is working fine , then check if you have done LDAP mapping correctly @ Configuration > LDAP Mapping . Make sure you have mapped your LDAP field with AE fields .

Incase all is set as above , then go to virsa_ae_emllog table and check to see if you have enteries in eml_to field corresponding to subject as given in next approver tab for the user to which mail should go as next approver for sec_approval stage. Incase it is not there then email id can not be found by AE . you need to check LDAP details of this user if it has email id maintained.

Also do check if you have assigned AEapprover role in UME to your next approver .

Hope this helps.

[Former Member]

Hi Jasmine,

I did check all that you suggested and doesn't seem to be any problem in the LDAP connection. Can you please let me know where to check the table virsa_ae_emllog ?

Everything was working in our system but we are facing this problem from last 6 days......

Where can i check if all the users are unlocked? In SU01 or ?

Where can i check the EMAIL DISPATCHER job is running or not? When i looked in AE->configuration->background job->view schedule, it shows that the job is available but it doesn't show me when it ran and all that. Where can i see that?

Thanks,

NK

Edited by: N K on Oct 23, 2008 9:08 AM

[Former Member]

Why am i getting the following messages in AE -> Configuration -> Monitoring -> System Log

_________________________________________

2008-10-23 09:30:58,356 [Thread-40] INFO Job ID id :EMAIL DISPATCHER

2008-10-23 09:30:58,356 [Thread-40] INFO The task is :com.virsa.ae.service.mail.MailScheduler@22322232

2008-10-23 09:30:58,362 [Thread-6782] INFO Host IP is :msx.abc.abcd.com

2008-10-23 09:30:58,362 [Thread-6782] INFO com.virsa.ae.dao.sqlj.EmailLogDAO : findAllForContext : : findAllForContext(SqljContext ctx) going to return ImmutableList(empty)

2008-10-23 09:31:42,231 [SAPEngine_Application_Thread[impl:3]_37] INFO pStrKey :9603~en

2008-10-23 09:31:42,231 [SAPEngine_Application_Thread[impl:3]_37] INFO pStrKey :9601~en

2008-10-23 09:31:42,231 [SAPEngine_Application_Thread[impl:3]_37] INFO pStrKey :9602~en

2008-10-23 09:31:42,231 [SAPEngine_Application_Thread[impl:3]_37] INFO pStrKey :9624~en

2008-10-23 09:31:42,231 [SAPEngine_Application_Thread[impl:3]_37] INFO desc isPlease enter a valid \"#_!FIELD_NAME#_!\".

____________________________________________________

Please suggest.

Edited by: N K on Oct 23, 2008 9:34 AM

[Former Member]

In Access Enforcer go to

Configuration -> Background Jobs

Click 'View Schedule'

If you see any of the jobs as busy, reset them to active.

The log issue could be because some jobs are busy/broken due to load.

Hope this helps!

[Former Member]

It doesn't show me "BUSY" but it shows me "Available" which i guess is the right message.