My Oracle Support Banner

Virus Scanning Fails with "ORA-02291: integrity constraint (BEE_DATA.VS_DEFINITIONS$FK1) violated" (Doc ID 1210115.1)

Last updated on APRIL 07, 2025

Applies to:

Beehive - Version 2.0.1.1.0 and later
Information in this document applies to any platform.

Symptoms

Virus scanning is not working for incoming messages.

BEEAPP logfile shows the following errors:

[2010-08-31T14:15:31.144-07:00] [beehive] [WARNING] [] [virusscanner.util.VirusDefinitionsCache] [tid: <TID>] [userId: <USER EID] [ecid: <ECID>] [bee_compid: <COMPID>] [bee_logonrecid: <RECID>] [bee_principalid: <PRINCIPAL EID>] [bee_compname: EmailService] Encountered VirusScannerDAException oracle.ocs.virusscanner.service.storage.VirusScannerDAException: OcsExceptionT[BEES-03012,Error Message:Error updating data in vs_definitions, Severity:WARNING, SqlCode:-2291, SqlErrorMsg:ORA-02291: integrity constraint (BEE_DATA.VS_DEFINITIONS$FK1) violated - parent key not found, ErrorStack:ORA-06512: at "BEE_CODE.VS_IMPL_DEFINITIONS", line 593[[

, CallStack:----- PL/SQL Call Stack -----
object line object
handle number name
0x224b01858 72 BEE_CODE.OCS_EXCEPTION_T
0x224b02790 35 BEE_CODE.OCS_ERROR_CODE_T
0x22de332b8 613 package body BEE_CODE.VS_IMPL_DEFINI

Please execute the following query, to verify if you are having this issue:

If row return has provider_id value 2, then you are hitting this problem.

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!

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