Connector reply error: SQL##f - SqlState: 00000, ErrorCode: 0, ErrorMsg:

[Eston_Sello]

Good day,

Could any one advise what does this error indicates :

Connector reply error: SQL##f - SqlState: 00000, ErrorCode: 0, ErrorMsg:

I am getting the above error when try to load a specific table it hangs and return the error but I can successfully load other tables.

Thanks in advance.

Eston

[Gysbert_Wassenaar]

Usually there is an actual error message after 'ErroMsg:' that will have more information about what happened.

[Anil_Babu_Samineni]

I understand that message after "You may  don't have permission to specific Table?

[Eston_Sello]

Hi,

This is what i get nothing more.

ODBC error

Connector reply error: SQL##f - SqlState: 00000, ErrorCode: 0, ErrorMsg:

TableABC:

SQL SELECT "Field_Name",
"Field_Name",
"Field_Name",
"Field_Name",
"Field_Name",
"Field_Name",
"Field_Name",
"Field_Name",
Field_Name,
Field_Name,
"Field_Name",
"Field_Name",
Field_Name,
Field_Name,
"Field_Name",
"Field_Name",
"START_DATE",
"Field_Name",
"Field_Name",
"Field_Name"
FROM CCDW30."TableABC"
where TO_CHAR( CCDW30."TableABC"."START_DATE",'DD-MM-YYYY') = '01-Jul-2019'

[Brett_Bleess]

Eston, what this tells us is the Connector is getting hung up, and I am referencing the ODBC/OLE DB driver/connector in this case, it is not returning any message to us to return in our log.  I do not know if something is timing out or what, but the issue is most likely in the DB driver side I believe, but I am not sure what may be the issue.  Your best bet may be to reach out to the DBA's, or hit the DB vendor support site as well and see if you can find anything there that fits the symptoms.  One other thing you could try is use Excel or something and the same connection string/DSN and see what you get there, if that pulls properly, then we may have an issue on the Qlik side somewhere after all.  Hopefully this helps you move things forward.

Regards,
Brett