Getting Attribute load failed error

[former_member85438]

Hi All,

We are facing below error while querying database.

SAP DBTech JDBC: [2048]: column store error: search table error: [6923] Attribute load failed

Please help. If it this issue is already fixed, please provide details about that.

Thanks,

Kunjan

[lucas_oliveira]

Hi,

Difficult to know what the issue is exactly. There's probably more information on the indexserver traces about the error. Provide the trace contents and maybe we can help.

BRs,

Lucas de Oliveira

[former_member85438]

Hi Lucas de Oliveira,

I requested jira ticket to get the index server traces.

http://jira.successfactors.com/browse/COSR-51472

[18816]{-1}[764/147663541] 2015-10-31 00:28:07.061085 e attributes DictStore.cpp(00669) : AttributeStoreFile error 'I^AQACANDROT_ANASCMGPH^AGENERIC_OBJECT_T^AA^AA^Aattribute_610.bin': attribute value is not a date or wrong syntax; failed with rc 6931
[18816]{-1}[764/147663541] 2015-10-31 00:28:07.061228 e attributes SpAttribute2.h(01519) : loadFileSingleV1() failed: 6923 Attribute load failed
[18816]{-1}[764/147663541] 2015-10-31 00:28:07.061389 e delta_merge MergeAttributeJob.cpp(00103) : merge failed for attribute 610on index QACANDROT_ANASCMGPH:GENERIC_OBJECT_T (272471)
[54825]{-1}[764/147663541] 2015-10-31 00:28:07.070012 e delta_merge DeltaIndexManager.cpp(04734) : mergeDeltaIndex2 failed for QACANDROT_ANASCMGPH:GENERIC_OBJECT_T (272471) rc=6923
[54825]{-1}[764/147663541] 2015-10-31 00:28:07.071034 e delta_merge DeltaIndexManager.cpp(05635) : do rollbackDeltaMerge merge for idx QACANDROT_ANASCMGPH:GENERIC_OBJECT_T (272471)
[54825]{-1}[764/147663541] 2015-10-31 00:28:07.098906 e Mergedog Mergedog.cpp(01206) : Automerge failed:

{IndexName: QACANDROT_ANASCMGPH:GENERIC_OBJECT_T, Trigger: 7, ReclaimDelta: false, DeltaMerge: true, OptimizeCompression: false, MainSize: 14026528}

, error: Attribute load failed;index=QACANDROT_ANASCMGPH:GENERIC_OBJECT_Ten,attribute='CREATED_DATE' (610)(6923)
[19022]{-1}[751/147663978] 2015-10-31 00:31:29.067661 e attributes DictStore.cpp(00665) : rc 6931 after handling dictionary write type 114 at filepos 34377
[19022]{-1}[751/147663978] 2015-10-31 00:31:29.067696 e attributes DictStore.cpp(00669) : AttributeStoreFile error 'I^AQACANDROT_AMWAYPH^AGENERIC_OBJECT_T^AA^AA^Aattribute_610.bin': attribute value is not a date or wrong syntax; failed with rc 6931

Thanks,

Kunjan