C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,329 questions
ORA-00933: SQL command not properly ended,
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 4%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
mohammed refaat
0
Reputation points
Hello,I am facing a non usual exception with no scenario having been caught regarding this exception.
I have an platform enterprise application consisting of many modules , some of those modules are dealing with the DB via the LINQ to entity technique [Lambda expressions] by writing the LINQ queries over the entity framework objects like tables & views.
I have an exception logger system that exists throughout each module to catch and save the raised exceptions while the clients are working.
My application has been published throw cloud IIS servers and the DB is at the same network
My application is written by C#.NET and dealing with ORACLE DB 12 & 19 C
My issue is that the system is working normally and suddenly I found this exception raised and logged at the log files while dealing with the DB
ORA-00933: SQL command not properly ended,
The exception then continues to get raised again and again , the only way to get the system working again normally is to restart the IIS server machine overall.
I need to understand why this exception is raising randomly ?What is the root cause ? Why does it get solved after restarting the server? and finally how to solve this exception permanently.
Thanks for your time
C#
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 85%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJX%3C/text%3E%3C/svg%3E)
Jiale Xue - MSFT 34,501 Reputation points Microsoft Vendor2024-05-02T06:53:01.36+00:00 Hi @mohammed refaat , Welcome to Microsoft Q&A,
The "ORA-00933: SQL command did not end properly" error usually occurs when there is a syntax error in the SQL statement being executed. This error indicates that there may be a problem with the SQL query generated by the LINQ to Entities query.
Check the code for LINQ queries. Ensure all LINQ expressions are correctly formed and converted to SQL.
Pay close attention to the syntax of LINQ expressions, especially when using complex queries.
Check the SQL query being executed. Look for any syntax errors or unexpected SQL constructs.
Compare problematic SQL queries to LINQ expressions to determine the source of the problem.
Sign in to comment