Error when adding a User Defined Field, v11.52

  • Questions
  • Error when adding a User Defined Field, v11.52
Question ID: 105026
4
0

Starting to evaluate v11.52 for future upgrade.
We are getting a memory protected or corrupted error when adding a UDF.
Any ideas?

Marked as spam
Posted by (Questions: 23, Answers: 1)
Asked on June 3, 2013 3:06 pm
5 views
Answers (1)
4
Private answer

Saw this issue in the readme for v11.52
If this is a legacy project, this may be your resolution.

**Issue User-defined fields:**

When trying to add a custom user defined field in a project that was created originally in Quality Center 9.2 or earlier, a memory protected or corrupted error may occur.

**Workaround:**

Run the following query on the project's schema:

For SQL Server:

UPDATE td.SYSTEM_FIELD
SET SF_ROOT_ID=NULL
WHERE SF_ROOT_ID = 0 AND
SF_COLUMN_NAME <> 'CF_FATHER_ID' AND
SF_COLUMN_NAME <> 'CY_FOLDER_ID'

For Oracle:

UPDATE .SYSTEM_FIELD
SET SF_ROOT_ID=NULL
WHERE SF_ROOT_ID = 0 AND
SF_COLUMN_NAME <> 'CF_FATHER_ID' AND
SF_COLUMN_NAME <> 'CY_FOLDER_ID'

Marked as spam
Posted by (Questions: 0, Answers: 613)
Answered on June 3, 2013 3:15 pm
Thanks, I will give it a try and let you know.
( at June 3, 2013 3:43 pm)