Broadcast reports fails with HTML format

Bharath Kumar shared this question 1 month 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 (18)

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

photo
1

Hi Bharath,

Thanks for the information.

If you try to upgrade Yellowfin while the Yellowfin Service is running then even though the upgrade went well, internally all the files might not have updated and this is what probably has happened in your case.

Has the client restarted the Smart Reporting server? After restarting if it still happens then the quickest way to correct is by restoring the configuration database before running the upgrade and then upgrade it correctly. Let me know how was the upgrade done? Did the client Stop Yellowfin Service or Smart Reporting before upgrade has run?

In my testing, I have installed 7.1 and while the Yellowfin service is running, I have tried to upgrade to 7.3, and my Yellowfin showed 7.1 even after upgrade. But once I restarted the Yellowfin Service, it shows me 7.3 and also the HTML broadcast which I created in 7.1 still runs ok after upgrading to 7.3.

Please let me know if you have any questions.

Regards,

Mahesh

photo
1

Hi Mahesh,

Thanks for the update. Yes, we did the service restart after the upgrade and the version still shows as 7.1. The upgrade installer went successful, however we are not sure why the version still shows as 7.1

We have done the upgrade multiple times, the result is the same. Not sure, if the YF upgrade build is not triggered?

The service was kept running while upgrading.

Is there a way to manually deploy upgrade files?

Regards,

Bharath

photo
1

Hi Bharath,

I believe BMC has different process of upgrading Yellowfin (Smart Reporting) and I am not sure about the process.

But while updating the Yellowfin service should be stopped.

You may need to contact internally to find out the process.

But if it is upgraded, you should see 7.3.

Let me know if you have any questions.

Regards,

Mahesh

photo
1

Hi Mahesh,

Can you tell me is there any exporter for html formats. There could be some exporter for the HTML format right?

I wanted to test by replacing this from any working environments.

Regards,

Bharath

photo
1

Hi Bharath,

We have an option to export report as below but not as a HTML report.

/AYOe195VD2L2AAAAAElFTkSuQmCC

Please let me know if you have any other questions.

Regards,

Mahesh

photo
1

Hi Bharath,

Hope you are doing well.

Please let me know if you have any questions on this ticket.

Regards,

Mahesh

photo
1

Hi Mahesh,

We are still trying to figure out how the installer skipped with upgrade. Will keep you posted further.

Regards,

Bharath