Crash of scripts

[Monsieur]

Hello,

If i use twice the same script i got an error message:

or

Any idea? I am over using EA memory?

[Geert Bellekens]

It think the script engine somehow looses the connection to the database, possibly because of an error.

Try checking dberror.txt. If you are lucky there's an error in there that says a bit more.

Geert

[Monsieur]

It think the script engine somehow looses the connection to the database, possibly because of an error.

Try checking dberror.txt. If you are lucky there's an error in there that says a bit more.

Geert

Where can i find this little guy?
I didn't found it in C:\Program Files (x86)\Sparx Systems\EA....

[Geert Bellekens]

%appdata%\Sparx Systems\EA

Geert

[Monsieur]

And this is supposed to help :p?

Code: [Select]

23/06/2015 11:21:10
DAO.Database [3014]

Can't open any more tables.

Context:
      SQL: select t1.Name, t1.ea_guid from t_object t1, t_object t2 where t1.ea_guid = t2.PDATA1 and  ( t2.Object_ID IN (1035) )

PS: thank you for this, i didn't know EA logged crash errors.

[Geert Bellekens]

It's better then only "Can't open any more tables" isn't it?

It looks like you are hitting some of the limitations of MS Access.
see here: http://stackoverflow.com/questions/1807934/ms-access-cant-open-any-more-tables
It seems like it might help if you switch to Jet 4 iso 3.5 as apparently that can handle double the amount of table handles.

Geert

[Monsieur]

I am working on a local EAP.... I know eap are just access database.

-But how can i "upgrade" my eap to Jet 4?
-If i move to an SQL database will i have less errors?

M

[Geert Bellekens]

I am working on a local EAP.... I know eap are just access database.

-But how can i "upgrade" my eap to Jet 4?
-If i move to an SQL database will i have less errors?

M

- To upgrade I think you need to make a new model using the jet4 base .eap and then do a model transfer. (I'm not sure, I never needed that)
- I'm pretty sure you will have less errors of this kind of you move to a "real" database.

Geert

[Monsieur]

Don't know how to create a jet4 base .eap.
And did not find it in the help.

Can you give a me short list of "real"s database?

[qwerty]

It is somewhere on Sparx resource pages. There's a recent thread about it,. Likely the Search button will work here.

q.

[Geert Bellekens]

Here's the EABase_Jet4.0
Here's a list of supported dbms's

Geert

[Monsieur]

Thanks for your help. Will look into that and post on forum if works.

 [smiley=tekst-toppie.gif]