Hello All,
I have successfully installed the reporting server, in the report navigator window i can see, "Alarm Resolution Time" sample Report. But when i run it as scheduler, the result is not shown in the Results windows.
I use Netxms Version 2.1-M2 under Ubuntu server and also the reporting server in same server use the same version.
in the output directory i can find the .jrprint file
root@netxms2:/opt/netxms-reporting-server/workspace/output# ls -ltr
total 12
drwxr-xr-x 2 root root 4096 Mar 23 15:54 4916972f-87c7-4a37-af2c-4d8522e9e645
drwxr-xr-x 2 root root 4096 Mar 23 16:08 18b2ec56-cac6-410a-b86e-f64ffe49704d
root@netxms2:/opt/netxms-reporting-server/workspace/output# cd 18b2ec56-cac6-410a-b86e-f64ffe49704d/
root@netxms2:/opt/netxms-reporting-server/workspace/output/18b2ec56-cac6-410a-b86e-f64ffe49704d# ls -ltr
total 588
-rw-r--r-- 1 root root 52816 Mar 22 15:52 5bd571d1-444f-41df-adf2-7f658675d5f0.jrprint
-rw-r--r-- 1 root root 280603 Mar 23 16:08 c2f028b0-e61c-41c1-a45d-10203a0b7f96.jrprint
in the log i found this:
Hibernate: select notificati0_.id as id1_0_, notificati0_.attach_format_code as attach_f2_0_, notificati0_.jobid as jobid3_0_, notificati0_.mail as mail4_0_, notificati0_.report_name as report_n5_0_ from report_notification notificati0_ where notificati0_.jobid=?
Hibernate: select reportresu0_.id as id1_1_, reportresu0_.executionTime as executio2_1_, reportresu0_.jobId as jobId3_1_, reportresu0_.reportId as reportId4_1_, reportresu0_.userId as userId5_1_ from reporting_results reportresu0_ where reportresu0_.reportId=? order by reportresu0_.executionTime desc
When i download the jrprint file locally, i can open it using jasper report
Why the results is not shown in the results window? am i miss some step?
Thank you
Subhan M