Internal Server Error after deployed to HANA DB
dear experts, I tried many times but still have no clue why there is an internal server error issue as screenshot shows.
Once I click "Go" (sorry for Chinese) and the error will come.
The same will come if I click "Create".
I already granted myself the required roles.
I tried to ask ChatGPT and here is the reply for my logs(I have this table in my HANA DB and don't know why it will call draft table just for a simple Travel "GET" call):
This error message is similar to the previous one you posted. It indicates that there is an issue with the SQL query being executed. The database is unable to recognize the column name ALIAS_1.DRAFTADMINISTRATIVEDATA.INPROCESSBYUSER.
Here are some steps to troubleshoot this issue:
-
Check the SQL Query: Ensure that the SQL query is written correctly. Make sure that the column
ALIAS_1.DRAFTADMINISTRATIVEDATA.INPROCESSBYUSERexists in theTravelService_Travel_draftstable. If the column doesn't exist, you will need to correct the SQL query. -
Check the Table Structure: Make sure that the table
TravelService_Travel_draftshas the columnDRAFTADMINISTRATIVEDATA.INPROCESSBYUSER. If the column doesn't exist, you will need to add it to the table or modify your SQL query to remove references to it. -
Check the Database Schema: Ensure that the database schema is up-to-date and matches the schema expected by your application. If the schema is out of date, you may need to update it.
-
Check the Application Code: If the SQL query is being generated by your application code, there may be a bug in the code that is causing the incorrect query to be generated. Check the code to make sure it is correctly generating the SQL query.
If you're still having trouble after trying these steps, you may need to seek help from a database administrator or a developer familiar with the database and application.
Anyone here?