Accidentally cleared the Journal Table

[Former Member]

Hi Gurus,

We have this dilemma where in we accidentally cleared the Journal Table under admin consol, loosing all our Journal Id that were created by the client.

Is there a way we can recover those journal templates? The clients are now looking for their journal saved but apparently there is no such record in bpc as well as in table ujj_jrnl.

Appreciate your help regarding recovering lost or cleared journal.

BTW we are in SAP BPC 7.5 NW

Thanks as always,

yajepenati

[Former Member · Accepted solution]

Hi Emmanuel,

Presuming you have no relevant backups you are going to have some difficulty, as this cannot be restored once deleted.

There is 1 way to re-build this table, but it is certainly a workaround:

1. Run a report in EPM that lists all of your journal data (I presume it is in a specific Datasource / AuditTrail)
2. Put all dimensions in the row or column axis and set each dimension to all base members (with 0 suppression turned on)
3. This will retrieve a list of all your journal records (not line items though unfortunately). From here you can re-key your journals (with discussion from the business you can decide how many journals to post)
4. Before posting these journals, copy all data from the journal Datasource into a test Category for backup purposes, then delete all data in the journal Datasource to ensure you don't double-up your data once new journals are posted
5. Post all new journals, then compare with the test Category to ensure all balances reconcile

This will put a journal entry back in the journal table for every journal record, even though it does not match the original set of journals.

Unfortunately this will be the best you can achieve with no backup anywhere.

Tom.

[former_member186338 · Accepted solution]

"re-key your journals" - ups, can take a lot of time

And the result will be absolutely artificial if original journals data overlap...

And if some default.lgf or journal.lgf is working...

To my mind it's better to stay as is - without old journals!

[Former Member · Accepted solution]

Totally agree Vadim, it is not ideal in any way and the presence of journal.lgf would have to be understood first.

However, auditors can be very uncomfortable if there are no actual journals to back up the data in the "journal" datasource. Given the fact that the journals have all disappeared, having something in there that adds back to the journal data can be a more appealing solution than having nothing at all.

Just my experience, and like I said earlier it's not an ideal answer by any means.

[former_member186338 · Accepted solution]

First of all auditors will kill administrators if the system is running without backup

[Former Member]

Hi Vadim and Tom,

Thank you both for your reply. Yes, we have a snapshot of the system, but the problem if we restore that snapshot, all the data entry of the current date will be gone. So the client doesn't want to do a restore.

I actually planned to restore the backup, then export journal, then restore the snapshot of the latest backup then to import journal, but these steps requires a lot of approval process from different department.

So what I did was to retrieve the data audit report based on activity journal, and arrange it like it looks like a journal for the clients reference only. Since the data that were posted won't be deleted even if the journal table was deleted. So we are getting the clients approval if the data audit will suffice for their reference, rather than re creating all the journal that were deleted.

Once again, thank you both for your inputs!

Thanks as always,

yajepenati

[former_member186338]

Just restore from backup!

Vadim