topic Re: Qlik Error in loading table from SQL data GateWay source in App Development

Qlik Error in loading table from SQL data GateWay source

Marcushenriquesk — Wed, 21 Sep 2022 18:15:51 GMT

The following error occurred:

(Connector error: Status(StatusCode="Internal", Detail="Invalid row status 5 at 0"))

The error occurred here:

LOAD LOC_ID, LOC_NAME, DEFAULT_GENDER, DEFAULT_AREA_CODE, DEFAULT_ZIP, DEFAULT_FASTING, HEADER1, HEADER2, HEADER3, HEADER4, HEADER5, HEADER_PIC, FOOTER1, FOOTER2, FOOTER3, FOOTER4, FOOTER5, DEFAULT_REQ_DOCS_FLAG, SETTINGS_MASK, NOTES, DEFAULT_ABN_RPT_ID, DEFAULT_REQ_RPT_ID, CLIA_NO, ORG_ID, DIRECTOR, ADDRESS1, ADDRESS2, CITY, STATE, ZIP, PHONE, FAX_PHONE, EXTERNAL_NO, SPECIMEN_CONTAINER_ID, SPECIMEN_EXTRA_COUNT, AUTO_PRINT_EXTRA_COPIES, CUMULATIVE_BREAK, EMAIL_ADDRESS, PASSWORD, PRINT_DEFAULT, FAX_DEFAULT, EMAIL_DEFAULT, DEFAULT_PRINTER, RPT_ID

Here is the query:

LOAD LOC_ID,
LOC_NAME,
DEFAULT_GENDER,
DEFAULT_AREA_CODE,
DEFAULT_ZIP,
DEFAULT_FASTING,
HEADER1,
HEADER2,
HEADER3,
HEADER4,
HEADER5,
HEADER_PIC,
FOOTER1,
FOOTER2,
FOOTER3,
FOOTER4,
FOOTER5,
DEFAULT_REQ_DOCS_FLAG,
SETTINGS_MASK,
NOTES,
DEFAULT_ABN_RPT_ID,
DEFAULT_REQ_RPT_ID,
CLIA_NO,
ORG_ID,
DIRECTOR,
ADDRESS1,
ADDRESS2,
CITY,
STATE,
ZIP,
PHONE,
FAX_PHONE,
EXTERNAL_NO,
SPECIMEN_CONTAINER_ID,
SPECIMEN_EXTRA_COUNT,
AUTO_PRINT_EXTRA_COPIES,
CUMULATIVE_BREAK,
EMAIL_ADDRESS,
PASSWORD,
PRINT_DEFAULT,
FAX_DEFAULT,
EMAIL_DEFAULT,
DEFAULT_PRINTER,
RPT_ID;

[LabdeqLocations]:
SELECT "LOC_ID",
"LOC_NAME",
"DEFAULT_GENDER",
"DEFAULT_AREA_CODE",
"DEFAULT_ZIP",
"DEFAULT_FASTING",
HEADER1,
HEADER2,
HEADER3,
HEADER4,
HEADER5,
"HEADER_PIC",
FOOTER1,
FOOTER2,
FOOTER3,
FOOTER4,
FOOTER5,
"DEFAULT_REQ_DOCS_FLAG",
"SETTINGS_MASK",
NOTES,
"DEFAULT_ABN_RPT_ID",
"DEFAULT_REQ_RPT_ID",
"CLIA_NO",
"ORG_ID",
DIRECTOR,
ADDRESS1,
ADDRESS2,
CITY,
STATE,
ZIP,
PHONE,
"FAX_PHONE",
"EXTERNAL_NO",
"SPECIMEN_CONTAINER_ID",
"SPECIMEN_EXTRA_COUNT",
"AUTO_PRINT_EXTRA_COPIES",
"CUMULATIVE_BREAK",
"EMAIL_ADDRESS",
PASSWORD,
"PRINT_DEFAULT",
"FAX_DEFAULT",
"EMAIL_DEFAULT",
"DEFAULT_PRINTER",
"RPT_ID"
FROM "ACUTIS_DIAGNOSTICS_QLIK_PROD".dbo.LabdeqLocations;

store [LabdeqLocations] into 'lib://Labdaq Data:DataFiles/LabdeqLocations.qvd';

drop table LabdeqLocations;

Re: Qlik Error in loading table from SQL data GateWay source

vinieme12 — Thu, 22 Sep 2022 06:23:25 GMT

just below is sufficient, preceding load is not required

Also, Which connector are you using? example ODBC/OLEDB/ any specific web connector?

try doing a select *

LabdeqLocations:

SQL Select * from "ACUTIS_DIAGNOSTICS_QLIK_PROD".dbo.LabdeqLocations;

[LabdeqLocations]: SQL SELECT "LOC_ID", "LOC_NAME", "DEFAULT_GENDER", "DEFAULT_AREA_CODE", "DEFAULT_ZIP", "DEFAULT_FASTING", HEADER1, HEADER2, HEADER3, HEADER4, HEADER5, "HEADER_PIC", FOOTER1, FOOTER2, FOOTER3, FOOTER4, FOOTER5, "DEFAULT_REQ_DOCS_FLAG", "SETTINGS_MASK", NOTES, "DEFAULT_ABN_RPT_ID", "DEFAULT_REQ_RPT_ID", "CLIA_NO", "ORG_ID", DIRECTOR, ADDRESS1, ADDRESS2, CITY, STATE, ZIP, PHONE, "FAX_PHONE", "EXTERNAL_NO", "SPECIMEN_CONTAINER_ID", "SPECIMEN_EXTRA_COUNT", "AUTO_PRINT_EXTRA_COPIES", "CUMULATIVE_BREAK", "EMAIL_ADDRESS", PASSWORD, "PRINT_DEFAULT", "FAX_DEFAULT", "EMAIL_DEFAULT", "DEFAULT_PRINTER", "RPT_ID" FROM "ACUTIS_DIAGNOSTICS_QLIK_PROD".dbo.LabdeqLocations;

Re: Qlik Error in loading table from SQL data GateWay source

Marcushenriquesk — Thu, 22 Sep 2022 15:18:21 GMT

Just tried this and its still gave me a:

(Connector error: Status(StatusCode="Internal", Detail="Invalid row status 5 at 0"))

the connector i am using is a microsoft sql connection via qlik data gate way.

Re: Qlik Error in loading table from SQL data GateWay source

NadiaB — Tue, 27 Sep 2022 20:52:13 GMT

Hi @Marcushenriquesk

Are you generating the query with the Data Preview or are you writing the query directly ?

If you are not using the Data preview, could you go to the connection, select "select data" icon and use the preview window to generate the query ?

Thanks!