CatalogMover: fails to import with No access allowed for requested action error (Doc ID 1519246.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle WebCenter Sites - Version 6.3.0 and later
Information in this document applies to any platform.

Symptoms

Importing a table using CatalogMover fails with No access allowed for requested action.

With logger com.fatwire.logging.cs.db set to DEBUG, the following is seen in the logs:

[2013-01-10 13:05:27,550 UTC] [DEBUG] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] INSERT INTO SystemInfo (TBLNAME,DEFDIR,SYSTABLE,ACL,METADATA) VALUES (?,?,?,?,?)
TBLNAME = tt1357121505880
DEFDIR = c:/FW_Application/
SYSTABLE = tmp
ACL = Browser,SiteGod
METADATA = shdkQn8HhQFBwRgLjpPh4J1frCknhvLdNzGQQZtL6JJLh9qlyv0Q!-1136825077!1357823079354
[2013-01-10 13:05:28,815 UTC] [DEBUG] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db]
<!--FTCS|||result=failure|||reason=No access allowed for requested action.|||err=-3|||command=replacerows|||params=tablename=tt1357121505880|||-->
[2013-01-10 13:05:28,815 UTC] [ERROR] [.kernel.Default (self-tuning)'] [cs.core.db.DBTransaction] TransactionUnit failed to execute
com.fatwire.cs.core.db.TransactionAbortException: replacerows failed

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms