if you modify persistence.properties, you modify the ReportServer internal datasource, so if you set DB2 in persistence.properties, ReportServer tries to load its internal database from the DB2 database. If such, it looks for tables such as RS_ACE, etc. So if you plan to use the standard (Bitnami) database, which is MariaDB, pls don't change persistence.properties
For using DB2 as a "normal" datasource, pls just add a datasource and use the "test" button to test it is working. More information here: https://reportserver.net/en/guides/admi … tasources/
Regards,
Eduardo
I don't know what exactly is your "SPEDITION" or your "sapvot" schema, but the schema you are planning to use with ReportServer has to contain the ReportServer tables (RS_ACE for example). Did you import the schemas / ddls for your version?
Pls check here: https://reportserver.net/en/tutorials/i … -practice/ and here: https://reportserver.net/en/tutorials/i … n-windows/ for installation details.
Regards,
Eduardo
do you see the table RS_ACE when connecting to sapvot schema?
what do you get with "select * from RS_ACE"?
Regards,
Eduardo
### DB Config ###
hibernate.dialect: net.datenwerke.rs.utils.hibernate.DB2Dialect (OK)
hibernate.connection.driver_class: com.ibm.db2.jcc.DB2Driver (OK)
hibernate.connection.url: jdbc:db2://172.16.64.124:5912/T00 (OK)
hibernate.connection.username: spedition
hibernate.connection.password: **********
hibernate.default_schema: sapvot
Connection Test: OK
Schema Version: Unknown (DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=SPEDITION.RS_SCHEMAINFO, DRIVER=4.26.14)
Schema-validation: missing table [RS_ACE]
ODBC Connection is working with param "CurrentSchema = sapvot".
Would be great to get help solving that problem.
Many thanks
Harald