alaa.thiab

I am using Jasper 7.1 and am having trouble exporting dashlets to any format. Here are some quick notes: 1) Exporting the master dashboard works fine 2) PhantomJS is configured, so it isnt that. 3) If I access the report directly, run it and export the results, it works fine ,but when I access a dashboards (with multiple reports underneath) and attempt to export a single dashlet's results to any format, the page just redirects to the Input control page, as if i was trying to run a one-time report. In short, referring to the attached. Export via 1 works but via 2 doesnt.

Hi Hozawa Thanks for the response. Can you guide me on where those connections are defined ? In my context.xml, I have three DB connection strings. Two are application related and the third seems to be JasperServer related. Is that where I need to point JasperSoft to a new read/write DB ? <Resource accessToUnderlyingConnectionAllowed="true" auth="Container" driverClassName="net.sourceforge.jtds.jdbc.Driver" factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory" maxActive="100" maxIdle="30" maxWait="10000" name="jdbc/ABC" password="ENC-829b7bbaa1ba780e2c685bf048896ef23dd49b08fa3b0a43eb0466d06e315e42-" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:jtds:sqlserver://10.26.26.23:1433;useLOBs=false;databaseName=vantage;" username="vision" validationQuery="SELECT 1 "/> <Resource accessToUnderlyingConnectionAllowed="true" auth="Container" driverClassName="net.sourceforge.jtds.jdbc.Driver" factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory" maxActive="100" maxIdle="30" maxWait="10000" name="jdbc/XYZ" password="ENC-829b7bbaa1ba780e2c685bf048896ef23dd49b08fa3b0a43eb0466d06e315e42-" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:jtds:sqlserver://10.26.26.23:1433;useLOBs=false;databaseName=vantage;" username="vision" validationQuery="SELECT 1 "/> <Resource accessToUnderlyingConnectionAllowed="true" auth="Container" driverClassName="tibcosoftware.jdbc.sqlserver.SQLServerDriver" factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory" maxActive="100" maxIdle="30" maxWait="10000" name="jdbc/jasperserver" password="ENC-829b7bbaa1ba780e2c685bf048896ef23dd49b08fa3b0a43eb0466d06e315e42-" testOnBorrow="true" type="javax.sql.DataSource" url="jdbc:tibcosoftware:sqlserver://10.26.26.23:1433;databaseName=vantage;SelectMethod=cursor;sendTimestampEscapeAsString=false" username="vision" validationQuery="SELECT 1"/>

Hi, I have setup JasperSoft to run reports off a SQL Server DB (for off-loading production DB). By design, the DB is READ-ONLY as it is built off SQL transaction logs shipping.. Now, when attempting to run a report, I get the below error in the logs: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.jaspersoft.jasperserver.api.logging.access.domain.hibernate.RepoAccessEvent]; uncategorized SQLException for SQL [insert into JIAccessEvent (user_id, event_date, resource_id, updating) values (?, ?, ?, ?)]; SQL state [25000]; error code [3906]; [TIBCO][sqlServer JDBC Driver][sqlServer]Failed to update database "vantage" because the database is read-only.; which suggests that JasperSoft attempts to UPDATE JI* tables. I understand they are for audit and access logging. My question is; how can I disable JasperSoft from writing into those tables so that it runs smoothly off a DB read replica ? Thanks