Schedule Reports Jobs are failed
Article ID: 130167
Updated On:
Products
SUPPORT AUTOMATION- SERVER
CA Service Desk Manager - Unified Self Service
CA Service Desk Manager
CA Service Management - Asset Portfolio Management
CA Service Management - Service Desk Manager
Issue/Introduction
Schedule Jasper reports are failed. While creating new schedule report we find below mentioned error.
"Hibernate option could not insert"
Excerpt from the Jasper Server:
=========================
019-03-22 09:25:31,481 ERROR JDBCExceptionReporter,pool-17-thread-1:101 - [Tibcosoftware][SQLServer JDBC Driver][SQLServer]Failed to update database "jasperserver" because the database is read-only.
2019-03-22 09:25:31,575 ERROR LocalDataSourceJobStore,localhost-startStop-1:3863 - ClusterManager: Error managing cluster: Failure updating scheduler state when checking-in: [Tibcosoftware][SQLServer JDBC Driver][SQLServer]Failed to update database "jasperserver" because the database is read-only.
org.quartz.JobPersistenceException: Failure updating scheduler state when checking-in: [Tibcosoftware][SQLServer JDBC Driver][SQLServer]Failed to update database "jasperserver" because the database is read-only. [See nested exception: java.sql.SQLException: [Tibcosoftware][SQLServer JDBC Driver][SQLServer]Failed to update database "jasperserver" because the database is read-only.]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.clusterCheckIn(JobStoreSupport.java:3393)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3250)
Failed to save scheduled job.
The reason is : Unexpected.error
The full response from the server is:{"message":"Hibernate operation:could not insert:
[com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.persistentreportjobsimpletrigger].uncategorized SQLException for SQL [insert into JIReportjobTrigger.
"Hibernate option could not insert"
Excerpt from the Jasper Server:
=========================
019-03-22 09:25:31,481 ERROR JDBCExceptionReporter,pool-17-thread-1:101 - [Tibcosoftware][SQLServer JDBC Driver][SQLServer]Failed to update database "jasperserver" because the database is read-only.
2019-03-22 09:25:31,575 ERROR LocalDataSourceJobStore,localhost-startStop-1:3863 - ClusterManager: Error managing cluster: Failure updating scheduler state when checking-in: [Tibcosoftware][SQLServer JDBC Driver][SQLServer]Failed to update database "jasperserver" because the database is read-only.
org.quartz.JobPersistenceException: Failure updating scheduler state when checking-in: [Tibcosoftware][SQLServer JDBC Driver][SQLServer]Failed to update database "jasperserver" because the database is read-only. [See nested exception: java.sql.SQLException: [Tibcosoftware][SQLServer JDBC Driver][SQLServer]Failed to update database "jasperserver" because the database is read-only.]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.clusterCheckIn(JobStoreSupport.java:3393)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3250)
Failed to save scheduled job.
The reason is : Unexpected.error
The full response from the server is:{"message":"Hibernate operation:could not insert:
[com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.persistentreportjobsimpletrigger].uncategorized SQLException for SQL [insert into JIReportjobTrigger.
<Please see attached file for image>
Environment
Jaspersoft Server 6.3/6.4
Resolution
# Update Database Properties with Write permission.
# Updated the database password with clear and simple password .
# Recycle Jaspersoft Tomcat Services.
# Updated the database password with clear and simple password .
# Recycle Jaspersoft Tomcat Services.
Additional Information
https://www.techcartnow.com/change-database-from-read-only-to-read-write-mode-in-sql-server/
Attachments
Feedback
Yes
No
Powered by
