SBL-DAT-00462: You have attempted to denormalize calculated field '%2' in business component '%3' into column '%1'.

Applies to:

Product Release: V7 (Enterprise)
Version: 7.5.3 [16157] DEU Fin Svcs
Database: IBM DB2/UDB 8.1 FixPack 1S
Application Server OS: Microsoft Windows 2000 Advanced Server SP 3
Database Server OS: Microsoft Windows 2000 Advanced Server SP 3

This document was previously published as Siebel SR 38-1165879168.

Symptoms

SBL-DAT-00385, SBL-DAT-00398, SBL-DAT-00462

Hi, after setting up all developer environments and doing a full get/full compile without any problems, we are now experiencing problems with the check-in/check-out routines.
Whatever project we are trying to check out, the error message reads as follows:
"You have attempted to denormalize calculated field 'Done Flag' in business component 'Action' into column 'DONE_FLG'. Donormalized calculations are not allowed (SBL-DAT-00462)"

I then went ahead with Tools, connected to the Server and checked the properties of this field. It was in fact not correctly defined, as it had a column property attached to it. I then removed this property, so that it was a calculated field (the flag and the calculation expression set as it used to be in our V6 environment). Did another full compile server based, which completed without errors.

When trying to check-out projects after this modification, we are running into the same error message again. After this first error message, we are getting another one which points to a field called 'Audit Flag', which sits on a custom extension to S_EVT_ACT, claiming it to be defined twice (which, of course, is not correct).

Other symptoms, which we think are related to this problem are the unability to create sif-files locally.
Please advise, how we can fix this.
Kind regards,

Solution

Message 1

DESCRIPTION:

Problems during Check-Out of Siebel Projects

SYMPTOMS:

Whatever project we are trying to check out, the error message reads as follows:
"You have attempted to denormalize calculated field 'Done Flag' in business component 'Action' into column 'DONE_FLG'. Donormalized calculations are not allowed (SBL-DAT-00462)"


SOLUTION:

The properties of the directories where Siebel was installed have been checked and it turned out, that the user didn't had the right permissions to write files to that directory (write protection on the windows directories). After resetting these, the user could check in /out and create sif-files without any error messages.

Thank you