Sense June UDC error

[wangxusq]

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.

[ansarikashif2017]

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?

[wangxusq]

Hi thanks,

tnsping message:

And please see the attachment .

Thanks.

[ansarikashif2017]

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.

[wangxusq]

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.

[ansarikashif2017]

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.

[wangxusq]

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…

[#8]

Yes, Kashif, thanks, I meant owner name.

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

[wangxusq]

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

[ansarikashif2017]

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

[ansarikashif2017]

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.