You are not logged in.
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
Offline
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
Offline
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)
Offline
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
Offline