search cancel

Error Code 300 when you run the System Summary query

book

Article ID: 164178

calendar_today

Updated On:

Products

Embedded Security Critical System Protection

Issue/Introduction

In the following versions of Symantec™ Embedded Security: Critical System Protection, when you run the System Summary query, you receive an error:

  • 6.5.1 MP1
  • 6.5.1 MP2
  • 7.0 MP1
  • 7.0 MP2

Error Code: 300
SQL Code: 213
Column name or number of supplied values does not match table definition.

Environment

  • New installation of the above-referenced versions of Symantec Embedded Security: Critical System Protection
  • Upgrade to the above-referenced versions of Symantec Embedded Security: Critical System Protection

 

Cause

Because of an issue, the System Summary query fails to execute correctly.

Resolution

You must update the dbo.SCSP_SYSSTATUS stored procedure by performing the following actions in the given order:

Action Details
Obtain the new stored procedure.
  1. Contact Symantec Support to obtain the SQL file available at https://symantec.box.com/s/9h4e0v3j00b08ex7oaclo9i830q5u08c.
  2. Open the SQL file and copy all of its contents.
Modify the existing stored procedure.
  1. Connect to the database with Microsoft SQL Management Studio.
  2. Expand Databases and the SES:CSP Database (default is SCSPDB).
  3. Navigate to Programmability > Stored Procedures.
  4. Right click on dbo.SCSP_SYSSTATUS and click Modify.
  5. Select all content in the stored procedure and replace it with the content of the SQL file you downloaded.
  6. To verify the new stored procedure, in the menu under Query click Parse. The command must complete successfully.
  7. To save the new stored procedure content, in the menu under Query click Execute.
Grant permissions to the stored procedure.
  1. Right click on the SCSPDB and click New Query.
  2. Enter the below query to grant execute permissions to the stored procedure.

    grant execute on SCSP_SYSSTATUS to scsp_opsrole
     
  3. Click Execute.

Attachments

procedure.sql get_app