on 08-14-2013 10:16 AM
I've built a query on Infoset. On execution it is redirecting to ABAP debugger.
Infoset:
DS1<--inner join-->C01<--inner join-->DS2
CTID is present in all the three infoproviders and is connected; both the joins are inner joins **No other object has joins in infoset- only CTID is connected**
DS1 contains 2 KF (These are the only two KFs being used in Query - Also these key figures are not present in C01 and DS2)
Few characteristics from DS1, C01, DS2 along with the above mentioned KFs are used to build the query.
Some characteristics are present in one infoprovider only and some are present in two infoproviders and some are present in all the three infoproviders.
But only CTID is connected as it is a key.
I want the query to display output as:
common CTIDs (if possible all) and aginst that
some characteristics from any of the three infoproviders and both the KFs from DS1
I'm using CTID of DS1 in Query.
I'm running query through RSRT
BEx analyzer is showing error :
CLI0111E Numeric value out of range SQLState=220 03 row=1 col=9
Error when generating SQL statement
Error reading the data of infoprovider Z****
Error while reading data; navigation is possible
Can someone please help what went wrong. Why the Query is redirecting to ABAP debugger? Why am I getting the above mentioned errors in BEx portal?
Steps taken:
No breakpoints exits - but still tried deactivating and deleting break points
Wizards, need your help to understand this. Please share Solutions/ ideas to resolve this.
Thanks!
Regards,
Asif Akram Mohammed
Hi Asif,
Check any exit variable was used on this bex report. if yes then check for any break points was there. by mistake some one may moved the code with breakpoints, when we excute it hit debug screen.
try to generate thru RSRT also. you may get clue.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Asif,
Please check whether by mistake anyone has created any customer exit variable on that query with single input but has declared it as a range in CMOD or vice versa. Change it so that the variable and COMD code be in sync.
IF this is not the case then try regenerating the query.
Hope this helps.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Asif,
It seems that any of the key figures are calculated as larger than the size defined in data type of the key figure.
Hope it helps
Yasemin.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.