Symptom
Running CALL CHECK_TABLE_CONSISTENCY () with "check" option results in ERROR_CODE: 5400 and ERROR_MESSAGE:
Invalid lob type 64 in column of type 32 at udiv xxxxx and rowid xxxxx
During consistency checks several rows seems to have issues with invalid lob type showing in the output result similar to below:
SCHEMA_NAME,TABLE_NAME,COLUMN_NAME,PART_ID,ERROR_CODE,ERROR_MESSAGE
"XXX_XXX_XXX","XXX_TASK_LIST","XML",0,5400,"Invalid lob type 64 in column of type 32 at udiv X and rowid XX"
"XXX_XXX_XXX","XXX_TASK_LIST","XML",0,5400,"Invalid lob type 64 in column of type 32 at udiv XX and rowid XX"
"XXX_XXX_XXX","XXX_TASK_LIST","XML",0,5400,"Invalid lob type 64 in column of type 32 at udiv XX and rowid XX"
"XXX_XXX_XXX","NR_NARRATIVE","FILTRO",0,5400,"Invalid lob type 64 in column of type 32 at udiv XX and rowid XX"
"XXX_XXX_XXX","NR_NARRATIVE","FILTRO",0,5400,"Invalid lob type 64 in column of type 32 at udiv XX and rowid XX"
"XXX_XXX_XXX","NR_NARRATIVE","FILTRO",0,5400,"Invalid lob type 64 in column of type 32 at udiv XX and rowid XX"
"XXX_XXX_XXX","NR_NARRATIVE","FILTRO",0,5400,"Invalid lob type 64 in column of type 32 at udiv XX and rowid XX"
"XXX_XXX_XXX","NR_NARRATIVE","FILTRO",0,5400,"Invalid lob type 64 in column of type 32 at udiv XX and rowid XX"
"XXX_XXX_XXX","NR_NARRATIVE","FILTRO",0,5400,"Invalid lob type 64 in column of type 32 at udiv XX and rowid XX"
Read more...
Environment
- SAP HANA 1.0
- SAP HANA 2.0
Product
SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0
Keywords
KBA , HAN-DB , SAP HANA Database , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.