Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Knowledge
QlikSense Oracle connector not working with error Instance 'QvOdbcConnectorPackage' does not exist in the specified Category
Article Number: 000052579 | Last Modified: 2018/11/08Description
QlikSense Oracle connector not working with error below when attempting to reload data or select data via Data Connection in Hub:
From QVOdbcConnectorPackage.log
20180501T164846.563-04:00 [1] 4.8.0 INFO HOSTNAME \\.\pipe\00002FD8_00003720_5F29A50B_422F232D.pip UserIdNotPassed AppIdNotPassed EngineSessionIdNotPassed bef8e662-ee3a-4207-86f6-d8ba9a564226 oracle SENDING: QvxReply {Result=QVX_UNKNOWN_ERROR, ErrorMessage=Error starting QvConnect process: Instance 'QvOdbcConnectorPackage' does not exist in the specified Category.}
From Service_Engine logs:
13 18.5.2.0 20180418T165531.453-0400 ERROR HOSTNAME 362dbe9c-0885-4b91-a6e5-0c98360d90f2 20180418T165531.461-0400 12.108.6.0 Command=Doc::CreateConnection;Result=11043;ResultText=Error: Connector connect error: {0} 4e13fe77-9f59-4ebc-9c35-4e701b2d176a ae111b6f-208a-4f6e-b7c2-81d52c4b8426 38 XXX 8683571536 22de82ef-f024-4dc3-b2b5-35b97878aec8 0 Not available Engine Not available Doc::CreateConnection Doc::CreateConnection 11043 {{"Error starting QvConnect process: Instance 'QvOdbcConnectorPackage' does not exist in the specified Category."}} 362dbe9c-0885-4b91-a6e5-0c98360d90f2
From the reload script log or Hub reload progress window:
...
The following error occurred:
Connector connect error: Errror starting QvConnect process: Instance 'QvOdbcConnectorPackage' does not exist in the specified Category.
The error occurred here:
?
...
Environment:
From QVOdbcConnectorPackage.log
20180501T164846.563-04:00 [1] 4.8.0 INFO HOSTNAME \\.\pipe\00002FD8_00003720_5F29A50B_422F232D.pip UserIdNotPassed AppIdNotPassed EngineSessionIdNotPassed bef8e662-ee3a-4207-86f6-d8ba9a564226 oracle SENDING: QvxReply {Result=QVX_UNKNOWN_ERROR, ErrorMessage=Error starting QvConnect process: Instance 'QvOdbcConnectorPackage' does not exist in the specified Category.}
From Service_Engine logs:
13 18.5.2.0 20180418T165531.453-0400 ERROR HOSTNAME 362dbe9c-0885-4b91-a6e5-0c98360d90f2 20180418T165531.461-0400 12.108.6.0 Command=Doc::CreateConnection;Result=11043;ResultText=Error: Connector connect error: {0} 4e13fe77-9f59-4ebc-9c35-4e701b2d176a ae111b6f-208a-4f6e-b7c2-81d52c4b8426 38 XXX 8683571536 22de82ef-f024-4dc3-b2b5-35b97878aec8 0 Not available Engine Not available Doc::CreateConnection Doc::CreateConnection 11043 {{"Error starting QvConnect process: Instance 'QvOdbcConnectorPackage' does not exist in the specified Category."}} 362dbe9c-0885-4b91-a6e5-0c98360d90f2
From the reload script log or Hub reload progress window:
...
The following error occurred:
Connector connect error: Errror starting QvConnect process: Instance 'QvOdbcConnectorPackage' does not exist in the specified Category.
The error occurred here:
?
...
Environment:
- Qlik Sense Februrary 2018 (12.5.3)
- Oracle v. 11g (11.2.0.4.0)
Cause
No root cause has been found at this time.
Resolution
As a workaround perform the following:
1. On the Qlik Sense server locate QvOdbcConnectorPackage.exe.config in C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage.
2. Towards the bottom of the config file, modify the following string:
...
<add key="oracle-reading-strategy" value="engine" />
...
Change it to:
<add key="oracle-reading-strategy" value="connector" />
Get Answers
Find Answers
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. For Data Integration related issues please refer to your onboarding documentation for current phone number.
Call Us