ReportServer Forum

Johann

Member

Registered: 2022-05-30

Clarification on purpose of table `reportserver.rs_hibernate_sequence`

Hi, I am working on duplicating my reportserver database in another server but am facing some data inconsistency issues with this particular table (`reportserver.rs_hibernate_sequence`). May I check what is the purpose of this table and when is it updated?

Thank you!

Regards,
Johann

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Clarification on purpose of table `reportserver.rs_hibernate_sequence`

Hi Johann,

this is the hibernate simulated sequence table. Check https://dzone.com/articles/hibernate-identity-sequence (table (sequence) ) for some details, or please check the hibernate documentation for more information.

Regards,
Eduardo

marcioribeiro1979

Member

Registered: 2023-04-18

Re: Clarification on purpose of table `reportserver.rs_hibernate_sequence`

I see many locks in PostgreSQL database because application keeps updating this table all the time.
Is there a way to replace this rs_hibernate_sequence table to regular sequence in PostgreSQL ?

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Clarification on purpose of table `reportserver.rs_hibernate_sequence`

Hi marcioribeiro1979,

this is currently not supported.

Regards,
Eduardo