When Oracle Report gets SQL error, all subsequent runs on same server fail
We have a report that always produces a stupid error related to language - the report was written for ENGLISH environment, and we are running in spanish (NLS_LANG="LATIN AMERICAN SPANISH_AMERICA")
The report is not needed, except to use as a way to prove that this problem is consistent: Any little error from a report such as "REP-300: mes no válido" in a query, and from then on, the reports server shows:
Error 500--Internal Server Error |
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:10.5.1 500 Internal Server ErrorThe server encountered an unexpected condition which prevented it from fulfilling the request. |