Claire,
If it is building object relationships, the setting is in the ar.cfg file,
and is record-object-relationships, or something similar, but adding an
index shouldn't cause that to suddenly happen, depending on the number of
tickets in your form, the table might just be locked while it builds it.
On Jan 15, 2015 10:36 PM, "Sanford, Claire" <
[email protected]> wrote:

> **
>  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
> [email protected]
>
>
>
>
>  _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"

Reply via email to