Since a couple of weeks, I am occasionally seeing this message in the Windows Event Viewer about an SQL statement issued by LaserFiche (v9.2).

I wasn't closely monitoring the Event Viewer before so I may have missed past occurrences.

Does anyone know what tool can issue such a statement ? No user complaints, no Workflow process errors, or anything else so far that can lead me to identify the source of this.

It can have something to do wit hmy database being 10.2 and this query using recursion which is not fully supported until 11.2, but still I'd like to know where this is coming from.

Thank you !

Here is what I finde in the Event Viewer :

Database statement execution error encountered. Session ID: ; Dialog ID: ; Repository: 'XXX'; CLI routine: CatalogManager::SubmitSingleEntry; Message: ORA-32033: unsupported column aliasing ; SQL Statement: 'WITH t(ids) AS (SELECT :id<int> FROM DUAL) SELECT tocid, 1 as mptid, 0 as sptid, 0 as metaid, name as value, native_language FROM toc WHERE EXISTS (SELECT ids FROM t WHERE ids = toc.tocid) UNION ALL SELECT tocid, 2, 0, 0, edoc_ext, native_language FROM toc WHERE edoc_ext IS NOT NULL AND EXISTS (SELECT ids FROM t WHERE ids = toc.tocid) UNION ALL SELECT toc.tocid, 4, 0, 0, notes, native_language FROM version_group, toc WHERE version_group.tocid = toc.tocid AND notes IS NOT NULL AND EXISTS (SELECT ids FROM t WHERE ids = toc.tocid) UNION ALL SELECT toc.tocid, 5, 0, vhist_toc.version, vhist_toc.toc_comment, toc.native_language FROM toc, vhist_toc WHERE vhist_toc.tocid = toc.tocid AND vhist_toc.toc_comment IS NOT NULL AND EXISTS (SELECT ids FROM t WHERE ids = toc.tocid) UNION ALL SELECT toc.tocid, 6, propval.prop_id, pos, str_val, native_language FROM propdef, propval, toc WHERE BITAND(propdef.prop_flags, 4) <> 0 AND propdef.prop_id = propval.prop_id AND propval.tocid = toc.tocid AND str_val IS NOT NULL AND EXISTS (SELECT ids FROM t WHERE ids = toc.tocid) UNION ALL SELECT toc.tocid, 7, 0, document_signatures.sig_id, sig_comment, native_language FROM document_signatures, toc WHERE document_signatures.tocid = toc.tocid AND sig_comment IS NOT NULL AND EXISTS (SELECT ids FROM t WHERE ids = toc.tocid) UNION ALL SELECT toc.tocid, 8, 0, document_signatures.sig_id, cert_subject, native_language FROM document_signatures, toc WHERE document_signatures.tocid = toc.tocid AND cert_subject IS NOT NULL AND EXISTS (SELECT ids FROM t WHERE ids = toc.tocid) UNION ALL SELECT toc.tocid, 9, 0, tag_id, et_descrip, native_language FROM entry_tag, toc WHERE toc.tocid = entry_tag.tocid AND et_descrip IS NOT NULL AND EXISTS (SELECT ids FROM t WHERE ids = toc.tocid) UNION ALL SELECT toc.tocid, 10, ann.ann_type, ann_id, ann_text, toc.native_language FROM ann, toc, doc WHERE toc.tocid = doc.tocid AND doc.pagenum >= 0 AND doc.page_id = ann.page_id AND ann_text IS NOT NULL AND EXISTS (SELECT ids FROM t WHERE ids = toc.tocid) UNION ALL SELECT toc.tocid, 11, ann.ann_type, ann_id, ann_comment, toc.native_language FROM ann, toc, doc WHERE toc.tocid = doc.tocid AND doc.pagenum >= 0 AND doc.page_id = ann.page_id AND ann_comment IS NOT NULL AND EXISTS (SELECT ids FROM t WHERE ids = toc.tocid) '; SQL variable: ''; SQL State: .