Error while running the SQL Query- Incorrect list format: 0 >= 0_SQLSTATE: S1000

Question

Question

Virat Sharma · Jan 11, 2023

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

Error getting attributeColumn: Name

Error getting attributeColumn: Amount

Error getting attributeColumn: RollNumber

Thanks in advance !!

Product version: Caché 2017.1

Discussion (2)2

Log in or sign up to continue

score 0 · Answer 1 · 2023-01-11T11:51:03-05:00

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

score 0 · Answer 2 · 2023-01-16T23:37:42-05:00

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).