Open AI Server Error

[Jurgem]

Please answer the questions below, it helps us to keep track of the issue. Please do not ignore it or your issue will be closed.

1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): Postgres 16.0, MariaDB 10.3
2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): Version 5.6.2 (516)
3. The steps to reproduce this issue:

• [ ] a. Open TablePlus and connect to the database.
• [ ] b. Navigate to the settings or configuration related to API keys.
• [ ] c. Input the OpenAI API key.
• [ ] d. Attempt to send something in the AI prompt.
• [ ] e. Observe the immediate appearance of "Open AI Server Error."

[huyphams]

Hi @Jurgem I think the Open AI server is down (API service only).

[yakirgb]

Hi @huyphams , I have similar issue, entered key and getting error of "Open AI Server Error." Simple test for this key show that this key is fine . How to debug this issue? Version Version 5.6.5 (521) Also sent in mail .

[huyphams]

Which model are you using @yakirgb ?

[yakirgb]

I tried all models on Tableplus list, getting same error

And on OpenAI web on simple test looks that key is working

There is any log for this plugin ?

[huyphams]

Hi @yakirgb please try to remove the key and enter the key again, it may contains invalid character (whitespace or newline).

[huyphams]

[yakirgb]

ok, didn't touch the key, resolved after reopen the app.

[yakirgb]

Also, Click on show prompt: Open a new empty window:

[jpmcb]

I'm seeing the same. And re-opening doesn't make a difference.

[Handfish]

Also getting Open AI Server Error - would be nice to check the logs

[huyphams]

Unfortunately, that's all the log. I think OpenAI is too new to fix these minor issues in their API.

[Handfish]

Hi @jpmcb,

I found a similar project to utilize using OpenAI as a SQL assistant that reveals the OpenAI API Error Codes in the UI. I found that the two most likely culprits of the problem we are experiencing in TablePlus is 429 - quota, or exceeding the 16k length with the template. The free version of the OpenAI Api acted as if I had hit the quota on the first query. Loading $5 into my OpenAI account upgraded my account to Usage tier 1 and TablePlus's AI assistant started working.

With that all being said - @huyphams I don't see why Table Plus couldn't reveal the response status code and description on error. I think it would be helpful for the TablePlus users.

[huyphams]

Hi @Handfish I did here: https://www.dropbox.com/scl/fi/s0z4zqny5947eg2qhqw16/TablePlus.dmg?rlkey=76jzdex2woe2ib6epa3r6ibxs&dl=0 I found away to get the real error. Thank you!

[lucidhive]

Hey Guys, I have also been trying to solve this issue with the "Assistant" Tab.

Version 5.8.6 (534) SetApp User Still not working properly && here is steps & Flow so far for tried and or attempted solutions.

I have my own applications with both Assistants + Regular Agent SK- integrations + Dalle + Open Registry + Midjourney etc and Have not come across this in my own development as of yet, and neither in any of the other chat interfaces I utilize for storing some history locally as within SetApps other applciations made to run on localhost and or chat with files etc.

Now=

1. I have not seen any info about this GPT assistant integration anywhere yet so perhaps its a -dev test still or is this intended to be fully working?

2. I have tried with multiple GPT versions thinking you had developed this to use a specific one or something as default 3.5 or default gpt 4 did not work as intended. then I tried instruct + preview gpt4-128k tokens thinking you perhaps sent something to train and or inform the agent assistant int the background. Yet still facing the same issue.

3. I still do not see any prompt in the SHOW PROMPT have never with either option and or settings combo I have tried.

4. using regular sk-XXXX with either gpt 3.5 or any GPT-4, the results are = IDENTICAL UNLESS I instruct the agent to answer using YES or NO ONLY

All other result in POPUP = ERROR +++" The Data Could not Be Read because it is not in the correct format "

If this was just 1 PoP Up i would not have bothered writing this but it literary POPS UP 100X depending on the length of the reply the agent/assistant is sending.

&& for such a beautiful and great app you have created it should not be happening && the only REASON I HAVE EVER HAD TO FORCE QUIT over and over using TablePLus.app

5. I did an experimental step since I still have not seen anything in your menu = SHOW PROMPT = always been empty. by inserting the Assistant String-url insteak of the sk-XXXX

&& this made this POP UP error disappear for a short while but only to reappear requiring FORCE QUIT AGAIN +++ REMOVE HISTORY or CLEAR because simply replacing with sk-XXXX still generated the same issue as if it was still trying to send responses again from the last ASSISTANT that got the ERROR.

6. Now Back to using sk-XXXX I as you can see was able to ask gpt4 why this is happenign and or if its seeing any issues on send or receive on its end and NO IT DOES NOT

[huyphams]

Hi, we're re-work on this feature, please wait for the next update.

[huyphams]

Open AI change the json format recently so the native lib shows this issue