Summary

When logging in to a Laserfiche 8.x repository on Oracle, the folder browser contents pane may not successfully load and display the list of entries. The server error log includes the following SQL error:

Database statement execution error encountered.
CLI routine: SysEntryOpenListingStreamEx;
Message: [Oracle][ODBC][Ora] ORA-00918: Column ambiguously defined; SQL Statement: 'select id,link,type,flags,sdctl,rfid,parentid,toc_uuid,toc_owner,hasacl,c0,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12 from (select toc.tocid id,toc.linkto link,toc.etype type,toc.toc_flags flags,toc.toc_sdctl sdctl,toc.rfid rfid,toc.parentid parentid,toc.toc_uuid toc_uuid,toc.toc_owner toc_owner,case when bitand(toc.toc_flags, 32) = 32 then 1 else 0 end hasacl,case when linktoc.etype>=0 then 1 else 0 end isfolder,toc.tocid as c0,toc.name as c1,linktoc.edoc_ext as c2,nvl(toc.parentid, 0) as c3,toc.etype as c4,cast(case when toc.edoc_storeid is null then null else case when toc.edoc_size is null then 0 else toc.edoc_size end end as varchar2(20)) as c5,linktoc.etype as c6,toc.name as c7,0 as c8,case when linktoc.etype = 0 and linktoc.rfid = linktoc.tocid then 320 when linktoc.etype = 0 and bitand(linktoc.toc_flags, 1) = 1 then 257 when linktoc.etype = 0 then 256 when linktoc.etype = 1 then 384 when (linktoc.edoc_mime is not null or linktoc.edoc_ext is not null) and bitand(linktoc.toc_flags, 1) = 1 then 17 when linktoc.edoc_mime is not null or linktoc.edoc_ext is not null then 16 when bitand(linktoc.toc_flags, 1) = 1 then 1 else 0 end as c9,linktoc.rfid as c10,case when linktoc.final_date is not null then linktoc.final_date else rf_toc.final_date end as c11,case when bitand(linktoc.toc_flags, 524288) = 524288 or bitand(linktoc.toc_flags, 1048576) = 1048576 then 1 else 0 end as c12 from toc left join entryacl on toc.tocid = entryacl.tocid and entryacl.pos = 0 left outer join toc linktoc on case when toc.etype = -1 then toc.linkto else toc.tocid end = linktoc.tocid left outer join record_folder on linktoc.rfid=record_folder.tocid left outer join toc rf_toc on linktoc.rfid = rf_toc.tocid where (toc.etype>=0 or (toc.etype = -1 and linktoc.etype>=0))) q1 join listing on id = listing.tocid and listing.lsid = ? where listing.row_num>=? and listing.row_num<=? order by listing.row_num'

Cause

This error may be caused by Oracle bug 7318276: False ORA-918 with fix for bug 5368296 installed.

Please see Metalink note 7318276.8. This issue can affect Oracle versions 10.2.0.4, 11.1.0.6 and 11.1.0.7. This issue does not affect Oracle 11.2.

Resolution

Please install the latest recommended patch set for your version of Oracle.