Views could not be linked together
Awaiting Reply
Hi,
I exported/imported a report to the same Yellowfin environment twice - creating two new reports with standalone views. I added a new field to one of the reports I imported. The other one I kept the same. After I had overwritten the other report with the version that had a new field included I received the "Error retrieving results" error when I tried to run it. The logs indicate that the Views could not be linked together.
YF:2024-10-17 05:44:55: WARN (MIReportGeneratorProcess) - [15034] [20B808E4] [REPORT_RUN] [1841073] Views could not be linked together<br>YF:2024-10-17 05:44:55:ERROR (MIReportGeneratorProcess) - [15034] [20B808E4] [REPORT_RUN] [1841073] SQL generation failed: java.lang.NullPointerException<br>java.lang.NullPointerException: null<br> at com.hof.mi.process.MIReportGeneratorProcess$_F.A(MIReportGeneratorProcess.java:6113) ~[i4-mi.9.13 (20240906)]<br> at com.hof.mi.process.MIReportGeneratorProcess$_D.D(MIReportGeneratorProcess.java:7739) ~[i4-mi.9.13 (20240906)]<br> at com.hof.mi.process.MIReportGeneratorProcess$_D.G(MIReportGeneratorProcess.java:6507) ~[i4-mi.9.13 (20240906)]<br> at com.hof.mi.process.MIReportGeneratorProcess.A(MIReportGeneratorProcess.java:10666) ~[i4-mi.9.13 (20240906)]<br> at com.hof.mi.process.MIReportGeneratorProcess.A(MIReportGeneratorProcess.java:9681) ~[i4-mi.9.13 (20240906)]<br> at com.hof.mi.process.MIReportGeneratorProcess.generateSql(MIReportGeneratorProcess.java:1351) [i4-mi.9.13 (20240906)]<br> at com.hof.report.result.StandardResultSetGenerator.generateResultSet(StandardResultSetGenerator.java:114) [i4-core.9.13 (20240906)]<br> at com.hof.report.result.StandardResultSetGenerator.generateResultSet(StandardResultSetGenerator.java:57) [i4-core.9.13 (20240906)]<br> at com.hof.mi.process.ReportRunner.J(ReportRunner.java:1160) [i4-mi.9.13 (20240906)]<br> at com.hof.mi.process.ReportRunner.runReport(ReportRunner.java:294) [i4-mi.9.13 (20240906)]<br> at com.hof.mi.util.background.ReportQueueItem.process(ReportQueueItem.java:93) [i4-mi.9.13 (20240906)]<br> at com.hof.mi.util.background.ReportQueueItem.process(ReportQueueItem.java:41) [i4-mi.9.13 (20240906)]<br> at com.hof.mi.util.background.ExecutionQueue$TaskRunner.call(ExecutionQueue.java:488) [i4-mi.9.13 (20240906)]<br> at java.util.concurrent.FutureTask.run(Unknown Source) [?:?]<br> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:?]<br> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:?]<br> at java.lang.Thread.run(Unknown Source) [?:?]
Best regards,
Ander-Eric
Hi,
Thanks for reaching out.
Here is my testing on this
1. create report in YF with 2 of 3 data source columns
2. Exported
3. Import all twice -
4. received warning the second time -
Also a view warning... that i had no option to correct.
5. I have 3 reports -
6. added column 3 to 1b, exported
7. Restore import on 1b -
Restore was successful -
8 Report runs with a filter error -
Let me know if there's something I'm missing in this replication attempt.
Thanks,
Eric
Hi,
Thanks for reaching out.
Here is my testing on this
1. create report in YF with 2 of 3 data source columns
2. Exported
3. Import all twice -
4. received warning the second time -
Also a view warning... that i had no option to correct.
5. I have 3 reports -
6. added column 3 to 1b, exported
7. Restore import on 1b -
Restore was successful -
8 Report runs with a filter error -
Let me know if there's something I'm missing in this replication attempt.
Thanks,
Eric
Replies have been locked on this page!