topic Re: UDC ODBC Oracle. Connection String - The operation has timed out. in Connectivity & Data Prep

UDC ODBC Oracle. Connection String - The operation has timed out.

Fri, 21 Apr 2017 09:20:15 GMT

Hello,

I am working on the creation of UDC passing by ODBC Oracle.

System DSN is configured and I see this DSN in the HUB when I want to make a new connection.

It works.

I suppose that I have a problem in Visible Connection String or in User Table Name, Attributes Table name

Tables Oracle:

Driver name comes from windows ODBC DATA SOURCE ADMINISTRATOR ( 64 bit) => Drivers

UID and PWD it is an identifier for my database

DBQ it is the name of my ODBC Data Source, this name is the same in tnsnames.ora

I tested also a set of User Table Name and Attributes Table Name

[SCHEMA.USER_UDC]
[SCHEMA.”USER_UDC”]
SCHEMA.”USER_UDC”
USER_UDC
SCHEMA.USER_UDC

It changes nothing. I have the same message. The operation has timed out and UDC is not operational.

Thanks in advance for your help and any suggestions,

Re: UDC ODBC Oracle. Connection String - The operation has timed out.

ansarikashif2017 — Wed, 17 May 2017 11:38:52 GMT

We are also getting the same issue.

20170517T072338.760-0400

WARN

P*******

UserManagement.Repository.Repository.Users.Factories.UserDirectoryFactory

159

7315b805-7e42-4f05-9f62-bdeb339feda8

NAEAST\***********************

Setting up UDC'IBIEE' of type Repository.UserDirectoryConnectors.ODBC.ODBC unsuccessful

The operation has timed out.

at Repository.Users.SafeUserDirectoryConnector.CallWithTimeout(Func`1 func, TimeSpan timeout)↵↓ at Repository.Users.SafeUserDirectoryConnector.Setup(Logger logger)↵↓ at Repository.Users.Factories.UserDirectoryFactory.TrySetupUserDirectory(UserDirectory userDirectory)

7315b805-7e42-4f05-9f62-bdeb339feda8

20170517T072338.931-0400

ERROR

P*******

UserManagement.Repository.Repository.Users.Factories.UserDirectoryFactory

345

27a007ee-f606-468a-94db-7ac808161372

NAEAST\*********************

Error when validating tables: ERROR [HYT00] [Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation↓

27a007ee-f606-468a-94db-7ac808161372

Re: UDC ODBC Oracle. Connection String - The operation has timed out.

ansarikashif2017 — Mon, 29 May 2017 09:05:12 GMT

Hi @mykhailo_prosianyk,

Were you able to resolve this issue?

I raised a support ticket but no luck. Qlik Sense support is pushing this to Oracle driver issue whereas we can connect to the same Db using the same driver from all other ways.

I get the timeout error after 30seconds. What about your case? After how much time do you get the error?

Regards,

Kashif

Re: UDC ODBC Oracle. Connection String - The operation has timed out.

ansarikashif2017 — Mon, 29 May 2017 10:32:39 GMT

Hi chooco_co

Will you have some insight into this?

Regards,

Kashif

Re: UDC ODBC Oracle. Connection String - The operation has timed out.

Mon, 29 May 2017 11:58:57 GMT

Hi, no, I still looking for the solution

Oracle driver works good because I am able to make a Script Oracle Data Connection.

I have the error after 30 sec also

Thanks for your responses

Mykhailo

Re: UDC ODBC Oracle. Connection String - The operation has timed out.

marcohadiyanto — Mon, 29 May 2017 12:31:30 GMT

Hi Kashif,

I never tried this, but you can try create an apps on hub then create connection to oracle and select your table.

After that search data connection on qmc and copy connection string from there and move it to UDC.

Hope it works.

For your reference about UDC:

https://help.qlik.com/en-US/sense/3.2/Subsystems/ManagementConsole/Content/ODBC-example.htm

Rgrds,

Marco

Re: UDC ODBC Oracle. Connection String - The operation has timed out.

ansarikashif2017 — Tue, 30 May 2017 11:21:38 GMT

Hi Marco,

Thanks for the quick revert.

I tired the steps mentioned by you but it didnt work out.The Conn string from the Data connection of QMC comes out to be a very long string with some weird parameters. But I have solved the issue. Pls see response below.

Re: UDC ODBC Oracle. Connection String - The operation has timed out.

ansarikashif2017 — Tue, 30 May 2017 11:24:14 GMT

Hey Mykhailo,

I finally resolved the issue. Please try adding the connect timeout parameter as shown below:-

Driver={Oracle in OraClient12home2};DBQ=<system DSN name>;Uid=<DB user>;Pwd=<pwd>;Connect Timeout=60;

It resolved the error for me. I had to create a System DSN and give its name in DBQ= parameter and add the Connect Timeout parameter.

Re: UDC ODBC Oracle. Connection String - The operation has timed out.

Wed, 31 May 2017 12:32:10 GMT

Hey Kashif,

I just resolved the issue too. You should restart all services of Qlik and restart the server.

Thanks a lot

Have a good day,

Mykhailo

Re: UDC ODBC Oracle. Connection String - The operation has timed out.

marcohadiyanto — Fri, 02 Jun 2017 02:36:50 GMT

Hi Mykhalio, good to hear that, please mark as answer.

Re: UDC ODBC Oracle. Connection String - The operation has timed out.

wangxusq — Mon, 18 Sep 2017 13:52:43 GMT

hi ,could you help this:Sense June UDC error

Thanks