locked
Error when attempting to publish a report for external use RRS feed

  • Question

  • I am attempting to use the 'publish report for external use' option on an existing report that correctly runs from within our CRM 2011 on premise environment.  This needs to be done as there is another report that contains a link to run the external use report at the root folder of our org_mcrm folder on the report server.

    The above has been done in the past but now when attempting to do this when clicking the 'publish for external use' option on the report we receive an "Invalid Argument" error. Log file indicates the error was due to an Expected Non-Empty String.

    I'm not sure what it is looking for here.  The datasource properties at the org root folder level on the report server look correct

    With tracing on I am not receiving any more detailed information regarding the error.

    Thank you,


    Robert

    Tuesday, March 3, 2015 5:19 PM

Answers

  • Can you try to update the RDL directly on the CRM server? (rather than importing it via a solution)

    I ran into that problem and if I remember correctly, the only fix I could manage was to re-upload a fresh .rdl file and then the Export to External would work.

    Wednesday, March 4, 2015 9:54 PM

All replies

  • Hello Robert,

    I would suggest to recheck log files of reporting service itself - http://www.sqlservercentral.com/Forums/Topic1094300-162-1.aspx


    Dynamics CRM MVP
    My blog

    Tuesday, March 3, 2015 5:54 PM
    Moderator
  • Thanks - Have tried that in a dev environment. In that environment I am not getting any error but there is no published report. Log files for reporting services do not show anything.  In another environment I am able to publish the same report for external use and it works but again no log activity seems to be generated.

    I'm not sure what may be different between the report servers in each environment.


    Robert

    Tuesday, March 3, 2015 7:26 PM
  • In case report is not getting published and error thrown one of CRM Log or Reporting Log would contain error description.

    Dynamics CRM MVP
    My blog

    Tuesday, March 3, 2015 7:33 PM
    Moderator
  • Thanks - However checking all available tracing , event viewer etc nothing comes up other than the error indicated.

    This is the error received when downloading the available log file that is generated:

    Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Expected non-empty string.Detail:
    <OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
      <ErrorCode>-2147220989</ErrorCode>
      <ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
      <Message>Expected non-empty string.</Message>
      <Timestamp>2015-03-04T19:16:43.4256602Z</Timestamp>
      <InnerFault i:nil="true" />
      <TraceText i:nil="true" />
    </OrganizationServiceFault>


    Robert

    Wednesday, March 4, 2015 7:22 PM
  • Can you try to update the RDL directly on the CRM server? (rather than importing it via a solution)

    I ran into that problem and if I remember correctly, the only fix I could manage was to re-upload a fresh .rdl file and then the Export to External would work.

    Wednesday, March 4, 2015 9:54 PM
  • Yeah, I had not thought of doing that and when I deleted the reports and re-uploaded them all worked.  That was a good use of my time :)


    Robert

    Wednesday, March 4, 2015 11:48 PM