cancel
Showing results for 
Search instead for 
Did you mean: 

Query built on Infoset is redirecting to ABAP debugger

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

RamanKorrapati
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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.

yasemin_kilinc
Active Contributor
0 Kudos

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.