SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[12.0.191 Pro] - Error message location in Messages pane

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[12.0.191 Pro] - Error message location in Messages pane
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post [12.0.191 Pro] - Error message location in Messages pane Reply with quote
The location of the error message in the Message pane is rather unpredictable. Check this screenshot taken on a Postgres server:



This is the result of a stored procedure call that processes rows of a table in a loop and provides some feedback by using RAISE NOTICE statements. It raises three notices for each row, one for the target full name, the second one for the etl statement, and the last one for rows modified. The execution of the etl statement comes between the second and the third notice.

The line containing the error is lined by red. This is the complete error message:
Quote:

SQL State: P0001, ERROR: Exception: state: [23502], msg: [null value in column "tid_type_of_fare_product" violates not-null constraint], detail: [Failing row contains (1, null, null, null, null, 1, hkir:supplementalproduct:csomagkutyajegy, Busz élőállat és útipoggyász fuvarozás jegy, null, Élőállat és útipoggyász fuvarozást biztosító menetjegy....).], hint: [], context: [SQL statement "INSERT INTO cs.supplement_product(tid_type_of_fare_product, tid_type_of_product_category, tid_type_of_service, tid_validity_parameter_assignment, version, external_id, name, short_name, description)
SELECT tid_type_of_fare_product, tid_type_of_product_category, tid_type_of_service, tid_validity_parameter_assignment, version, external_id, name, short_name, description FROM stage.v_supplement_product;"
PL/pgSQL function etl.usp_etl_stage(text,boolean) line 1808 at EXECUTE]...


It is obvious that this line should be the last line in the row of messages. However, its location is random, based on some unknown factor. The run after which the screenshot was made put it on the 4th line from behind. The last run stuffed it somewhere in the middle of the list, containing hundreds of other lines.

What happens here? Why is it not at the end of the list? Is that heap of received lines reordered somehow and not displayed in chronological order?
Wed Jan 26, 2022 7:08 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Reply with quote
I see the same line number. I *assume* it somehow sorts lines by line number and in this case the position appears random. Let me check and get back on this.

By the way, big changes are coming to the Messages pane in 12.1. Among other things it 's going to support filtering by message type, enabling to reduce the clout and show errors only.
Wed Jan 26, 2022 10:06 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post Reply with quote
That line (19) is the location of the procedure call. All of these messages are produced by that stored procedure, so if that's the only ordering condition it might even cause the error message to move. But the rest of the lines do not seem to be messed, they are in the proper order. It's the error message that behaves as if it were drunk.
Wed Jan 26, 2022 1:20 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.