App did not load successfully when adding cloud database

AppSheet AppSheet Q&A
1

I keep getting App did not load successfully when I try to add a table from the cloud database (postgres).

There are no issues found, but the app preview returns this error.

I am able to preview data for the table I added from the cloud database.

What am I doing wrong?

There was a “__:parseerror“ in the error message.

added context: the table I wanted to add have 500,000+ records which might be related because when I added a different table with low number of records from the same cloud data source, the app did not throw the same error.

2

Hello @ralph.christian,

I did some research and found out that there are some prerequisites that will allow you to enable this connection:

  • Your Postgres instance must be publicly hosted in the cloud (e.g., Google Cloud SQL, Amazon RDS).

  • Your network and the Postgres database must accept inbound connections from AppSheet’s servers. You may need to configure firewall rules or security groups to whitelist AppSheet’s IP addresses.

  • You will need the following database credentials: Server (hostname/IP address), Database name, Username, and Password.

How to connect the PostgreSQL Database as a Data Source

  1. Sign in to AppSheet and navigate to the “My Account” page.

  2. Go to the Sources tab and click + New Data Source.

  3. Enter a name for the data source and select Cloud Database.

  4. In the connection dialog:

    • For Type, select Postgres.

    • Enter the Server (hostname or IP address), Database name, Username, and Password.

    • Configure SSL settings as required by your database provider.

  5. Click Test to verify the connection details. After a successful test, click Authorize Access to save the data source in your AppSheet account.

I also found this article about using data from PostgreSQL.

I certainly hope this helps!

2 Likes
3

Please post a screenshot of the entire app screen showing the error.

4

I don’t think this is a connection issue, because I can add tables from the same postgres data source with no issues.

Here’s the screenshot @Steve

image
image1596×988 56.7 KB

1 Like
5

This is not the “parseerror” you cited originally. This error should be explained in the app editor itself.

6

My bad, that was a different error. The correct screenshot should be this:

image
image1604×1000 42 KB

1 Like
7 
I also experienced the same error "parsererror"

Screenshot_250
Screenshot_250288×175 14.4 KB

Screenshot_251
Screenshot_251278×319 20.7 KB

8

Screenshot_250
Screenshot_250288×175 14.4 KB

I also experienced the same error "parsererror"
9

That’s an internal error. You’ll need to engage Support for help with this.

10

Hello, I’m not sure if this is the exact fix to this problem but I consulted with support and I just did some security filters to the cloud database table so that the user will only see a fraction of the records (based on their useremail) and the app ran well.

So I guess it’s a data volume thing?

11

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.