ORA-00913: too many values during arcotUDS dbArchive process

Document ID : KB000100715
Last Modified Date : 11/07/2018
Show Technical Document Details
Issue:
ORA-00913: too many values error is occurring during arcotUDS dbArchive process. Below is the exact error that occurs during the archive process: 

2018-03-29 18:05:35,093 BRT : [DbArchiveThread-1] : ERROR : dbarchive.impl.DbArchiveImpl : Error processing table: ARWFAUTHAUDITLOG 
java.sql.SQLSyntaxErrorException: ORA-00913: too many values 

 
Environment:
Version= 9.0.02 
Cause:
ARWFAUTHAUDITLOG table has PUSHAUTHDEVICEID column whereas the ARWFAUTHAUDITLOG_AR table does not have this column therefore when we archive rows from ARWFAUTHAUDITLOG table and try inserting it into the archive table the UDS log prints the error and the insert fails as the PUSHAUTHDEVICEID column is not present in archive table. 



 
Resolution:
Please run the below command on the arcotDB so that a PUSHAUTHDEVICEID column is created. 

ALTER TABLE ARWFAUTHAUDITLOG_AR ADD PUSHAUTHDEVICEID VARCHAR(128); 

Restart UDS.

 A fix will be available in upcoming release or patch.