Stop the server and check the ar.cfg for Record-Object-Relationships: T and set it to F - it may not be exactly that text but it should be obvious which one it is. Restart and you should be good to go.
It may take several hours to build the relationship data on a large system so your other option is to just wait... Mark ________________________________ From: Action Request System discussion list(ARSList) <arslist@ARSLIST.ORG> on behalf of Sanford, Claire <claire.sanf...@memorialhermann.org> Sent: 16 January 2015 05:35 To: arslist@ARSLIST.ORG Subject: ARServer.exe not responding - 911 ** Tonight I added a new index to the HPD:HelpDesk form. The ArServer Service is not coming back up completely. I have a feeling it is building the relationships. Is there a way to turn that off if I can’t get into the application? Some key in the ar.cfg or the config.properties? If I can turn it off and restart the service maybe things will come back up. This is my production system. Got to love BMC. I don’t pay for 24 hour support so I can’t have a “Critical” ticket. The woman who called me said she was going to move it down to a “High” and I would be contacted within 4 – 6 business hours. It doesn’t matter that my system is basically down. This is a snippet of my SQL log: <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:55.9530 */COMMIT WORK <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:55.9690 */SELECT timestamp,owner,lastChanged,wkConnType,alOrder,executeMask,controlfieldId,fieldId,enable,numActions,numElses,queryShort,queryLong FROM actlink WHERE actlinkId = 16909 <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:55.9690 */OK <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:55.9850 */SELECT actionIndex,actlinkId,macroName,shortText,longText FROM actlink_macro WHERE actlinkId IN(16909) ORDER BY 2 ASC <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:55.9850 */OK <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:55.9850 */SELECT actionIndex,actlinkId,fieldId,assignShort,assignLong,sampleServer,sampleSchema FROM actlink_set WHERE actlinkId IN(16909) ORDER BY 2 ASC <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:55.9850 */OK <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:55.9850 */SELECT actionIndex,actlinkId,command,commandLong FROM actlink_process WHERE actlinkId IN(16909) ORDER BY 2 ASC <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:55.9850 */OK <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:55.9850 */SELECT actionIndex,actlinkId,msgType,msgNum,msgText,msgPane FROM actlink_message WHERE actlinkId IN(16909) ORDER BY 2 ASC <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:55.9850 */OK <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:55.9850 */SELECT actionIndex,actlinkId,fieldId,charMenu,propShort,propLong,focus,accessOpt,options FROM actlink_set_char WHERE actlinkId IN(16909) ORDER BY 2 ASC <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:55.9850 */OK <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:56.0000 */INSERT INTO ardefnrel (relId,relType,relOverlayGroup,objectId,objectType,relatedObjId,relatedObjType,objectName,relatedObjName) VALUES (372011,500,'-1',16909,3,1418,1,'ASI:SHR:ButtonsOnDialogRelat_101','AST:Application') <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:56.0000 */OK <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:56.0000 */INSERT INTO ardefnrel (relId,relType,relOverlayGroup,objectId,objectType,relatedObjId,relatedObjType,objectName,relatedObjName) VALUES (372012,501,'-1',16909,3,1418,1,'ASI:SHR:ButtonsOnDialogRelat_101','AST:Application') <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:56.0000 */OK <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:56.0000 */INSERT INTO ardefnrel (relId,relType,relOverlayGroup,objectId,objectType,relatedObjId,relatedObjType,objectName,relatedObjName) VALUES (372013,500,'-1',16909,3,1415,1,'ASI:SHR:ButtonsOnDialogRelat_101','AST:Account') <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:56.0000 */OK <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:56.0000 */INSERT INTO ardefnrel (relId,relType,relOverlayGroup,objectId,objectType,relatedObjId,relatedObjType,objectName,relatedObjName) VALUES (372014,502,'-1',16909,3,1415,1,'ASI:SHR:ButtonsOnDialogRelat_101','AST:Account') <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:56.0000 */OK <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:56.0000 */INSERT INTO ardefnrel (relId,relType,relOverlayGroup,objectId,objectType,relatedObjId,relatedObjType,objectName,relatedObjName) VALUES (372015,500,'-1',16909,3,1416,1,'ASI:SHR:ButtonsOnDialogRelat_101','AST:Activity') <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:56.0160 */OK <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:56.0160 */INSERT INTO ardefnrel (relId,relType,relOverlayGroup,objectId,objectType,relatedObjId,relatedObjType,objectName,relatedObjName) VALUES (372016,500,'-1',16909,3,1417,1,'ASI:SHR:ButtonsOnDialogRelat_101','AST:AdminDomain') <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:56.0160 */OK <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:56.0160 */INSERT INTO ardefnrel (relId,relType,relOverlayGroup,objectId,objectType,relatedObjId,relatedObjType,objectName,relatedObjName) VALUES (372017,500,'-1',16909,3,1419,1,'ASI:SHR:ButtonsOnDialogRelat_101','AST:ApplicationInfrastructure') <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:56.0160 */OK <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:56.0160 */INSERT INTO ardefnrel (relId,relType,relOverlayGroup,objectId,objectType,relatedObjId,relatedObjType,objectName,relatedObjName) VALUES (372018,500,'-1',16909,3,1420,1,'ASI:SHR:ButtonsOnDialogRelat_101','AST:ApplicationService') <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:56.0160 */OK <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:56.0310 */INSERT INTO ardefnrel (relId,relType,relOverlayGroup,objectId,objectType,relatedObjId,relatedObjType,objectName,relatedObjName) VALUES (372019,500,'-1',16909,3,1421,1,'ASI:SHR:ButtonsOnDialogRelat_101','AST:ApplicationSystem') <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:56.0310 */OK <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:56.0310 */INSERT INTO ardefnrel (relId,relType,relOverlayGroup,objectId,objectType,relatedObjId,relatedObjType,objectName,relatedObjName) VALUES (372020,500,'-1',16909,3,1425,1,'ASI:SHR:ButtonsOnDialogRelat_101','AST:BIOSElement') <SQL > <TID: 0000004368> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > <Overlay-Group: -2 > /* Thu Jan 15 2015 23:02:56.0310 */OK Argh! ITSM 7.6.04 SP2 ARS 7.6.04 SP3 Oracle 11.2.0.3.0 - 64bit Production Win 2008 Server Claire Sanford Information Systems Division Memorial Hermann Healthcare System claire.sanf...@memorialhermann.org _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"