Can you confirm what version you're using?
When you are adding People/People/Organization, you provide permissions to the corresponding CI (Business Service in your case). These are records in AST:AssetPeople form and also based on what you have selected - information is populated in CMDBRowLevelSecurity attribute in Base Element from. Each related company adds a new infromation to the existing one in this field. For this particular Business Service - go and check the corresponding record in Base Element form. I am pretty sure that the Row Level Security attribute is populated with a lot of information and it has a 255 characters limit - this invokes the 306 error.
What to do - you can increase the attribute limit via Atrium Class Manager. It is against the best practices but if comany relationships are required - you can do it!
Hi Jon – we’re using 7.6.04
Hi – I made the change from 255 Max Length to 0 – then I got the following error. I’ve changed it back to 255 but the error remains – have I broken our system?
The SQL database operation failed. : Could not use view or function ‘T1453’ because of binding errors. (SQL Server 4413)Invalid column name ‘C112’. (SQL Server 207) (ARERR 552)
Turns out I did break the system as changing the value to 0 removed the column - oops. Our support team carried out a restore of the DB and we have it fixed now but here's my next question.
We run a managed services org and we provide some shared services to our customers. One such service is a hosting service within one of our Data Centres. I created the service and began to relate any of the companies who avail of the service (there are 100+) using a 'used by' relationship to people org. Obviously this is not the way forward as it fills up the CMDBRowLevelSecurity field to its limit with only a fraction of the relationships created. Does anyone know another way to do this, am I completely off track in what I've been doing. How does anyone else model customers to service?
I am in the same boat, did you get a satisfactory solution for this?
Setting it to 0 I guess it created a CLOB so it dropped the field and recreated it, if you set it to 1024 or 2048 it should be ok
But i depends the number of relation you want to create...
I made the change to 2048 in the core class manager for base.element.
Now when I try to add more items I get the error.
The SQL database operation failed. : The statement has been terminated.String or binary data would be truncated. (SQL Server 8152) (ARERR 552) "
seems like the data type in SQL did not update...hmmm
Error from SQL log
<SQL > <TID: 0000001368> <RPC ID: 0000305993> <Queue: Fast > <Client-RPC: 390620 > <USER: ARsysadmin > <Overlay-Group: 1 > /* Wed Apr 18 2012 10:17:24.5270 */INSERT INTO T1340 (C2,C7,C8,C112,C179,C200000006,C260000001,C260100003,C260100005,C260100006,C260100008,C260100009,C260100012,C260100013,C300839200,C301104100,C301104200,C301497700,C301501300,C301501400,C304040600,C400079600,C1000000010,C1000000082,C1000002883,C1000002884,C3,C5,C6,C1) VALUES ('ARsysadmin',0,'x',';1000000027;1000000024;1000000048;1000000047;1000000022;1000000021;1000000020;1000000019;1000000046;1000000045;1000000016;1000000044;1000000037;1000000015;1000000014;1000000013;1000000012;1000000011;1000000010;1000000009;1000000008;1000000007;1000000000;''afish'';','AGGAA5V0H0O0EAMCO83AC75ZCJHAIQ',NULL,NULL,'Robert Wood Johnson University Hospital at Rahway',6000,'POR000000000232',NULL,'000000000000011|000000000000115|000000000000011|000000000000115',2,'People Organization',NULL,'OI-3e0b8ec44a844bd98fcef9809dad466b','AGGAA5V0H0O0EAMBHH8QA20UB0A57R',0,1,1,1,'BMC_BUSINESSSERVICE',NULL,'Robert Wood Johnson University Hospital at Rahway',1,1,1334758644,'ARsysadmin',1334758644,'000000000000204')
<SQL > <TID: 0000001368> <RPC ID: 0000305993> <Queue: Fast > <Client-RPC: 390620 > <USER: ARsysadmin > <Overlay-Group: 1 > /* Wed Apr 18 2012 10:17:24.5270 */* WARNING * The statement has been terminated.String or binary data would be truncated. (SQL Server 8152)
The SQL definition for the above is below.
The 112 field is still set to 255...
/****** Object: View [dbo].[T1340] Script Date: 04/18/2012 10:31:26 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE VIEW [dbo].[T1340] (C1,C4,C7,C112,C179,C60900,C10000900,C10001601,C10001858,C10007300,C10007301,C10007302,C10007304,C10007305,C10007400,C10007401,C10007410,C1000005951,E0,E1,C2) AS SELECT (b1.C1 + '|') + b2.C1,b1.C4,b1.C7,b1.C112,b1.C179,b1.C60900,b1.C1,b1.C10001601,b1.C10001858,b2.C10007300,b2.C10007301,b2.C10007302,b2.C10007304,b2.C10007305,b1.C10007400,b1.C10007401,b1.C10007410,b2.C1000005951,b1.C1,b2.C1,' ' FROM T1322 b1, T1320 b2 WHERE (b1.C10007400 = b2.C179)
1 of 1 people found this helpful
You need to do that in several tables:
AST:AssetPeople, AST:WorkLog, BMC.CORE:BMC_BaseElement, BMC.CORE:BMC_BaseRelationship, AST:LoadAssetPeople.
And then of course the class in which you want to add a relation, for example BMC.CORE:BMC_ComputerSystem_
AST:Asset people doesn;t seem to have the field. Is the list above whats needed, or only an example?
1 of 1 people found this helpful
Indeed in some forms the field isn't in the view that's why you can't find it.
So you need to go into Form->add/remove field in view and add the field to a view.
By the way, sometimes the field 112 is named RLA, Assigned Groups and so on...
I was looking for it by name and by id.... I try adding to the other forms. thanks!