Error occurred while rendering report:null while following the tutorial

  • 2
  • Problem
  • Updated 2 years ago
I'm evaluating the connect for use in a partner database, and have been been following the tutorials to get everything set up. I've been successful in getting the Account and Entity macros to work, but the tutorial for using the Salesforce reporter with Reporting fails every time with "error occurred while rendering report:." Having seen the other problem post about this, I suspect it's a problem with report-info. Is there any update or workaround for this? If this doesn't work then our evaluation fails. 

I'm using Reporting 6.4.4 with SF Connector 4.3.0 on Confluence Server 5.9.7. I've also attached a screenshot of my code, it's a very basic table and I know the query should work because it's the exact same one I used for the Entity macro test. 
Photo of Phil Gochenour

Phil Gochenour

  • 4 Posts
  • 0 Reply Likes
  • a bit frustrated

Posted 2 years ago

  • 2
Photo of Aidin Mahmoodi

Aidin Mahmoodi, Alum

  • 267 Posts
  • 6 Reply Likes
Hi Phil,

Can you please verify that if you have obtained license for the Reporting plugin as well?

If yes, can you please provide a screenshot?

Cheers,
Aidin
Photo of Phil Gochenour

Phil Gochenour

  • 4 Posts
  • 0 Reply Likes
I do have a license and a screenshot of my set up is already attached.
Photo of Mervyn Toh

Mervyn Toh, Alum

  • 117 Posts
  • 7 Reply Likes
Hi Phil,

I believe this is due to a limitation from the {salesforce reporter}. I'm attaching a storage format, let me know if the storage format works for you :
<ac:structured-macro ac:macro-id="54914c04-e550-455d-af1b-7385b2d75bd5" ac:name="report-table" ac:schema-version="1">
  <ac:rich-text-body>
    <ac:structured-macro ac:macro-id="578c388f-21a7-4212-8aa1-970641c8f933" ac:name="salesforce-reporter" ac:schema-version="1">
      <ac:parameter ac:name="">Account</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="8bb58932-2b88-4c57-b76b-756a6cb0ce07" ac:name="text-filter" ac:schema-version="1">
            <ac:parameter ac:name="include">Accenture</ac:parameter>
            <ac:parameter ac:name="">sf:Name</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="dc44ce1a-112e-4f5c-9d45-539eec2ec648" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Name</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="6b430871-5221-4b1c-b8da-6591fe4ec356" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="">sf:Name</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <ac:structured-macro ac:macro-id="4ec7ef96-ff7c-448e-8786-451ca9d2613b" ac:name="report-column" ac:schema-version="1">
      <ac:parameter ac:name="title">Last Updated</ac:parameter>
      <ac:rich-text-body>
        <p>
          <ac:structured-macro ac:macro-id="ac3d5dd1-676c-4af4-931a-0e17da9cc38c" ac:name="report-info" ac:schema-version="1">
            <ac:parameter ac:name="">sf:Industry</ac:parameter>
          </ac:structured-macro>
        </p>
      </ac:rich-text-body>
    </ac:structured-macro>
  </ac:rich-text-body>
</ac:structured-macro>
Thank you.
Photo of Phil Gochenour

Phil Gochenour

  • 4 Posts
  • 0 Reply Likes
This also fails with the error "macro cannot be used in this context." Can you provide any more information on what the "limitation" is with the SF reporter? I also don't understand what is significantly different in the storage format version from my version, except that I used the regular expression .*Accenture.* for the text filter include.