Data load from cte - Error

999rs — Sat, 16 Nov 2024 21:21:19 GMT

Hi, using qlik sense. After update to 2019 feb release i am getting errors in my data load tasks. (Connector reply error: Executing non-SELECT queries is disabled. Please contact your system administrator to enable it.)

According to this articles (https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/How-to-load-without-SELECT.htm and https://support.qlik.com/articles/000064538 ) I have to change "allow-nonselect-queries" setting to true in my QvOdbcConnectorPackage.exe.config file

But my QvOdbcConnectorPackage.exe.config file does not contain "allow-nonselect-queries" property.

I am asking for example of QvOdbcConnectorPackage.exe.config with "allow-nonselect-queries" enabled.

here is my current content of QvOdbcConnectorPackage.exe.config :

<?xml version="1.0"?>
<configuration>
    <configSections>
        <sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
            <section name="QvOdbcConnector.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false"/>
        </sectionGroup>
    </configSections>
    <userSettings>
        <QvOdbcConnector.Properties.Settings>
            <setting name="LoggingLevel" serializeAs="String">
                <value>ERROR</value>
            </setting>
        </QvOdbcConnector.Properties.Settings>
    </userSettings>
<startup>
  <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2"/>
</startup>
  <appSettings>
    <add key="InstallationMode" value="Enterprise" />
  </appSettings>
</configuration>

Re: Data load from cte - Error

999rs — Mon, 25 Feb 2019 13:05:19 GMT

Can any body help? just reply with correct config part with "allow-nonselect-queries" setting

Re: Data load from cte - Error

qlikdan — Thu, 28 Feb 2019 13:47:34 GMT

I have been having the same problem too. The config property is under the <appSettings> section near the bottom of the file. Add a row like "<add key="allow-nonselect-queries" value="true" />" so your config file would read:

<appSettings>
     <add key="allow-nonselect-queries" value="true" />
     <add key="InstallationMode" value="Enterprise" />
</appSettings>

topic Re: Data load from cte - Error in QlikView

Data load from cte - Error

Re: Data load from cte - Error

Re: Data load from cte - Error