Web service
Hi All, I am getting the following error message when consuming a web service created using Developer studio. ERROR (8940): Error during XML definition parsing WSDL ?xml version=1.0 encoding=UTF-8 ? - wsdl:definitions targetNamespace=urn:BBRECUpdate xmlns:s0=urn:BBRECUpdate xmlns:soap=http://schemas.xmlsoap.org/wsdl/soap/; xmlns:soapenc=http://schemas.xmlsoap.org/soap/encoding/; xmlns:wsdl=http://schemas.xmlsoap.org/wsdl/; xmlns:xsd=http://www.w3.org/2001/XMLSchema; - wsdl:types - xsd:schema elementFormDefault=qualified targetNamespace=urn:BBRECUpdate xsd:element name=Set type=s0:InputMapping3 / - xsd:complexType name=InputMapping3 - xsd:sequence xsd:element name=REC type=xsd:dateTime / xsd:element name=Request_ID type=xsd:string / /xsd:sequence /xsd:complexType xsd:element name=SetResponse type=s0:OutputMapping3 / - xsd:complexType name=OutputMapping3 - xsd:sequence xsd:element name=Request_ID type=xsd:string / /xsd:sequence /xsd:complexType xsd:element name=AuthenticationInfo type=s0:AuthenticationInfo / - xsd:complexType name=AuthenticationInfo - xsd:sequence xsd:element name=userName type=xsd:string / xsd:element name=password type=xsd:string / xsd:element minOccurs=0 name=authentication type=xsd:string / xsd:element minOccurs=0 name=locale type=xsd:string / xsd:element minOccurs=0 name=timeZone type=xsd:string / /xsd:sequence /xsd:complexType /xsd:schema /wsdl:types - wsdl:message name=ARAuthenticate wsdl:part element=s0:AuthenticationInfo name=parameters / /wsdl:message - wsdl:message name=SetSoapIn wsdl:part element=s0:Set name=parameters / /wsdl:message - wsdl:message name=SetSoapOut wsdl:part element=s0:SetResponse name=parameters / /wsdl:message - wsdl:portType name=PortPortType - wsdl:operation name=Set wsdl:input message=s0:SetSoapIn / wsdl:output message=s0:SetSoapOut / /wsdl:operation /wsdl:portType - wsdl:binding name=PortSoapBinding type=s0:PortPortType soap:binding style=document transport=http://schemas.xmlsoap.org/soap/http; / - wsdl:operation name=Set soap:operation soapAction=urn:BBRECUpdate/Set style=document / - wsdl:input soap:header message=s0:ARAuthenticate part=parameters use=literal / soap:body use=literal / /wsdl:input - wsdl:output soap:body use=literal / /wsdl:output /wsdl:operation /wsdl:binding - wsdl:service name=BBRECUpdateService - wsdl:port binding=s0:PortSoapBinding name=PortSoap soap:address location=http://maxxweb/arsys/services/ARService?server=servenetdevdbswebService=BBRECUpdate; / /wsdl:port /wsdl:service /wsdl:definitions XML using Soap UI soapenv:Envelope xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/; xmlns:urn=urn:BBRECUpdate soapenv:Header urn:AuthenticationInfo urn:userNameTest/urn:userName urn:passwordTester/urn:password !--Optional:-- urn:authentication/urn:authentication !--Optional:-- urn:localeen_CA/urn:locale !--Optional:-- urn:timeZoneAmerica/New_York/urn:timeZone /urn:AuthenticationInfo /soapenv:Header soapenv:Body urn:Set urn:REC2012-02-13T00:00:00.000-05:00/urn:REC urn:Request_ID003/urn:Request_ID /urn:Set /soapenv:Body /soapenv:Envelope ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
migrating forms migrator 7.4.6SP1 / Ars 7.1.Patch004
I cant see anyware in the migrator PDF where it states if you can or not migrate the Audit forms. I ma exporting the Helpdesk and the corresponding Audit form to .migrator file but I only end up with the main form and not the audit. I can do it with the Admin tool but not the migrator. Anyway clued as to why? thank you frex ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re : migrating forms migrator 7.4.6SP1 / Ars 7.1.Patch004
quite strange indeed!! I have tested with new forms the export with migrator seem to work... but with this specific form the form is exported with the Audit option diabled and hence no Audit form is generated at the other end when the import is completed. De : Frex Popo frexp...@yahoo.fr À : arslist@ARSLIST.ORG arslist@ARSLIST.ORG Envoyé le : Lundi 13 février 2012 14h46 Objet : migrating forms migrator 7.4.6SP1 / Ars 7.1.Patch004 I cant see anyware in the migrator PDF where it states if you can or not migrate the Audit forms. I ma exporting the Helpdesk and the corresponding Audit form to .migrator file but I only end up with the main form and not the audit. I can do it with the Admin tool but not the migrator. Anyway clued as to why? thank you frex ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: HPD Help Desk SLA
It will start a new SLA if you have set up the parameter 'Allow Service Target to Re-Open?' is set to Yes on SLA Measurement tab. Thanks, Wirasat Siddiqi Remedy Development Team Desk Phone: 202-502-3204 Cell: 202-368-7190 Email: wirasat_sidd...@ao.uscourts.gov From: Bhupesh Gupta gupta.bhupesh3...@gmail.com To: arslist@ARSLIST.ORG Date: 02/13/2012 05:53 AM Subject:HPD Help Desk SLA Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG SLA for ticket re-open ? Does it reset and start fresh SLA , or continue to use the same SLA Please advise -- Regards, Bhupesh Gupta ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Web service
Have you already tried flushing the cache on the mid-tiers or restarting the mid-tier servers? I have encountered this issue before whenever I have forgotten to do that. Sean -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Niddhi Singh Sent: Monday, February 13, 2012 8:20 AM To: arslist@ARSLIST.ORG Subject: Web service Hi All, I am getting the following error message when consuming a web service created using Developer studio. ERROR (8940): Error during XML definition parsing WSDL ?xml version=1.0 encoding=UTF-8 ? - wsdl:definitions targetNamespace=urn:BBRECUpdate xmlns:s0=urn:BBRECUpdate xmlns:soap=http://schemas.xmlsoap.org/wsdl/soap/; xmlns:soapenc=http://schemas.xmlsoap.org/soap/encoding/; xmlns:wsdl=http://schemas.xmlsoap.org/wsdl/; xmlns:xsd=http://www.w3.org/2001/XMLSchema; - wsdl:types - xsd:schema elementFormDefault=qualified targetNamespace=urn:BBRECUpdate xsd:element name=Set type=s0:InputMapping3 / - xsd:complexType name=InputMapping3 - xsd:sequence xsd:element name=REC type=xsd:dateTime / xsd:element name=Request_ID type=xsd:string / /xsd:sequence /xsd:complexType xsd:element name=SetResponse type=s0:OutputMapping3 / - xsd:complexType name=OutputMapping3 - xsd:sequence xsd:element name=Request_ID type=xsd:string / /xsd:sequence /xsd:complexType xsd:element name=AuthenticationInfo type=s0:AuthenticationInfo / - xsd:complexType name=AuthenticationInfo - xsd:sequence xsd:element name=userName type=xsd:string / xsd:element name=password type=xsd:string / xsd:element minOccurs=0 name=authentication type=xsd:string / xsd:element minOccurs=0 name=locale type=xsd:string / xsd:element minOccurs=0 name=timeZone type=xsd:string / /xsd:sequence /xsd:complexType /xsd:schema /wsdl:types - wsdl:message name=ARAuthenticate wsdl:part element=s0:AuthenticationInfo name=parameters / /wsdl:message - wsdl:message name=SetSoapIn wsdl:part element=s0:Set name=parameters / /wsdl:message - wsdl:message name=SetSoapOut wsdl:part element=s0:SetResponse name=parameters / /wsdl:message - wsdl:portType name=PortPortType - wsdl:operation name=Set wsdl:input message=s0:SetSoapIn / wsdl:output message=s0:SetSoapOut / /wsdl:operation /wsdl:portType - wsdl:binding name=PortSoapBinding type=s0:PortPortType soap:binding style=document transport=http://schemas.xmlsoap.org/soap/http; / - wsdl:operation name=Set soap:operation soapAction=urn:BBRECUpdate/Set style=document / - wsdl:input soap:header message=s0:ARAuthenticate part=parameters use=literal / soap:body use=literal / /wsdl:input - wsdl:output soap:body use=literal / /wsdl:output /wsdl:operation /wsdl:binding - wsdl:service name=BBRECUpdateService - wsdl:port binding=s0:PortSoapBinding name=PortSoap soap:address location=http://maxxweb/arsys/services/ARService?server=servenetdevdbswebService=BBRECUpdate; / /wsdl:port /wsdl:service /wsdl:definitions XML using Soap UI soapenv:Envelope xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/; xmlns:urn=urn:BBRECUpdate soapenv:Header urn:AuthenticationInfo urn:userNameTest/urn:userName urn:passwordTester/urn:password !--Optional:-- urn:authentication/urn:authentication !--Optional:-- urn:localeen_CA/urn:locale !--Optional:-- urn:timeZoneAmerica/New_York/urn:timeZone /urn:AuthenticationInfo /soapenv:Header soapenv:Body urn:Set urn:REC2012-02-13T00:00:00.000-05:00/urn:REC urn:Request_ID003/urn:Request_ID /urn:Set /soapenv:Body /soapenv:Envelope ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Issue when displaying attached files
We are running into a couple of issues when users display file attachments from the mid-tier. 1. Users displaying MS Office files that have office 2010 installed on their workstation experience a long wait time (up to 5 minutes) before the file finally opens. 2. Users displaying .txt files have issues with the text all running together when the file displays. In both cases, the user is either double clicking on the attached file or selecting it and then clicking the Display button in the attachment pool to display the file. If the user selects the file and then clicks the Save to Disk button on the attachment pool, followed by clicking the Open button that displays, everything opens as you would expect. Has anyone else seen this type of behavior? Anyone have a fix? ARS 7.5 p7 Mid-tier 7.5 p7 SQL 2008 IE 8 and IE 9 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Changing the port on oracle; Question?
Hello, The dba's are changing the port for the Remedy oracle db which is local to application server. Can she change the port and restart the listner, without me having to restart the remedy application? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Changing the port on oracle; Question?
You will want to restart the application. It is better for you to stop the application, have the DBA change the port, and restart the application. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Dee Sent: Monday, February 13, 2012 9:37 AM To: arslist@ARSLIST.ORG Subject: Changing the port on oracle; Question? Hello, The dba's are changing the port for the Remedy oracle db which is local to application server. Can she change the port and restart the listner, without me having to restart the remedy application? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: SRM Tasks
I had a similar requirement, and used an Advanced Interface Form (this isn't necessarily relevant but it explains why I would have one Filter versus several that you will need.) What I did was to have my AIF decide what the Task Group Template was based on criteria selected on the form in SRM. If you are using the normal type of SRM form, you won't be able to make your own active links and such so instead you'll have to move this portion to the Work Order itself, perhaps basing which Task Group Template you use on what is populated in one or more of the custom fields on the Details tab. Anyway, all you really need is some way to get the Task Group Template's Instance ID. From there, you need a Filter that executes on Submit. Then you create the following If Actions: 1) Push Fields to TMS:ParentApplicationTemplateBuilder mapping basically everything that looks like it fits, with the important ones being zTmpInternalCommand being set to CREATECHILD, RootRequestFormName being set to WOI:WorkOrder or $SCHEMA$, RootRequestName being $Work Order ID$, RootRequestInstanceID to $InstanceId$, and the Parent Template InstanceId to your Task Group Template's Instance ID. 2) Set Fields on the Current Transaction, setting z1D Char01 with $PROCESS$ Application-Query-Delete-Entry TMS:Flow 'RootRequestInstanceID' = $InstanceId$ AND 'ParentID' = $InstanceId$ AND 'Sequence Mode' = Yes AND 'Status' = Pending 3) Push Fields to TMS:FlowBuilder setting the fields that match, plus Parent Name to $RootRequestName(TMS)$, ParentID to $InstanceId$, Parent Type to Root Request, zTmpInternalCommand to CREATE, RootRequestFormName to $SCHEMA$, RootRequestName to $RootRequestName(TMS)$, and RootRequestInstanceID to $InstanceId$ 4) Set fields on the Current Transaction of CreatedfromParentTemplate to Yes Originally, I did it slightly differently, by setting up the Task Group Template to be attached to the Work Order instead. However, the users don't like Task Group Templates because it makes it harder to use Tasks so this method instead takes the Task Templates and attaches them directly to the Work Order instead. Thanks, Shawn Pierson Remedy Developer | Southern Union From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Gmail Sent: Saturday, February 11, 2012 9:04 AM To: arslist@ARSLIST.ORG Subject: SRM Tasks ** I have an SRD that has 3 questions with several options. Depending on the answer from the user to those three questions, I determine the tasks needed and using a variable on the PDT, the process determines which Work Order template to attach. This is working fine. However, the number of different tasks along with the possibility of answers, bring the total number of WO templates to be created to 28 different templates with respective embedded tasks that represent the user's answers. As you can see this requires a great deal of maintenance. My alternative approach is to create the tasks on the fly once the SRD is submitted and the WO has already been created. So I was wondering if anyone had to do that or not. Any ideas or thoughts would be highly appreciated. Environment details ARS 7.5.04 ITSM 7.6.00 SRM 7.6.02 Win 2003 x64 Oracle 10.2.2 Thanks, Moe. _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Resolved: Changing the port on oracle; Question?
Thanks Fred, was hoping would not have to. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Changing the port on oracle; Question?
In theory, yes.. your definitions are already loaded, during the disconnect, you will receive several disconnect errors which will go away once the database is up.. If the database takes too long to come up, the AR service has a chance of timing out, which could mean it may have to be restarted.. Life in theory tends to be different than our lower level of existence.. :-) -Original Message- From: Dee Sent: Monday, February 13, 2012 10:36 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Changing the port on oracle; Question? Hello, The dba's are changing tohe port for the Remedy oracle db which is local to application server. Can she change the port and restart the listner, without me having to restart the remedy application? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Changing the port on oracle; Question?
To be safe with production, we will schedule outage -- shutdown-port change-restart. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Server 'Alive' check
Adding SYS:Action From: Garrison, Sean (Norcross) [mailto:sean.garri...@fiserv.com] Sent: Friday, February 10, 2012 10:57 AM Subject: Re: Server 'Alive' check Additional things to check: NTE:SYS NT Process Control - is the queue building up and not clearing out? Application Pending -- is the queue building up and not clearing out? CAI:Events - is the queue building up and not clearing out? Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Friday, February 10, 2012 11:31 AM To: arslist@ARSLIST.ORG Subject: Re: Server 'Alive' check ** Ahgood point, I hadn't considered that :) From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Campbell, Paul (Paul) Sent: Friday, February 10, 2012 8:59 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Server 'Alive' check ** You may want to make sure your script is not using a user in the Administrator group, so that if for some reason you want to put a server in Admin Only mode, your script would return a failure and have the loadbalancer remove the server from the load balanced group if you set admin only mode to on, something I wish we had done at our installation. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Friday, February 10, 2012 10:02 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Server 'Alive' check ** Well...in my situation, I have a Server Group...so the effort that I'm working on is to make my Load Balancer 'smarter' so that I can take a node out of rotation if it's not working, so this particular approach wouldn't quite work for me, but I agree that in a 'manual' manner, it seems to be a reasonable scenario :) From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of strauss Sent: Thursday, February 09, 2012 3:28 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Server 'Alive' check ** I am usually satisfied with watching the AR System Email Messages form from the User Tool - I keep an open session on a work desktop that refreshes an open query for Send Message = Yes every 5 minutes, and another open query for Message Type = Outgoing where I can refresh to see all outbound traffic. If I remote in to look at it and see a miscellaneous tli error dialog, SOMETHING blocked the connection, at least momentarily, and I start troubleshooting from there by clearing the dialog. A method that requires even less effort is that I also have a folder in my mailbox that gets copies of notifications to the central Helpdesk, where I am an Associate Member. If there is recent traffic (unread mail in that folder), there isn't a problem. Basically, if people are entering tickets via one of the mid-tiers or Kinetic Request, and notifications (or escalations) are going out, it's working. A corollary benefit of this is that I see outage notifications and maintain an awareness of what kinds of tickets are being entered by both support staff and customers. That may not be what you are looking for, but it works for us. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Thursday, February 09, 2012 4:12 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Server 'Alive' check ** Listers, As we have discussed several times in the past a simple 'port check' isn't sufficient to tell you that your server is 'alive'. I'm looking for assistance with 'what do you check' when you are checking to see if your remedy server is alive and healthy. I'm not looking to check the MidTier in this effort...just the Remedy server itself. So far I have my script performing the following actions - Login - Search User Form - Execute Service The first of course ensures that the server is processing logins The second asks the remedy server to connect to the DB and return results The third 'exercises' it just a bit, asking it to do some things that one of our services does, and return a result These are of course just a small sampling of things I can have my script do...I was looking to the list to see if you have any 'oh yea, that's a good check' type of things that you typically do when embarking on this type of effort. _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the
Re: What requests does the Needs Attention view display in SRM 7.6.04
Needs attention flag is set for all service requests in which a fulfillment worker has created a work info entry for the fulfillment record (incident, change, work order) and set it to public visibility. This is a signal to the requester to read the ActivityLog because it could contain important information that might need a response by the requester. Note that if the requester and the fulfillment worker who created the work info are the same user, the Needs Attention flag is not set. The Needs attention flag has nothing to do with error, and nothing to do with request requiring approval. The latter is reflected by status waiting for approval. We are updating the misleading statement in the documentation. Peter ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Do we need two separate License keys If we plan 2 Remedy instances on ONE SUN BOX
Hello I am planing to create another ARS Remedy 7.1 Version Instnace on same solaris box in separate ZONE. Separate ZONE named as separate host separate IP address. Do we need to request another LICENSE KEY for New Instance ? OR can we use same existing LICENSE KEY ? can we point same ORACLE SID ? or Creating Separate Oracle SID is better? Please help . Thanks Ramesh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Recommeded Java Version and Tomcat Version
What is the recommended versions of these for Remedy ARS 7.6.04? Highest version please [Description: ATS Logo] Ron Suwanski Remedy Business Analyst P: 847.781.6771 F: 847.781.6750 rsuwa...@advancedtech.commailto:rsuwa...@advancedtech.com www.atsmanagedservices.comhttp://www.atsmanagedservices.com/ This communication, together with any attachments, is confidential. It may be read, copied and used only by the intended recipient. If you have received it in error, please notify the sender immediately by e-mail or telephone. Please then delete it from your computer without making any copies or disclosing it to any other person. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are inline: image001.png
Re: Recommeded Java Version and Tomcat Version
Mine is on 1.6, I have not test 1.7 on it yet.. . I believe 1.6 is minimum -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
How to create an archival server in remedy in windows platform!!!
Hi All, I want to create an archival server which will offload my production server load improves my production server performance Can anyone suggest what are all the prerequisites for the required archival server.And what need to be kept in mind while configuring this. Also will it require any short of customizations for achieveing an archival server. Please suggest to achieve the same. -- Best Regards, Hari shankar Vishwakarma Mobile:- +91-9833675872 E-mail:- hsvishwaka...@gmail.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Midtier SSO for 7.6.04 64bit
Has anyone implemented Midtier SSO in a 64bit environment? I have been using a modified version of code provided by BMC. It was written for 32bit systems and errors out when attempting to use it on a 64bit system. I just wanted to know if there are any solutions out there for 64bit environments. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Midtier SSO for 7.6.04 64bit
Hi, What are the errors? I think the BMC open source code is for the C plugin which is still 32 bit even on the latest builds. So it should work. Regards Danny -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of E. Thornton Sent: 13 February 2012 18:52 To: arslist@ARSLIST.ORG Subject: Midtier SSO for 7.6.04 64bit Has anyone implemented Midtier SSO in a 64bit environment? I have been using a modified version of code provided by BMC. It was written for 32bit systems and errors out when attempting to use it on a 64bit system. I just wanted to know if there are any solutions out there for 64bit environments. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: How to create an archival server in remedy in windows platform!!!
Well Hari... We currently just finishing up the creation of an archival server. I guess my key questions would be: 1. Do you have any Archive Policies in place (i.e. Incident Tickets will be automatically closed after 90 Days). 2. What applications are you running (i.e. ITSM or Custom Applications)? 3. What do you want to archive? 4. How are you going to archive (Archive forms, DSO, Remedy Migrator, DRIVER.EXE, etc.)? On Feb 13, 1:32 pm, Hari Vishwakarma hsvishwaka...@gmail.com wrote: Hi All, I want to create an archival server which will offload my production server load improves my production server performance Can anyone suggest what are all the prerequisites for the required archival server.And what need to be kept in mind while configuring this. Also will it require any short of customizations for achieveing an archival server. Please suggest to achieve the same. -- Best Regards, Hari shankar Vishwakarma Mobile:- +91-9833675872 E-mail:- hsvishwaka...@gmail.com ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug12www.wwrug12.comARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Question about Oracle-Clob-Storage-In-Row setting
Hello, We are setting up a new 7.6.04 sandbox server (ARS on AIX, db is Oracle 11gR2) and reviewing our settings from prior versions. We've set Oracle-Clob-Storage-In-Row: T in the ar.conf. My understanding from reading the documents was that this setting causes ARS to add a clause to the CREATE TABLE statement so that clobs are stored in row. In the Using Oracle CLOBs with BMC Remedy Action Request System (March 2009, 89963) white paper it says: To specify the storage option at the Oracle database level, use the ENABLE|DISABLE STORAGE IN ROW clause of the CREATE TABLE statement. So with the setting set and sql logging turned on, I created a regular form, core fields only. This is the entire CREATE TABLE statement from the log: CREATE TABLE T2005 (C1 varchar(15) not null,C2 varchar(254) NULL,C3 number(15,0) not null,C4 varchar(254) NULL,C5 varchar(254) not null,C6 number(15,0) not null,C7 number(15,0) not null,C8 varchar(254) not null) Shouldn't there be a part of that that says STORAGE IN ROW or something similar? I tried googling for examples of what the SQL should look like, but didn't find anything definitive. Is there a way to see if STORAGE IN ROW has been set for that table? Out of curiousity, I ran the same test on our existing 7.1 dev server which has been running with that setting for years and got the same results. So I figure I'm misunderstanding something and would appreciate any insights. Thanks, Thad ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Question about Oracle-Clob-Storage-In-Row setting
You will only see the clause if you add a 0 length character field (or a Diary or a field bigger than 4000 characters) as those are stored as a CLOB. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Monday, February 13, 2012 1:50 PM To: arslist@ARSLIST.ORG Subject: Question about Oracle-Clob-Storage-In-Row setting ** Hello, We are setting up a new 7.6.04 sandbox server (ARS on AIX, db is Oracle 11gR2) and reviewing our settings from prior versions. We've set Oracle-Clob-Storage-In-Row: T in the ar.conf. My understanding from reading the documents was that this setting causes ARS to add a clause to the CREATE TABLE statement so that clobs are stored in row. In the Using Oracle CLOBs with BMC Remedy Action Request System (March 2009, 89963) white paper it says: To specify the storage option at the Oracle database level, use the ENABLE|DISABLE STORAGE IN ROW clause of the CREATE TABLE statement. So with the setting set and sql logging turned on, I created a regular form, core fields only. This is the entire CREATE TABLE statement from the log: CREATE TABLE T2005 (C1 varchar(15) not null,C2 varchar(254) NULL,C3 number(15,0) not null,C4 varchar(254) NULL,C5 varchar(254) not null,C6 number(15,0) not null,C7 number(15,0) not null,C8 varchar(254) not null) Shouldn't there be a part of that that says STORAGE IN ROW or something similar? I tried googling for examples of what the SQL should look like, but didn't find anything definitive. Is there a way to see if STORAGE IN ROW has been set for that table? Out of curiousity, I ran the same test on our existing 7.1 dev server which has been running with that setting for years and got the same results. So I figure I'm misunderstanding something and would appreciate any insights. Thanks, Thad ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Question about Oracle-Clob-Storage-In-Row setting
I was just testing that scenario as you responded. I created a new regular form, adding a character field with db length 8000 before the first save. This is what showed in the logs (clipped for brevity) when I did save it: CREATE TABLE T2011 (C1 varchar(15) not null,C2 varchar(254) NULL,C3 number(15,0) not null,C4 varchar(254) NULL,C5 varchar(254) not null,C6 number(15,0) not null,C7 number(15,0) not null,C8 varchar(254) not null) OK CREATE UNIQUE INDEX IT2011 ON T2011 (C1) OK CREATE TABLE H2011 (entryId varchar(15) not null,T0 number(15,0) NULL,U0 varchar(254) NULL,T1 number(15,0) NULL,U1 varchar(254) NULL,T2 number(15,0) NULL,U2 varchar(254) NULL,T3 number(15,0) NULL,U3 varchar(254) NULL,T4 number(15,0) NULL,U4 varchar(254) NULL) OK ... creates H, T, B tables and views ... ALTER TABLE T2011 ADD (C536870913 clob NULL) Still no indication that it is accounting for the storage in row. I'm sure it's there, I would just like to see it happening or be able to verify it somehow. Thanks, Thad On Mon, Feb 13, 2012 at 12:04 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: You will only see the clause if you add a 0 length character field (or a Diary or a field bigger than 4000 characters) as those are stored as a CLOB. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Monday, February 13, 2012 1:50 PM To: arslist@ARSLIST.ORG Subject: Question about Oracle-Clob-Storage-In-Row setting ** Hello, We are setting up a new 7.6.04 sandbox server (ARS on AIX, db is Oracle 11gR2) and reviewing our settings from prior versions. We've set Oracle-Clob-Storage-In-Row: T in the ar.conf. My understanding from reading the documents was that this setting causes ARS to add a clause to the CREATE TABLE statement so that clobs are stored in row. In the Using Oracle CLOBs with BMC Remedy Action Request System (March 2009, 89963) white paper it says: To specify the storage option at the Oracle database level, use the ENABLE|DISABLE STORAGE IN ROW clause of the CREATE TABLE statement. So with the setting set and sql logging turned on, I created a regular form, core fields only. This is the entire CREATE TABLE statement from the log: CREATE TABLE T2005 (C1 varchar(15) not null,C2 varchar(254) NULL,C3 number(15,0) not null,C4 varchar(254) NULL,C5 varchar(254) not null,C6 number(15,0) not null,C7 number(15,0) not null,C8 varchar(254) not null) Shouldn't there be a part of that that says STORAGE IN ROW or something similar? I tried googling for examples of what the SQL should look like, but didn't find anything definitive. Is there a way to see if STORAGE IN ROW has been set for that table? Out of curiousity, I ran the same test on our existing 7.1 dev server which has been running with that setting for years and got the same results. So I figure I'm misunderstanding something and would appreciate any insights. Thanks, Thad ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Question about Oracle-Clob-Storage-In-Row setting
You can see the current state using the Oracle data dictionary: select owner , table_name , column_name , in_row fromdba_lobs / Axton Grams On Mon, Feb 13, 2012 at 2:25 PM, Thad Esser thad.es...@gmail.com wrote: ** I was just testing that scenario as you responded. I created a new regular form, adding a character field with db length 8000 before the first save. This is what showed in the logs (clipped for brevity) when I did save it: CREATE TABLE T2011 (C1 varchar(15) not null,C2 varchar(254) NULL,C3 number(15,0) not null,C4 varchar(254) NULL,C5 varchar(254) not null,C6 number(15,0) not null,C7 number(15,0) not null,C8 varchar(254) not null) OK CREATE UNIQUE INDEX IT2011 ON T2011 (C1) OK CREATE TABLE H2011 (entryId varchar(15) not null,T0 number(15,0) NULL,U0 varchar(254) NULL,T1 number(15,0) NULL,U1 varchar(254) NULL,T2 number(15,0) NULL,U2 varchar(254) NULL,T3 number(15,0) NULL,U3 varchar(254) NULL,T4 number(15,0) NULL,U4 varchar(254) NULL) OK ... creates H, T, B tables and views ... ALTER TABLE T2011 ADD (C536870913 clob NULL) Still no indication that it is accounting for the storage in row. I'm sure it's there, I would just like to see it happening or be able to verify it somehow. Thanks, Thad On Mon, Feb 13, 2012 at 12:04 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: You will only see the clause if you add a 0 length character field (or a Diary or a field bigger than 4000 characters) as those are stored as a CLOB. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Monday, February 13, 2012 1:50 PM To: arslist@ARSLIST.ORG Subject: Question about Oracle-Clob-Storage-In-Row setting ** Hello, We are setting up a new 7.6.04 sandbox server (ARS on AIX, db is Oracle 11gR2) and reviewing our settings from prior versions. We've set Oracle-Clob-Storage-In-Row: T in the ar.conf. My understanding from reading the documents was that this setting causes ARS to add a clause to the CREATE TABLE statement so that clobs are stored in row. In the Using Oracle CLOBs with BMC Remedy Action Request System (March 2009, 89963) white paper it says: To specify the storage option at the Oracle database level, use the ENABLE|DISABLE STORAGE IN ROW clause of the CREATE TABLE statement. So with the setting set and sql logging turned on, I created a regular form, core fields only. This is the entire CREATE TABLE statement from the log: CREATE TABLE T2005 (C1 varchar(15) not null,C2 varchar(254) NULL,C3 number(15,0) not null,C4 varchar(254) NULL,C5 varchar(254) not null,C6 number(15,0) not null,C7 number(15,0) not null,C8 varchar(254) not null) Shouldn't there be a part of that that says STORAGE IN ROW or something similar? I tried googling for examples of what the SQL should look like, but didn't find anything definitive. Is there a way to see if STORAGE IN ROW has been set for that table? Out of curiousity, I ran the same test on our existing 7.1 dev server which has been running with that setting for years and got the same results. So I figure I'm misunderstanding something and would appreciate any insights. Thanks, Thad ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Question about Oracle-Clob-Storage-In-Row setting
If you don't have access to dba_logs, use user_lobs instead: select table_name , column_name , in_row fromuser_lobs / Axton Grams On Mon, Feb 13, 2012 at 2:33 PM, Axton axton.gr...@gmail.com wrote: You can see the current state using the Oracle data dictionary: select owner , table_name , column_name , in_row from dba_lobs / Axton Grams On Mon, Feb 13, 2012 at 2:25 PM, Thad Esser thad.es...@gmail.com wrote: ** I was just testing that scenario as you responded. I created a new regular form, adding a character field with db length 8000 before the first save. This is what showed in the logs (clipped for brevity) when I did save it: CREATE TABLE T2011 (C1 varchar(15) not null,C2 varchar(254) NULL,C3 number(15,0) not null,C4 varchar(254) NULL,C5 varchar(254) not null,C6 number(15,0) not null,C7 number(15,0) not null,C8 varchar(254) not null) OK CREATE UNIQUE INDEX IT2011 ON T2011 (C1) OK CREATE TABLE H2011 (entryId varchar(15) not null,T0 number(15,0) NULL,U0 varchar(254) NULL,T1 number(15,0) NULL,U1 varchar(254) NULL,T2 number(15,0) NULL,U2 varchar(254) NULL,T3 number(15,0) NULL,U3 varchar(254) NULL,T4 number(15,0) NULL,U4 varchar(254) NULL) OK ... creates H, T, B tables and views ... ALTER TABLE T2011 ADD (C536870913 clob NULL) Still no indication that it is accounting for the storage in row. I'm sure it's there, I would just like to see it happening or be able to verify it somehow. Thanks, Thad On Mon, Feb 13, 2012 at 12:04 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: You will only see the clause if you add a 0 length character field (or a Diary or a field bigger than 4000 characters) as those are stored as a CLOB. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Monday, February 13, 2012 1:50 PM To: arslist@ARSLIST.ORG Subject: Question about Oracle-Clob-Storage-In-Row setting ** Hello, We are setting up a new 7.6.04 sandbox server (ARS on AIX, db is Oracle 11gR2) and reviewing our settings from prior versions. We've set Oracle-Clob-Storage-In-Row: T in the ar.conf. My understanding from reading the documents was that this setting causes ARS to add a clause to the CREATE TABLE statement so that clobs are stored in row. In the Using Oracle CLOBs with BMC Remedy Action Request System (March 2009, 89963) white paper it says: To specify the storage option at the Oracle database level, use the ENABLE|DISABLE STORAGE IN ROW clause of the CREATE TABLE statement. So with the setting set and sql logging turned on, I created a regular form, core fields only. This is the entire CREATE TABLE statement from the log: CREATE TABLE T2005 (C1 varchar(15) not null,C2 varchar(254) NULL,C3 number(15,0) not null,C4 varchar(254) NULL,C5 varchar(254) not null,C6 number(15,0) not null,C7 number(15,0) not null,C8 varchar(254) not null) Shouldn't there be a part of that that says STORAGE IN ROW or something similar? I tried googling for examples of what the SQL should look like, but didn't find anything definitive. Is there a way to see if STORAGE IN ROW has been set for that table? Out of curiousity, I ran the same test on our existing 7.1 dev server which has been running with that setting for years and got the same results. So I figure I'm misunderstanding something and would appreciate any insights. Thanks, Thad ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Question about Oracle-Clob-Storage-In-Row setting
Just an FYI ... enabling this feature does not go back and fix all of the tables that are storing your data Out of Row BMC has an oracle stored procedure for fixing that. See page 10 and 11 of the Using Oracle CLOBs with BMC Remedy Action Request System white paper. Doing so will reduce your db size considerably (assuming you enabled it after installing ITSM). Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Monday, February 13, 2012 3:26 PM To: arslist@ARSLIST.ORG Subject: Re: Question about Oracle-Clob-Storage-In-Row setting ** I was just testing that scenario as you responded. I created a new regular form, adding a character field with db length 8000 before the first save. This is what showed in the logs (clipped for brevity) when I did save it: CREATE TABLE T2011 (C1 varchar(15) not null,C2 varchar(254) NULL,C3 number(15,0) not null,C4 varchar(254) NULL,C5 varchar(254) not null,C6 number(15,0) not null,C7 number(15,0) not null,C8 varchar(254) not null) OK CREATE UNIQUE INDEX IT2011 ON T2011 (C1) OK CREATE TABLE H2011 (entryId varchar(15) not null,T0 number(15,0) NULL,U0 varchar(254) NULL,T1 number(15,0) NULL,U1 varchar(254) NULL,T2 number(15,0) NULL,U2 varchar(254) NULL,T3 number(15,0) NULL,U3 varchar(254) NULL,T4 number(15,0) NULL,U4 varchar(254) NULL) OK ... creates H, T, B tables and views ... ALTER TABLE T2011 ADD (C536870913 clob NULL) Still no indication that it is accounting for the storage in row. I'm sure it's there, I would just like to see it happening or be able to verify it somehow. Thanks, Thad On Mon, Feb 13, 2012 at 12:04 PM, Grooms, Frederick W frederick.w.gro...@xo.commailto:frederick.w.gro...@xo.com wrote: You will only see the clause if you add a 0 length character field (or a Diary or a field bigger than 4000 characters) as those are stored as a CLOB. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Monday, February 13, 2012 1:50 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Question about Oracle-Clob-Storage-In-Row setting ** Hello, We are setting up a new 7.6.04 sandbox server (ARS on AIX, db is Oracle 11gR2) and reviewing our settings from prior versions. We've set Oracle-Clob-Storage-In-Row: T in the ar.conf. My understanding from reading the documents was that this setting causes ARS to add a clause to the CREATE TABLE statement so that clobs are stored in row. In the Using Oracle CLOBs with BMC Remedy Action Request System (March 2009, 89963) white paper it says: To specify the storage option at the Oracle database level, use the ENABLE|DISABLE STORAGE IN ROW clause of the CREATE TABLE statement. So with the setting set and sql logging turned on, I created a regular form, core fields only. This is the entire CREATE TABLE statement from the log: CREATE TABLE T2005 (C1 varchar(15) not null,C2 varchar(254) NULL,C3 number(15,0) not null,C4 varchar(254) NULL,C5 varchar(254) not null,C6 number(15,0) not null,C7 number(15,0) not null,C8 varchar(254) not null) Shouldn't there be a part of that that says STORAGE IN ROW or something similar? I tried googling for examples of what the SQL should look like, but didn't find anything definitive. Is there a way to see if STORAGE IN ROW has been set for that table? Out of curiousity, I ran the same test on our existing 7.1 dev server which has been running with that setting for years and got the same results. So I figure I'm misunderstanding something and would appreciate any insights. Thanks, Thad ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org/ attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com/ ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Question about Oracle-Clob-Storage-In-Row setting
Do a Describe on the T table. In SQL Plus do DESC T2011; You should see something like LOB (C536870913) STORE AS ( ENABLE STORAGE IN ROW CHUNK 8192 Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Monday, February 13, 2012 2:26 PM To: arslist@ARSLIST.ORG Subject: Re: Question about Oracle-Clob-Storage-In-Row setting ** I was just testing that scenario as you responded. I created a new regular form, adding a character field with db length 8000 before the first save. This is what showed in the logs (clipped for brevity) when I did save it: CREATE TABLE T2011 (C1 varchar(15) not null,C2 varchar(254) NULL,C3 number(15,0) not null,C4 varchar(254) NULL,C5 varchar(254) not null,C6 number(15,0) not null,C7 number(15,0) not null,C8 varchar(254) not null) OK CREATE UNIQUE INDEX IT2011 ON T2011 (C1) OK CREATE TABLE H2011 (entryId varchar(15) not null,T0 number(15,0) NULL,U0 varchar(254) NULL,T1 number(15,0) NULL,U1 varchar(254) NULL,T2 number(15,0) NULL,U2 varchar(254) NULL,T3 number(15,0) NULL,U3 varchar(254) NULL,T4 number(15,0) NULL,U4 varchar(254) NULL) OK ... creates H, T, B tables and views ... ALTER TABLE T2011 ADD (C536870913 clob NULL) Still no indication that it is accounting for the storage in row. I'm sure it's there, I would just like to see it happening or be able to verify it somehow. Thanks, Thad -Original Message- On Mon, Feb 13, 2012 at 12:04 PM, Grooms, Frederick W wrote: You will only see the clause if you add a 0 length character field (or a Diary or a field bigger than 4000 characters) as those are stored as a CLOB. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Monday, February 13, 2012 1:50 PM To: arslist@ARSLIST.ORG Subject: Question about Oracle-Clob-Storage-In-Row setting ** Hello, We are setting up a new 7.6.04 sandbox server (ARS on AIX, db is Oracle 11gR2) and reviewing our settings from prior versions. We've set Oracle-Clob-Storage-In-Row: T in the ar.conf. My understanding from reading the documents was that this setting causes ARS to add a clause to the CREATE TABLE statement so that clobs are stored in row. In the Using Oracle CLOBs with BMC Remedy Action Request System (March 2009, 89963) white paper it says: To specify the storage option at the Oracle database level, use the ENABLE|DISABLE STORAGE IN ROW clause of the CREATE TABLE statement. So with the setting set and sql logging turned on, I created a regular form, core fields only. This is the entire CREATE TABLE statement from the log: CREATE TABLE T2005 (C1 varchar(15) not null,C2 varchar(254) NULL,C3 number(15,0) not null,C4 varchar(254) NULL,C5 varchar(254) not null,C6 number(15,0) not null,C7 number(15,0) not null,C8 varchar(254) not null) Shouldn't there be a part of that that says STORAGE IN ROW or something similar? I tried googling for examples of what the SQL should look like, but didn't find anything definitive. Is there a way to see if STORAGE IN ROW has been set for that table? Out of curiousity, I ran the same test on our existing 7.1 dev server which has been running with that setting for years and got the same results. So I figure I'm misunderstanding something and would appreciate any insights. Thanks, Thad ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Do we need two separate License keys If we plan 2 Remedy instances on ONE SUN BOX
Yes, each solaris zone or virtual machine is treated as a separate instance and you need license for each of them. You can check with your BMC account rep to see if your are in new pricing model which may give you unlimited installs. But you may still have to pay user licensing for each instance. But if you use them for a server group configuration then user and application licenses are shared. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
hey wirasat
Are you still interested in a possible perm job? I believe you said you would get your permanent green card sometime in the spring... I would like to invite you to apply at Rightstar Systems. I love this company, and they provide all sorts of training and benefits, as well as CareFirst Blue Cross. The recruiter there asked me if I knew anyone I could recommend who is local to NoVa and of course thought of you. Please let me know and I can provide you with more information to answer your questions and introduce you to David Edwards, our recruiter. Take care now! Louise From: Wirasat Siddiqi wirasat_sidd...@ao.uscourts.gov To: arslist@ARSLIST.ORG Sent: Monday, February 13, 2012 9:58 AM Subject: Re: HPD Help Desk SLA ** It will start a new SLA if you have set up the parameter 'Allow Service Target to Re-Open?' is set to Yes on SLA Measurement tab. Thanks, Wirasat Siddiqi Remedy Development Team Desk Phone: 202-502-3204 Cell: 202-368-7190 Email: wirasat_sidd...@ao.uscourts.gov From: Bhupesh Gupta gupta.bhupesh3...@gmail.com To: arslist@ARSLIST.ORG Date: 02/13/2012 05:53 AM Subject: HPD Help Desk SLA Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG SLA for ticket re-open ? Does it reset and start fresh SLA , or continue to use the same SLA Please advise -- Regards, Bhupesh Gupta ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.comARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
spam warning
Dear Dan and the list, I just did this to prove that Yahoo's interface for private email replies still appends the group email address.It also qualifies me to get the Wake Up and Smell the Coffee award for the second time in my career. (The first time was spamming the ARSList in 1997 for which Dan promptly recruited me for Systemhouse. Actually it was just a dumb mistake. So I am really hoping he, and Wirasat, will forgive me. From: Louise Van Hine lvanh...@yahoo.com To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG; wirasat_sidd...@ao.uscourts.gov wirasat_sidd...@ao.uscourts.gov Sent: Monday, February 13, 2012 3:48 PM Subject: hey wirasat Are you still interested in a possible perm job? I believe you said you would get your permanent green card sometime in the spring... I would like to invite you to apply at Rightstar Systems. I love this company, and they provide all sorts of training and benefits, as well as CareFirst Blue Cross. The recruiter there asked me if I knew anyone I could recommend who is local to NoVa and of course thought of you. Please let me know and I can provide you with more information to answer your questions and introduce you to David Edwards, our recruiter. Take care now! Louise From: Wirasat Siddiqi wirasat_sidd...@ao.uscourts.gov To: arslist@ARSLIST.ORG Sent: Monday, February 13, 2012 9:58 AM Subject: Re: HPD Help Desk SLA ** It will start a new SLA if you have set up the parameter 'Allow Service Target to Re-Open?' is set to Yes on SLA Measurement tab. Thanks, Wirasat Siddiqi Remedy Development Team Desk Phone: 202-502-3204 Cell: 202-368-7190 Email: wirasat_sidd...@ao.uscourts.gov From: Bhupesh Gupta gupta.bhupesh3...@gmail.com To: arslist@ARSLIST.ORG Date: 02/13/2012 05:53 AM Subject: HPD Help Desk SLA Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG SLA for ticket re-open ? Does it reset and start fresh SLA , or continue to use the same SLA Please advise -- Regards, Bhupesh Gupta ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.comARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: spam warning
That was then this is now. 15 years later and you are making the same dumb mistakes? I expect a whole new set by now, quite disappointing and uninteresting. And knowing you I really expected obscurely interesting ones. Happy to hear you like your current employer, much better than what people usually post by accident. Sorry, I only award the truly interesting things. Granted it is my rather suspect definition of interesting. Hey, no one has threatened to sue if I don't delete a post in at least a couple of years, any takers? Daniel p.s. and the answer is no, the same answer I gave the US Armed Forces when they called me, I can't delete a post, I can't stop a post From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Louise Van Hine Sent: February 13, 2012 4:29 PM To: arslist@ARSLIST.ORG Subject: spam warning ** Dear Dan and the list, I just did this to prove that Yahoo's interface for private email replies still appends the group email address.It also qualifies me to get the Wake Up and Smell the Coffee award for the second time in my career. (The first time was spamming the ARSList in 1997 for which Dan promptly recruited me for Systemhouse. Actually it was just a dumb mistake. So I am really hoping he, and Wirasat, will forgive me. From: Louise Van Hine lvanh...@yahoo.com To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG; wirasat_sidd...@ao.uscourts.gov wirasat_sidd...@ao.uscourts.gov Sent: Monday, February 13, 2012 3:48 PM Subject: hey wirasat Are you still interested in a possible perm job? I believe you said you would get your permanent green card sometime in the spring... I would like to invite you to apply at Rightstar Systems. I love this company, and they provide all sorts of training and benefits, as well as CareFirst Blue Cross. The recruiter there asked me if I knew anyone I could recommend who is local to NoVa and of course thought of you. Please let me know and I can provide you with more information to answer your questions and introduce you to David Edwards, our recruiter. Take care now! Louise From: Wirasat Siddiqi wirasat_sidd...@ao.uscourts.gov To: arslist@ARSLIST.ORG Sent: Monday, February 13, 2012 9:58 AM Subject: Re: HPD Help Desk SLA ** It will start a new SLA if you have set up the parameter 'Allow Service Target to Re-Open?' is set to Yes on SLA Measurement tab. Thanks, Wirasat Siddiqi Remedy Development Team Desk Phone: 202-502-3204 Cell: 202-368-7190 Email: wirasat_sidd...@ao.uscourts.gov From: Bhupesh Gupta gupta.bhupesh3...@gmail.com To:arslist@ARSLIST.ORG Date:02/13/2012 05:53 AM Subject:HPD Help Desk SLA Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG SLA for ticket re-open ? Does it reset and start fresh SLA , or continue to use the same SLA Please advise -- Regards, Bhupesh Gupta ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Question about Oracle-Clob-Storage-In-Row setting
Excellent, Thank You! We're good. Thad On Mon, Feb 13, 2012 at 12:33 PM, Axton axton.gr...@gmail.com wrote: If you don't have access to dba_logs, use user_lobs instead: select table_name , column_name , in_row fromuser_lobs / Axton Grams On Mon, Feb 13, 2012 at 2:33 PM, Axton axton.gr...@gmail.com wrote: You can see the current state using the Oracle data dictionary: select owner , table_name , column_name , in_row fromdba_lobs / Axton Grams On Mon, Feb 13, 2012 at 2:25 PM, Thad Esser thad.es...@gmail.com wrote: ** I was just testing that scenario as you responded. I created a new regular form, adding a character field with db length 8000 before the first save. This is what showed in the logs (clipped for brevity) when I did save it: CREATE TABLE T2011 (C1 varchar(15) not null,C2 varchar(254) NULL,C3 number(15,0) not null,C4 varchar(254) NULL,C5 varchar(254) not null,C6 number(15,0) not null,C7 number(15,0) not null,C8 varchar(254) not null) OK CREATE UNIQUE INDEX IT2011 ON T2011 (C1) OK CREATE TABLE H2011 (entryId varchar(15) not null,T0 number(15,0) NULL,U0 varchar(254) NULL,T1 number(15,0) NULL,U1 varchar(254) NULL,T2 number(15,0) NULL,U2 varchar(254) NULL,T3 number(15,0) NULL,U3 varchar(254) NULL,T4 number(15,0) NULL,U4 varchar(254) NULL) OK ... creates H, T, B tables and views ... ALTER TABLE T2011 ADD (C536870913 clob NULL) Still no indication that it is accounting for the storage in row. I'm sure it's there, I would just like to see it happening or be able to verify it somehow. Thanks, Thad On Mon, Feb 13, 2012 at 12:04 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: You will only see the clause if you add a 0 length character field (or a Diary or a field bigger than 4000 characters) as those are stored as a CLOB. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Monday, February 13, 2012 1:50 PM To: arslist@ARSLIST.ORG Subject: Question about Oracle-Clob-Storage-In-Row setting ** Hello, We are setting up a new 7.6.04 sandbox server (ARS on AIX, db is Oracle 11gR2) and reviewing our settings from prior versions. We've set Oracle-Clob-Storage-In-Row: T in the ar.conf. My understanding from reading the documents was that this setting causes ARS to add a clause to the CREATE TABLE statement so that clobs are stored in row. In the Using Oracle CLOBs with BMC Remedy Action Request System (March 2009, 89963) white paper it says: To specify the storage option at the Oracle database level, use the ENABLE|DISABLE STORAGE IN ROW clause of the CREATE TABLE statement. So with the setting set and sql logging turned on, I created a regular form, core fields only. This is the entire CREATE TABLE statement from the log: CREATE TABLE T2005 (C1 varchar(15) not null,C2 varchar(254) NULL,C3 number(15,0) not null,C4 varchar(254) NULL,C5 varchar(254) not null,C6 number(15,0) not null,C7 number(15,0) not null,C8 varchar(254) not null) Shouldn't there be a part of that that says STORAGE IN ROW or something similar? I tried googling for examples of what the SQL should look like, but didn't find anything definitive. Is there a way to see if STORAGE IN ROW has been set for that table? Out of curiousity, I ran the same test on our existing 7.1 dev server which has been running with that setting for years and got the same results. So I figure I'm misunderstanding something and would appreciate any insights. Thanks, Thad ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Question about Oracle-Clob-Storage-In-Row setting
Fred, This is what I got when I did a describe: SQL desc t2011 Name Null?Type - C1NOT NULL VARCHAR2(15) C2 VARCHAR2(254) C3NOT NULL NUMBER(15) C4 VARCHAR2(254) C5NOT NULL VARCHAR2(254) C6NOT NULL NUMBER(15) C7NOT NULL NUMBER(15) C8NOT NULL VARCHAR2(254) C536870913 CLOB SQL Axton's answer has satisfied my curiousity for now, so I'm not going to worry about this not matching. Thanks for replying. Thad On Mon, Feb 13, 2012 at 12:39 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: Do a Describe on the T table. In SQL Plus do DESC T2011; You should see something like LOB (C536870913) STORE AS ( ENABLE STORAGE IN ROW CHUNK 8192 Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Monday, February 13, 2012 2:26 PM To: arslist@ARSLIST.ORG Subject: Re: Question about Oracle-Clob-Storage-In-Row setting ** I was just testing that scenario as you responded. I created a new regular form, adding a character field with db length 8000 before the first save. This is what showed in the logs (clipped for brevity) when I did save it: CREATE TABLE T2011 (C1 varchar(15) not null,C2 varchar(254) NULL,C3 number(15,0) not null,C4 varchar(254) NULL,C5 varchar(254) not null,C6 number(15,0) not null,C7 number(15,0) not null,C8 varchar(254) not null) OK CREATE UNIQUE INDEX IT2011 ON T2011 (C1) OK CREATE TABLE H2011 (entryId varchar(15) not null,T0 number(15,0) NULL,U0 varchar(254) NULL,T1 number(15,0) NULL,U1 varchar(254) NULL,T2 number(15,0) NULL,U2 varchar(254) NULL,T3 number(15,0) NULL,U3 varchar(254) NULL,T4 number(15,0) NULL,U4 varchar(254) NULL) OK ... creates H, T, B tables and views ... ALTER TABLE T2011 ADD (C536870913 clob NULL) Still no indication that it is accounting for the storage in row. I'm sure it's there, I would just like to see it happening or be able to verify it somehow. Thanks, Thad -Original Message- On Mon, Feb 13, 2012 at 12:04 PM, Grooms, Frederick W wrote: You will only see the clause if you add a 0 length character field (or a Diary or a field bigger than 4000 characters) as those are stored as a CLOB. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Monday, February 13, 2012 1:50 PM To: arslist@ARSLIST.ORG Subject: Question about Oracle-Clob-Storage-In-Row setting ** Hello, We are setting up a new 7.6.04 sandbox server (ARS on AIX, db is Oracle 11gR2) and reviewing our settings from prior versions. We've set Oracle-Clob-Storage-In-Row: T in the ar.conf. My understanding from reading the documents was that this setting causes ARS to add a clause to the CREATE TABLE statement so that clobs are stored in row. In the Using Oracle CLOBs with BMC Remedy Action Request System (March 2009, 89963) white paper it says: To specify the storage option at the Oracle database level, use the ENABLE|DISABLE STORAGE IN ROW clause of the CREATE TABLE statement. So with the setting set and sql logging turned on, I created a regular form, core fields only. This is the entire CREATE TABLE statement from the log: CREATE TABLE T2005 (C1 varchar(15) not null,C2 varchar(254) NULL,C3 number(15,0) not null,C4 varchar(254) NULL,C5 varchar(254) not null,C6 number(15,0) not null,C7 number(15,0) not null,C8 varchar(254) not null) Shouldn't there be a part of that that says STORAGE IN ROW or something similar? I tried googling for examples of what the SQL should look like, but didn't find anything definitive. Is there a way to see if STORAGE IN ROW has been set for that table? Out of curiousity, I ran the same test on our existing 7.1 dev server which has been running with that setting for years and got the same results. So I figure I'm misunderstanding something and would appreciate any insights. Thanks, Thad ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Question about Oracle-Clob-Storage-In-Row setting
Sean, Yep, got that handled. Do you know if there is a more recent version of that white paper than the one I used from Oct 2009? Thanks, Thad On Mon, Feb 13, 2012 at 12:35 PM, Garrison, Sean (Norcross) sean.garri...@fiserv.com wrote: ** Just an FYI … enabling this feature does not go back and fix all of the tables that are storing your data “Out of Row”…. BMC has an oracle stored procedure for fixing that. See page 10 and 11 of the “Using Oracle CLOBs with BMC Remedy Action Request System” white paper. Doing so will reduce your db size considerably (assuming you enabled it after installing ITSM). ** ** Thanks, ** ** Sean ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Thad Esser *Sent:* Monday, February 13, 2012 3:26 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Question about Oracle-Clob-Storage-In-Row setting ** ** ** I was just testing that scenario as you responded. I created a new regular form, adding a character field with db length 8000 before the first save. This is what showed in the logs (clipped for brevity) when I did save it:* *** CREATE TABLE T2011 (C1 varchar(15) not null,C2 varchar(254) NULL,C3 number(15,0) not null,C4 varchar(254) NULL,C5 varchar(254) not null,C6 number(15,0) not null,C7 number(15,0) not null,C8 varchar(254) not null) OK CREATE UNIQUE INDEX IT2011 ON T2011 (C1) OK CREATE TABLE H2011 (entryId varchar(15) not null,T0 number(15,0) NULL,U0 varchar(254) NULL,T1 number(15,0) NULL,U1 varchar(254) NULL,T2 number(15,0) NULL,U2 varchar(254) NULL,T3 number(15,0) NULL,U3 varchar(254) NULL,T4 number(15,0) NULL,U4 varchar(254) NULL) OK ... creates H, T, B tables and views ... ALTER TABLE T2011 ADD (C536870913 clob NULL) Still no indication that it is accounting for the storage in row. I'm sure it's there, I would just like to see it happening or be able to verify it somehow. Thanks, Thad On Mon, Feb 13, 2012 at 12:04 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: You will only see the clause if you add a 0 length character field (or a Diary or a field bigger than 4000 characters) as those are stored as a CLOB. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Monday, February 13, 2012 1:50 PM To: arslist@ARSLIST.ORG Subject: Question about Oracle-Clob-Storage-In-Row setting ** Hello, We are setting up a new 7.6.04 sandbox server (ARS on AIX, db is Oracle 11gR2) and reviewing our settings from prior versions. We've set Oracle-Clob-Storage-In-Row: T in the ar.conf. My understanding from reading the documents was that this setting causes ARS to add a clause to the CREATE TABLE statement so that clobs are stored in row. In the Using Oracle CLOBs with BMC Remedy Action Request System (March 2009, 89963) white paper it says: To specify the storage option at the Oracle database level, use the ENABLE|DISABLE STORAGE IN ROW clause of the CREATE TABLE statement. So with the setting set and sql logging turned on, I created a regular form, core fields only. This is the entire CREATE TABLE statement from the log: CREATE TABLE T2005 (C1 varchar(15) not null,C2 varchar(254) NULL,C3 number(15,0) not null,C4 varchar(254) NULL,C5 varchar(254) not null,C6 number(15,0) not null,C7 number(15,0) not null,C8 varchar(254) not null) Shouldn't there be a part of that that says STORAGE IN ROW or something similar? I tried googling for examples of what the SQL should look like, but didn't find anything definitive. Is there a way to see if STORAGE IN ROW has been set for that table? Out of curiousity, I ran the same test on our existing 7.1 dev server which has been running with that setting for years and got the same results. So I figure I'm misunderstanding something and would appreciate any insights. Thanks, Thad ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
AUTO: Guru is on vacation (returning 02/16/2012)
I am out of the office until 02/16/2012. Hi All, I will be on leave from 14th 15th Feb. I'll have very limited access to mails during my vacation and will be checking emails once or twice in a day. Hence my response will be delayed. During my absence, please contact the following team members for any issues. Carphone Warehouse(Remedy) - Jogi Ruben/Rajini K Sanapala Hartford (Remedy) - Subbarao Kare LobLaw, - Rajini K Sanapala ServiceMaster(Remedy) - Shashidhar Vajjha GM (Remedy) - Mohana R Mamidi/Attili Srinivas IMPACT - Hidayathulla K Patan/ Karunakar Gouni All escalations should go to my manager Pratibha Allamaraju @ 'pratibh...@in.ibm.com'. Please send me an SMS for any requirement / issue that needs my attention and call me on my mobile @ +91-897 898 9843, for urgent issues. Thanks Regards, Guru Note: This is an automated response to your message How to create an archival server in remedy in windows platform!!! sent on 14/2/12 0:02:33. This is the only notification you will receive while this person is away. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: HPD Help Desk SLA
I don't believe that how it works in 7.1+, if you reopen a ticket it will reopen the same SLA and treat the period from when the SLA stopped to the reopen event as if the SLA was suspended, a new due date will be calculated and any remaining time on the SLA will be reinstigated. The parameter mentioned below allows this to happen Stuart Schon Service Desk Systems - Manager Fujitsu Australia Limited 2 Julius Avenue, North Ryde NSW 2113, Australia T +61 2 9113 9435 M +61 458 592 245 stuart.sc...@au.fujitsu.com mailto:stuart.sc...@au.fujitsu.com au.fujitsu.com http://au.fujitsu.com file:///C:\DOCUMENTS%20AND%20SETTINGS\SCHONST\Application%20Data\Micros oft\Signatures\Fujitsu_files\fujitsuemailsignature.gif From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Wirasat Siddiqi Sent: Tuesday, 14 February 2012 01:59 To: arslist@ARSLIST.ORG Subject: Re: HPD Help Desk SLA ** It will start a new SLA if you have set up the parameter 'Allow Service Target to Re-Open?' is set to Yes on SLA Measurement tab. Thanks, Wirasat Siddiqi Remedy Development Team Desk Phone: 202-502-3204 Cell: 202-368-7190 Email: wirasat_sidd...@ao.uscourts.gov From:Bhupesh Gupta gupta.bhupesh3...@gmail.com To:arslist@ARSLIST.ORG Date:02/13/2012 05:53 AM Subject:HPD Help Desk SLA Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG SLA for ticket re-open ? Does it reset and start fresh SLA , or continue to use the same SLA Please advise -- Regards, Bhupesh Gupta ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: AR Server or DB issue
Hi Ron I noticed the arAPPnote - indicating an approval notice. I've recently hotfxed our servers which were presenting us with ARERR 93 (server busy) or the same error you are getting (ARERR 92). Our servers would hang upon handling some approval actions. The symtom turned out to be unbelievable numbers of notifications being triggered - by a single Approval on a change. We got 13 entries in NTE:SYS-NT Proces Control for a single change. hotfix was SW00369891 Knowledgebase article is KA 354923 - just a hunch - but check your NTE:SYS-NT Proces Control form (or select from the Database if your server is unresponsive as ours was). br Jonas Den 10-02-2012 16:34, Peters, Ron skrev: ** Hello all, Having some AR server issues. Something has been happening in the mornings about 6am in that our service desk can't access Remedy. This started in Decemeber but only once. Then twice in January and now a couple times this week. The first few times it resolved itself after about 30 minutes but this week we had to restart the AR service on the server to get it back. The following is the arerror log from this morning. I've contacted our DBA's to see if they notice anything but since an AR restart resolves it, I'm not convinced it's a DB issue. Any thoughts? Thanks. Fri Feb 10 06:25:30 2012 AssignEng : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:25:30 2012 AssignEng : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:25:31 2012 SLMCS : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:25:31 2012 SLMCS : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:27:32 2012 AssignEng : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:27:32 2012 AssignEng : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:27:32 2012 SLMCS : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:27:32 2012 SLMCS : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:29:32 2012 AssignEng : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:29:32 2012 AssignEng : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:29:32 2012 SLMCS : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:29:32 2012 SLMCS : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:30:05 2012 BRIE : Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation (OUR_AR_SERVER) ARERR - 94 Fri Feb 10 06:31:32 2012 AssignEng : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:31:32 2012 AssignEng : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:31:32 2012 SLMCS : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:31:32 2012 SLMCS : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:33:32 2012 AssignEng : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:33:32 2012 AssignEng : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:33:32 2012 SLMCS : Timeout during database update -- the operation has been accepted by the server and will usually complete successfully (OUR_AR_SERVER) ARERR - 92 Fri Feb 10 06:33:32 2012 SLMCS : AR System Application server terminated -- fatal error encountered (ARAPPNOTE 4501) Fri Feb 10 06:35:02 2012 CMDB Dispatcher : Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation (OUR_AR_SERVER) ARERR - 94 Fri Feb 10 06:35:05 2012 BRIE : Timeout during database query -- consider using more specific search criteria to narrow the results, and retry the operation (OUR_AR_SERVER) ARERR - 94 Fri Feb 10
Re: What requests does the Needs Attention view display in SRM 7.6.04
Thanks for that clarificaton Peter, that solves a mystery for a lot of us and does make sense. The correlation with errors may well have been coincidence rather than cause and effect. Rod Harris On 14 February 2012 01:18, Adams, Peter peter_ad...@bmc.com wrote: Needs attention flag is set for all service requests in which a fulfillment worker has created a work info entry for the fulfillment record (incident, change, work order) and set it to public visibility. This is a signal to the requester to read the ActivityLog because it could contain important information that might need a response by the requester. Note that if the requester and the fulfillment worker who created the work info are the same user, the Needs Attention flag is not set. The Needs attention flag has nothing to do with error, and nothing to do with request requiring approval. The latter is reflected by status waiting for approval. We are updating the misleading statement in the documentation. Peter ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: spam warning
Back then it wasn't DANIELBLOOM.CA, though. I think that makes all the difference. And I didn't ask for a delete! I just asked for forgiveness. I will try to err more excitingly next time. Humor Friday fell on Tuesday this week, who knew? From: arslist arsl...@danielbloom.ca To: arslist@ARSLIST.ORG Sent: Monday, February 13, 2012 4:50 PM Subject: Re: spam warning ** That was then this is now. 15 years later and you are making the same dumb mistakes? I expect a whole new set by now, quite disappointing and uninteresting. And knowing you I really expected obscurely interesting ones. Happy to hear you like your current employer, much better than what people usually post by accident. Sorry, I only award the truly interesting things. Granted it is my rather suspect definition of interesting. Hey, no one has threatened to sue if I don’t delete a post in at least a couple of years, any takers? Daniel p.s. and the answer is no, the same answer I gave the US Armed Forces when they called me, I can’t delete a post, I can’t stop a post From:Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Louise Van Hine Sent: February 13, 2012 4:29 PM To: arslist@ARSLIST.ORG Subject: spam warning ** Dear Dan and the list, I just did this to prove that Yahoo's interface for private email replies still appends the group email address.It also qualifies me to get the Wake Up and Smell the Coffee award for the second time in my career. (The first time was spamming the ARSList in 1997 for which Dan promptly recruited me for Systemhouse. Actually it was just a dumb mistake. So I am really hoping he, and Wirasat, will forgive me. From:Louise Van Hine lvanh...@yahoo.com To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG; wirasat_sidd...@ao.uscourts.gov wirasat_sidd...@ao.uscourts.gov Sent: Monday, February 13, 2012 3:48 PM Subject: hey wirasat Are you still interested in a possible perm job? I believe you said you would get your permanent green card sometime in the spring... I would like to invite you to apply at Rightstar Systems. I love this company, and they provide all sorts of training and benefits, as well as CareFirst Blue Cross. The recruiter there asked me if I knew anyone I could recommend who is local to NoVa and of course thought of you. Please let me know and I can provide you with more information to answer your questions and introduce you to David Edwards, our recruiter. Take care now! Louise From:Wirasat Siddiqi wirasat_sidd...@ao.uscourts.gov To: arslist@ARSLIST.ORG Sent: Monday, February 13, 2012 9:58 AM Subject: Re: HPD Help Desk SLA ** It will start a new SLA if you have set up the parameter 'Allow Service Target to Re-Open?' is set to Yes on SLA Measurement tab. Thanks,Wirasat SiddiqiRemedy Development TeamDesk Phone: 202-502-3204Cell: 202-368-7190Email: wirasat_siddiqi@ao.uscourts.govFrom: Bhupesh Gupta gupta.bhupesh3...@gmail.comTo: arslist@ARSLIST.ORGDate: 02/13/2012 05:53 AMSubject: HPD Help Desk SLASent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG SLA for ticket re-open ? Does it reset and start fresh SLA , or continue to use the same SLA Please advise -- Regards, Bhupesh Gupta ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are