topic Re: Sense June UDC error in Management & Governance

Sense June UDC error

wangxusq — Fri, 15 Sep 2017 01:52:54 GMT

Hi everyone,

I create two tables :

Configured the ODBC:

Tested the ODBC in the script,it is OK.

But at last, error comes up:

Anything wrong?

Please help,thanks.

Re: Sense June UDC error

wangxusq — Mon, 18 Sep 2017 02:12:08 GMT

Anyone can help?

Re: Sense June UDC error

Chanty4u — Mon, 18 Sep 2017 07:59:07 GMT

Hi,

check here

User Directory Connector is not configured.......

Re: Sense June UDC error

wangxusq — Mon, 18 Sep 2017 08:09:28 GMT

Hi,

I have checked this artical before,but I still don't know where the problem is.

I refered to the qlik help, but not solved it .

Any help?

Thanks.

Re: Sense June UDC error

Mon, 18 Sep 2017 14:03:01 GMT

Hello

Try with
TABLE.T_USERS and TABLE.T_ATTRIBUTES

Re: Sense June UDC error

ansarikashif2017 — Mon, 18 Sep 2017 14:50:12 GMT

Hi Scott,

You able to do tnsping on the QlikSense server for TNS Service name ORCL?

Regards,

Kashif

Re: Sense June UDC error

ansarikashif2017 — Mon, 18 Sep 2017 16:36:02 GMT

I think what Mykhailo meant was <OWNER_NAME>.T_USERS.

E.g. If the table resides in Schema EMP, then EMP.T_USERS.

Re: Sense June UDC error

wangxusq — Mon, 18 Sep 2017 22:52:23 GMT

Hi ,

thanks for reply. My qliksense server and tns service are both in my VM. And I tested the TNS service in my HUB script, it is OK.See the above picture.

Re: Sense June UDC error

wangxusq — Mon, 18 Sep 2017 22:55:30 GMT

Hi thanks for reply. I tried it ,but still error. See the picture

Re: Sense June UDC error

wangxusq — Mon, 18 Sep 2017 22:56:08 GMT

Hi thanks for reply. I tried it ,but still error. See the picture

Re: Sense June UDC error

ansarikashif2017 — Tue, 19 Sep 2017 07:23:57 GMT

In the above pic, you have tested the ODBC connection based on the TNS Service. What I am talking about is doing a "tnsping orcl" on the command prompt assuming orcl is your tns entry name.

Also, can you attach the logs from ProgramData\Qlik\Sense\Log\Repository\Trace\<hostanme>_UserManagement_Repository.txt when you hit the sync button?

Re: Sense June UDC error

wangxusq — Tue, 19 Sep 2017 07:54:55 GMT

Hi thanks,

tnsping message:

And please see the attachment .

Thanks.

Re: Sense June UDC error

ansarikashif2017 — Tue, 19 Sep 2017 07:57:47 GMT

This is the issue you are facing :-

ERROR [08004] [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified

Can you search for tnsnames.ora on your machine and check if their are multiple files? If yes, please add the orcl entry in the other tnsnames.ora files as well and retry.

Re: Sense June UDC error

wangxusq — Tue, 19 Sep 2017 08:00:42 GMT

My PC install the 32-bit oracle client and the 64-bit oracle db.

Now I rename the other tnsnames.ora,just have one tnsnames.ora. I have searched it.

Re: Sense June UDC error

ansarikashif2017 — Tue, 19 Sep 2017 08:03:02 GMT

So what is the new result of "tnsping orcl" on command prompt and re-running the UDC sync? Do share the new logs if you still facing the error.

Re: Sense June UDC error

wangxusq — Tue, 19 Sep 2017 08:21:25 GMT

Hi ,

I tested it. I found the log and the tnsping is the same.

Nothing changed.

I want to know whether I should uninstall 32-bit client or 64-bit db driver? Just stay one?

But I have try to uninstall the 32-bit client,the error still…

Re: Sense June UDC error

Tue, 19 Sep 2017 08:36:23 GMT

Yes, Kashif, thanks, I meant owner name.

@Scott try with SCOTT.T_USERS and SCOTT.T_ATTRIBUTES please

Re: Sense June UDC error

wangxusq — Tue, 19 Sep 2017 08:41:41 GMT

Thanks，I tried it, but the error still exists…

Re: Sense June UDC error

ansarikashif2017 — Tue, 19 Sep 2017 09:23:53 GMT

I think try with adding the tns entry for orcl in other tnsnames.ora files instead of renaming the files.

Re: Sense June UDC error

ansarikashif2017 — Tue, 19 Sep 2017 11:00:41 GMT

Let me know how this goes?

Also, can you check what is the path in the below command :-

echo %TNS_ADMIN%

The tnsnames file at this path should have the orcl entry.