Unable to get column information for the fields that are used in the query

[stonecold111]

Hi Qlikss. I got this error n my task failed in Qmc

What is the reason for this

SQL:

2017-05-08 01:00:06 0089   LOAD

2017-05-08 01:00:06 0090   Id,

2017-05-08 01:00:06 0091   Id2

2017-05-08 01:00:06 0092   SQL SELECT

2017-05-08 01:00:06 0093   Id,

2017-05-08 01:00:06 0094   bookit,

2017-05-08 01:00:06 0095   Id2

2017-05-08 01:00:06 0096   FROM Entrydata

2017-05-08 01:00:07        Error: Unable to get column information for the fields that are used in the query. Please make sure you have only one SELECT statement in a query editor. Description: INVALID_OPERATION_WITH_EXPIRED_PASSWORD: The users password has expired, you must call SetPassword before attempting any other API operations

[Anil_Babu_Samineni]

bookit is not there in Load Statement

[prieper]

Please add a semicolon between LOAD and SQL SELECT:

LOAD Id, Id2; SQL SELECT ....

[stonecold111]

so what .. i don't want to load that field. Thats not the reason

it got succeeded for the past 3 months. it just failed today

[stonecold111]

no it is there in script. but in log file it is not showing semicolon

[prieper]

Did you react on the second part of the message, explaining the error:

INVALID_OPERATION_WITH_EXPIRED_PASSWORD: The users password has expired, you must call SetPassword before attempting any other API operations

Probably your password (as admin) is still working, but what with the credentials for the server?

[stonecold111]

salesforce sfdc connection i am using

[avinashelite]

As per the error

"INVALID_OPERATION_WITH_EXPIRED_PASSWORD: The users password has expired, you must call SetPassword before attempting any other API operations"

Your Password has expired so ask your IT team to reset

[avinashelite]

As per the error

"INVALID_OPERATION_WITH_EXPIRED_PASSWORD: The users password has expired, you must call SetPassword before attempting any other API operations"

Your Password has expired so ask your IT team to reset

[stonecold111]

maybe .. i will check