Greetings,
Question: Any ideas on what causes the SyntaxError: Unexpected number in JSON at position error?
This resumes a previous thread with new details. We have been trying to run an SyntaxError. Invalid Character error to ground for weeks. So far, no luck.
This bland error was occurring in Internet Explorer. It occurred across multiple applications, in pages with/without interactive grids, in our development/staging/production environments. I have installed the same applications in multiple XE-based environments, without the problem appearing. We are using APEX 5.1.0.0.0.45 (please do not say "upgrade to 5.1.4" as that is not currently an option. Also, my XE-based labs are all 5.1.0 and they do not exhibit the problem and others have posted that they have the same Invalid Character error in 5.1.4, so that is not inherently the answer.
We increased debug logging to level 9, with no detectable information in the debug log.
What has changed? Today, I installed Chrome to test whether there was any difference. The error described above as SyntaxError. Invalid Character in Internet Explorer changes to SyntaxError: Unexpected number in JSON at position 1 in Chrome. The typical triggers to cause the error are:
- In the IDE, change a complex property (e.g. SQL, PLSQL Code block, CSS In-Line, etc.) and then save. The wait cursor comes up for 30-40 seconds, then the SyntaxError: Unexpected number in JSON at position 1. The page can then be saved successfully.
For example, after editing the SQL behind an interactive grid (SQL Syntax is NOT the issue. We have tested it with SQL as simple as "SELECT * FROM tblSample")
After clicking Save, following edits to any of the complex properties or attributes, described above.
2. In run-time, when attempting to refresh an interactive grid, after opening a modal dialog.
Any thoughts?
Rob