My Oracle Support Banner

CSDT Import Failed": com.fatwire.assetapi.common.AssetAccessException: Error met whiling saving assets [XXXXXXX:asset id ] and the error number is -105 (Doc ID 2501670.1)

Last updated on MARCH 28, 2023

Applies to:

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

Symptoms

Command-Line CSDT is failing on import with the error:

Import Error: com.fatwire.cs.core.realtime.DataException: com.fatwire.assetapi.common.AssetAccessException: Error met whiling saving assets [XXXXXXX:asset id ] and the error number is -105

Sites.log shows an error similar to the following:

[ERROR] [] [oracle.wcsites.db] [tid: 113] [userId: <anonymous>] [ecid: dbb192b9-6682-480c-bdd2-223012be507c-000093d7,0] [APP: sites] [partition-name: DOMAIN] [tenant-name: GLOBAL] Exception executing prepared statement: INSERT INTO [tablename] (ID,FLEXTEMPLATEID,STATUS,CREATEDBY,CREATEDDATE,UPDATEDBY,UPDATEDDATE,NAME,DESCRIPTION,SUBTYPE,FILENAME,TEMPLATE,FW_UID) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)[[
ID = [idnum]
FLEXTEMPLATEID = [template] 
STATUS = PL
CREATEDBY = [username] 
CREATEDDATE = [datetime] 
UPDATEDBY = [username]
UPDATEDDATE = [datetime] 
NAME = [assetname] 
DESCRIPTION = [description] 
SUBTYPE = [subtype] 
FILENAME = [filename] 
TEMPLATE = [template] 
FW_UID = [uid] java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint ([schema.index]) violated

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


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