Skip to Content
avatar image
Daniel Spokoinyi

[Solved] Prompts fail after Cloud Agent upgrade (Max. Nr of Rows not specified)

Feb 06, 2018 at 01:54 PM | 75 Views | Last edit Mar 02, 2018 at 04:31 PM 2 rev.

Dear Developers of SAP AC. At our customer we updated the Cloud Agent to version 1.0.91 last friday, and since we have not been able to get data from SAP ERP anymore. Could it be that there is a bug in the system?

We had to go back to the old version.

The reason we upaded is that the blog you posted 2 weeks ago about the 2018.02 release it says we need to update, but did not say when the update will happen (I expected this Saturday). it would help if you state the date of the updates somewhere.

SAP Analytics Cloud
SAP Analytics Cloud connectors
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Daniel Spokoinyi
    Mar 02, 2018 at 04:29 PM

    Turns out that the problem was that we had a Nr of Maximum rows to load enabled, causing the error. Once specified a high maximum of lines, the problem was solved.

    well, Took a long while, but we got there. So, lesson learned: Be careful with Prompts, and which one's you select!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Mate Kiss
    Feb 06, 2018 at 02:22 PM

    Hello Daniel,

    The problem is that that the Agent (1.0.91) you have installed belongs to 2018.02.
    However your SAP Analytics Cloud Tenant is not yet on that version.
    In this case please do not open an incident, just wait until your System gets updated.
    After that you can deploy the new Agent and the connection should work fine.

    Best Regards,
    Mate

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Julian Jimenez
    Feb 06, 2018 at 03:57 PM

    Hi Daniel,

    The newer agents support "older" versions of SAP Analytics Cloud. Having the latest agent should not be a problem.

    You can check the Tomcat logs to identify more clearly the error. Sometimes a simple Tomcat restart fix issues related to memory.

    Thanks,

    Julian

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Daniel Spokoinyi
    Feb 06, 2018 at 02:20 PM

    Are you using ERP as connection? Otherwise I will open an incident

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Tammy Powlas
    Feb 06, 2018 at 01:56 PM

    Hi Daniel - I recommend opening a SAP Support incident at support.sap.com and use component LOD-ANA-BI

    I updated my cloud agent this weekend and so far I haven't experienced issues.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Daniel Spokoinyi
    Feb 11, 2018 at 06:14 PM

    Hey guys,

    I have updated it now, and even with the new release I still have problems with updating queries. Some queries do come through, so I believe it has something to do with prompts and the new Cloud Agent.

    I will put in a ticket at SAP, but if someone has any suggestion on what else to do it would be great. The Tomcat server did not show anything

    Daniel

    Add comment
    10|10000 characters needed characters exceeded