ARRFCASEAUDITLOG partitioning query
search cancel

ARRFCASEAUDITLOG partitioning query


Article ID: 232025


Updated On:


CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort) CA Risk Authentication


we wanted to create partitioning of ARRFCASEAUDITLOG table. 

On table ARRFCASEAUDITLOG the column [DTCREATED] is nullable can we make it not null 

Do we have any issue on it?


Release : 9.1

Component : RiskMinder(Arcot RiskFort) Risk Authentication


ARRFCASEAUDITLOG table is used by the Case Management server and if you do not use Case Management server this table can be truncated.

The DTCREATED column is NULLABLE but it does not store any NULL values and that is programmatically handled so the DB partitioning can be done without issues as the data store is not NULL in that column.