Error Design Studio - I can not open the DB anymore

[Former Member]

Dear All

I am facing a big issue with Design Studio

I was working on a DB and suddenly I can not see it .

I can open it and see outline , DSs properties but I can not see the preview . I get the error below.

I have no idea what happens - I get no error script problem in the DB - I dunno what it is wrong with it.

I have tried to open the RSTT trace but I see no trace  with LOC_000001.

Thanks in advance for your help . I will appreciate that

regeards

Manu

ERROR

_______________________________________________________________________________________________

Termination message sent INFO Recording RSTT trace with ID "LOC_000001"... com.sap.ip.bi.base.appli [...]

While processing the current request, an exception occurred which could not be handled by the application or the framework.

Log ID:

8f13d621-0fb0-4ce4-9ba0-e9a559973fe4

Failed to process request. Please contact your system administrator.

To facilitate analysis of the problem, keep a copy of this error page.

We are sorry for the inconvenience.

_______________________________________________________________________________________________

[Former Member · Accepted solution]

Also, does a reset of the initial view helps? Insert new?

[Former Member · Accepted solution]

Nothing happened - I have reset all the DSs to initial view 😞

[max_rosn · Accepted solution]

And you also set all DSs to Load in Script = true?

[Former Member]

yes it is "1 1

[Former Member]

Now I get this error and just the first ds is loaded .. I am really lost

Group: DATAPROVIDER

Type: null

Name:

Init parameters:<parameterList>

<param name="LOAD_IN_SCRIPT" value="false"/>

</parameterList>

[max_rosn]

Emanuela,

I think the initial problem still exists. I suspect that one or more of your data sources is corrupt somehow.

The "fix" we did earlier was just to confirm that.

What you need to do now is to locate the faulty data source and maybe delete it and add it again or something like that.

To do this you can set all the data sources to "Load in Script = false", except the one you suspect is defect, and then try to reload the application. Maybe even restart the application.

[Former Member]

Hi Max

yes a DS was corrupted - I have deleted it and create a new DS with 4 DS to test the background loading but I still get the error below and the DS are not loaded

I  do not understand why 😞

thanks for your help

regards

Manu

Group: DATAPROVIDER

Type: null

Name:

Init parameters:<parameterList>

<param name="LOAD_IN_SCRIPT" value="false"/>

</parameterList>

[former_member131154]

Hi Manu,

have you set the Datasources to Load in script = true?

Dirk

[Former Member]

yes all of them but still get the error ...

[Former Member]

I wrote the following code on start up and all the DS are set to load in script but it does not work - no ds is loaded

CROSSTAB_09.showLoadingState("loading...");

CROSSTAB_10.showLoadingState("loading...");

CROSSTAB_11.showLoadingState("loading...");

CROSSTAB_12.showLoadingState("loading...");

CROSSTAB_13.showLoadingState("loading...");

CROSSTAB_14.showLoadingState("loading...");

CROSSTAB_15.showLoadingState("loading...");

CROSSTAB_16.showLoadingState("loading...");

CROSSTAB_17.showLoadingState("loading...");

1. APPLICATION.doBackgroundProcessing();

//APPLICATION.doBackgroundProcessing();

if (DS_COUNTER == 1)

{CROSSTAB_09.hideLoadingState();DS_TABLE1.loadDataSource();}

else if

(DS_COUNTER == 2){CROSSTAB_10.hideLoadingState();DS_TABLE2.loadDataSource();}

else if

(DS_COUNTER == 3){CROSSTAB_11.hideLoadingState();DS_TABLE3.loadDataSource();}

else if

(DS_COUNTER == 4){CROSSTAB_12.hideLoadingState();DS_TABLE4.loadDataSource();}

else if

(DS_COUNTER == 5){CROSSTAB_13.hideLoadingState();DS_TABLE5.loadDataSource();}

else if

(DS_COUNTER == 6){CROSSTAB_14.hideLoadingState();DS_TABLE6.loadDataSource();}

else if

(DS_COUNTER == 7){CROSSTAB_15.hideLoadingState();DS_TABLE10.loadDataSource();}

else if

(DS_COUNTER == 8){CROSSTAB_16.hideLoadingState();DS_TABLE7.loadDataSource();}

else if

(DS_COUNTER == 9){CROSSTAB_17.hideLoadingState();DS_TABLE9.loadDataSource();}

if (DS_COUNTER < 9)

{DS_COUNTER = DS_COUNTER +1;

1. APPLICATION.doBackgroundProcessing();

}

[Former Member]

And what is the default value of DS_COUNTER? Make sure it's 1, then it should work I think

[Former Member]

I get a skript error but I don not know which one - it does not describe it 😞

[Former Member]

HI Max

thanks !!

I set all to true and it is working

you are great 🙂

where can I set correct answer?

cheers

Manu

[max_rosn]

Hi Emanuela,

glad it helped

Now you can at least find the faulty datasource and then delete/readd it. After you've been doing that you should be able to set Load in script to false again, if you want.

Br

Max Rosén

[Former Member]

Hi Max

do you know the coad to load the data source on script one after the other and not at the same time and when a tab in a tabstrip is selected?

that would be great

thanks

Manu

[former_member131154]

Hi Manu,

check this blog DS1.2 - Load Data in sequense - see data dropping in

All the best

Dirk

[Former Member]

Thank you very much Dirk .

Excellent:-)

regards

Manu

[Former Member]

Hi Dirk

I have been trying to do that - 2 questions:

where shall I write the:

APPLICATION.doBackgroundProcessing();

on STart up or "on backgroundprocessing"?

and the if statements ?

if DS_counter =="1"?

additionaly

the code does not accept if I write:

if (DS_COUNTER < 1) I get an error

thanks again 🙂

regards

Manu

[Former Member]

Hi manu,

You should use APPLICATION.doBackgroundProcessing(); where you want the background code to be called. So in your case, place it in your onStartup.

Is your DS_counter a string or an int?

Sjoerd

[Former Member]

Hi Sjord

what do you mean?

it is a variable that I created in the DB.

I need to write"1"  like this - w/o"" -I get an error.

regards

Manu

[max_rosn]

Change type of the variable to Integer

[Former Member]

I did it

I wrote every thing on "start up" It does not work 😞

regards

Manu

[max_rosn]

Hi Emanuela,

if I understand you correctly you cannot see your application at all in Design Studio? But you can see the Outline?

I ran into the same issue when one of my querys was changed in BEx.

Try this:

- Set "Load from script = true" to all your data sources.

- Restart the application and see if it works.

If it works now you probably have to reset the initial view for the faulty data source or delete it and add it again.

[Former Member]

You gave probably done this already, but could you try saving, closing Design Studio and then opening it again? Design Studio gives me some error messages during design time now and then and restarting the application always works for me.

Sjoerd

[Former Member]

Hi Sjoerd

I have already done it . I got the error last nite already :- (

regards

Manu