Discoverer Reports fail to export a csv file


 Product(s):Exor Network Manager
 Version(s):04.07.00.01
 Environment:Windows XP 32 bit
 Area:Other
 Subarea:N\A

Problem

Oracle BI Discoverer Viewer Version 11.1.1.1.7
Error below was happening in Discoverer Viewer when trying to export a csv file. No file gets produced as error below is displayed instead. It can occur trying to export to other formats within Discoverer Viewer/Plus.

Message displayed using Discoverer Viewer to export a csv file
The application encounters an invalid state. . 
- Exception waiting for response; nested exception is: 
weblogic.utils.net.SocketResetException - Nested exception: 
DiscoNetworkException Exception waiting for response; nested exception is: 
weblogic.utils.net.SocketResetException - Nested exception: 
org.omg.CORBA.MARSHAL: Exception waiting for response; nested exception is: 
weblogic.utils.net.SocketResetException vmcid: 0x0 minor code: 0 completed: No 
- Exception waiting for response; nested exception is: 
weblogic.utils.net.SocketResetException 
Oracle BI Discoverer Viewer cannot find the data necessary to display the 
results of this event. Correct any errors, and try again.

 

Solution

The issue occured as no temporary directory ( referenced in the opmn.xml file )  existed on the server that was needed for temporay file creation during the process.

The opmn.xml file had the following entry below for TEMP/TMP environmental variables but no physical location existed on the server. Creating the directory ( as plenty of space on that disk existed ) solved the problem. 

<ias-instance id="fmds" name="fmds">

<environment>

<variable id="TEMP" value="C:\temp"/>

<variable id="TMP" value="C:\temp"/>

</environment>

After creating the directory c:\temp , when exporting the file the following message appeared

Export Ready

The export you created is ready. Please click the button below to open the exported document to view or save it.

Click to view or save



 Original Author:Clive T