NetXMS Support Forum

Hi radw,
thanks for ideas. But of course I executed it as root with proper environment variables and rights.

Hello all,
could you kindly help me with understanding on why Reporting Server is not starting on my server ...

Configuration:

QuoteLinux server:  cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.1 (Maipo)

NetXMS version 2.0.4 compiled with next configuration:

QuoteCPPFLAGS=-I/usr/include/oracle/11.2/client64/ LDFLAGS=-L/usr/lib/oracle/11.2/client64/lib ./configure --with-agent --with-oracle --with-mysql --with-client --with-server --enable-unicode -prefix=/usr/local/netxms --exec-prefix=/usr/local/netxms --disable-ldap --disable-ipv6

/etc/netxmsd.conf

QuoteLogFile = /usr/local/netxms/log/netxms.log
#DBDriver = sqlite.ddr
#DBName = /usr/local/netxms/database/netxms_db
DBDriver = mysql.ddr
DBServer = localhost
DBName = <DBNAME_HIDDEN>
DBUser = netxms
DBPassword = <PWD_HIDDEN>
LogFailedSQLQueries = yes
EnableReportingServer = 1
ReportingServerPort = 4710
ReportingServerHostname = localhost

I have 2 issues:
1. When I'm enabling Reporting Server and restarting netxms server, port is still not listened:

Quote/usr/local/netxms/bin/nxdbmgr set EnableReportingServer 1
/etc/init.d/netxmsd stop
/etc/init.d/netxmsd start
netstat -an | grep 4710
NOTHING

2. When I'm trying to start netxms-reporting-server, some errors thrown on the screen which I'm not able to overcome:
conf/nxreporting.xml

Quote<config>
  <workspace>/usr/local/netxms/reporting/workspace</workspace>
    <netxmsdConfig>/etc/netxmsd.conf</netxmsdConfig>
</config>

Starting server:
java -jar ./reporting-server-2.0.4.jar

Quote...........
Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.sql.DataSource]: Factory method 'dataSource' threw exception; nested exception is java.lang.NullPointerException
        at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:189)
        at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:588)
        ... 40 more
Caused by: java.lang.NullPointerException
        at com.radensolutions.reporting.dao.DaoContextConfig.dataSource(DaoContextConfig.java:42)
        at com.radensolutions.reporting.dao.DaoContextConfig$$EnhancerBySpringCGLIB$$28d50b10.CGLIB$dataSource$1(<generated>)
........

I also tried with another command:
java -cp /usr/local/netxms/reporting/lib/\*.jar:/usr/local/netxms/reporting/conf:/usr/local/netxms/reporting/reporting-server-2.0.4.jar com.radensolutions.reporting.Launcher

But results are still the same. I tried to read all the articles posted on this forum but was not able to find such issue.

Can you give me an example of use this Transformation Script.
I have some value recieved by DCI and need to devide this value by 48.

[recieved value] / 48 = [new value]

Thank You for your help.