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 OCTOBER 21, 2024

Applies to:

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

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