DXA app is intermittently able to retrieve content -- sometimes it works and sometimes the DXA app throws a 500 error with below exception.

ERROR SqlExceptionHelper - ORA-00904: "BINARYVARI0_"."NAMESPACE_ID": invalid identifier ERROR ODataFunctionProcessorImpl - Unexpected exception when executing a function. javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet


1 Answer 1


This may be a known issue and possibly an upgrade to DXA 2.0 should resolve this intermittent 500 error.

I would recommend getting in touch with the SDL support and get their opinion about it.

background: In one of our project we were receiving quite intermittent 500 Error and it was because of older version of newtonsoft json dll in DXA - and recommendation was to either update the version of that specific dll or upgrade to DXA 2.0

  • It would highly surprise me if the mentioned DB error could be caused by the version of Newtonsoft JSON used by the Web App. Nevertheless, contacting SDL Support sounds like a good advice. Apr 18, 2019 at 17:28
  • 1
    Thank you all for the response. The issue was happening due to some bad storage info in the cd_storage file of the content service. When updated it resolved the issue.
    – user2869
    Apr 22, 2019 at 13:32
  • glad it is resolved! Apr 25, 2019 at 7:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.