ExtJS Grid Field failed due to JSON value before space load

Today, there is a wonderful problem, because excle data is not removed before the import Extjs.grid cannot load data.

Troubleshooting Order:

1. First check the console for any errors.

2. Run SQL statements in Oracle to check if SQL is correct

3. Export the JSON data and verify that the JSON data is correct in the online JSON validation.

4. On-line, the day is displayed normal, and the export operation. Suspect recent data error. Add createdate filter conditions, from the day before the day before the reverse check whether the error. Day Data error, the day before yesterday there is no error. Check the day data.

5. Find the day data, check found 5 columns Chinese length is too long, suspect that the data in these columns have special characters, one column after the update. And check that the loading data is incorrect and not found.

6. Exclude those 5 columns, and check the remaining column data, find the field information of one row, with the front space information, remove the former space, ExtJS Grid loading success.

7. It is concluded that any excle information into the database, must be removed before and after the space, so as not to bring unnecessary workload.

ExtJS Grid Field failed due to JSON value before space load