NetXMS Support Forum

English Support => General Support => Topic started by: Darren Leggett on January 14, 2019, 01:39:55 PM

Title: Installing reporting server on Windows server.
Post by: Darren Leggett on January 14, 2019, 01:39:55 PM
I'm having problems installing the reporting server on a Windows server.  I've tried following the instructions in the manual but the link in step 8. (see below) is no longer valid.

https://git.netxms.org/public/netxms.git/tree/refs/heads/develop:/src/java/nxreporting/sql

Does anyone have an alternate link or an up to date guide that I can follow.

Regards

Darren
Title: Re: Installing reporting server on Windows server.
Post by: Junoonguy on February 06, 2019, 12:04:05 PM
Did you able to resolve the problem ???
Title: Re: Installing reporting server on Windows server.
Post by: Luis Montaño on February 06, 2019, 06:03:45 PM
I think that you can use this link: https://git.netxms.org/public/reporting-server.git/tree/refs/heads/master:/sql?js=1
Title: Re: Installing reporting server on Windows server.
Post by: Darren Leggett on February 08, 2019, 02:09:07 PM
Tried the link https://git.netxms.org/public/reporting-server.git/tree/refs/heads/master:/sql?js=1 but still not able to get the reporting server started.

Really need a clear, step by step instruction guide.
Title: Re: Installing reporting server on Windows server.
Post by: Luis Montaño on February 12, 2019, 05:23:33 PM
Hi,
Recently I have some issues migrating from postgresql to windows server 2012 + sqlserver 2016
I'm attaching my configurations samples.
I also remove "lib" folder (due size of file) but you can restore them if you download reporting server https://netxms.org/download/releases/2.2/2.2.12/netxms-reporting-server-2.2.12.zip
You can copy the folder, change path of logs, modify users and password and should work.
On my case, my instalation path is: C:\NetXMS\Reporting\

Also, here is updated link for sql scrips (you have to execute them before configure reporting server):
https://github.com/netxms/netxms/tree/master/src/java/nxreporting/sql

I had an issue after execute this script:
https://github.com/netxms/netxms/blob/master/src/java/nxreporting/sql/mssql/nxreporting.sql

it says that you should create the sequence:
CREATE SEQUENCE HIBERNATE_SEQUENCE
  INCREMENT BY 1
  MINVALUE 1
  CACHE 20;

it didn't work for me, so I had to execute the next script:
create table hibernate_sequence(
    next_val INTEGER NOT NULL,
PRIMARY KEY(next_val)
);
insert into [dbo].[hibernate_sequence] (next_val) values (3);

that should be enough to make it works

sorry for my english, I speak spanish.
hope this could be helpful