v5.6 - The multi-part identifier "xxx" could not be bound

Posts   
 
    
rsiera
User
Posts: 48
Joined: 09-Oct-2011
# Posted on: 22-May-2020 16:28:35   

I have a website running that uses llblgen 5.6. Works great, for years now. Today, suddenly, I was getting a lot of failed queries, with error "The multi-part identifier 'xxx' could not be bound", whereby xxx was one of two fields of different tables. After approx 30min the errors stopped again. So the issue was fixed before I noticed it ;-)

Any idea what might have been going on?

R.

Walaa avatar
Walaa
Support Team
Posts: 14983
Joined: 21-Aug-2005
# Posted on: 22-May-2020 20:37:42   

There is not enough information, to deduce what went wrong. What do you mean by " xxx was one of two fields of different tables" ?

rsiera
User
Posts: 48
Joined: 09-Oct-2011
# Posted on: 22-May-2020 21:01:40   

xxx is always the name of a field. The error had two variants, each with a different field of a different table.

What does that error mean?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39749
Joined: 17-Aug-2003
# Posted on: 23-May-2020 10:16:47   

the error is thrown by sql server if a field is specified in a query and it's not in the table. E.g. SELECT Field1, Field2 FROM Table where Table has only Field1, and not Field2.

Do you use load balancing perhaps between multiple database servers?

Frans Bouma | Lead developer LLBLGen Pro
rsiera
User
Posts: 48
Joined: 09-Oct-2011
# Posted on: 23-May-2020 11:27:54   

Thx for the info.

No, i'm using a single instance SQL server.

Weird, very weird. Ok, i'll keep this info in the back of my mind. I'll come back to this ticket if I even have more info.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39749
Joined: 17-Aug-2003
# Posted on: 24-May-2020 10:00:18   

Hmm, then I don't know what happened. Keep us posted!

Frans Bouma | Lead developer LLBLGen Pro