Download File from Repoting Service

Certified Senior Developer

Hi,

in our system,  we have a functionality to create a document from an url of Reporting Service. We use the following smart service:

In Input Body, we use the function httpgetbinary() (from plugin Web And XML Extensions), where endpoint is the url of Reporting Service that generate the document.

However, the plugin doesn't exist anymore and Appian suggests to use Integration Object to substitute it. However, when we try to use it, we receive the following error:

 

So, we find Microsoft SSRS Document Integration Plugin, but there isn't no documentation about this plugin and we don't know the value of input Device Info.

Could you help me to understand what kind of value it's necessary to insert?

Or Is there another way to get a document from Reporting Service with NTLM Authentication?

Thanks in advacne.

Regards,

Juri Monti

  Discussion posts and replies are publicly visible

Parents Reply Children
  • 0
    Certified Senior Developer
    in reply to Harshit Bumb (Appyzie)

    Hi,

    thanks for your response.

    I receive the following error message javax.xml.stream.XMLStreamException: ParseError at [row,col]:[1,1]Message: Premature end of file.

    Optional values of the smart services are empty.

    I try to download the url from outside and it works.

    Thanks.

    Regards,

    Juri Monti

  • 0
    Certified Senior Developer
    in reply to jurim0992

    2022-01-19 11:19:28,572 [Appian Work Item - 2471 - execution02 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.ssrs2008R2.WebCaller - javax.xml.stream.XMLStreamException: ParseError at [row,col]:[1,1]
    Message: Premature end of file.
    org.apache.axis2.AxisFault: javax.xml.stream.XMLStreamException: ParseError at [row,col]:[1,1]
    Message: Premature end of file.
    	at org.apache.axis2.AxisFault.makeFault(AxisFault.java:430)
    	at org.apache.axis2.transport.TransportUtils.createSOAPMessage(TransportUtils.java:123)
    	at org.apache.axis2.transport.TransportUtils.createSOAPMessage(TransportUtils.java:67)
    	at org.apache.axis2.description.OutInAxisOperationClient.handleResponse(OutInAxisOperation.java:354)
    	at org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:421)
    	at org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:229)
    	at org.apache.axis2.client.OperationClient.execute(OperationClient.java:165)
    	at com.microsoft.schemas.sqlserver.reporting.reportingservices.ReportExecutionServiceStub.render(ReportExecutionServiceStub.java:6061)
    	at com.appiancorp.ps.ssrs2008R2.WebCaller.renderOperation(WebCaller.java:152)
    	at com.appiancorp.ps.ssrs2008R2.GetReportFromRS.run(GetReportFromRS.java:95)
    	at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.lambda$call$0(DefaultActivityExecutor.java:131)
    	at com.appiancorp.plugins.PluginUsageLogger.runWithPluginInformation(PluginUsageLogger.java:52)
    	at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.call(DefaultActivityExecutor.java:131)
    	at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.call(DefaultActivityExecutor.java:125)
    	at com.appiancorp.common.ContextClassLoaderSwitcher.runInContext(ContextClassLoaderSwitcher.java:27)
    	at com.appiancorp.process.runtime.framework.DefaultActivityExecutor.execute(DefaultActivityExecutor.java:125)
    	at com.appiancorp.process.engine.UnattendedJavaActivityRequest.execute(UnattendedJavaActivityRequest.java:88)
    	at com.appiancorp.process.engine.UnattendedJavaActivityRequestResponseCreator.getJavaActivityResultResponse(UnattendedJavaActivityRequestResponseCreator.java:21)
    	at com.appiancorp.process.engine.UnattendedJavaActivityRequest.getJavaActivityResultResponse(UnattendedJavaActivityRequest.java:67)
    	at com.appiancorp.process.engine.UnattendedJavaActivityRequest.execute0(UnattendedJavaActivityRequest.java:55)
    	at com.appiancorp.common.persistence.data.AppianDataUserContextProvider.executeWithConsistentDataReads(AppianDataUserContextProvider.java:116)
    	at com.appiancorp.process.engine.ProcessContinuationRequest.executeOuter(ProcessContinuationRequest.java:68)
    	at com.appiancorp.process.engine.ContinuationRequest.execute(ContinuationRequest.java:102)
    	at com.appiancorp.process.workpoller.UnattendedRequestHandlerBean.onMessage(UnattendedRequestHandlerBean.java:36)
    	at com.appiancorp.process.workpoller.WorkItem.run(WorkItem.java:93)
    	at org.springframework.jca.work.SimpleTaskWorkManager$DelegatingWorkAdapter.run(SimpleTaskWorkManager.java:239)
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    	at java.lang.Thread.run(Thread.java:748)
    Caused by: org.apache.axiom.om.OMException: javax.xml.stream.XMLStreamException: ParseError at [row,col]:[1,1]
    Message: Premature end of file.
    	at org.apache.axiom.om.impl.builder.StAXOMBuilder.next(StAXOMBuilder.java:276)
    	at org.apache.axiom.om.impl.llom.OMContainerHelper.buildNext(OMContainerHelper.java:164)
    	at org.apache.axiom.om.impl.llom.OMContainerHelper.getFirstOMChild(OMContainerHelper.java:182)
    	at org.apache.axiom.om.impl.llom.OMDocumentImpl.getFirstOMChild(OMDocumentImpl.java:201)
    	at org.apache.axiom.om.impl.llom.OMDocumentImpl.getOMDocumentElement(OMDocumentImpl.java:98)
    	at org.apache.axiom.om.impl.builder.StAXOMBuilder.getDocumentElement(StAXOMBuilder.java:544)
    	at org.apache.axiom.om.impl.builder.StAXOMBuilder.getDocumentElement(StAXOMBuilder.java:540)
    	at org.apache.axis2.transport.TransportUtils.createDocumentElement(TransportUtils.java:198)
    	at org.apache.axis2.transport.TransportUtils.createSOAPMessage(TransportUtils.java:145)
    	at org.apache.axis2.transport.TransportUtils.createSOAPMessage(TransportUtils.java:108)
    	... 27 more
    Caused by: javax.xml.stream.XMLStreamException: ParseError at [row,col]:[1,1]
    Message: Premature end of file.
    	at com.sun.org.apache.xerces.internal.impl.XMLStreamReaderImpl.next(XMLStreamReaderImpl.java:604)
    	at org.apache.axiom.om.impl.builder.StAXOMBuilder.parserNext(StAXOMBuilder.java:651)
    	at org.apache.axiom.om.impl.builder.StAXOMBuilder.next(StAXOMBuilder.java:189)
    	... 36 more

    Here the log, thanks