aamitt06

I have gone through https://community.jaspersoft.com/documentation/jasperreports-server-user-guide/v55/setting-output-options but could not find suitable answer to connect to sftp port.

when we schedule reports there is an output option in which output to ftp server option is there ,but my requirement is to transfer to sftp server

Well I have resolved the issue initially what I was doing is using the command root@ubuntu:pg_dump --username=postgres --host=127.0.0.1 --port=5433 jasperserver > /home/user/JS_55_Backup.sql the problem with it was that there was another pg_dump on linux server which was of higher version and bundled postgresql of JasperServer uses 9.0.4 postgresql , to resolve this issue I gave the path of pg_dump inside jasperserver i.e root@ubuntu:~# /opt/jasperreports-server-cp-5.5.0/postgresql/bin/pg_dump --username=postgresql --host-127.0.0.1 --port=5433 jasperserver > /home/user/JS_55_Backup.sql

According to me this is a version issue but dont know how to resolve this.

Running command pg_dump --username=postgres --host=127.0.0.1 --port=5433 jasperserver > jasperdb.sql getting error pg_dump:column -1 out of range 0..21 pg_dumo:column -1 out of range 0..21 pg_dump: cannot duplicate null pointer. I have used bundled jasperserver database.

For more detail visit http://amitptechnocrat.blogspot.in/2014/10/creating-user-using-jasperserver-rest.html

http://amitptechnocrat.blogspot.in/2014/10/creating-user-using-jasperserver-rest.html

I resolved the issue the mistake i was doing was that in String input = "{"username":"AgentUser22", ... instead of username it should be fullName and the correct fromat of descriptor should be String input = "{"fullName":"AgentUser22","password":"jasperadmi","emailAddress":"aamitt06@gmail.com","tenantid":"Ag","enabled":true, "externallyDefined":false,"roles":[{"name":"ROLE_USER"},{"name":"ROLE_VOUCHER"}]}"; JSONObject jObject = new JSONObject(input); Rest would be the same as above.

After users when I am typing userid that already exists it gives me status 200 that is ok.

I am trying to create user by following JasperServer rest api I am using JasperServer version 5.6.0 ,when I am passing put request with json data I am getting 400 Bad Request error Authenticator.setDefault(new Authenticator() { @Override protected PasswordAuthentication getPasswordAuthentication() { return new PasswordAuthentication("jasperadmin", "jasperadmin".toCharArray()); } }); String input = "{"username":"AgentUser22","password":"jasperadmi","fullname":"Agent User","emailAddress":"aamitt06@gmail.com","enabled":true,"externallyDefined":false,"roles":[{"name":"ROLE_AGENT"}]}"; JSONObject jObject = new JSONObject(input); ClientResponse response = service.path("rest_v2").path("users").path("AgentUser22").type("application/json") .put(ClientResponse.class,jObject);' System.out.println(jObject); if (response.getStatus() != 201) { throw new RuntimeException("Failed : HTTP error code : " + response.getStatus()); }

Please tell how to create Jasper User using rest web service.

Please tell how to create Jasper User using rest web service.

But how jasper server will store users unique id ... Should there be a separate field in login page ?

Please tell me if there is any method through which I can get the users unique id who logged into the Jasper Server, and that id could be used in the report to display only those records matching this id. Is there any parameter which can be referred or any other work around to obtain the logged in user name or any other way to deal with the issue. Thanks in Advance!!

Thanks ernestoo I made changes in server.xml changed the ports and the issue was resolved.

SEVERE: Failed to initialize end point associated with ProtocolHandler ["ajp-apr-8009"] java.lang.Exception: Socket bind failed: [730048] Only one usage of each socket address (protocol/network address/port) is normally permitted. at org.apache.tomcat.util.net.AprEndpoint.bind(AprEndpoint.java:446) at org.apache.tomcat.util.net.AbstractEndpoint.init(AbstractEndpoint.java:610) at org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:429) at org.apache.catalina.connector.Connector.initInternal(Connector.java:981) at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102) at org.apache.catalina.core.StandardService.initInternal(StandardService.java:559) at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102) at org.apache.catalina.core.StandardServer.initInternal(StandardServer.java:814) at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102) at org.apache.catalina.startup.Catalina.load(Catalina.java:640) at org.apache.catalina.startup.Catalina.load(Catalina.java:665) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:281) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:455) Sep 18, 2014 10:52:55 PM org.apache.catalina.core.StandardService initInternal SEVERE: Failed to initialize connector [Connector[AJP/1.3-8009]] org.apache.catalina.LifecycleException: Failed to initialize component [Connector[AJP/1.3-8009]] at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:106) at org.apache.catalina.core.StandardService.initInternal(StandardService.java:559) at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102) at org.apache.catalina.core.StandardServer.initInternal(StandardServer.java:814) at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102) at org.apache.catalina.startup.Catalina.load(Catalina.java:640) at org.apache.catalina.startup.Catalina.load(Catalina.java:665) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.catalina.startup.Bootstrap.load(Bootstrap.java:281) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:455) Caused by: org.apache.catalina.LifecycleException: Protocol handler initialization failed at org.apache.catalina.connector.Connector.initInternal(Connector.java:983) at org.apache.catalina.util.LifecycleBase.init(LifecycleBase.java:102) ... 12 more Caused by: java.lang.Exception: Socket bind failed: [730048] Only one usage of each socket address (protocol/network address/port) is normally permitted. at org.apache.tomcat.util.net.AprEndpoint.bind(AprEndpoint.java:446) at org.apache.tomcat.util.net.AbstractEndpoint.init(AbstractEndpoint.java:610) at org.apache.coyote.AbstractProtocol.init(AbstractProtocol.java:429) at org.apache.catalina.connector.Connector.initInternal(Connector.java:981) ... 13 more

I tried installing JasperReports Server 5.6.0 but it is giving errors on post installation ,If any of you guys are using jasper server 5.6.0 then please guide me too

I have limitation to use community edition is jasper server 5.6.1 community edition ?

/sites/default/files/images/jasperserver(1).jpg

I am using Ireport5.6 for making reports and jasperreports-server community edition 5.5 .In my report there are two parameters I am able to set parameter value in jasperreports-server community edition 4.7 but in version 5.5 parameter option is disabled therefore the report is unable to schedule.

I am able to schedule the report containing parameter on jasperserver community edition 4.7 but I am not able to set parameter value while scheduling report on jasper server 5.5 ?

I resolved the issue by making customized BarRenderer class here is what I did to resolve this: public void customize(JFreeChart chart, JRChart jasperChart) { //Set the Customized Bar Renderer CustomBarRenderer renderer = new CustomBarRenderer(); chart.getCategoryPlot().setRenderer((CategoryItemRenderer) renderer); } And Here is code for customized bar renderer class: public class CustomBarRenderer extends BarRenderer { public CustomBarRenderer(){ // super( } @Override public Paint getItemPaint(int row,int column){ CategoryDataset dataset = getPlot().getDataset(); if(dataset!=null) { Number maximum = DatasetUtilities.findMaximumRangeValue(dataset); Number minimum = DatasetUtilities.findMinimumRangeValue(dataset); double l_value = dataset.getValue(row, column).doubleValue(); if(l_value==(double)minimum) { return Color.RED; } else if(l_value==(double)maximum) { return Color.GREEN; } } return Color.GRAY; } }

Go through this link you will get idea how to create customizer class and integrate it with charts

You should create a barchart customizer class to control width of bar chart and use the setMaximumBarWidth attribute CategoryPlot categoryPlot=chart.getCategoryPlot(); BarRenderer renderer=(BarRenderer)categoryPlot.getRenderer(); renderer.setMaximumBarWidth(.30); //Set maximum width of barchart to 30 percent

Have you set the parameter class of $P{ID_product} to integer ?