Suggestion required to solve my SPSS error message:
I am getting an error message when I try to run syntax to extract data from ODBC. I receive a message: "An unknown error has terminated communication with the processor. The SPSS Statistics Processor is unavailable. Please restart the application to recover the session". This happen s very randomly and if I close the SPSS programmes couple of times, it seems to be working. It been frustrating as it keeps on happening and delays my data extractions only while connecting to ODBC. Otherwise, no issues while running other syntax.
I SPSS version is SPSS29 (64-bit) and the ODBC data source is Oracle 19c.
I did get this software installed into my PC assuming possible issue with JAVA. But, still the same issue.
https://builds.openlogic.com/downloadJDK/openlogic-openjdk/17.0.13+11/openlogic-openjdk-17.0.13+11-windows-x64.msi
The information below is what I can see from the IBM SPSS Statistics Error Report when I try to restart the SPSS application. Error message logs below.
Application information:
Version:
featureCode: STATISTICS
build: 20
version: 29.0.2.0
CrashCount: 253
System information:
Operating System: WIN
logs:
Command Journal:
command.jnl:
44: 03 21:27.623: Start:AutoRecovery
45: 03 21:35.641: run_selection_syntax:RunCurrentAction
46: 03 21:35.643: New:Output
47: 03 21:35.792: GET
48: 03 21:35.792: GET CAPTURE
49: 03 21:35.890: Close:Dataset 0
50: 03 21:36.426: New:Dataset 1
51: 03 21:36.433: IPCMSLCK: 1
52: 03 21:36.433: Execute
53: 03 21:36.524: Title:Dataset 1
54: 03 21:36.535: Title:Dataset 1
55: 03 23:32.719: Error: "java.io.IOException: Connection reset by peer": ",,,,,,null:-1,null:-1,null:-1"
56: 03 23:32.720: spssengine:connection terminated
57: 03 23:33.242: server:An unknown error has terminated communication with the processor. The SPSS Statistics Processor is unavailable.
59: Please restart the application to recover this session.
59: Please restart the application to recover this session.
60: 03 23:35.981: AutoRecovery:saving files
61: 03 23:35.983: Auto Saved:1 syntax files
62: 03 23:35.984: Save:Output
63: 03 23:36.010: Auto Saved:1 output files
64: 03 23:36.012: Title:Dataset 1
65: 03 23:36.014: Auto Saved:1 data files
66: 03 23:36.406: AutoRecovery:done saving files
67: 03 23:57.481: Close:Syntax
68: 03 23:57.500: Close:Syntax
last:
command: 23:57.500: Close:Syntax
timestamp: 03
errors:
last: 03:23:32.719: Error: "java.io.IOException: Connection reset by peer": ",,,,,,null:-1,null:-1,null:-1"