My Oracle Support Banner

Audit Trail - Cascade Delete Assoc Operation Fails With Error In 19.3 With DB2 Z/OS (Doc ID 2549128.1)

Last updated on OCTOBER 28, 2022

Applies to:

Siebel CRM - Version 19.3 and later
Information in this document applies to any platform.

Symptoms

On : 19.3 version, Client Functionality


Error in Audit trail for Cascade Delete Assoc Operation. This prevents from deleting the record.

This error happens only with DB2 Z/OS

ERROR
-----------------------
SQLError: sqlstate 42610: [][CLI Driver][DB2] SQL0418N The statement was not processed because the statement contains an invalid use of one of the following: an untyped parameter marker, the DEFAULT keyword, or a null value. SQLSTATE=42610


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Navigate to Administration - Audit Trail 
  2. Enable audit trail for business component for Contact. 
  3. Make sure the ‘Assoc’ checkbox is set to TRUE. 
  4. Go to tab Child Buscomp and add the link Contact/Action
  5. Go to Contact screen, drilldown on a contact and go to the Activity view tab (Contact Detail View)
  6. Create a new activity. Do not commit it.
  7. Now press escape to undo the new record
  8. Step off and the error is generated. 

 

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!

In this Document
Symptoms
Cause
Solution


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