Thread: Receiving java.lang.RuntimeException error.

Hello everyone,

I am part of the IT team for a medium sized company. We use an online based payroll management service called Unifocus. However a lot of times we will receive error messages on login and I am not sure how to combat them. The most recent one is "java.lang.runtimeException: incorrect syntax near ")". All of the user permissions are set up properly(I think) and I am not sure where to go from here. Any ideas or help would be greatly appreciated.


Thanks

John

Hi,

That error appears to be coming from the database engine. If so, there may be character data in some of the fields which it doesn't like (newline characters, "smart" quotes, etc). It's trying to use the field value to build a query, but the illegal characters are resulting in a bad SQL statement. Did someone copy/paste from a web page, email, Word document, or any other rich text document when adding or editing values in the database? See this page for an example of what can happen:

https://blogs.msdn.microsoft.com/old...25-00/?p=19033

Originally Posted by BinaryDigit09

Hi,

That error appears to be coming from the database engine. If so, there may be character data in some of the fields which it doesn't like (newline characters, "smart" quotes, etc). It's trying to use the field value to build a query, but the illegal characters are resulting in a bad SQL statement. Did someone copy/paste from a web page, email, Word document, or any other rich text document when adding or editing values in the database? See this page for an example of what can happen:

https://blogs.msdn.microsoft.com/old...25-00/?p=19033

I don't believe anyone changed anything in any of the files Java downloaded automatically to the PC when he originally logged in. Is there a specific file I should be trying to edit, or perhaps just uninstalling and reinstalling java will fix it? I'm totally lost with this as I am not a programmer.

Originally Posted by trcooke

I'd recommend getting hold of the support team for that Unifocus product. They will likely be able to help you analyse the problem, seeing as it's their application.

I agree with BinaryDigit09 that the root of the problem lies with some mis-formed SQL statement but that's not something you'll easily be able to solve without knowledge of the inner workings of the system.

Thanks for the response. After reaching out to the support team they told me it is a "permissions issue" and that they can't troubleshoot that so it's really been no help what so ever. Any other ideas?

Originally Posted by trcooke

And you're going to accept that as their response? I'd recommend pushing them for better than that.

No, but I am still waiting on a response from the rep.