Broadcast reports fails with HTML format

Bharath Kumar shared this question 1 week ago
In Progress

Hi Team,

We are facing issue with broadcasting reports failing with HTML format. I see the below errors in the logs:

ERROR (ReportDatasetProducer:produceDataset) - Error creating Dataset: java.lang.Exception: No Y-axis fields found. CategoryDataSet requires at least one

java.lang.Exception: No Y-axis fields found. CategoryDataSet requires at least one

at com.hof.mi.export.ReportDatasetProducer.I(ReportDatasetProducer.java:2047)

at com.hof.mi.export.ReportDatasetProducer.produceDataset(ReportDatasetProducer.java:3890)

at com.hof.mi.export.ReportResultBean.renderChart(ReportResultBean.java:5934)

at com.hof.mi.export.HtmlExporter.A(HtmlExporter.java:7361)

at com.hof.mi.export.HtmlExporter.A(HtmlExporter.java:3821)

at com.hof.mi.export.HtmlExporter.A(HtmlExporter.java:3521)

at com.hof.mi.export.HtmlExporter.A(HtmlExporter.java:2965)

at com.hof.mi.export.HtmlExporter.D(HtmlExporter.java:2324)

at com.hof.mi.export.HtmlExporter.C(HtmlExporter.java:1077)

at com.hof.mi.export.HtmlExporter.export(HtmlExporter.java:1026)

at com.hof.mi.export.HtmlExporter.export(HtmlExporter.java:1015)

at com.hof.mi.process.MIReportGeneratorProcess.generateBroadcastReportEmailHtml(MIReportGeneratorProcess.java:15888)

at com.hof.mi.process.ReportBroadcastProcess.A(ReportBroadcastProcess.java:3691)

at com.hof.mi.process.ReportBroadcastProcess.A(ReportBroadcastProcess.java:3600)

at com.hof.mi.process.ReportBroadcastProcess.reportRunThread(ReportBroadcastProcess.java:3447)

at com.hof.mi.util.ReportBroadcastThread.run(ReportBroadcastThread.java:80)

at com.hof.mi.process.ReportBroadcastProcess.A(ReportBroadcastProcess.java:3216)

at com.hof.mi.process.ReportBroadcastProcess.A(ReportBroadcastProcess.java:2975)

at com.hof.mi.process.ReportBroadcastProcess.broadcastReport(ReportBroadcastProcess.java:2113)

at com.hof.mi.servlet.ReportBroadcastTask.runBroadcastTask(ReportBroadcastTask.java:112)

at com.hof.mi.servlet.TaskScheduler$_A.A(TaskScheduler.java:102)

at com.hof.mi.servlet.TaskScheduler$_A.run(TaskScheduler.java:153)

at java.lang.Thread.run(Thread.java:745)

ERROR (TaskScheduler:run) - Error running task: java.lang.NoSuchMethodError: org.jsoup.select.Elements.get(I)Lorg/jsoup/nodes/Element;

java.lang.NoSuchMethodError: org.jsoup.select.Elements.get(I)Lorg/jsoup/nodes/Element;

at com.hof.mi.util.CSSInliner.inlineStyles(CSSInliner.java:58)

at com.hof.mi.process.ReportBroadcastProcess.A(ReportBroadcastProcess.java:3695)

at com.hof.mi.process.ReportBroadcastProcess.A(ReportBroadcastProcess.java:3600)

at com.hof.mi.process.ReportBroadcastProcess.reportRunThread(ReportBroadcastProcess.java:3447)

at com.hof.mi.util.ReportBroadcastThread.run(ReportBroadcastThread.java:80)

at com.hof.mi.process.ReportBroadcastProcess.A(ReportBroadcastProcess.java:3216)

at com.hof.mi.process.ReportBroadcastProcess.A(ReportBroadcastProcess.java:2975)

at com.hof.mi.process.ReportBroadcastProcess.broadcastReport(ReportBroadcastProcess.java:2113)

at com.hof.mi.servlet.ReportBroadcastTask.runBroadcastTask(ReportBroadcastTask.java:112)

at com.hof.mi.servlet.TaskScheduler$_A.A(TaskScheduler.java:102)

at com.hof.mi.servlet.TaskScheduler$_A.run(TaskScheduler.java:153)

at java.lang.Thread.run(Thread.java:745)

ERROR (TaskScheduler:run) - Error running task: java.lang.NoSuchMethodError: org.jsoup.select.Elements.get(I)Lorg/jsoup/nodes/Element;

java.lang.NoSuchMethodError: org.jsoup.select.Elements.get(I)Lorg/jsoup/nodes/Element;

at com.hof.mi.util.CSSInliner.inlineStyles(CSSInliner.java:58)

at com.hof.mi.process.ReportBroadcastProcess.A(ReportBroadcastProcess.java:3695)

at com.hof.mi.process.ReportBroadcastProcess.A(ReportBroadcastProcess.java:3600)

at com.hof.mi.process.ReportBroadcastProcess.reportRunThread(ReportBroadcastProcess.java:3447)

at com.hof.mi.util.ReportBroadcastThread.run(ReportBroadcastThread.java:80)

at com.hof.mi.process.ReportBroadcastProcess.A(ReportBroadcastProcess.java:3216)

at com.hof.mi.process.ReportBroadcastProcess.A(ReportBroadcastProcess.java:2975)

at com.hof.mi.process.ReportBroadcastProcess.broadcastReport(ReportBroadcastProcess.java:2113)

at com.hof.mi.servlet.ReportBroadcastTask.runBroadcastTask(ReportBroadcastTask.java:112)

at com.hof.mi.servlet.TaskScheduler$_A.A(TaskScheduler.java:102)

at com.hof.mi.servlet.TaskScheduler$_A.run(TaskScheduler.java:153)

at java.lang.Thread.run(Thread.java:745)

Any idea on this?

Comments (11)

photo
1

Hi Bharath,

Thanks for reaching us.

I had a quick look at the log snippet you sent us. From the log, I found generic error message for the chart while developing it, and for the scheduler. Nothing about the Broadcast.

Would you mind sending us the full log file. Also tell us the date and time of the issue occurred and the Yellowfin Build.

Please let us if you have any questions.

Regards,

Mahesh

photo
1

Hi Mahesh,

Hereby attaching the logs.

Thanks,

Bharath

Files: Log2.zip
photo
1

Hi Bharath,

Thanks the logs.

I am currently discussing with developer. Can you please let me know the Build of your Yellowfin?

I know you are using 7.3 version, but I need to know the Build as well.

Please let me know if you have any questions.

Regards,

Mahesh

photo
1

Hi Bharath,

Can you please find out if you have 2 versions of jsoup file in the folder <Yellowfin>\appserver\webapps\ROOT\WEB-INF\lib.

At this stage we are thinking that could be the cause of the issue.

Let me know if you have any questions.

Regards,

Mahesh

photo
1

Hi Mahesh ,

Thanks for your response . I am updating this on behalf of Bharath .

I checked with customer and confirmed that there is only one jar file available which is nothing but jsoup-1.8.2.jar .

The build version is 20180108


Regards

Pratiksha

photo
photo
1

Hi Pratiksha,

Thanks for your reply.

Just wondering if you know since when did this issue started as this particular build 20180108 has been released last year.

Does this happen with all the report broadcast in HTML format or just one particular report in HTML format?

Can you create a new report for test and broadcast it as HTML and see if that works?

I believe this might have been working before as we haven't heard of any issues.

We need to know bit more to investigate further.

Does your test system with the same build works ok?

Please provide me bit more insights and let me know if you have any questions.

Regards,

Mahesh

photo
1

Hi Mahesh ,


This issue has started after upgrading to 7.3 version . Prior upgrading it was working fine(Older version was 7.1 Build version 20161021) .This is happening for existing and new reports if Report Type is html .

Tested the issue in below scenarios but it didnot work

1)Created new schedule

2)Imported the same report in another environment and tried to broadcast it but no luck


Let me know if you need more details on this .


Regards

Pratiksha

photo
1

Hi Pratiksha,

Can you please let me know the Build of 7.3 version?

You can it from the info.jsp page. Click here for instructions.

I will test it here to replicate the issue and raise a defect.

Regards,

Mahesh

photo
1

Hi Mahesh ,


The build version of 7.3 is 20180108 .


Regards

Pratiksha

photo
photo
1

Hi Pratiksha,

I have tested Broadcasting report in HTML format and it worked ok. As 7.1 20161021 is bit older, I couldn't find this build for me to install and then upgrade to 7.3 20180108. I will speak to developers and see if I can get a copy of 7.1 20161021 for further investigation.

In the meantime if you find anything new please let me know.

Regards,

Mahesh

photo
1

Hi Mahesh,

Customer did upgrade the BMC Smart Reporting build from 7.1 to 7.3. The upgrade went successful, but Yellowfin version still shows as 7.1.

-Bharath