41
Views
5
Comments
Error executing query. Could not assign '' to ' tabel name  There is no more data to

we have one column in entity  and this entity comes from 3rd party db extension, and when we bind some other column it's working fine. but when we bind 1 particular column we are getting this error. 

Error executing query. Could not assign '' to ' table name  There is no more data to return.



2024-03-22 09-17-23
Chandra Vikas Sharma

One more information need to add the original data type of the issued column is CLOB data type.

 

2019-04-09 00-57-55
carl ruhle

It's a bit hard to help you with what you said.  Is it possible to have more information?

It looks like an error in building the SQL statement. 

2024-03-22 09-17-23
Chandra Vikas Sharma

when we building the SQL statement  and Test with test query option it's return the data but on runtime it will give me error same happened with aggregate also . in service studio we can see the data but on runtime it gives the error on that column .

2019-04-09 00-57-55
carl ruhle

What I read is that without any change the query returns an error, the only difference is the environment.

Could you give the error code and the SQL statement, you can cross over anything that you don't want to share with us. 

2020-11-10 07-09-26
Dadi

Hi @cvsharma nds 

You already check the output structure? or the SQL syntax?

It might be helpful to give the screenshot about what you trying for and give description whats the goal, so others member on the community can share their ideas to solve your issues


Regards

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.