Article ID: 126602, created on Aug 18, 2015, last review on Jun 27, 2016

  • Applies to:
  • Odin Business Automation Standard 4.5

Symptoms

When clicking on Payment ID on a transaction screen Top > Commerce Director > Online Payments > Transaction Log > Transaction #N the error

The requested object was not found

appears.

The document that should have been paid with the Online Payment in question stays in Open status.

A lot of errors like the following one can be found in /var/log/hspc/hspc.log:

[2015/04/30 12:18:36] [INFO] [31822] [HSPC::MT::PP::PluginEngine::OP::_save_transact_payment] _save_transact_payment()::Unable to save payment, internal billing error: DBD::mysql::st execute failed: Lock wait timeout exceeded; try restarting transaction at /usr/lib/perl5/site_perl/5.8.8/HSPC/WebDB.pm line 238.
[2015/04/30 12:22:01] [INFO] [31822] [HSPC::MT::PP::PluginEngine::OP::_save_transact_payment] _save_transact_payment()::Unable to save payment, internal billing error: DBD::mysql::st execute failed: Deadlock found when trying to get lock; try restarting transaction at /usr/lib/perl5/site_perl/5.8.8/HSPC/WebDB.pm line 238.

Cause

Such behavior was classified as the software issue PBAS-29793 that was fixed in OBAS 4.5.5.

Resolution

To resolve the issue, please upgrade to 4.5.5 as described in How to upgrade OBAS system to the latest available version.

Hotfix for OBAS version 4.5.3

Please download and install the hotfix for OBAS 4.5.3 32-bit OS by running the following commands:

# rpm -Uvh hspc-pp-4.5.3-54.swsoft.i386.rpm
# service hspcd restart

Warning: Restart of the hspcd service will cause OBAS downtime for about 10-60 seconds.

Search Words

_save_transact_payment()

Unable to save payment, internal billing error

NA

DBD::mysql::st execute failed: Lock wait timeout exceeded; try restarting transaction at /usr/lib/perl5/site_perl/5.8.8/HSPC/WebDB.pm line 238

order always is open

Renewal order

624ca542e40215e6f1d39170d8e7ec75 caea8340e2d186a540518d08602aa065 400e18f6ede9f8be5575a475d2d6b0a6 70a5401e8b9354cd1d64d0346f2c4a3e

Email subscription for changes to this article
Save as PDF