Reassemble message chains for display from an ODBC Log

FactoryTalk Diagnostics
has the ability to log messages that are related in message chains. However,
FactoryTalk Diagnostics
Viewer does not reassemble message chains for display from the records stored in an ODBC database. To reassemble message chains for display, create your own logic for the ODBC-compliant reporting tools you are using.
Messages that are related are logged in separate records in the database, but the values of the
RecordID
,
ParentID
,
SequenceNumber
, and
ChainTime
fields are used to associate related fields, so that the messages can be reassembled in the correct sequence when reading them from the database. For messages that are not chained, the ParentID and SequenceNumber fields are set to zero (0), and the ChainTime field contains the same time stamp as the TimeStmp field.
To reassemble a message chain, use the following
SQL Server
statement with the reporting tools you are using:
SELECT * from <table> ORDER BY ChainTime, ParentID, SequenceNumber
where <table> is the name of the table in the database.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal