New post
Question
Virat Sharma · Jan 11

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

#Databases #SQL #Caché #InterSystems IRIS

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
0
0 139
Discussion (2)2
Log in or sign up to continue
Enrico Parisi · Jan 11

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

0 0
Virat Sharma · Jan 16

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

0 0