000037813 - ORA-12899: value too large for column "AVUSER"."STX_450689643"."OBJECT_TYPE" when importing a coverage file into an RSA Identity Governance & Lifecycle Review

Document created by RSA Customer Support Employee on Aug 7, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037813
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: All
   
IssueUploading a Coverage file to a User Access Review in RSA Identity Governance & Lifecycle fails with the following error in the user interface:
 

ORA-12899: value too large for column "AVUSER"."STX_450689643"."OBJECT_TYPE" (actual: 59, maximum: 50)


The following errors can be seen in the aveksaServer.log:
 
06/27/2019 14:35:43.103 ERROR (default task-24) [com.aveksa.gui.pages.review.definition.edit.coverage.UploadCoverageDataPageData] 
com.aveksa.server.review.ReviewServiceException: Error while processing coverage file <br><br>ORA-12899: value too large for column "AVUSER"."STX_450689643"."OBJECT_TYPE" (actual: 59, maximum: 50) 

at com.aveksa.server.review.ReviewServiceProvider.validateCoverageFile(ReviewServiceProvider.java:1695) 
at com.aveksa.server.review.ReviewServiceProvider.validateReviewerCoverageFile(ReviewServiceProvider.java:1658) 
Caused by: com.aveksa.server.db.PersistenceException: java.sql.BatchUpdateException: ORA-12899: value too large for column "AVUSER"."STX_450689643"."OBJECT_TYPE" (actual: 59, maximum: 50) 
at com.aveksa.server.review.ReviewUtils.loadCoverageIntoTmpTable(ReviewUtils.java:155) 
at com.aveksa.server.review.ReviewServiceProvider.validateCoverageFile(ReviewServiceProvider.java:1684) 
... 65 more 
Caused by: java.sql.BatchUpdateException: ORA-12899: value too large for column "AVUSER"."STX_450689643"."OBJECT_TYPE" (actual: 59, maximum: 50) 
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12296) 
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:246) 
at org.jboss.jca.adapters.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:1190) 
at com.aveksa.server.db.FileToTable.commitBatchToDB(FileToTable.java:397) 
at com.aveksa.server.db.FileToTable.process(FileToTable.java:372) 
at com.aveksa.server.review.ReviewUtils.loadCoverageIntoTmpTable(ReviewUtils.java:149) 


Please refer to RSA Knowledge Base Article 000030327 - Artifacts to gather in RSA Identity Governance & Lifecycle to find the location of the log files for your specific deployment.   
CauseThe separator character used to separate fields in the coverage file exists in the data itself.

 For example, the structure of a coverage file for a review is as follows:
 
<Reviewer/Monitor Filter>|<Subject Type>|<Subject Filter>|<Object Type>|<Object Filter>|<Privilege>


A legitimate sample entry could be as follows where the application name is Payroll.
 


user_id='009'|user|department='HR'|application|name='Payroll'|



What if the application name was 0025|Payroll as in:
 


user_id='009'|user|department='HR'|application|name='0025|Payroll'|



The use of the separator character (|) in the text field will cause this error.
 
ResolutionThe separator character cannot be used in the data. One way to resolve this issue would be to change the coverage file entry
 
FROM:




user_id='009'|user|department='HR'|application|name='0025|Payroll'|



TO:




user_id='009'|user|department='HR'|application|name='0025%Payroll'|


 

Attachments

    Outcomes