HANA SQL error: 2048 column store error: [6900] Attribute engine failed

[shaji_narayanan]

Hello HANA Experts!

We are facing below error in our ERP Business Suite on HANA rev.80 Database.  This is a test server and only has 70GB of RAM.

The error happens on SELECT statement for table COIX for filed CLUSTD.

Any other combination of SELECT statement works OK, but even a simple distinct SELECT with field CLUSTD fails.

Example SQL statement:

select distinct aedtm, clustd from "SAPECC"."COIX" where aedtm = 19981214;

Error received is:

2EETW000 sql error:  2048 column store error: search table error:  [6900] Attribute engine failed

2EETW125 SQL error "2048" during "" access: "column store error: search table error:  [6900] Attribute engine failed"

=========================================

Error from Index Server log file is as follows:

[16641]{200028}[24/0] 2014-06-25 17:51:46.138328 e LogicalPageAccesLogicalPageAccessImpl.cpp(01128) : handleFailedChecksumCheck: all retries failed

[16641]{200028}[24/-1] 2014-06-25 17:51:46.138782 e attributes AttributeStoreFile.h(00328) : AttributeStoreFile error 'ISAPECCCOIXAAattribute_209.bin': AttributeEngine: error reading file; failed with rc 6946

[16641]{200028}[24/-1] 2014-06-25 17:51:46.139100 e attributes SingleAttribute2.h(05383) : loadFileSingleV1() failed: 6923 Attribute load failed

[16641]{200028}[24/-1] 2014-06-25 17:51:46.139327 e SERVER_TRACE DeltaIndexManager.cpp(03249) : SAPECC:COIX$delta_1$ (6977): jeReadValueIds failed for attribute <209> rc=6923

[16641]{200028}[24/-1] 2014-06-25 17:51:46.139594 e Executor PlanExecutor.cpp(00389) :  executeSingleThreaded plan plan1@<host_name>:30003 failed with rc 6923; Attribute load failed

=========================================

Any help towards resolution is highly appreciated.

Thanks in advance and best regards,

shaji

[Former Member]

This message was moderated.

[Former Member]

Hi Friend..

Can you please explain the steps ... how did you resolved .. I am getting same issue

[wenjie_he]

Hi

Please see the note 1978433 - System copy import based on NW 740 running on HANA failed due to Attribute save failed error.

[lbreddemann]

Hi Shaji

you might want to check with SAP support on that one.

Appears as if there is a corruption present at this column store table.

Cheers,

Lars

[shaji_narayanan]

Thanks for the quick reply, Lars.

An incident is already with SAP OSS for last few days; still waiting for an initial response/reply.

Cheers,

Shaji

[lbreddemann]

If this is taking too long, make sure that the incident priority is chosen correctly (HIGH seems appropriate). Also you my phone in to the customer interaction centre (CIC) to get status updates or request a feedback.

- Lars

[former_member190691]

Hi Shaji,

I have the same error, still you have this issue? how did you solved it?

Regards.

Fernando.

[Former Member]

We're also seeing the same error with DB version 1.00.092.00.1422010182. Can anyone that's solved this post the resolution? Thanks!

[lbreddemann]

Looks like you're facing a database corruption.

Please get in touch with SAP Support for further analysis.

- Lars