RA_SYD
November 15, 2023, 5:10am
1
Hi,
When I run a query in retool on my postgresql connection I get the following error - * message:"portal "C_29945" does not exist".
The query works fine if I apply a LIMIT to around 4000 lines. Anything over 4000 lines or the LIMIT removed I get the above error?
The query without the LIMIT will only be about 5.5k lines and when I run it in pgAdmin4 I have zero issues.
Any ideas what could be causing this?
Thanks
ScottR
November 15, 2023, 2:12pm
2
There are limitations as to how many rows you can pull down before it times out - why not leave the limit in there?
RA_SYD
November 16, 2023, 12:54am
3
Hi,
Prefer having the whole table available and its never been an issue when I run the same queries on the retool database, which is also a postgresql connection.
Also never a problem when I run SOQL, seems to be isolated to the connection I currently have set up?
Thanks
@RA_SYD Did some research on that error and it seems like a Postgres cursor error. Can you share where that db is hosted?
never been an issue when I run the same queries on the retool database
Does the Retool DB have the exact same data as the original postgres db?
RA_SYD
November 26, 2023, 3:00am
5
Hi Joe, the retool database has very similar data, just not at the same volume.
When I run SOQL queries from Salesforce no limit on the volume of data, so its annoying this postgres issue? Any ideas why this is happening? Thanks
RA_SYD
November 29, 2023, 6:41am
6
@joeBumbaca do you have any update on this? My company has a large catalogue, so the limit at 4000k is abit frustrating at the moment? Thanks
RA_SYD
November 29, 2023, 6:44am
7
see another screengrab with the issue