Skip to content

The mWorkOrder sync monitor shows 'DB_SWITCH_SESSION: Could not switch database proxy session to user [username]' with over 200 queued transactions stuck waiting to send from Mobile to IFS. The user's database account had gotten locked and has since been unlocked, the IFSSYS proxy user setup is confirmed correct, and Oracle profile idle time is unlimited, but the error persists on the sync monitor.

Answer

Confirm the account is genuinely unlocked, then explicitly resend the queued transaction(s) from the mobile device itself — simply unlocking the account doesn't automatically clear this specific error on transactions that already failed while the account was locked; those specific queued transactions need to be manually resent after the account is confirmed unlocked, at which point they go through normally.

← Browse Mobile and service touch apps (MWO/MRO) questions