Error popup

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
augustin.yann
Posts: 8
Joined: Mon 14 Apr 2014 11:21

Error popup

Post by augustin.yann » Tue 24 Jun 2014 12:26

Hello,

I am using devart fusion from VS 2013.

When I run a script with many sql statements that have errors I get a popup to ask me if I want to stop, continue or ignore all. This is fine.

But the popup only show me the Oracle error. I cannot see what line of code generates the error. So it is difficult to choose if I want stop or continue.
I tried to add the execution detail in the “SqlLog” output. But as the output window automatically switch to the general log when executing a script it doen’t help.

I there a way to see what is executing when I get an error?

Best regards
Yann

alexa

Re: Error popup

Post by alexa » Wed 25 Jun 2014 04:59

Please perform the following:
1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Devart dbForge Fusion -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.
5. Restart Visual Studio.

To open Devart SQL Log, select 'View -> Output' from the main menu and select 'Devart - SQLLog' from the drop-down menu in the 'Output' tool window.

Also, the generated log file is placed in the directory '%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Fusion\'.

augustin.yann
Posts: 8
Joined: Mon 14 Apr 2014 11:21

Re: Error popup

Post by augustin.yann » Wed 25 Jun 2014 06:02

Hello,

Thank you for your reply but as explain in the previous post this not solve my issue.

Here is an example:
I write the following code in a sql windows.

Code: Select all

SELECT 1 FROM DUAL;
SELECT 2 FROM DUAL;
SELECT 3 FROM UAL;
SELECT 4 FROM DUAL;
When I run it I get a message box saying
An error occurred in C:\Users\yaugustin\AppData\Local\Temp\{67dea28a-a47f-4305-be80-2cd64c180740}\SQL1.sql.
Additional information: ORA-00942: table or view does not exist
Do you want to stop batch execution or ignore the error and continue?
In the output windows I see the general log with the message
Query opened in 0,004s [0,004s exec, < 0,001s fetch]
Query opened in 0,003s [0,003s exec, < 0,001s fetch]
Error (3,15): ORA-00942: table or view does not exist
I cannot switch to the SQL-Log as the error popup is modal.
I have no way to know that the line causing problem is “SELECT 3 FROM UAL;”

As I have sometimes scripts with many lines and as I do not know what code makes the problem I do not know if I have to stop the script or just continue when I get an error.

Other tools, like Toad also give a message box in such case with text
SELECT 3 FROM UAL
*
Error at line 1
ORA-00942: table or view does not exist
So I immediately know what wrong in my script and can decide if I want to ignore or continue.

Is there a way to get similar information with devart ?

Best regards
Yann

alexa

Re: Error popup

Post by alexa » Wed 25 Jun 2014 06:12

Please also try invoking the 'Output' tool window by selecting 'View -> Output' from the main menu and then selecting 'Devart - SQLLog' from the drop-down menu in the 'Output' tool window prior to executing the query so when you execute the query, Devart SQLLog should open.

augustin.yann
Posts: 8
Joined: Mon 14 Apr 2014 11:21

Re: Error popup

Post by augustin.yann » Fri 04 Jul 2014 09:30

Sorry, it doesn’t work.
I automatically switch to the general log as soon as you start execution.

For me, the best way would be to show the statement that causes the error in the popup window.

alexa

Re: Error popup

Post by alexa » Fri 04 Jul 2014 11:06

Thank you for the reply.

We will fix this in future product versions.

augustin.yann
Posts: 8
Joined: Mon 14 Apr 2014 11:21

Re: Error popup

Post by augustin.yann » Mon 14 Jul 2014 12:14

Thank you :D

Post Reply