ASSIGN DBConnector(“PROD_CXONE_DB”, “SELECT account_type, tier FROM customer_profiles WHERE phone_number = '” + session.Customer.Number + “'”) TO db_result
IF db_result.Success EQUALS TRUE THEN
ASSIGN db_result.Data[0].account_type TO session.AccountType
ENDIF
The lookup keeps timing out after 3 seconds. Studio throws a 504 Gateway Timeout on the DBConnector action block. It’s not a network issue, the ODBC connection tests fine in the admin console. I’ve wrapped the query in a try-catch equivalent using the error handling flags but the script just drops to the fallback queue. The docs mention a 10-second default timeout but there’s no visible parameter to extend it in the action properties. I tried adding a SET_TIMEOUT variable to the action metadata, didn’t change anything. The result set is only two columns, shouldn’t take this long. My test calls with hardcoded numbers work fine, but anything pulling from the session variable fails. The SQL string looks correct when I print it to the debug log. The debug log shows the full query executing on the DB side but Studio never gets the response back. Connection pool settings are at default.