Column store errors during runtime

[Former Member]

Hi,

I created a HANA instance in the trial landscape and directed my application to use the HANA instance schema. Over time, I get errors:

SAP DBTech JDBC: [2048]: column store error: search table error: [29] attribute not defined for physical index;internal error: attribute 'NEO_29J91OPIP2IAEWXFUZRHT093R:CA_EV_VENUEen/PK_EVENT_VENUE_ID' not found in indexInfoMap

I'm using the HANA instance instead of the default schema created from the application because I need to run spatial queries, which is currently only available in the HANA instance.

Does anyone know what's wrong?

[Former Member]

Have you found any solution? I'm getting the same Error:

attribute not defined for physical index … not found in indexInfoMap …

And also this exception, which might be the Soruce:

(90358): exception  1: no.10000008  (ims_search_api/Delta/impl/DeserializerContext.cpp:2112

Attribute engine failed(6900); $function$=writeDataIntoDelta

TableLoad.cpp(00580) : TableLoad::load(): replay log failed

And I can confirm, it happens to tables with a spatial column. Also a few days ago, hana started to loose data after restarting the system, Shutdown at 25.08.2014, the data could not be loaded the next day after starting HANA again :

Now the whole table seems to fail :- (

[Former Member]

Unfortunately not. I had to ditch the spatial columns and created lat/lon columns and convert them on the fly to st_point during queries.

[Former Member]

Ok thanks, I'll open a ticket and post a solution here as soon as there is a patch available.

[bernd_hofmann]

As this seems to be an error of the SAP HANA database itself (and not the SAP HANA Cloud Platform) please check Support Communities | SAP HANA for a solution.

Thanks and Regards,

Bernd

[Former Member]

Additional errors from the HCP logs:

javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.0.v20130507-3faac2b): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [2048]: column store error: search table error:  [10000008] exception 10000008:

ims_search_api/Delta/impl/DeserializerContext.cpp:2099

Failed to write data into NEO_95BOXA4K094KH5V4JNKE5KDPZ:CA_EV_VENUE$delta_1$en: Attribute engine failed(6900); $function$=writeDataIntoDelta

Error Code: 2048

Call: SELECT PK_EVENT_VENUE_ID, ADDRESS, DESCRIPTION, EMAIL, EXTERNAL_ID, FAX, LATITUDE, LONGITUDE, NAME, PHONE, WEBSITE, FK_EVENT_DATA_PROVIDER_ID FROM CA_EV_VENUE WHERE ((FK_EVENT_DATA_PROVIDER_ID = ?) AND (EXTERNAL_ID = ?))

  bind => [2 parameters bound]

Query: ReadAllQuery(name="EventVenue.findByProvider" referenceClass=EventVenue sql="SELECT PK_EVENT_VENUE_ID, ADDRESS, DESCRIPTION, EMAIL, EXTERNAL_ID, FAX, LATITUDE, LONGITUDE, NAME, PHONE, WEBSITE, FK_EVENT_DATA_PROVIDER_ID FROM CA_EV_VENUE WHERE ((FK_EVENT_DATA_PROVIDER_ID = ?) AND (EXTERNAL_ID = ?))")

The table CA_EV_VENUE contains spatial column and only this table is "failing". Other tables doesn't contain spatial columns are fine.

I'm trying to get HANA DB traces from the HCP team and was wondering which traces will be helpful for the HANA team.