Deleting a dataset and recreating another one with the same name in a single procedure can lead to errors in the EBX repository.

Deleting a dataset and recreating another one with the same name in a single procedure can lead to errors in the EBX repository.

book

Article ID: KB0138320

calendar_today

Updated On:

Products Versions
TIBCO EBX 6.0 to 6.2.2

Description

EBX 6 versions contain a bug which can lead to repository corruption.
It occurs when a single procedure deletes a dataset and then creates another one with the same reference.

The exact scenario to reproduce the corruption implies many subtilities such as

  • the initial creation of the deleted dataset with errors because of inter-instance links,
  • and a data model with inter-instance links or other data models having inter-instance links to this model triggering a nested validation procedure that reloads tables from the deleted dataset during the new dataset creation.

This bug is referenced under CP-29202: Deleting and then creating a dataset with same AdaptationReference within the same procedure may corrupt the repository.

Resolution

Until the version which contains the correction is released, we strongly discourage to execute both operations in the same procedure.
A simple workaround consists in applying the deletion and the creation of the new dataset in separate procedures.

Issue/Introduction

A bug in EBX 6 can lead to repository corruption under very specific conditions if a single procedure deletes a dataset and immediately creates another one with the same reference.