Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > Bugs & Issues> v5.6 - The multi-part identifier "xxx" could not be bound
 

Pages: 1
Bugs & Issues
v5.6 - The multi-part identifier "xxx" could not be bound
Page:1/1 

  Print all messages in this thread  
Poster Message
rsiera
User



Location:

Joined on:
09-Oct-2011 22:33:00
Posted:
38 posts
# 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.
  Top
Walaa
Support Team



Location:

Joined on:
21-Aug-2005 16:03:48
Posted:
14626 posts
# 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" ?


  Top
rsiera
User



Location:

Joined on:
09-Oct-2011 22:33:00
Posted:
38 posts
# 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?
  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
38047 posts
# 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
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
rsiera
User



Location:

Joined on:
09-Oct-2011 22:33:00
Posted:
38 posts
# 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.
  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
38047 posts
# Posted on: 24-May-2020 10:00:18.  
Hmm, then I don't know what happened. Keep us posted!

Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.