Oracle

Keep Batch Deletes Inside …

A user selected several records and clicked Delete. The request returned HTTP 500, and the first database error came from a grouped detail query intended to assemble display text. The mutation had inherited a read dependency that it did not need.

That coupling made the failure larger than one …

Fixing Today-Only Metrics …

An operations page displayed two headline counters under a label that meant “today.” A direct read-only check of records from the current local date returned smaller populations. The database was still changing as work continued, yet normal activity could not explain why every comparison contained a …

Deriving Workflow Status …

An operations dashboard began moving orders into later phases before the work behind those phases had started. A completed receipt could appear as unloading or inspection. A shipped order could still carry the label of an earlier verification phase. The underlying transactions continued, but the …

Designing Rerunnable …

A database cloned for an upgrade rehearsal began from a valid source snapshot. Later source-side schema and reference-data changes still had to be applied to the test target before application testing could use a comparable baseline.

The target was not empty. It already contained part of the desired …

Repairing Orphaned …

An order-copy request failed with an application-defined database error. The message suggested that inventory quality made the stock ineligible, yet the physical quantity existed and the recorded quality attribute allowed the operation.

The database still had a valid reason to reject the write. …

Repairing Oracle Sequence …

A newly created business record failed with ORA-00001 on a primary key. That was unexpected because the application generated the key from an Oracle sequence. The log resolved the contradiction: the generated value already belonged to an older row that had arrived with the migrated data.

This was …