DSC 8.6.1 doesn't log alarms

[Charlie Silver]

My alarms are not being logged in DSC 8.6.1.

I can tell that the alarms are being properly generated when I monitor them in the Distributed System Manger.  In keeping with previous posts, I know that the MSSQL server is running in the taskbar.  I've also tried changing the permissions for NETWORK SERVICE in the citadel directory.

When I try to monitor alarms in LV, it returns error code 1967386611: HIST_RunAlarmQueryCORE.vi, Citadel:  (Hex 0x8ABC100D) The given Citadel database is not currently configured to log alarms to a relational database.

I also notice that the time stamp on all of the citadel files is not being updated with each alarm, so it really seems like the alarms not being logged.

I have alarm logging enabled in all the appropriate places (at the variable, and in the library properties).

When I check the alarm log history in MAX, there is nothing there.

Thanks,

Charlie

[David_L]

Did you have Microsoft SQL Server installed before installing DSC?  If so some of the configuration settings may not be compatible with DSC.  SQL Server 2005 Express is installed automatically with LV DSC 8.5 and later.  If this was the case, I would suggest the following to set up SQL Express with the correct settings:

1. Detach any existing databases.
2. Uninstall all Microsoft SQL Server 2005 components.
3. Uninstall the LabVIEW DSC Module.
4. Reinstall LabVIEW DSC.

Hope this helps

[ThHagel]

Hello David,

I have the same Problem with LabVIEW and DSC8.5.1 and, yes, SQL-Server 2000 was installed before I tried to install DSC the first time.

But after I uninstalled the DSC, SQL-Server-Express 2005 and the old 2000-Version and reinstalled the complete DSC-Module it still didn't work. MAX doesn't display any error message but doesn't also show any data. ldf- and mdf-Files are not contained in the database folder.

Right after installation and first reboot I get an Error-Message: IN MSDE Security Setup Error „NI MSDE is not accessable or currently logged user doesn't have sysadmin permissions“. I found a post for this issue, but the suggested solutions didn't work for me too ( http://forums.ni.com/ni/board/message?board.id=170&message.id=243298). And if I try to use the DSC's alarm-loging feature I end up with the Error:"...database is not currently configured to log alarms...".

The DSC and the application we developed work fine on two other XP-Pro-PC's and I was surprised to get in trouble with installing it on the customers PC.

The Windows XP Pro has been installed by our customer and I don't want to touch that installation. My user account has admin permissions. I have no clue how to fix this and I hope you have an idea what to try next.

Thanks in advance,

Thomas

[Charlie Silver]

I've been back and forth with tech support for over a month on this one.  I'm afraid we're no closer than when I started.  If you ever figure it out, then please do share your solution.  This is an aggravating one - best of luck!

Charlie

[ThHagel]

Hello Charlie,

reinstalling XP Pro helped in my case. I hate that kind of solutions, but we tried so hard and spent so many days to find out what the real problem was without any results.

Except one thing: during our tests, our supporting NI-engineer found out that using the desktop for the database folder doesn't work either. Query Alarm and Events leads to the same error type. After adding the user "Everyone" to the folders security settings with full access rights the query worked without an error.

But unfortunately this was not the problem in our case, we just found another small trap while trying out possible solutions. As long as you don't have your database on your desktop (or other folders that only logged on user has access rights) this will not be the solution you are looking for.

I wish you good luck,

Thomas