Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SyntaxError: Unexpected number in JSON at position 1

ToolTimeTaborFeb 7 2018 — edited Feb 8 2018

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:

  1. 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")

pastedImage_4.png

After clicking Save, following edits to any of the complex properties or attributes, described above.

pastedImage_5.png

2. In run-time, when attempting to refresh an interactive grid, after opening a modal dialog.

pastedImage_6.png

Any thoughts?

Rob

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 8 2018
Added on Feb 7 2018
1 comment
4,624 views