500 Internal Server Error when doing a GET /oslc/am/nestedresources/

[didier.pironet]

Hi guys,

Hope this is the right forum for this question.

We have Sparx EA 16.x along with PCS 5.x
DB is Oracle on RHEL.
DB config settings are default ones.

We are developing a tool to interact with Sparx DB through the OSLC API's.
So far so good however now our developers are getting time to time an 500 internal server error when GETting data from /oslc/am/nestedresources/ !?

We suspect Max Simultaneous Queries...

Do you have any hint on the issue here?

Thx,

[qwerty]

Look through this forum and you find that Oracle is a bad choice for use with EA. They use a lot of tiny queries while Oracle is tuned for jackhammer queries.

q.

[didier.pironet]

Look through this forum and you find that Oracle is a bad choice for use with EA. They use a lot of tiny queries while Oracle is tuned for jackhammer queries.

q.

Thx qwerty
I can only concur with that statement.
It is planned to ditch Oracle for another RDBS.
Which Amazon RDS engine is recommended here?

Thx,

[didier.pironet]

Additionally we have the following error message in the development IDE:

OSLC DB query error - select Object_ID as EAID, Object_Type as EAType, Stereotype, Runstate from t_object where ea_guid = '{E9A2736C-637C-40dc-8F40-4D9D4F6BF5B6}'

The guid exists for sure.

While comparing to a 'standard' SQL query, the major difference is Object_Type AS CLASSTYPE where in the OSLC API call it is Object_Type as EAType

Any hint and can this be the root cause of the 500 ISE?

Thx,

[Geert Bellekens]

Look through this forum and you find that Oracle is a bad choice for use with EA. They use a lot of tiny queries while Oracle is tuned for jackhammer queries.

q.

Thx qwerty
I can only concur with that statement.
It is planned to ditch Oracle for another RDBS.
Which Amazon RDS engine is recommended here?

Thx,

MS SQL Server works just fine (and it used by 95% of my clients)
I've heard great things about MySQL as well, but I have limited experience with that one.
Basically anything but Oracle works.

Geert

[Geert Bellekens]

Additionally we have the following error message in the development IDE:

OSLC DB query error - select Object_ID as EAID, Object_Type as EAType, Stereotype, Runstate from t_object where ea_guid = '{E9A2736C-637C-40dc-8F40-4D9D4F6BF5B6}'

The guid exists for sure.

While comparing to a 'standard' SQL query, the major difference is Object_Type AS CLASSTYPE where in the OSLC API call it is Object_Type as EAType

Any hint and can this be the root cause of the 500 ISE?

Thx,

There's absolutely no reason this query is the source of the problem.
I'm guessing there is another bug somewhere in the processing of this query, and the exception throws the query out as additional context.

Geert

[qwerty]

Additionally we have the following error message in the development IDE:

OSLC DB query error - select Object_ID as EAID, Object_Type as EAType, Stereotype, Runstate from t_object where ea_guid = '{E9A2736C-637C-40dc-8F40-4D9D4F6BF5B6}'

I don't have any idea about the error message. But you could try running that query from the EA SQL scratchpad and see what happens.

q.