DAOSQLException: message 'Error on MAIN_TH', occ error string 'OCC-102: backlog eviction',"

3DFrank
Contributor
Contributor

Today I'm getting this and a variety of other errors when attempting to check out using PayPal Express on Sandbox:

DAOSQLException: message 'Error on MAIN_TH', occ error string 'OCC-102: backlog eviction', occ error number 0 query: 'SELECT a.account_number, a.account_number_enc, a.name, a.required_security_level, a.pp_legal_entity, a.country_code, a.disposition, a.update_version, a.last_time_opened, a.last_time_closed, a.time_created, a.time_updated, a.update_version, apl.account_number, apl.receiving_prefs, apl.subprime, apl.subprime_subcat, apl.primary_currency_code, apl.fraud_score, apl.time_created, apl.time_updated, apl.update_version, at.account_number, at.type, at.time_created, at.time_updated, at.update_version, ap.id, ap.account_number, ap.party_id, ap.relationship_type, ap.status, ap.time_created, ap.time_updated, ap.update_version, app.account_number, app.account_party_id, app.time_created, app.time_updated, app.update_version, wf.account_number, wf.flag_group_id, wf.flag_group_value, wf.pypl_time_touched, wf.update_version FROM ACCOUNT A JOIN ACCOUNT_TYPE AT ON A.ACCOUNT_NUMBER = AT.ACCOUNT_NUMBER LEFT JOIN ACCOUNT_PROPERTY_LEGACY APL ON A.ACCOUNT_NUMBER = APL.ACCOUNT_NUMBER LEFT JOIN ACCOUNT_PARTY AP ON A.ACCOUNT_NUMBER = AP.ACCOUNT_NUMBER LEFT JOIN ACCOUNT_PARTY_PRIMARY APP ON AP.ACCOUNT_NUMBER = APP.ACCOUNT_NUMBER LEFT JOIN WUSER_FLAGS WF ON A.ACCOUNT_NUMBER = WF.ACCOUNT_NUMBER WHERE a.account_number IN ( :account_number_0 ) ', bindings: [:account_number_0=XXXX85831015584XXXX] Backtrace: PPException::PPException(String const&) SQLException::SQLException(String const&, String const&, int) dao::ErrorPolicy::static_check(int, TransactionHandler*, OCCHost const&, String const&, String const&) dao::Private::OCCResultSetIterator::has_next() dao::SelectIterator::has_next() User::AccountPrefetch_DAOImpl::load_by_account_numbers(TArray const&, User::AccountPrefetch_DAO::CustomClauses const&) User::AccountPrefetchDAOImpl::load_by_account_numbers(TArray const&, TArray&, TArray&, TArray&, TArray&, TArray&) User::AccountPartyPrefetchPBImpl::load_account_and_party_data(TArray const&, TArray&, TArray&, TArray&, TArray&, TArray&, TArray&, TArray&, TArray&, boost::shared_ptr, boost::shared_ptr, boost::shared_ptr) User::AccountPartyPrefetchPBImpl::prefetch_account_and_party_data(TArray const&) User::UserAccountAdapterPBImpl::load_by_account_number_list(TArray, ForUpdate, bool, bool, bool) User::UserAccountAdapterPBImpl::load_by_account_number(unsigned long long, ForUpdate, bool, bool, bool) User::AccountPBImpl::load_by_account_number(unsigned long long, ForUpdate, bool, bool) User::WebSessionALIImpl::get_user() User::WebSessionALIImpl::on_valid_session(bool) User::WebSessionALIImpl::validate(bool) Rapids::DecoratorRefreshValidSession::refresh() const Rapids::DecoratorRefreshValidSession::decorate(MsgLog2&) const Rapids::DecoratedState::show_page(MsgLog2&) const Riprap::RiprapRapidsGenericFlow::process_states(Riprap::WebAppContextOrnate const&, Riprap::RiprapRapidsGenericFlow::ProcessStates, Riprap::DispatchInterceptorRegistry const&, Rapids::TransitionEdge const*) Riprap::RiprapRapidsGenericFlow::flow_call(Riprap::WebAppContextOrnate const&, Riprap::WebAppReturn const&, String const&, Riprap::DispatchInterceptorRegistry const&) Riprap::call_rapids(Riprap::WebAppContext const&, Riprap::RapidsFlowFactory const&, Riprap::DispatchAction const&, Riprap::WebAppReturn const&, String const&, Riprap::DispatchInterceptorRegistry const&) Riprap::dispatch_loop(Riprap::EPRegistry const&, Riprap::WebAppContext const&, Riprap::DispatchAction&, Riprap::WebAppReturn&, String const&, Riprap::DispatchInterceptorRegistry const&) Riprap::dispatch_wrapper(OutputStream&, Riprap::EPRegistry const&, Riprap::WebAppContext const&, Riprap::WebAppReturn const&, String const&, bool const&, Riprap::DispatchInterceptorRegistry const&) Riprap::entry_point(HTTPInterface&, Riprap::CGIVars&, OutputStream&, String const&, String const&) main
Login to Me Too
1 ACCEPTED SOLUTION

Accepted Solutions
Solved

MTS_Justin
Moderator
Moderator
Hi @3DdFrank

This was an caused by a technical issue on our end, which has since been resolved.

Apologies for any inconvenience caused !

Was my post helpful? If so, please give me a kudos!

View solution in original post

Login to Me Too
3 REPLIES 3
Solved

MTS_Justin
Moderator
Moderator
Hi @3DdFrank

This was an caused by a technical issue on our end, which has since been resolved.

Apologies for any inconvenience caused !

Was my post helpful? If so, please give me a kudos!
Login to Me Too

sourabh250991
Contributor
Contributor

I have also facing this error . Please give us solution asap.

If you want to test . We have test page link :- http://56.octallabs.com/mys/paypal-test/

click on "Make a payment" and you see this error "Cannot connect to db USER_R, pip user_r1_occ_host 1:10.72.108.212:22807: socket.Cannot connect to db USER_R, pip user_r2_occ_host 1:10.72.108.212:22808: socket.".

Login to Me Too

MTS_Justin
Moderator
Moderator
Hello,

This is known issue occurring at the moment in our sandbox environment. We're working on it at the moment.

https://www.paypal-status.com/product/sandbox

Was my post helpful? If so, please give me a kudos!
Login to Me Too

Haven't Found your Answer?

It happens. Hit the "Login to Ask the community" button to create a question for the PayPal community.