Reporting server (Invalid object name 'hibernate_sequence')

Started by Marco Incalcaterra, March 19, 2017, 06:47:31 PM

Previous topic - Next topic

Marco Incalcaterra

Hi,

I've managed to install reporting server to run in Windows environment on MSSQL Server 2016 and AzureSQL. If I try to execute the default report "Alarm Resolution Timer" what I get is this error in the report server log (attached to the post there is the complete log):


20:30:30.089 [quartzScheduler_Worker-1] ERROR o.h.id.enhanced.TableStructure - could not read a hi value
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'hibernate_sequence'.
        at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc4-4.0.jar:na]
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) ~[sqljdbc4-4.0.jar:na]
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404) ~[sqljdbc4-4.0.jar:na]


The only similar error I found is this:

https://www.netxms.org/forum/installation/reporting-server-4315/msg20119/#msg20119

But no useful hints...

Any other suggestions on how to solve?

Regards,
Marco