Jahia in English > Cannot publish Couldn't...

0 (0 Good)
0 (0 Bad)

Cannot publish Couldn't store job: The table 'JAHIA_QRTZ_JOB_DETAILS' is full

by  prabakarnatesan »  2014/05/13 08:30

Getting the below error message when trying to publish.

Cannot publish Couldn't store job: The table 'JAHIA_QRTZ_JOB_DETAILS' is full

Could you please provide the possible solutions to get rid of the issue at the earliest?

 

Many thanks,

Prabakar

  (prabakarnatesan)

Number of messages  1
Registration date
0 (0 Good)
0 (0 Bad)

Re: Cannot publish Couldn't store job: The table 'JAHIA_QRTZ_JOB_DETAILS' is full

by  shyrkov »  2014/05/13 08:50

Hello Prabakar,

seems your database storage (table space?) has reached its limit.

Please check the settings with your DB administrator.

You could cleanup the table by purging completed background jobs. In the Edit mode's toolbar click on "Background jobs". In that opened window you will find the "Delete all completed" button to cleanup history of the background jobs.

 

Kind regards

Sergiy

Sergiy Shyrkov (shyrkov)

Number of messages  407
Registration date
0 (0 Good)
0 (0 Bad)

Re: Re: Cannot publish Couldn't store job: The table 'JAHIA_QRTZ_JOB_DETAILS' is full

by  Thanks very much, Sergiy »  2014/05/13 09:11

Thanks a lot, Sergiy.
I have deleted the all the completed jobs now as per your advise.
 

Thanks very much, Sergiy
Number of messages  1
Not registered
0 (0 Good)
0 (0 Bad)

DB details/credentials needs to be retrieved

by  DB details/credentials needs to be retrieved »  2014/05/19 11:17

Hi,

  The database table size limits needs to be chenaged.

  Is there any way we can get the Database credentials details shall be retrieved from Jahia config as the third party company who had designed and maintained the application did not provide the DB credentials?

 

Thanks,

Prabakar

DB details/credentials needs to be retrieved
Number of messages  1
Not registered
0 (0 Good)
0 (0 Bad)

Re: DB details/credentials needs to be retrieved

by  shyrkov »  2014/05/19 14:50

Hello Prabakar,

could you, please, provide the exact version of Jahia, you are using, and which application server it is installed on?

 

Kind regards

Sergiy

Sergiy Shyrkov (shyrkov)

Number of messages  407
Registration date
0 (0 Good)
0 (0 Bad)

Re: DB details/credentials needs to be retrieved

by  Re: DB details/credentials needs to be retrieved »  2014/05/20 04:05

We use Jahia 6.

I was trying to check the DB credentials with hibernate configuration which I could not locate.

But found the DB credentials in Tomcat server Context as DataSource Resource.

Your comments on in general for DB configuration would be very helpful and I shall retain in our internal Knowledge Database.

 

Many Thanks,

Prabakar

Re: DB details/credentials needs to be retrieved
Number of messages  1
Not registered
Contact
Share
Feedback

Get in touch

Whether you are a current user or if you are just evaluating Jahia, we are here to help.

Contact us

Share this page