How to create the relational database to store Alarms and Event

[RichiP]

I am using LabVIEW 8.01, Citadel 5 and DSC 8.01

How can I store Alarms and Events?

I know that I have to store it in a relational database like MS SQL, but how do I do that?

[REM1]

Citadel does it for you.

When you have alarms configured on a shared variable they are logged to Citadel.  Citadel uses MSDE as the mechanism by which it stores the alarm data so when the Citadel database gets created by the variable engine the relational database will be created also.

[RichiP]

That's what I thought, but I am still not able to log alarms.

I undeployed all variables, deleted the citadel database, disabled DB logging, restarted LabVIEW.

Then I enabled database logging, and configured the shared variables that I wanted to log. Then I deployed the variables.

When I try to read alarms and events (Alarm & Event Query.vi), I get this message:

Error -1967386611 occurred at HIST_RunAlarmQueryCORE.vi, Citadel:  (Hex 0x8ABC100D) The given Citadel database is not currently configured to log alarms to a relational database.

Regards

Richard

[RichiP]

That's what I thought, but I am still not able to log alarms.

I undeployed all variables, deleted the citadel database, disabled DB logging, restarted LabVIEW.

Then I enabled database logging, and configured the shared variables that I wanted to log. Then I deployed the variables.

When I try to read alarms and events (Alarm & Event Query.vi), I get this message:

Error -1967386611 occurred at HIST_RunAlarmQueryCORE.vi, Citadel:  (Hex 0x8ABC100D) The given Citadel database is not currently configured to log alarms to a relational database.

Regards

Richard

[RichiP]

One more thing:

I am using MS SQL Server 2005 Express.

If I browse to the selected database folder, I see that the mssql.mdf appears for a few seconds, before it disappear again. Is that correct?

regards

Richard

[JCFC]

---

Escrito por RichiP:

That's what I thought, but I am still not able to log alarms.

I undeployed all variables, deleted the citadel database, disabled DB logging, restarted LabVIEW.

Then I enabled database logging, and configured the shared variables that I wanted to log. Then I deployed the variables.

When I try to read alarms and events (Alarm & Event Query.vi), I get this message:

Error -1967386611 occurred at HIST_RunAlarmQueryCORE.vi, Citadel:  (Hex 0x8ABC100D) The given Citadel database is not currently configured to log alarms to a relational database.

Regards

Richard

---

I had the same error, (LV 8.2.1, citadel 5).

In my project I enter to properties of the Library and deactivate "Enable Alarms and Events Logging" and then i run the program, it send the same error. Next I enabled Alarms and events Logging and it works fine.