Troubleshooting
Problem
Attempting to run SPD (Custom Dialogs) from Deployment Portal fails. A Remote Statistics Server is defined and configured in PEA. In addition, the proper credentials are defined in PEA(Predictive Enterprise Administrator). Connecting to the "Statistics" Server from "Statistics" client using the same credentials is successful. However, trying to run a custom dialog from PEB(Predictive Enterprise Browser) fails with the following error after selecting a data file (SAV). An unexpected error has occurred. The operation can not be completed. java.rmi.RemoteException: java.sql.SQLException: [SPSS Inc][PASW Statistics JDBC Driver]TCP/IP error, connection refused.; nested exception is: java.sql.SQLException: [SPSS Inc][PASW Statistics JDBC Driver]TCP/IP error, connection refused. Show Details>> AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode: faultString: java.rmi.RemoteException: java.sql.SQLException: [SPSS Inc][PASW Statistics JDBC Driver]TCP/IP error, connection refused.; nested exception is: java.sql.SQLException: [SPSS Inc][PASW Statistics JDBC Driver]TCP/IP error, connection refused. faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}hostname:CDSDemo java.rmi.RemoteException: java.sql.SQLException: [SPSS Inc][PASW Statistics JDBC Driver]TCP/IP error, connection refused.; nested exception is: java.sql.SQLException: [SPSS Inc][PASW Statistics JDBC Driver]TCP/IP error, connection refused. at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:222) at org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:129) at org.apache.axis.encoding.DeserializationContext.endElement(DeserializationContext.java:1087) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) at javax.xml.parsers.SAXParser.parse(SAXParser.java:375) at org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227) at org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696) at org.apache.axis.Message.getSOAPEnvelope(Message.java:435) at org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62) at org.apache.axis.client.AxisClient.invoke(AxisClient.java:206) at org.apache.axis.client.Call.invokeEngine(Call.java:2784) at org.apache.axis.client.Call.invoke(Call.java:2767) at org.apache.axis.client.Call.invoke(Call.java:2443) at org.apache.axis.client.Call.invoke(Call.java:2366) at org.apache.axis.client.Call.invoke(Call.java:1812) at com.spss.pev.ws.axis.MetadataStub.getVariableMetadata(MetadataStub.java:268) at com.spss.peb.spd.engine.variables.VariableRequester.getAllVariables(VariableRequester.java:69) at com.spss.peb.spd.engine.variables.VariableRequester.getVariableList(VariableRequester.java:87) at com.spss.peb.spd.engine.UIBuilder.processSrcList(UIBuilder.java:602) at com.spss.peb.spd.engine.UIBuilder.buildPanelElement(UIBuilder.java:360) at com.spss.peb.spd.engine.UIBuilder.processPanelDefinition(UIBuilder.java:220) at com.spss.peb.spd.engine.UIBuilder.writePromptUI(UIBuilder.java:146) at com.spss.peb.spd.actions.ProcessUIAction.generateSpdOutput(ProcessUIAction.java:365) at com.spss.peb.spd.actions.ProcessUIAction.processSpdRequest(ProcessUIAction.java:111) at com.spss.peb.spd.actions.SpdActionBase.doProcess(SpdActionBase.java:112) at com.spss.peb.spd.servlet.SPDServlet.doPost(SPDServlet.java:68) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at com.spss.peb.spd.servlet.SPDServlet.service(SPDServlet.java:33) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.spss.er.filter.PingFilter.doFilter(PingFilter.java:48) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:595) The problem is that the PASW Statistics Data File Driver did not fully or properly install. This was identified as the problem because the Statistics17DataDriverService was present or running in the Services dialog.
Resolving The Problem
This is caused by a bad install of the Service data driver "PASW Statistics Data File Driver - Service"
Uninstall the data driver service using the following instructions:
1. From Add/Remove programs uninstall "PASW Statistics Data File Driver - Service"
2. From task manager "End Process" for any process running as "oaagent.exe" or "oasoa.exe" or "oastrtr.exe"
3. Delete directory "C:\Program Files\SPSSInc\PASWStatistics17DataFileDriver"
4. From the command prompt run below commands:
sc delete SAVService_Agent
sc delete Statistics17DataDriverService
5. Restart the machine.
6. This reinstalled the data driver "PASW Statistics Data File Driver - Service"
The reinstall corrected "PASW Statistics Data File Driver - Service data driver
Related Information
Historical Number
82467
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21475173