tomhardypants

I am using the REST API to upload my reports. I have uploaded all of the resource files in one directory and the report units in another. I am able to upload everything the first time with no problems, and from there I can upload the files numerous times and they work with no problems, but randomly I keep getting this error message: <errorCode>generic.error.message</errorCode><message>No row with the given identifier exists: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoInputControl#0]; nested exception is org.hibernate.UnresolvableObjectException: No row with the given identifier exists: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoInputControl#0] And once it shows up it will always show up whenever I try to upload the report units after that. The strange thing about it is that the file that causes the failure is different every time I run my upload script. Even the file that caused the failure in the previous run will upload on the next run, so it seems completely random. I should also mention, every input control in the report unit uses a local resource but everything else (data files, images, etc...) use a references. Also, if I use the REST API to delete the directory first and then upload (without trying to do an update of the file) it will work every time. I would prefer to not have to delete all my files everytime I use the REST API though because that's kind of ridiculous. Any ideas on how to fix this?

Hopefully this helps someone in the future. If you use this endpoint: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v710/resources-service#Searching_the_Repository it will return the attributes of the file, including the version of the existing file. The problem is that it's a search endpoint so you have to be really specific about the file that you are wanting otherwise it will return a list of files. Use fileUri= and q= options to pinpoint to the exact file you want info for. Note that this endpoint: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v710/resources-service#Viewing_Resource_Details Will return the object that you uploaded. Which, in my experience, if the file is a jrxml file it will return the actual jrxml file and it doesn't actually include the attributes of the file on the server (which is where the version is at).

When trying to update a file resource on the jasper server using the endpoints described here: https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v710/working-file-resources#Updating_File_Resources it requires a "version" of the report in order to update it and if you don't have it you will get an error back. I tried using the "overwrite" option but it still requires the version. Is there a way to get the version of a file on the server through the REST API? If so which endpoint, and where in the returned data can I find it?

I am looking to use the REST v2 API to upload my jrxml files (and their resources) to Jasperserver. (Similar to what is desrcribed here: https://community.jaspersoft.com/wiki/how-use-rest-v2-upload-report-unit-jasperreports-server-multipart-body) However, I'm wondering if there is a way to automatically generate the content described in the output.txt file from that example so I don't have to manually create/update it for every single report. I noticed that when I upload my jrxml files using Jaspersoft studio that it's able to find all the resources and generate these files for the server. Is there a tool provided with jaspersoft to do this? Also, on a related note, is there a tool provided from jaspersoft that can take an entire directory containing jrxml files and upload that structure to jasper server? Or if you have some other method of uploading that works well for you I'd like to hear it. Any help is appreciated.

@sthomas_3 If j_spring_security_check is now the endpoint to use then why does the documentation say that the rest/login endpoint still works? It's even listed on the page that you posted a link to. Is that endpoint now depracated?

I know this is old but it would probably be a good idea to post a link to the resource you're describing. https://community.jaspersoft.com/wiki/getting-started-rest-web-service-api

I'm wondering if there is a way so that when you select a cell (not column) in a table if you can highlight the specific cell you selected. Currently if I click on a cell the entire column is highlighted. I want to be able to highlight the entire column only if the header is selected and only a cell if a cell is selected. How can I do this? I'm using Jaspersoft Studio Pro.