Reporting Server - The Result is not shown in Results window console

Started by subhanm, March 23, 2017, 11:25:41 AM

Previous topic - Next topic

subhanm

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

Marco Incalcaterra


voron

Try this (for MYSQL):
CREATE TABLE `hibernate_sequence` (
`next_val` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY(`next_val`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `hibernate_sequence` VALUES (1);

More https://www.netxms.org/forum/oe-oo/reporting-server-2-1-oema-etatam-aam/

Marco Incalcaterra

Quote from: voron on August 18, 2017, 06:10:09 AM
Try this (for MYSQL):
CREATE TABLE `hibernate_sequence` (
`next_val` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY(`next_val`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO `hibernate_sequence` VALUES (1);

More https://www.netxms.org/forum/oe-oo/reporting-server-2-1-oema-etatam-aam/

I'm using SQL server, actually I have a system object of type SEQUENCE_OBJECT that, I guess, has been created by the installer with the purpose of acting as that table. I can try to drop it and create as table to see if it works.

Regards,
Marco.