Issue
Running reports on Extended Logs shows no data
Environment
Continuum system
Cause
Possible Causes:
- Other programs currently running extended logging (pre-1.7x style).
- Time sync errors
- Cyberstation preference is set to false
Resolution
- Check that you do not have programs running that are performing extended logging the pre-1.7x style. Any programs that were used for extended logging should be disabled or removed.
- Check the Continuum Error Log listview and see if there are time sync errors. A difference of more than 5 minutes between the Master controller and the Cyberstation will stop extended logging from working properly. You will see an error indicating that the time difference has been exceeded.
-
Ensure the Cyberstation preference is set to True
Download Extended Log Data from Controllers on the LAN(RAS)
If it was set to false, Stop/Restart Continuum
Run List views of all points, (inputs, outputs, numerics)
Example:
- In Explorer, Go to ListView> Listview_Infinity Inputs > Edit
- Click Columns> Add a Column
- Add ExtLogEnable
- Check Off Edit box
- Click Apply then the General Tab
- Run the listview
- Select Edit> Select All
- Select Object> Set Attributes
- Select ExtLogEnable, For Value type in True and Click OK, OK
- Select View> Refresh list and the attributes are set to true
- Repeat this for Outputs and Numerics
- Wait for awhile beyond how often you are logging your points.
- Run reports to verify data is being logged.
NOTE: Occasionally, after an upgrade, you may need to set all the extended log enable attributes to FALSE FIRST and then to true again for inputs, outputs and numerics to get them working.
Data may have been logging and then stopped. The data range requested in the report doesn’t have data, but there is data in the database. Here are some tips on verifying the data in the database.
Using Enterprise Manager
- Use Query Analyzer against the Continuumdb
- Select * from extendedlog
Using OSQL
- Go to a command prompt
- Enter in osql –Uandover97 –Ppyramid97 –S then enter (this assumes default user and pw, change if needed. –S needs to be followed by your server name Once you hit enter you’ll be brought to the 1> prompt
- At the 1> Prompt hit the Enter key
- 1> select * from ExtendedLog
- Type Go the Enter
- If values are returned, then extended logging is working.
- Type quit (to exit OSQL)
- Type Exit to close the DOS window