Error while migrating saiku PRPT report to another server

[rahulsarma]

Hi

I am using pentaho 4.5 and ctools version 1.39
I created a saiku report on server1 and exported it into a PRPT format. It opens up fine.
Now if I move this PRPT report to another environment (server2) and open the file it gives me "Report Validation error" when using CSV and in the log file i see connection refused.
However if I keep the server1 running, it works fine.
It leads me to believe that the PRPT file somehow has reference to the older server and always tries to connect to that.

Another point I found is that a temporary CDA file is created under system/tmp whenever I export to PRPT. I copied this file in to the new environment along with the datasources/xmi file etc.

Any suggestion on how to fix this problem.

log file error:

ParentException:
java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:529)
at java.net.Socket.connect(Socket.java:478)
at java.net.Socket.(Socket.java:375)
at java.net.Socket.(Socket.java:249)
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:80)
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:122)
at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:707)
at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:387)
at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:323)
at org.pentaho.reporting.engine.classic.extensions.datasources.cda.HttpQueryBackend.fetchData(HttpQueryBackend.java:93)