Extracting errors from server messages

I want to be able to give admin users a warning when errors that might not otherwise be see (eg errors generated by events) are logged. I thought about filtering the server messages for errors.

When server messages are written to a log file, they are nicely categorised with a message type indicator at the beginning of the line:

E. 01/25 05:00:49. Handler for event 'iqx_updateLapsed' caused SQLSTATE '23W01'


E. 01/25 05:00:49. Primary key for table 'contactevent' is not unique : Primary key value (''MG49000525012014004A'')
E. 01/26 05:00:46. Handler for event 'iqx_updateLapsed' caused SQLSTATE '23W01'
E. 01/26 05:00:46. Primary key for table 'contactevent' is not unique : Primary key value (''MG460005260120140068'')
I. 01/26 05:56:37. Starting checkpoint of "IQX" (pears.db) at Sun Jan 26 2014 05:56

I. 01/26 05:56:46. Finished checkpoint of "IQX" (pears.db) at Sun Jan 26 2014 05:56

However that indicator isn't present when server messages are retrieved using the property('Message',n) or property('MessageText',n) functions. The exact text used to indicate the error is hard to predict and it is particularly difficult to get the additional information (eg the second line in the messages above). Is there, or could there be, a way of retrieving the indicator as well?

I could grep the output file - but that does seem a bit of a round about way of doing it!

asked 28 Jan '14, 09:02

Justin Willey
7.6k●137●179●249
accept rate: 20%

edited 28 Jan '14, 09:03

flat view

One Answer:

active answers oldest answers newest answers popular answers

Take a look at the sa_server_messages system procedure - it contains all of the information that you need including message severity (INFO, WARN, ERR)

permanent link

answered 28 Jan '14, 09:09

Mark Culp
24.9k●10●141●297
accept rate: 41%

perfect - thank you! (I was used to the old get_server_messages function)

select msg_time, msg_text from sa_server_messages(0,1000000) where msg_severity = 'ERR' order by msg_id desc

(28 Jan '14, 09:25) Justin Willey

Replies hidden

FWIW: Here's another link on that topic:

How to replace the server property "Message" and the like?

(28 Jan '14, 09:36) Volker Barth

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

sa-16 ×261
server ×37
administration ×10
message ×10

question asked: 28 Jan '14, 09:02

question was seen: 2,167 times

last updated: 28 Jan '14, 09:36

SAP SQL Anywhere

Extracting errors from server messages

Follow this question

Related questions