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 …