You are not logged in.
Hello, I trying to setup a simple csv list as parameter, but its giving me a strange error.
As datasource i've used CSV List with Text Connector, and put a simple test for months:
month
01
02
...
12
But every time i try to use as parameter, not only this specific list, i performed plenty of tests, its giving me this error:
1) [Guice/NullInjectedIntoNonNullable]: null returned by binding at ManagedQueryFactory.create()
but the 5th parameter of ManagedQuery.<init>(ManagedQuery.java:63) is not @Nullable
at ManagedQueryFactory.create(ManagedQueryFactory.java:1)
at ManagedQuery.<init>(ManagedQuery.java:63)
\_ for 5th parameter
while locating ManagedQuery annotated with @UniqueAnnotations$Internal(value=1)
Learn more:
https://github.com/google/guice/wiki/NU … N_NULLABLE
1 error
======================
Full classname legend:
======================
ManagedQuery: "net.datenwerke.rs.base.service.dbhelper.querybuilder.ManagedQuery"
ManagedQueryFactory: "net.datenwerke.rs.base.service.dbhelper.ManagedQueryFactory"
UniqueAnnotations$Internal: "com.google.inject.internal.UniqueAnnotations$Internal"
========================
End of classname legend:
========================
at com.google.inject.internal.InternalProvisionException.toProvisionException(InternalProvisionException.java:251)
at com.google.inject.internal.InjectorImpl$1.get(InjectorImpl.java:1104)
at com.google.inject.assistedinject.FactoryProvider2.invoke(FactoryProvider2.java:906)
at com.sun.proxy.$Proxy153.create(Unknown Source)
at net.datenwerke.rs.base.service.datasources.table.impl.TableDBDataSource.<init>(TableDBDataSource.java:101)
at net.datenwerke.rs.base.service.datasources.transformers.csv.Csv2TableTransformer.transformResult(Csv2TableTransformer.java:63)
at net.datenwerke.rs.base.service.datasources.transformers.csv.Csv2TableTransformer.transformResult(Csv2TableTransformer.java:1)
at net.datenwerke.rs.base.service.datasources.transformers.csv.Csv2XTransformer.transform(Csv2XTransformer.java:99)
at net.datenwerke.rs.base.service.datasources.transformers.DatasourceTransformationServiceImpl.transform(DatasourceTransformationServiceImpl.java:28)
at net.datenwerke.rs.base.service.reportengines.table.SimpleDataSupplier.getData(SimpleDataSupplier.java:165)
at net.datenwerke.rs.base.service.parameters.datasource.DatasourceParameterServiceImpl.getParameterData(DatasourceParameterServiceImpl.java:158)
... 49 common frames omitted
I using ReportServer 4.6.2 Community, tried to downgrade to 4.6.1 but still gving me the same error.
For now the only way i found to circumvent this is creating a static select, but feels dirty.
Appreciate any help. Thanks.
Offline
Hi fotorious,
I cannot reproduce the problem. Can you pls post some screenshots of your exact datasource configuration? You can use http://imgbb.com for this.
Regards,
Eduardo
Online
Defnitely can, following the image links for datasource config, parameter config and the error:
https://ibb.co/T8FYrLB
https://ibb.co/LnV7JPr
https://ibb.co/BctxqdT
The error happens right after selecting the datasource and after clicking on "Apply".
Don't know if it has any influence, but the reportserver is running from the docker, with a simple self-made Dockerfile I did.
Offline
Hi fotorious,
thanks for the screenshots. We raised RS-8386 for looking into this.
Regards,
Eduardo
Online
Hi fotorious,
thanks for the screenshots. We raised RS-8386 for looking into this.
Regards,
Eduardo
Hi!
I have the same problem as the user who opened the topic.
Is there any news? How can I see the status of RS-8386?
I will be very grateful for the answer!
Offline
Hi kyrylodudnyk,
in our case, it works as expected. Which RS version exactly are you using? Can you pls export your datasource and report (please use one of the DEMO reports or any simple report based on the internal RS database, e.g. select * from RS_USER) so maybe we can reproduce the issue?
Regards,
Eduardo
Online
Hi kyrylodudnyk,
in our case, it works as expected. Which RS version exactly are you using? Can you pls export your datasource and report (please use one of the DEMO reports or any simple report based on the internal RS database, e.g. select * from RS_USER) so maybe we can reproduce the issue?
Regards,
Eduardo
Hello!
In general, we use RS Community Edition, and my problem comes from the "impossibility" of making a dynamic list from a CSV file. When I try to select columns from a CSV file, I get the error below:
Error
The report could not be executed: ProvisionException: Unable to provision, see the following errors: 1) [Guice/NullInjectedIntoNonNullable]: null returned by binding at ManagedQueryFactory.create() but the 5th parameter of ManagedQuery.<init>(ManagedQuery.java:63) is not @Nullable at ManagedQueryFactory.create(ManagedQueryFactory.java:1) at ManagedQuery.<init>(ManagedQuery.java:63) \_ for 5th parameter while locating ManagedQuery annotated with @UniqueAnnotations$Internal(value=1) Learn more: https://github.com/google/guice/wiki/NU … N_NULLABLE 1 error ====================== Full classname legend: ====================== ManagedQuery: "net.datenwerke.rs.base.service.dbhelper.querybuilder.ManagedQuery" ManagedQueryFactory: "net.datenwerke.rs.base.service.dbhelper.ManagedQueryFactory" UniqueAnnotations$Internal: "com.google.inject.internal.UniqueAnnotations$Internal" ======================== End of classname legend: ========================
display error details
This is an example of the simplest data source and a report based on it:
https://drive.google.com/drive/folders/ … sp=sharing
Main Information:
Version:
RS4.6.3-6104 (2024-03-20-14-57-05)
Java version:
Ubuntu OpenJDK 64-Bit Server VM 11.0.22+7-post-Ubuntu-0ubuntu222.04.1 (11)
Java home:
/usr/lib/jvm/java-11-openjdk-amd64
Application server:
Apache Tomcat/9.0.58 (Ubuntu)
Operating system:
Linux 6.1.0-18-amd64 (amd64)
DB Configuration:
hibernate.dialect:
net.datenwerke.rs.utils.hibernate.SQLServer2008Dialect
hibernate.default_schema:
Database name:
Microsoft SQL Server
Database version:
16.00.4131
JDBC driver name:
Microsoft JDBC Driver 12.6 for SQL Server
JDBC driver version:
12.6.1.0
Schema Version:
RS3.0-26
If there is any more information I can provide, please let me know!
Thank you!
Offline
Hi kyrylodudnyk,
thanks for the export files. Unfortunately, everything works as expected in our case. Can you pls try with a clean test RS installation? Maybe something is wrong with your configuration.
Regards,
Eduardo
Online
Hi kyrylodudnyk,
thanks for the export files. Unfortunately, everything works as expected in our case. Can you pls try with a clean test RS installation? Maybe something is wrong with your configuration.
Regards,
Eduardo
About which configuration are you talking about? Configuration from files (https://github.com/infofabrik/reportser … /4.6.1/etc) or application in general?
Offline
Hi kyrylodudnyk,
I mean the application in general. If you test with a clean, freshly installed version and it works, we will know the issue is related to your specific application setup. If it doesn't work with a fresh installation, we can investigate why we can't reproduce the issue, since everything works as expected on our end.
Regards,
Eduardo
Online
Hi kyrylodudnyk,
I mean the application in general. If you test with a clean, freshly installed version and it works, we will know the issue is related to your specific application setup. If it doesn't work with a fresh installation, we can investigate why we can't reproduce the issue, since everything works as expected on our end.
Regards,
Eduardo
Thanks for describing. I will try to reproduce the problem locally on fresh installations and share the results with you.
Offline