$(function () { pageContext.i18n.modTalk = 'moderation talk'; pageContext.i18n.replyToComment = 'Reply'; pageContext.i18n.modTalkEmpty = 'moderation talk is empty'; pageContext.url.getModTalk = "/comments/%25ID%25/listModTalk.json"; pageContext.url.possibleCommentRecipients = "/comments/%ID%/possibleRecipients.json"; pageContext.url.commentEdit = '/comments/%25ID%25/edit.html'; pageContext.url.commentView = '/comments/%ID%/view.html'; pageContext.i18n.commentVisibility = { 'full': 'Viewable by all users', 'op': 'Viewable by the original poster', 'mod': 'Viewable by moderators', 'opAndMod': 'Viewable by moderators and the original poster', 'other': 'Advanced visibility', 'dialogTitle': 'Comment visibility', 'selectGroups': 'Visible to groups', 'selectOther': 'Other recipients', 'selectOriginalPoster': 'Original poster', 'selectModerators': 'Moderators', 'selectAssignees': 'Asked to answer users' }; pageContext.i18n.commentMenuLabels = { 'comment-edit': 'comments.menu.edit', 'comment-delete': 'comments.menu.delete', 'comment-convert': 'comments.menu.convert' };pageContext.i18n.answer= { bestAnswer: 'Best Answer', controlBar : { accept: 'Accept', unaccept: 'Unaccept', acceptCommand: 'Accept this answer as correct', cancelAcceptedCommand: 'Remove this answers accepted status' } }; window.croles = { u: false, op: false, m: false, og: false, as: false, ag: false, dc: false, doc: false, eo: false, ea: false }; tools.init({ q: { e: false, ew: false, eo: false, r: false, ro: false, d: false, dow: false, fv: false, c: false, co: false, p: false, tm: false , ms: false, mos: false }, n: { f: false, vf: false, vfo: false, vr: false, vro: false, c: false, co: false, vu: false, vd: false, w: false, wo: false, l: false }, c: { e: false, eo: false, d: false, dow: false, ta: false, tao: false, l: false }, a: { e: false, ew: false, eo: false, d: false, dow: false, a: false, aoq: false, ao: false, tc: false, tco: false, p: false, tm: false }, pc: croles }, { tc: true, nsc: true }); commandUtils.initializeLabels(); }); Skip to Content
avatar image
Former Member

How to fetch fulltext index preprocessing errors?

Hi, I'm looking for a HANA equivalent to the Oracle "CTXSYS.CTX_USER_INDEX_ERRORS" and DB2 "SYSIBMTS.TSEVENT_####" views, which contain information about fulltext index preprocessing/indexing errors.


I can see errors in the "proprocessor_alert" log files in HANA Development Studio, but so far I don't see any way to fetch this info from the database and potentially work back to the original data. An example of this log entry is at the bottom of the post.

The only thing I've seen accessible with SQL is the error count stored in M_FULLTEXT_QUEUES.ERROR_DOCUMENT_COUNT, but no actual error information.


Thank you for any help or suggestions! If this doesn't exist, please recommend a component to make an internal message against.


---------------


[21857]{-1}[-1/-1] 2017-01-27 21:30:11.151348 e preprocessor Preprocessor.cpp(00593) : HANDLE: DISPATCH - Processing of 1 document(s) failed, last failed document key 'DB2_HANA_RE:FCI_ATTACHMENT_BLOBen.FILE_DATA:86579' (Code 10529), returning PREPROCESSOR_ACTIVITY_ERROR

[21857]{-1}[-1/-1] 2017-01-27 21:30:11.572054 e preprocessor PreprocessorImpl.cpp(00410) : Text analysis error '/sapmnt/ld7272/a/HDB/jenkins_prod/workspace/HANA__FA_CO_LIN64GCC48HAPPY_rel_fa~hana1sp12/s/textanalysis/tasdk/filters/isys/src/ISYSConverter.cpp: Line 743: Error 0x0500001D: Unsupported format: zip.', number of errors: 1

[21857]{-1}[-1/-1] 2017-01-27 21:30:11.572076 e preprocessor PreprocessorImpl.cpp(00432) : process(): Error in Document, theProcessResult was set to 10529

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 01, 2017 at 06:59 PM

    Doing further reading, the following fulltext SQL functions seem to be sufficient for our purposes. The errors messages are not quite as detailed, but it's something.

    INDEXING_ERROR_CODE(column)

    INDEXING_ERROR_MESSAGE(column)

    INDEXING_STATUS(column)

    Add comment
    10|10000 characters needed characters exceeded