Skip to Content
avatar image
Former Member

Promotion management issue - 'Failed to get dependencies of the job'

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • May 23, 2015 at 08:10 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 25, 2015 at 04:56 AM
    1. Can you Confirm If both the source and the destination systems are on the same patch level
    2. Can you try logging on to your Q/A (test server or prod or sandbox) and then try promoting (still use the same source and destination)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 25, 2015 at 05:31 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 25, 2015 at 07:47 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 25, 2015 at 11:23 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 26, 2015 at 08:39 AM

    Hi

    According the SAP Note 2137769 - Exception thrown when adding a WebI report to a Promotion Management job in BI 4.1 SP5

    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

    Add comment
    10|10000 characters needed characters exceeded