on 05-29-2011 7:38 AM
Hey Experts,
I have a Situation where:-
A key figure was added in 0SD_C03 cube & activated.Later one transformation linked to this Cube throws dump whenever I try to display or change it.The other 5 transformation linked to the same cube are working properly.
Dump:-
Error analysis
Short text of error message:
ATR_NAV_OF_DTA_PRO_NOT_FOUND 0SOLD_TO__0
Long text of error message:
Technical information about the message:
Message class....... "R7"
Number.............. 000
Variable 1.......... "ATR_NAV_OF_DTA_PRO
Variable 2.......... "0SOLD_TO__0DB87SIC
Variable 3.......... " "
Variable 4.......... " "
Troubleshooting so far :-
1) The KEy figure that was added was removed from cube, yet that no change still short dump is thrown upon display or change of transformation.
2) " 0Sold_to" InfoObject analysis was done at RSRV no inconsistencies found there similarly for dependent InfoObject " "0Customer"
PLZ suggest what else I can do to solve this issue.
Thanks
Aman
Hi,
First, if you feel everything is okay and there shouldnt be any issue, try activating the transformation using program RSDG_TRFN_ACTIVATE. If that throws error too, you can use a FM to get last active version. I do not remember exact name, but you may search RSTRANACT*
About the error it seems you loading from SOLD_TO master data attribute in one of the field. Check if that attribute is available in SOLD_TO.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pranth,
Thanks for the quick response.
I am able to activate the transformation from se38 ...but inspite of that when i Display or Change the transformation it throws the same Dump.
&
"0SOLD_TO__0DB87SIC1" does not exits as an attribute under "0SOLD_TO " so shd I add it also 0DB87SlC1does not exits in system...
Are you in development or in test/production system?
Do you have a clue what 0DB87SIC1 is meaning? It is a strange name anyhow.
Can you find it in the generated program?
Is it possible that you have activated this cube again starting with the business content version?
The message indicates something like a navigational attribute from your cube is not found
Edited by: Marco Lamers on May 29, 2011 11:03 AM
Hey Macro
I am in development system.
0SOLD_TO_ODB87SlC1 stand for D&B US 1987 SIC code i got it from here
http://help.sap.com/saphelp_tm70/helpdata/en/bd/7fe8147b12c94ebd13a1309698158c/frameset.htm
I can't find this in the generated program
Also I am not using this navigational attribute in my cube....plus after uncheck 0SOLD_TO related navigation attributes still this error remains whenever i Try to Display or Change Transformation.
is there anything else u suggest that i can check with respect to this attribute?
Thanks
Aman
.
Your cube is activated anyway if i understand you rigth?
One thing you might try is reactivating the cube from the business content
and adding your keyfigures again.
I'm not quite sure if this will work and i don't know how much work it is (depending on the number of changes already made).
You should al least try to save as much of your current logic to the cube as possible.
Is your SD_C03 cube also available in test and/or production?
Another option might be adding an infoobject ODB87SlC1 to 0SOLDto to get into your transformation again.
That is a little bit of work; i would try this one first.
to get to the D&B fields you have to activate this D&B functionality.
Follow this link for info:
http://help.sap.com/saphelp_tm70/helpdata/en/bd/7fe8147b12c94ebd13a1309698158c/frameset.htm
I don't know what is wise.
Did you put a lot of business logic (ABAP, formulas, etc) in your transformation?
If the answer is no i should start with reactivating the 0SD_C03 cube from business content and try to rebuild it.
There are many routines involved in this cube ...rebuilding cube would be like the last option...i made a copy of cube & all the transformation...now i can open the COPIED transformation which was earlier shooting dump...but when it comes to transportating it is shooting a RC 8:-
Rule (target: 0SUBTOT_1S, group: 01 Standard Group): Syntax error in routine
Any idea ..wats wrong I checked the Start ,END routine in transformation it show no Error at syntax or any sort.
your error (Rule) means something with your rule should be wrong. You checked these also?
Another question; you're using transformations in your development system.
Is that also the case in the production system or did you recently change from update rules to transformation?
And another question; what's your source? Is it a DSO, a datasource or another cube?
Yes i have checked the rule aswell it says "no Error"
1) I am using transformation in development system same trasnformation had been transported earlier to production n is working fine there.
2) The case is not so in production system ...i just recently added a key figure in Cube in Development and that resulted in this Transformation Dump.I am able to display or change all transformation linked to this Cube except for 1.And i also require to do map the key figure in the same tranformation that is throwing dump.
3) the flow is like CUBE--InfoSource --Data Source
Hi parth,
I tried at se37 n got ...
Runtime: 7,271,917 Microseconds
Exception CX_RSTRAN_VERSION_NOT_FOUND
Message ID: XT Message number: 465
Message:
Parameter LSM not in version 0014 of tp configuration
Also tried to delete and create transformation .. yet threw same dump again ...it did work after I coped that cube and rest of transformation from original Cube but this time I am not able to transport them...every time i try to transport the copied trasnformation it throws a RC 8
:- Rule (target: 0SUBTOT_1S, group: 01 Standard Group): Syntax error in routine
Inspite no error at transformation routine it throws this error ...can u suggest me anything on that ?
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.