Multiple tasks are getting failed after recent upgrade from 11.20 SR16 to 12.20 SR1

sivayuvaraj — Mon, 26 Jan 2026 18:19:17 GMT

Hi Legends,

Multiple tasks are getting failed after recent upgrade from 11.20 SR16 to 12.20 SR1.

1. Tasks which ever connecting to Service now is failing with below error,

2018-02-20 05:17:41 Error: Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 1050, ErrorMsg: [SN][ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Cannot create schema.Cannot retrieve a DB schema. Please run <instance>?SCHEMA in your browser and try again. Also make sure that the table descriptor cache can hold all your tables and DB views. You can check the table descriptor stats runing <instance>/xmlstats.do in your browser.[1050]

2018-02-20 05:17:41 Execution Failed

2018-02-20 05:17:41 Execution finished.

2. Some of the tasks are failing with this error.

2018-02-27 19:16:51 0030 [http://ussclpeciprpt02/CIPAmazonWebService/CIPAmazonWebSerive.asmx/GetFilesContentInScope?path=com.autodesk.analytics.ap.prd/tables/pl3/cip20_edu_community_usage_monthly/2-data/&from=mon=2014-02&to=mon=2015-01]

2018-02-27 19:16:51 0031 (txt, codepage is 1252, no labels, delimiter is '\t', msq)

2018-02-27 19:17:13 Error: Unknown LOAD statment error

2018-02-27 19:17:13 Unknown LOAD statment error

2018-02-27 19:17:13 Execution Failed

2018-02-27 19:17:13 Execution finished.

2018-03-03 11:57:15 0021 FROM [http://ussclpeciprpt02/CIPAmazonWebService/CIPAmazonWebSerive.asmx/GetFilesContent?tableCompletePath=com.autodesk.analytics.ap.prd/tables/pl3/dap_edu_community_product_info/2-data/]

2018-03-03 11:57:15 0022 (txt, utf8, no labels, delimiter is '\t', msq)

2018-03-03 11:57:36 Error: Unknown LOAD statment error

2018-03-03 11:57:36 Unknown LOAD statment error

2018-03-03 11:57:36 Execution Failed

2018-03-03 11:57:36 Execution finished.

Anyone faced this issue after upgrade. Please provide solution/inputs/suggestion to fix this.

Thanks in advance.

Re: Multiple tasks are getting failed after recent upgrade from 11.20 SR16 to 12.20 SR1

qvd1rkqv — Tue, 23 Apr 2019 18:42:20 GMT

We started getting these recently. Did you ever figure out what was causing this?

Error: Unknown LOAD statment error

Re: Multiple tasks are getting failed after recent upgrade from 11.20 SR16 to 12.20 SR1

Chip_Matejowsky — Tue, 23 Apr 2019 20:15:40 GMT

@qvd1rkqv it would be helpful to post the full task/document log, or snippet of log detailing the full error message. Thanks.

Re: Multiple tasks are getting failed after recent upgrade from 11.20 SR16 to 12.20 SR1

qvd1rkqv — Wed, 24 Apr 2019 18:00:21 GMT

Thanks. I thought I would reach out to this poster and see if anything had been learned. I have a bunch of logs and the problem we're running into is that we push play again and the task runs without the fantastic "Error: Unknown LOAD statment error". I'm going to open a ticket and drop some logs there. Thanks again.

topic Multiple tasks are getting failed after recent upgrade from 11.20 SR16 to 12.20 SR1 in QlikView

Multiple tasks are getting failed after recent upgrade from 11.20 SR16 to 12.20 SR1

Re: Multiple tasks are getting failed after recent upgrade from 11.20 SR16 to 12.20 SR1

Re: Multiple tasks are getting failed after recent upgrade from 11.20 SR16 to 12.20 SR1

Re: Multiple tasks are getting failed after recent upgrade from 11.20 SR16 to 12.20 SR1