Official Support Articles

[Andrea_Bertazzo]

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

• Qlik Sense Enterprise on Windows May 2021
• Qlik Sense Enterprise on Windows 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.

Internal Investigation ID(s):

QB-8346

[rva_be-terna]

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

[Andrea_Bertazzo]

Hi Rvaheldendaten.

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

[rva_be-terna]

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

[nik_lim]

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)?

[Andrea_Bertazzo]

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

[skozawa]

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

[skozawa]

@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

[Sonja_Bauernfeind]

Hello @skozawa

Let me see if I can find out what changes.

All the best,
Sonja

[Sonja_Bauernfeind]

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

[skozawa]

@Sonja_Bauernfeind

Thank you for replying.

I understand the output itself is not changed.

Thanks.

Shiho Kozawa