Jump to content

Failure to generate attachment using API while sending email with input controls applied


integrations

Recommended Posts

Hi everyone,

Using the API, I'm trying to schedule a report that has input controls applied to it. However, with this no attachment is generated. Instead, Jasper Server throws an error "JasperReports Server encountered an error while generating this report. Please contact your administrator."

The JSON code generated in the background is as below:

<p>{"baseOutputFilename":"Pipeline_By_Status","outputFormats":</p>{"outputFormat":["PDF"]}<p>,"outputTimeZone":"US/Eastern","outputLocale":"en","source":{"reportUnitURI":"/public/FranConnect/QA/Reports/Pipeline_by_Status","parameters":{"parameterValues":</p>{"dateFrom":["2018-03-19"],"dateTo":["2018-07-18"]}<p>}},"trigger":{"simpleTrigger":{"timezone":"Asia/Calcutta","occurrenceCount":1,"startType":1,"recurrenceInterval":null,"recurrenceIntervalUnit":null,"endDate":null,"startDate":null}},"repositoryDestination":</p>{"overwriteFiles":false,"sequentialFilenames":false,"timestampPattern":"","saveToRepository":false,"folderURI":""}<p>,"mailNotification":{"toAddresses":</p>{"address":["arvind.upadhyay@franconnect.net"]}<p>,"ccAddresses":</p>{"address":[]}<p>,"bccAddresses":</p>{"address":[]}<p>,"subject":"My Mail","messageText":"","resultSendType":"SEND_ATTACHMENT"},"alert":{"toAddresses":{},"jobState":"ALL","includingReportJobInfo":false,"includingStackTrace":false},"label":"Pipeline By StatusSend Email"}</p><p>but in network we are getting below object.<br>{"id":37911,"version":0,"username":"1_DBRAND","label":"Pipeline By StatusSend Email","creationDate":"2018-07-24T18<br>:10:03.972+05:30","trigger":{"simpleTrigger":{"id":37907,"version":0,"timezone":"Asia/Calcutta","startType"<br>:1,"misfireInstruction":0,"occurrenceCount":1}},"source":{"reportUnitURI":"/public/FranConnect/QA/Reports<br>/Pipeline_by_Status","parameters":{"parameterValues":{"dateTo":</p>{"item":["2018-07-18"]}<p>,"dateFrom":{"item"<br>:<span class="error">["2000-02-01"]</span>}}}},"baseOutputFilename":"Pipeline_By_Status","outputLocale":"en","mailNotification"<br>:{"id":37909,"version":0,"toAddresses":</p>{"address":["arvind.upadhyay@franconnect.net"]}<p>,"ccAddresses"<br>:</p>{"address":[]}<p>,"bccAddresses":</p>{"address":[]}<p>,"subject":"1111111111","messageText":"1111111111111","skipEmptyReports"<br>:false,"includingStackTraceWhenJobFails":false,"skipNotificationWhenJobFails":false,"resultSendType"<br>:"SEND_ATTACHMENT"},"alert":{"id":0,"version":-1,"recipient":"OWNER_AND_ADMIN","toAddresses":</p>{"address":[]}<p>,"jobState":"ALL","includingStackTrace":false,"includingReportJobInfo":false},"repositoryDestination"<br>:{"id":37908,"version":0,"folderURI":"","sequentialFilenames":false,"overwriteFiles":false,"timestampPattern"<br>:"","saveToRepository":false,"usingDefaultReportOutputFolderURI":false,"outputFTPInfo":{"userName":"anonymous"<br>,"pbsz":0,"implicit":true,"type":"ftp","port":21}},"outputFormats":{"outputFormat":<span class="error">["PDF"]</span>}}</p><p>Moreover we have checked with jasper server by login SuperUser as tenant User we got below object</p><p>{"id":37981,"version":0,"username":"1_DBRAND","label":"wqwqwq","creationDate":"2018-07-24T18:12:22.087<br>+05:30","trigger":{"simpleTrigger":{"id":37978,"version":0,"timezone":"US/Eastern","startType":1,"misfireInstruction"<br>:0,"occurrenceCount":1}},"source":{"reportUnitURI":"/public/FranConnect/QA/Reports/Pipeline_by_Status"<br>,"parameters":{"parameterValues":</p>{"leadOwner":[],"userdivisionLocal":["1"],"leadStatusID":[],"Source_Details":[],"leadDivisionLocal":["-1"],"dateTo":["2018-07-24"],"userDivID":["-1"],"dateFrom":["2008-04-01"],"rootFolderURL":["/public/FranConnect/QA/"],"UserType":["0"],"Source":[]}<p>}},"baseOutputFilename":"Pipeline_by_Status"<br>,"mailNotification":{"id":0,"version":-1,"toAddresses":</p>{"address":["arvind.upadhyay@franconnect.net"]}<p>,"ccAddresses":</p>{"address":[]}<p>,"bccAddresses":</p>{"address":[]}<p>,"subject":"from jasper","messageText":""<br>,"skipEmptyReports":false,"includingStackTraceWhenJobFails":false,"skipNotificationWhenJobFails":false<br>,"resultSendType":"SEND_ATTACHMENT"},"outputTimeZone":"US/Eastern","repositoryDestination":{"id":37979<br>,"version":-1,"folderURI":"/public/FranConnect/QA/Reports","sequentialFilenames":false,"overwriteFiles"<br>:true,"saveToRepository":false,"usingDefaultReportOutputFolderURI":false,"outputFTPInfo":{"userName"<br>:"anonymous","password":"","pbsz":0,"implicit":true,"type":"ftp","port":21}},"outputFormats":{"outputFormat"<br>:<span class="error">["PDF"]</span>}} : </p>[/code]

 

Any thoughts on how to sort this?

P.S - Works fine from the front-end, but not with the API.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...