ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

SQL Server: Unable to edit the Default Allocation in staffing Grid

book

Article ID: 241641

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

For SQL Server the staff grid cannot be edited.  Error is:

Could not retrieve resource. Resource name: obaStaffs. Error code: internal Error message: System error. Contact system administrator.
as well as

Cannot create a row of size 9588 which is greater than the allowable maximum row size of 8060. 

 

Steps to Reproduce: 

  1. In a MSSQL Server environment, navigate to the 'Staffing' Workspace, 'Staff Grid' 
  2. Try to edit the 'Default Allocation' field 

 

Expected Results: The field should allow editing without any errors. 

Actual Results: Error is shown and allocation resets back to the original value. Errors: Could not update resource. Resource name: obaStaffs. Cannot create a row of size 9588 which is greater than the allowable maximum row size of 8060.

 

Cause

This has to do with how the part of obaStaffs is built and reported as DE65046. 

Workaround: Add the Common Investment, 'Name' hyperlinked field to the grid. Navigate to the investment and edit the allocations in the staff grid.  

 

Environment

Release : 16.0.1

Component : Clarity MUX UI Usability

Resolution

Resolved in 16.0.2