on 05-23-2015 5:08 PM
Hi Experts,
We are currently on 4.1 SP5 FP3 on Windows server 2008 equipped with a 64 GB RAM . Everytime I am choosing even a single report in a promotion management job and hitting 'add and close' I am getting the error
Sorry, Promotion management application is unable to process your request.
The error from the server is: Failed to get dependencies of the job.(PRS 00048)com.businessobjects.framework.dependency.dm.exception.DMException$ExceptionWrapper: The argument has an invalid value rules (FWM 02024) at com.businessobjects.framework.dependency.dm.internal.DependencyManager.checkParams(DependencyManager.java:130) at com.businessobjects.framework.dependency.dm.internal.DependencyManager.calculateDependencies(DependencyManager.java:142) at com.businessobjects.lcm.dependencies.DependencyManager.computeDMDependencies(DependencyManager.java:725) at com.businessobjects.lcm.dependencies.DependencyManager.calculateDependenciesUsingDM(DependencyManager.java:694) at com.businessobjects.lcm.dependencies.DependencyManager.calculateDependenciesUsingDM(DependencyManager.java:679) at com.businessobjects.lcm.dependencies.DependencyManager.computeDependees(DependencyManager.java:659) at com.businessobjects.lcm.core.LCMEngine.computeDependees(LCMEngine.java:1264) at com.businessobjects.lcm.job.Job.computeDependencies(Job.java:1130) at com.businessobjects.lcm.job.Job.computeDependencies(Job.java:1106) at com.businessobjects.lcm.job.Job.addPrimaryResources(Job.java:402) at com.businessobjects.lcm.job.Job.addPrimaryResources(Job.java:286) at com.businessobjects.lcm.actionHelper.JobActionHelper.addResourceToJob(JobActionHelper.java:4518) at com.businessobjects.lcm.actionHelper.JobActionHelper.performAction(JobActionHelper.java:330) at com.businessobjects.lcm.actions.JobActions.execute(JobActions.java:59) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:646) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at com.businessobjects.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:110) at com.businessobjects.http.servlet.internal.ServletLastFilterChainElement.service(ServletLastFilterChainElement.java:30) at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:46) at com.businessobjects.bip.core.web.filter.StrutsParamFilter.doFilter(StrutsParamFilter.java:31) at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72) at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43) at com.businessobjects.lcm.LCMCacheControleFilter.doFilter(LCMCacheControleFilter.java:27) at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72) at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43) at com.businessobjects.bip.core.web.boetrustguard.BOETrustPrepareFilter.doFilter(BOETrustPrepareFilter.java:35) at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72) at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43) at com.businessobjects.bip.core.web.supportabilty.TraceLogScopeFilter.doFilter(TraceLogScopeFilter.java:38) at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72) at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43) at com.businessobjects.sdk.actionfilter.WorkflowFilter.doFilter(WorkflowFilter.java:45) at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72) at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43) at com.businessobjects.bip.core.web.appcontext.RequestInitFilter.doFilter(RequestInitFilter.java:26) at com.businessobjects.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:72) at com.businessobjects.http.servlet.internal.filter.FilterChainImpl.doFilter(FilterChainImpl.java:43) at com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.serviceHelper(BundlePathAwareServiceHandler.java:235) at com.businessobjects.http.servlet.internal.BundlePathAwareServiceHandler.service(BundlePathAwareServiceHandler.java:197) at com.businessobjects.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:248) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:220) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.businessobjects.pinger.TimeoutManagerFilter.doFilter(TimeoutManagerFilter.java:168) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1736) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1695) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:763) Caused by: com.crystaldecisions.sdk.exception.SDKException$InvalidArg: The argument has an invalid value rules (FWM 02024) ... 67 more com.businessobjects.framework.dependency.dm.exception.DMException$ExceptionWrapper: The argument has an invalid value rules (FWM 02024)
I found two recommendation 1779821 and 1962884 and analyzed both as potential solution.
I applied SAP note 1779821 by typing 'TEMP' in
RUN and
deleting folders starting with Derby . Observed the names are like -
Derby_78fb09cb-14d059486e2--7fff I had to stop tomcat prior to this
activity [the steps described in the KBA are applicable for unix so had to guess if I am doing it right on windows or not please let me know if this is right or not ]
I tried applying SAP note
1962884 as well . Executed the following query in
query builder - select si_id from ci_appobjects where si_name in
('Platform Search Delta
Index Folder','Platform Search Content Surrogates') gave me two
SI_IDs 4445[Platform search delta index folder],4680
[platform search Content Surrogates] Prior to deleting DB records
based on these two SI_ID I wanted to verify
what are those rows that the delete statements are going to delete .
And executed these three SQLs - SQL> select * from
cms_relations7 where parentid in(select objectid from
cms_inf oobjects7 where parentid in (4445,4680)); no rows
selected SQL> select * from cms_relations7 where childid
in(select objectid from
cms_info objects7 where parentid in (4445,4680)); no rows
selected SQL> select * from cms_infoobjects7 where parentid in
(4445,4680); no rows selected .
The result suggests the
delete statements would have deleted nothing.
Please help as it is greatly affecting migration activity .
Thanks ,
Sourav Roy
Hi
According the SAP Note 2137769 - Exception thrown when adding a WebI report to a Promotion Management job in BI 4....
The issue has been fixed in SAP BusinessObjects Business Intelligence Platform. The exact SP and Patch information will be available under "Support Packages & Patches" section once it is released to SAP Service Market Place.
The tentative release dates for the same is available in the following SMP link. https://service.sap.com/bosap-maintenance-schedule
Note: Patch release dates are tentative and subject to change.
You need to apply this patch to the Business Intelligence Platform.
SAP Note 330793 explains how to download patches from SAP Service Marketplace.
I hope the above is useful to you.
Regards,
István
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
1. Does it happen if you add any object (User, Universe, connection,report etc..).
2. Did you try restarting APS (which has LCM services)
Regards,
Rohit Vamsi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
It is possible you are affected by the BUG which is addressed in the following SAP Note 2137769 which is fixed in SP 05 Patch 4 and SP06.
--
Patrick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Sourav,
Please try to migrate reports or universe through UMT.
UMT will definitely fetch all dependencies. Please add switch in UMT properties before migration.
Thanks,
Abhishek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sourav,
Did you the APS Configuration Wizard to split the APS properly base on you HW sizing. Also after the APS split have you adjusted the Java Heap memory to 2Gig.
Regards,
Ajay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.