Skip to Content
author's profile photo Former Member
Former Member

BI 4.1 Analysis For Office schedule failing

Dear SAP Community,

Analysis Office Workbook scheduling is failing in all environment (Prod/Dev/Test) for all users with below error message:

Error: Error during scheduling; workbook does not contain OLAP connection.


Environment Details are as below:

- Product Version: SAP BI 4.1 SP6 Patch 3

- Analysis Office BIP Server Add-on 2.2 (server version)

- SAP BO Analysis Edition for Office 2.2.2.55076 (client version)

- Server OS: Windows Server 2012 R2

SSO using STS to backend BW server works fine

We followed SAP KBA: 2134836: Checklist for scheduling Analysis for office workbooks. We made sure all necessary things are in place however all workbooks are continues failing.

We are able to view and refresh same affected workbooks when opened from AAO client. Only scheduling part is impacted via BI-Launchpad in all environments.

I could not attach complete logs here, but here is the snippet for reference. Could someone assist us on this?

Regards,

Mahesh

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2016 at 05:15 AM

    Hi Raunak,

    Yes, we used same installer in all environments.

    Here one thing I would to add is, out of 70 Analysis workbooks, two existing workbooks we are able to schedule successfully in all environments. Both working workbooks are are based off of same data source and same OLAP connection. As we have checked with our developer team, there were no changes made in workbooks designing.

    Considering above scenario, we can say that scheduling functionality has no issues. Still I would like to give try of re-install. We will update you once done.

    Thanks!

    Regards,

    Mahesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Stefan Backhaus

      Hello Stephan/Everyone,

      After investigation found that the issue had caused because of missing mandatory prompts values.

      If your Analysis Workbook contains "Mandatory prompts" then it should contains some values in SAP BW backend. If that value is blank/missing then schedule fails with said error message.

      In my case, workbooks whose schedules succeeds, its corresponding mandatory prompt values were already in place in backend BW system and it can be seen while refreshing those workbooks; however in case of non-working workbooks, values were missing against mandatory prompts. Assigning values against mandatory prompts in BW backend system solved the problem and AFO scheduling started working 😊 

      I hope this helps!

      Regards,

      Mahesh

  • Posted on Apr 21, 2016 at 11:11 AM

    Are you using SSO with your OLAP connection for scheduling?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 21, 2016 at 10:53 AM

    Here is the logs snippet for reference: ====jobserver_DEV1.AdaptiveJobServer_AOSchedulingService_CHILD0_trace.000001.glf=====

    |A88CC8F01B494B3992610246F6605FE70|2016 01 21 13:28:19.147|+0200|Error| |==|E| |jobserver_KESBIDEV1.AdaptiveJobServer_AOSchedulingService_CHILD0|36532| 30|ORBacus:ThreadPerRequest:Dispatcher| |460|0|4|0|BIlaunchpad.WebApp|kesbidev1:1360:29769.226194:1|CMS.runJobs|localhost:7464:48096.2275539:1|.run|kesbidev1:36532:30.8:1|CloXJt41fUzFhxj0AAfDFl837383|||||||||com.businessobjects.js.child.processingsubsystem.aoprecalc||

    An error occurred; could not precalulcate instance 266029 : 360 |A88CC8F01B494B3992610246F6605FE71|2016 01 21 13:28:19.147|+0200|Error| |==|E| |jobserver_KESBIDEV1.AdaptiveJobServer_AOSchedulingService_CHILD0|36532| 30|ORBacus:ThreadPerRequest:Dispatcher| |460|0|4|0|BIlaunchpad.WebApp|kesbidev1:1360:29769.226194:1|CMS.runJobs|localhost:7464:48096.2275539:1|.run|kesbidev1:36532:30.8:1|CloXJt41fUzFhxj0AAfDFl837383|||||||||com.businessobjects.js.child.processingsubsystem.aoprecalc||

    AOPrecalcExecutor.Execute returned false |9F4990DEBF5E47FCBC95E3A4FAE732F30|2016 01 21 14:13:08.149|+0200|Error| |==|E| |jobserver_KESBIDEV1.AdaptiveJobServer_AOSchedulingService_CHILD0|27388| 31|ORBacus:ThreadPerRequest:Dispatcher| |220|0|4|0|BIlaunchpad.WebApp|kesbidev1:1360:29808.226444:1|CMS.runJobs|localhost:7464:46240.2297245:1|.run|kesbidev1:27388:31.8:1|CloXJt41fUzFhxj0AAfDFl83747d|||||||||com.businessobjects.js.child.processingsubsystem.aoprecalc||

    Document does not contain OLAP connections |9F4990DEBF5E47FCBC95E3A4FAE732F31|2016 01 21 14:13:08.149|+0200|Error| |==|E| |jobserver_KESBIDEV1.AdaptiveJobServer_AOSchedulingService_CHILD0|27388| 31|ORBacus:ThreadPerRequest:Dispatcher| |222|0|4|0|BIlaunchpad.WebApp|kesbidev1:1360:29808.226444:1|CMS.runJobs|localhost:7464:46240.2297245:1|.run|kesbidev1:27388:31.8:1|CloXJt41fUzFhxj0AAfDFl83747d|||||||||com.businessobjects.js.child.processingsubsystem.aoprecalc||

    failed to retrieve connection information.

    Please let me know if anymore info needed.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.