RE: Escalation Error

[Hiremath, Raj]

I guess you are making an equal to query on clob data type.
What all is on stack on AR?

Esclation+API+SQL logs may help find the piece.

From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Brittain, Mark
Sent: 19 September 2018 02:02
To: ARList (arslist@ARSLIST.ORG) 
Subject: Escalation Error

HI All

I am seeing two strange escalation errors that I can't identify based on the 
logs.

An application command failed.ERROR (552): The SQL database operation failed.; 
ORA-00932: inconsistent datatypes: expected - got CLOB`

Error while performing escalation action

Both are in pool 1.

I have been able to rule out any custom escalations, very few, and am hoping 
not to have to check each OTB escalation if hopes of finding the bad guys. Has 
anyone encountered this.

ARS 9.1.4.

Thanks
Mark

Mark Brittain  | Senior Systems Engineer | 315.634.9337
125 Elwood Davis Road | Syracuse NY 13212
[new_spectrum]

-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: [EXTERNAL] Re: What's new in ARS 9.x?

[Hiremath, Raj]

Dustin, do you use CMDB?

Sent from my iPhone

> On Nov 27, 2017, at 8:50 AM, Fawver, Dustin  wrote:
> 
> Mr. Adams,
> 
> Would you be so kind as to give us some hints or teasers about things that 
> are coming very soon?  I'm hoping that they aren't limited to things that are 
> in products that are outside of the base ARS package.  If you've seen some of 
> my previous posts, you may remember that I was _REALLY_ looking forward to 
> ARS getting the capability of showing "mobile-friendly" versions forms.  I 
> read over AngularJS so that I could be that much better prepared for it.  
> From what I've been told, what had been billed as ARS 9.5 resulted in just 
> Innovation Studio branching out as a separate product.
> 
> Please don't get me wrong.  Going from ARS 9.1 from ARS 7.1, I'm finding some 
> really nice stuff that I can do now that I couldn't do as well (if at all) on 
> 7.1.  I just need to be able to give members of management a "wow!" feeling 
> with ARS.  If I can do that, I can probably coax out some funding to procure 
> more licenses.  :-)
> 
> Thanks!
> 
> Dustin Fawver
> Sr. Help Desk Technician
> Information Technology Services
> 
> P: 423-439-4648
> itsh...@etsu.edu
> 
> 
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Adams, Peter
> Sent: Sunday, November 26, 2017 9:05 PM
> To: arslist@ARSLIST.ORG
> Subject: [EXTERNAL] Re: What's new in ARS 9.x?
> 
> 
> There’s a couple of places where BMC documents what’s new in Remedy 9  (both 
> 9.0 and 9.1)
> 1) Product documentation. This is the most detailed info. For Remedy AR 
> System, please see a. 
> https://linkprotect.cudasvc.com/url?a=https://docs.bmc.com/docs/display/ars91/9.1.00%20enhancements&c=E,1,CyP7w5HP2LWhB-ftkkZqc9Dg0qwSUdTuGeu3NA2ovpMvUIrIMpBz6makRgn8tyBtGaix7GKfcb4rHBtKUlYLcRfuMY04hADw1PHMysRSGh2oDDA3VC9kIg,,&typo=1
> b. 
> https://linkprotect.cudasvc.com/url?a=https://docs.bmc.com/docs/display/ars91/9.1.02:%20Service%20Pack%202%23id-9.1.02:ServicePack2-Enhancements&c=E,1,-rT_F8M7TDA7UW4bp5Mnce58l2htlUOHKr9v_TVzJZ5b1EEo9ewmZnpHrthz5d61jJSa0NkESZKMql8YO6BMwSbM-HUtO8Nt9ASyMH5HFw,,&typo=1
> c. 
> https://linkprotect.cudasvc.com/url?a=https://docs.bmc.com/docs/display/ars91/9.1.03:%20Service%20Pack%203%23id-9.1.03:ServicePack3-enhancements&c=E,1,k496xlAP8aAEcGDTpKRTGJRoSKT2FiWe_46qsp38qX8hF8GcWST9Bhyf2wZe9hnxuefuizS6zAoC-ebYCxMwJ9UKB0hvk7MLBxlagTTDfQI,&typo=1
> d. 
> https://linkprotect.cudasvc.com/url?a=https://docs.bmc.com/docs/display/ars9000/9.0.00%20enhancements&c=E,1,q_e1SJq-52hiiTaIEFdb4E4u5O4FoWpGh-bW18qElKVfCsJMMR0YD_6huRGhWhUa9vJ8hN62ABKpyJnt320s1sClfZ3e5qc_Fmvi2bYdrMVZhDFvkWfpzF6p&typo=1
> 2) 
> https://linkprotect.cudasvc.com/url?a=https://www.bmc.com/it-solutions/remedy-upgrade.html&c=E,1,jSFTX8MPUY9n-1gYR33HYP6OtVLNpDCXGVcpFvk29rMeqY2QIck3JcemCSsUcDv0R_xrHkbscheX5lLV-RUJFtbCyUB6iG4MImpZFrpalPtKhyDgng,,&typo=1
>   (note: this covers both ITSM application and platform enhancements. The 
> platform related ones are mostly in tab “Lower Total Cost of Ownership”
> 3) 
> https://linkprotect.cudasvc.com/url?a=https://communities.bmc.com/community/bmcdn/bmc_it_service_support/blog/2017/08/20/gaining-additional-capabilities-and-value-by-moving-from-remedy-81-to-91&c=E,1,_vMDaemNriOZDb6oII_8nUTlVFcWALkl5KcovuSf4LIY6nodvzsN6c7ug4mmgMG4TXeTY-NpQRKMPHVlqgreVw6q6_aet0Lo96uA_XdREx0,&typo=1
> 
> If you need presentation material, I suggest that you work with your BMC 
> Sales or partner representative.
> 
> BTW, lots of features in the Remedy platform introduced with Remedy 9, not 
> just Smart Reporting. Just to give a few examples:
> - 100% Java implementation of platform (which allows to do troubleshooting, 
> tuning, etc. using standard Java tools)
> - FTS performance and relevancy improvements
> - REST API
> - Deployment Application
> - Archiving / Associations
> - Remedy SSO
> - Zero downtime upgrades
> - New Rich-text Editor
> - CMDB enhancements
> - Centralized Configuration
> 
> And more is coming very soon …
> 
> Peter
> 
> 
> 
> On 11/21/17, 4:29 AM, "Action Request System discussion list(ARSList) on 
> behalf of Toby Mitchell"  toby.w.mitch...@gmail.com> wrote:
> 
>Check out Smart Reporting. Best thing I have seen in my 16 years as a 
> Remedy developer.
> 
>Toby
> 
>Sent from my iPad
> 
>> On Nov 20, 2017, at 3:03 PM, Thomas Miskiewicz  wrote:
>> 
>> Hello Listers,
>> 
>> is there a document / presentation that describes what’s new in ARS 9 and 
>> 9.1? I’m especially interested in the ARS part vs. ITSM/MyIT related 
>> features.
>> 
>> 
>> Thanks
>> 
>> 
>> Thomas
>> 
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at 
>> https://linkprotect.cudasvc.com/url?a=https://www.arslist.org&c=E,1,cA3azoxZ7QzlKhrND3_RuOKDMcR9wMXYrLZVDsrmLChqAfoGOBwPkmRd7wYhqdBamVZPhjkABp_Ze3ZyC2z3tyqJejxntjZU2McynQ,,&typo=1
>> "Where the Answers Are, and have been for 20 years

Re: v.9.1.3 upgrade fails

[Hiremath, Raj]

I am not sure if I am correct here, but not sure if the failure is for your 
user or Remedy Application Service user since you are saying reported failure 
is for ‘AR System Server Admin’ user.
This can potentially because the RAS user password in ar.cfg is corrupted.
AR Server restart might correct this.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joel D Sender
Sent: 14 June 2017 21:28
To: arslist@ARSLIST.ORG
Subject: v.9.1.3 upgrade fails

**
I’ve got a ticket at BMC for this, but I thought the ARSlist might have some 
insight:

I am attempting to upgrade ARS 8.1 to 9.1.3 (or 9.1.2 – same problem).
Both versions complain that the ‘AR System Server Admin’ user fails 
authentication.
I’ve verified that ‘Demo’ and my ID can login to the server with the same 
passwords entered into the upgrade dialog.

BMC support has requested LOG files from the install, but after extensively 
searching the disk, no log files are found.

Anyone bump into this before?
Thanks,
Joel
Joel Sender  *   jdsen...@earthlink.net


[https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif]

Virus-free. 
www.avast.com

_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"

Re: Alumni People Management in ITSM7.6.04

[Hiremath, Raj]

Good use case for Process Designer!

We have all the back end processing, we have a standard and transparent 
“business process” which is not hidden in code (workflows or java/c other 
standard binaries), you can club it with other off-boarding processes.

-Raj

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Saturday, January 31, 2015 22:57
To: arslist@ARSLIST.ORG
Subject: Re: Alumni People Management in ITSM7.6.04

**
Harsh,
Ask your organization what they want done with any tickets assigned to the 
'terminated' personyou could either automatically make all of them 
'unassigned', or you could choose, at random, the first person in the list, or 
something like thatbut you can do something with those tickets, you just 
need to have a consensus of what is supposed to happen.

On Sat, Jan 31, 2015 at 10:05 AM, Harsh 
mailto:chaudhar...@gmail.com>> wrote:
**
Hi Guys,

I got one of the business requirement where support lead wants that if a person 
left organisation then that person should automatically get removed from their 
support group.

initially i thought to write a filter to delete the record of the that person 
from people form on modify action if the termination field(its a custom field 
which gets populated from one other integration when person leave the 
organisation) date is greater then current time stamp.

But that will not resolve the issue as if that person have some ticket assigned 
then that will always stuck on his name.

If I try to automate the option to make the person non support staff available 
on left side in quick links of people form then again there is a clause that 
the person should not have any ticket assigned to their name.

can you guys help out the best idea to deal with this requirement as i more 
feel like it should be a process level thing rather then a customization.

Your ideas are welcome.. Thanks in Advance..

Regards,
Harsh
Where there is a question.. there is an answer..

_ARSlist: "Where the Answers Are" and have been for 20 years_

_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"