Error in exporting alarms to file

[dhanwanti]

dear all,

I m using Labview 7.1 and its DSC software for exporting alarms to a file.

i m using "Alarms and Event Query to SpreadSheetFile.vi" for exporting alarms.

First time when i run it then it generates the output alarm file but it was blank having only header in 2nd line of file no other data in it.

then i delete the data folder manually.

on starting again it creates the data folder after that when i run my vi for exporting alarms then it shows error as follows:-

"error code "-1967386616 " "Hist_Alarms to SpreadSheet.vi" citadel (Hex 0x8ABC1008) Read alarm failed because of connection or query failure.

 After lot research i found one of the reason may be that in data folder "MsSql.mdf and mssql.ldf" files are not generated. These files are automatically generated first time but not generated after deleting the data folder why?????

so please resolve it as early as possible for u anybody.

Thanks in advance,

Regards,

Dhanwanti

[rolfk]

---

@dhanwanti wrote:

dear all,

I m using Labview 7.1 and its DSC software for exporting alarms to a file.

i m using "Alarms and Event Query to SpreadSheetFile.vi" for exporting alarms.

First time when i run it then it generates the output alarm file but it was blank having only header in 2nd line of file no other data in it.

then i delete the data folder manually.

on starting again it creates the data folder after that when i run my vi for exporting alarms then it shows error as follows:-

"error code "-1967386616 " "Hist_Alarms to SpreadSheet.vi" citadel (Hex 0x8ABC1008) Read alarm failed because of connection or query failure.

 After lot research i found one of the reason may be that in data folder "MsSql.mdf and mssql.ldf" files are not generated. These files are automatically generated first time but not generated after deleting the data folder why?????

so please resolve it as early as possible for u anybody.

Thanks in advance,

Regards,

Dhanwanti

---

The mdf and ldf files are not created when you export the alarms but when you start up the DSC engine. They are the database files where the alarms and events are stored. Deleting them will result in an error during query because LabVIEW DSC asks the MS SQL engine to query those files for alarms and events in the specified time interval and other filter parameters and MS QSL returns an error saying it can't find those files.

All the export does is quering the database for alarms according to your criteria  (time interval and other filter events) and then writing it to a text spreadsheet file. If that file is empty you have either no alarms in the database (likely since you have deleted them many times already) or you specify filter parameters that describe an empty query result.

Rolf Kalbermatter

[dhanwanti]

dear sir,

please reply me back how i create these mssql.mdf and mssql.ldf files.

thanks

Regards

dhanwanti

[rolfk]

---

@dhanwanti wrote:

dear sir,

please reply me back how i create these mssql.mdf and mssql.ldf files.

thanks

Regards

dhanwanti

---

You don't! LabVIEW DSC does this for you after:

1) you have shutdown it properly
2) restart the DSC application
3) have defined any tags or other events that can create an alarm
4) and smile happily at your program

Not necessarily in that order but they all have to be satisfied before those files will appear again.

Rolf Kalbermatter

Message Edited by rolfk on 04-13-2006 03:11 PM