RCA - AWB Generation Issue
Resolved
Mar 23, 2026 at 11:06am UTC
Impacted Time Window: 23rd March 2026, 10:40 AM IST to 11:35 AM IST
ClickPost manifestation service encountered an issue in the primary storage layer during data persistence, which caused failures in the API. ClickPost system uses a relational database as the primary transactional storage system. The issue was traced to a table's primary key column running out of range. By default the integer column type is used in the legacy core tables for the primary key column which can accommodate IDs till 2147483647 (2^31 - 1). This limit got exceeded which caused query failures, that got cascaded to the API.
As an immediate action, the column capacity was bumped up to Big Integer (having much higher capacity 2^63 - 1), which resolved the issue. Post this action, the orders started getting through normally.
Future prevention steps
* ClickPost team will audit the legacy core table column capacities and perform upscaling wherever needed.
* The team will audit the storage layer alerts and add further granularity to help in proactive detection.
Affected services