#1 2019-08-23 14:11:39

HejaTibor
Member
Registered: 2019-08-23

Metadata datasource in 3.0.8

Hi All,

Is it possible that the metadata datasource doesn't work in 3.0.8?
I've  set everything according to the documentation (https://reportserver.net/en/guides/admi … amic-List/):
1. DB datasource for the ref-table
2. ref-table with the columns: column_name, default_alias, description
3. at the dyn-list definition into the metadata datasource field i selected the datasource for the ref-table
4. the report query return the expected columns
5. the metadata query is simple "SELECT column_name, default_alias, description FROM pte_metadata". pte_metadata is my ref-table, contains the names of the result columns (in column_name), aliases (in default_alias) and descriptions (in description) in each row for each column of the result of the query.

And when I run the query, no aliases, no descriptions.

Did I missed something? I've an 3.0.6 instance of ReportServer, with the same (?) config, which works.

thanks
Tibor

Offline

#2 2019-08-23 14:16:33

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Metadata datasource in 3.0.8

Hi Tibor,

can you please share some screenshots showing the behavior? You can use http://imgbb.com for posting the images.

Regards,
Eduardo

Offline

#3 2019-08-23 15:41:37

HejaTibor
Member
Registered: 2019-08-23

Re: Metadata datasource in 3.0.8

Hi Eduardo,

Thank you for your quick answer.
Here are the screenshots:
https://ibb.co/w0MdxCn
https://ibb.co/9rPLKQH
https://ibb.co/K61NTrh

Of course i tried the metadata query with specifying the fields (select column_name, default_alias, description ...).

The RS is Community Edition, RS3.0.8-6009, the DB is GreenPlum (a PostgreSQL fork), but i tried with PostgreSQL 10 too.

thanks
Tibor

Offline

#4 2019-08-26 06:42:36

HejaTibor
Member
Registered: 2019-08-23

Re: Metadata datasource in 3.0.8

Hi Eduardo,

Solved!
The problem was at the DB side. I put the metadata db to another server, just worked.

Regards
Tibor

Offline

Board footer

Powered by FluxBB