Re: Identify an incident that originated from SRM
In the upper right-hand corner of the Incident, you should see a 'View Service Request' link on those entries that came from an SR. Of course if you've set the system parameter that generates SR's for Incident submission, they'll all have this but if you haven't, it should work for you. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Steven Iocco Sent: Friday, November 07, 2008 11:25 AM To: arslist@ARSLIST.ORG Subject: Identify an incident that originated from SRM --_cbf270c5-b681-43cc-823f-12738034b6d2_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi folks. Just wondering if there is a field or ID on the incident form th= at identifies if an incident originated from the SRM. I imagine there is o= ne and could probably find it but thought it might be quicker to ask the li= st. Thanks Steve ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" --_cbf270c5-b681-43cc-823f-12738034b6d2_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable ** .hmmessage P { margin:0px=3B padding:0px } body.hmmessage { font-size: 10pt=3B font-family:Verdana } Hi folks. =3B Just wondering if there is a field or ID on the incident = form that identifies if an incident originated from the SRM. =3B I imag= ine there is one and could probably find it but thought it might be quicker= to ask the list. Thanks Steve = __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ --_cbf270c5-b681-43cc-823f-12738034b6d2_-- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: mid-tier "Service Unavailable"
We used these steps when we encountered the same problem on 7.1 patch 3: 1. Make sure you can browse localhost; if you can't, check: a. the c:\windows\system32\drivers\etc\hosts file to make sure it has an entry with the server's IP/localhost b. under IIS Admin/web site/ISAPI Filters, make sure Jakarta redirector is up c. if it becomes necessary to test the status of IIS, you can enable port 8080 and use Tomcat to check localhost (this effectively bypasses IIS); edit the server.xml file under D:\Program Files\Apache Software Foundation\Tomcat-5.5.17\conf as follows and then restart Tomcat: -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Bloom Sent: Wednesday, November 05, 2008 7:51 AM To: arslist@ARSLIST.ORG Subject: mid-tier "Service Unavailable" I did a simple install on a windows2003 server of 7.1 patch 5 and Tomcat (IIS as the web server). When I try to get to the config.sys page I get "Service Unavailable". This looks like it could be permissions, but where? Any other causes (I have tried searching ARSlist and following old Advice from 6.3, BMC knowledge base etc.). ? Thanks ... Daniel ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: problems w/jakarta for mid tier on 64-bit W2003 Enterprise
Matt: Thanks for the assistance, it is much appreciated. I followed the steps you outlined but although Jakarta was loaded with the p005 'upgrade', it still didn't appear as an ISAPI Filter for the web site. In the past, we've added it manually but another ARSLister had previously pointed a step from the installation guide that does this for you: 4. From the command window, run the following command: cscript.exe C:\WINDOWS\system32\iisext.vbs /AddFile "C:\Program Files (x86)\Apache Software Foundation\Jakarta Isapi Redirector\bin\isapi_redirect.dll" 1 jakarta 1 jakarta This step adds and enables the Jakarta Isapi Redirector web service extension. Unfortunately, we get an odd error from running this command: "Error while configuring application or extension. You were not connected because a duplicate name exists on the network. Go to System in Control Panel to change the computer name and try again.". I'm running it down with our server folks because it makes no sense. Thanks. - Don -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matt Reinfeldt Sent: Tuesday, October 21, 2008 6:49 AM To: arslist@ARSLIST.ORG Subject: Re: problems w/jakarta for mid tier on 64-bit W2003 Enterprise This is a multipart message in MIME format. --=_NextPart_000_0025_01C93359.CF097820 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Donald, It sounds like you're on the right path with this. You do need to set IIS to run as 32-bit and get the asp.net updated. However, you should be loading a newer version of MT, IMHO. Try this: go to Add/Remove Programs and uninstall both Tomcat and the Jakarta ISAPI Redirector (not Mid-Tier). Go to Windows Explorer and delete the d:\program files\apache. folder and sub-folders. Now, run the ARS 7.1 patch005 MT Installer. Choose IIS and Tomcat, and 'reinstall' your MT. It should reinstall both the Jakarta and Tomcat for you. You'll get Tomcat 5.5.25, which is now bundled with patch004 and patch005. I've used the above method several times on Windows 2003 x64 with success, but it would not work if the IIS had not been changed to 32-bit and restarted first. Good luck! Matt Reinfeldt From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Savant, [EMAIL PROTECTED] Sent: Monday, October 20, 2008 6:03 PM To: arslist@ARSLIST.ORG Subject: problems w/jakarta for mid tier on 64-bit W2003 Enterprise ** So far, we've been unable to bring the Mid Tier up using Jakarta on our new 64-bit W2003 Enterprise server. We've been working with Support for a week now, they're pointing to Jakarta as the problem. Here's what we've tried so far: - successfully loaded ARS 7.1 p002 on MS Windows Server 2003 Enterprise Edition, 64-bit to D:/Program Files, received no errors. - ran the command that enables 32-bit mode: cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1 - found the ARSList post re: D:/Program Files vs. D:/Program Files (x86) but according to Support, the Mid Tier is registered as a 32-bit application so Windows knows how to deal with it. - ran the command that installs the 32-bit version of asp.net to clear the ISAPI filter error: %SYSTEMROOT%\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i - downloaded fresh copies of Tomcat and Jakarta directly overriding those provided during the Remedy install. Tried both 32-bit and 64-bit versions of Jakarta. - Mid Tier simply won't come up under IIS using Jakarta Redirector. We turned on logging, the debug log shows: jk_isapi_plugin.c (1417): [/arsys] is not a servlet url. - Able to use Mid Tier under Tomcat without issue, but we must use IIS. - Loaded ServletExec, Mid Tier works under this as well so it may an option, albeit an expensive one. If anyone has run into a similar problem, any insights would be most appreciated. Thanks. - Don __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" --=_NextPart_000_0025_01C93359.CF097820 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable ** http://schemas.microsoft.com/office/2004/12/omml"; = xmlns=3D"http://www.w3.org/TR/REC-html40";> <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face {font-family:Tahoma; pano
Re: Problems calling java api from filter.
** Hi,Please be aware, that you run the api program with the correct path and classpath variable.You can use a shell script for testing purposes !CheersTristan-Original Message-Date: Tue, 21 Oct 2008 10:51:39 +0200Subject: Problems calling java api from filter.From: Sergio Tomillero <[EMAIL PROTECTED]>To: arslist@ARSLIST.ORGHello PeopleI have a strange problem with an java api. The api is correct but it onlyruns from active link. If I execute the api from the server's command line, it runs correctly, butif I execute it from a filter, it does not run returning ARERR 341.I have reviewed all logs (arerror.log, arapi.log, filter.log, sql.log) butthey do not show anything special about the problem.As example, the instruction in the server's command line, that runs Ok,should be like this: java -Dentorno=D remedyServer.Access aaa RA111 password JOT012345 00098765 "Error DSE" UA111 S JA2008The instruction in the same in active link or filter, as it islike this:$PROCESS$ @@:java -Dentorno=D remedyServer.Access new $field1$ password$field2$ $field3$ "$field4$" "$Description$" $field5$ $field6$ "$field7$" J"$field8$" "$Field9$" "$Field10$"As I have mentioned, from an active link it runs, but from a filter fails.The configuration is ARServer 5.1.2, Windows 2000.- Is it normal that the same instruction runs from an active link and doesnot run from a filter?- How can I find the error? What should I trace? Thanks in advance,Sergio Tomillero-- View this message in context: http://www.nabble.com/Problems-calling-java-api-from-filter.-tp20086003p20086003.htmlSent from the ARS (Action Request System) mailing list archive at Nabble.com.___UNSUBSCRIBE or access ARSlist Archives at www.arslist.orgPlatinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___
problems w/jakarta for mid tier on 64-bit W2003 Enterprise
So far, we've been unable to bring the Mid Tier up using Jakarta on our new 64-bit W2003 Enterprise server. We've been working with Support for a week now, they're pointing to Jakarta as the problem. Here's what we've tried so far: - successfully loaded ARS 7.1 p002 on MS Windows Server 2003 Enterprise Edition, 64-bit to D:/Program Files, received no errors. - ran the command that enables 32-bit mode: cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1 - found the ARSList post re: D:/Program Files vs. D:/Program Files (x86) but according to Support, the Mid Tier is registered as a 32-bit application so Windows knows how to deal with it. - ran the command that installs the 32-bit version of asp.net to clear the ISAPI filter error: %SYSTEMROOT%\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i - downloaded fresh copies of Tomcat and Jakarta directly overriding those provided during the Remedy install. Tried both 32-bit and 64-bit versions of Jakarta. - Mid Tier simply won't come up under IIS using Jakarta Redirector. We turned on logging, the debug log shows: jk_isapi_plugin.c (1417): [/arsys] is not a servlet url. - Able to use Mid Tier under Tomcat without issue, but we must use IIS. - Loaded ServletExec, Mid Tier works under this as well so it may an option, albeit an expensive one. If anyone has run into a similar problem, any insights would be most appreciated. Thanks. - Don ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Copy Prod Environment to Dev Environment
One other item worth mentioning: Support is adamant that they will not officially support the database copy method. You can do it and they will still provide support, but if the underlying root cause of the problem turns out to be a direct result of the database copy, they will NOT provide a fix. They did say that they would ask Engineering what it would take to make it officially supported, but nothing has come of it yet. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Thursday, October 09, 2008 6:26 AM To: arslist@ARSLIST.ORG Subject: Re: Copy Prod Environment to Dev Environment This is a multi-part message in MIME format. --_=_NextPart_001_01C92A12.8866F642 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Mid-Tier patch 2 to patch 4 is not an issue as the Mid-Tier install does not do anything to the database. =20 You need to upgrade the Prod CMDB to 2.1, then it is a simple matter to copy (Backup/Restore) the database.=20 =20 NOTE: Save the database data that holds the license information on Dev first so you don't have to re-install the licenses. =20 Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Wednesday, October 08, 2008 7:08 PM To: arslist@ARSLIST.ORG Subject: Re: Copy Prod Environment to Dev Environment Short answer: you REALLY shouldn't try this until you get the install versions to match. You need to get the install versions to agree before you do this. =20 I would patch Prod to MT 7.1 patch 004 and then patch the CMDB to 2.1 patch 6 and then copy it over...however,getting that done by Monday might be a minor miracle. =20 William Rentfrow Principal Consultant, StrataCom Inc. [EMAIL PROTECTED] 701-306-6157 C =20 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jase Brandon Sent: Wednesday, October 08, 2008 6:54 PM To: arslist@ARSLIST.ORG Subject: Copy Prod Environment to Dev Environment Hello All, I need to copy my production app server environment over to my development environment. =20 Differences in patch levels are: Dev mid-tier =3D 7.1 Patch 004, Prod mid-tier =3D 7.1 Patch 002. Dev CMDB =3D 2.1 Patch 6, Prod CMDB =3D 2.0.1 Unpatched. =20 I tried unsuccessfully to run the midtier.exe for 7.1 Patch 002 on dev, and I am a tad leary of running the CMDB installer for 2.0.1 since it's already 2.1 Patch 6. =20 I have to have them in synch by Monday and I can't think of what else to do, other then copy my production app server environment over to my development environment. =20 Since our prod environment has three servers, web, SQL, and App servers, and Dev environment is all on one server: I think I need to copy the D:\Program Files\AR System directory from Prod App Server to the Dev AR System Directory, in order to get patch levels synched up to match the prod environment. =20 Can anyone help me out with steps to take to accomplish this? I have been searching .pdf's for hours with no success. =20 Thanks in Advance, =20 Jase =20 =20 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" --_=_NextPart_001_01C92A12.8866F642 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable ** Mid-Tier patch 2 to patch 4 is not an issue as = the Mid-Tier=20 install does not do anything to the database. You need to upgrade the Prod CMDB to 2.1, then = it is a=20 simple matter to copy (Backup/Restore) the database. = NOTE: Save the database data that = holds the=20 license information on Dev first so you don't have to re-install the=20 licenses. Fred From: Action Request System = discussion=20 list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William=20 RentfrowSent: Wednesday, October 08, 2008 7:08 = PMTo:=20 arslist@ARSLIST.ORGSubject: Re: Copy Prod Environment to Dev=20 Environment =20 Short answer: you REALLY shouldn't try this = until you get=20 the install versions to match. You need to get the install = versions to=20 agree before you do this. I would patch Prod to MT 7.1 patch 004 and then = patch the=20 CMDB to 2.1 patch 6 and then copy it over...however,getting that = done by=20 Monday might be a minor miracle. William = Rentfrow Principal Consultant, = StrataCom=20 Inc. mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]= 701-306-6157 = C From: Action Request System = discussion=20 list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jase=20 BrandonSent: Wednesday, October 08, 2008 6:54 = PMTo:=20 arslist@ARSLIST.ORGSubject: Copy Prod Environment to D
SRM 2.2 - Data Initialization
Following several rounds of testing, we're now attempting to initialize the Service Request form and associated data before rollout. According to support, there is no means to remove the SRM test data, they're recommending a completely fresh install and re-configuration. Considering the time investment we've already made in development, we are looking for other alternatives. Has anyone identified all the SRM forms one would need to purge the system while retaining SRD's, AOT's, PDT's, etc...? Thanks in advance. - Don ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: What's going on with TuringSMI?
Consulting Partner means that they are not able to sell licenses or support. They are only able to provide consulting services. They were a solution provider 2 weeks ago, able to sell licenses and support... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: What's going on with TuringSMI?
You are correct in what your view. Having spoken to numerous contractors (directly) and their suppliers (directly), I think rumour is too strong a notion. If you want evidence, you should have a look into this. Check the BMC web-site and companies house. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: What's going on with TuringSMI?
I heard they were in financial trouble and owe money (Allegedly, to contractors and their major suppliers). They are no longer a solutions partner and can only provide consultancy. If I had any business with these guys I would be worried!!! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Data load tool for Service Request Management 2.2
The duplicates come from known error SW00287342 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller Sent: Wednesday, September 17, 2008 4:29 PM To: arslist@ARSLIST.ORG Subject: Re: Data load tool for Service Request Management 2.2 This is a multi-part message in MIME format. --=_NextPart_000_0022_01C918F3.3D1BC740 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Joe, make sure you're not confusing the Navigational Category form with the Browse for Service Details form. This may be why you have duplicates. Drew Tulsa, OK -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Joe DeSouza Sent: Wednesday, September 17, 2008 5:51 PM To: arslist@ARSLIST.ORG Subject: Re: Data load tool for Service Request Management 2.2 ** Might not be too hard to build one.. Anyway did anyone of you have problems where the borad Navigation Category got duplicated in the Request Entry console? What I had done was entered a few Navigation categories and before adding SRD's felt the need to modify some of the Navigational Categories.. After modifying them, where the first tier was changed, it dupliacted two sets of the first tier, one containing all the older subcategories, and the other containing the newly entered subcategories.. Where is this list of Service Categories being read from? I know the navigational categories is where you configure them, but obviously its not reading this list from there directly.. Joe - Original Message From: Mahesh Chandra <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Wednesday, September 17, 2008 6:03:34 PM Subject: Re: Data load tool for Service Request Management 2.2 ** We will be very much interested if there is any such tool and I agree with you, as a developer it is really a night mare doing the Data configuration work. I wish there was some Data Wizard tool to do this. Regards Mahesh On Wed, Sep 17, 2008 at 4:42 PM, Joe DeSouza <[EMAIL PROTECTED]> wrote: ** Thank you Mahesh.. I was hoping for a tool to import the rest to make life a bit easier! I wonder if it would be too hard to build such a tool from scratch than to enter 900 billion configuration records by hand :-) Okay its not that much but you know what I mean.. 200 is a lot too and a lot more uninteresting to do manually than developing some ARS code to facilitate the same thing.. Are you or anyone reading this post, aware of any 'behind the curtains' kind of a document about SRM that may be useful if one were to attempt to build such tools? Joe - Original Message From: Mahesh Chandra <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Wednesday, September 17, 2008 5:35:11 PM Subject: Re: Data load tool for Service Request Management 2.2 ** Hi Joe If the environment is a mix and match, it is possible to import the Navigational Categories, Work Order Templates and Task templates but not the SRD's, PDTS and AOTs. (Ref: Page 324 of SRM 2.2 Admin Guide) In our case, it was ITSP 3 Request Management to ITSM SRM 2.2. We had to manually create AOT's and associate the Work Order Template to the AOT, then create PDT and SRD. Thanks Mahesh On Tue, Sep 16, 2008 at 12:30 PM, Joe DeSouza <[EMAIL PROTECTED]> wrote: ** I have some data for Navigational Categories, SRD's, Item details with SRD's, etc given to me in the form of a excel spreadsheet.. Is there a tool available for data load for SRM 2.2 configuration data? Or is it pretty much something that I may need to build myself? Joe __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" --=_NextPart_000_0022_01C918F3.3D1BC740 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable ** Joe,=20 make sure you're not confusing the Navigational Category form with the = Browse=20 for Service Details form. This may be why you have duplicates.=20 Drew Tulsa,=20 OK -Original Message-From: Action Request = System=20 discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of = Joe=20 DeSouzaSent: Wednesday, September 17, 2008 5:51 = PMTo:=20 arslist@ARSLIST.ORGSubject: Re: Data load tool for Service = Request=20 Management 2.2**=20 DIV { MARGIN: 0px } Might not be too hard to build one.. Anyway did anyone of you have problems where the borad Navigation = Category=20 got duplicated in th
Automated Test Tools for Remedy 7
Does anyone have any experience testing Remedy 7 functionality with automated test tools? Our users are tired of running manual test scripts every time we apply a new patch. We've heard that BMC uses LoadRunner for performance testing but have no clue how they test functionality. Any and all suggestions are appreciated. Thanks. - Don ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Automated Test Tools for Remedy 7
Does anyone have any experience testing Remedy 7 functionality with automated test tools? Our users are tired of running manual test scripts every time we apply a new patch. We've heard that BMC uses LoadRunner for performance testing but have no clue how they test functionality. Any and all suggestions are appreciated. Thanks. - Don ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Automated Test Tools for Remedy 7
Does anyone have any experience testing Remedy 7 functionality with automated test tools? Our users are tired of running manual test scripts every time we apply a new patch. We've heard that BMC uses LoadRunner for performance testing but have no clue how they test functionality. Any and all suggestions are appreciated. Thanks. - Don ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: SRM auto-assign
Well that answers it - we're patched and round-robin is cranking away! -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller Sent: Tuesday, September 02, 2008 7:52 AM To: arslist@ARSLIST.ORG Subject: Re: SRM auto-assign There have been problems getting good answers from the SRM support team, but if you persist you'll get some help. You can auto-assign an SR to a group, but as far as I can tell, it's the Org group instead of the Support group. See the Service Request tab in the Service Request Definition form. >From there, the SR should round-robin (for example) auto-assign to a individual. This doesn't work in our system because I forgot to apply Patch 001 when I installed SRM. It's a listed bug, where the assignee field doesn't get filled. I'll apply the patch and report back. Drew Tulsa, OK On Tue, 2 Sep 2008, Savant, [EMAIL PROTECTED] wrote: > Let me know what you find, we don't want to assign SR's to individuals but > rather to the group; according to Support, it's not possible as designed. > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: SRM auto-assign
Let me know what you find, we don't want to assign SR's to individuals but rather to the group; according to Support, it's not possible as designed. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller Sent: Friday, August 29, 2008 2:17 PM To: arslist@ARSLIST.ORG Subject: Re: SRM auto-assign Yes, they do. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Remedy Alert
There's a whitepaper that shows port configurations for Alert, let me know if you need a copy. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sharon-Michal Mamon-Meged Sent: Tuesday, September 02, 2008 4:59 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Alert Check the open ports in your desktop . Best Regards, sharon mamon-meged AR System administrator phone : 972-3-9165229 moblie : 050-9165229 "Trevino, Rick" <[EMAIL PROTECTED] SYS.COM> To Sent by: "Action arslist@ARSLIST.ORG Request System cc discussion list (ARSList)" Subject <[EMAIL PROTECTED] Remedy Alert ORG> 19/08/2008 23:40 Please respond to [EMAIL PROTECTED] RG ** Has anyone had any issues with the Remedy alert not popping up messages on the Remedy client, It works on the laptop but is not working in the desktops Thanks Rick __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: SRM auto-assign
Assuming the group you're trying to assign to has members, do those members have the Service Request User permission group at a minimum? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller Sent: Friday, August 29, 2008 11:52 AM To: arslist@ARSLIST.ORG Subject: Re: SRM auto-assign I'm trying to get an SR auto-assigned to an individual. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Java code (.jar) via Run Process
** Use this java -cp %CLASSPATH% etc etc !-Original Message-Date: Wed, 13 Aug 2008 17:03:22 +0200Subject: Java code (.jar) via Run ProcessFrom: Tadeu Augusto Dutra Pinto <[EMAIL PROTECTED]>To: arslist@ARSLIST.ORG** Hi,How can I execute a java code (.jar) via Run Process ???1) I tried to do a 'Set Fields' action, where there is:Fields: Name: tmpField Value: $PROCESS$ /aplic/ARSD3/www/lib/sacrmvirtual.jar 123 $CpfCnpj$;echo $?This return "1" to tmpField2) I tried to create a 'Run Process' action, where there is:Command Line: /aplic/ARS/www/lib/sacrmvirtual.jar "123" $CpfCnpj$;Both commands execute successfully... But my java code (that creates an entry on another form) does not work...Anyone knows what is going on?Am I writing the Run Process command right??Is it necessary to put ("") in my values? Such as "123", or "$CpfCnpj$", etc...I'm using:AR Server 7.0.01 P 7AR User 7.0.00 P 1AR Admin 7.0.00 P 1Eclipse 3.0 (Java 1.3)Oracle DB 10gThankx a lotTadeu Augusto Dutra Pinto-----IT Web Services ATM Cinq Technologieshttp://www.cinq.com.br [EMAIL PROTECTED]Fone: 41 3018-2833 - Cinq-Confiabilidade, Inovação e Qualidade em T.I.__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___
Re: ARWARN [66] the query matched more than the maximum number of entries specified for retrieval
Ramy, you should be aware that the change doesn't really "fix" anything, it only turns the message off. If the message needs to display in the future, it won't be able to. Support wanted us to do the same thing but we said they needed to fix it instead. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ramy S. Ayoub Sent: Monday, August 11, 2008 9:10 AM To: arslist@ARSLIST.ORG Subject: Re: ARWARN [66] the query matched more than the maximum number of entries specified for retrieval --=_Part_110361_16846221.1218470999494 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi Math , Issue has been resolved by modifying the ar,cfg with the line below then restart the server Suppress-warnings: 66 Thanks all for advices On Mon, Aug 11, 2008 at 6:52 PM, Matt Reinfeldt <[EMAIL PROTECTED]>wrote: > Interesting... I started seeing this on our system after applying 7.0.1 > patch008. It definitely was not happening before that. We were at patch004 > before installing patch008. > > Matt > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Savant, [EMAIL PROTECTED] > Sent: Monday, August 11, 2008 10:42 AM > To: arslist@ARSLIST.ORG > Subject: Re: ARWARN [66] the query matched more than the maximum number of > entries specified for retrieval > > I believe this is a known bug. Support pointed us to SW00298917 "Push > Field > in Filter generates ARWARN [66] if option "Modify First Matching Request" > is > chosen", details are below. They told us it would be fixed in 7.5 but we > pushed for a patch/hotfix to 7.1 since it's still a supported version. The > defect shows Status = Closed and we were told it's underway, but as for > when > we'll see it... > > 1. DROP/BUILD BUG OCCURS IN (IF PRE-RELEASE) > ARS - 7.1.0 p3 > User and Admin - 7.1.0 p3 > > 2. STEPS TO REPRODUCE: > - Create Filter that does a Push Fields to another form. > - Have the "If Any Requests Match" option set to "Modify First Matching > Request" > - Trigger the filter. > > 3. ACTUAL RESULTS: > A Warning will appear in the User Tool. The record still gets modified, > but > the message shouldn't appear. > > ARWARN [66] The query matched more than the maximum number of entries > specified for retrieval > > 4. EXPECTED RESULTS: > No warning message should appear. The issue doesn't appear to occur with an > Active Link. > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook > Sent: Sunday, August 10, 2008 1:03 PM > To: arslist@ARSLIST.ORG > Subject: Re: ARWARN [66] the query matched more than the maximum number of > entries specified for retrieval > > --=_Part_43924_771237.1218398570905 > Content-Type: text/plain; charset=ISO-8859-1 > Content-Transfer-Encoding: 7bit > Content-Disposition: inline > > Since it's directly related to Status, could it be related to Status > History? > > Rick > On Sun, Aug 10, 2008 at 11:12 AM, Frank Caruso > <[EMAIL PROTECTED]>wrote: > > > ** Looks like there is a set fields operation that is run on update. Turn > > on SQL,filter and alink logging and see what action is causing the > warning > > > > On Aug 10, 2008, at 11:10 AM, "Ramy S. Ayoub" <[EMAIL PROTECTED]> > wrote: > > > > ** > > > > Dear List, > > > > I get this below warring only when the status is updated > > > > ARWARN [66] the query matched more than the maximum number of entries > > specified for retrieval > > > > When update anything else... Things are going smooth > > > > AR Server 7.1 Patch 4 > > > > Service Desk 7.0.3 Patch 8 > > > > OS windows > > > > Database SQL 2005 > > > > Regards, > > > > Ramy > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > html___ > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > html___ > > > ________ > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > --=_Part_43924_771237.1218398570905 > Content-Type: text/html; charset=ISO-8859-1 > Content-Transfer-Encoding: 7bit > Content-Disposition: inline > > ** > Since it's directly related to Sta
Re: ARWARN [66] the query matched more than the maximum number of entries specified for retrieval
I believe this is a known bug. Support pointed us to SW00298917 "Push Field in Filter generates ARWARN [66] if option "Modify First Matching Request" is chosen", details are below. They told us it would be fixed in 7.5 but we pushed for a patch/hotfix to 7.1 since it's still a supported version. The defect shows Status = Closed and we were told it's underway, but as for when we'll see it... 1. DROP/BUILD BUG OCCURS IN (IF PRE-RELEASE) ARS - 7.1.0 p3 User and Admin - 7.1.0 p3 2. STEPS TO REPRODUCE: - Create Filter that does a Push Fields to another form. - Have the "If Any Requests Match" option set to "Modify First Matching Request" - Trigger the filter. 3. ACTUAL RESULTS: A Warning will appear in the User Tool. The record still gets modified, but the message shouldn't appear. ARWARN [66] The query matched more than the maximum number of entries specified for retrieval 4. EXPECTED RESULTS: No warning message should appear. The issue doesn't appear to occur with an Active Link. -Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Sunday, August 10, 2008 1:03 PM To: arslist@ARSLIST.ORG Subject: Re: ARWARN [66] the query matched more than the maximum number of entries specified for retrieval --=_Part_43924_771237.1218398570905 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Since it's directly related to Status, could it be related to Status History? Rick On Sun, Aug 10, 2008 at 11:12 AM, Frank Caruso <[EMAIL PROTECTED]>wrote: > ** Looks like there is a set fields operation that is run on update. Turn > on SQL,filter and alink logging and see what action is causing the warning > > On Aug 10, 2008, at 11:10 AM, "Ramy S. Ayoub" <[EMAIL PROTECTED]> wrote: > > ** > > Dear List, > > I get this below warring only when the status is updated > > ARWARN [66] the query matched more than the maximum number of entries > specified for retrieval > > When update anything else... Things are going smooth > > AR Server 7.1 Patch 4 > > Service Desk 7.0.3 Patch 8 > > OS windows > > Database SQL 2005 > > Regards, > > Ramy > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" --=_Part_43924_771237.1218398570905 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline ** Since it's directly related to Status, could it be related to Status History? Rick On Sun, Aug 10, 2008 at 11:12 AM, Frank Caruso <mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]> wrote: ** Looks like there is a set fields operation that is run on update. Turn on SQL,filter and alink logging and see what action is causing the warningOn Aug 10, 2008, at 11:10 AM, "Ramy S. Ayoub" <mailto:[EMAIL PROTECTED]" target="_blank">[EMAIL PROTECTED]> wrote: ** Dear List, I get this below warring only when the status is updated ARWARN [66] the query matched more than the maximum number of entries specified for retrieval When update anything else... Things are going smooth AR Server 7.1 Patch 4 Service Desk 7.0.3 Patch 8 OS windows Database SQL 2005 Regards, Ramy__Platinum Sponsor: http://www.rmsportal.com/"; target="_blank">www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: http://www.rmsportal.com/"; target="_blank">www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ --=_Part_43924_771237.1218398570905-- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Runmacro for export in an escalation
I'm attempting to use the runmacro command from an escalation to do an export. I've followed the Integrating with Plug-ins and Third-Party Products guide as best I can. The command simply doesn't work in the escalation. When I run it from a command window in Windows I get the following error: DTS:CMDB-SDS:Transactions is not a regular form and is not processed. The listed form is a regular form, however. The command as written: runmacro -o "D:\Remedy\SDS_File_Exchange\SDS_nightly_batch_data\cmdb2sdsnew.csv" -d "D:\Remedy\SDS_File_Exchange\Macros" -x ms-res-devrm -e "expxcmdb.arq" -U -P -s "DTS:CMDB-SDS:Transactions" -t csv Any input is appreciated. Thank you. Ron Suster State of California ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: BMC Service Request Management
Drew: In configuring SRM, we created Incident and Change templates, but no Tasks. However, I would think it would be relatively straightforward given that you can relate task templates to the underlying change and incident templates. - Don -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller Sent: Tuesday, July 01, 2008 9:28 AM To: arslist@ARSLIST.ORG Subject: Re: BMC Service Request Management Donald, thanks for the info. I do have a specific question. Is there an easy answer for how to create a task template? I haven't found that in the documentation yet. The sample data Task Templates look pretty hairy. Drew On Tue, 1 Jul 2008, Savant, [EMAIL PROTECTED] wrote: > We've had SRM 2.1 p001 fully configured in dev and test for months now, we > are scheduled to move to prod in September after final UAT and training. > Suffice it say, SRM requires a fair amount of configuration, too much to > cover in an ARList response. Let me know if you have any specific questions. > In general, my suggestions would be to take the training if you can, read > the manuals thoroughly, and keep it as simple as possible. We do plan to > move to 2.2 before rollout because according to support, it resolves more > than 200 bugs. > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto:[EMAIL > PROTECTED] On Behalf Of Drew Shuller > Sent: Tuesday, July 01, 2008 7:03 AM > To: arslist@ARSLIST.ORG > Subject: Re: BMC Service Request Management > > We just installed SRM 2.2 on our UNIX/Oracle servers. No install issues > other than the ususal ITSM headaches, so that went pretty well. You get > some sample SRM's that should work but they rely on > Foundation configurations that don't exist. > > So I'm in the middle of it...if anyone has good info on how to configure > SRM, please speak up. Any help would be greatly appreciated! > > Drew > Tulsa, OK > > On Mon, 30 Jun 2008, > Joe DeSouza wrote: > >> This information may be useful for me too.. We might end up using SRM 2.2 >> (the new release) with all the language options installed.. >> Joe >> >> >> >> - Original Message >> From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> >> To: arslist@ARSLIST.ORG >> Sent: Monday, December 3, 2007 5:27:34 PM >> Subject: BMC Service Request Management >> >> Is there any one out there who has implemented BMC Service Request >> Management and is actually using the tool in a production environment? >> Looking for any installation, user and troubleshooting issues you may have >> encountered. >> >> Scott Parrish >> IT Prophets, LLC >> (770) 653-5203 >> >> >> >> ___ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >> > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: BMC Service Request Management
We've had SRM 2.1 p001 fully configured in dev and test for months now, we are scheduled to move to prod in September after final UAT and training. Suffice it say, SRM requires a fair amount of configuration, too much to cover in an ARList response. Let me know if you have any specific questions. In general, my suggestions would be to take the training if you can, read the manuals thoroughly, and keep it as simple as possible. We do plan to move to 2.2 before rollout because according to support, it resolves more than 200 bugs. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller Sent: Tuesday, July 01, 2008 7:03 AM To: arslist@ARSLIST.ORG Subject: Re: BMC Service Request Management We just installed SRM 2.2 on our UNIX/Oracle servers. No install issues other than the ususal ITSM headaches, so that went pretty well. You get some sample SRM's that should work but they rely on Foundation configurations that don't exist. So I'm in the middle of it...if anyone has good info on how to configure SRM, please speak up. Any help would be greatly appreciated! Drew Tulsa, OK On Mon, 30 Jun 2008, Joe DeSouza wrote: > This information may be useful for me too.. We might end up using SRM 2.2 > (the new release) with all the language options installed.. > Joe > > > > ----- Original Message > From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > To: arslist@ARSLIST.ORG > Sent: Monday, December 3, 2007 5:27:34 PM > Subject: BMC Service Request Management > > Is there any one out there who has implemented BMC Service Request Management > and is actually using the tool in a production environment? Looking for any > installation, user and troubleshooting issues you may have encountered. > > Scott Parrish > IT Prophets, LLC > (770) 653-5203 > > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: I'm almost there....
This is what we used when installing SLM 7.1: Set server System Variable BMC_SLM_JAVA_HOME to folder (e.g. c:\Program Files\java\jre1.5.0_12) (My Computer > Properties > Adv tab > Environment Variables) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Copits Sent: Thursday, June 19, 2008 7:41 AM To: arslist@ARSLIST.ORG Subject: I'm almost there This is a multi-part message in MIME format. --_=_NextPart_001_01C8D21A.893EF050 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable First, a sincere thanks to everyone for their patience, tolerance, help and suggestions during my journey through the wonderful wonderland of Remedy 7x installation and configuration... =20 Todays test of my ability to decode the obscure happened during the installation of the SLM module. I got an error message about something called "BMC_SLM_JAVA_HOME" not being set as an environment variable. I'm assuming that this is a system variable in the control panel, system properties, advanced, environment variables area and NOT someplace in AR.CFG or some other obscure XML file. Before I change anything which if I'm wrong might render 3 days of work totally trashed I thought I'd ask the experts. Am I correct in my assuming that I need to put it in as a SYSTEM environment variable and give it the path to some module (???) in Java? Thank you for your suggestions. Portions of this message may be confidential under an exemption to Ohio's= public records law or under a legal privilege. If you have received this= message in error or due to an unauthorized transmission or interception,= please delete all copies from your system without disclosing, copying, o= r transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" --_=_NextPart_001_01C8D21A.893EF050 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable ** http://www.w3.org/TR/REC-html40"; xmlns:q=3D"http://schemas.xml= soap.org/soap/envelope/" xmlns:D=3D"DAV:" xmlns:x2=3D"http://schemas.micr= osoft.com/office/excel/2003/xml" xmlns:ois=3D"http://schemas.microsoft.co= m/sharepoint/soap/ois/" xmlns:dir=3D"http://schemas.microsoft.com/sharepo= int/soap/directory/" xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#"; xmln= s:dsp=3D"http://schemas.microsoft.com/sharepoint/dsp"; xmlns:udc=3D"http:/= /schemas.microsoft.com/data/udc" xmlns:xsd=3D"http://www.w3.org/2001/XMLS= chema" xmlns:sub=3D"http://schemas.microsoft.com/sharepoint/soap/2002/1/a= lerts/" xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#"; xmlns:sp=3D"http:/= /schemas.microsoft.com/sharepoint/" xmlns:sps=3D"http://schemas.microsoft= =2Ecom/sharepoint/soap/" xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-in= stance" xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile"; xml= ns:wf=3D"http://schemas.microsoft.com/sharepoint/soap/workflow/"; xmlns:mv= er=3D"http://schemas.openxmlformats.org/markup-compatibility/2006"; xmlns:= m=3D"http://schemas.microsoft.com/office/2004/12/omml"; xmlns:mrels=3D"htt= p://schemas.openxmlformats.org/package/2006/relationships" xmlns:ex12t=3D= "http://schemas.microsoft.com/exchange/services/2006/types"; xmlns:ex12m=3D= "http://schemas.microsoft.com/exchange/services/2006/messages"; xmlns:Z=3D= "urn:schemas-microsoft-com:" xmlns=3D"http://www.w3.org/TR/REC-html40";> Question: Permission Issues with Infrastructure Change Management = 7.x <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman","serif";} a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:purple; text-decoration:underline;} p {mso-style-priority:99; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} span.EmailStyle18 {mso-style-type:personal; font-family:"Calibri&q
Re: arslist Digest - 27 May 2008 to 28 May 2008 (#2008-226)
I will be out of the office from May 23, 2008 until June 2, 2008 If you need immediate information or assistance with any of the Remedy applications, please contact Michael White at 504-426-2475. Please contact Diane Schmit at 504-426-2060 for non-Remedy related inquiries. Thanks, Maria Bertucci ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: ARS 4.5.2 license problem
You have to reapply the AR server license to the new host Id as the host Id got changed with network update. Thanks, Mohan On May 25, 2008, at 6:33 PM, "Henderson, Danielle R CNTR" <[EMAIL PROTECTED]> wrote: Hello everyone, I have problem. We are currently using ARS 4.5.2 on a unix box, with oracle database. During a network upgrade the application fail to come up. The unix admins moved the drive to a different box. For some reason all the current license keys are missing and it is showing windows license keys that we have used previously. I was able to get support purge a few licenses keys but I am receiving the following error message. ARERR (337) You have reach the maximum number of database entries permitted with this version of the Action Request System. Only the Server license can be added. I'm getting invalid keys for any user license I try to add. It is also populating the wrong HostID. I a newbie here but I have searched everywhere trying to find out where it getting the incorrect hostid with no luck. Any Ideas? I would greatly appreciate any help I can get. The work day start on Tuesday and I have to have this app back up an running before the workday starts at 6am. Danielle Henderson [EMAIL PROTECTED] L-3 Communication Titan Corp ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Menu Missing - 7.1 ARSysmtem
Nope, we don't have that one, with or without the leading 'x'. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Decou, Candace M Sent: Tuesday, May 20, 2008 12:05 PM To: arslist@ARSLIST.ORG Subject: Re: Menu Missing - 7.1 ARSysmtem I don't have that one either - Donald perhaps? It looks like you are missing any of the specific menus related to SRM. :) =20 Candace DeCou DOI Remedy Systems Analyst=20 Verizon Business=20 Office: (408) 371-1112 Email: [EMAIL PROTECTED] =20 Verizon Business - global capability, personal accountability.=20 This e-mail is strictly confidential and intended only for use by the addressee unless otherwise indicated -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis Sent: Tuesday, May 20, 2008 11:54 AM To: arslist@ARSLIST.ORG Subject: Re: Menu Missing - 7.1 ARSysmtem Thank you! Does anyone have the following menu - I found one more missing. xSYS:MNU:InfraChangeRoleCAB_locale-Q -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Savant, [EMAIL PROTECTED] Sent: Tuesday, May 20, 2008 1:27 PM To: arslist@ARSLIST.ORG Subject: Re: Menu Missing - 7.1 ARSysmtem We have the menu (see attached), I believe it's from SRM 2.1 p001. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis Sent: Tuesday, May 20, 2008 10:51 AM To: arslist@ARSLIST.ORG Subject: Menu Missing - 7.1 ARSysmtem This is a multi-part message in MIME format. --_=3D_NextPart_001_01C8BAA2.009746D7 Content-Type: text/plain; charset=3D"us-ascii" Content-Transfer-Encoding: quoted-printable I am looking for a menu called:=3D20 INT:FNDSRM:WorkOrderRoleLabel-Q - it is on the CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role - does anyone have this? =3D20 Thanks =3D20 Pam Hollis Tractor Supply Company Senior Remedy Developer Remedy Skilled Professional 615-440-4617 (Office) 615-484-4617 (Fax) [EMAIL PROTECTED] =3D20 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" --_=3D_NextPart_001_01C8BAA2.009746D7 Content-Type: text/html; charset=3D"us-ascii" Content-Transfer-Encoding: quoted-printable ** http://www.w3.org/TR/REC-html40";> <!-- /* Font Definitions */ @font-face {font-family:Raavi; panose-1:2 0 5 0 0 0 0 0 0 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline;} span.EmailStyle17 {mso-style-type:personal-compose; font-family:Arial; color:windowtext;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in;} div.Section1 {page:Section1;} --> I am looking for a menu called: =3D INT:FNDSRM:WorkOrderRoleLabel-Q – it is on the CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role =3D – does anyone have this? Thanks Pam =3D Hollis Tractor Supply =3D Company Senior Remedy Developer Remedy Skilled Professional 615-440-4617 (Office) 615-484-4617 (Fax) mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]= < /=3D span> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ --_=3D_NextPart_001_01C8BAA2.009746D7-- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Menu Missing - 7.1 ARSysmtem
We have the menu (see attached), I believe it's from SRM 2.1 p001. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis Sent: Tuesday, May 20, 2008 10:51 AM To: arslist@ARSLIST.ORG Subject: Menu Missing - 7.1 ARSysmtem This is a multi-part message in MIME format. --_=_NextPart_001_01C8BAA2.009746D7 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I am looking for a menu called:=20 INT:FNDSRM:WorkOrderRoleLabel-Q - it is on the CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role - does anyone have this? =20 Thanks =20 Pam Hollis Tractor Supply Company Senior Remedy Developer Remedy Skilled Professional 615-440-4617 (Office) 615-484-4617 (Fax) [EMAIL PROTECTED] =20 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" --_=_NextPart_001_01C8BAA2.009746D7 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable ** http://www.w3.org/TR/REC-html40";> <!-- /* Font Definitions */ @font-face {font-family:Raavi; panose-1:2 0 5 0 0 0 0 0 0 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline;} span.EmailStyle17 {mso-style-type:personal-compose; font-family:Arial; color:windowtext;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in;} div.Section1 {page:Section1;} --> I am looking for a menu called: = INT:FNDSRM:WorkOrderRoleLabel-Q – it is on the CTM:CFG-ApplicationPreferences Form for the Work Order Tab for the Role = – does anyone have this? Thanks Pam = Hollis Tractor Supply = Company Senior Remedy Developer Remedy Skilled Professional 615-440-4617 (Office) 615-484-4617 (Fax) mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ --_=_NextPart_001_01C8BAA2.009746D7-- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" int_fndsrm_menu.def Description: int_fndsrm_menu.def
Re: Workflow to audit every field on a form
What is your version of the AR System? Scott Parrish Original Message: - From: Chintan Shah [EMAIL PROTECTED] Date: Thu, 15 May 2008 14:25:11 -0700 To: arslist@ARSLIST.ORG Subject: Workflow to audit every field on a form Hi all, I was wondering if there is a better way to track who changed what field at what time and then push it to an audit trail form. I am too lazy to write individual workflow checking for TR values for every field. Thanks Chintan. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" myhosting.com - Premium Microsoft® Windows® and Linux web and application hosting - http://link.myhosting.com/myhosting ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
AR System 7.0.1 Patch 7???
I searched the archives and didn't find any information or posts about Patch 7 for 7.0.1. I'm looking for any feedback on possible problems from anyone who has installed patch 7. Primarily looking for feedback on Windows 2003/MS SQL 2000 & Mid-Tier, but any platform feed back would be helpful. Thanks, Dave Fincher BAE Systems "Pierson, Shawn" <[EMAIL PROTECTED]> wrote: Davin, You gave me some ideas, although I still haven't resolved the issue. Currently, we are authenticating against AD for the username and passwords. We have multiple ways people can log into the system, and we want the User Tool to allow people to authenticate with their domain password, while the Mid Tier will automatically log in based on their domain credentials with SSO. Also, by not using the "Cross-reference blank password" option, I get ARERROR 623 and the AuthString value still gets passed. When I have it enabled, I get the 8908 message and the authstring is passed. I might take some of the other suggestions in that other people have given as far as seeing examples of other JSP pages that do authentication. I'm not sure if I'm having this much difficulty because of something in my environment or if I am too dense at the moment. It's probably a combination of the two, so thanks for your help. If you have any other ideas I'll be glad to try to them out. Thanks, Shawn Pierson -Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Davin Lindner-Green Sent: Tuesday, April 29, 2008 1:17 PM To: arslist@ARSLIST.ORG Subject: Re: IIS remoteuser for Single-Sign On Jiri, is another term for the token an NTLM hash? Just curious. Shawn, unless I have this wrong, in the context of Remedy authentication, I belive what you are getting from your SSO in the AuthString parameter would correspond to the 4th field on the OOB login screen ("Authentication"). Typically this is unused, except in cases where it might be needed to specify a domain or other information when configuring AREA LDAP login. In the AREA LDAP Configuration form, the contents of AuthString can be passed into the LDAP search base using the syntax $\AUTHSTRING$, for example. I don't know why you have data there, but you can probably ignore it. In your case, how is authentication supposed to be handled on the server? In the context of Midtier using IWA, normally you would not then go to the AD/LDAP server, because a valid IWA login is implicity trusted, so instead you would simply connect the user using a server side AREA plugin. When you ran plugin logging did you see the failed authentication attempt there? Does that shed any light? Hope that helps, Davin Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" - Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
HELP: Reports not Running
AR 7.0.1 Patch 2 Mid-Tier Patch 5 Win Srv 2003 MSSQL 2000 Crystal Enterprise 10 Our reports from the Reports Form stopped running this morning, they were running fine yesterday. We are hoping someone may have experienced this before and knows of a fix. These are ARSystem Reports and Crystal Reports. On the Client there are no errors being generated or displayed. When the report is run the cursor goes to an hourglass for a second or two and returns to normal with nothing else happening. The client continues to function as normal. On the Mid-Tier the report generates an ARERR 9246; "Error during processing: ARERR [9246] Cannot find report [Ljava.lang.String;@83d8be of type null for form {2} on server {3}. Please see your administrator" All AR System functions appear to be normal, the only thing affected is reporting. There are no errors being reported in the AR logs, System logs or the SQL logs. Any help on this is greatly appreciated. Thanks, Dave Fincher BAE Systems - Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: BMC Support RFE Document
Although rumors of said document persist, we have not yet been told to use it (our last submission was 4/15). But if it's unavoidable, why not at least provide an automated form to collect the information? And perhaps a 'voting' mechanism so that others could champion their favorites? Personally, I think they could do a better job of translating customer requirements into an actual RFE; shifting the burden to us will undoubtedly lead to fewer, albeit more significant, submissions but with varying degrees of thoroughness. Perhaps they're being bombarded and simply want to sift out those truly interested in improving the product. Either, it's more work for us. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: Tuesday, April 22, 2008 11:52 AM To: arslist@ARSLIST.ORG Subject: BMC Support RFE Document This is a multi-part message in MIME format. --_=_NextPart_001_01C8A4A9.ED2A9C6C Content-Type: text/plain; charset="us-ascii" content-transfer-encoding: quoted-printable I don't really want to start a flame war about BMC Support, but I have a question about RFEs. I recently submitted an Issue to BMC to request an enhancement to Change Management. It's a pretty straight forward request (I asked for the Work Info to be able to be updated on Closed Change Requests) and thought it would follow the process all other RFEs had in the past, where the Support person opens the request with engineering for me. Unfortunately, I was given a *FOUR PAGE* document and told to fill it out before they would be able to look at my request. So my question is this: How many of you have had to fill out that four page document for an RFE? Keep in mind that the template is four pages, and the actual end result could be much larger. There is a section on the Word document titled "Story" where you are supposed to write a story about the change you would like to see. If it is indeed standard now to write a story to submit an RFE, I need to choose between "Goldilocks and the three CAB approvers" or something more modern like "The DougMueller Code". Thanks, Shawn Pierson Private and confidential as detailed here: http://www.sug.com/disclaimers/de= fault.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" --_=_NextPart_001_01C8A4A9.ED2A9C6C Content-Type: text/html; charset="us-ascii" content-transfer-encoding: quoted-printable ** BMC Support RFE Document I don= ’t really want to start a flame war about BMC Support, but I have a question= about RFEs. I recently submitte= d an Issue to BMC to request an enhancement to Change Management. It’s a pretty straight forward req= uest (I asked for the Work Info to be able to be updated on Closed Change Re= quests) and thought it would follow the process all other RFEs had in the past, where the Supp= ort person opens the request with engineering for me. Unfortunately, I= was given a *F= OUR PAGE* docu= ment and told to fill it out before they would be able to look at my request. So my question is t= his: How many of you have had to fill out that four page document for= an RFE? Keep in mind that t= he template is four pages, and the actual end result could be much larger. There is a section on the Word= document titled &= #8220;Story= ” where you are supposed to write a s= tory about the change you would like to see. If it is indeed standard= now to write a st= ory to submit an RFE, I need to choose between “Goldilocks and the three CAB approvers” or something more modern like “The DougMueller Code”. Thanks, Shawn Pierson Private and confidential as detailed http://www.sug.com/disclaimers/default.htm#Mail";>here. If you c= annot access hyperlink, please e-mail sender. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ --_=_NextPart_001_01C8A4A9.ED2A9C6C-- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: arslist Digest - 16 Apr 2008 to 17 Apr 2008 - Special issue (#2008-161)
I will be out of the office afternoon of April 17, 2006. If you need immediate information or assistance with any of the Remedy applications, please contact Greg Gaspard at 504-426-1037. Please contact Diane Schmit at 504-426-2060 for non-Remedy related inquiries. Thanks, Maria Bertucci ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Questions: ETL options for Remedy?
My reporting team is looking to create a small reporting warehouse with data pulled from Remedy production. We're using ARS 7.01 patch 5 on MS SQL Server 2005. We've spent quite a bit of time looking at our options and I wanted to pose a few questions to those of you on the list who are using ETL tools with Remedy. The questions are around unlimited-text fields and date translation. A little background: Our first choice was to use MS SQL Integration Services, utilizing the AR ODBC driver to avoid T-table translation. Problem is, those jobs hang on unlimited-text fields (Description, Worklog, Audit Message, etc.). The problem definitely seems to be SSIS and Remedy ODBC, since the same queries work in Access and Crystal. After going up the support chain we were reminded that SSIS was unsupported, while Access and Crystal were. So we've run into a dead end here. So our remaining options seem to be: A) AR ODBC for the small fields and straight SQL for large fields (no- go) B) Use straight SQL against t-tables for everything (would like to avoid if possible) C) Use Access or some other AR ODBC-compatible tool as an intermediate step to populate the data. (ugh) So my questions would be: 1: Is anyone else selecting unlimited-text fields such as Worklog using the AR ODBC driver? Have you run into any problems with rows that have large amounts of text? Have you found a workaround? 2: If you use straight SQL to pull Remedy data, how do you handle the translation of date/time fields? (The nice thing about AR ODBC is it handles Daylight Savings Time conversions for us.) This is particularly a problem with the Worklog field which has dates embedded in the text. 3: Are there any other simple and cost-effective ETL tools you recommend for Remedy? Any comments are greatly appreciated! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Remdy position available Phila, PA suburbs (west of phila)
Looking for mid-level to senior Remedy developer to hit the ground running in a fairly large (windows / 7.0.1 / ITSM) shop based in the Phila, PA suburbs (west of phila) area. Please contact me for details. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: This is a test
J.T. Same here. I get some but don't get others. "J.T. Shyman" <[EMAIL PROTECTED]> wrote: **v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} Did not see this message and a few others by 15:57 EDT. Trying again. J.T. Shyman Column Technologies - From: J.T. Shyman [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2008 3:29 PM To: 'arslist@ARSLIST.ORG' Subject: This is a test Im not seeing my own replies and suspect Im missing other postings as well. Sent at 15:30 EDT --- J.T. Shyman __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ - Looking for last minute shopping deals? Find them fast with Yahoo! Search. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: SSIS and Large Fields, importing large fields issues
Yes, this refers to SQL Server 2005 Integration Services. We're using ARS 7.01 patch 5. We created several SSIS packages to populate a data warehouse with several Remedy tables (HPD:Helpdesk, CHG:Task, SHR:Audit, etc.) on a nightly basis. These are very simple jobs with no transformations involved. We're using DataReader Source and connecting through the Remedy ODBC driver to get the data, then saving it to a SQL table on our reporting server. For the most part these have worked fine, but we've run into a problem with text fields such as Description, Worklog and Audit Message. When there is too much texts in any of these fields (several paragraphs, not sure of the exact size), the SSIS job simply hangs when selecting the data. The step will turn yellow and the status bar reads "[DTS.Pipeline] Information: Execute phase is beginning." But it stays that way until I stop the job. We can select these fields if they contain a small amount of text. But the job chokes when we add a few K of text to those same fields. The text fields are being transferred as DT_TEXT or DT_NTEXT. In terms of the troubleshooting we've done: - The same SELECT statement works fine on the same machine when using MS Access or Crystal Reports, with both apps using the Remedy ODBC driver and same user credentials as the SSIS package. - We've verified that the "DataReader Source" connection works fine when selecting large text fields from other databases. - We've turned off validation (though the package validates fine) and increased the buffer size in SSIS, with no luck. Logging is no help either. - We've verified we can SELECT the same text fields by querying the T tables directly and not using Remedy's ODBC driver. - We're created the package from scratch on another machine with no luck. At this rate we're sort of dead in the water. Any insights or recommendations would be much appreciated... On Mar 17, 2:32 pm, Gidd <[EMAIL PROTECTED]> wrote: > Mr/Mrs Bird: > > One can only assume you are speaking of Microsoft SQL Server Integration > Services? > Can you help us to help you? > > What version of MS SQL are you using? > What version of ARS are you using? > > Regards...Gidd > > PS: Claire ... > > > > -----Original Message- > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] > Sent: Monday, March 17, 2008 11:24 AM > To: [EMAIL PROTECTED] > Subject: SSIS and Large Fields, importing large fields issues > > We're seeing issues when moving (copying) data to our data warehouse when it > comes upon a work log field where there is a LOT of data it hangs, the job > never completes. We can cancel it and it doesn't error, it just waits. > > Anyone seeing this issue with SSIS and custom (Remedy) ODBC drivers. > I found this thread that validates that this isn't just our problem. > Unfortunately, there is no resolution in the thread or elsewhere that I > could find. > > http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1497581&Site... > > Do you have a support contract and contact for Remedy that we could open a > ticket with regarding this issue? I would believe that they may have seen > this with other customers and may even have an updated driver that works > around SSIS's limitations. > > I'll make an inquiry with Microsoft with regards to this issue and see if > there is a workaround within SSIS or a hotfix in the works. > > If those two paths are dead-ends then there are alternatives outside of SSIS > that we could explore using. > > ____ > ___ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgPlatinum > 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"- Hide > quoted text - > > - Show quoted text - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
SSIS and Large Fields, importing large fields issues
We're seeing issues when moving (copying) data to our data warehouse when it comes upon a work log field where there is a LOT of data it hangs, the job never completes. We can cancel it and it doesn't error, it just waits. Anyone seeing this issue with SSIS and custom (Remedy) ODBC drivers. I found this thread that validates that this isn't just our problem. Unfortunately, there is no resolution in the thread or elsewhere that I could find. http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1497581&SiteID=17 Do you have a support contract and contact for Remedy that we could open a ticket with regarding this issue? I would believe that they may have seen this with other customers and may even have an updated driver that works around SSIS's limitations. I'll make an inquiry with Microsoft with regards to this issue and see if there is a workaround within SSIS or a hotfix in the works. If those two paths are dead-ends then there are alternatives outside of SSIS that we could explore using. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Forcing Different Form Views
Andy, I have created an AL for each group which needs a different view and then assigned group permissions to the group which needs that particular view. Since execution is limited to the group which the AL is assigned this clearly defines which form view is opened by which group. The only exclusion I account for is in the run if statement to ensure that the proper view was opened for the administrator group. HTHs, Dave Fincher "Mayfield, Andy L." <[EMAIL PROTECTED]> wrote: Is there an easy way to have a form open in different views based on group membership? This is specifically through the WUT. We do not currently use the web-tier. I've been reading through the documentation and so far have not seen that specific question covered. ARS 7.0.01 Windows 2003 MS SQL Thanks, Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" - Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: OT:Friday Befuddlement (U)
Lists the same words for Word 2002. Technically correct but functionally unusable. Dave "Hennigan, Sandra H CTR OSD-CIO" <[EMAIL PROTECTED]> wrote: UNCLASSIFIED Word provides the synonym for "in" "formation" Meaning - in order With suggested replacements: In order In sequence In turn In rank In a row Sandra Hennigan OSD Enterprise Remedy Administrator Office # 703-602-2525 x248 Apparently, there is nothing that cannot happen today. Mark Twain -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Atherly Sent: Friday, March 07, 2008 4:06 PM To: arslist@ARSLIST.ORG Subject: Re: OT:Friday Befuddlement ** For us with different version what does it say? John Atherly American Power Conversion [EMAIL PROTECTED] 401-789-5735 Ext. 2120 1-800-788-2208 Ext. 2120 Joanne Mansur Sent by: "Action Request System discussion list(ARSList)" 03/07/2008 03:49 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: OT:Friday Befuddlement ** FYI - Does the same thing in Word 2007. Joanne Mansur Client Systems Analyst Northeastern University Phone\617.373.3295 Fax\617.373.5985 [EMAIL PROTECTED] "J.T. Shyman" Sent by: "Action Request System discussion list(ARSList)" 03/07/2008 02:17 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject [ARSLIST] OT:Friday Befuddlement ** I ran across this one yesterday and it had me laughing. For those of you that have MS Word 2003...open a document, type the word information and ask it for synonyms or look them up in the built-in thesaurus. Then, realize that this fits perfectly with Microsoft's corporate vision. --- J.T. Shyman __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" - Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Missing List Email
Is it just me or does it seem like the list is dropping emails? I have noticed on several recent threads where one or two emails seem to be missing the in the thread. This is rather troublesome because you never know when you might miss that Friday Humor post that makes your day. Thanks, Dave - Never miss a thing. Make Yahoo your homepage. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Test - please ignoe
subscription test please ignore.. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: ITSM 7 Reports - list of these available?
Ya know, its been a while but I think we got it from our sales rep! -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Friday, February 08, 2008 8:55 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7 Reports - list of these available? Donald - mind if I ask where you got this? I have been looking for something like this for quite some time. Thanks! Ty On 2/8/08, Savant, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > I can't say how current this is, but it should be a good starting point > for you. > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Julie L Kanakanui JLKANAKA > Sent: Friday, February 08, 2008 7:33 AM > To: arslist@ARSLIST.ORG > Subject: ITSM 7 Reports - list of these available? > > This is a multipart message in MIME format. > --=_alternative 005567A5852573E9_= > Content-Type: text/plain; charset="US-ASCII" > > Hello, Wondering if there is a doc somewhere that has lists of the > pre-defined reports in each of the ITSM 7 apps? Sample reports would be > > nice too, but a list would be a good start for our planning needs > > Thanks, > > > [EMAIL PROTECTED] > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > --=_alternative 005567A5852573E9_= > Content-Type: text/html; charset="US-ASCII" > > ** > > Hello, Wondering if there is a > doc somewhere that has lists of the pre-defined reports in each of the > ITSM 7 apps? Sample reports would be nice too, but a list would be > a good start for our planning needs > > Thanks, > > > [EMAIL PROTECTED] > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > --=_alternative 005567A5852573E9_=-- > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: IM installation error - Urgent help Please!
We had a similar problem loading SRM 2.1 and support said it was a bug. The workaround was to modify the corresponding entry in SHARE:Application_Properties, that's what the installer checks. But I would be very cautious given that the versioning is quite specific. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kumar, Amita Sent: Thursday, February 07, 2008 5:10 AM To: arslist@ARSLIST.ORG Subject: IM installation error - Urgent help Please! Hi All, I am trying upgrading IM 7.0.2 patch 5 to IM 7.0.3 on ARS 7.0.1 Patch 5. After the setup checks the applications installed on the server, an error screen flashes up with the following error -> " A newer version of Remedy Definitive Software Library detected on your ARSystem server, installation cannot continue. Please check Remedy customer support web site for compatibility information. http://supportweb.remedy.com " Any Idea how can I get rid of the DSL installed? Thanks & Regards, Amita This e-mail and any attachment is for authorised use by the intended recipi= ent(s) only. It may contain proprietary material, confidential information = and/or be subject to legal privilege. It should not be copied, disclosed to= , retained or used by, any other party. If you are not an intended recipien= t then please promptly delete this e-mail and any attachment and all copies= and inform the sender. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Service Request Management -Anybody using it?
We're in the process of acquiring/building SRM 2.1 and so far, it's been working pretty much as expected. A few bugs here and there and some questions about functional design. Also, it's a bit cumbersome to configure but that's because there's a lot of flexibility in the tool that you may or may not need. Overall, we're satisfied (ask me again after we rollout!!!) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Christopher Smith Sent: Wednesday, January 23, 2008 4:36 PM To: arslist@ARSLIST.ORG Subject: Service Request Management -Anybody using it? This is a multipart message in MIME format. --=_alternative 000344E1852573DA_= Content-Type: text/plain; charset="US-ASCII" Is anybody using BMC Service Request Management. Was hoping to get some feedback on the product from people that are actually using it. Thanks, Chris Smith ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" --=_alternative 000344E1852573DA_= Content-Type: text/html; charset="US-ASCII" ** Is anybody using BMC Service Request Management. Was hoping to get some feedback on the product from people that are actually using it. Thanks, Chris Smith __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ --=_alternative 000344E1852573DA_=-- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Tomcat Config GUI
This is the path for ours, we're on 7.1 though. "C:\Program Files\Apache Software Foundation\Tomcat 5.5\bin\tomcat5w.exe" //ES//Tomcat5 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Wednesday, January 23, 2008 7:51 AM To: arslist@ARSLIST.ORG Subject: Tomcat Config GUI This is a multi-part message in MIME format. --_=_NextPart_001_01C85DD7.BA311CE1 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I have MidTier 7.0.1 Patch 005 set up on all of our MidTier servers. (Windows 2003). They are configured all the same, but when I try to look for the Config GUI for Tomcat, it's nowhere to be found on three of my MidTier servers ("Apache" isn't even my program files). I do have the Apache services running so I know it's installed. I installed Tomcat from the Remedy's Mid Tier installation. =20 Does anyone have any idea how I can get the configuration GUI to work? I'd like to change the java heap size on the other three MidTier servers. Thanks! Lisa Kemes=20 AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" --_=_NextPart_001_01C85DD7.BA311CE1 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable ** Tomcat Config GUI I have MidTier 7.0.1 = Patch 005 set up on all of our MidTier servers. (Windows = 2003). They are configured all the same, but when I try to look = for the Config GUI for Tomcat, it's nowhere to be found on three of my = MidTier servers ("Apache" isn't even my program files). = I do have the Apache services running so I know it's installed. I = installed Tomcat from the Remedy's Mid Tier installation. = Does anyone have any = idea how I can get the configuration GUI to work? I'd like to = change the java heap size on the other three MidTier servers. Thanks! Lisa = Kemes AR System = Developer Tyco = Electronics 717-810-2408 tel 717-810-2124 fax [EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ --_=_NextPart_001_01C85DD7.BA311CE1-- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: SRM 2.1 and various bugs
Yes, please do. Thanks! -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, January 17, 2008 1:07 PM To: arslist@ARSLIST.ORG Subject: Re: SRM 2.1 and various bugs The fix I received from BMC indeed show that locales are the problem. I think there are 2 new filters and modification to the SRM:AppInstanceBridge form. I can send you the def fix if you want. On Jan 17, 3:52=A0pm, "Savant, [EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > We have SRM 2.1 installed in dev and noticed that fields stopped passing > to the Work Orders. =A0Oddly enough, we may have stumbled on an answer > this morning - locales. =A0We created duplicate AOT/PDT/SRD using one > locale and the fields pushed again. =A0We haven't taken it all the way > through yet, but suspect that's the root cause. =A0We're rebuilding all > the navigational categories, etc.. at the moment. > > > > -Original Message- > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] > Sent: Thursday, January 17, 2008 11:46 AM > To: [EMAIL PROTECTED] > Subject: SRM 2.1 and various bugs > > Hi, > > Does anyone have SRM 2.1 installed in dev or prod? > We have it set up but have numerous issues. =A0It is an upgrade from SRM > 2.0. > > First, it seems the email confirmation to end user on the SRM:Request > form doesn't send out. > Second, out of the box question/answer values don't push to the work > order level. > Third, the Work Order audit log shows the wrong column as modified by > (Always showing the submitter of the original request no matter who > changes it) <- this I fixed by changing the column to the proper field > but BMC says it is working as designed.. > > Those are the quick ones that I've found in our environment. > Plus all the custom forms we created in 2.0 doesn't work in 2.1 as it > says Application is not licensed. > It actually didn't work when we exported the def file and imported > into prod. =A0Yes we have a valid license. =A0We had to recreate all the > custom forms again. > > Anyone else having issues with SRM 2.1? > > > ___ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are" > > __= _=AD > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"- Hide q= uoted text - > > - Show quoted text - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Remedy 7.0.01 Patch 6 Questions
I've installed 7.0.x Patch 6 on a fresh ITSM 7.0.3(Incident/Problem/Change/Asset/SLM on ARS 7.1 patch 1) and various forms become corrupted such as the HPD:Help Desk. Patch 4 also fails (which is applied as part of the patch 6 installer). Have also tried installing the patch 6 installer on ITSM 7.0.2 and same thing happens. Has anyone else experienced form corruption when applying the 7.0.x patch? This was done on Windows 2003 Server, MS SQL 2005 and Oracle 10g R2. Jason Clarke. On 18/01/2008, Jase Brandon <[EMAIL PROTECTED]> wrote: > > ** Hello All, > I just upgraded my dev system from 7.0.01 to 7.0.01 Patch6. > Now, everytime I submit and incident, or anything... I get the > standard database timeout error, "transaction has been accepted and will > usually be processed, etc." > When I check, the record is being created, but getting the dbase timeout > on every submission. > Has anyone else seen this issue with Patch 6? I can't get anything out of > support yet, just wondering is the real guru's had seen this or any other > odd behaviour with Patch 6. > Any suggestions? I have checked all the logs and don't see anything > jumping out at me. > > Thanks in Advance, > > Jase Brandon > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: SMPM
Check out all the details on the BMC web site, the product is: Service Management Process Model. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sugavanam K K Sent: Thursday, January 17, 2008 11:46 AM To: arslist@ARSLIST.ORG Subject: SMPM --0-1967504429-1200599188=:84202 Content-Type: text/plain; charset=us-ascii Hi All, Do any one know what SMPM is and for it is used. Information on SMPM is appreciated. Thanks in advace. Regards, Sugan Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" --0-1967504429-1200599188=:84202 Content-Type: text/html; charset=us-ascii ** <!-- DIV {margin:0px;} -->Hi All, Do any one know what SMPM is and for it is used. Information on SMPM is appreciated. Thanks in advace. Regards, Sugan Looking for last minute shopping deals? http://us.rd.yahoo.com/evt=51734/*http://tools.search.yahoo.com/ne wsearch/category.php?category=shopping"> Find them fast with Yahoo! Search. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ --0-1967504429-1200599188=:84202-- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: SRM 2.1 and various bugs
We have SRM 2.1 installed in dev and noticed that fields stopped passing to the Work Orders. Oddly enough, we may have stumbled on an answer this morning - locales. We created duplicate AOT/PDT/SRD using one locale and the fields pushed again. We haven't taken it all the way through yet, but suspect that's the root cause. We're rebuilding all the navigational categories, etc.. at the moment. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, January 17, 2008 11:46 AM To: arslist@ARSLIST.ORG Subject: SRM 2.1 and various bugs Hi, Does anyone have SRM 2.1 installed in dev or prod? We have it set up but have numerous issues. It is an upgrade from SRM 2.0. First, it seems the email confirmation to end user on the SRM:Request form doesn't send out. Second, out of the box question/answer values don't push to the work order level. Third, the Work Order audit log shows the wrong column as modified by (Always showing the submitter of the original request no matter who changes it) <- this I fixed by changing the column to the proper field but BMC says it is working as designed.. Those are the quick ones that I've found in our environment. Plus all the custom forms we created in 2.0 doesn't work in 2.1 as it says Application is not licensed. It actually didn't work when we exported the def file and imported into prod. Yes we have a valid license. We had to recreate all the custom forms again. Anyone else having issues with SRM 2.1? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Activating an AR System to Vendor Data Exchange (EIE Again) via Workflow
ARS 7.0.1 patch 6 Remedy Link for SQL Server 7.0.1 patch 5 (EIE service on another Win 2K3 box) Windows 2003 SP2 SQL Server 2000 SP4 (separate hardware) So in reading the EIE admin guide, it tells me that I can trigger an AR System to Vendor data exchange by creating a new record in the Application Pending form. Very cool, this is what I've been looking for now that I've been able to upgrade Remedy Link for SQL Server to 7.0.1. The guide tells me to create a record in the Application pending form like this (quoting): "In the Other Short field, type the key or the AR System request ID for the record that you want to include in the data exchange, or invoke all records configured for a data exchange using one or more of the parameters inTable 6-1." So to test this, I created a new record in the Application Pending form with "-r 0213688|0213232" in the Other Short field (quotes added for readability). I waited patiently for the request to get picked up, and in watching the data exchange's debug log, a bulk exchange was triggered instead of the single record I thought I specified. So I stopped the EIE service and deleted this AP record. So to see what else might be needed, I used eiexfer.exe to create an Application Pending record for the same request ID for the same data exchange. The AP record that was created had a few more fields filled out. Category = EIE Command = the name of the data exchange Form = the instance name of the EIE service Source ID = New Tag = On Scheduled Interval Other Short = same as above When this request was picked up, it also activated a bulk data exchange, so I stopped EIE and deleted this AP record. Next (and this is all I've done so far), I manually created an AP record with all of the data immediately above, but I added "-s " (again, quotes for readability) to the Other Short field, since the EIE admin guide specified that the -s option is required for single records. This AP record also triggered a bulk exchange. I have submitted a ticket with BMC, but I usually get better answers here anyway. Thanks, everyone. Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Remedy Link for SQL Server (EIE) Function Syntax
Oops. Forgot this. ARS 7.0.1 patch 6 Remedy Link for SQL Server 7.0.1 patch 5 Windows 2003 SP2 SQL Server 2000 SP4 (separate hardware) Mike On Jan 10, 12:32 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Quick question since the EIE admin guide isn't any help. > > What's the syntax for using EIE functions in data mappings? I have the > Last Modified By field on SHARE:Contact mapped to a field in my > external vendor database and the column in my vendor database is > limited to 20 characters, so I want to use the LEFT() function to > truncate the value coming from Remedy. > > I inserted the left function using the rules dialog on the > EIE:DataMapping form, which resulted in a mapping of > > function|left(Last Modified By, 20) > > However, EIE doesn't like this. Here's from the data exchange debug > log: > > [10:33:42,01/10/08] - SqlServer.Initialize: Verifying configuration > parameters > [10:33:42,01/10/08] - Scheduled Only mode > [10:33:42,01/10/08] - CONNECT eFO, USER scc_super_reader (Native > Database) > [10:33:42,01/10/08] - SET CONCAT_NULL_YIELDS_NULL OFF > [10:33:42,01/10/08] - StartDataHandlers: Connection established to > both AR/CMDB and vendor application. > [10:33:42,01/10/08] - >>>AR System Rules: > [10:33:55,01/10/08] - Rules in RuleSet: 'eFO Person Update' > [10:33:55,01/10/08] - Rule 1: Set to data > type: 4 (Character) > [10:33:55,01/10/08] - Rule 2: Set to data > type: 4 (Character) > [10:33:55,01/10/08] - Rule 3: Set to data > type: 4 (Character) > [10:33:55,01/10/08] - Rule 4: Set to data > type: 7 (Date/Time) > [10:33:55,01/10/08] - Rule 5: Set to data type: > 4 (Character) > [10:33:55,01/10/08] - Rule 6: Set to data > type: 4 (Character) > [10:33:55,01/10/08] - Rule 7: Set to data > type: 4 (Character) > [10:33:55,01/10/08] - Rule 8: Set to > data type: 4 (Character) > [10:33:55,01/10/08] - Rule 9: Set to data > type: 4 (Character) > [10:33:55,01/10/08] - Rule 10: Set to > data type: 6 (Enum) > [10:33:55,01/10/08] - Rule 11: > Set to data type: 6 (Enum) > [10:33:55,01/10/08] - Rule 12: Set to data > type: 4 (Character) > [10:33:55,01/10/08] - Rule 13: Set to > data type: 6 (Enum) > [10:33:55,01/10/08] - Rule 14: Set to > data type: 4 (Character) > [10:33:55,01/10/08] - Rule 15: Set to > data type: 4 (Character) > [10:33:55,01/10/08] - Rule 16: > Set to data type: 4 (Character) > [10:33:55,01/10/08] - Rule 17: Set to data > type: 4 (Character) > [10:33:55,01/10/08] - Rule 18: Set to > data type: 4 (Character) > [10:33:55,01/10/08] - Rule 19: Set to data type: 2 > (Integer) > [10:33:55,01/10/08] - Rule 20: Set to data > type: 4 (Character) > [10:33:55,01/10/08] - Rule 21: Set to > data type: 4 (Character) > [10:33:55,01/10/08] - Rule 22: Set to > data type: 4 (Character) > [10:33:55,01/10/08] - Rule 23: Set to > data type: 4 (Character) > [10:33:55,01/10/08] - Rule 24: > Set to data type: 4 (Character) > [10:33:55,01/10/08] - *** Field Mapping error for Rule 24 *** > [10:33:55,01/10/08] - --> ValidateParmType: 2 required parameters not > supplied for function LEFT(). > [10:33:55,01/10/08] - *** Field Mapping Error for function|left(Last > Modified By, 20) *** > [10:33:55,01/10/08] - --> ValidateParmType: 2 required parameters not > supplied for function LEFT(). > > [10:33:55,01/10/08] - Key Rule 1: Set to > data type: 4 (Character) > [10:33:55,01/10/08] - Delete Rule 1: Set to data type: 2 > (Integer) > [10:33:55,01/10/08] - >>>AR System Keys: > [10:33:56,01/10/08] - Key field: 'EFO Per_ID (id: 60085)' > [10:33:56,01/10/08] - >>>AR System Query: > [10:33:56,01/10/08] - No query defined. All entries will be processed. > [10:33:56,01/10/08] - >>>Vendor Rules: > > What's wrong with the syntax I have above? Should I be putting $ > around the AR field name? > > Thanks. > > Mike > > ___ > 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"
Remedy Link for SQL Server (EIE) Function Syntax
Quick question since the EIE admin guide isn't any help. What's the syntax for using EIE functions in data mappings? I have the Last Modified By field on SHARE:Contact mapped to a field in my external vendor database and the column in my vendor database is limited to 20 characters, so I want to use the LEFT() function to truncate the value coming from Remedy. I inserted the left function using the rules dialog on the EIE:DataMapping form, which resulted in a mapping of function|left(Last Modified By, 20) However, EIE doesn't like this. Here's from the data exchange debug log: [10:33:42,01/10/08] - SqlServer.Initialize: Verifying configuration parameters [10:33:42,01/10/08] - Scheduled Only mode [10:33:42,01/10/08] - CONNECT eFO, USER scc_super_reader (Native Database) [10:33:42,01/10/08] - SET CONCAT_NULL_YIELDS_NULL OFF [10:33:42,01/10/08] - StartDataHandlers: Connection established to both AR/CMDB and vendor application. [10:33:42,01/10/08] - >>>AR System Rules: [10:33:55,01/10/08] - Rules in RuleSet: 'eFO Person Update' [10:33:55,01/10/08] - Rule 1: Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 2: Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 3: Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 4: Set to data type: 7 (Date/Time) [10:33:55,01/10/08] - Rule 5: Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 6: Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 7: Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 8: Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 9: Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 10: Set to data type: 6 (Enum) [10:33:55,01/10/08] - Rule 11: Set to data type: 6 (Enum) [10:33:55,01/10/08] - Rule 12: Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 13: Set to data type: 6 (Enum) [10:33:55,01/10/08] - Rule 14: Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 15: Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 16: Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 17: Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 18: Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 19: Set to data type: 2 (Integer) [10:33:55,01/10/08] - Rule 20: Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 21: Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 22: Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 23: Set to data type: 4 (Character) [10:33:55,01/10/08] - Rule 24: Set to data type: 4 (Character) [10:33:55,01/10/08] - *** Field Mapping error for Rule 24 *** [10:33:55,01/10/08] - --> ValidateParmType: 2 required parameters not supplied for function LEFT(). [10:33:55,01/10/08] - *** Field Mapping Error for function|left(Last Modified By, 20) *** [10:33:55,01/10/08] - --> ValidateParmType: 2 required parameters not supplied for function LEFT(). [10:33:55,01/10/08] - Key Rule 1: Set to data type: 4 (Character) [10:33:55,01/10/08] - Delete Rule 1: Set to data type: 2 (Integer) [10:33:55,01/10/08] - >>>AR System Keys: [10:33:56,01/10/08] - Key field: 'EFO Per_ID (id: 60085)' [10:33:56,01/10/08] - >>>AR System Query: [10:33:56,01/10/08] - No query defined. All entries will be processed. [10:33:56,01/10/08] - >>>Vendor Rules: What's wrong with the syntax I have above? Should I be putting $ around the AR field name? Thanks. Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: 7.1 mid tier w/IIS and SSL
That explains it! No worries, thanks for the prompt reply LJ! -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ LongWing (Head) Sent: Wednesday, January 09, 2008 8:57 AM To: arslist@ARSLIST.ORG Subject: Re: 7.1 mid tier w/IIS and SSL Ahseemud on my faceyou said CI Viewer (CMDB thing right?) and I read CR ViewerLOLmy bad...sorry for any confusion I caused -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Savant, [EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 9:31 AM To: arslist@ARSLIST.ORG Subject: Re: 7.1 mid tier w/IIS and SSL Yes, it is true that you need a CR Server for reporting on the web but the CI Viewer is not a Crystal Report. Yes, we have changed the 'Default Web Path' setting. If we had not, the CI Viewer would not work at all. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ LongWing (Head) Sent: Wednesday, January 09, 2008 8:28 AM To: arslist@ARSLIST.ORG Subject: Re: 7.1 mid tier w/IIS and SSL I don't have information to the contrary...mostly because I don't use CR...but it was my understanding that the only way you could get Reporting working on the Mid-Tier was to have a CR Server configured properly. One setting that just came to mind was the 'Default Web Path' option found on the advanced tab of server properties...was that configured with the new https url? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Savant, [EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 8:53 AM To: arslist@ARSLIST.ORG Subject: Re: 7.1 mid tier w/IIS and SSL Thanks for the reply! Although we do intend to add SSL to the report server in the near future, it was my understanding that the CI Viewer doesn't use CR. We believe this to be true because CI Viewer was working for us even before we got the CR server. Do you have information to the contrary? Thanks. - Don -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ LongWing (Head) Sent: Wednesday, January 09, 2008 7:37 AM To: arslist@ARSLIST.ORG Subject: Re: 7.1 mid tier w/IIS and SSL This is a multi-part message in MIME format. --=_NextPart_000_0033_01C8529A.C4F941D0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Is your CR web server also using SSL?...if not, then it is mixed content...one option of course would be to add ssl to your CR Web server _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Savant, [EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 8:31 AM To: arslist@ARSLIST.ORG Subject: 7.1 mid tier w/IIS and SSL ** After enabling an SSL cert on our 7.1 mid tier, everything seems to be OK under https except for the CI Viewer - it runs but gives the annoying message 'This page contains both secure and non-secure items.'. Changing the 'Display mixed content' setting in IE from 'Prompt' to 'Enable' seems to be an effective workaround but it is a global setting plus it may still prove to be a nuisance for our customers. Has anyone figured out a way around this problem? Thanks in advance. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" --=_NextPart_000_0033_01C8529A.C4F941D0 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable ** 7.1 mid tier w/IIS and SSL Is your CR web server also using SSL?...if not, = then it is=20 mixed content...one option of course would be to add ssl to your CR Web=20 server From: Action Request System = discussion=20 list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Savant,=20 [EMAIL PROTECTED]Sent: Wednesday, January 09, 2008 8:31 = AMTo:=20 arslist@ARSLIST.ORGSubject: 7.1 mid tier w/IIS and=20 SSL **=20 After enabling an SSL cert on our 7.1 mid tier, everything = seems to be OK=20 under https except for the CI Viewer – it runs but gives the = annoying message=20 ‘This page contains both secure and non-secure = items…’. Changing the=20 ‘Display mixed content’ setting in IE from = ‘Prompt’ to ‘Enable’ seems to be an=20 effective workaround but it is a global setting plus it may still prove = to be a=20 nuisance for our customers. Has anyone figured out a way around = this=20 problem? Thanks in advance.__Platinum Sponsor: www.rmsportal.com ARSlist: = "Where the=20 Answers Are" html__
Re: 7.1 mid tier w/IIS and SSL
Yes, it is true that you need a CR Server for reporting on the web but the CI Viewer is not a Crystal Report. Yes, we have changed the 'Default Web Path' setting. If we had not, the CI Viewer would not work at all. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ LongWing (Head) Sent: Wednesday, January 09, 2008 8:28 AM To: arslist@ARSLIST.ORG Subject: Re: 7.1 mid tier w/IIS and SSL I don't have information to the contrary...mostly because I don't use CR...but it was my understanding that the only way you could get Reporting working on the Mid-Tier was to have a CR Server configured properly. One setting that just came to mind was the 'Default Web Path' option found on the advanced tab of server properties...was that configured with the new https url? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Savant, [EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 8:53 AM To: arslist@ARSLIST.ORG Subject: Re: 7.1 mid tier w/IIS and SSL Thanks for the reply! Although we do intend to add SSL to the report server in the near future, it was my understanding that the CI Viewer doesn't use CR. We believe this to be true because CI Viewer was working for us even before we got the CR server. Do you have information to the contrary? Thanks. - Don -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ LongWing (Head) Sent: Wednesday, January 09, 2008 7:37 AM To: arslist@ARSLIST.ORG Subject: Re: 7.1 mid tier w/IIS and SSL This is a multi-part message in MIME format. --=_NextPart_000_0033_01C8529A.C4F941D0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Is your CR web server also using SSL?...if not, then it is mixed content...one option of course would be to add ssl to your CR Web server _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Savant, [EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 8:31 AM To: arslist@ARSLIST.ORG Subject: 7.1 mid tier w/IIS and SSL ** After enabling an SSL cert on our 7.1 mid tier, everything seems to be OK under https except for the CI Viewer - it runs but gives the annoying message 'This page contains both secure and non-secure items.'. Changing the 'Display mixed content' setting in IE from 'Prompt' to 'Enable' seems to be an effective workaround but it is a global setting plus it may still prove to be a nuisance for our customers. Has anyone figured out a way around this problem? Thanks in advance. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" --=_NextPart_000_0033_01C8529A.C4F941D0 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable ** 7.1 mid tier w/IIS and SSL Is your CR web server also using SSL?...if not, = then it is=20 mixed content...one option of course would be to add ssl to your CR Web=20 server From: Action Request System = discussion=20 list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Savant,=20 [EMAIL PROTECTED]Sent: Wednesday, January 09, 2008 8:31 = AMTo:=20 arslist@ARSLIST.ORGSubject: 7.1 mid tier w/IIS and=20 SSL **=20 After enabling an SSL cert on our 7.1 mid tier, everything = seems to be OK=20 under https except for the CI Viewer – it runs but gives the = annoying message=20 ‘This page contains both secure and non-secure = items…’. Changing the=20 ‘Display mixed content’ setting in IE from = ‘Prompt’ to ‘Enable’ seems to be an=20 effective workaround but it is a global setting plus it may still prove = to be a=20 nuisance for our customers. Has anyone figured out a way around = this=20 problem? Thanks in advance.__Platinum Sponsor: www.rmsportal.com ARSlist: = "Where the=20 Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ --=_NextPart_000_0033_01C8529A.C4F941D0-- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: 7.1 mid tier w/IIS and SSL
Thanks for the reply! Although we do intend to add SSL to the report server in the near future, it was my understanding that the CI Viewer doesn't use CR. We believe this to be true because CI Viewer was working for us even before we got the CR server. Do you have information to the contrary? Thanks. - Don -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ LongWing (Head) Sent: Wednesday, January 09, 2008 7:37 AM To: arslist@ARSLIST.ORG Subject: Re: 7.1 mid tier w/IIS and SSL This is a multi-part message in MIME format. --=_NextPart_000_0033_01C8529A.C4F941D0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Is your CR web server also using SSL?...if not, then it is mixed content...one option of course would be to add ssl to your CR Web server _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Savant, [EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 8:31 AM To: arslist@ARSLIST.ORG Subject: 7.1 mid tier w/IIS and SSL ** After enabling an SSL cert on our 7.1 mid tier, everything seems to be OK under https except for the CI Viewer - it runs but gives the annoying message 'This page contains both secure and non-secure items.'. Changing the 'Display mixed content' setting in IE from 'Prompt' to 'Enable' seems to be an effective workaround but it is a global setting plus it may still prove to be a nuisance for our customers. Has anyone figured out a way around this problem? Thanks in advance. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" --=_NextPart_000_0033_01C8529A.C4F941D0 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable ** 7.1 mid tier w/IIS and SSL Is your CR web server also using SSL?...if not, = then it is=20 mixed content...one option of course would be to add ssl to your CR Web=20 server From: Action Request System = discussion=20 list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Savant,=20 [EMAIL PROTECTED]Sent: Wednesday, January 09, 2008 8:31 = AMTo:=20 arslist@ARSLIST.ORGSubject: 7.1 mid tier w/IIS and=20 SSL **=20 After enabling an SSL cert on our 7.1 mid tier, everything = seems to be OK=20 under https except for the CI Viewer – it runs but gives the = annoying message=20 ‘This page contains both secure and non-secure = items…’. Changing the=20 ‘Display mixed content’ setting in IE from = ‘Prompt’ to ‘Enable’ seems to be an=20 effective workaround but it is a global setting plus it may still prove = to be a=20 nuisance for our customers. Has anyone figured out a way around = this=20 problem? Thanks in advance.__Platinum Sponsor: www.rmsportal.com ARSlist: = "Where the=20 Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ --=_NextPart_000_0033_01C8529A.C4F941D0-- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: 7.1 mid tier w/IIS and SSL
Thanks for the quick reply and suggestion J.T.! -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Wednesday, January 09, 2008 7:36 AM To: arslist@ARSLIST.ORG Subject: Re: 7.1 mid tier w/IIS and SSL This is a multi-part message in MIME format. --=_NextPart_000_00B2_01C852AB.6C0D10E0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit The only step I can recommend would be to see if you can figure out where the HTTP references are. One way to do that might be to connect to your mid-tier using a browser over HTTPS then go to a form that uses the CI Viewer. When you get the error try to view the source of the page and search for HTTP:// Once you find those it may lead in the direction of the badly behaving component. J.T. Shyman Column Technologies _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Savant, [EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 10:31 AM To: arslist@ARSLIST.ORG Subject: 7.1 mid tier w/IIS and SSL After enabling an SSL cert on our 7.1 mid tier, everything seems to be OK under https except for the CI Viewer - it runs but gives the annoying message 'This page contains both secure and non-secure items.'. Changing the 'Display mixed content' setting in IE from 'Prompt' to 'Enable' seems to be an effective workaround but it is a global setting plus it may still prove to be a nuisance for our customers. Has anyone figured out a way around this problem? Thanks in advance. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" --=_NextPart_000_00B2_01C852AB.6C0D10E0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable ** http://www.w3.org/TR/REC-html40";> 7.1 mid tier w/IIS and SSL <!-- /* Font Definitions */ @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} @font-face {font-family:Perpetua; panose-1:2 2 5 2 6 4 1 2 3 3;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline;} p {mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman";} span.EmailStyle18 {mso-style-type:personal-reply; font-family:Arial; color:navy;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in;} div.Section1 {page:Section1;} --> The only step I can recommend would = be to see if you can figure out where the HTTP references are. One way to do = that might be to connect to your mid-tier using a browser over HTTPS then go = to a form that uses the CI Viewer. When you get the error try to view the = source of the page and search for HTTP:// Once you find those it may lead in = the direction of the badly behaving component. J.T. Shyman Column = Technologies From: = Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Savant, = [EMAIL PROTECTED] Sent: Wednesday, January = 09, 2008 10:31 AM To: = arslist@ARSLIST.ORG Subject: 7.1 mid tier = w/IIS and SSL After enabling an SSL cert on our 7.1 mid tier, = everything seems to be OK under https except for the CI Viewer – it runs but gives = the annoying message ‘This page contains both secure and non-secure items…’. Changing the ‘Display mixed = content’ setting in IE from ‘Prompt’ to ‘Enable’ seems to = be an effective workaround but it is a global setting plus it may still prove = to be a nuisance for our customers. Has anyone figured out a way around = this problem? Thanks in advance. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" = html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ --=_NextPart_000_00B2_01C852AB.6C0D10E0-- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
7.1 mid tier w/IIS and SSL
After enabling an SSL cert on our 7.1 mid tier, everything seems to be OK under https except for the CI Viewer - it runs but gives the annoying message 'This page contains both secure and non-secure items...'. Changing the 'Display mixed content' setting in IE from 'Prompt' to 'Enable' seems to be an effective workaround but it is a global setting plus it may still prove to be a nuisance for our customers. Has anyone figured out a way around this problem? Thanks in advance. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
7.1 mid tier w/IIS and SSL
After enabling an SSL cert on our 7.1 mid tier, everything seems to be OK under https except for the CI Viewer - it runs but gives the annoying message 'This page contains both secure and non-secure items...'. Changing the 'Display mixed content' setting in IE from 'Prompt' to 'Enable' seems to be an effective workaround but it is a global setting plus it may still prove to be a nuisance for our customers. Has anyone figured out a way around this problem? Thanks in advance. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
7.1 mid tier w/IIS and SSL
After enabling an SSL cert on our 7.1 mid tier, everything seems to be OK under https except for the CI Viewer - it runs but gives the annoying message 'This page contains both secure and non-secure items...'. Changing the 'Display mixed content' setting in IE from 'Prompt' to 'Enable' seems to be an effective workaround but it is a global setting plus it may still prove to be a nuisance for our customers. Has anyone figured out a way around this problem? Thanks in advance. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
7.x Notification Groups?
Listers: Has anyone found a way to enable non-support groups within the ITSM 7 application? We use Remedy 5 notification groups for SLA notifications and contract reminders but 7.x doesn't seem to allow for the same functionality. Suggestions? Thanks for reading. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Generating ticket request number after push fields.
Would the Run if qualification be OPERATION = SET, execute on Modify? and then just do a push field where the change id gets pushed back into the custom form? On Dec 10, 2:37 pm, "Wheeler, Dylan" <[EMAIL PROTECTED]> wrote: > If you are pushing the id of the custom form to the CHG form you could > have a filter on the CHG form push the newly created CHG ID back to the > custom form. > Then you could use those two ID's to link up changes between the forms. > > - > > Dylan Wheeler > Production Control Analyst Principal > IT Operations > Downey Savings & Loan Association, F.A. > Email: [EMAIL PROTECTED] > > > > -Original Message- > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] > Sent: Monday, December 10, 2007 11:32 AM > To: [EMAIL PROTECTED] > Subject: Generating ticket request number after push fields. > > Hello All, > > I built a custom form and when a user hits save on the form, I have a > filter that fires with a push fields action to send all the data from > the custom form into the Change Form. > > Now they "higher ups", want a way to get the Change ticket number into > the custom form. They also want any changes made in the Change form to > push back to the matching custom ticket number. > > Is this something just as simple as another push fields filter? How > would I match the request ID's together since I'm not even sure what the > change number is because it doesn't give a pop up window with the change > ticket number after saving the custom ticket? > > Appreciate any help you can give me. > > > ___ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgPlatinum > Sponsor:www.rmsportal.comARSlist: "Where the Answers Are" > > This message and any attachments are for the intended recipient(s) only and > may contain privileged, confidential and/or proprietary information about > Downey Savings or its customers, which Downey Savings does not intend to > disclose to the public. If you received this message by mistake, please > notify the sender by reply e-mail and delete the message and attachments. > > ___- > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"- Hide > quoted text - > > - Show quoted text - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Generating ticket request number after push fields.
Hello All, I built a custom form and when a user hits save on the form, I have a filter that fires with a push fields action to send all the data from the custom form into the Change Form. Now they "higher ups", want a way to get the Change ticket number into the custom form. They also want any changes made in the Change form to push back to the matching custom ticket number. Is this something just as simple as another push fields filter? How would I match the request ID's together since I'm not even sure what the change number is because it doesn't give a pop up window with the change ticket number after saving the custom ticket? Appreciate any help you can give me. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: How can I display User parameters on Crystal Report
Bruce, We currently have a couple of reports that we do this with. The general principal is to collect the users report parameters and then push those parameters into a temp field on the record(s) which will be displayed in the report. After the report is executed we do another push field back to the form to delete the report parameters from the temp fields. For what it's worth, we have always had to rework reports after an upgrade or migration to get the to work. There have been several reports which we have had to abandon because they worked once and we could never get them to work again. BMC/Remedy Tech. Support always points the finger to our server configuration, but will never provide a solid configuation which will work. The cavet to all of this is that we run 98% of our applications on the Mid Tier with 30+ Crystal Reports available for users. Crystal Reports integration into ARS is absolutely one of the worst areas of integration for ARS. One would think that after YEARS of customers and developers complaining about the integration process and problems that BMC/Remedy would actually try to resolve the issue. I have no love for Crystal Reports, but I have seen implementations of Crystal Reports in applications that are far better than what BMC had done with ARS. Even Microsoft has had decent reporting in Access for over a decade now. One would think that during this time BMC/Remedy would be able to provide an integrated report tool that was actually usable. HTH's Dave Fincher "Wilson, Bruce B" <[EMAIL PROTECTED]> wrote: ** st1\:*{behavior:url(#default#ieooui) }I would like to know if there is a way to pass parameters (for example the parameters the user selected on a dialog window) to a Crystal Report and have them displayed on the Crystal Report called from Remedy. Having fought the gritty never-ending battle to produce Crystal Reports that dont fail when called from Remedy or after migration require massaging, I am starting to wonder if I would be better off using SQL Server Reporting Services as a replacement for Crystal Reports technology. Too long I find myself hanging on to what seems to be counter-productive rapid application development tools. Realizing I cant [currently] just pass parameters to a Crystal Report and have them displayed really paints a good picture for me of how inadequate it is. Does anyone have any success stories theyd like to share using Reporting Services and how difficult to transition to the technology? I am using SQL Server 2005. Thank you, Bruce Wilson Norfolk Southern Corporation C&S Remedy Administrator __20060125___This posting was submitted with HTML in it___ - Never miss a thing. Make Yahoo your homepage. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: CMDB 2.1.0.001
According to Support, the patch is still in restricted release. I'm awaiting their explanation as to why they would send out a notification for a patch that has not yet been released. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Thursday, November 29, 2007 12:09 PM To: arslist@ARSLIST.ORG Subject: CMDB 2.1.0.001 This last Tuesday, BMC released a Technical Bulletin dated 15 November about Patch 001 to CMDB 2.1.0, along with a Patch 001 to AIE 7.1.00 and the missing Release Notes for SLM 7.1.00. I have yet to find the patch for the CMDB in the Patch Downloads for BMC Remedy Products interface (the one for AIE is there). Has anyone spotted it somewhere else? Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
BMC Service Request Management
Is there any one out there who has implemented BMC Service Request Management and is actually using the tool in a production environment? Looking for any installation, user and troubleshooting issues you may have encountered. Scott Parrish IT Prophets, LLC (770) 653-5203 mail2web.com What can On Demand Business Solutions do for you? http://link.mail2web.com/Business/SharePoint ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Changing banner of all forms
Just a guess, but I would look at saving the image in a common location or in the users home directory and then reference it through css. I know you could do this with the Mid-Tier but I am not sure if it would work on the client. HTHs Dave "Muhammed, Siraj" <[EMAIL PROTECTED]> wrote: ** Hi listers, It is difficult to change banner of all the forms with our customer logo. Is there any common place where we can save our logo and pick up when ever any form opens? We are using ARS 7 Thanks and Regards Siraj P M This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. __20060125___This posting was submitted with HTML in it___ - Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: How to show data attributes in a Table Field?
Hi Mark Milke, Maybe Field.DataType could help you. It is included in API 7.1 BR Mark On Nov 23, 10:33 pm, Mark Milke <[EMAIL PROTECTED]> wrote: > Hi everyone, > > I was wondering what would it take to should the attributes of a > Ticket in a Table Field? > > I mean something like this: > > Table Field > -- > | Field Name | FieldValue | > - > | Request-ID |001| > | Field_1 | some datahere| > | Field_2 | some datahere| > | Filed_3 | you get theidea | > -- > > How to do something like this? > > Regards, > > Mark Milke > > ___- > 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"
Excute Active Link in Microsoft Automation program
Hi All Here is my scenario: One display only form, it is a control panel face to normal user. And many active link will active after user input values in this form. One of them is, user input a "last name", press "enter", the other field including "last name", "first name", will be got from other information normal form. I'm trying build a VB program using ARUSER.tlb to do this. I do not know how to excute active link in this program. And I only find there is method OpenGuide but NO excuteActiveLink. So, I build one guide just fire one active link with code as below, { Set ARForm = App.OpenForm(SessionId, strServer, "Employee_ControlPanel", ARSubmit, True) Set LastName = ARForm.GetField("Last Name") LastName.Value = Text1.Text ARForm.GiveFieldFocus ("Last Name") Call App.OpenGuide(SessionId, "test", strServer) ARForm.Submit } The problem is "Call App.OpenGuide(SessionId, "test", strServer)" sentence will open new form, the "last name" value will be blank Any body could help me? Or tell me another way to archive this automation task. Please help BR Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Printing Tickets in Web Client
You'll need Crystal Web or Crystal Enterprise 10/11 for this. hth Dave Fincher Mark <[EMAIL PROTECTED]> wrote: **Hi all, are there any know probs with printing a Ticket in ITSM7 (Web Client)? Do I need a local Crystal Client for this? Thx Mark __20060125___This posting was submitted with HTML in it___ - Never miss a thing. Make Yahoo your homepage. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: New installation of Mid-Tier displays only blank page
Probably not the fix for you as you mention just a blank screen, but may be worth checking... *Symptom: "Page not found" errors on Mid Tier 7.x installation with MS IIS and Tomcat* You might have a problem after you install BMC Remedy Mid Tier 7.0.01 using Microsoft Internet Information Services (IIS) with the Tomcat application server. You may discover that when you attempt to open a form or configuration tool page that "page not found" errors appear in your browser. Solution Make sure that the Tomcat filter is properly added. If the filter is not added properly or if you reinstalled Tomcat, add the filter manually as follows: 1. Open IIS Manager. 2. Select your web site under Web Sites. 3. On the Action menu, click Properties. 4. In the properties dialog box, click the ISAPI Filters tab, then click Add to open the Add/Edit Filter Properties dialog box. 5. In the Filter name box, type jakarta. 6. In the Executable box, type C:\Program Files\Apache Software Foundation\Jakarta Isapi Redirector\bin\isapi_redirect.dll or browse to the file. 7. Click OK to close the Add/Edit Filter Properties dialog box, and click OK again to close the web site properties dialog box. 8. Stop and restart the web server. *Self Help Document* ID: KM-01003752 Type: Problem Solution Regards Jason Clarke On 19/11/2007, Durrant, Michael M. - ITSD <[EMAIL PROTECTED]> wrote: > > It sounds like your JSP engine is not happy - have you checked your > Tomcat log files to see if something is failing? > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin > Sent: Monday, November 19, 2007 10:42 AM > To: arslist@ARSLIST.ORG > Subject: New installation of Mid-Tier displays only blank page > > Hello Everyone, > > We have installed Mid-Tier 7.1 on a Windows 2003 server, IIS 6 web > server. > We used the bundled Tomcat as the JSP engine. > We also installed Crystal Reports Server XI. > > The web server displays html pages OK, but when we try to access Remedy > or connect to "config.jsp " from the local host we just get a blank white > screen. > > The set-up is identical to the old server that does work, at least as > far as we can see, and we have tried re-installing Mid-tier and > rebooting the web server. > > Any idea what might be wrong? > > Dwayne Martin > James Madison University > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum > Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > The information contained in this email may be privileged, confidential or > otherwise protected from disclosure. All persons are advised that they may > face penalties under state and federal law for sharing this information with > unauthorized individuals. If you received this email in error, please reply > to the sender that you have received this information in error. Also, > please delete this email after replying to the sender. > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: How AR System ODBC Data Source Driver is reset when the status report option in Helpdesk application is used
If you are using a Preference Server, the "AR System User Preference" form "Advanced" tab has an "ODBC Use Undersocres" setting. The system will use the setting to control the ODBC if the user is calling the Preference Server. If your not using a Preference Server you may have to set the Use Underscore in the report and in your ODBC settings. HTHs Dave Fincher Thad K Esser <[EMAIL PROTECTED]> wrote: ** When we had the exact same error, we tracked it down to whether or not the user was using a preference server. If they used a preference server when logging in, it would put a seemingly random number in the "Private RPC Socket" field of the ODBC config. I never checked if it was resetting the underscores. Hope that helps, Thad Esser Remedy Developer "Argue for your limitations, and sure enough, they're yours."-- Richard Bach "Jorge Polo" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" 11/09/2007 10:48 AMPlease respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject How AR System ODBC Data Source Driver is reset when the status report option in Helpdesk application is used ** Hello Everyone, When a user is in the Remedy user Helpdesk application there is a menu item named "Shortcut" that allows to print a status history of a case. The user receives an error "Error occurred generating report. (ARERR 1658). One of solutions to resolve this error is to change the configuration in the AR System ODBC Setup to check "Use underscores" option. The problem is that this configuration gets reset when the user clicks on the "Shortcut" menu item to print a status history of a case. I am trying to find if Crystal reports is recreating the AR System ODBC driver or what is resetting this driver and making it loose my last configuration. Environment - Windows server 2003 - Remedy Ar System 6.3 - Helpdesk 5.6 - Microsoft SQL Server 2000 Database. Thank you. Jorge Polo Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. __20060125___This posting was submitted with HTML in it___ ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** __20060125___This posting was submitted with HTML in it___ __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Notification Group in ITSM 7?
I'm just starting to learn ITSM version 7 but am currently using version 5. In version 5 you could create a general notification group. The Contracts forms then had a notification group field that we used to notify these groups when a contract was expiring. In version 7 did they do away with notification groups? If so, does anyone know the reasoning behind this decision? How are you supposed to create a group just for notification purposes in version 7(i.e. the group can only be used for contract notifications and not for Help Desk Requests or Change Requests)? Any suggestions would be greatly appreciated. Thanks John Monroe Department of Technology Services ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: One notification engine to rule them all?
I believe ARS already does this with the SLA application. Someone please correct me if this is not so. Thanks, Dave Fincher - Original Message From: "Durrant, Michael M. - ITSD" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Thursday, November 8, 2007 11:38:48 AM Subject: One notification engine to rule them all? ** Like Bing Crosby, I'm dreaming, but not of a White Christmas. I'm dreaming of a single set of forms and workflow that I would use to control all of my notifications. Originally, my co-worker and I envisioned a single system for ALL notifications, regardless of the form. Realizing that was quite the undertaking, we're limiting it to one form right now: HPD:HelpDesk. The idea is "Send xxx notification to y based on criteria a, b, and c (and possibly d through z)." I can see a few different ways of doing this - has anyone already done it? Thanks, Michael The information contained in this email may be privileged, confidential or otherwise protected from disclosure. All persons are advised that they may face penalties under state and federal law for sharing this information with unauthorized individuals. If you received this email in error, please reply to the sender that you have received this information in error. Also, please delete this email after replying to the sender. __20060125___This posting was submitted with HTML in it___ __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Using regular forms for data storage ONLY?
We did this on a some custom applications and converted them back to standard forms. It is much easier and cleaner to deal directly with the regular forms when creating, modifying and searching for records. If you use Mid Tier, the regular forms allow you to take advantage of the Mid Tier functionality for menus and search results. The primary issues with this are, as you pointed out, more coding of workflow and an increase in coding for simple field additions or removal. If you go this route you need extremely good documentation on your workflow since adding/removing a field will affect all workflow which does validation, creation, or modification of data. Depending upon the size of the application this can be fairly simple or very complex. For data validation you will still want to use filters and possibly and escalation or two. Since filters and escalations have to run against regular forms you will not be able to use your regular forms for JUST data storage. Over all I would recommend using the regular forms as much as possible and only using dialog forms where absolutely needed. Each type of form in ARS has a purpose and the system has been optimized to utilize each type in a specific way. Yes, you can use the forms in different ways, but you gain development and maintenance overhead when trying to force them into new roles. HTHs Dave Fincher - Original Message From: "Durrant, Michael M. - ITSD" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Thursday, November 8, 2007 11:41:18 AM Subject: Using regular forms for data storage ONLY? ** I'm toying with the idea of using regular forms for data storage only and using display forms for all user interactions. while I realize this entails more "coding", I think I would have a greater deal of control over behavior of the user interface. Has anyone tried this already? Am I crazy for even thinking about it? Thanks, Michael Durrant The information contained in this email may be privileged, confidential or otherwise protected from disclosure. All persons are advised that they may face penalties under state and federal law for sharing this information with unauthorized individuals. If you received this email in error, please reply to the sender that you have received this information in error. Also, please delete this email after replying to the sender. __20060125___This posting was submitted with HTML in it___ __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Printing incidents from the web
The problem is that there is almost no advanced layout features on the internal Remedy report functionality. The internal reports are pretty limited in layout and generating a report with any aesthetic qualities. If you want a report for customer consumption with any type of organized layout you have to use Crystal. Remedy's reporting focus has always been on the client web reporting has always been a struggle. I agree that you should not have these variances between the Client and Mid Tier, but unfortunately if you want nicely formatted web reports you have to buy Business Objects web software. There are other companies which have report tools which will work with Remedy. However, you are still in the same boat with having to buy it and getting all the software to play nicely together. Of course Remedy's standby line is, if you want reports to work we highly recommend Business Objects Crystal Reports. I know this isn't helpful, but it may give you some idea of the issues involved with web reporting. Based on the focus of Mid Tier development hopefully there will be better options coming in the future. I know that there have been several Software Issue tickets which deal with Mid Tier reporting that have been on hold since version 6.3. We can only hope that these issues were placed on hold because they were developing new reporting functionality for the web, and not because they felt that web reporting wasn't as important as client reporting. Thanks, Dave Fincher - Original Message From: Melissa Reed <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Wednesday, November 7, 2007 9:51:14 PM Subject: Re: Printing incidents from the web Thanks for the info but I'm having trouble with the fact that the out of the box functionality of the Print button on the Incident form requires Crystal. You can use the Print button for Work Info on the Incident Console which is not a Crystal report. Why should the other print button work any different? On Nov 7, 7:31 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Melissa, > Yes, when running Mid Tier you need to have a Crystal Web or Crystal > Enterprise running, either on the Mid Tier server or on a seperate server. > There are various configuration settings in the AR Config utility for Mid > Tier which tell it how to access Crystal to service the report. ARS 7 is > compatable with the new Crystal Web software and is probably the direction I > would recommend investigating. We currently run Crystal Enterpise 10, and > while we get most of what we need from it we have had issues with it. > > HTHs > Dave Fincher > > > > - Original Message > From: Melissa Reed <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Sent: Wednesday, November 7, 2007 3:28:34 PM > Subject: Printing incidents from the web > > We are running ITSM 7 and ARS 7.0.1. > > It appears that crystal reports (or some other web reporting tool) is > required when printing an incident from the web. When you click the > print button from the user tool, a Crystal report comes up. When you > click the same button from the web, an error "Error during processing: > ARERR [9260] Repor tlocation is missing from report settings > configuration page. Please see your administrator." > > Anyone know how to get around this? We do not have a report tool > available for our mid-tier. > > Thanks! > > > ___ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are" > > __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection > aroundhttp://mail.yahoo.com > > > ___ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:www.rmsportal.comARSlist: "Where the Answers Are"- Hide > quoted text - > > - Show quoted text - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Printing incidents from the web
Melissa, Yes, when running Mid Tier you need to have a Crystal Web or Crystal Enterprise running, either on the Mid Tier server or on a seperate server. There are various configuration settings in the AR Config utility for Mid Tier which tell it how to access Crystal to service the report. ARS 7 is compatable with the new Crystal Web software and is probably the direction I would recommend investigating. We currently run Crystal Enterpise 10, and while we get most of what we need from it we have had issues with it. HTHs Dave Fincher - Original Message From: Melissa Reed <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Wednesday, November 7, 2007 3:28:34 PM Subject: Printing incidents from the web We are running ITSM 7 and ARS 7.0.1. It appears that crystal reports (or some other web reporting tool) is required when printing an incident from the web. When you click the print button from the user tool, a Crystal report comes up. When you click the same button from the web, an error "Error during processing: ARERR [9260] Repor tlocation is missing from report settings configuration page. Please see your administrator." Anyone know how to get around this? We do not have a report tool available for our mid-tier. Thanks! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Crystal report error on Mid-Tier
Dwayne, I'm not saying that this is your error but we currently have an open support issue with a software defect number SW00280014 directly related to generating a Crystal Report on the Mid Tier from an AL which seems similar to your issue. According Remedy Tech. this issue has been around since 6.3 and is still present in 7.0.1. Here is the detail information on our issue. It may be worth it to check with support and see if your issue could be related to this defect. If it is related then it would certainly help get the defect resolution elevated. ARSystem 7.0.1 Patch 4 Mid-Tier 7.0.1 Patch 4 MSSQL 2000 Win Srv 2003 Crystal Enterprise 10 An ActiveLink which generates a report of type Crystal causes an error when a Qualification contains a datetime field compared to the 10/18/2007 10:52:47 AM keyword when executed on the Mid-Tier. (example: 'datetimefield' > 10/18/2007 10:52:47 AM). ERROR Displayed "Crystal Report Viewer Error in formula A number, currency amount, boolean, date, time, date-time, or string is expected here. Details: errorKind. File report.rpt [On Cache/Page Server. SERVERNAME.pageserver]" The report in question has been verified against the database, executes correctly with the activelink when the date comparison is removed from the Qualification field, runs from the Remedy Report Selection Console, runs when executed directly from a web browser, runs from the report function of the User Tool. ActiveLink logging shows successful activelink processing (i.e. activelink log shows no errors). Data for the date field has been manually validated and the field contains valid data for all records. HTH, Dave Fincher - Original Message From: "Pargeter, Christie" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Tuesday, November 6, 2007 1:35:31 PM Subject: FW: Crystal report error on Mid-Tier You can edit the sub report's links your issue might be there. You can do this in 2 places, right click the sub report & select "Change Subreports links..." or on the criteria of the embedded subreport. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Tuesday, November 06, 2007 11:35 AM To: arslist@ARSLIST.ORG Subject: Re: Crystal report error on Mid-Tier Hi Christie, I don't understand your question. I did delete the subfile and re-write it from scratch. It works fine in the User tool. Dwayne Original message >Date: Tue, 6 Nov 2007 10:36:44 -0800 >From: "Pargeter, Christie" <[EMAIL PROTECTED]> >Subject: Re: Crystal report error on Mid-Tier >To: arslist@ARSLIST.ORG > >Have you tried to re-select your sub-query's quals? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Crystal report error on Mid-Tier
Does your active link contain a Qualification with datetime references? - Original Message From: Dwayne Martin <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Monday, November 5, 2007 1:40:23 PM Subject: Crystal report error on Mid-Tier Hello everyone, We have a Crystal Report stored in Report form, launched by an active link. It displays find in the User tool, but on Mid-Tier we get: -- Error encountered by Crystal PageServer The error message returned is: Error in formula . '{IT_Resource.Associated PIQ/Request} = {?Pm-IT_PIQ.PIQ_ID}' This field name is not known.. File ITPIQ3.rpt. [On Cache/Page Server: REMEDY.pageserver] -- I rebuilt the sub-report from scratch, but still get the same error. Other Crystal Reports display OK on Mid-Tier. Any ideas? (Mid-Tier 6.3, ARS 7.1, RH Linux server, Oracle 9.2 db) Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
TR vs DB value for SLA action
Hi All, I just need to confirm something. We have a ton of SLA actions firing on our server. One of them is not working properly, but I figured out that it was because there were not enough qualifications in the stop actions. Here is the scenerio. I have a group that wants to stop the SLA when the ticket gets reassigned out of their queue. Do I want to add 'TR.Assigned To Group' != 'Assigned To Group'? Or do I want to do 'TR.Assigned To Group' != "DB.Assigned To Group" Any advice would be appreciated. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: SLM - Pay to upgrade from SLA - Anybody fight this and win?
Jack: We were in the same position earlier this year but lost the battle. As our sales rep explained it, they discontinued the older product (SLA 6.0) and were no longer going to upgrade or support it. To appease our complaining, they offered us the new product (SLM 7.0) at zero cost - we just had to pay the difference in maintenance for the balance of our annual contract (i.e. the difference between the unused portion of SLA maintenance and the pro-rated expense for the new product). It's my understanding that this was a "one-time" offer that had to be processed by June 30, 2007. Note that none of the above mentions functionality or features, it was simply a product direction decision. If I were you, I would question my sales rep as to why they didn't work with you to take advantage of the "one-time" offer. Even though you weren't ready to move to 7.x at that time, it obviously would have to been to your advantage to process the SLA to SLM migration before June '07. - Don -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Covert, Jack Sent: Wednesday, October 31, 2007 11:56 AM To: arslist@ARSLIST.ORG Subject: SLM - Pay to upgrade from SLA - Anybody fight this and win? This is a multi-part message in MIME format. --_=_NextPart_001_01C81BEF.A27C8418 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Okay, so here's the deal. We've owned SLA for many years and always paid maintenance. All we really needed was a simple escalation tool. Now we're upgrading to 7 and they're saying we have to pay another $30k plus maintenance (80% discount I guess) to upgrade to 7 because it has extra features. =20 We've been paying for maintenance, which entitles us to an upgrade. If they want to throw in a bunch of bells and whistles (none of which we need), they should either have an SLM light that we can upgrade to for free or a free upgrade to the full blown SLM. =20 Am I crazy here or ? Anybody else have this problem? Anybody else go to the mattresses w/ BMC? How'd it turn out? =20 Jack Covert =20 Corporate IT Enterprise Systems Management Remedy Support Team =20 =20 Remedy Support Team Home Page <http://collaborate.mckesson.com/sites/esm/remedy> http://collaborate.mckesson.com/sites/esm/remedy =20 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" --_=_NextPart_001_01C81BEF.A27C8418 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: quoted-printable ** http://www.w3.org/TR/REC-html40";> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline;} span.EmailStyle17 {mso-style-type:personal-compose; font-family:Arial; color:windowtext;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in;} div.Section1 {page:Section1;} --> Okay, so here’s the deal. We’ve = owned SLA for many years and always paid = maintenance. All we really needed was a simple escalation tool. Now we’re = upgrading to 7 and they’re saying we have to pay another $30k plus maintenance (80% = discount I guess) to upgrade to 7 because it has extra = features. We’ve been paying for maintenance, which = entitles us to an upgrade. If they want to throw in a bunch of bells and = whistles (none of which we need), they should either have an SLM light that we can = upgrade to for free or a free upgrade to the full blown = SLM. Am I crazy here or ? Anybody else have this = problem? Anybody else go to the mattresses w/ BMC? How’d it turn = out? Jack Covert Corporate = IT Enterprise Systems = Management Remedy Support = Team Remedy Support Team Home = Page http://collaborate.mckesson.com/sites/esm/remedy";>http://collaborate.mckesson = .com/sites/esm/remedy= __20060125___This posting was submitted with HTML in it___ --_=_NextPart_001_01C81BEF.A27C8418-- ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: BMC Support Site Rant
I'm sure that you'll find that BMC/Remedy no longer uses BEST practices. In order to be fully ITIL V.3 compliant they now use GOOD practices. Good practices doesn't quite make since to me but guess they had to find a name for it. I do have to admit that after I raised hell at support and my program manager raised hell at sales our support has improved. Not sure if this is just luck or if we finally got through to someone. Probably tagged my person data entry as SQUEAKY WHEEL. Have a good one Dave - Original Message From: Timothy Powell <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Monday, October 29, 2007 4:55:12 PM Subject: Re: BMC Support Site Rant ** Benjamin, You are confusing a company that "preaches" best practice with one that actually "utilizes" best practice in their own support mechanism. Practice what you preach is NOT one of the BMC/Remedy tenants.sadly. Another example is reporting. "Best practice" says that you allow customers to be somewhat self sufficient and provide them the ability to do some reporting on their tickets/issues. Does BMC allow any type of reporting on outstanding support issues. No they do not. They sell a product with 100+ embedded reports because, "that's what customers need", but do not implement any type of reporting for their internal customers. I'm sure that the members of this list can come up with numerous other examples where the practice doesn't measure up to the preaching. Self reporting is just one of my pet peeves. Tim From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Watson, Benjamin A. Sent: Monday, October 29, 2007 6:15 PM To: arslist@ARSLIST.ORG Subject: OT: BMC Support Site Rant ** Dear List (David Easter are you listening), I’d like to know how many of you out there have a size limit on a field named “Details” and/or “Description”? What is the “best practice” for a size limit on the “Details” field? In my mind, this field should be a 0-length (unlimited) field such that a person can input as many characters as it takes (within database constraints for a character field) to make a _detailed_ description of the problem. I can understand a limit on a “Summary” or “Brief Description” field for reporting purposes. Apparently the folks running the BMC Remedy Support site feel that 254 characters are sufficient for a _detailed_ description. Further, if you exceed this limit, do you get descriptive feedback as to why you couldn’t save your ticket? NO. “Unable to setup data connection which is preventing this application from working correctly”. What is that? Sorry to rant here, but after typing up a nice detailed description of a problem, I get an error message on trying to save my ticket. After butchering my response, I can finally save the ticket, but it now nowhere near reflects what I wanted to say and have to resort to several sequential ticket updates. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Mid-Tier/ServletExec
Hi All, I was wondering if anyone has ever received the below errors when installing Mid-Tier. We are on version 6.3 unix/oracle platform and we are installing the mid-tier on the same server. I appreciate any help since I cannot find anything close to this on bmc.com and their customer support is not being very helpful. cp: cannot access bin/HP-UX/*: No such file or directory cp: cannot access /opt/remap/NewAtlanta/ServletExecAS/bin/mod_servletexec2.c: No such file or directory Error constructing mod_servletexec.so Verify that the compiler and link-editor specified by $CFG_CC and $CFG_LD_SHLIB in your 'apxs' script are in your PATH. Also verify that the 'apxs' script has been properly installed. The installation log file (/tmp/SEinstall.log) has more details about these problems. If you continue to have problems then please forward the error messages and to [EMAIL PROTECTED] ServletExec installation aborting on failure! See /tmp/SEinstall.log for log of installation. Exiting ServletExec AS installer... egrep: can't open /opt/remap/NewAtlanta/ServletExecAS/config/webadapter.properties Backup_File: Can't create backup of /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec grep: can't open /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec ./mt_install[9]: test: Specify a parameter with this command. grep: can't open /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec grep: can't open /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec egrep: can't open /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec egrep: can't open /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec egrep: can't open /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec egrep: can't open /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec ***ERROR*** * chmod: can't access /opt/remap/NewAtlanta/ServletExecAS/se-tremap/ServletExecData/default * Error running the following command * chmod 775 /opt/remap/NewAtlanta/ServletExecAS/se-tremap/ServletExecData/default * You will need to manually run this command after the * installation has completed. See the install log * /usr/tmp/mt_install.log for details *** ***ERROR*** * chmod: can't access /opt/remap/NewAtlanta/ServletExecAS/se-tremap/ServletLogs/ servletexec/ Se rvlet.log * Error running the following command * chmod 775 /opt/remap/NewAtlanta/ServletExecAS/se-tremap/ServletLogs/ servletexec/ Se rvlet.log * You will need to manually run this command after the * installation has completed. See the install log * /usr/tmp/mt_install.log for details *** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Mid-Tier/ServeletExec Errors
Oddly enough, we were installing servlet as root. When I looked at our box, I couldn't see the files it was trying to access. Its not completing the install at all and we have tried both non-root and root and getting the same thing. Thanks for the input. On Oct 26, 10:34 am, "Payne, George" <[EMAIL PROTECTED]> wrote: > Jaimie, > > Wow...so many things that this could be: > > 1.) Is there a C Compiler on the box, is it properly configured and > available in your path? > > 2.) Were you attempting this installation as ROOT or as another user? > > 3.) Are the files that the script is trying to CHMOD actually there? If > so, who owns them (owner and group) and what are the access rights? > > It sounds like it's trying to compile the module for your http/java > servlet connector. If it doesn't have access to a compiler or to the > necessary source files (apxs is usually owned by ROOT but should be > readable by other users). I'd recommend doing the installation as ROOT > and then follow the post-installation routines to set up the whole thing > for non-ROOT usage. > > Best of luck, > Gp > > George Payne > Corporate Applications Developer > Electric Reliability Council of Texas > (512) 248-3940 > [EMAIL PROTECTED] > > > > -----Original Message- > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] > Sent: Friday, October 26, 2007 7:46 AM > To: [EMAIL PROTECTED] > Subject: Mid-Tier/ServeletExec Errors > > Hi All, > > I was wondering if anyone has ever received the below errors when > installing Mid-Tier. We are on version 6.3 unix/oracle platform and > we are installing the mid-tier on the same server. > > I appreciate any help since I cannot find anything close to this on > bmc.com and their customer support is not being very helpful. > > cp: cannot access bin/HP-UX/*: No such file or directory > cp: cannot access > /opt/remap/NewAtlanta/ServletExecAS/bin/mod_servletexec2.c: No such > file > or directory >Error constructing mod_servletexec.so > >Verify that the compiler and link-editor specified by $CFG_CC >and $CFG_LD_SHLIB in your 'apxs' script are in your PATH. >Also verify that the 'apxs' script has been properly >installed. The installation log file (/tmp/SEinstall.log) >has more details about these problems. >If you continue to have problems then please forward the >error messages and to [EMAIL PROTECTED] > >ServletExec installation aborting on failure! >See /tmp/SEinstall.log for log of installation. > >Exiting ServletExec AS installer... > > egrep: can't open > /opt/remap/NewAtlanta/ServletExecAS/config/webadapter.properties > Backup_File: Can't create backup of > /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec > grep: can't open > /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec > ./mt_install[9]: test: Specify a parameter with this command. > grep: can't open > /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec > grep: can't open > /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec > egrep: can't open > /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec > egrep: can't open > /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec > egrep: can't open > /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec > egrep: can't open > /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec > > ***ERROR*** > * chmod: can't access > /opt/remap/NewAtlanta/ServletExecAS/se-tremap/ServletExecData/default > * Error running the following command > * chmod 775 > /opt/remap/NewAtlanta/ServletExecAS/se-tremap/ServletExecData/default > * You will need to manually run this command after the > * installation has completed. See the install log > * /usr/tmp/mt_install.log for details > *** > > ***ERROR*** > * chmod: can't access > /opt/remap/NewAtlanta/ServletExecAS/se-tremap/ServletLogs/servletexec/ > Se > rvlet.log > * Error running the following command > * chmod 775 > /opt/remap/NewAtlanta/ServletExecAS/se-tremap/ServletLogs/servletexec/ > Se > rvlet.log > * You will need to manually run this command after the > * installation has completed. See the install log > * /usr/tmp/mt_install.log for details > *** > > ___
Mid-Tier/ServeletExec Errors
Hi All, I was wondering if anyone has ever received the below errors when installing Mid-Tier. We are on version 6.3 unix/oracle platform and we are installing the mid-tier on the same server. I appreciate any help since I cannot find anything close to this on bmc.com and their customer support is not being very helpful. cp: cannot access bin/HP-UX/*: No such file or directory cp: cannot access /opt/remap/NewAtlanta/ServletExecAS/bin/mod_servletexec2.c: No such file or directory Error constructing mod_servletexec.so Verify that the compiler and link-editor specified by $CFG_CC and $CFG_LD_SHLIB in your 'apxs' script are in your PATH. Also verify that the 'apxs' script has been properly installed. The installation log file (/tmp/SEinstall.log) has more details about these problems. If you continue to have problems then please forward the error messages and to [EMAIL PROTECTED] ServletExec installation aborting on failure! See /tmp/SEinstall.log for log of installation. Exiting ServletExec AS installer... egrep: can't open /opt/remap/NewAtlanta/ServletExecAS/config/webadapter.properties Backup_File: Can't create backup of /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec grep: can't open /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec ./mt_install[9]: test: Specify a parameter with this command. grep: can't open /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec grep: can't open /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec egrep: can't open /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec egrep: can't open /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec egrep: can't open /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec egrep: can't open /opt/remap/NewAtlanta/ServletExecAS/se-tremap/StartServletExec ***ERROR*** * chmod: can't access /opt/remap/NewAtlanta/ServletExecAS/se-tremap/ServletExecData/default * Error running the following command * chmod 775 /opt/remap/NewAtlanta/ServletExecAS/se-tremap/ServletExecData/default * You will need to manually run this command after the * installation has completed. See the install log * /usr/tmp/mt_install.log for details *** ***ERROR*** * chmod: can't access /opt/remap/NewAtlanta/ServletExecAS/se-tremap/ServletLogs/servletexec/ Se rvlet.log * Error running the following command * chmod 775 /opt/remap/NewAtlanta/ServletExecAS/se-tremap/ServletLogs/servletexec/ Se rvlet.log * You will need to manually run this command after the * installation has completed. See the install log * /usr/tmp/mt_install.log for details *** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Hey not sure I can do this.
Saji, Active Link errors for this type of thing are great as it gives immediate user feedback and users don't waste their time filling out the form before a filter informs them that they can't submit a ticket. However, it's always good practice to back up your active link error with a filter error also. Scott Parrish IT Prophets, LLC Original Message: - From: Philip, Saji L [EMAIL PROTECTED] Date: Thu, 25 Oct 2007 12:14:58 -0500 To: arslist@ARSLIST.ORG Subject: Re: Hey not sure I can do this. And you are targeting the HelpDesk form right? Saji From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 25, 2007 12:01 PM To: arslist@ARSLIST.ORG Subject: Re: Hey not sure I can do this. We use an Active Link that fires on Window Open with the qualification of: (NOT ($GROUPS$ LIKE "%Administrator%" )) AND (NOT ($GROUPS$ LIKE "%SOC_Staff%" )) AND (NOT ($GROUPS$ LIKE "%Submit_Group%" )) AND ($OPERATION$ = "CREATE" ) If you are not a member of the appropriate group (based on the criteria in qualification statement above) you get an error telling you that you are not permitted to create a ticket. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Thursday, October 25, 2007 10:41 AM To: arslist@ARSLIST.ORG Subject: Re: Hey not sure I can do this. You could just create a filter for that form. The "execute on" would be "Submit" and the run if section would be 'Group' = "xxx" (whatever the group number is of the deskside support is). The Action could then be an Error Message that says "You do not have the permission to create new tickets" or something like that. I do this on display forms when people try to click on the "new" button. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Philip, Saji L Sent: Thursday, October 25, 2007 11:18 AM To: arslist@ARSLIST.ORG Subject: Hey not sure I can do this. ** Running: AR 6.3 ITSM Helpdesk: 6.0( Out-of-the-box ) I need to set-up a special permission on a group, whereby, they having editing capabilities but cannot create new tickets. Basically, we have our support environment segregated into two tiers( phone support and deskside support ). We want to limit the deskside support into only editing tickets and closing them, but not allow them to create( that's the phone level ). I have been looking at it and I see permission levels as ' None, View, and Change '. Has anyone done something similar to this. Saji __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" mail2web.com What can On Demand Business Solutions do for you? http://link.mail2web.com/Business/SharePoint ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Hey not sure I can do this.
Saji, Create a filter that executes on Submit and checks for Group membership in your special group. If this returns true, then return an error that membership in this group prevents submitting tickets. Scott Parrish IT Prophets Original Message: - From: Philip, Saji L [EMAIL PROTECTED] Date: Thu, 25 Oct 2007 10:17:39 -0500 To: arslist@ARSLIST.ORG Subject: Hey not sure I can do this. Running: AR 6.3 ITSM Helpdesk: 6.0( Out-of-the-box ) I need to set-up a special permission on a group, whereby, they having editing capabilities but cannot create new tickets. Basically, we have our support environment segregated into two tiers( phone support and deskside support ). We want to limit the deskside support into only editing tickets and closing them, but not allow them to create( that's the phone level ). I have been looking at it and I see permission levels as ' None, View, and Change '. Has anyone done something similar to this. Saji ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" mail2web LIVE Free email based on Microsoft® Exchange technology - http://link.mail2web.com/LIVE ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Midtier error; ARERR 9215
Troy, We fought with something along these lines when we upgraded to 7.x. There is an authentication error which is present in the 7.0 software, we upgraded to 7.0.1 patch 4 which resolved the issue. However, 7.0.1 P4 has a few issues of it's own. Things we have found so far, timestamp qualifications for Crystal Reports generated in an active link cause a Crystal Reports formula error, and the delete button on the alert list is only visible to administrators. Both of these issues have confirmed bug reports and will hopefully be resolved with Patch 5. HTH's Dave - Original Message From: Troy Sasso <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Monday, October 22, 2007 1:53:04 PM Subject: Midtier error; ARERR 9215 Hello all, AR mid-tier 7.x on Win2003, Tomcat 5.5 Users are being presented with the login screen, when they try to login, they see ARERR 9215. The Mid-tier config tool works perfectly though. Not a lot of reading material out there on this one. I know a lot of others have seen this, how did you get by it? Thanks. Troy __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
RESOLVED: Help with ARERR 552
First, Thank you to everyone who responded, Your thoughts and input helped in determining what to do and what not to do. Interestingly enough, we did modify our user form which upgraded correctly, however we did not modify the group form which did not upgrade correctly. A. Since we were dealing with the Group form we did not feel it was safe to delete the form and risk not being able to get back into the system. B. We could have imported the valid Def from the installation folder and then used the arcache command to create a new administrator group, which would have enabled us to get into the system and then import our groups. We chose not to execute either of these options since there was some risk of not being able to recover the system, a low risk but still a risk. The steps we took to correct this issue were as follows: 1. Identified the columns in the database which were being reported as errors. (C120, C121, and C179) 2. Verified that the columns were not in the T table and were not applicable to the H and C tables. 3. Verified each of the column description entries in the corresponding field_* and view_* tables (In our case all of the related tables contained valid entries for the missing fields) 4. Scheduled a system outage with our users. 5. Shut down the AR System service and backed up the database 6. Created the column entries in the T table 7. Identified and corrected default data for these fields and the default AR Groups. 8. Called BMC and told them to close the ticket, because we have taken care of the problem ourselves. - Original Message From: Dwayne Martin <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Monday, October 22, 2007 6:16:26 AM Subject: Re: Help with ARERR 552 We had a similar problem with the User form after upgrading to 7.1. Support asked if we had customized our User form, which we had. They said to back up the data, download a fresh form definition, and delete and re-import the form and data. That sounded scarey to us. Instead we looked at the message and queried the db for the fieldname of the column in question. Then we copied and deleted that field, saved the form, pasted the field back into the form and saved again. We kept doing that till we no longer got the message. That seems to have fixed the problem. Apparently you are not supposed to customize the User or Group form, but we customized ours six years ago before we knew about the rule. Dwayne Martin James Madison University Original message >Date: Sat, 20 Oct 2007 15:53:37 -0500 >From: strauss <[EMAIL PROTECTED]> >Subject: Re: Help with ARERR 552 >To: arslist@ARSLIST.ORG > > ** > In spite of my recent experiences with Migrator 7.1 > between 7.1 servers when the target server is not in > development cache mode, if I was in this situation I > would try to migrate the Group form from a valid > 7.0.01.004 installation to the one that > is experiencing problems. Migrator is the only tool > I have used that will reliably ADD fields - columns > to a table (don't try to remove them), without > risking the data or directly editing the form. I > have moved data records successfully with it as > well, if you had to go in the other direction. In > this case you just need the columns added back to > the table. You could even do it from a def file of > the Group form, if you could get a good one from > another server. The only error you might get would > be when it tries to update the arsfields table > afterwards and finds the existing column ids, but if > it fixes the Group table you should be okay - > migrator should not create a mismatch between column > ids since it maintains the source id unless you tell > it to use a new one. It's one more thing to try... > > Christopher Strauss, Ph.D. > Remedy Database Administrator > University of North Texas Computing Center > http://itsm.unt.edu/ > > ---- > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of David > Sanders > Sent: Saturday, October 20, 2007 1:37 PM > To: arslist@ARSLIST.ORG > Subject: Re: Help with ARERR 552 > > ** > > Sorry if this has already been suggested, but have > you tried importing the Group form from a def > file? If you go to your ARServer installation > directory, the Group form def is located in the > ...\ARServer\InstallForms\en directory. > > > > If you have to delete the Group form, the server > should remain operable as it will use the entries > in the group_cache table (until the server tries > to recache). > > > > HTH > > > > David Sanders &
Re: Help with ARERR 552
Unfortunately, all of our 7.0.1 backups have this problem, since it occurred during the upgrade process. Our previous version db backups are two weeks old and loosing that much data is not an option, not too mention the amount of post upgrade work we have done during the last two weeks to accommodate for 7.0.1 idiosyncrasies. This is one we have to fight through, I was hoping that there would have been someone who has had this happen and knew of a fix. Seems like BMC/Remedy would have some type of DB tool which could validate and correct the DB structure if problems were found during the validation, I guess that would be WAY too much to ask for though. I would even be happy if the Admin tool, which is more than happy to tell you there is a problem with the form, would perform the correction on save or at least give you the option of performing the correction. Looks like I get to learn more about the Remedy DB structure than I wanted too. I'll have to study up over the weekend and go in Monday to perform brain surgery. Thanks, Dave - Original Message From: Joe D'Souza <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Friday, October 19, 2007 3:20:08 PM Subject: Re: Help with ARERR 552 ** You will loose access to your system to do anything further if you delete the group form... Restoring your last known good backup of the database is your best and fastest option. Any other option would be very time consuming (attempts to build the T table by altering it to include the missing columns etc..). Not impossible but might take even an expert Remedy developer a lot more than 15 or 20 minutes that restoring a DB backup would take.. Cheers Joe D'Souza -Original Message- From: Action Request Systemdiscussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of[EMAIL PROTECTED] Sent: Friday, October 19, 2007 4:23PM To: arslist@ARSLIST.ORG Subject: Re: Help with ARERR552 **DIV { MARGIN:0px;}Yes,we do have a backup of the pre-upgrade database (we still have the pre-upgradedatabase server in pristine condition). While restoring the databasewould provide a means to recover the data in the Group form, it would notresolve the error with the 7.01 Group form. While it would be possibleto recover the Group form data and then delete the current Group form andReimport a valid Group form, I'm not sure that it is possible to delete theGroup form and maintain an operational system. Like you, we had thisoccur on a test upgrade to 7.0 to the User form. The end result was,because it was a test upgrade, to dump the system and redo the upgradeprocess. However, with 7.0 this happened every time we tried theupgrade, thus the wait for 7.0.1 for the upgrade. During testing with 7.0.1 this error did not occur, so we thought we were out of the woods on it. Thanks, Dave -Original Message From: Rahul AR User<[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Friday,October 19, 2007 2:02:06 PM Subject: Re: Help with ARERR 552 ** Didu take the database backup before the upgrade?? If yes then restore the backupon some other database server and import the table from this restored databaseto the existing database. I'll again remind you to take a database backupbefore proceeding with the steps as mentioned above. On 10/20/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:** Anyone have a recommendation for this. When accessing the Group form we receive the error "ARERR 552 Failure during SQL operation to the database: Invalid column name 'C179', (SQL Server 207)Invalid column name 'C121', (SQL Server 207)Invalid column name 'C120', (SQL Server 207) This error prevents us from viewing, creating or modifying records on the Group form. The fields exist in the 'field' table but do not exist in the 'T9' table. All efforts to resolve this through the Admin tool have been unsuccessful. My best guess on cause would be a problem with the form creation/import during our database upgrade to 7.0.1. I would try to manually create the fields in the T table, but do not want to cause more issues than what I have. Equally unsuccessful was to open a high impact ticket with BMC Support over 24 hours ago (ISS03190758). They have been unresponsive and have failed to meet the Fast-Track SLA. (If anyone from BMC is monitoring the list any assistance would be greatly appreciated.) Windows 2003 Server / MSSQL 2000 / BMC Remedy AR System 7.0.1 P4 Thanks in advance, DaveFincher __20060125___This posting was submitted with HTML in it___ __ Do
Re: Help with ARERR 552
Sorry I miss read as importing the form instead of importing the database table. I'm not sure that this would be a solution since the pre-upgrade table is a 5.1.2 format table and the 7.0.1 table contains a different structure, I'd still be missing these fields in the T table. I'm not sure that the AR database would be capable of dealing with this any better than it can deal with the fields not being in the T table to start with. While it may be possible to do a fresh installation of a 7.0.1 system and then move the clean T table over to to my production system, it is possible that there may be other problems with the Group schema. If I'm having problems with the T table what other parts of the schema may be corrupt? The production system has been running on 7.0.1 for a couple of weeks now so dropping back to the pre-upgrade database is not an option. Unfortunately, we did not need to modify any of our groups until now so the error did not appear until after we were beyond our commit point with the new software. Thanks for the input, anything I get here is better than what I am getting from BMC at this point. Thanks, Dave - Original Message From: Rahul AR User <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Friday, October 19, 2007 2:32:07 PM Subject: Re: Help with ARERR 552 ** Deleting the Group Form is not advised. If you are not comfortable with the option I suggested then you need to import this form. You may try exporting the Group Form from any running AR System and then importing the same in the current box. Well the database style was what we did once when we came across the similar error, not exactly the same but some what similar. Again.. please take a database back, proactively, before continuing with any of the steps as advised. On 10/20/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: ** Yes, we do have a backup of the pre-upgrade database (we still have the pre-upgrade database server in pristine condition). While restoring the database would provide a means to recover the data in the Group form, it would not resolve the error with the 7.01 Group form. While it would be possible to recover the Group form data and then delete the current Group form and Reimport a valid Group form, I'm not sure that it is possible to delete the Group form and maintain an operational system. Like you, we had this occur on a test upgrade to 7.0 to the User form. The end result was, because it was a test upgrade, to dump the system and redo the upgrade process. However, with 7.0 this happened every time we tried the upgrade, thus the wait for 7.0.1 for the upgrade. During testing with 7.0.1 this error did not occur, so we thought we were out of the woods on it. Thanks, Dave - Original Message From: Rahul AR User < [EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Friday, October 19, 2007 2:02:06 PM Subject: Re: Help with ARERR 552 ** Did u take the database backup before the upgrade?? If yes then restore the backup on some other database server and import the table from this restored database to the existing database. I'll again remind you to take a database backup before proceeding with the steps as mentioned above. On 10/20/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: ** Anyone have a recommendation for this. When accessing the Group form we receive the error "ARERR 552 Failure during SQL operation to the database: Invalid column name 'C179', (SQL Server 207)Invalid column name 'C121', (SQL Server 207)Invalid column name 'C120', (SQL Server 207) This error prevents us from viewing, creating or modifying records on the Group form. The fields exist in the 'field' table but do not exist in the 'T9' table. All efforts to resolve this through the Admin tool have been unsuccessful. My best guess on cause would be a problem with the form creation/import during our database upgrade to 7.0.1. I would try to manually create the fields in the T table, but do not want to cause more issues than what I have. Equally unsuccessful was to open a high impact ticket with BMC Support over 24 hours ago (ISS03190758). They have been unresponsive and have failed to meet the Fast-Track SLA. (If anyone from BMC is monitoring the list any assistance would be greatly appreciated.) Windows 2003 Server / MSSQL 2000 / BMC Remedy AR System 7.0.1 P4 Thanks in advance, Dave Fincher __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __20060125___This posting was submitted with HTML in it___ -- Regards Rahul __20060125___This posting was submitted with HTML in it___ ___
Re: Help with ARERR 552
Yes, we do have a backup of the pre-upgrade database (we still have the pre-upgrade database server in pristine condition). While restoring the database would provide a means to recover the data in the Group form, it would not resolve the error with the 7.01 Group form. While it would be possible to recover the Group form data and then delete the current Group form and Reimport a valid Group form, I'm not sure that it is possible to delete the Group form and maintain an operational system. Like you, we had this occur on a test upgrade to 7.0 to the User form. The end result was, because it was a test upgrade, to dump the system and redo the upgrade process. However, with 7.0 this happened every time we tried the upgrade, thus the wait for 7.0.1 for the upgrade. During testing with 7.0.1 this error did not occur, so we thought we were out of the woods on it. Thanks, Dave - Original Message From: Rahul AR User <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Friday, October 19, 2007 2:02:06 PM Subject: Re: Help with ARERR 552 ** Did u take the database backup before the upgrade?? If yes then restore the backup on some other database server and import the table from this restored database to the existing database. I'll again remind you to take a database backup before proceeding with the steps as mentioned above. On 10/20/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: ** Anyone have a recommendation for this. When accessing the Group form we receive the error "ARERR 552 Failure during SQL operation to the database: Invalid column name 'C179', (SQL Server 207)Invalid column name 'C121', (SQL Server 207)Invalid column name 'C120', (SQL Server 207) This error prevents us from viewing, creating or modifying records on the Group form. The fields exist in the 'field' table but do not exist in the 'T9' table. All efforts to resolve this through the Admin tool have been unsuccessful. My best guess on cause would be a problem with the form creation/import during our database upgrade to 7.0.1. I would try to manually create the fields in the T table, but do not want to cause more issues than what I have. Equally unsuccessful was to open a high impact ticket with BMC Support over 24 hours ago (ISS03190758). They have been unresponsive and have failed to meet the Fast-Track SLA. (If anyone from BMC is monitoring the list any assistance would be greatly appreciated.) Windows 2003 Server / MSSQL 2000 / BMC Remedy AR System 7.0.1 P4 Thanks in advance, Dave Fincher __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __20060125___This posting was submitted with HTML in it___ -- Regards Rahul __20060125___This posting was submitted with HTML in it___ __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Help with ARERR 552
Anyone have a recommendation for this. When accessing the Group form we receive the error "ARERR 552 Failure during SQL operation to the database: Invalid column name 'C179', (SQL Server 207)Invalid column name 'C121', (SQL Server 207)Invalid column name 'C120', (SQL Server 207) This error prevents us from viewing, creating or modifying records on the Group form. The fields exist in the 'field' table but do not exist in the 'T9' table. All efforts to resolve this through the Admin tool have been unsuccessful. My best guess on cause would be a problem with the form creation/import during our database upgrade to 7.0.1. I would try to manually create the fields in the T table, but do not want to cause more issues than what I have. Equally unsuccessful was to open a high impact ticket with BMC Support over 24 hours ago (ISS03190758). They have been unresponsive and have failed to meet the Fast-Track SLA. (If anyone from BMC is monitoring the list any assistance would be greatly appreciated.) Windows 2003 Server / MSSQL 2000 / BMC Remedy AR System 7.0.1 P4 Thanks in advance, Dave Fincher __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
OT: Re: Friday Humor: AMAZINGLY SIMPLE HOME REMEDIES
Only on the ARSList can a Friday Humor posting elicit a correction. Scott Parrish Original Message: - From: LJ LongWing (Head) [EMAIL PROTECTED] Date: Fri, 19 Oct 2007 10:34:38 -0600 To: arslist@ARSLIST.ORG Subject: Re: Friday Humor: AMAZINGLY SIMPLE HOME REMEDIES 7 and 8 aren't simple home remediesbut overall very funny...:) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Friday, October 19, 2007 10:29 AM To: arslist@ARSLIST.ORG Subject: Friday Humor: AMAZINGLY SIMPLE HOME REMEDIES AMAZINGLY SIMPLE HOME REMEDIES 1. If you're choking on an ice cube simply pour a cup of boiling water down your throat. Presto! The blockage will instantly remove itself. 2. Avoid cutting yourself when slicing vegetables by getting someone else to hold while you chop. 3. Avoid arguments with the Mrs. about lifting the toilet seat by using the sink. 4. For high blood pressure sufferers: simply cut yourself and bleed for a few minutes, thus reducing the pressure in your veins. Remember to use a timer. 5. A mouse trap, placed on top of your alarm clock, will prevent you from rolling over and going back to sleep after you hit the snooze button. 6. If you have a bad cough, take a large dose of laxatives, then you'll be afraid to cough. 7. You only need two tools in life - WD-40 and Duct Tape. If it doesn't move and should, use the WD-40. If it shouldn't move and does, use the duct tape. 8. Remember: Everyone seems normal until you get to know them. Daily Thought: SOME PEOPLE ARE LIKE SLINKIES. NOT REALLY GOOD FOR ANYTHING BUT THEY BRING A SMILE TO YOUR FACE WHEN PUSHED DOWN THE STAIRS If you can't fix it with a hammer, you've got an electrical problem. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" mail2web.com - Microsoft® Exchange solutions from a leading provider - http://link.mail2web.com/Business/Exchange ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: CTM:People large data imports
William, Since a GUID is simply a way of generating a unique identifier, then you should be able to create a GUID yourself. There is no validation of a GUID to check for a particular format. For instance, if you are stating that through direct SQL loads you can generate the Request ID (which must be unique), then you could also use that same Request ID for the GUID (after all, it is a unique ID and it would be unique across forms). I think the process you have described raises many more questions that are not covered here. If we assume you have those items covered and the only thing holding you back from the direct sql process is the GUID, then there is certainly a way to get around that issue. Scott Parrish IT Prophets, LLC www.itprophets.com Original Message: - From: William Rentfrow [EMAIL PROTECTED] Date: Mon, 15 Oct 2007 12:34:52 -0500 To: arslist@ARSLIST.ORG Subject: CTM:People large data imports On my current project we will have to import about 1,000,000 CTM:People records every week (give or take). These will be "new" records every time because the only unique identifier we have from the external systems is an identifier like SSN that we can't put into our system (that's a policy decision). We're checking on ways to do updates but it's still messy due to the item below. The actual import is going to be automatic and should follow this process: 1.) Escalation deletes all relevant CTM:People records 2.) File is automatically put on the Remedy server with people information 3.) Escalation fires a Run Process that imports the data into a staging form. 4.) Escalation fires and sets a flag field to "Process Now" on all records in the staging form 5.) Filter on "modify" on the staging form pushes to CTM:People Here's the problem - we're using decent hardware running on Solaris 9, etc - yet the push to CTM:People takes 1.5 seconds per record due to all of the validation that takes place. I have to do 1,000,000 records a week - and there are only 604,800 seconds in a weekalso, it appears using direct SQL loads won't work due to all of the back end set fields (I can get around all of those except the GUID - which could be set by another escalation.and then we are back at this same problem). If you've done large data imports to CTM:People I'd really like to know how you went about loading the data efficiently. William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" mail2web.com What can On Demand Business Solutions do for you? http://link.mail2web.com/Business/SharePoint ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Looking for advice on DSL and 7.x Product Categorizations
Listers: It would seem that in loading the DSL data, we're forced to use the associated out-of-the-box Product Categorizations of 'Software/Application/Third Party' and 'Software/Operating System/Third Party'. Since Product is not available when configuring Assignment rules, such broad categorizations make it nearly impossible to single out support groups for routing without redundantly populating Operational Categorizations. We've thought about disabling all DSL entries, then reactivating and recategorizing only those we need, but that would seem to be an extremely time consuming task. We're also concerned that future DSL data patches would overwrite our updates. Perhaps populating the DSL ourselves is a better approach? For those of you using BMC's DSL data, how do you handle this? Many thanks! - Don Savant State of California, Dept of Technology Services ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Read data in MS SQL Server from a Oracle Unix Environment
Hello Listers, May be this topic was covered before, but I didn´t find any hints in the archives that let me go ahead with this point. We need to read in a MS SQL Database from a AR System that use Oracle- Solaris as platform. Which could be the best/rapid way to accomplish that. Any hints will be really appreciate. Thanks in advance, Antonio Acosta Syslog Solutions Caracas - Venezuela ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: OT: OpenOffice.org from Sun..
I use it pretty extensively outside of the office. I even installed in on my kid's computers for them to use for school work (beats buying multiple MS Office licenses). They seem to be able to switch between MS Office and OOo pretty seamlessly. If your looking for something that can read and write MS formats (most of the time, it does have rendering problems with some features) and don't have a big budget then OOo may be for you. Dave Fincher - Original Message From: Joe D'Souza <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Friday, October 5, 2007 11:39:39 AM Subject: OT: OpenOffice.org from Sun.. ** Has anybody used this tool OpenOffice.org? How long has it been around? I just got a link to download it while updating java on my laptop to download it for free. Its description sounds good and I'm tempted to try it out. This is the link.. http://java.com/en/download/javacom_update.jsp Joe D'Souza __20060125___This posting was submitted with HTML in it___ Be a better Globetrotter. Get better travel answers from someone who knows. Yahoo! Answers - Check it out. http://answers.yahoo.com/dir/?link=list&sid=396545469 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: ARSList Awards: Some yes, some no.MVP not enough yet!
Ok, I voted a couple of days ago. I didn't put in a vote for the third party apps because I have no experiance with them. I tend to lurk most of the time but monitor the list on a daily basis and throw out a suggestion when I think I might have an anwser. For those going to Canada, please have some extra fun for me. I would love to go to RUG but would need a sponsor (any one willing ;-?). Dave Fincher - Original Message From: Ray Palla <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Thursday, October 4, 2007 6:09:10 PM Subject: Re: ARSList Awards: Some yes, some no.MVP not enough yet! ** Okay, I vote for RemedyRick, Rick Cook. Now can we depress about more important things? There is no reason for Remedy to die, as most of us seem to believe is occurring. Consider MS 95, NT, xXP, and whatever Vista is, ... Remedy is morphing into something better than 5x. RANT: Remedy 8x may finally be the drawn-down (quick scaled, fast deployed) version we're telling our customers is the rapid development salvation. Truly, Flash on a good DB is pretty fine... Cold Fusion on Oracle is a good idea.. but, Remedy, with a fresh ITIL BS behind it, is instantly cool in the current climate. Let's hope that the few who do show up in Canada have the passion and speak the truth. We'll know in a few short weeks. Good luck Marc Thames, gTech Try to have some fun... BC is cool. R From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: Thursday, October 04, 2007 6:48 PM To: arslist@ARSLIST.ORG Subject: Re: ARSList Awards: Some yes, some no.MVP not enough yet! ** Look at where they are having it and when. Howard On 10/4/07, Susan Palmer <[EMAIL PROTECTED]> wrote: ** Pretty sad isn't it:( So are there only going to be about 100 of us at RUG? Susan On 10/4/07, Timothy Powell <[EMAIL PROTECTED] > wrote: ** Susan, I agree that the dynamics of the list is changing. But let's throw some speculative numbers out. Dan states that there are in excess of 3000 registered users. We'll round that down to 3000 even. Let's say 50% of those registered users are inactive. Now we're at 1500. Let's say another 50% of those users are as you describedoccasional users and never glance at the list until the need arises. Now were down to 750. Of those, 50% are in the hospital and have been unable to use a computer in the last month. Now we're down to 375. Of those 375, surely there are enough dedicated users to get 150 votes. :-) Regards, Tim From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Susan Palmer Sent: Thursday, October 04, 2007 4:15 PM To: arslist@ARSLIST.ORG Subject: Re: ARSList Awards: Some yes, some no.MVP not enough yet! ** I think we've failed to recognize that the composition of the arslisters is different than it used to be. Just like bmc is changing the applications to be 'non-development' OOB applications we may have many listers that do not read the list on a regular basis. They send an email if they have an issue, get the answer, and then don't come back until they have another question. I go through the arslist emails every day. I find it therapeutic to know others have far more issues than I do and more importantly to learn about things I may never come across. I may not remember all of it off hand but I know I've seen something about it and can find it later. Maybe core arslisters have to adjust their expectations of the list. OR maybe the others just NEED TO VOTE !!! Susan On 10/4/07, Daniel Bloom <[EMAIL PROTECTED] > wrote: ** Okay folks. Last chance: we need another 35 votes for MVP we need more votes for the software categories. Just look up the past posts for the list of nominees and send your votes to either [EMAIL PROTECTED] or [EMAIL PROTECTED] __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ -- Howard Richter Remedy ServiceDesk Manager CedarCrestone Managed Services Center [EMAIL PROTECTED] __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ Moody friends. Drama queens. Your life? Nope! - their life, your story. Play Sims Stories at Yahoo! Games. http://sims.yahoo.com/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"