DB connect version 4.2.0

[VijaySrrie]

DB connect 4.2.0 version identities and connections are working fine but while trying to get the logs using SQL query getting error - Error in 'dbxquery' command:External search command exited unexpectedly

Same SQL query is working fine in version 3.9.0
(Note - We are not upgradinging DB connect
We have installed a fresh DB connect app in a new server and configuring each and every input)

[kknairr]

@VijaySrrie Found the resolution for a similar issue recorded in Splunk KB and see if it helps. Make sure you run the SPL mentioned and see if the error log matches and then proceed with the resolution. 

index=_internal source="*dbxquery*" log_level=ERROR

Solution: 

Error in 'dbxquery' command: External search command exited unexpectedly | Splunk

>>

If this post addressed your question, you can:

• Give it karma to show appreciation 👍
• Mark it as the solution if it solved your issue ✔️
• Add a comment if you’d like more details ✏️

Acknowledging helpful answers keeps the community strong and motivates contributors to continue sharing their expertise.

>>

[VijaySrrie]

Tried for below databases
1. MSSQL generic

2. Oracle

Both are having the same error - Error in 'dbxquery' command:External search command exited unexpectedly

[isoutamo]

Have you updated those JDBC app packages also?