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

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

Symptoms

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

Top > Commerce Director > Online Payments > Transaction Log > #TR_ID
--->8---
Application Error
rep2013-09-04_02-11-36
---8<---

Error details:

/var/log/hspc/rep2013-09-04_02-11-36
--->8---
[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/TransLog.pm line 762.
---8<---

Cause

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.

Resolution

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.

Search Words

Can't use an undefined value as a HASH reference at /usr/lib/perl5/site_perl/5.8.8/HSPC/CCP/TransLog.pm line 762

Application Error

400e18f6ede9f8be5575a475d2d6b0a6 caea8340e2d186a540518d08602aa065 70a5401e8b9354cd1d64d0346f2c4a3e

Email subscription for changes to this article
Save as PDF