Getting Error Message : Read timed out while doing Refresh Schema in Read JDBC, Query JDBC, SQL Node in Canara Sparkflows Environment

Setup & Configuration
1

While doing the Refresh Schema in Read JDBC, Query JDBC, SQL, Spark, Pyspark Node, If we are getting the Error : Read Timed Out, which actually means there is quite a lot of load on the connection through which the data is transfer is taking place or Connection is too busy, that’s why data is not able to load.

In order to deal with the above issue follow the below steps, we have to stop all the spark process for a while :

If already logged in as Non-Admin User, then first log in as Admin user :

  1. Go to Administration.
  2. Go to Application lib jars.
  3. On the right top most side, press the kill fire processes button (In order to kill all the fire-processes for a while).
  4. After killing all the fire-processes, do the refresh schema, Refresh schema will work now.