topic Error during creation of external views in Application Development and Automation Discussions

Error during creation of external views

manjunath_b — Mon, 09 Jun 2014 11:19:38 GMT

Hello,

I am trying to create an analytic view modelled like below:

When I do a data preview of the same from the Modeler perspective, it works fine and I can see the data. But I switch to ABAP perspective and consume this Analytic view as an External view and try a data preview, I get an error like below:

Can someone help out as to what could be wrong here.

Thanks and regards,

Manjunath

Re: Error during creation of external views

jasmin_gruschke — Mon, 09 Jun 2014 17:42:13 GMT

Hi Manjunath,
I think this might be related to the ADT installation you are using. You might ask for more information on how to solve the issue with the ADT colleagues in the community: .

Additionally, can you try to create a small report, something like:

data lt_res type standard table of zext_an_view.

select * from zext_an_view into table lt_res.

cl_demo_output=>display_data( lt_res ).

If that works, everything is fine with the external view and the issue is rather related to your IDE.

BTW, are you running a recent version of ADT (see SAP Development Tools for Eclipse for an Eclipse installation + ADT plugins).

Cheers,
Jasmin

Re: Error during creation of external views

manjunath_b — Tue, 10 Jun 2014 03:53:20 GMT

Hello Jasmin,

I tried the above report program on my system and the execution results in a dump with

Category Resource Shortage

Runtime Errors SYSTEM_NO_ROLL

both using ABAP on eclipse and using txn se80 in SAPGui.

Any thoughts on what could be the issue.

Thanks and regards,

Manjunath

Re: Error during creation of external views

jasmin_gruschke — Tue, 10 Jun 2014 06:20:16 GMT

Hi Manjunath,
seems to be a great amount of data... . SYSTEM_NO_ROLL tells you that you're out of memory on your application server.

You can restrict the result set by using SELECT ... UP TO 100 ROWS. Not a solution for an application but it's just a test.

Cheers,
Jasmin

Re: Error during creation of external views

manjunath_b — Tue, 10 Jun 2014 06:27:26 GMT

Thanks a lot. The result is displayed for 100 rows now. So it looks like the external view works fine and it indeed is an issue with IDE.

Will dig a little deeper into the cause now.

Cheers,

Manjunath