cancel
Showing results for 
Search instead for 
Did you mean: 

Update rule bacame inactive

Former Member
0 Kudos

Hello experts

today morning, i tried to the delta load for sales order and billing data, Update rules became Inactive(Rec colored)for the datasource 2LIS_11_VAITM and 2LIS_13VDITM.

What could be the reason? Any Ideas

Thanks

SP

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

The only reason could be that someone changed the cube.

Open the update rules and check if there is any characteristic not assigned, if yes assign it and acrivate UPR again.

Than reload.

Hope it helps.

Regards

Former Member
0 Kudos

Great PaoLo

Former Member
0 Kudos

I updated The Transfer structure and tried to actived still Updates rules aren't

active Any ideas?

Thanks

SP

Former Member
0 Kudos

Hi SP,

Is the update rule showing Last Changed by "IMPACT"?

Check that all the fields and the mapped in "Update Rules" and activate manually.

You can use the program RSAU_UPDR_REACTIVATE_ALL for activation as well.

Hope this helps...

Thanks,

Amol

Former Member
0 Kudos

Amol,

Who is this Impact?

Amol, I tried to active the cube, its displaying following error in the log:

Table /BIC/DK_0SD_C031 was not activated,

Actually i added 3 fields to this cube and assigned to Organization dimention(/BIC/DK_0SD_C031), now iam unable to active this cube, I checjed in ABAP Analyis editor its saying there is no such a(/BIC/DK_0SD_C031) in the Database.

how to resolve this error?

Thanks

SP

former_member188975
Active Contributor
0 Kudos

Hi,

Did you add the new chars to the dimension table while there was data in the cube? If you are adding to an existing dimension you will need to first delete the data from the cube.

Hope this helps...

Former Member
0 Kudos

Bhanu,

Good morning!! this has been done by my boss, i think he added while there is data in the cube,and he left for vacation and we have several projects pending based on this cube:-( which should be done before yr end.

Before adding tho characteristcs do we delete the whole data from the cube ? or do we delete the data only from that dimension?

He added 3 characteristics to the Organization dimension in the Sales overview cube, from that time onwards when we tried to activate the cube, iam ending with different log messeges.

Table /BIC/DK_0SD_C031 must be created in the database

Adjust table in DB >>>

sql:

CREATE TABLE R3BWQDATA/"/BIC/DK_0SD_C031"

("DIMID" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_0COMP_CODE" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_0PLANT" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_0SALES_GRP" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_0SALES_OFF" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_0SHIP_POINT" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_0SALESEMPLY" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_0SALESDEAL" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_SLS_TER" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_GPO_CODE" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_GPO_STAT" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_0SALES_DIST" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_SLS_TER2" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_PARTFNCT1" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_REP_P3" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_REP_P4" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_PARTFNCTT" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_REP_P5" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_0STOR_LOC" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_GPO_ID" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_REP_PE" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_REP_P1" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_REP_P2" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_REP_PT" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_PROJ_MAN" INTEGER

WITH DEFAULT 0 NOT NULL,

"SID_SAL_ENG" INTEGER

WITH DEFAULT 0 NOT NULL)

/BIC/DK_0SD_C031 in R3BWQDATA type *FILE already exists. MSGID= Jo

b=596572/BWQ22/WP01

DDL time(___1): ........75 milliseconds

The SQL statement was not executed

<b>Table /BIC/DK_0SD_C031 (Error adjusting the database)

Table /BIC/DK_0SD_C031 was not activated</b>

Actually in Dev system, this cube has no problems, but when he transported it to Test system, the problem has occured(Ended with warning code 😎 however he transported it to PRoduction its working fine.

But we need this sales overview cube in TestSystem for testing some other projects, Bhanu do you think can I ask the BASIS guys to transport only the cube without losing the data in Test system data???(but not the data because iam sure we have important )

any ideas??? suggestions,

I dont want to lose any data from Test system sales cube, any suggestions.

Thanks

SP

former_member188975
Active Contributor
0 Kudos

Hi,

Did the cube have data in Dev and Prod? Ideally you need to delete the data in the cube if you are adding more chars to existing dimensions. If you are creating a new dim for the new chars, then no need to delete the data. I wonder if someone did soem adjustments using SE14 (not recommended though)

Do you have all the test data in the PSA (so that you can reconstruct)? If not another idea would be to create a new cube (copy of this one) and transport that...

Former Member
0 Kudos

Bhanu, where can I check in data for this corresponding cube in PSA?

your Second idea:

anyhow the this cube in Dev system is good, so i can make a copy of this Dev cube(lets say Xcubbe) and transport it across to QAS and later we can load all the data from the QAS salescube into this X cube. is the the idea?

Thanks

SP

former_member188975
Active Contributor
0 Kudos

Hi,

You need to find the InfoSource (based on which update rules feed the cube) and then in RSA1 > Modeling > PSA, find this InfoSource and check the requests under it. You will need to see if there are all the requests that are loaded to this cube.

Second idea: What you write is correct. To laod data from the original cube to copy cube you will need to generate the export datasource and then create update rules.

Hope this helps...

Former Member
0 Kudos

Bhanu, I checked them I dont see any requests underthis,:-((

I already created the cube and transported it to (QA)Test system, its active now. now my question is if I do the Generate export datasource, will it make another copy of data or will it just transer all the data in the infocube, because I want the old cube also in Test cube beacause iam just scared.

and also I would like to create 2 infosources under this cube, 2LIS_11_VAITM and 2LIS_13_VDITM, is there a way I can just copy all the update rules from these infosources in a minute orelse do i have to do a manual copy all update rules,

how can i copy an exact copy of this these 2 infosources in short time?

Thanks

SP

former_member188975
Active Contributor
0 Kudos

May be you need to change the date range of display (from the menu Settings > Display Selection for PSA tree).

Anyways as you have created a copy of the cube, generating the export datasource will not create another copy of the cube. It will also not transfer the data. After you do the export datasource you will need to create update rules, and then an InfoPackage under the 8CubeName Infosource (just like is done for ODS objects).

You can copy the update rules from the other InfoSource (2LIS...). No need to create copies of the InfoSources.

Hope this helps...

Former Member
0 Kudos

Bhanu, as u said i selected the PSA i can see all the Data:-),

Iam struck with assigning the DS, which DS i should assign to this IS, id select the i dont find 2LIS_11_VAITM, 2LIS_13_VDITM in the source systems.

Thanks

SP

former_member188975
Active Contributor
0 Kudos

may be here is some confusion here...

"which DS i should assign to this IS"...which IS are you talking about?

Former Member
0 Kudos

Bhanu,

The new cube that came from DEV system is K0SD_C03

The Old cube in Test is K_0SD_C03

I created an exported datasource(8K_0SD_C03) based on the cube from the Test system(i.e K_0SD_C03) could you please tell me the steps now.

How to copy update rules?

Thanks

SP

0 Kudos

hi SP,

to copy update rules you had opened another thread ...

to create export datasource, right click the cube and 'generate export datasource' then do 'replicate datasource' from source system bw myself.

you can find this infosource in rsa1->infosource, application component datamart, try to use binocular to find, the name is 8[infocubename], you may need to first right click root node 'infosource' and 'insert lost node(s)' if the infosource is invisible, you can then create infopackage from that infosource/datasource assigned, and load data.

to fix the cube and update rules inactive, as suggested you can delete data, right click infocube and 'delete data', then change infocube and activate (since the infoobjects has been added and the status just inactive/it has been saved).

then activate the update rules again.

reload data from source system, or from the copied cube if you want still use existing cube (due to perhaps some queries already been created on this cube).

hope this helps.

Former Member
0 Kudos

Thanks Edwin,

Iam posting the complete problem in a new thread

Thanks

SP

Answers (0)