Getting -105 Error While Mirroring Table (Doc ID 2193542.1)

Last updated on APRIL 24, 2023

Applies to:

Symptoms

Publish is failing when using Initialize Realtime Destination. The following error can be seen in the UI

Error:during mirror operation. Error number=-105. sendRows: extraction query failed, errno=-105

And an error similar to the following can be found in the sites.log:

[fatwire.logging.cs.db] ERROR SQLException executing query: SELECT id, name, description, classname, args FROM FILTERS WHERE id IN (allItems.id) : com.fatwire.logging.cs.db-(1152)
java.sql.SQLSyntaxErrorException: ORA-00904: "ALLITEMS"."ID": invalid identifier

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.