Qlik Error in loading table from SQL data GateWay source

[Marcushenriquesk]

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;

[vinieme12]

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;

[Marcushenriquesk]

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.

[NadiaB]

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!