This discussion is archived
0 Replies Latest reply: Nov 8, 2012 3:35 PM by user13059242 RSS

Scheduler is not working (XMLP_SCHEDULER)

user13059242 Newbie
Currently Being Moderated
Hello,

My OIM version is 9.1.0.2, WLS 10.3.3 and BI Publisher is 10.1.3.4.2 which is running on Lunix server. I have configured my BI to authendicate against AD server.

I have created 6 standard functional roles (XMLP_*) in AD and I have added couple of user in all these groups. I also created one more custom group in AD called BI_Users and added those 2 users in this group too and then added OIM User report to this BI_Users group. I can login to BI without any issues and can see the reports, run the reports and download them without any issues.

But the issue I am facing is that, I couldn't schedule the report even though the user is part of XMLP_SCHEDULER group in AD. Getting below error.
*Job scheduling failed because the user has no permission to access this report. [REPORT_URL]=[Access Policy Reports/Policy Details/Policy Details.xdo], [USERNAME]=[xelsysadm]*

I have enabled the BI log and this is what I have observerd. While user login, I can all the roles to him including XMLP_SCHEDULER

[110812_181057347][][STATEMENT] LdapValidator.getDirContext: USERDN=CN=DIT-SVC-BIP,OU=AAAA,OU=BBBB,OU=CCC,OU=DDD,DC=EEE,DC=FF,DC=GGG
[110812_181057685][][STATEMENT] LdapValidator.getDirContext: USERDN=CN=xelsysadm,OU=Accounts,OU=Users,DC=AAA,DC=BBB,DC=CCC
[110812_181057814][][STATEMENT] Get user roles(7) from Cache:xelsysadm
[110812_181057814][][STATEMENT] LdapValidator.getDirContext: USERDN=CN=DIT-SVC-BIP,OU=AAAA,OU=BBBB,OU=CCC,OU=DDD,DC=EEE,DC=FF,DC=GGG
[110812_181057873][][STATEMENT] User Attribute: primaryGroupID = 513
[110812_181057873][][STATEMENT] User Attribute: primaryGroupName = Domain Users
*[110812_181057873][][STATEMENT] User Roles:xelsysadm=XMLP_TEMPLATE_DESIGNER,XMLP_ADMIN,XMLP_ANALYZER_ONLINE,Domain Users,XMLP_SCHEDULER,DIT-BIPAdmins-GG,XMLP_DEVELOPER,XMLP_ANALYZER_EXCEL*[110812_181057874][][STATEMENT] Skip migration for cookie (ORA_XDO) is not found
[110812_181057874][][STATEMENT] request ui locale: en_US
[110812_181057874][][STATEMENT] default ui locale: en_US
[110812_181057875][][STATEMENT] bindUILocale(xelsysadm)=en_US
[110812_181057875][][STATEMENT] bindReportLocale(xelsysadm)=en_US


BUT while schedule the reports, it's not look the logined user roles, but it's trying to fetch the LDAP admin user roles and dont know why!!

[110812_181826137][][STATEMENT] Skip migration for cookie (ORA_XDO) is not found
*[110812_182405686][][STATEMENT] Get user roles(0) from Cache:CN=DIT-SVC-BIP,OU=AAAA,OU=BBBB,OU=CCC,OU=DDD,DC=EEE,DC=FF,DC=GGG*[110812_182405687][][STATEMENT] checkPathPermission: failed - User principal is null
[110812_182405687][][EXCEPTION] oracle.apps.xdo.servlet.scheduler.ProcessingException: Job scheduling failed because the user has no permission to access this report. [REPORT_URL]=[Access Policy Reports/Policy Details/Policy Details.xdo], [USERNAME]=[xelsysadm]
at oracle.apps.xdo.servlet.ui.scheduler.SchedulerServlet.scheduleJob(SchedulerServlet.java:1140)
at oracle.apps.xdo.servlet.ui.scheduler.SchedulerServlet.doPost(SchedulerServlet.java:295)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:100)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.doIt(WebAppServletContext.java:3684)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3650)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2268)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1446)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)


Can anyone please help me to solve this issue?

Thanks
log

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points