Skip to main content
Solved

DB_SWITCH_SESSION:Could not switch database proxy session to user [username]

ctaylor56
Hero (Partner)
Forum|alt.badge.img+14

Anybody had this error on the sync monitor in mWorkOrder?

 

DB_SWITCH_SESSION:Could not switch database proxy session to user [username]

 

Apparently the user’s account got locked prior to sending new transactions to IFS.  Since then we have unlocked the account but we are still getting this error on the user’s sync monitor.  Looking at the Sync Traces, data from IFS to mobile are working, but we have over 200+ queued transactions waiting to be sent from Mobile to IFS.  We have run the query to check if they have the IFSSYS proxy user setup and they do.  Any ideas for this error in mobile?  Idle time on the Oracle profile is unlimited too.

 

 

Best answer by ctaylor56

Found that if you resend the transaction from mobile, the error gets resolved.  Just ensure the account is unlocked before resending from mobile.

View original
Don't Count the Days, Make the Days Count
Did this topic help you find an answer to your question?

A
Superhero (Employee)
  • anmise
  • Superhero (Employee)
  • September 1, 2020
ctaylor56 wrote:

Anybody had this error on the sync monitor in mWorkOrder?

 

DB_SWITCH_SESSION:Could not switch database proxy session to user [username]

 

Apparently the user’s account got locked prior to sending new transactions to IFS.  Since then we have unlocked the account but we are still getting this error on the user’s sync monitor.  Looking at the Sync Traces, data from IFS to mobile are working, but we have over 200+ queued transactions waiting to be sent from Mobile to IFS.  We have run the query to check if they have the IFSSYS proxy user setup and they do.  Any ideas for this error in mobile?  Idle time on the Oracle profile is unlimited too.

 

 

Can you check the Oracle Profile Idle Time parameter value? It should always be set to UNLIMITED.
 

The connection pool needs to be restarted after you’ve changed the profile.

 

A
Superhero (Employee)
  • anmise
  • Superhero (Employee)
  • September 1, 2020

Actually found another thread for it now, luckily we had the same advice :) 

 

https://community.ifs.com/technology-infrastructure-cloud-integration-dev-tools-50/db-switch-session-could-not-switch-database-proxy-session-to-user-username-240

ctaylor56
Hero (Partner)
Forum|alt.badge.img+14
  • ctaylor56
  • Hero (Partner)
  • September 1, 2020
anmise wrote:

Actually found another thread for it now, luckily we had the same advice :) 

 

https://community.ifs.com/technology-infrastructure-cloud-integration-dev-tools-50/db-switch-session-could-not-switch-database-proxy-session-to-user-username-240

My Oracle profile was already on unlimited for idle time.  We’ve done no changes to this.

Don't Count the Days, Make the Days Count
ctaylor56
Hero (Partner)
Forum|alt.badge.img+14
  • ctaylor56
  • Hero (Partner)
  • September 18, 2020

Found that if you resend the transaction from mobile, the error gets resolved.  Just ensure the account is unlocked before resending from mobile.

Don't Count the Days, Make the Days Count

Reply


Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings