Search Engine: Elastic

Article ID: 118129, created on Oct 23, 2013, last review on May 10, 2014

  • Applies to:
  • Odin Business Automation Standard 4.x


Application error occurs when try to open transition log in status "Error":

Top > Commerce Director > Online Payments > Transaction Log > #TR_ID
Application Error

Error details:

[2013/09/04 02:11:36] [FATAL] [4865] [Error::throw] URI handler (HSPC::CCP::TransLog->setup) error: Can't use an undefined value as a HASH reference at /usr/lib/perl5/site_perl/5.8.8/HSPC/CCP/ line 762.


It is bug for upgrade from 3.3.0-beta to 3.3.0 RTM.

Field 'details' of pp_trans_log has TEXT type but should be BLOB:

mysql> desc pp_trans_log;
| Field         | Type             | Null | Key | Default             | Extra          |
| detailes      | text             | YES  |     | NULL                |                |

So details of transaction is lost sometimes.


For prevent future errors table should be altered:

~# alter table pp_trans_log change detailes detailes blob;

Restore of broken transaction is not possible. Only cleanup details for broken transaction can prevent application error in transaction log. Delete details only for affected details not ALL.

400e18f6ede9f8be5575a475d2d6b0a6 caea8340e2d186a540518d08602aa065 70a5401e8b9354cd1d64d0346f2c4a3e

Email subscription for changes to this article
Save as PDF