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]

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.