Confusing messages from Adaptive Server

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.

View refreshes fail

Negative numbers as object IDs

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.