cancel
Showing results for 
Search instead for 
Did you mean: 

Error in HANA SQL: Invalid Object state

0 Kudos

Hi All,

I am trying to run a HANA query with multiple inner joins and filter on partition ranges. When I changethe partition range or do a count(*), my query is running fine. But selecting some columns from the joined tables with specific partition key filter (which is in "others" partition), I am getting the below error:

SAP DBTech JDBC: [2048]: column store error: search table error: [23058] exception 70023058: Internal error during join: invalid object state

Can you please help on this issue.

Thanks,

Mathan.

Accepted Solutions (0)

Answers (1)

Answers (1)

carlos_basto2
Explorer
0 Kudos

Hi mathanmsd ,

If you are using MDC on a SAP HANA 1.0 database Revisions of SPS12 <= 122.13, this SAP Note 2557786 - SQL Statement Fails With "column store error: search table error" - "Attribute id... would help you.

Then, empty the plan cache of the tenant in which the SQL statement fails should work.

If not, can you provide more details about the version you're using.

0 Kudos

Hi Carlos,

Thanks for your inputs.

We are currently in HANA 2 SP02 Rev 23.

Thanks,

Mathan.