Failed to get rows with filter (oracle): ORA-00904:"OLD_ID": invalid identifier.

[Akshay_patel95]

Hi there,

I have connected to oracle instance from appsheet. But when I try to use table from the oracle I am getting error saying Failed to get rows with filter (oracle): ORA-00904:"OLD_ID": invalid identifier. Can anyone help me in this?

[Steve]

Screenshot of the error message?

[Akshay_patel95]

Now I am getting this error. I have above 200,000 records in the table.

[Steve]

It tells you what the problem: it's taking too long to fetch the rows. Perhaps your database performance is insufficient?

[Akshay_patel95]

Hello @Steve ,

Do you think I am getting connection timeout because of 200K+ records?

[Steve]

I think it's possible.

[Akshay_patel95]

Btw now I am connected by deleting some records. Still it takes around 2 minutes to load the app.

Can you suggest me a way to design a form so that in database for every question for a particular site will be stored in row by row. If there are 10 predefined question then 10 rows.

And how can I see those 10 questions with answer in a single row in table view?

[Steve]

This sounds unrelated to the database error. Please start a new topic if so.