wcbutler

I'll research doing this, if there is an article on the SMTP pooling that would be amazing. Another idea, is it possible to resend on SMTP failure? I see a set of commented out misfire policy settings in quartz.properties

Hello, I have reports written that are emailed to a variety of folks on the campus I work on. They are written so that I have a query that pulls a parameter to grab a group out of the system it's reporting on and it that is used a a drop-down. Another field is an open field to type in the number of days back. Those are then used when scheduling and let me customize reports for a multi-tenancy system to send to a certain liaison. So I have a need to report off the reporting system, and I have a report showing all the email schedules. The one piece of data I cannot find is what is included in those parameters. If there is a field that even says "13 down" on the parameter dropdown, I could easily report off that using a subquery. I see a table called jireportjobparameter I would expect to see the information but it shows the job ID, parameter name, and it does show a parameter_value field but it's just reporting a size (example - (BLOB) 9 bytes). I also see a jireportunitinputcontrol that I'd expect to join to jiinputcontrol. jiinputcontrol does have a control_index but it seems to be 0, 1, or 2 where my parameter list is hundreds of items long so I assume that is the index number of the inputs on the report since I only normally have a few. Just some pointing in the right direction would go far. I'm pretty good at reverse engineering databases (hence why I'm the Jasper reporting guy). Thanks!

Hello all, long time Jaspersoft Studio/server user for my job. My boss has a big push to have reports sent to all liaisons on my campus. As we have stacked up a lot of emails on 7am and 8am on the first of the month we are hitting the Google SMTP relay with a ton of auth requests and losing reports. The team handling the gsuite said we can pay for an alt SMTP process that costs per email. Obviously I could also set up multiple Jasper servers or stagger the delivery time. Is there any way I can have the server auth once for SMTP delivery for a stack of emails? I'm on Server 8.0.0, Here is the error, I sanitized some GUIDS just in case 2023-05-01T07:09:00,369 ERROR SecureExceptionHandlerImpl,JasperServerScheduler_Worker-2:125 - There was an error on the server. Try again or contact site administrators. (Error UID: xxxxxxxxxxxx). 454 4.7.0 Too many login attempts, please try again later. v189-20020xxxxxxxxx.130 - gsmtp org.springframework.mail.MailAuthenticationException: Authentication failed; nested exception is javax.mail.AuthenticationFailedException: 454 4.7.0 Too many login attempts, please try again later. v189-20020xxxxxxxxxx - gsmtp at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailSenderImpl.java:440) at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:361) at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:356) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobMailNotificationImpl.sendMailNotification(ReportExecutionJobMailNotificationImpl.java:141) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendMailNotification(ReportExecutionJob.java:746) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:526) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:219) at org.quartz.core.JobRunShell.run(JobRunShell.java:202) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) Caused by: javax.mail.AuthenticationFailedException: 454 4.7.0 Too many login attempts, please try again later. v189-20020xxxxxxxxxx - gsmtp at com.sun.mail.smtp.SMTPTransport$Authenticator.authenticate(SMTPTransport.java:965) at com.sun.mail.smtp.SMTPTransport.authenticate(SMTPTransport.java:876) at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:780) at javax.mail.Service.connect(Service.java:366) at org.springframework.mail.javamail.JavaMailSenderImpl.connectTransport(JavaMailSenderImpl.java:518) at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailSenderImpl.java:437) ... 8 more

I had a similar error and this fixed my issue: <js-webapp>/WEB-INF/classes/esapi/security-config.properties security.validation.sql.on=true to security.validation.sql.on=false

I have the need to have non-admin users set up scheduled reports and have other non-admins be able to view and edit those. I made a test user and read only access to the report folder and execute only for the rest of the system. With that user I created a scheduled report. I logged out and logged in to a different with the exact same role as this one and I do not see the schedule. My department has a need for the help desk to create a report, and multiple other users who are back-ups to be able to view, create, and modify that. I don't want the user to have edit abilities of params/settings regarding the reports on the server side. I also don't want to have a shared service account. Any help for this would be great, thank you!