Error while running the SQL Query- Incorrect list format: 0 >= 0_SQLSTATE: S1000
Hello Team,
I need a help in the following error I am getting while running the SQL Query. I am running the SQL Query from different table using inner join. I run this everyday for last 90 days but for few days while extracting the data through this query I am getting this error. Please assist.
SQLException was thrown: Incorrect list format: 0 >= 0_SQLSTATE: S1000
SQLException was thrown: Incorrect list format: 0 >= 0_SQLSTATE: S1000
Error getting attributeColumn: Name
Error getting attributeColumn: Amount
Error getting attributeColumn: RollNumber
Thanks in advance !!
Product version: Caché 2017.1
It's very difficult....nearly impossible to help with the little info provided.
The error does not looks like an IRIS/Caché error, is it an IRIS/Caché table or an external table?
How are you invoking the query? System Management Portal? Embedded SQL? xDBC?
Enrico
Hi Enrico,
Yes it's a cache table (but running query using inner join to get the data from multiple tables) .
Invoking query through System Management Portal (in logical mode).