Thank you so much Kevin! This is our current system but we've built out a new
8.1 system so this will be an issue there as well. 4000 sounds like a good
size as we are gonna exceed the 255 size on all services in the near future.
Thank you for your answer.
TERRI
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kevin Shaffer
Sent: Monday, August 10, 2015 3:29 PM
To: arslist@ARSLIST.ORG
Subject: Re: BMC.CORE:BMC_BaseElement field 112 changes
**
Terri
I have ran into this issue before because we needed 100s of companies to have
access to the Business Services.
BMC Support recommended we increase the size to 4000 which we did. You also
have to make sure you update all association forms, i.e. HPD:Association,
CHG:Association, PBM:Association, etc.
This all worked fine and dandy until it was time to apply a Service Pack.
When we moved from 7.6.04 no service pack to 7.6.04 SP4 the CMDB installer kept
failing and it took us weeks on the phone with Support troubleshooting the
issue.
It's been a couple years but if my memory serves me correctly I think I did the
following.
1. Make a backup arx of the data in Field 112
2. Change the field length back to 255 on Field 112, which truncated the
data
3. Run the SP4 CMDB installer
4. Increase the field back to 4000
5. Import the backup data I made in step 1 back into Field 112
We have replicated the issue in 8.1 and have been told it is a known limitation.
HTH
[Partner Logo-EmailSig]http://www.partneritsm.com/
Kevin Shaffer, Senior Partner
Partner IT, Inc.
(O) 888-380-8899
(C) 316-208-5341
(F) 708-887-1704
[ZA104088553]https://twitter.com/partnerITSM[ZA104088555]http://www.linkedin.com/company/partner-it-inc-[ZA104088556]https://www.youtube.com/user/partnerITSM
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Terri Lockwood
Sent: Monday, August 10, 2015 2:00 PM
To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG
Subject: BMC.CORE:BMC_BaseElement field 112 changes
**
In your experience, what are the implications of increasing the size of the
CMDBRowLevelSecurity field (112) on the Base Element form? I am getting the
error below when I try to add a new people organization relationship on the
Business Service form. I've always heard never touch this field so reaching
out to the experts. Thank you in advance!
[cid:image006.jpg@01D0D376.CECC46C0]
~~~
Terri
ARS 7.6.04
ITSM 7.6.03
Midtier 7.6.04
Windows 2008
MS SQL 2008 R2 SP2
_ARSlist: Where the Answers Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years