ReportServer Forum

unsi_2

Member

Registered: 2020-06-24

error when using _rs_temp tables ( csv datasources, birt...)

hi

we get error when trying to use _rs_temp tables ( csv datasources, birt...) in parameters for instance

this is the error:
net.datenwerke.gxtdto.client.servercommunication.exceptions.NonFatalException: The report could not be executed: NullPointerException: <br>    at net.datenwerke.rs.base.server.table.TableReportUtilityServiceImpl.getReturnedColumns(TableReportUtilityServiceImpl.java:295)<br>    at com.google.inject.persist.jpa.JpaLocalTxnInterceptor.invoke(JpaLocalTxnInterceptor.java:64)<br>    at ..

is some kind of memory issue? or related to the internal database?

kind regards

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: error when using _rs_temp tables ( csv datasources, birt...)

Hi unsi_2,

what exactly do you mean by "when trying to use _rs_temp tables ( csv datasources, birt...) in parameters for instance", can you pls post some screenshots?

Also pls post the complete error message and the following screenshot: administration -> system consoles -> general info

You can use http://imgbb.com for the images.

Regards,
Eduardo

unsi_2

Member

Registered: 2020-06-24

Re: error when using _rs_temp tables ( csv datasources, birt...)

yes, when trying to use a csv datasource for instance,

then queries have to use something like select * from _rs_Temp_table
we get a nullpointer exception.

*****
we have found the issue, a missing datasource name in /fileserver/etc/datasources/internaldb.cf

thanks

Last edited by unsi_2 (2023-06-28 11:37:40)

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: error when using _rs_temp tables ( csv datasources, birt...)

Hi unsi_2,

pls never use the _RS_TEMP_TABLE directly in your query wrapper.

You should use something similar to:
SELECT * FROM $!{_RS_TMP_TABLENAME}

as explained here:
https://reportserver.net/en/guides/admi … tasources/

4.18.2. Configuration at the Object

Regarding the "no internal database found" error, yes, pls configure your internal db in your internaldb.cf configuration file: https://github.com/infofabrik/reportser … ernaldb.cf

Regards,
Eduardo