Eclipse Community Forums: Jubula » Spontanous error message from Jubula

Help

Home

Home » Archived » Jubula » Spontanous error message from Jubula(Spontanous error message from Jubula)

Show: Today's Messages :: Show Polls :: Message Navigator

Spontanous error message from Jubula [message #1228055]

Mon, 06 January 2014 10:05

Jurjen Hofstra

Messages: 65
Registered: March 2013

Member

Hello people,

It's the first time I post in this forum, so in case I'm doing something wrong, I'm sorry for that.
I have Jubula 7.2 locally installed on a windows 7 machine and a fresh new installation of Jubula 7.2 on a new test server, also windows 7, with Oracle.

Sometimes, while I have Jubula open on my local machine, I got a spontanous error message:

An internal error occurred during: "Cleaning Testresults in Database for Project "Trimergo T2G2"".

Internal Exception: java.sql.SQLException: ORA-01654: unable to extend index TRIMERGO.SYS_IL0000020105C00007$$ by 8 in tablespace SYSTEM

Error Code: 1654
Call: DELETE FROM TESTRESULT WHERE (INTERNAL_TESTRUN_ID = ?)
bind => [1 parameter bound]
Query: DeleteAllQuery(referenceClass=TestResultPO sql="DELETE FROM TESTRESULT WHERE (INTERNAL_TESTRUN_ID = ?)")

I have uploaded a file with a similar error message.
For our main project, the executionlog is 24 MB large.
For now many thanks for your answer!

Jurjen

Report message to a moderator

Re: Spontanous error message from Jubula [message #1228060 is a reply to message #1228055]

Mon, 06 January 2014 10:22

Achim Loerke

Messages: 376
Registered: July 2009
Location: Braunschweig, Germany

Senior Member

Hi Jurjen,

this looks like you run in a resource shortage in the Oracle instance. I guess some of the buffers overflow while deleting the test results.

What actually triggers this is some housekeeping: depending on your configuration test result details are kept for a limited time. Whenever a ITE is started it checks if there are results exceeding this limit and deletes them silently.

Assigning some disk space to the SYSTEM tablespace should fix this.

- Achim

Report message to a moderator

Re: Spontanous error message from Jubula [message #1228108 is a reply to message #1228060]

Mon, 06 January 2014 12:32

Jurjen Hofstra

Messages: 65
Registered: March 2013

Member

Hi Achim,

Thanks for your answer! The system tablespace is indeed 100% in use. I tried to google how to assign more disk space.
I tried: alter database datafile 'DATA1.ORA' autoextend on next 20 M maxsize 1200M;
but this does'nt work. It says nonexistent data file "DATA1.ORA"
How can I retrieve the name of the datafile?
Many thanks!
Jurjen

Report message to a moderator

Re: Spontanous error message from Jubula [message #1228128 is a reply to message #1228108]

Mon, 06 January 2014 13:30

Achim Loerke

Messages: 376
Registered: July 2009
Location: Braunschweig, Germany

Senior Member

Sorry, no idea how to configure an Oracle db. If I had to do it I'd ask our db administrator Wink

- Achim

Report message to a moderator

Re: Spontanous error message from Jubula [message #1228927 is a reply to message #1228128]

Wed, 08 January 2014 11:06

Jurjen Hofstra

Messages: 65
Registered: March 2013

Member

Hi Achim,

I found it: from the oracle command line I typed:
alter database datafile 'c:/full/path/to/system.dbf' resize 1024M;
this worked!

Greetings,

Jurjen

Report message to a moderator