-
What are the DBMS jobs that are responsible for publishing the events to Service Bus?
A separate DBMS job is created for each document which runs in every 2mins and publishes all the queued events of the document to the respective Azure Service Bus topic. Following are the DBMS jobs for the supported Smart Materials documents.
-
Agreements - EN_PUB_AGREEMENTS
-
Requisitions - EN_PUB_REQUISITIONS
-
Invoices - EN_PUB_INVOICES
-
Period Progress - EN_PUB_PERIOD_PROGRESS
-
Account Codes - EN_PUB_ACCOUNt_CODES
-
-
Where the log files get created?
Log files get created in the DB server at a path mentioned in DBA setting LOG_FILE_DEST.
-
What are the names of the log files that are generated for event notifications?
A new log file with name "EN_{EntityType}_{DD-MM-YYYY}" gets generated every day for each document by the DBMS job and all the events log that are published on that day will be added to this log file. For example, for Agreements the log file name is EN_Agreement_21-11-2014.
A separate log file with the name "EN_{EntityType}_{Key}" is generated for each entity and all the events occurred on that entity are logged in this file.
For example, for an agreement with poh _id 12345, the log file name is EN_Agreement_12345.
-
How the sample event message looks like?
Event message schema is same for all the events. Here is the sample message for Agreement Approved event.
{"Product":"SMAT","Project":"SITE","Discipline":"PIPING","Nls":"English","EntityType":"Agreement","EntityId":10006851298,"EventType":"Approved"}