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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"