Views could not be linked together

Ander-Eric Einmann shared this problem 13 hours ago
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

Replies (1)

photo
1

Hi,

Thanks for reaching out.

Here is my testing on this

1. create report in YF with 2 of 3 data source columns


adec917add776cb445657b07cb437c56


2. Exported



21a0d67990e1d0683fc3610769d7351e


3. Import all twice -

ef650a08db2fc249bf70d4265a456797


4. received warning the second time -



21b9b0407c0585e0adfd18959386ec57


Also a view warning... that i had no option to correct.


9b03a83de19fae3a0949fea056176ab5


5. I have 3 reports -


d21a7c32fd9577e368b9786ad708dd8d


6. added column 3 to 1b, exported

e1029905d6512b049dfd0d4755c6448b


7. Restore import on 1b -

44ac06596e580c043ba7cc8de08ac99b


Restore was successful -

c118c510866832baa7c9a6363866b0c2


8 Report runs with a filter error -

baf1e8180d0501a4af5763107fb209a9


Let me know if there's something I'm missing in this replication attempt.

Thanks,

Eric

Leave a Comment
 
Attach a file