ReportServer Forum

Nayana

Member

Registered: 2018-11-15

RS_AUDIT_LOG_ENTRY & RS_AUDIT_LOG_PROPERTY tables are not available

Both RS_AUDIT_LOG_ENTRY & RS_AUDIT_LOG_PROPERTY tables are not available in reportserver metadata
Metadata is saved in Mariadb
ReportServer Community Edition 3.0.5

Please assist on this.

---

Thanks & Regards
Nayana

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: RS_AUDIT_LOG_ENTRY & RS_AUDIT_LOG_PROPERTY tables are not available

Hi Nayana,

how did you install 3.0.5 community edition? With the bitnami installers or with a manual installation?
And did you install 3.0.5 directly or did you perform an upgrade ?

Regards,
Eduardo

Nayana

Member

Registered: 2018-11-15

Re: RS_AUDIT_LOG_ENTRY & RS_AUDIT_LOG_PROPERTY tables are not available

Manual installation and installed 3.0.5 directly

---

Thanks & Regards
Nayana

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: RS_AUDIT_LOG_ENTRY & RS_AUDIT_LOG_PROPERTY tables are not available

Hi Nayana,

if you perform a manual installation, you executed the DDL scripts manually,  correct? Check the DDL (create) script for your version:

    create table RS_AUDIT_LOG_ENTRY (
        ENTITY_ID bigint not null auto_increment,
        action varchar(64),
        DATE_FIELD datetime,
        user_id bigint,
        ENTITY_VERSION bigint,
        primary key (ENTITY_ID)
    ) CHARACTER SET utf8 COLLATE utf8_bin;

    create table RS_AUDIT_LOG_PROPERTY (
        ENTITY_ID bigint not null auto_increment,
        KEY_FIELD varchar(64) not null,
        value longtext,
        ENTITY_VERSION bigint,
        LOG_ENTRY_ID bigint,
        primary key (ENTITY_ID)
    ) CHARACTER SET utf8 COLLATE utf8_bin;

If you executed this, you should have RS_AUDIT_LOG_ENTRY & RS_AUDIT_LOG_PROPERTY tables.
What do you mean with "are not available in Reportserver metadata"? Do you get an error? what error? What exactly are you trying to do?

Try to create a new dynamic list with query:

 SELECT E.*, P.KEY_FIELD, P.VALUE
FROM RS_AUDIT_LOG_ENTRY E,
RS_AUDIT_LOG_PROPERTY P
WHERE
E.ENTITY_ID = P.LOG_ENTRY_ID

set the datasource to your internal datasource and run the report. Does this work?

Regards,
Eduardo

Nayana

Member

Registered: 2018-11-15

Re: RS_AUDIT_LOG_ENTRY & RS_AUDIT_LOG_PROPERTY tables are not available

We re-run the ddl and now it is available. Earlier it may have missed somehow. Thanks.

---

Thanks & Regards
Nayana