You are not logged in.
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
Offline
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
Offline
Manual installation and installed 3.0.5 directly
Thanks & Regards
Nayana
Offline
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
Offline
We re-run the ddl and now it is available. Earlier it may have missed somehow. Thanks.
Thanks & Regards
Nayana
Offline