How to dynamically disable and then enable the connection in Nifi

[#1]

I am fetching data from pastel(pervasive) database.

But every other day, i used to get error--->LNA session timeout

Then i have to go the connection setting and when i disable the connection and then enable it, everything works fine.

Is there any way that i can automate the process of disable then enable the connection.

[#2 · Accepted solution]

Hi @James Singh ,

As you may know, LNA is an Internal Protocol used by the pervasive SRDE.Engine and there are a couple of reasons for `session timeout`. A few queries for you question.

Can you please share what is the value of Timeout Enquires After in the Administrative tool?

How often are you fetching data from the db?

Can you share the log for this particular error?

[#3]

Hi @Sumit Das,

Value of Timeout Enquires After was not proper in the Administrative tool.

That's why we were facing the issue.

Thanks