ReportServer Forum

mquevedob

Member

Registered: 2016-08-29

computed columns not working

Hi

I am trying to create a computed column like this

EXTRACT(EPOCH FROM (response_timestamp - timestamp))

but I get the following error message:

Could not tokenize: EXTRACT(EPOCH FROM (response_timestamp - timestamp)). Problem occured at EXTRACT(EPOCH FROM (response_timestamp - timestamp))

I tried to find the file computedcolumn.cf but I dont have it anywhere.
However I noticed a couple of tables in reportserver database

rs_computed_column
rs_computed_column_a

Do I need to insert the functions here ? should the function name be in expression column?

Thanks in advance

Thomas Davies

datenwerke

Registered: 2016-05-18

Re: computed columns not working

Hi,

the computedcolumn.cf is in the internal filesystem (Administration module) under /etc/dynamiclists.cf. Remember to reload the configuration after changing by using config reload on the terminal.

Cheers,
Thomas

ps. do not try to make any changes on the database level. This will most probably cripple your installation.

mquevedob

Member

Registered: 2016-08-29

Re: computed columns not working

Thanks Thomas,

for some reason I thought that was a file in my disk filesystem.

i just cant figure out how to execute config reload...
is it a bash script somewhere?

Thomas Davies

datenwerke

Registered: 2016-05-18

Re: computed columns not working

in ReportServer you can open a terminal by pressing CTRL+ALT+T. There issue the command.

Cheers,
Thomas