Description
Strategy users receive the following message when executing Report Services Document in Strategy Web 9.4.1+:
An error has occurred on this page.
Your request could not be processed. Please try again. If the problem persists, contact the
Administrator.
Document Execution Failed: One or more dataset reports returned an error.
The following entry is created into the Web log file
"\\Program Files\MicroStrategy\Web ASPx\WEB-INF\log\MSTRLog12152008_1.log":
<record>
<package>com.Strategy.webapi</package>
<level>SEVERE</level>
<miliseconds>1229360035625</miliseconds>
<timestamp>12/15/2008 13:53:55:625</timestamp>
<thread>1</thread>
<class>CDSSXMLDocumentServer</class>
<method>GetExecutionResultsEx</method>
<message>Document Execution Failed: One or more dataset reports returned an error. (com.Strategy.webapi.MSTRDocumentException)</message>
<exception>com.Strategy.webapi.MSTRDocumentException: Document Execution Failed: One or more dataset reports returned an error. at com.Strategy.webapi.CDSSXMLDocumentServer.GetExecutionResultsEx(Unknown Source) at com.Strategy.web.objects.RWInstanceImpl.pollForResults(Unknown Source) at com.Strategy.web.objects.RWInstanceImpl.pollForResults(Unknown Source) at com.Strategy.web.objects.RWInstanceImpl.getDocumentProperties(Unknown Source) at com.Strategy.web.app.beans.ExportOptionsEditorBeanImpl.getExportMode(Unknown Source) at com.Strategy.web.app.transforms.ExportOptionsEditorTransform.initializeTransform(Unknown Source) at com.Strategy.web.app.transforms.AbstractAppTransform.transform(Unknown Source) at com.Strategy.web.beans.AbstractTransformable.transform(Unknown Source) at com.Strategy.web.beans.AbstractTransformable.transform(Unknown Source) at com.Strategy.web.beans.AbstractTransformable.transform(Unknown Source) at com.Strategy.web.app.gui.GuiComponentImpl.renderElement(Unknown Source) at com.Strategy.web.app.taglibs.DisplayGuiComponentTagHelper.renderComponent(Unknown Source) at com.Strategy.web.app.taglibs.DisplayGuiComponentTagHelper.getcontent(Unknown Source) </exception>
<userName>Moacyr Passador</userName>
<clientID>200.157.1.142</clientID>
</record>
The following entry is created into the DSSErrors.log file
"\\Program Files\Common Files\MicroStrategy\Log\DSSErrors.log":
QueryEngine encountered error: Connect failed. Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. Optional feature not implemented. TNS-12505: TNS:listener could not resolve SID given in connect descriptor.
Why is this happening?
This message is showing due to the fact that the Oracle Instance that hosted the warehouse was neither loaded nor opened.
Solution
Check whether the affected Report Services Document has more than one dataset because one of them can be pointing to a different database schema or instance. Each dataset should be executed separately via Web or Desktop in order to check which dataset is returning this error. Contact the Database Administrator in order to have the affected Database available.
Still having trouble? Feel free to start a discussion on Community!
Or feel free to reach out to your Support liaison to create a case.
