PL/SQL function call via set fields.
Greetings ,
we've a small function in Oracle 10g to return a transcoded/hashed
value for its input parameter., and are trying to use it for setting
the transcoded values into the DB.
we're running ITSM 7.0
my filter Set Fields SQL looks like this -
select get_hash('$current_field$') from dual;
the return value is assigned to the current field -
current_field = $1$
But whenever the filter is triggered, I see the following error. Any
idea how to get this fixed?
ARERR [552] Failure during SQL operation to the database : ORA-24374:
define not done before fetch or execute and fetch
My sqlplus prompt gives the correct response value for the function
call using the select statement.
BnB
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: PL/SQL function call via set fields.
I've checked in SQL Logs that the value of my current_field is being
passed on fine to the select Get_Hast('current value') from dual;.
Doesnt look like null value is a problem,
as the Filter qualification itself filters out null values.
checking out other suggestions on the thread.
On Nov 5, 12:10 am, Grooms, Frederick W [EMAIL PROTECTED]
wrote:
You may want to default the value in your get_hash function in Oracle
Try something like
CREATE OR REPLACE FUNCTION GET_hash (in_value VarChar2 :=
'somedefault') return VarChar2 is
for your function definition
This way if Remedy does not have a value for current_field when you call
the function it will use the default value
Another thing you may look at is to see exactly what Remedy is sending
to the database by looking in the SQL logs.
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Wallace, Kelvin
Sent: Tuesday, November 04, 2008 12:25 PM
To: [EMAIL PROTECTED]
Subject: Re: PL/SQL function call via set fields.
Hey B,
I think this is the same error I get whenever an attempt is made to use
the SELECT on the first attempt. But, it works on the second attempt
and every other attempt until Remedy server is restarted. The Oracle
error is basically saying that Remedy is not defining the variable
before it is getting to Oracle.
HTH,
Kelvin
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Bulls-n-Bears
Sent: Tuesday, November 04, 2008 1:16 PM
To: [EMAIL PROTECTED]
Subject: PL/SQL function call via set fields.
Greetings ,
we've a small function in Oracle 10g to return a transcoded/hashed
value for its input parameter., and are trying to use it for setting
the transcoded values into the DB.
we're running ITSM 7.0
my filter Set Fields SQL looks like this -
select get_hash('$current_field$') from dual;
the return value is assigned to the current field -
current_field = $1$
But whenever the filter is triggered, I see the following error. Any
idea how to get this fixed?
ARERR [552] Failure during SQL operation to the database : ORA-24374:
define not done before fetch or execute and fetch
My sqlplus prompt gives the correct response value for the function
call using the select statement.
BnB
___
UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Using Incident ServiceTgt Milestone Notification Action Templates
Greetings, we're running ITSM 7.0 Patch 002. And are trying to use Action templates on Milestones. I've NotifyIncidentOwner , NotifyIncidentOwnerGroup besides other templates., If I'm not wrong these are OOTB templates. But using them do not generate notifications on my system when milestone is met. If I use Custom - Alert or Email Action , with email Id fixed or use a new Action template with Alert or Email Action defined, Both of them are generating notifications , which was expected. I believe the workflow being triggered for using the Role Based Notification ., e.g., NotifyIncidentOwner , NotifyIncidentOwnerGroup needs to be looked into for isolating the problem. Is there a doc to help me with the sequence of workflow that's triggered and help me nail down the problem ? One thing I could figure is usage of filter guide HPD:INC:NotificationGenerator sets notification into NTE:SYS-NTProcess Control . How do I debug from here? Is the nofication triggered on an escalation ? or from a Notify action from a filter? Cheers, TIA ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Using Incident ServiceTgt Milestone Notification Action Templates
Lisa, That was a very detailed response. The behaviour I'm noticing could well be a defect. BTW, where do I access the details of the defects you've listed here ? I've got my hands on a document from here . This may be of help ., if you haven't got this yet. http://developer.bmc.com:8080/jiveProd/thread.jspa?messageID=73039#73039 Here's the behaviour I'm seeing on my system : 1) Action Templates for Role Based Notifications do NOT work 2) Using To/CC/BCC from Owners Menu Item on Custom Templates or Templates based on that do NOT work. I've two entries defined in SLM:ConfigSLMOwners form for Owners menu item, with mixture of valid email ids and user IDs. 3) Custom Actions or Action Templates based on Email or Alert work as expected. Is there any relevant defect info/ documentation that I can access? Cheers, BnB. On Jul 8, 7:21 pm, Lisa Westerfield [EMAIL PROTECTED] wrote: Without explaining every detail of some key SLM challenges, I thought it may be useful to share some of the results of what we have encountered with the SLM application and hopefully save you some time. If you need further details, please let me know. 1. The OOTB templates did not work for us either. We had to create identical templates for our milestones, actions, etc, that did exactly what the OOTB ones did for them to work. I have seen on more than 1 occasion that OOTB templates in general have lost their data connections and do not work as expected (i.e. People templates, SLM templates). 2. There is not a document that explains the notification structure, nor what the 'Message' tags do exactly. We asked about specific ones and got answers to them, but are still searching for additional information. (i.e. ESCALATEDBYOLA, ESCALATEMGRASSIGN). I'm not sure how this ticket is flagged, but this is the one we have open with BMC to get some of the answer on the SLM tags: SW00268723 3. We have been unsuccessful over the last 2 months to get any custom email action to work. We tried the same thing as you did - mailing a specific address - which doesn't work. We decided this was fine as long as the message tags in #2 notified the expected people, so no additional ticket was opened for our client. 4. The notifications you do receive may be missing some data (i.e. Status, Summary), and there is a partial fix for this from BMC, so don't waste too much time troubleshooting that one. Known Bug: SW00285647 5. SLM Viewer permissions do not work as documented. This is a known bug: SW00283951 6. Service Target Metrics report does not display the incidents that make up the group percentages. This is an open bug: SW00299164 7. SLM notifications do not consider the Business Hours of the support group. This is a known defect: SW00268723 8. SLM notifications do not consistently consider on-call paging times of support staff. This is still being investigated with BMC. 9. SLM Last Acknowledged Date on an incident is not set consistently. BMC is working on explaining when this should be set so we know if it's working or not. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bulls-n-Bears Sent: Tuesday, July 08, 2008 3:11 AM To: [EMAIL PROTECTED] Subject: Using Incident ServiceTgt Milestone Notification Action Templates Greetings, we're running ITSM 7.0 Patch 002. And are trying to use Action templates on Milestones. I've NotifyIncidentOwner , NotifyIncidentOwnerGroup besides other templates., If I'm not wrong these are OOTB templates. But using them do not generate notifications on my system when milestone is met. If I use Custom - Alert or Email Action , with email Id fixed or use a new Action template with Alert or Email Action defined, Both of them are generating notifications , which was expected. I believe the workflow being triggered for using the Role Based Notification ., e.g., NotifyIncidentOwner , NotifyIncidentOwnerGroup needs to be looked into for isolating the problem. Is there a doc to help me with the sequence of workflow that's triggered and help me nail down the problem ? One thing I could figure is usage of filter guide HPD:INC:NotificationGenerator sets notification into NTE:SYS-NTProcess Control . How do I debug from here? Is the nofication triggered on an escalation ? or from a Notify action from a filter? Cheers, TIA ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are This message is subject to and does not create or vary any contractual relationship between TuringSMI, SMI Technologies, SMI Telco, its subsidiaries or affiliates and you. Internet communications are not secure and therefore the TuringSMI Group does not accept any legal responsibility for the contents of this message. Any views or opinions
Log Files Size Limit
AR Gurus, I'm running AR System 7.0 on Solaris 9 , and my logging is turned on for filters , sql and api. Within a few hours ( ~ 10 hrs ) , my filter logs are reaching 2.0 G and not taking any more log messages. we havent configured the log size limit from Admin tool. Is there anyway I can configure the system to keep pumping more log messages ? or rotate the logs ? move after limit reached and use new one etc? Cheers, BnB ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Log Files Size Limit
If you turn on rotating log files, you can backup the file at an interval that makes sure you does not loose data. Could you please tell me how I can do this ? Cheers, BnB On Jun 13, 12:56 pm, Misi Mladoniczky [EMAIL PROTECTED] wrote: Hi, I just saw the same thing at a customer site. The maximum file size seems to be 2 GB on their Unix-server. Maybe this limit can be increased on the OS level? If you turn on rotating log files, you can backup the file at an interval that makes sure you does not loose data. You can then remove any duplicate rows by looking at the previous backup file. Best Regards - Misi, RRR AB,http://rrr.se AR Gurus, I'm running AR System 7.0 on Solaris 9 , and my logging is turned on for filters , sql and api. Within a few hours ( ~ 10 hrs ) , my filter logs are reaching 2.0 G and not taking any more log messages. we havent configured the log size limit from Admin tool. Is there anyway I can configure the system to keep pumping more log messages ? or rotate the logs ? move after limit reached and use new one etc? Cheers, BnB ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Log Files Size Limit
Could you please tell me how I can do this ? Cheers, BnB Sorry , or did you mean general cron job backups ? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: SLM Export
The Data File Path/Name should be anything ( absolute path ) on your Solaris Server. I for eg., have exported Service targets agreements to my /local/ Remedy/ServerName/SLM_Exports.arx ( am on Solaris 9 Server ) HTH, On Jun 4, 8:53 pm, versicle [EMAIL PROTECTED] wrote: All, Has anyone used the Export/Import feature of ITSM 7 for SLM. It's located in the Application Admin Console. I've looked at the User Guide for and SLM and it isn't very helpful for telling me what needs to go in the Data File Path/Name field. Any guidance or examples would be appreciated. Thanks. We are running ARS 7.1 and ITSM 7.0.03 on Solaris 10 Mike -- View this message in context:http://www.nabble.com/SLM-Export-tp17650049p17650049.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Error on Change Template Tasks ( ARERR 45093 )
Great :) It works now . thanks so much, BnB, On May 28, 4:48 pm, T. Dee [EMAIL PROTECTED] wrote: You can not start working on the Task(s) until the Change is in Implementation in Progress. On 5/28/08, Bulls-n-Bears [EMAIL PROTECTED] wrote: Greetings All, Am trying to create a new change ticket using a change template. The ticket got created successfully . When I now switch to Tasks tab and try closing a task with Status reason as Success., I recieve the following error. This task (or group) must be activated (from the parent) before it can be changed to the status: Closed Success (ARERR 45093). The change ticket is freshly created. The Task template is successfully attached to the ticket and I'm seeing the three tasks coming in from the template in Tasks tab. My env : ITSM 7.0 on Solaris and User Tool ( 7.0) on WinXP. Any ideas how to fix this ? Cheers, BnB ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
arsignal returns exit status = 3
Greetings All, We're running AR System 7.0 on Solaris 9. While using the arsignal command , with various flags available, it always returns Exit 3 . Any idea how to interpret the error ? and how to fix this ? #arsignal -c myhostname Exit 3 Cheers, BnB ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: arsignal returns exit status = 3
Could someone help me with this pls ? Cheers On May 29, 6:10 pm, Bulls-n-Bears [EMAIL PROTECTED] wrote: Greetings All, We're running AR System 7.0 on Solaris 9. While using the arsignal command , with various flags available, it always returns Exit 3 . Any idea how to interpret the error ? and how to fix this ? #arsignal -c myhostname Exit 3 Cheers, BnB ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Error on Change Template Tasks ( ARERR 45093 )
Greetings All, Am trying to create a new change ticket using a change template. The ticket got created successfully . When I now switch to Tasks tab and try closing a task with Status reason as Success., I recieve the following error. This task (or group) must be activated (from the parent) before it can be changed to the status: Closed Success (ARERR 45093). The change ticket is freshly created. The Task template is successfully attached to the ticket and I'm seeing the three tasks coming in from the template in Tasks tab. My env : ITSM 7.0 on Solaris and User Tool ( 7.0) on WinXP. Any ideas how to fix this ? Cheers, BnB ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Widescreen Remedy User Tool Display 1440 x 900 Resolution
Sandeep, I've tried this but that didnt change anything. where do i check the window resolution settings ? btw, what are the values given for server window and frame window ? :) On May 15, 1:07 pm, ITSM Support [EMAIL PROTECTED] wrote: Hi Bulls-n-Bears, The problem can be resolved by setting AR User Tool--Home Page-- Administrative Preferences--My Admin--Window Location The values for following fields should be--- Server Window = -137 99 1020 324 250 1 Frame Window = 143 52 768 537 1 Note--Check your Window Resolution Settings also. Hope this helps Regards. *Sandeep .* *Vyom Labs Pvt. Ltd. An ISO 2 certified company. Consulting | Outsourcing | Training || BMC Remedy BSM | ITIL Web :www.vyomlabs.com * Bulls-n-Bears wrote: Greetings Listers, There's almost 40% of my screen on right side that's blank . User forms/objects are displayed only towards the left rectangle. Is there any setting/config I need to perform so I'd be able to utilize my display ? Mine is a wide screen monitor and the aspect ratio remains like this . Anyone who could help ? Cheers ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Widescreen Remedy User Tool Display 1440 x 900 Resolution
Greetings Listers, There's almost 40% of my screen on right side that's blank . User forms/objects are displayed only towards the left rectangle. Is there any setting/config I need to perform so I'd be able to utilize my display ? Mine is a wide screen monitor and the aspect ratio remains like this . Anyone who could help ? Cheers ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
