[IlligealArgumentException: exception parsing filter string]

A couple of our customers are getting this error (See screenshot). When I try to rebuild this reports in the adhoc editor, It seems to work fine. Anybody any idea where this error comes from ? Or where too look ?

 

Greetings,

Peter

 

[Reports giving exception initting query error]

When we save a adhocView, wich is based on another adhocView (via the save as method in the editor), some of our customers are getting a

java.lang.RuntimeException: exception initting query error.

The reports haven't changed in a couple of months... and this is the first time we encountered this kind of behaviour in the total runtime of our application. We are running jasperserver 4.7

 

Greetings,

Peter

[In wich package can I find AbstractJRUIPlugin]

Massimo,

 

Thanks for the answer... apperently my eclipse was kind of confused. After a restart it could find the package.

[In wich package can I find AbstractJRUIPlugin]

Never mind, I referenced the source project for the jasper plugin... and now it works.

[In wich package can I find AbstractJRUIPlugin]

I'm developing a plugin for jasperstudio, i'm using the mongodb plugin as an example.

 

I'm trying implement the Activator class with the AbstractJRUIPlugin. But my eclipse (wich has the jasper plugin installed via the market place) can't seem to resolve it.

 

What should I do here ?

Greetings,

Peter

 

[How to add an fieldprovider to an customer query executer for jasperstudio 5.6]

Apperently I have to create a plugin, but the tutorial on how to do that on http://community.jaspersoft.com/wiki/contributing-jaspersoft-studio-and-building-sources is full of errors. And in the documentation (community or commercial) I can't find anything about this...

Does somebody have an idea ?

 

[How to add an fieldprovider to an customer query executer for jasperstudio 5.6]

Hello,

 

I have created an custom query executer for jasperstudio, but I can't seem to get the fieldprovider to work. I got a class that implements the import com.jaspersoft.studio.data.fields.IFieldsProvider. But I think i have to add it to the jaspereports_extensions.properties as well. The only thing I have in that file is this line:

net.sf.jasperreports.extension.registry.factory.qe=com.jaspersoft.studio.cxs.qe.ConnexysExtensionsRegistryFactory

 

What should I add here to get the Fieldprovider to work, or should I do something else ?

 

Greetings,

Peter

[error when creating a user through the jasper REST api]

When I run the following curl command:

curl -i -u superuser:superuser -X PUT -H "Content-Type:text/xml" -H "Accept:text/xml" -d 'Fozzie123Fozzie Beardeveldb' "http://localhost:8080/jasperserver-pro/rest/user"

 

I get this output:

HTTP/1.1 201 Created

Server: Apache-Coyote/1.1

Cache-Control: private

Expires: Thu, 01 Jan 1970 01:00:00 CET

P3P: CP="ALL"

Set-Cookie: JSESSIONID=1D193052E4313ADA2B66E073304F5756; Path=/jasperserver-pro/; HttpOnly

Content-Type: text/xml;charset=UTF-8

Transfer-Encoding: chunked

Vary: Accept-Encoding

Date: Mon, 02 Sep 2013 12:45:43 GMT

 

 

I'm not sure if jasper also supports json as request, the examples I could find are only with XML. I'm also not sure if you have to give the organization with the username. We are using the pro version, so jasperadmin is linked to an organisation there.

[error when creating a user through the jasper REST api]

It seems that you're descriptor is correct, when I use it at the same url it works. Are you using a PUT request ?

[How can I connect the JasperETL to Oracle database?]

I think you should change the value for connection type from Oracle Sid, to oracle service name, that should do the trick.

[Perform simple SQL Queries / PL-SQL]

You could just use the tOracleInput component and do a "select package.function from dual". As long as the function gives back a single value.

I believe this will also work if your packaged function in Oracle is a pipelined one. Because that kind of is the same as a table.

[No query executer factory registered for the ... language.]

Actually we only added a jar file to the lib folder, with the custom executer classes. and a line in the jasperreports.properties file.

[No query executer factory registered for the ... language.]

It seems like you haven't added a line to your jasperreports.properties file (in the classes directory). It should look something like this:
net.sf.jasperreports.query.executer.factory.CXS_SQL=net.sf.jasperreports.engine.query.JRConnexysJdbcQueryExecuterFactory

where CXS_SQL should be replaced by your own language name.