NetXMS Support Forum

Please login or register.

Login with username, password and session length

Author Topic: Installing reporting server on Windows server.  (Read 442 times)

Darren Leggett

  • Newbie
  • *
  • Posts: 8
    • View Profile
Installing reporting server on Windows server.
« 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
Logged

Junoonguy

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: Installing reporting server on Windows server.
« Reply #1 on: February 06, 2019, 12:04:05 pm »
Did you able to resolve the problem ???
Logged

Luis Montaño

  • Newbie
  • *
  • Posts: 29
    • View Profile
Re: Installing reporting server on Windows server.
« Reply #2 on: February 06, 2019, 06:03:45 pm »
Logged

Darren Leggett

  • Newbie
  • *
  • Posts: 8
    • View Profile
Re: Installing reporting server on Windows server.
« Reply #3 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.
Logged

Luis Montaño

  • Newbie
  • *
  • Posts: 29
    • View Profile
Re: Installing reporting server on Windows server.
« Reply #4 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
Logged