ReportServer Forum

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

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

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

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