SAP BPC 10.1 restore Journal

[Former Member]

Hi Experts,

I am trying to restore journal. I have followed steps for exporting journal, clear journal and then use restore journal.

Restore journal package executes successfully, it also updated tables UJJ* correctly. But it is not showing any data in Admin console or in backend cube. Is there anything else, I need to execute?

regards,

Sonali

[damovand]

Hello,

Since you are restoring your existing journals I am assuming you are migrating from a different verison of BPC to BPC 10.1.  Please execute the migration program, even if you have done so before do it again.   If you are migrating from BPC 10 to BPC 10.1 then you have to execute the program UJT_MIGRATE_100_TO_101.  We have seen situations when executing the migration program a second time solves some issues with journals and BPF. 

Best Regards,

Leila Lappin

[Former Member]

Hi Leila,

I am not migrating environments. Few journal entries were posted in BPC. I then executed export journal package and exported .jrn file. Then used clear journal and cleared it. Now when I execute restore Journal, it is not restoing it.

regards,

Sonali

[damovand]

Hello, How did you clear the journal tables and what tables?  The UJJ* tables hold the structure for journal templates and the journal ID.  These tables are generated when journal templates and journals are created.  They should not be cleared.

UJJ_JRNTMPL_INFO, UJJ_TMPL_FLDS, UJJ_JRNL, UJJ_JRN_ID_NR

The journal IDs are used to reference journal information from a dynamic table.  As far as I know the export and import of journals affect only the dynamic journal table.  This table name is of the following format:  /1cpmb/<APPSET_PREFIX>/<APPL_PREFIX>JRDT

Please find the name of your journal table by following note 1529062 and then check if that table has anything in it.  If the referential integrity between these tables are broken then there is no easy way to recreated them.

Best Regards,

Leila

[Former Member]

Hi Leila,

To figure out issue, I copied whole environment. now all journals are in in this new environment.

I executed Clear Journal package and now I am not even able to Clear journal. I get error message that journal are locked or posted.

I checked entries in journal id table and it shows all journals having status unposted.

I also checked journal table by following instructions in note specified by you. and I can see journal entries there. Is there any other way of clearing Journal.

regards,

Sonali