Jump to content

Custom Query Verification does not finish

Thorsten Saeger

Recommended Posts

Hello denizens of the Tibco Community,

I am using Spotfire 11.4 and I am trying to create a custom query to access data through the Apache Spark connector on DataBricks.

Every aspect of the data connection works just fine except that I can't verify my custom query. After clicking on "Verify" it runs for hours without finishing it, even for the simplest query.


Tahnsk and best,


Link to comment
Share on other sites

Hello Thorsten,


Is anything logged in the Analyst log files Looking in my log files, I can see the validation query logged on DEBUG level, so make sure to enable that level first, in the following way:


1. In TIBCO Spotfire Analyst, go to Help menu > Support diagnostics and logging

2. In the Logging tab, set the log level to DEBUG.

3. You can also find the path to the log file there. Open the file (or folder) so you can easily check it later.

3. Click OK to close the dialog.


Now reproduce the issue and then check the log file. Search for "Running validation query for custom query". You should also find the validation query itself in the logs - try executing that validation query outside of Spotfire.


You/the DBA should also check the details on the database side - what is logged there when the validation query is executed


For further troubleshooting,I recommend that you open a support case for this in the TIBCO Support Portal (https://support.tibco.com), and the support team will assist you with further troubleshooting.


Best Regards

Fredrik (proud denizenof the TIBCO Community)

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...