$(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
0

How to fetch fulltext index preprocessing errors?

Jan 30, 2017 at 08:33 PM

65

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Daniel Reed
Feb 01, 2017 at 06:59 PM
0

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)

Share
10 |10000 characters needed characters left characters exceeded