12-17-2010 02:57 PM
We are retrieving data with third-party package SQL queries from a Citadel database. Certain queries for some object members will not return data, but the SQL search application software returns an "error". An analysis of the error from the SQL end does not find problem on SQL side. I suspect corruption of Citadel database. The link to database is good, as most tags do return a value as expected.
This problem occurred at the time of re-location of the database to a replacement computer. Any ideas on how to fix such a problem?
12-19-2010 07:00 PM
Can you give an example of the "bad" SQL statement and a good one?