Here's a little more information. From arsql.log:
[dbmc...@vx1249 db]$ grep SG-Check-Config arsql.log
<SQL > <TID: 1101482304> <RPC ID: 0000000000> <Queue: ServGroup >
<Client-RPC: 000000 > <USER:
> /* Wed Dec 29 2010 11:06:18.3185 */INSERT INTO T8
(C2,C7,C8,C501,C508,C3,C5,C6,C1) VALUES
('ARSERVER',0,'Approval-CHK-CONFIG','SG-Check-Config','vx1249',1293642378,'ARSERVER',1293642378,'000000000215661')
<SQL > <TID: 1101482304> <RPC ID: 0000000000> <Queue: ServGroup >
<Client-RPC: 000000 > <USER:
> /* Wed Dec 29 2010 11:06:18.3496 */INSERT INTO T8
(C2,C7,C8,C501,C508,C3,C5,C6,C1) VALUES
('ARSERVER',0,'AE-CHK-CONFIG','SG-Check-Config','vx1249',1293642378,'ARSERVER',1293642378,'000000000215662')
<SQL > <TID: 1101482304> <RPC ID: 0000000000> <Queue: ServGroup >
<Client-RPC: 000000 > <USER:
> /* Wed Dec 29 2010 11:06:18.3616 */INSERT INTO T8
(C2,C7,C8,C501,C508,C3,C5,C6,C1) VALUES
('ARSERVER',0,'BR-CHK-CONFIG','SG-Check-Config','vx1249',1293642378,'ARSERVER',1293642378,'000000000215663')
<SQL > <TID: 1101482304> <RPC ID: 0000000000> <Queue: ServGroup >
<Client-RPC: 000000 > <USER:
> /* Wed Dec 29 2010 11:06:18.3741 */INSERT INTO T8
(C2,C7,C8,C501,C508,C3,C5,C6,C1) VALUES
('ARSERVER',0,'CMDB-CHK-CONFIG','SG-Check-Config','vx1249',1293642378,'ARSERVER',1293642378,'000000000215664')
<SQL > <TID: 1101482304> <RPC ID: 0000000000> <Queue: ServGroup >
<Client-RPC: 000000 > <USER:
> /* Wed Dec 29 2010 11:06:18.3885 */INSERT INTO T8
(C2,C7,C8,C501,C508,C3,C5,C6,C1) VALUES
('ARSERVER',0,'Reconciliation-CHK-CONFIG','SG-Check-Config','vx1249',1293642378,'ARSERVER',1293642378,'000000000215665')
<SQL > <TID: 1101482304> <RPC ID: 0000000000> <Queue: ServGroup >
<Client-RPC: 000000 > <USER:
> /* Wed Dec 29 2010 11:06:18.3969 */INSERT INTO T8
(C2,C7,C8,C501,C508,C3,C5,C6,C1) VALUES
('ARSERVER',0,'SLM-CHK-CONFIG','SG-Check-Config','vx1249',1293642378,'ARSERVER',1293642378,'000000000215666')
<SQL > <TID: 1139128640> <RPC ID: 0000002256> <Queue: List >
<Client-RPC: 390620 > <USER: Remedy Application Service
> /* Wed Dec 29 2010 11:06:30.7626 */SELECT T8.C1 FROM T8 WHERE ((T8.C8 =
'AE-CHK-CONFIG') AND (T8.C501 = 'SG-Check-Config')) ORDER BY C1 ASC
<SQL > <TID: 1141229888> <RPC ID: 0000002268> <Queue: List >
<Client-RPC: 390620 > <USER: Remedy Application Service
> /* Wed Dec 29 2010 11:06:30.7993 */SELECT T8.C1 FROM T8 WHERE ((T8.C8 =
'AE-CHK-CONFIG') AND (T8.C501 = 'SG-Check-Config')) ORDER BY C1 ASC
<SQL > <TID: 1160141120> <RPC ID: 0000006570> <Queue: List >
<Client-RPC: 390620 > <USER: Remedy Application Service
> /* Wed Dec 29 2010 11:06:53.8440 */SELECT T8.C1 FROM T8 WHERE ((T8.C8 =
'Approval-CHK-CONFIG') AND (T8.C501 = 'SG-Check-Config')) ORDER BY C1 ASC
<SQL > <TID: 1101482304> <RPC ID: 0000000000> <Queue: ServGroup >
<Client-RPC: 000000 > <USER:
> /* Wed Dec 29 2010 11:08:17.4584 */INSERT INTO T8
(C2,C7,C8,C501,C508,C3,C5,C6,C1) VALUES
('ARSERVER',0,'Approval-CHK-CONFIG','SG-Check-Config','vx1249',1293642497,'ARSERVER',1293642497,'000000000215672')
<SQL > <TID: 1101482304> <RPC ID: 0000000000> <Queue: ServGroup >
<Client-RPC: 000000 > <USER:
> /* Wed Dec 29 2010 11:08:17.4631 */INSERT INTO T8
(C2,C7,C8,C501,C508,C3,C5,C6,C1) VALUES
('ARSERVER',0,'AE-CHK-CONFIG','SG-Check-Config','vx1249',1293642497,'ARSERVER',1293642497,'000000000215673')
<SQL > <TID: 1101482304> <RPC ID: 0000000000> <Queue: ServGroup >
<Client-RPC: 000000 > <USER:
> /* Wed Dec 29 2010 11:08:17.4684 */INSERT INTO T8
(C2,C7,C8,C501,C508,C3,C5,C6,C1) VALUES
('ARSERVER',0,'BR-CHK-CONFIG','SG-Check-Config','vx1249',1293642497,'ARSERVER',1293642497,'000000000215674')
<SQL > <TID: 1101482304> <RPC ID: 0000000000> <Queue: ServGroup >
<Client-RPC: 000000 > <USER:
> /* Wed Dec 29 2010 11:08:17.4757 */INSERT INTO T8
(C2,C7,C8,C501,C508,C3,C5,C6,C1) VALUES
('ARSERVER',0,'CMDB-CHK-CONFIG','SG-Check-Config','vx1249',1293642497,'ARSERVER',1293642497,'000000000215675')
<SQL > <TID: 1101482304> <RPC ID: 0000000000> <Queue: ServGroup >
<Client-RPC: 000000 > <USER:
> /* Wed Dec 29 2010 11:08:17.4831 */INSERT INTO T8
(C2,C7,C8,C501,C508,C3,C5,C6,C1) VALUES
('ARSERVER',0,'Reconciliation-CHK-CONFIG','SG-Check-Config','vx1249',1293642497,'ARSERVER',1293642497,'000000000215676')
<SQL > <TID: 1101482304> <RPC ID: 0000000000> <Queue: ServGroup >
<Client-RPC: 000000 > <USER:
> /* Wed Dec 29 2010 11:08:17.4888 */INSERT INTO T8
(C2,C7,C8,C501,C508,C3,C5,C6,C1) VALUES
('ARSERVER',0,'SLM-CHK-CONFIG','SG-Check-Config','vx1249',1293642497,'ARSERVER',1293642497,'000000000215677')
<SQL > <TID: 1139128640> <RPC ID: 0000006587> <Queue: List >
<Client-RPC: 390620 > <USER: Remedy Application Service
> /* Wed Dec 29 2010 11:08:17.5507 */SELECT T8.C1 FROM T8 WHERE ((T8.C8 =
'Approval-CHK-CONFIG') AND (T8.C501 = 'SG-Check-Config')) ORDER BY C1 ASC
<SQL > <TID: 1141229888> <RPC ID: 0000006588> <Queue: List >
<Client-RPC: 390620 > <USER: Remedy Application Service
> /* Wed Dec 29 2010 11:08:17.5526 */SELECT T8.C1 FROM T8 WHERE ((T8.C8 =
'AE-CHK-CONFIG') AND (T8.C501 = 'SG-Check-Config')) ORDER BY C1 ASC
<SQL > <TID: 1160141120> <RPC ID: 0000007171> <Queue: List >
<Client-RPC: 390620 > <USER: Remedy Application Service
> /* Wed Dec 29 2010 11:08:21.5290 */SELECT T8.C1 FROM T8 WHERE ((T8.C8 =
'Approval-CHK-CONFIG') AND (T8.C501 = 'SG-Check-Config')) ORDER BY C1 ASC
<SQL > <TID: 1139128640> <RPC ID: 0000007226> <Queue: List >
<Client-RPC: 390620 > <USER: Remedy Application Service
> /* Wed Dec 29 2010 11:08:22.6205 */SELECT T8.C1 FROM T8 WHERE ((T8.C8 =
'AE-CHK-CONFIG') AND (T8.C501 = 'SG-Check-Config')) ORDER BY C1 ASCSorry for all the spam.... :( -- Sam Morris Service Assurance Union Pacific Railroad, Omaha NE 402-544-2443 (Office) 402-490-8775 (Cellular) email: [email protected] Frank Caruso <caruso.fr...@gma IL.COM> To Sent by: "Action [email protected] Request System cc discussion list(ARSList)" Subject <arsl...@arslist. Re: The Attributes that Won't Die ORG> 12/29/2010 10:19 AM Please respond to [email protected] RG ** Solaris 10 Oracle 11G ITSM 7.6.03 I have not been able to do much in the CMDB. Every change I make locks up the server and requries a restart. After the restart the changes are not there, and using the SYNC method in the CMDB driver program does not fix the issue - it also locks up the server. The only change I was able to make ( and only one time) was to add an abstract class to Base Element. BMC is currently working on the issue. They did recommend using the OLD Class manager. It did not help me but it might help you. On Wed, Dec 29, 2010 at 10:56 AM, Samuel A. Morris <[email protected]> wrote: ** Hello Listfolks! Merry Christmas, Happy Holidays, and Happy New Year! I'm trying to delete some custom attributes that were added to a few classes, and not having much luck. For example, I added an attribute to BMC_Application. I need to remove it. So I go into Atrium Core Console, drill down to the class, click the Attributes tab, choose the attribute, and click Remove. The screen grinds away for a minute or so. Then the icon in the BMC Atrium Core Console that you would use to "Delete Class" gets a red ball on the lower-right, with a white '-' in the middle of it. If I then go back into BMC_Application, the attribute is gone. But the parent class (BMC_ApplicationSystem) shows a "Status" of "Error" (though it's greyed out in that field), and in the Custom Properties field, there's "1\100050\2\1". (That part is not greyed out, and I can remove it if I want.) If I close out of Atrium Core Console and go back in, the rod ball with the minus sign on it is still present in the "Delete class" icon. And in the Custom Properties field, there's still "1\100050\2\1". However the "Status for BMC_ApplicationSystem is now "Active". And its parent (BMC_System) is also "Active", but has the same series of numbers in the "Custom Properties" field. BMC_BaseElement is the same ("Active" status, and same numbers in "Custom Properties". AND, in the BMC_Application, in the "Custom Properties" field, there's this mess: "2\400090\4\15\ApplicationType\100050\2\1" I've restarted the ARS Server (version 7.6.03 running on Linux), and had the Oracle (10gR2) guys bounce the database (also version 7.6.03) for me. The problem persists. Anyone have any ideas on how I can fix this? Thanks Sam -- Sam Morris Service Assurance Union Pacific Railroad, Omaha NE 402-544-2443 (Office) 402-490-8775 (Cellular) email: [email protected] ** This message and any attachments contain information from Union Pacific which may be confidential and/or privileged. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited by law. If you receive this message in error, please contact the sender immediately and delete the message and any attachments. ** _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ ** This message and any attachments contain information from Union Pacific which may be confidential and/or privileged. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited by law. If you receive this message in error, please contact the sender immediately and delete the message and any attachments. ** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
<<inline: graycol.gif>>
<<inline: pic08116.gif>>
<<inline: ecblank.gif>>

