Error DQ299E on Dataquery DRAW command for the AUTOSCOPE DBIDs 1018, 1019, and 1020

Products

• Datacom
• Datacom/DB

Issue/Introduction

A Dataquery DRAW command against a AUTOCOLLECT table produces:

DQ299E - TABLE CAN'T BE DISPLAYED - IT IS NOT A TABLE THAT YOU MAY ACCESS: S_MUF_RETURN_CODES

Resolution

The SQL AUTHID for the AUTOSCOPE tables is "AUTOCOLLECT". Therefore, to inquire against any AUTOSCOPE tables such as S_MUF_RETURN_CODES, you need to update your Dataquery profile to add AUTOCOLLECT into SQL AUTHORIZATION ID.

Additional Information

For more information on Dataquery profiles, please review the documentation topic Managing Dataquery User Profile.

As always, please contact Broadcom support for Datacom if you have further questions.