cap-sflight icon indicating copy to clipboard operation
cap-sflight copied to clipboard

Internal Server Error after deployed to HANA DB

Open iadc2005 opened this issue 1 year ago • 12 comments

dear experts, I tried many times but still have no clue why there is an internal server error issue as screenshot shows. Screenshot 2024-04-26 at 16 51 09 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.

iadc2005 avatar Apr 26 '24 08:04 iadc2005

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:

  1. Check the SQL Query: Ensure that the SQL query is written correctly. Make sure that the column ALIAS_1.DRAFTADMINISTRATIVEDATA.INPROCESSBYUSER exists in the TravelService_Travel_drafts table. If the column doesn't exist, you will need to correct the SQL query.

  2. Check the Table Structure: Make sure that the table TravelService_Travel_drafts has the column DRAFTADMINISTRATIVEDATA.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.

  3. 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.

  4. 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.

iadc2005 avatar Apr 26 '24 09:04 iadc2005

Anyone here?

iadc2005 avatar Jun 05 '24 06:06 iadc2005