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
Hi there,
What happens when you try to input a random value to it and run?
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.
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