ReportServer Forum

betotres

Member

Registered: 2020-02-21

Schema-validation

Hello, I'm new to Reporting Service. I'm trying to connect to a SQL Server 2012 database, but after log confirmation this error appears. So the Report does not start.

I modified sql to create a "longvarchar" column, but sql does not support this format.

### DB Config ###
hibernate.dialect: org.hibernate.dialect.SQLServerDialect (OK)
hibernate.connection.driver_class: com.microsoft.sqlserver.jdbc.SQLServerDriver (OK)
hibernate.connection.url: jdbc:sqlserver://localhost:1433 (OK)
hibernate.connection.username: sa
hibernate.connection.password: ***********
hibernate.default_schema:

Connection Test: OK
Schema Version: RS3.0-15
Schema-validation: wrong column type encountered in column [value] in table [RS_AUDIT_LOG_PROPERTY]; found [varchar (Types#VARCHAR)], but expecting [text (Types#LONGVARCHAR)]

Last edited by betotres (2020-02-21 19:32:23)

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Schema-validation

Hi betotres,

how did you perform installation? Manual installation ?
What exact drivers are you using for your SQLServer?

And which reportserver version are you using? rsversion.properties

Regards,
Eduardo