transform stopped due to error: Transaction cancelled: Failed to get database connection

[sailajaj]

Hi All,
we are receiving the Error:" transform stopped due to error: Transaction cancelled: Failed to get database connection." while moving the data from staging to Target table.

Also, import set is in struck state and it's not in running state.

Any solutions for this?

[Tanushree Maiti]

Hi @sailajaj 

Check following configuration:

A. If any table in the reference chain has a missing or inefficient database index, the individual query execution time can be very high (e.g., 20–30 seconds per record). Since the transform processes records sequentially within a single transaction, the cumulative SQL time grows linearly with each record and eventually exceeds the platform's maximum transaction execution time, causing the transaction to be cancelled.

B.Add missing database indexes: Check sys_index.list for the tables involved in the reference chain. Ensure that columns used in JOIN conditions (especially foreign key columns like reference fields) are properly indexed.

Ref: KB2902037 Import Set Transform Fails with "Transaction cancelled: maximum execution time exceeded" D...