"Error loading data" in a table

Grid-View
1

Hi, there.

Suddenly, when I click one specific table of my database, nocodb shows the message “Error loading data”, appearing as the attached image.

image
image863×192 16.3 KB

How can I solve this?

2

If you are self hosting NocoDB on your server - please send error logs from docker. And errors from chrome console (cmd+alt+i or ctrl+alt+i)

3

Thanks a lot for you fast response.

Here is what you requested to me:

Chrome console:

image
image1919×963 53.1 KB

Error logs from my self hosting server:

[Nest] 10 - 10/13/2023, 7:01:23 AM ERROR [i] Cannot read properties of null (reading ‘columns’)
TypeError: Cannot read properties of null (reading ‘columns’)
at s (/usr/src/app/docker/main.js:1:692165)
at /usr/src/app/docker/main.js:1:693601
at processTicksAndRejections (node:internal/process/task_queues:96:5)
at async /usr/src/app/docker/main.js:1:694147
at async s (/usr/src/app/docker/main.js:1:692767)
at async w.getDataList (/usr/src/app/docker/main.js:1:1228700)
at async w.dataList (/usr/src/app/docker/main.js:1:1226894)
at async p.dataList (/usr/src/app/docker/main.js:1:53356)

4

Maybe it’s relevant to know this other error:

When I try to get the swagger:

image

the navigator responses like this:

image
image742×255 21.1 KB

5

Hi @Petrogrado_1917, Can you share the docker version you are using ? Which will help us to debug more easily.

6

We suspect there might be a comma or . in one of your column name. Possible to confirm it ?

Also please reach out in discord - one of us can help.

7

Docker version 20.10.7, build f0df350

8

@Petrogrado_1917 : Sorry for the confusion, NocoDB docker version is what we need. And it’s look like you are using an older version of NocoDB, we always recommends to use the latest version of our docker image.

9

Hi.

I updated to the latest version but still got the same error in the conflicting table:

image
image1088×354 36.1 KB

I also attach the Chrome console output:

image
image1064×358 13.3 KB

Please, help. This table is the core of my nocodb.

Thanks in advance.

10

@Petrogrado_1917 : Can you include the backend error log as well, including the call stack.

11

[Nest] 10 - 10/13/2023, 12:16:42 PM ERROR [GlobalExceptionFilter] Cannot read properties of null (reading ‘columns’)
TypeError: Cannot read properties of null (reading ‘columns’)
at r (/usr/src/app/docker/main.js:2:971090)
at /usr/src/app/docker/main.js:2:972552
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async /usr/src/app/docker/main.js:2:973098
at async r (/usr/src/app/docker/main.js:2:971718)
at async DatasService.getDataList (/usr/src/app/docker/main.js:2:1574486)
at async DatasService.dataList (/usr/src/app/docker/main.js:2:1572660)
at async DataAliasController.dataList (/usr/src/app/docker/main.js:2:361509)

1 Like
12

@Petrogrado_1917 : Thanks for your quick reply. I would like to know few more things,

  1. Do you have a LinkToAnotherRecord column in your table ?
  2. Which column is your display value (primary value) ?
  3. Are you altering the meta db using any external database tools ?
  4. Are you using Redis for caching ?
13
  1. Yes
  2. A SingleLineText column called ‘Nombre y Apellidos’
  3. No. We just were using REST API to fill this table.
  4. No

I’m trying to delete this column but it is not deleted:

image
image1919×1007 137 KB

14

Please try the following image and let me know that it still causing problem or not.

docker run -d -p 8888:8080 nocodb/nocodb-timely:0.202.4-pr-6690-20231014-0527
15

Good morning.

The error still persists.

Any other idea?

Thanks.

16

Can you share the error backend error log with above image.

17

Ok.

By now I give you the Chrome capture after clicking the table with the problem:

image
image1074×554 20.4 KB

Same error, it seems…

18

Please share the backend error log (from docker logs) with following image nocodb/nocodb-timely:0.202.4-pr-6690-20231014-0527

19

[Nest] 9 - 10/16/2023, 7:15:51 AM ERROR [GlobalExceptionFilter] Cannot read properties of null (reading ‘columns’)
TypeError: Cannot read properties of null (reading ‘columns’)
at r (/usr/src/app/docker/main.js:2:971090)
at /usr/src/app/docker/main.js:2:972572
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async /usr/src/app/docker/main.js:2:973118
at async r (/usr/src/app/docker/main.js:2:971718)
at async DatasService.getDataList (/usr/src/app/docker/main.js:2:1574506)
at async DatasService.dataList (/usr/src/app/docker/main.js:2:1572680)
at async DataAliasController.dataList (/usr/src/app/docker/main.js:2:361509)

This table has a Link field to another table that I deleted before. I mean this column persists even after was deleted the linked table and, in fact, I can’t delete it manually in the frontend.

20

Sorry for the delayed reply I will have a look and get back to you soon.