article Qlik Sense : Reloads failing with error "General Script Error in statement handling" and error code 232 in engine logs in Official Support Articles

Qlik Sense : Reloads failing with error "General Script Error in statement handling" and error code 232 in engine logs

Andrea_Bertazzo — Thu, 11 Apr 2024 14:45:17 GMT

Many reloads are failing on different schedulers with General Script Error in statement handling. The issue is intermittent.
The connection to the data source goes through our Qlik ODBC connectors.

The Script Execution log shows a “General Script Error in statement handling” message. Nevertheless, the same execution works if restarted after some time without modifying the script that looks correct.

The engine logs show:

CGenericConnection: ConnectNamedPipe(\\.\pipe\data_92df2738fd3c0b01ac1255f255602e9c16830039.pip) set error code 232

Environment

May 2021
September 2020 and higher (less frequent occurrence)

Resolution

Change the reading strategy within the current connector:

Set reading-strategy value=engine in C:\ProgramFiles\Common Files\Qlik\CustomData\QvOdbcConnectorPackage\QvODBCConnectorPackage.exe.config

reading-strategy value=connector should be removed

Switching the strategy to engine may impact NON SELECT queries. See Connector reply error: Executing non-SELECT queries is disabled. Please contact your system administrator to enable it. for details.

Internal Investigation ID(s):

QB-8346

Re: Reloads failing with Engine Error code 232

rva_be-terna — Wed, 22 Sep 2021 11:18:55 GMT

Any updates on this issue? One of our customers sees this error and needs a patch release!

Re: Reloads failing with Engine Error code 232

Andrea_Bertazzo — Wed, 22 Sep 2021 13:01:20 GMT

Hi Rvaheldendaten.

We don't have a release date for the fix so far. Has your customer already opened a ticket with support?

Re: Reloads failing with Engine Error code 232

rva_be-terna — Thu, 23 Sep 2021 06:13:59 GMT

@Andrea_Bertazzo: no case yet, but I will create one.

Re: Qlik Sense : Reloads failing with error "General Script Error in statement handling" and error code 232 in engine logs

nik_lim — Sun, 06 Mar 2022 11:25:01 GMT

Would the workaround for ODBC connector (i.e changing the reading strategy) works also with REST connector (i.e set reading-strategy value=engine instead of =connector)?

Re: Qlik Sense : Reloads failing with error "General Script Error in statement handling" and error code 232 in engine logs

Andrea_Bertazzo — Thu, 10 Mar 2022 15:57:06 GMT

Hi @nik_lim

Thanks for the interesting question. The problem has been reported only for ODBC connectors so far, so I need to investigate with our development team and I will be back to you as soon as possible.

In the meanwhile, I would suggest you to try the workaround if possible. It would be very useful to know if this fixes your issue with REST connectors.

Thanks

Re: Qlik Sense : Reloads failing with error "General Script Error in statement handling" and error code 232 in engine logs

skozawa — Thu, 17 Nov 2022 06:15:35 GMT

Hi @Andrea_Bertazzo

How does the following log output change by setting "reading-strategy value=engine"
in QvODBCConnectorPackage.exe.config? 　

C:\ProgramData\Qlik\Custom Data\QvOdbcConnectorPackage\Log

Shiho Kozawa

Re: Qlik Sense : Reloads failing with error "General Script Error in statement handling" and error code 232 in engine logs

skozawa — Thu, 24 Nov 2022 09:44:31 GMT

@Andrea_Bertazzo

Sorry to bother you when you're busy.

Have you had a chance to look over my previous post?

I'll be grateful if you can reply to me.

Shiho Kozawa

Re: Qlik Sense : Reloads failing with error "General Script Error in statement handling" and error code 232 in engine logs

Sonja_Bauernfeind — Thu, 01 Dec 2022 11:20:41 GMT

Hello @skozawa

Let me see if I can find out what changes.

All the best,
Sonja

Re: Qlik Sense : Reloads failing with error "General Script Error in statement handling" and error code 232 in engine logs

Sonja_Bauernfeind — Thu, 01 Dec 2022 11:35:27 GMT

Hello again @skozawa

The output itself is not changed. This change is internal only and does not modify how the log files are written.

All the best,
Sonja

Re: Qlik Sense : Reloads failing with error "General Script Error in statement handling" and error code 232 in engine logs

skozawa — Fri, 02 Dec 2022 00:27:03 GMT

@Sonja_Bauernfeind

Thank you for replying.

I understand the output itself is not changed.

Thanks.

Shiho Kozawa

Re: Qlik Sense : Reloads failing with error "General Script Error in statement handling" and error code 232 in engine logs

Alastair_Ometis — Wed, 06 Sep 2023 15:01:55 GMT

Hi @Sonja_Bauernfeind,

@Andrea_Bertazzo, suggested applying this fix to @nik_lim who had similar symptoms with the REST connector.

I have looked and I don't see the key in the appsettings of the REST Connector Config file.

Can you advise how to proceeed? We are running Qlik Sense May 2023.

Best,

Alastair

Re: Qlik Sense : Reloads failing with error "General Script Error in statement handling" and error code 232 in engine logs

seblabalyerr — Fri, 08 Mar 2024 10:59:08 GMT

Hi Everyone,

We have also same error for Rest Connector. Since the same parameter is not for REST, how can we edit it?

Thanks

Re: Qlik Sense : Reloads failing with error "General Script Error in statement handling" and error code 232 in engine logs

Sonja_Bauernfeind — Mon, 11 Mar 2024 08:26:55 GMT

Hello @seblabalyerr

I recommend searching the error you receive in our larger community, including information that you are seeing the issue with the REST Connector. As we do not have a lot of information to go by, I can only provide generic advise.

Examples:

QlikSense error General Script Error in statement handling question
REST API task is failing Intermittently with General Script Error in statement handling

Either way, please post about your issue in the Connectivity and Data Prep forum, where our active support agents and your Qlik peers can more readily assist you. When doing so, include:

Your version
Information about your setup
The error you receive (both in the script and in the log files)
Information on whether this worked previously or not

All the best,
Sonja

Re: Qlik Sense : Reloads failing with error "General Script Error in statement handling" and error code 232 in engine logs

cjgorrin — Fri, 22 Mar 2024 14:50:10 GMT

We were getting this error in our servers because due to business needs, we had to insert a lot of records into an Oracle DB in an app's load script and we were getting this "General error" with pipe error 232 in the logs.

Applying the patch kind of worked, and I say "kind of" because it broke the !EXECUTE_NON_SELECT_STATEMENT functionality. All our apps that used it with Oracle just stop reloading correctly and failed with DB error "ORA-00933: SQL command not properly ended" because the "!EXECUTE_NON_SELECT_QUERY" part was being sent to the DB as part of the SQL statement (our DBA confirmed this).

So, after testing a lot we found out the following:

All Oracle data connections created BEFORE the fix have UseBulkReader = False in their connection string.
All Oracle data connections created AFTER the fix have UseBulkReader = True in their connection string.
The combination of UseBulkReader = False, reading-strategy value=engine and !EXECUTE_NON_SELECT query just doesn't work. Either you remove the !EXECUTE_NON_SELECT_STATEMENT or you change UseBulkReader to true in the connection string.

We experienced this issue with version May 2023 patch 9. I hope this can help anybody having the same issue.

@Sonja_Bauernfeind and @Andrea_Bertazzo, if you could update the article to reflect this side effect, it would be very useful. Thanks.

Re: Qlik Sense : Reloads failing with error "General Script Error in statement handling" and error code 232 in engine logs

cjgorrin — Thu, 11 Apr 2024 10:56:27 GMT

UPDATE: we are not sure if the UseBulkReader default value changed when we applied the fix or because we installed a more recent patch. In any case, the third item in the list above is still correct:

Bulk reader False + engine reader strategy + !EXECUTE_NON_SELECT_STATEMENT = problems.

Re: Qlik Sense : Reloads failing with error "General Script Error in statement handling" and error code 232 in engine logs

dobak — Tue, 14 Jan 2025 08:13:46 GMT

We have a similar intermittent issue with an MS SQL connector while not using ODBC. Getting 'General Script Error in statement handling' and 'set error code 232'.

Will the change of QvODBCConnectorPackage.exe.config fix this? Or is there some other place we should adjust in the case of a direct MS SQL connection?