Data table is not accessible due to: Unable to cast object of type 'System.

[Boray]

Whenever I try to regenerate one of my tables, I keep getting same error across all of my apps: Data table 'PPC Engagement Manager' is not accessible due to: Unable to cast object of type 'System.Byte[]' to type 'System.String'..

 

[WillowMobileSys]

it would seem that you are attempting to connect to a database and the datatype you have set to the database columns are not compatible with the AppSheet datatype configured in the app.  For example "BYTE[]", which most databases support, does not directly translate to any AppSheet datatype. 

If you are attempting to use that datatype for LIST type AppSheet columns, then you would want to change those database columns to a simple string/text type column.

I hope this helps!

[muhammadjavohir]

The same happened with me too. It was related to my read-only table.

[Boray]

YES! All of them are read-only tables. Is this considered a kind of bug? How can we fix it without making them writable?

[muhammadjavohir]

I suppose it should be a bug or so. I also had to make them writable and disabled editable_if conditions for each column.

[khiemtg]

same for me, this issue happened with Appsheet database, Postgres database on my side

[Boray · Accepted solution]

I changed the table settings from read-only to editable and it fixed the issue, but there must be a better way to solve this

[Boray]

I made all of the tables editable but I still can't regenerate them, It returns this error, and whenever I try to update anything on app, it takes around 5 minutes to save it

[AlbertoVacis]

Hi Boray, i've the same problem. 
I did no changed anything in my tables and from a day to another appeared this issue that i can't solve.
Even changing the option of only reading or editable of the the table. Anoyone have any suggetsion more?

[iem_looker]

This must be a new bug.... I added a new readonly table from Postgres and a random table got hit with this bug. 

No modifications to existing tables so I'm at a loss for what happened to cause this.

[nkadonaga]

Thank you for reporting this error. My colleague @nico discovered that this a bug related to a rollout of a new caching mechanism that affects some users. Our infrastructure team has been notified and they will resolve this shortly.

[Boray]

Thank's a lot!!

[AlbertoVacis]

HI @nkadonaga  and @nico .
If can be usefull i notice the bug more often appears when I add a new colum to some random table and during the process of atualization this error appear. Then I logout , clear the cache and login in my appscritp and everything goes well.
Bye