Oracle Reports (MOSC)

MOSC Banner

When Oracle Report gets SQL error, all subsequent runs on same server fail

edited Jan 16, 2015 3:18PM in Oracle Reports (MOSC) 3 commentsAnswered

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 Error

The server encountered an unexpected condition which prevented it from fulfilling the request.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center