cancel
Showing results for 
Search instead for 
Did you mean: 

Problem while generating an Export DataSource in our Productive BW system

Former Member
0 Kudos

Hi all


We are trying to generate an export data source in our productive system and for any infocube and we are getting the error "SAP System has status 'not modifiable', Choose 'Display Object' or 'Cancel'." please see the following steps to reproduce the error, for ODS's everything it's working just fine

In the attached document, you will see he error

Best Regards,
BW Team

Steps to Reproduce the error

Please follow the next steps in order to reproduce the error:
1. Logon into BW production system
2. Go to TX RSA1
3. Find infocube "XXXX"
4. Right bottom on your mouse, go to "Additional Functions" and then select "Generate Export Data Source"
5. You will get the following error "SAP System has status 'not modifiable', Choose 'Display Object' or 'Cancel'."


The error is only happening with infocubes, for ODS's everything it's working just fine.


We already check several notes and in RSA1 the "Transport Connection" --> "Object Changeability" and everything seems to be OK, we used to do it but "something happened" and we cannot do it anymore

a"

Accepted Solutions (0)

Answers (2)

Answers (2)

RamanKorrapati
Active Contributor
0 Kudos

Hi,

Why your using generate export data source option ?

BW 7.x on wards, we can load data from DSO/Cube to further targets(with in bw) by using transformations and dtp. in such case generate export data source not required.

You can create transformations from your cube to further target.

Create a dtp and load data.

Hope you got my point.

Thanks

Former Member
0 Kudos

Hi Ramanjaneyulu


I got your point but I don't have a clue how to doing this without generating the export datasource, do you have any useful documentation that I may use?


Best regards,

CD

RamanKorrapati
Active Contributor
0 Kudos

Hi Carlos,

You don't need any document.

In 3.x we use generate export data source to load data from one target to another target.

its data mart concept. But bw 7.x there is no data mart concept.

So now you want load data from Cube1 to Cube2.

This will your data flow  Data source---->cube1--->cube2.

Go to your cube2-->rigth click-->create transformations, use source cube as Cube1.

Do the mappings as you need.

Later create dtp at cube2.

Thanks

Former Member
0 Kudos

Hi Ramanjaneyulu


This is working if we want to copy data from cube1 to cube2 within the same system but at least for us it's not working from copy to our productive system to our quality system


Thanks!!!

former_member186399
Active Contributor
0 Kudos

Dear Carlos,

Export datasource on infocube needs to transported from the dev to production system. This is not required incase of DSO as system creates an export datasource by default when the DSO is transported. That's why you are not getting the error in DSO.

You might need to status of the system namespace to modifiable if you want to generate the export datasource in production system

Regards

Gajesh

RamanKorrapati
Active Contributor
0 Kudos

Hi,

if possible can you try to do at dev system. if its works then you can transport your changes to prod.

Mean while please check this note: 1682044 .

Can you activate your cube and later try to generate export data source.

While doing generate export data source is any load happening to same info cube?

Thanks

Former Member
0 Kudos

Hi Ramanjaneyulu

Thanks for your soon response, we are trying to do this in order to copy data from our productive system to our quality system for testing purposes

We have a SAP 730 and SP08 so the note does not apply because we already have it

The problem it's only happening with infocubes and no loads had been executed  in the system during this process; for ODS's we can generate the export datasource without any problem

thanks

Carlos Deciga