• Article for your preferred language does not exist. Below is international version of the article.

Article ID: 6937, created on Nov 25, 2009, last review on Apr 25, 2014

  • Applies to:
  • Business Automation 4.4

Symptoms

  • Provider upgraded PBA-E from 4.3.4 to 4.4.x
  • After upgrade message archive is empty in PBA-E control panel at Top > Communication Director > Message Manager > Message Log

Resolution

Content of the table 'MessageArchive' in PBA-E database is backed up and placed into the table 'MessageArchive_back' during upgrade. You may restore old messages if it is needed. Check whether a server where PBA-E database is installed has enough diskspace before restoring old messages.

Note:
the table 'MessageArchive' also contains invoices sent to customers. If message archive is not restored and customer changes company name and/or address, and resends invoice from Control Panel, then they will receive invoice with new contact data. It is recommended to restore archived messages for at least 3 last months.

PBA-E for Linux:


To view the number of existing messages in archived table run the following command in shell:

perl ~bm/tools/restore_old_messages.pl


You will get number of messages for the periods of 3 months, 6 months and a year.

To restore messages created after the target date, specify the date as the argument in format YYYY-MM-DD:

perl ~bm/tools/restore_old_messages.pl YYYY-MM-DD


To restore all messages, specify ALL as the argument:

perl ~bm/tools/restore_old_messages.pl ALL
 

PBA-E for Windows:


To view the number of existing messages in archive run the following command in 'cmd':

cd c:\Programm Files\Parallels\PBA
perl\bin\perl.exe tools\restore_old_messages.pl


You will get the number of messages for the periods of 3 months, 6 months and a year.

To restore messages created after the target date, specify the date as the script argument in format YYYY-MM-DD:

cd c:\Programm Files\Parallels\PBA
perl\bin\perl.exe tools\restore_old_messages.pl YYYY-MM-DD


To restore all messages, specify ALL as the script argument:

cd c:\Programm Files\Parallels\PBA
perl\bin\perl.exe tools\restore_old_messages.pl ALL

3d55d50f8852f9c7863e871edae687aa 198398b282069eaf2d94a6af87dcb3ff 4ab279b4a01a37a9fdcbcd5333c6c096 caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF