Thanks Ramy,
I have checked all the logs and have run filter, api and sql logs many
times.
There is no loop, just the issue with the second CMDB filter trying to
update the child CI.
I have copied a small part of a filter log below to show the issue more
clearly.
Cheers
Peter
/* Fri Mar 27 2009 17:12:22.2430 */ Checking
"INT:ASIFND:ACT:UPDATEGROUPLIST_105_ASTRel"
0: Push Fields -> "BMC.CORE:BMC_BaseRelationship"
<deferred from filter
INT:ASIFND:ACT:UPDATEGROUPLIST_105_ASTRel>
z1D_Action (1000000076) = CIUPDATEGROUPLIST
/* Fri Mar 27 2009 17:12:22.2580 */ Start filter processing (phase 1)
-- Operation - SET on BMC.CORE:BMC_BaseRelationship - 000000003496543
/* Fri Mar 27 2009 17:12:22.2580 */ Checking
"CMDB:Instance:REEscapeToCompareFilters" (0)
--> Failed qualification
/* Fri Mar 27 2009 17:12:22.2580 */ Checking
"CMDB:Instance:InvokeCMDBEngine01" (100)
--> Passed -- perform actions
0: Set Fields
+WFGS ARIWfGetSchema -- schema BMC.CORE:BMC_BaseRelationship
-WFGS OK
+WFGLSF ARIWfGetListField -- schema BMC.CORE:BMC_BaseRelationship
-WFGLSF OK
+WFGE ARIWfGetEntry -- schema BMC.CORE:BMC_BaseRelationship
-WFGE OK
+WFSCE ARIWfSetCurrEntry
-WFSCE OK
+WFSCE ARIWfSetCurrEntry
-WFSCE OK
+WFSCE ARIWfSetCurrEntry
-WFSCE OK
+WFSCE ARIWfSetCurrEntry
-WFSCE OK
Application-Invoke-External-Filter bmc.cmdb.cmdbEngine
PHASE=1 CLIENTTYPE=3
Exit code: 0 Value:
zCMDBEngInvokeResult (530031900) =
/* Fri Mar 27 2009 17:12:22.2890 */ Checking "ASI:CDM_SetData_500"
(500)
--> Disabled -- filter is ignored
/* Fri Mar 27 2009 17:12:22.2890 */ Checking
"ASI:CDM_UpdateGroupList-AsgGroupCI_550" (550)
--> Passed -- perform actions
0: Set Fields
CMDBRowLevelSecurity (112) = 1000000000;
/* Fri Mar 27 2009 17:12:22.3520 */ Checking
"CMDB:Instance:InvokeCMDBEngine02" (600)
--> Passed -- perform actions
0: Set Fields
+WFGE ARIWfGetEntry -- schema BMC.CORE:BMC_BaseRelationship
-WFGE OK
+WFGLEWF ARIWfGetListEntryWithFields -- schema
BMC.CORE:BMC_ProtocolEndpoint
-WFGLEWF OK
+WFGLEWF ARIWfGetListEntryWithFields -- schema
BMC.CORE:BMC_ComputerSystem
-WFGLEWF OK
+WFSE ARIWfSetEntry -- schema BMC.CORE:BMC_ProtocolEndpoint
/* Fri Mar 27 2009 17:12:22.3990 */ Start filter processing (phase 1)
-- Operation - SET on BMC.CORE:BMC_ProtocolEndpoint -
000000000043961|000000003587241
/* Fri Mar 27 2009 17:12:22.3990 */ Checking
"CMDB:Instance:REEscapeToCompareFilters" (0)
--> Failed qualification
_____
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Ramy S. Ayoub
Sent: 30 March 2009 20:54
To: [email protected]
Subject: Re: CMDB Performance - Updating Row Level Security
**
**
did you checked the AR Error log it seems there infinity loop start when the
action also start , you can refer to ar.montor and ar,cfg configuration .. a
lot of fact can cause this issue
Regards,
Ramy Ayoub
On Mon, Mar 30, 2009 at 2:17 PM, Peter Romain
<[email protected]> wrote:
Hi All,
On my system Marimba has imported ~4500 computers each with ~200 related
CIs.
When I add a Company value to a computer system CI the
CMDBRowLevelSecurity is correctly pushed to all relationships (via the
SYS:Action form).
The problem I am seeing is that when the relationship CMDBRowLevelSecurity
is updated the CMDB filter at order 600 performs a set fields on the child
CI of the relationship instead of the underscore form of the relationship
(eg BMC.CORE:BMC_Component_).
This is causing a performance hit as we try and add companies.
I have played with the security and markasdeleted fields on parent and
chld CIs as well as the relationship CI but I can't figure out why this is
happening.
Has anyone else seen this and found the reason for the child CI being
updated during an update of a relationship?
Cheers
Peter
Win 2003
ARS 7.1 Patch 6
CMDB 2.1 Patch 5
SQL Server 2005
____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
<http://www.arslist.org/>
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
__Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
