Error on Adding 2 dimension of existing Application

[former_member541910]

Hi Expert,

I have a critical problem on developing my SAP BPC 7.0, the client want to add 2 dimension on my running application,

but my problem is while adding 2 dimension an error occur saying "THIS APPLICATION HAS THE JOURNAL. YOU CANNOT MODIFY THE APPLICATION STRUCTURE" then i delete all the journal through "MANAGE JOURNAL". and then try to modify again the application but same error again.

Could someone please please help me on this situation?

Thanks in advance, so much appreciated for your help.

Regards,

ZubZero

[Former Member · Accepted solution]

Hi,

Go to the application and then journals and then click on clear journal table.

Hope this helps.

[former_member541910 · Accepted solution]

Hi,

I already did that, but it didn't work.

Regards,

ZubZero

[Former Member · Accepted solution]

Hi,

Please check the jrn tables in the SQL management studio. There might be some entry for your application. Please delete those entries and then try again.

Hope this helps.

[former_member541910 · Accepted solution]

Hi,

i'm already in tbljournal but how can i see if there are entries on my application? can you please help me on step by step on how to search if there are entries on my application.hope you spare me on this.

Thanks and Best Regards,

ZubZero

[Former Member · Accepted solution]

Hi,

Close all the BPC applications. Go to SQL Management Studio. Go to tblApp under your appset. You will see that journal field is 1 for your application. Please change it to 0. Then login to BPC admin and try to process your application.

Hope this helps.

[former_member541910 · Accepted solution]

Hi Nilanjan,

Thank you very much for your help. I owe you one. ^_

Best Regards,

ZubZero

[former_member541910]

Hi nilanjan,

here is the step by step i did to go to the table of journal

1st > SQL manager studio (server)

2nd > i select the corresponding application set

3rd > i select the table (folder)

4th > the i select the "dbo.jrnLegalApp (LegalApp is the name of my application)

5th > i right click it and then select "edit 200 row"

when i saw the table it has a value of "Null" on all the column.

did I do it correction?

Thanks and Best Regards,

ZubZero