Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

ansarikashif201
Contributor

UDC is not configured. Operation has timed out.

Hi All,

I have been trying to get UDC operational using an Oracle DB but not able to succeed. UDC is behaving inconsistent. It connected once and created the users stored in the DB table but it stopped working after that. After lot of debugging I added a Connect Timeout paramter to the visible conn string and it worked for a day or two but it stopped working again.

I am using the below conn string :-

Driver={Oracle in OraClient12home2};Dbq=<TNSEntry name>;Uid=<DB user>;Pwd=<pwd>;ConnectTimeout=60;

or

Driver={Oracle in OraClient12home2};Dbq=<ODBC DSN Name>;Uid=<DB user>;Pwd=<pwd>;Connect Timeout=60;

none of which seems to work. I keep getting below error after 30 seconds:-

Operation has timed out.

The log has the below error :-


ORA-01013: user requested cancel of current operation

I am able to connect to the same DB user using DB Client tool like Toad or SQL Plus and query the tables. Even tnsping to the Tns entry works fine.

Any pointers much appreciated.

Tags (1)
8 Replies
ansarikashif201
Contributor

Re: UDC is not configured. Operation has timed out.

Calling out korsikov‌ , gwassenaar‌, jog‌, mto‌ for any insights?

korsikov
Valued Contributor II

Re: UDC is not configured. Operation has timed out.

sorry but i not has any idea about this problem. And does not has Oracle environment to reproduce this situation

ansarikashif201
Contributor

Re: UDC is not configured. Operation has timed out.

No problem Alex. thanks for responding.

Calling out stalwar1‌, swuehl‌ , jpe‌ for any insights?

ansarikashif201
Contributor

Re: UDC is not configured. Operation has timed out.

Hi Guys,

Any one has any insights in solving this?

Regards,

Kashif

ansarikashif201
Contributor

Re: UDC is not configured. Operation has timed out.

Any reference to any Qlik Engineer who deals direclty with DB connectors?

Employee
Employee

Re: UDC is not configured. Operation has timed out.

Hi Kashif,

The Property your referring  here ConnectTimeout=60 is not known to Oracle ODBC

I hope for refernce you can look into more properties here.

Using the Oracle ODBC Driver

QTO

Query Timeout Option

T=Query Timeout Enabled.

F=Query Timeout Disabled.

To achieve your request i would request you to have a try with below requests:

Driver={Oracle in OraClient12home2};Dbq=<ODBC DSN Name>;Uid=<DB user>;Pwd=<pwd>;QTO=F;

//Suraj

ansarikashif201
Contributor

Re: UDC is not configured. Operation has timed out.

Hi Suraj,

Thanks for the reply. Same thing was sugegsted by Qlik Support engineer but didnt help. Finally the support engineer spotted a timeout error which seems to have been fixed in 3.2. We would need to upgrade to 3.2.

Regards,

Kashif

anderson1985
New Contributor

Re: UDC is not configured. Operation has timed out.

Hi all,

I am using an access database for my User Directory Connector and came across this problem. the solution was to clear out the 'Synchronization timeout (seconds)' field and re-enter the number  (Example: 300 or 500).

That worked for me, hope this helps.

Keep Qlikin

Anderson

Community Browser