topic Re: Qlik Sense-Service now connection Issue in Connectivity & Data Prep

Qlik Sense-Service now connection Issue

sujeet_shirude — Thu, 21 Mar 2024 22:02:13 GMT

Hi Team,

We are currently on Qlik Sense Nov 2023 SR5 version.

I am configuring the Qlik ServiceNow connector and I am running into an issue. Issue is that I am just seeing the "sys_id_value" field for all the tables.

Tables I have tried to access so far are sc_req_item, sc_request, dmn_demand, pm_project tables. From my knowledge, the username has access to the tables.

@MTO @DJK Has anyone run into a similar issue?

Create a ServiceNow connection | Qlik Connectors Help

#ServiceNow

Thanks in advance!

Regards,

Sujeet

Re: Qlik Sense-Service now connection Issue

-AA — Fri, 22 Mar 2024 16:36:18 GMT

I am having the same issue; it seems servicenow connector not working; i tried with REST connection getting some data but limiting to 10k rows. i might need to loop it to get more data but Qlik 'ServiceNow' connector is not working.

Re: Qlik Sense-Service now connection Issue

sujeet_shirude — Fri, 22 Mar 2024 17:54:47 GMT

Thanks for confirming @-AA !

Re: Qlik Sense-Service now connection Issue

AfeefaTk — Thu, 28 Mar 2024 02:34:05 GMT

Hi @sujeet_shirude

Could you please enable the debug level of logging, This can be done by setting LoggingLevel value as DEBUG in QvOdbcConnectorPackage.exe file located at C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage.
Also set LogSQLStatements value as true in QvOdbcConnectorPackage.exe file to capture sql queries in the log.
Once the above settings are done, Recreate the issue and send us the connector logs.

Logs are located at : C:\ProgramData\Qlik\Custom Data\QvOdbcConnectorPackage\Log

Thanks

Re: Qlik Sense-Service now connection Issue

sujeet_shirude — Thu, 28 Mar 2024 19:42:43 GMT

Thanks for your response @AfeefaTk

I was able to re-create the issue. Is there any way to send you the logs privately?

Re: Qlik Sense-Service now connection Issue

AfeefaTk — Mon, 01 Apr 2024 01:36:11 GMT

@sujeet_shirude

Please send it to my email.

This article might help in locating the connector and driver logs.

https://community.qlik.com/t5/Qlik-Fix/Qlik-Fix-How-to-Find-Qlik-Connector-Logs/ta-p/1762915

Thanks