Re: Yet another tenancy question...SOLVED
Okay - so this actually works if you do this: Put all people in COmpany A. This includes all of your support staff. Create a company B and C. In the Support Company Access Configuration, set company B and C as a Support company for Company A. Create support groups under company B and C. In the people records for a support group for company B, LEAVE their company on the General tab as company A. But update their access restriction on the permissions tab to only allow access to company B. Repeat for people under company C. Now the people in B and C will be able to create incidents for people in Company A, but Company B and C will NOT be able to see each other's incidents at all. Supervisors/Managers, etc can of course have their access restriction set to include any/all of the companies so they can see everything. This also requires you set some things to Global (Service+) if you want to share those across the board. There are some interesting workflow things you may or may not want to deal with. I'm still working those out. For example, when you create or update a people record it automatically changes the access restriction company to the company on the General tab. We may disable this. William Rentfrow wrentf...@stratacominc.com Office: 715-204-3061 or 701-232-5697x25 Cell: 715-498-5056 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carl Wilson Sent: Friday, February 27, 2015 10:11 AM To: arslist@ARSLIST.ORG Subject: Re: Yet another tenancy question... ** Hi, This is working as expected. As you mentioned, Multi-tenancy is based on either of those fields on an Incident so as long as you have membership to one of the Group ID's you will see the Incident. So if Support Group 1 has access to the Customer common Company, then they would see all requests, same for Support Group 2, etc as tenancy is done at the Company level. To separate out this there is the concept of Supporting Companies introduced I think around version 7.6 where you can have a Support Company work a request (Assignment) without the need to give them full Company access and they only see those requests - however I believe this uses the Vendor fields to control access so can be somewhat tricky to setup. You could not have the common Company for the People though as the above still applies. Kind Regards, Carl Wilson http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow Sent: 27 February 2015 15:42 To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Yet another tenancy question... ** Hi all- ARS 8.1.02, ITSM 8.1, etc - totally Remedy workflow question - architecture doesn't matter. We are doing a test configuration on our dev server trying to configure multi-tenancy as follows: 1.) All People records belong to a company MyCompany 2.) Support users are in a company for their business unit, e.g. Group 1, Group 2, etc. To be very clear, these are defined as separate companies - they are NOT under MyCompany. 3.) We do not have unrestricted access turned on for anyone. - so if an incident is assigned to Group 1 we do not want Group 2 to be able to see it at all. The entire point of doing the above setup is to have one copy of each people record shared among everyone - otherwise the only real option is to load a separate copy of the people record for every defined company - and we're talking about millions of records in that instance. All of those would have to get updated weekly in order to keep things up to date, so that's kind of a non-starter. Or we could customize multi-tenancy, which seems like path fraught with peril... The tenancy documentation I read says that tenancy and row level security is based off of three things in 8.1: Customer Company for field 112, Support Company on field 60900, and Vendor Assignee groups. I was under the impression that permissions were additive - so, if there was a value in any of those three fields your People profile had to match all of them for you to be able to see the incident. I checked the permissions on Entry ID (Field 1) in HPD:Help Desk and they match this as advertised (Unrestricted access membership is also one of the permission groups for field one but no one is defined as unrestricted in my test setup). The problem is I don't think it's working right. The value that gets set for field 112 is the value of the customer's company, NOT the assigned group's company. Having the incident assigned to a group under a separate company has no real effect on anything. I checked the data and the field 60900 is filled in with the correct value of the Group entry that matches the assigned support company. Consequently, anyone can see all of the incidents, regardless of what company they are in. How do we go about getting this
Re: web service logging
I can run the published wsdl that is in the Web service by pasting that URL in my browser. So yes... However when I call the code that is in my external asp page it's does not run yet that is the Same results as when I point my asp script to production and the production interface works fine Sent from my T-Mobile 4G LTE Device Original message From: Terry Bootsma tboot...@objectpath.com Date: 03/11/2015 1:34 PM (GMT-05:00) To: arslist@ARSLIST.ORG Subject: Re: web service logging ** Scott: On your dev mid-tier, can you access the WSDL and the web-service end-point that defines your web service (via a browser) to ensure that your mid-tier has the web service defined and available ? If it is available, it doesn't even look like the calling program is hitting your midtier at all and I would debug from that point. Terry On 2015-03-11 13:22, Scott Hallenger wrote: If you can see my previous post with attachment. my Midtier logs isnt showing anything relating to a web service. The cache clear that you see in the log was long before i made any calls to the web service. On Wed, 3/11/15, Terry Bootsma tboot...@objectpath.com wrote: Subject: Re: web service logging To: arslist@ARSLIST.ORG Date: Wednesday, March 11, 2015, 12:46 PM ** Scott: If you are consuming your remedy-based web service from another application (other than Remedy itself) , it will not utilize the java plugin server. The java plugin server is only used for outbound web-service calls from Remedy. You should be able to see your web services being called in the mid-tier log. From there, you would have to enable filter/API logging on your Remedy server to debug further. HTH Terry On 2015-03-11 12:18, Scott Hallenger wrote: Hi can anyone help me find my webservice loggs? We have a web service that creates an incident in ttsm 7.0.1. it work in our prduction invironment, but the moment we re-point it to our dev system it does not generate the incident. The midtier web service logs dont really show anything useful. What I'm really looking for is the arjavaplugin.log file which does nost seem to exist. I am seriously frustrated at this point. I do not have the ability to install soapUI in my environment so I have to rely on the log if I can find it... help please. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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 _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: Incident template with tasks - no tasks?
Thank you guys… I suppose it just made sense in my head to have this. I haven’t used PD very much -just to do some basic FTP. I struggled to find documentation on it. –I may end up doing it thru workflow. Speaking of ideas.. have you seen any of your “ideas” added into ARS/ITSM? Thx, Marcelo From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Dmitry Baryshnikov Sent: Thursday, March 12, 2015 1:59 AM To: arslist@ARSLIST.ORG Subject: Re: Incident template with tasks - no tasks? ** Jason is right: now you can attach the task templates only to the changes. Is there an option to use the Process Designer? You could try to develop a process that would create the tasks after the Incident had been created. Regards, Dmitry Baryshnikov On Mar 12, 2015 9:23 AM, Jason Miller jason.mil...@gmail.commailto:jason.mil...@gmail.com wrote: ** It doesn't look like it is an option for incidents (so your not missing anything). There is an Idea (RFE) to add it here: https://communities.bmc.com/ideas/7438https://urldefense.proofpoint.com/v2/url?u=https-3A__communities.bmc.com_ideas_7438d=AwMFaQc=jPeYnCWs4C2yfrLNmdUWFQr=8S4PwC_PU4Zrhf0I-QKdBApCVXq7qcpID-QxJedHlNkm=YVqjqKk0U_mwlwwtSBZH2oTlHQTyYbcp2XZ9K4QGs1Qs=Ft7RhEMM2becrxlMCbSOzlpXAYk5bp6MaJd2MuA2dVUe= Jason ** Hello List, I’m trying to create an incident template that includes about 3 tasks. – or maybe a task group template (don’t know if this is necessary). Ultimately this incident template will be consumed by the “Rule Base Email Engine” to create an incident from an email. The issue I have is that my incident template does not have a tab for tasks… huh? Shouldn’t it have a tab for tasks?? Ideally I would of liked for the RBE to create 3 incidents from one email. But I have not found a way to do that w/o customizing. Or… if the email could create an SRM request that was tied to a PDT that created 3 incidents.. would be perfect. ☺ ARS/ITSM 8.1.01 Thanks, Marcelo _ARSlist: Where the Answers Are and have been for 20 years_ _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
Re: BIRT report: Previous month function; and ability to schedule?
Susan, Just thoughts off the top of my headon button press 1 - using MONTH and YEAR functions, collect tmp values for last month, last year, current month, and current year for $DATE$ 2 - Do some sort of calculation that determines if last month is 0, then set it to 12, and if last month is 12, set last year -1 (to capture Dec last year) 3 - Set a Date/Time field = $lastMonth$/1/$lastYear$, set another to $currentMonth$/1/$currentYear$ 4 - now that you have the date/time values for the first of the month for last month, and the first of the month for this month, do an open window action of type report, utilizing the new calculated date/time values from step 3 as qualification of what should be in the report In theory, that should 'always' work for last month data, ensuring the query is 'DateTime' = $lastMonthDate$ AND 'DateTime' $thisMonthDate$. This query of course runs in 'your' timezone, so results may vary depending on who presses the button and what timezone they are in...but should work pretty good. On Thu, Mar 12, 2015 at 7:34 AM, Champagne, Susan schampa...@hsnsudbury.ca wrote: ** Hi folks, I am struggling with trying to get the correct syntax, using BIRT Functions, to acquire results for “last month”. I am simply trying to pull the list of tasks that were assigned to a particular group. So, for example, I will run the report in any day of March, and the results should display all data from the month of February. Then, in April, I will expect the results to display the March data. I have found several suggestions, online, but none have given the correct results. Also, if you know of a means of scheduling a report to be e-mailed automatically, from Remedy, please let me know. Using ITSM 7.6.04. Your assistance with these questions is most appreciated. Thank you, Susan Champagne Health Sciences North's vision is to be globally recognized for patient-centred innovation. The information contained in this e-mail and document(s) attached are for the exclusive use of the addressee and may contain confidential, privileged and non-disclosable information. If the recipient of this e-mail is not the addressee, such recipient is strictly prohibited from reading, photocopying, distributing or otherwise using this e-mail or its content in any way. _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
Remedy Mid Tier Menu Mouse Scroll Wheel?
Hello, We are using Remedy 8.1.00 Mid Tier 8.1.01 (SP1) 201406260451 Hotfix. Our users are unable to use the scroll wheel on their mouse to navigate any of the drop-down menus in the system. Any ideas on how to accomplish this or are we out of luck without the client? Below are 2 examples of what I'm referring to. Customer Search [cid:image005.png@01D05CAA.E2707180] Assigned Group [cid:image001.png@01D05CAA.B0829D10] [Description: Description: cid:411C7191-C84A-4BC4-84A6-03A2A02A75D5] Connect with us:interpublic.comhttp://www.interpublic.com/ Twitterhttps://twitter.com/#%21/interpublicipg Facebookhttps://www.facebook.com/InterpublicGroup Levi Lippincott / Remedy Administrator +1 402 561 7014 office +1 402 321 5421 mobile levi.lippinc...@interpublic.commailto:levi.lippinc...@interpublic.com Lync Communcatorsip:levi.lippinc...@na.corp.ipgnetwork.com Interpublic Group 6825 Pine Street, Omaha, NE 68106 Talent is a Gift; But Character is a Choice. -Matt Grotewold- This message contains information which may be confidential and privileged. Unless you are the intended recipient (or authorized to receive this message for the intended recipient), you may not use, copy, disseminate or disclose to anyone the message or any information contained in the message. If you have received the message in error, please advise the sender by reply e-mail, and delete the message. Thank you very much. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Redirect to a View on Query - SOLVED
Hi All, Thanks for your help. I asked another friend for help and we both came up with a solution. Both worked but the first one was easier so I went with that. #1 - Execute on Window Open Qualification: ($OPERATION$ = QUERY) AND ($VUI$ = Default Administrator View) Action #1 - Open Window in Search Mode New Default Admin View Action #2 - Close Window #2 - Execute on Window Loaded Qualification: ($OPERATION$ = QUERY) AND ($VUI$ = Default Administrator View) Action #1 - Set Temp Field to Searching Action #2 - Close Window 2nd Active Link Execute on Window Closed Qualification (zTemp = Searching) Action #1 - Open Window in Search Mode New Default Admin View I asked a friend for help and we both came up with a solution at the same time. Regards, == Julia James Application Developer and Support, IC3-SMI for Remedy and Impact ITIL® V3 Foundation Certified IBM Corporation, GTS - Strategic Outsourcing Delivery Office: 860-275-5625 (External) Internet: julia.ja...@us.ibm.com Address: 106 Moosehorn Road, Northfield, CT 06778 “Try to help others, if you are not able to be of help, then at least do them no harm.” Dalai Lama From: Jayesh jhpancha...@gmail.com To: arslist@ARSLIST.ORG Date: 03/10/2015 12:34 PM Subject:Re: Redirect to a View on Query Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** You can compare the VUI in run if with the same view which u want on search and if not same ,you can write if action to open the desired view in open window From: Julia James Sent: 10-03-2015 10:38 PM To: arslist@ARSLIST.ORG Subject: Re: Redirect to a View on Query ** Actually it doesn't matter, as long as the search results are in the correct view it doesn't matter which view the search screen starts on. I need the NewDefaultAdminView (Form Alias: MECHModify). The way I have it currently set up is that the DefaultAdminView has a message on the top in Query Mode that says You are not in the correct search screen, click the Search button. The Search button will redirect the user to the correct view. The customer is not too happy with that option because he feels it should automatically bring him to the correct search window. Regards, == Julia James Application Developer and Support, IC3-SMI for Remedy and Impact ITIL® V3 Foundation Certified IBM Corporation, GTS - Strategic Outsourcing Delivery Office: 860-275-5625 (External) Internet: julia.ja...@us.ibm.com Address: 106 Moosehorn Road, Northfield, CT 06778 “Try to help others, if you are not able to be of help, then at least do them no harm.” Dalai Lama From:Jayesh jhpancha...@gmail.com To:arslist@ARSLIST.ORG Date:03/10/2015 12:01 PM Subject:Re: Redirect to a View on Query Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** Do you want default search view to be shown as the newly created view? Or once you search the data,it should open in a new view? From: Julia James Sent: 10-03-2015 10:18 PM To: arslist@ARSLIST.ORG Subject: Redirect to a View on Query ** Hi, I am on Remedy 7.5 and the customer use Remedy User and not the web to access the application. I'm trying to write some code that on Query the system will redirect the user to another view. So when the user opens the form in search mode from the Object List it will bring them to the view. This is my form information. Form Name: MECH:Tkt Form Alias: MECH Ticket Form View Label: Default Administrator View Form Alias: MECHModify Form View Label: NewDefault Administrator View I have tired using Run Process for Application-Get-Form-Name and Application-Get-Form-Alias but I don't have the syntax right. I have tried every possible combination I can think of. My workflow is firing on Window Loaded with a Qualification on $OPERATION$ = QUERY When the system opens in Query I get the following RunProcess Active Link: Problem: Hint: The system cannot find the file specified. Any help would be appreciated. Julia James _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _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
Re: BIRT report: Previous month function; and ability to schedule?
Thank you for your response LJ. I’m a real novice, so, as logical as your suggestion is, it is a little intimidating to me. I was really hoping there would be a simple BIRT function, that would work. I’ll continue to play with it, and hopefully eventually find the solution. Susan Champagne From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: March-12-15 9:49 AM To: arslist@ARSLIST.ORG Subject: Re: BIRT report: Previous month function; and ability to schedule? ** Susan, Just thoughts off the top of my headon button press 1 - using MONTH and YEAR functions, collect tmp values for last month, last year, current month, and current year for $DATE$ 2 - Do some sort of calculation that determines if last month is 0, then set it to 12, and if last month is 12, set last year -1 (to capture Dec last year) 3 - Set a Date/Time field = $lastMonth$/1/$lastYear$, set another to $currentMonth$/1/$currentYear$ 4 - now that you have the date/time values for the first of the month for last month, and the first of the month for this month, do an open window action of type report, utilizing the new calculated date/time values from step 3 as qualification of what should be in the report In theory, that should 'always' work for last month data, ensuring the query is 'DateTime' = $lastMonthDate$ AND 'DateTime' $thisMonthDate$. This query of course runs in 'your' timezone, so results may vary depending on who presses the button and what timezone they are in...but should work pretty good. On Thu, Mar 12, 2015 at 7:34 AM, Champagne, Susan schampa...@hsnsudbury.camailto:schampa...@hsnsudbury.ca wrote: ** Hi folks, I am struggling with trying to get the correct syntax, using BIRT Functions, to acquire results for “last month”. I am simply trying to pull the list of tasks that were assigned to a particular group. So, for example, I will run the report in any day of March, and the results should display all data from the month of February. Then, in April, I will expect the results to display the March data. I have found several suggestions, online, but none have given the correct results. Also, if you know of a means of scheduling a report to be e-mailed automatically, from Remedy, please let me know. Using ITSM 7.6.04. Your assistance with these questions is most appreciated. Thank you, Susan Champagne Health Sciences North's vision is to be globally recognized for patient-centred innovation. The information contained in this e-mail and document(s) attached are for the exclusive use of the addressee and may contain confidential, privileged and non-disclosable information. If the recipient of this e-mail is not the addressee, such recipient is strictly prohibited from reading, photocopying, distributing or otherwise using this e-mail or its content in any way. _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ Health Sciences North's vision is to be globally recognized for patient-centred innovation. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Time to Install ITSM 8.1.2
HiI have installed 8.1 Server with ITSM 8.1 on a test machine. Apart from
problems with the version of Java/Tomcat, the actual installation took around
4/5 hours.
Shafqat Ayaz
From: Terri Lockwood teresa.lockw...@sungard.com
To: arslist@ARSLIST.ORG
Sent: Monday, March 9, 2015 9:20 PM
Subject: Re: Time to Install ITSM 8.1.2
**#yiv9497951358 #yiv9497951358 -- _filtered #yiv9497951358
{font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv9497951358
{font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #yiv9497951358
{panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv9497951358
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv9497951358
{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv9497951358
#yiv9497951358 p.yiv9497951358MsoNormal, #yiv9497951358
li.yiv9497951358MsoNormal, #yiv9497951358 div.yiv9497951358MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv9497951358 a:link,
#yiv9497951358 span.yiv9497951358MsoHyperlink
{color:blue;text-decoration:underline;}#yiv9497951358 a:visited, #yiv9497951358
span.yiv9497951358MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv9497951358 p
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv9497951358
p.yiv9497951358MsoAcetate, #yiv9497951358 li.yiv9497951358MsoAcetate,
#yiv9497951358 div.yiv9497951358MsoAcetate
{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;}#yiv9497951358
span.yiv9497951358BalloonTextChar {}#yiv9497951358
span.yiv9497951358EmailStyle20 {color:#1F497D;}#yiv9497951358
span.yiv9497951358EmailStyle21 {color:#1F497D;}#yiv9497951358
.yiv9497951358MsoChpDefault {font-size:10.0pt;} _filtered #yiv9497951358
{margin:1.0in 1.0in 1.0in 1.0in;}#yiv9497951358 div.yiv9497951358WordSection1
{}#yiv9497951358 I’ve had successful install on multiple servers but I wouldn’t
call any of the “easy” J Getting data successfully loaded now that’s another
story. Terri
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf OfSanford, Claire
Sent: Monday, March 09, 2015 4:58 PM
To: arslist@ARSLIST.ORG
Subject: Re: Time to Install ITSM 8.1.2 ** Has anyone has an easy successful
install yet? I tried on a brand new fresh clean server with a fresh clean
DB instance and it kept failing! Since it was an “exercise” I stopped and
loaded the ITSM 7.6.04 SP4. It worked for what I needed. Claire From:
Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]On
Behalf Of Rick Cook
Sent: Monday, March 09, 2015 2:23 PM
To: arslist@ARSLIST.ORG
Subject: Re: Time to Install ITSM 8.1.2 ** Mine is failing, too. Actually,
it (finally) installed, but now I can't connect to my plug-in server, which
I've been working with Support on for over a week.
Rick Cook On Mon, Mar 9, 2015 at 10:27 AM, Hynes, Douglas
douglas.hy...@froedtert.com wrote: ** My 8.1.02 Core patch in my Test Env.
failed. I won’t be able to give a good set of numbers for a bit. Sorry, -Doug
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Tanner, Doug
Sent: Monday, March 09, 2015 11:49 AM
To: arslist@ARSLIST.ORG
Subject: Re: Time to Install ITSM 8.1.2 ** Thanks Rick, I installed English
French Doug From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Phillips
Sent: Monday, March 09, 2015 12:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: Time to Install ITSM 8.1.2 ** Doug, it depends on which locales
you have installed. For us (with all locales installed) it's 11 hours.
rp On 3/9/2015 5:47 AM, Tanner, Doug wrote:
** Dear List, Looking for some feedback on Installation times
for ITSM Suite. I know there are a lot of variables and different system
configurations, etc. I installed CMDB, Atrium Integrator and then ITSM (8.1.2)
suite over the weekend on a Sandbox. Just trying to gauge if my installation
time was typical/average. My Question for the List –If you
have installed ITSM 8.1.2 – How long did the install take? P.S. Are there any
tips/tricks that can reduce the installation time? Thanks in Advance, Doug
|Doug Tanner | Enterprise Workflow Applications| |Compass Group |2400 Yorkmont
Rd, Charlotte, NC 28217| |(w)+1.704.328.3178 |(m)+1.980.230.8563 |
|www.cgnad.com|why Compass? | This email is subject to certain disclaimers,
which may be reviewed via the following
link.http://compass-usa.com/Pages/Disclaimer.aspx. _ARSlist: Where the Answers
Are and have been for 20 years_
_ARSlist: Where the Answers Are and have been for 20 years_ This email is
subject to certain disclaimers, which may be reviewed via the following
link.http://compass-usa.com/Pages/Disclaimer.aspx. _ARSlist: Where the Answers
Are and have been for 20 years_ Confidentiality Notice: This e-mail message,
including any attachments, is for the sole use of the intended recipient(s) and
Re: BIRT report: Previous month function; and ability to schedule?
Ok, if you need that broken out into something more detailed and easier to follow for a novice, let me know :) On Thu, Mar 12, 2015 at 8:09 AM, Champagne, Susan schampa...@hsnsudbury.ca wrote: ** Thank you for your response LJ. I’m a real novice, so, as logical as your suggestion is, it is a little intimidating to me. I was really hoping there would be a simple BIRT function, that would work. I’ll continue to play with it, and hopefully eventually find the solution. Susan Champagne *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *LJ LongWing *Sent:* March-12-15 9:49 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: BIRT report: Previous month function; and ability to schedule? ** Susan, Just thoughts off the top of my headon button press 1 - using MONTH and YEAR functions, collect tmp values for last month, last year, current month, and current year for $DATE$ 2 - Do some sort of calculation that determines if last month is 0, then set it to 12, and if last month is 12, set last year -1 (to capture Dec last year) 3 - Set a Date/Time field = $lastMonth$/1/$lastYear$, set another to $currentMonth$/1/$currentYear$ 4 - now that you have the date/time values for the first of the month for last month, and the first of the month for this month, do an open window action of type report, utilizing the new calculated date/time values from step 3 as qualification of what should be in the report In theory, that should 'always' work for last month data, ensuring the query is 'DateTime' = $lastMonthDate$ AND 'DateTime' $thisMonthDate$. This query of course runs in 'your' timezone, so results may vary depending on who presses the button and what timezone they are in...but should work pretty good. On Thu, Mar 12, 2015 at 7:34 AM, Champagne, Susan schampa...@hsnsudbury.ca wrote: ** Hi folks, I am struggling with trying to get the correct syntax, using BIRT Functions, to acquire results for “last month”. I am simply trying to pull the list of tasks that were assigned to a particular group. So, for example, I will run the report in any day of March, and the results should display all data from the month of February. Then, in April, I will expect the results to display the March data. I have found several suggestions, online, but none have given the correct results. Also, if you know of a means of scheduling a report to be e-mailed automatically, from Remedy, please let me know. Using ITSM 7.6.04. Your assistance with these questions is most appreciated. Thank you, Susan Champagne Health Sciences North's vision is to be globally recognized for patient-centred innovation. The information contained in this e-mail and document(s) attached are for the exclusive use of the addressee and may contain confidential, privileged and non-disclosable information. If the recipient of this e-mail is not the addressee, such recipient is strictly prohibited from reading, photocopying, distributing or otherwise using this e-mail or its content in any way. _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ Health Sciences North's vision is to be globally recognized for patient-centred innovation. _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: web service logging
Thanks LJ, So if I were to test this in SoapUI which url would I use to simulate an external call to the wysdl. The one from my external scrypt: http://mywebserver/arsys/services/ARService?server=myappseverwebService=HPD_IncidentInterface_Create_WS_3 Or the one from the actual Remed web service http://mywebserver/arsys/WSDL/public/myappserver/HPD_IncidentInterface_Create_WS_3 On Wed, 3/11/15, LJ LongWing lj.longw...@gmail.com wrote: Subject: Re: web service logging To: arslist@ARSLIST.ORG Date: Wednesday, March 11, 2015, 3:08 PM ** Scott,the /arsys/WSDL is the URL to the WSDL, the /arsys/services is the URI that the WSDL points to for executiontwo different pieces of the same puzzle. On Wed, Mar 11, 2015 at 12:55 PM, Scott Hallenger vadr...@yahoo.com wrote: Ok here is what I dont understand: This is the url of the webs service that is called externally: http://mywebserver/arsys/services/ARService?server=myappseverwebService=HPD_IncidentInterface_Create_WS_3 This is the URL of the web service as defined in remedy (admin tool/web services): http://mywebserver/arsys/WSDL/public/myappserver/HPD_IncidentInterface_Create_WS_3 If past the below url from the admin tool into my browser I runs and the soap code is returned but if use the external url above.. it does not run. I get the Hi there, this is an AXIS service! error. http://mywebserver/arsys/WSDL/public/myappserver/HPD_IncidentInterface_Create_WS_3 Now it get srange because I can't call the external url from my production server either, but when I run the same script against prod it creates the incident as it is suppose to do. On Wed, 3/11/15, Terry Bootsma tboot...@objectpath.com wrote: Subject: Re: web service logging To: arslist@ARSLIST.ORG Date: Wednesday, March 11, 2015, 1:34 PM ** Scott: On your dev mid-tier, can you access the WSDL and the web-service end-point that defines your web service (via a browser) to ensure that your mid-tier has the web service defined and available ? If it is available, it doesn't even look like the calling program is hitting your midtier at all and I would debug from that point. Terry On 2015-03-11 13:22, Scott Hallenger wrote: If you can see my previous post with attachment. my Midtier logs isnt showing anything relating to a web service. The cache clear that you see in the log was long before i made any calls to the web service. On Wed, 3/11/15, Terry Bootsma tboot...@objectpath.com wrote: Subject: Re: web service logging To: arslist@ARSLIST.ORG Date: Wednesday, March 11, 2015, 12:46 PM ** Scott: If you are consuming your remedy-based web service from another application (other than Remedy itself) , it will not utilize the java plugin server. The java plugin server is only used for outbound web-service calls from Remedy. You should be able to see your web services being called in the mid-tier log. From there, you would have to enable filter/API logging on your Remedy server to debug further. HTH Terry On 2015-03-11 12:18, Scott Hallenger wrote: Hi can anyone help me find my webservice loggs? We have a web service that creates an incident in ttsm 7.0.1. it work in our prduction invironment, but the moment we re-point it to our dev system it does not generate the incident. The midtier web service logs dont really show anything useful. What I'm really looking for is the arjavaplugin.log file which does nost seem to exist. I am seriously frustrated at this point. I do not have the ability to install soapUI in my environment so I have to rely on the log if I can find it... help please. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org 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 _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 _ARSlist: Where the Answers Are and have been for 20 years_
BIRT report: Previous month function; and ability to schedule?
Hi folks, I am struggling with trying to get the correct syntax, using BIRT Functions, to acquire results for last month. I am simply trying to pull the list of tasks that were assigned to a particular group. So, for example, I will run the report in any day of March, and the results should display all data from the month of February. Then, in April, I will expect the results to display the March data. I have found several suggestions, online, but none have given the correct results. Also, if you know of a means of scheduling a report to be e-mailed automatically, from Remedy, please let me know. Using ITSM 7.6.04. Your assistance with these questions is most appreciated. Thank you, Susan Champagne Health Sciences North's vision is to be globally recognized for patient-centred innovation. The information contained in this e-mail and document(s) attached are for the exclusive use of the addressee and may contain confidential, privileged and non-disclosable information. If the recipient of this e-mail is not the addressee, such recipient is strictly prohibited from reading, photocopying, distributing or otherwise using this e-mail or its content in any way. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: web service logging
Scott: You point SOAP-UI to the WSDL definition of the web service. So, that would be your second link below. It read's the WSDL and will execute against the first link you identify. Terry On 2015-03-12 10:10, Scott Hallenger wrote: Thanks LJ, So if I were to test this in SoapUI which url would I use to simulate an external call to the wysdl. The one from my external scrypt: http://mywebserver/arsys/services/ARService?server=myappseverwebService=HPD_IncidentInterface_Create_WS_3 [1] Or the one from the actual Remed web service http://mywebserver/arsys/WSDL/public/myappserver/HPD_IncidentInterface_Create_WS_3 [2] On Wed, 3/11/15, LJ LongWing lj.longw...@gmail.com wrote: Subject: Re: web service logging To: arslist@ARSLIST.ORG Date: Wednesday, March 11, 2015, 3:08 PM ** Scott,the /arsys/WSDL is the URL to the WSDL, the /arsys/services is the URI that the WSDL points to for executiontwo different pieces of the same puzzle. On Wed, Mar 11, 2015 at 12:55 PM, Scott Hallenger vadr...@yahoo.com wrote: Ok here is what I dont understand: This is the url of the webs service that is called externally: http://mywebserver/arsys/services/ARService?server=myappseverwebService=HPD_IncidentInterface_Create_WS_3 [1] This is the URL of the web service as defined in remedy (admin tool/web services): http://mywebserver/arsys/WSDL/public/myappserver/HPD_IncidentInterface_Create_WS_3 [2] If past the below url from the admin tool into my browser I runs and the soap code is returned but if use the external url above.. it does not run. I get the Hi there, this is an AXIS service! error. http://mywebserver/arsys/WSDL/public/myappserver/HPD_IncidentInterface_Create_WS_3 [2] Now it get srange because I can't call the external url from my production server either, but when I run the same script against prod it creates the incident as it is suppose to do. On Wed, 3/11/15, Terry Bootsma tboot...@objectpath.com wrote: Subject: Re: web service logging To: arslist@ARSLIST.ORG Date: Wednesday, March 11, 2015, 1:34 PM ** Scott: On your dev mid-tier, can you access the WSDL and the web-service end-point that defines your web service (via a browser) to ensure that your mid-tier has the web service defined and available ? If it is available, it doesn't even look like the calling program is hitting your midtier at all and I would debug from that point. Terry On 2015-03-11 13:22, Scott Hallenger wrote: If you can see my previous post with attachment. my Midtier logs isnt showing anything relating to a web service. The cache clear that you see in the log was long before i made any calls to the web service. On Wed, 3/11/15, Terry Bootsma tboot...@objectpath.com wrote: Subject: Re: web service logging To: arslist@ARSLIST.ORG Date: Wednesday, March 11, 2015, 12:46 PM ** Scott: If you are consuming your remedy-based web service from another application (other than Remedy itself) , it will not utilize the java plugin server. The java plugin server is only used for outbound web-service calls from Remedy. You should be able to see your web services being called in the mid-tier log. From there, you would have to enable filter/API logging on your Remedy server to debug further. HTH Terry On 2015-03-11 12:18, Scott Hallenger wrote: Hi can anyone help me find my webservice loggs? We have a web service that creates an incident in ttsm 7.0.1. it work in our prduction invironment, but the moment we re-point it to our dev system it does not generate the incident. The midtier web service logs dont really show anything useful. What I'm really looking for is the arjavaplugin.log file which does nost seem to exist. I am seriously frustrated at this point. I do not have the ability to install soapUI in my environment so I have to rely on the log if I can find it... help please. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org [3] 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 [3] 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 [3] Where the Answers Are, and have been for 20 years _ARSlist: Where the Answers Are and have been for 20 years_
ITSM Upgrade completed with warnings - In fact failed to upgrade
Hello Experts, We tried to upgraded ITSM from 7.603 to 8.1.02, but it says completed with warnings. From the logs we could find many def files failed to import. We have sorted out issues related to Asset, incident and Problem Management. But facing issues while importing the def files related to Change Module. We could see the below error messages while importing the file. The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552, The following item was not imported; CHG:ChangeImpactedAreaCIAssociation_Join, 55, The following item was not imported; CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, The following item was not imported; CHG:ChangeRelationshipInterface, 55 We have restarted Remedy services and tried importing that again. This time we could find the below messages. The value(s) for this entry violate a unique index that has been defined for this form; , 382, The following item was not imported; CHG:ChangeImpactedAreaCIAssociation_Join, 55, The following item was not imported; CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, The following item was not imported; CHG:ChangeRelationshipInterface, 55, I have opened a ticket with BMC but as as usual very poor response in this week. Any suggestions are highly appreciated. Thanks Pavan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years BMCRemedyChangeManagement_error.log Description: Binary data
Re: ITSM Upgrade completed with warnings - In fact failed to upgrade
Hi William, Firstly, thanks for your response. Below was done prior to ITSM upgrade. 1) We have upgraded AR Server from 7.6.04 to 8.1.02 without any issues. 2) Ran BPCU in overlay mode to preserve our customizations 3) Upgraded Atrium Core successfully from 7.6.03 to 8.1.02 4) Upgraded ITSM from 7.6.03 to 8.1.02 successfully after fixing issues with field mappings using the option Only copy CI attributes from CDM to ITSM Foundation. 5) Restarted upgrade once again with the option Upgrade to 8.1.02 but don not remove CI attributes from CDM. After 13 hours we got the results as BMC Remedy ITSM Suite 8.1.02 install completed with warnings. I believe I am going in the correct direction. Please advise. Thanks Pavan On Thu, Mar 12, 2015 at 11:01 PM, William Rentfrow wrentf...@stratacominc.com wrote: ** Um...where to start. You can't upgrade - as far as I know - from 7.6.03 to 8.1. You first have to upgrade to 7.6.04 - but prior to that you have to do the whole BPCU utility to convert any customizations you have to overlays and/or deal with them according to the guidelines BMC gives. William Rentfrow wrentf...@stratacominc.com Office: 715-204-3061 or 701-232-5697x25 Cell: 715-498-5056 *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Nagidi Pavan *Sent:* Thursday, March 12, 2015 12:14 PM *To:* arslist@ARSLIST.ORG *Subject:* ITSM Upgrade completed with warnings - In fact failed to upgrade ** Hello Experts, We tried to upgraded ITSM from 7.603 to 8.1.02, but it says completed with warnings. From the logs we could find many def files failed to import. We have sorted out issues related to Asset, incident and Problem Management. But facing issues while importing the def files related to Change Module. We could see the below error messages while importing the file. The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552, The following item was not imported; CHG:ChangeImpactedAreaCIAssociation_Join, 55, The following item was not imported; CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, The following item was not imported; CHG:ChangeRelationshipInterface, 55 We have restarted Remedy services and tried importing that again. This time we could find the below messages. The value(s) for this entry violate a unique index that has been defined for this form; , 382, The following item was not imported; CHG:ChangeImpactedAreaCIAssociation_Join, 55, The following item was not imported; CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, The following item was not imported; CHG:ChangeRelationshipInterface, 55, I have opened a ticket with BMC but as as usual very poor response in this week. Any suggestions are highly appreciated. Thanks Pavan _ARSlist: Where the Answers Are and have been for 20 years_ -- No virus found in this message. Checked by AVG - www.avg.com Version: 2014.0.4800 / Virus Database: 4257/9209 - Release Date: 03/01/15 Internal Virus Database is out of date. _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: web service logging
And the reason you can’t see anything but the Hi there, this is an AXIS service! to the endpoint is that a browser is doing an HTTP GET transaction while all web service calls are HTTP POST (Getting the WSDL is a GET while communicating with the endpoint is a POST) In the Mid-Tier do the following: Go to the Log settings page and make sure at least Web Services is checked (I usually run Session Management, Web Services, Performance, and Servlet) Set Log Level to Fine Set Log Viewer to File Set Log Format to Detailed Text (includes class name and method) You should then be able to see the incoming and outgoing XML Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Terry Bootsma Sent: Thursday, March 12, 2015 11:36 AM To: arslist@ARSLIST.ORG Subject: Re: web service logging ** Scott: You point SOAP-UI to the WSDL definition of the web service. So, that would be your second link below. It read's the WSDL and will execute against the first link you identify. Terry On 2015-03-12 10:10, Scott Hallenger wrote: Thanks LJ, So if I were to test this in SoapUI which url would I use to simulate an external call to the wysdl. The one from my external scrypt: http://mywebserver/arsys/services/ARService?server=myappseverwebService=HPD_IncidentInterface_Create_WS_3 Or the one from the actual Remed web service http://mywebserver/arsys/WSDL/public/myappserver/HPD_IncidentInterface_Create_WS_3 On Wed, 3/11/15, LJ LongWing wrote: Subject: Re: web service logging To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Date: Wednesday, March 11, 2015, 3:08 PM ** Scott,the /arsys/WSDL is the URL to the WSDL, the /arsys/services is the URI that the WSDL points to for executiontwo different pieces of the same puzzle. On Wed, Mar 11, 2015 at 12:55 PM, Scott Hallenger wrote: Ok here is what I dont understand: This is the url of the webs service that is called externally: http://mywebserver/arsys/services/ARService?server=myappseverwebService=HPD_IncidentInterface_Create_WS_3 This is the URL of the web service as defined in remedy (admin tool/web services): http://mywebserver/arsys/WSDL/public/myappserver/HPD_IncidentInterface_Create_WS_3 If past the below url from the admin tool into my browser I runs and the soap code is returned but if use the external url above.. it does not run. I get the Hi there, this is an AXIS service! error. http://mywebserver/arsys/WSDL/public/myappserver/HPD_IncidentInterface_Create_WS_3 Now it get srange because I can't call the external url from my production server either, but when I run the same script against prod it creates the incident as it is suppose to do. On Wed, 3/11/15, Terry Bootsma wrote: Subject: Re: web service logging To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Date: Wednesday, March 11, 2015, 1:34 PM ** Scott: On your dev mid-tier, can you access the WSDL and the web-service end-point that defines your web service (via a browser) to ensure that your mid-tier has the web service defined and available ? If it is available, it doesn't even look like the calling program is hitting your midtier at all and I would debug from that point. Terry On 2015-03-11 13:22, Scott Hallenger wrote: If you can see my previous post with attachment. my Midtier logs isnt showing anything relating to a web service. The cache clear that you see in the log was long before i made any calls to the web service. On Wed, 3/11/15, Terry Bootsma wrote: Subject: Re: web service logging To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Date: Wednesday, March 11, 2015, 12:46 PM ** Scott: If you are consuming your remedy-based web service from another application (other than Remedy itself) , it will not utilize the java plugin server. The java plugin server is only used for outbound web-service calls from Remedy. You should be able to see your web services being called in the mid-tier log. From there, you would have to enable filter/API logging on your Remedy server to debug further. HTH Terry On 2015-03-11 12:18, Scott Hallenger wrote: Hi can anyone help me find my webservice loggs? We have a web service that creates an incident in ttsm 7.0.1. it work in our prduction invironment, but the moment we re-point it to our dev system it does not generate the incident. The midtier web service logs dont really show anything useful. What I'm really looking for is the
Re: ITSM Upgrade completed with warnings - In fact failed to upgrade
Um...where to start. You can't upgrade - as far as I know - from 7.6.03 to 8.1. You first have to upgrade to 7.6.04 - but prior to that you have to do the whole BPCU utility to convert any customizations you have to overlays and/or deal with them according to the guidelines BMC gives. William Rentfrow wrentf...@stratacominc.com Office: 715-204-3061 or 701-232-5697x25 Cell: 715-498-5056 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Nagidi Pavan Sent: Thursday, March 12, 2015 12:14 PM To: arslist@ARSLIST.ORG Subject: ITSM Upgrade completed with warnings - In fact failed to upgrade ** Hello Experts, We tried to upgraded ITSM from 7.603 to 8.1.02, but it says completed with warnings. From the logs we could find many def files failed to import. We have sorted out issues related to Asset, incident and Problem Management. But facing issues while importing the def files related to Change Module. We could see the below error messages while importing the file. The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552, The following item was not imported; CHG:ChangeImpactedAreaCIAssociation_Join, 55, The following item was not imported; CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, The following item was not imported; CHG:ChangeRelationshipInterface, 55 We have restarted Remedy services and tried importing that again. This time we could find the below messages. The value(s) for this entry violate a unique index that has been defined for this form; , 382, The following item was not imported; CHG:ChangeImpactedAreaCIAssociation_Join, 55, The following item was not imported; CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, The following item was not imported; CHG:ChangeRelationshipInterface, 55, I have opened a ticket with BMC but as as usual very poor response in this week. Any suggestions are highly appreciated. Thanks Pavan _ARSlist: Where the Answers Are and have been for 20 years_ No virus found in this message. Checked by AVG - www.avg.comhttp://www.avg.com Version: 2014.0.4800 / Virus Database: 4257/9209 - Release Date: 03/01/15 Internal Virus Database is out of date. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ITSM Upgrade completed with warnings - In fact failed to upgrade
I’ve seen the unique index error occur when there is a form with and without the __c designation. Seems like the system thinks they are two different forms, but the same form. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Thursday, March 12, 2015 2:03 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM Upgrade completed with warnings - In fact failed to upgrade ** The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552 Sounds like your database had an error with connecting to it. I believe there is an SQL log made during the upgrade. See if it has any more information Look to see what the SQL was doing when you got the The value(s) for this entry violate a unique index that has been defined for this form; , 382 That will tell you which forms tried to create duplicate records Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Nagidi Pavan Sent: Thursday, March 12, 2015 12:52 PM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: Re: ITSM Upgrade completed with warnings - In fact failed to upgrade ** Hi William, Firstly, thanks for your response. Below was done prior to ITSM upgrade. 1) We have upgraded AR Server from 7.6.04 to 8.1.02 without any issues. 2) Ran BPCU in overlay mode to preserve our customizations 3) Upgraded Atrium Core successfully from 7.6.03 to 8.1.02 4) Upgraded ITSM from 7.6.03 to 8.1.02 successfully after fixing issues with field mappings using the option Only copy CI attributes from CDM to ITSM Foundation. 5) Restarted upgrade once again with the option Upgrade to 8.1.02 but don not remove CI attributes from CDM. After 13 hours we got the results as BMC Remedy ITSM Suite 8.1.02 install completed with warnings. I believe I am going in the correct direction. Please advise. Thanks Pavan From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG ] On Behalf Of Nagidi Pavan Sent: Thursday, March 12, 2015 12:14 PM To: arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG Subject: ITSM Upgrade completed with warnings - In fact failed to upgrade ** Hello Experts, We tried to upgraded ITSM from 7.603 to 8.1.02, but it says completed with warnings. From the logs we could find many def files failed to import. We have sorted out issues related to Asset, incident and Problem Management. But facing issues while importing the def files related to Change Module. We could see the below error messages while importing the file. The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552, The following item was not imported; CHG:ChangeImpactedAreaCIAssociation_Join, 55, The following item was not imported; CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, The following item was not imported; CHG:ChangeRelationshipInterface, 55 We have restarted Remedy services and tried importing that again. This time we could find the below messages. The value(s) for this entry violate a unique index that has been defined for this form; , 382, The following item was not imported; CHG:ChangeImpactedAreaCIAssociation_Join, 55, The following item was not imported; CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, The following item was not imported; CHG:ChangeRelationshipInterface, 55, I have opened a ticket with BMC but as as usual very poor response in this week. Any suggestions are highly appreciated. Thanks Pavan _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: ITSM Upgrade completed with warnings - In fact failed to upgrade
The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552 Sounds like your database had an error with connecting to it. I believe there is an SQL log made during the upgrade. See if it has any more information Look to see what the SQL was doing when you got the The value(s) for this entry violate a unique index that has been defined for this form; , 382 That will tell you which forms tried to create duplicate records Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Nagidi Pavan Sent: Thursday, March 12, 2015 12:52 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM Upgrade completed with warnings - In fact failed to upgrade ** Hi William, Firstly, thanks for your response. Below was done prior to ITSM upgrade. 1) We have upgraded AR Server from 7.6.04 to 8.1.02 without any issues. 2) Ran BPCU in overlay mode to preserve our customizations 3) Upgraded Atrium Core successfully from 7.6.03 to 8.1.02 4) Upgraded ITSM from 7.6.03 to 8.1.02 successfully after fixing issues with field mappings using the option Only copy CI attributes from CDM to ITSM Foundation. 5) Restarted upgrade once again with the option Upgrade to 8.1.02 but don not remove CI attributes from CDM. After 13 hours we got the results as BMC Remedy ITSM Suite 8.1.02 install completed with warnings. I believe I am going in the correct direction. Please advise. Thanks Pavan From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Nagidi Pavan Sent: Thursday, March 12, 2015 12:14 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: ITSM Upgrade completed with warnings - In fact failed to upgrade ** Hello Experts, We tried to upgraded ITSM from 7.603 to 8.1.02, but it says completed with warnings. From the logs we could find many def files failed to import. We have sorted out issues related to Asset, incident and Problem Management. But facing issues while importing the def files related to Change Module. We could see the below error messages while importing the file. The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552, The following item was not imported; CHG:ChangeImpactedAreaCIAssociation_Join, 55, The following item was not imported; CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, The following item was not imported; CHG:ChangeRelationshipInterface, 55 We have restarted Remedy services and tried importing that again. This time we could find the below messages. The value(s) for this entry violate a unique index that has been defined for this form; , 382, The following item was not imported; CHG:ChangeImpactedAreaCIAssociation_Join, 55, The following item was not imported; CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, The following item was not imported; CHG:ChangeRelationshipInterface, 55, I have opened a ticket with BMC but as as usual very poor response in this week. Any suggestions are highly appreciated. Thanks Pavan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ITSM Upgrade completed with warnings - In fact failed to upgrade
I could see the below in the log files SQL TID: 2100709120 RPC ID: 000667 Queue: Admin Client-RPC: 390600USER: Demo Overlay-Group: -2 /* Wed Mar 11 2015 22:39:50.8992 */INSERT INTO field_permissions (recordId,schemaId,fieldId,groupId,permission,overlayExtended) VALUES (2074676,3530,23009,0,1,0) SQL TID: 2100709120 RPC ID: 000667 Queue: Admin Client-RPC: 390600USER: Demo Overlay-Group: -2 /* Wed Mar 11 2015 22:39:50.9352 */ SQL TID: 2100709120 RPC ID: 000667 Queue: Admin Client-RPC: 390600USER: Demo Overlay-Group: -2 /* Wed Mar 11 2015 22:39:50.9353 */SELECT T1.C1,C152,C155,C156 FROM T1 WHERE ((T1.C8 = '382') AND (T1.C7 = 0) AND (T1.C150 = 0) AND ((T1.C152 LIKE 'NO LOCALE') OR (T1.C152 IS NULL))) ORDER BY C152 ASC, 1 ASC SQL TID: 2100709120 RPC ID: 000667 Queue: Admin Client-RPC: 390600USER: Demo Overlay-Group: -2 /* Wed Mar 11 2015 22:39:50.9415 */OK SQL TID: 2100709120 RPC ID: 000667 Queue: Admin Client-RPC: 390600USER: Demo Overlay-Group: -2 /* Wed Mar 11 2015 22:39:50.9420 */ROLLBACK WORK Its almost some 3mb file after zipping it. I will send the logs shortly. On Fri, Mar 13, 2015 at 12:16 AM, Nagidi Pavan pavan@gmail.com wrote: Okay.. Attaching the SQL log that is captured while importing the def file using the developer studio. On Thu, Mar 12, 2015 at 11:32 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: ** The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552 Sounds like your database had an error with connecting to it. I believe there is an SQL log made during the upgrade. See if it has any more information Look to see what the SQL was doing when you got the The value(s) for this entry violate a unique index that has been defined for this form; , 382 That will tell you which forms tried to create duplicate records Fred *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Nagidi Pavan *Sent:* Thursday, March 12, 2015 12:52 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ITSM Upgrade completed with warnings - In fact failed to upgrade ** Hi William, Firstly, thanks for your response. Below was done prior to ITSM upgrade. 1) We have upgraded AR Server from 7.6.04 to 8.1.02 without any issues. 2) Ran BPCU in overlay mode to preserve our customizations 3) Upgraded Atrium Core successfully from 7.6.03 to 8.1.02 4) Upgraded ITSM from 7.6.03 to 8.1.02 successfully after fixing issues with field mappings using the option Only copy CI attributes from CDM to ITSM Foundation. 5) Restarted upgrade once again with the option Upgrade to 8.1.02 but don not remove CI attributes from CDM. After 13 hours we got the results as BMC Remedy ITSM Suite 8.1.02 install completed with warnings. I believe I am going in the correct direction. Please advise. Thanks Pavan *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Nagidi Pavan *Sent:* Thursday, March 12, 2015 12:14 PM *To:* arslist@ARSLIST.ORG *Subject:* ITSM Upgrade completed with warnings - In fact failed to upgrade ** Hello Experts, We tried to upgraded ITSM from 7.603 to 8.1.02, but it says completed with warnings. From the logs we could find many def files failed to import. We have sorted out issues related to Asset, incident and Problem Management. But facing issues while importing the def files related to Change Module. We could see the below error messages while importing the file. The SQL database operation failed.; Error - OCI_INVALID_HANDLE, 552, The following item was not imported; CHG:ChangeImpactedAreaCIAssociation_Join, 55, The following item was not imported; CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, The following item was not imported; CHG:ChangeRelationshipInterface, 55 We have restarted Remedy services and tried importing that again. This time we could find the below messages. The value(s) for this entry violate a unique index that has been defined for this form; , 382, The following item was not imported; CHG:ChangeImpactedAreaCIAssociation_Join, 55, The following item was not imported; CHG:Change-ImpactedAreasCIAssociation_outer_ApproverLookup, 55, The following item was not imported; CHG:ChangeRelationshipInterface, 55, I have opened a ticket with BMC but as as usual very poor response in this week. Any suggestions are highly appreciated. Thanks Pavan _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: Incident template with tasks - no tasks?
Jason is right: now you can attach the task templates only to the changes. Is there an option to use the Process Designer? You could try to develop a process that would create the tasks after the Incident had been created. Regards, Dmitry Baryshnikov On Mar 12, 2015 9:23 AM, Jason Miller jason.mil...@gmail.com wrote: ** It doesn't look like it is an option for incidents (so your not missing anything). There is an Idea (RFE) to add it here: https://communities.bmc.com/ideas/7438 Jason ** Hello List, I’m trying to create an incident template that includes about 3 tasks. – or maybe a task group template (don’t know if this is necessary). Ultimately this incident template will be consumed by the “Rule Base Email Engine” to create an incident from an email. The issue I have is that my incident template does not have a tab for tasks… huh? Shouldn’t it have a tab for tasks?? Ideally I would of liked for the RBE to create 3 incidents from one email. But I have not found a way to do that w/o customizing. Or… if the email could create an SRM request that was tied to a PDT that created 3 incidents.. would be perfect. J ARS/ITSM 8.1.01 Thanks, Marcelo _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
Re: Incident template with tasks - no tasks?
It doesn't look like it is an option for incidents (so your not missing anything). There is an Idea (RFE) to add it here: https://communities.bmc.com/ideas/7438 Jason ** Hello List, I’m trying to create an incident template that includes about 3 tasks. – or maybe a task group template (don’t know if this is necessary). Ultimately this incident template will be consumed by the “Rule Base Email Engine” to create an incident from an email. The issue I have is that my incident template does not have a tab for tasks… huh? Shouldn’t it have a tab for tasks?? Ideally I would of liked for the RBE to create 3 incidents from one email. But I have not found a way to do that w/o customizing. Or… if the email could create an SRM request that was tied to a PDT that created 3 incidents.. would be perfect. J ARS/ITSM 8.1.01 Thanks, Marcelo _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
