cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Patrick,

I believe this is exactly our scenario right now . We are currently at FP-3 and content migration has hit this serious roadblock.

Do you think downgrading to SP-5 is a better option ?

Regards,

Sourav Roy

Former Member
0 Kudos

Hi Sourav,

If you can apply patch 4 to your platform, that would fix the issue. I believe there were other issues on SP05 - generally I'd suggest going up in version, not down.

--

Kind regards,

Patrick Bulteel

Former Member
0 Kudos

Hi Patrick ,

For the time being we have downgraded to SP-5 and that have fixed things and we are able to use promotion mgmt quite smoothly.

Thanks,

Sourav Roy

former_member185603
Active Contributor
0 Kudos

That is what we did. We installed SP5 patch3, since this is an issue, we downgraded to SP5. This issue addressed in FP4 and above. You can install FP4 or FP5.

Former Member
0 Kudos

Hi Jawahar ,

Thanks . This is something under discussion whether we should upgrade to FP4 or FP5 .

Thanks for the suggestion.

Regards,

Sourav

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Abhishek ,

UMT does not work if both platform are on 4.x .

Regards,

Sourav Roy

former_member207052
Active Contributor
0 Kudos
  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)
CdnConnection
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Ajay ,

Thanks for responding . Yes I should have mentioned both activity have already been performed .The designated APS was earlier having 4 GB memory and now it has also been further expanded to 8GB . Java heap size is configured to have 2 GB .

Regards,

Sourav Roy

CdnConnection
Active Contributor
0 Kudos

Sourav,

       Since you mentioned you have 64Gig on the server, did you use the APS Configuration to size the APS to split XL and then adjust the Java Heap settings.

Thanks Kindly,

Ajay

Former Member
0 Kudos

Hi Ajay ,

No the APS configuration have been done manually not via the wizard.

Regards,

Sourav Roy