Schedule Reports Jobs are failed

book

Article ID: 130167

calendar_today

Updated On:

Products

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS 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. 

<Please see attached file for image>

database error
 

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. 
 

Additional Information

https://www.techcartnow.com/change-database-from-read-only-to-read-write-mode-in-sql-server/
 

Attachments

1558688287228000130167_sktwi1f5rjvs16fiz.png get_app