If you create a view that requires information from a database that needs to be recovered, you get error messages from Adaptive Server rather than a concise error message from Monitor Client Library.
If you try to refresh a view at the same time as someone creates a database, the refresh may fail.
A refresh for a view may fail if one or more databases on Adaptive Server are in single user mode.
If you create a view using the SMC_NAME_OBJ_ID data item, you might see negative numbers as object IDs. Negative object IDs are an accurate reporting of IDs as assigned by Adaptive Server.
Monitor Server reports on all activity, including activity on temporary tables that Adaptive Server creates to perform a complex query. The object IDs that Adaptive Server assigns to temporary tables can be positive or negative. The object ID that was assigned by Adaptive Server is reported.
In views that show SMC_NAME_OBJ_NAME, the string **TempObject** is reported for temporary tables.