Remedy View forms and SQL

Hi all, i am just trying to create a remedy view form and environment details are below DB : Oracle ARS: 7.0.01 i wont to pull the data from the form which is present in the same database( as arsystem tablenamespace) under user sys(System tablenamespace) using remedy view forms using SQL query.

Re: Remedy View forms and SQL

Hi, i think you should first create view with your query in the DB and then create the view form on the new view On Wed, May 26, 2010 at 10:11 AM, Gopal-srg srgr...@gmail.com wrote: Hi all, i am just trying to create a remedy view form and environment details are below DB : Oracle ARS:

Re: BMC's Sample SSO White Paper/Code

Hi, Send me the whole arplugin log to my email address and I will take a look. Send me the whole file so I can see the startup information. Regards Danny dkellett ( at ) javasystemsolutions.com Single Sign On (SSO) for ARS and ITSM http://www.javasystemsolutions.com/jss/ssoplugin Danny so

Re: Remedy View forms and SQL

Hi Hany, Thanks for ur response. the view for the form which i try in SQL already exist in the database. Also error which it throws is like some error in the SQL definition. Regards, Gopal Hany Abd El_Fatah wrote: Hi, i think you should first create view with your query in the DB and then

Customizing BMC Remedy Knowledge Management 7.5

Dear Colleagues, i need to customize the BMC Remedy Knowledge Management 7.5. For that reason, i must to change the Titles on the user interface (like Home, Search, Browse, News Flashes and etc), but i can not find where RKM store them. Can someone help me on that? Cheers, Plamen Ivanov

Re: Remedy View forms and SQL

Hi, then you can check the fields type if it's supported from remedy or not, and if the view exist in the DB so all what you need is to write the view name in the view form not the SQL On Wed, May 26, 2010 at 11:39 AM, Gopal-srg srgr...@gmail.com wrote: Hi Hany, Thanks for ur response. the

WWRUG preso on Server Group

** Hi All, I'm proposing a topic "Server Group - Beyond the Obvious" as sort of a follow on to my topic from a few years ago about how server groups work and how to install. I've learned a lot since about tweaks that are only lightly documented such as places where you have to directly edit the

Re: Customizing BMC Remedy Knowledge Management 7.5

Plamen, I had a similar request which I asked BMC and they claim that most of the UI is stored in the rkm.war file. This means that it's essentially not customizable. Michael -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On

Tomcat 5.5.25 SSO Mid Tier Failure

I thought the Midtier.jar file contains the two classes we can see in the stack trace: java.lang.NoClassDefFoundError: Could not initialize class com.remedy.arsys.session.Login com.remedy.arsys.stubs.GoatServlet.postInternal(Unknown Source Hence the exception appears to be a lie. We'd

Re: Tomcat 5.5.25 SSO Mid Tier Failure

Here is the STDOUT.log file from Tomcat. - Trying to load configuration arsys_api.xml - Could not load optional configuration arsys_api.xml - Trying to load configuration default.xml - setCatalogFileName: arcatalog - constructor(arcatalog) - setJrpcMode: true - useLegacyQualParser: false -

Re: Customizing BMC Remedy Knowledge Management 7.5

Hi Michael, thanks a lot for your reply. That is really pity... I found the following facts as well: 1. Only customizable are the templates. 2. The Thesaurus functionality (Stop file as well) is not working with Cyrillic words and symbols. If someone else knew other restrictions, I will

Re: Remedy View forms and SQL

So you want a view form 1 record that has only 1 column? What do you have in the Form Properties, View Information tab? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Gopal-srg Sent: Wednesday, May 26, 2010 2:11 AM

Re: Mid-tier BOXI

I've removed the redirect and tried both the home (where the now blank default page is) and the /crystalreportviewers11 location, but get: The page cannot be found When trying to run a report, but I do get the blank index page and the authorization error when I access the sites directly. I've

Re: Mid-tier BOXI

Ok, this is the URL it's trying to pull up: http://mysever/arsys/m11c23c11b16/56FB4E5FAFEA4D336FC6EE4CE9E26851/null or http://mysever/crystalreportviewers11/arsys/m11c23c11b16/56FB4E5FAFEA4D336FC6EE4CE9E26851/null Does that look right? arsys is not the name of the reports directory or any part

Error Log for Sim installation

Hi Listers, I received the following errors while running the ARintegration file for SIM. Please let me know what might be the probable reasons and effects if anybody has done that already. Do I need to reinstall the same? [ERROR][Wed May 26 19:25:55.264] LoadApp- no element found at line 87

Mailbox disabled

Hi everyone, We are facing an issue with email engine. We've disabled a mailbox in AR System Email Mailbox Configuration form in our production server, but the engine is still checking this mailbox. This is a test mailbox that should work only in our test environment. We've changed the

Re: Mailbox disabled

You need to restart the email engine process on the server to change the mailbox settings like this. Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only

Upgrade to 7.5 Patch 4 and 5 fails

Hi there, we're on ARS 6.3 with Oracle 9.2 on Linux Red Hat. We're trying to upgrade from 6.3 to 7.5 on Oracle 11 and Linux Red Hat. We tried to upgrade to 7.5 patch 4 and then to 7.5 patch 5; both fail while executing this statement: Failed to run SQL statement [ALTER TABLE ACTLINK_MESSAGE

Tomcat 5.5.25 SSO Mid Tier Failure

The SSOAuthenticator wasn't compiled for that Midtier, it seems. It's probably worth reminding you that BMC aren't going to support that SSO example because it's just an example, it isn't in any way a solution for production. John -- Java System Solutions SSO Plugin for the AR System

Re: {Remedy ARS} Remedy Mid-Tier Patch 8 upgrade issue

We discovered that there is a bug with the installer for Mid-Tier 7.1 patch 8 and ServletExec 5.0 and Java 1.5 patch 15 combination. We were able to roll back the patch to an earlier version but it took us over 21 hours to recover our two mid-tier servers and many long hours with 3 different

Re: Cannot able to login to Remedy Server 7.1

Are you using portmapper? If not, then you need to ensure you specify the port to connect to when you connect. If you are, then it's possible the AR server is not running. If you're behind a load balancer, the load balancer also needs to forward port 111, if you're using port mapper. Just a

Re: Customizing BMC Remedy Knowledge Management 7.5

In patch 3 of 7.2 the ability to localize/customize any label in RKM was introduced.  See the patch file readme (Starting on page 9).  I would imagine this feature progressed into the 7.5 release but don't know for sure. Alan BlakeKnowlysis --- On Wed, 5/26/10, pivanov

Re: Upgrade to 7.5 Patch 4 and 5 fails

I looked in my 7.1 (on Oracle) and the MSGTEXT column is a CLOB. I'm not sure why yours is a LONG column. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Milke Sent: Wednesday, May 26, 2010 9:52 AM To:

OT: Remedy ARERR message lookup page

Hi, I have published a new open web-page where you can lookup details concerning the error message numbers from Remedy. You can access directly from a form on our main page: http://rrr.se Or you can go straight the slim-lined web page: http://rrr.se/cgi/arerrr I am planning to open the

Re: Upgrade to 7.5 Patch 4 and 5 fails

Some other general thoughts: 1. AR System 7.5.00 is only supported on 64-bit Red Hat Linux - is it possible you're on a 32-bit Linux operating system? 2. If not (i.e. you are on a 64-bit Linux OS now), did you replace your Oracle client with a 64-bit 10gR2 client as per the compatibility

Re: BMC's Sample SSO White Paper/Code

Thanks for all your help Danny. I got it working. I appreciate all the info you provided was EXTREMELY helpful. Rafael -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Danny Kellett Sent: Wednesday, May 26, 2010 4:07 AM

Re: Customizing BMC Remedy Knowledge Management 7.5

Just as an FYI – and I realize this is not a short term fix for your request – but in future versions of RKM (i.e. major/minor releases after 7.5.00), RKM will be a native AR System application like ITSM, SRM and SLM. Beyond the obvious strong benefits of being an AR-powered application

Re: Upgrade to 7.5 Patch 4 and 5 fails

I hate it when I hit send to fast... If your column is really a LONG it should have been updated back with 6.3. I have a script that can convert a LONG to a CLOB if you need it. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]

Incoming email create

List, I have incoming emails that ARS is parsing out and creating tickets with the simple submit instructions from the email engine guide such as Schema: HPD:HelpDesk Server: TestServer Login: Testuser Password: 12345 Action: Submit etc I get this to work but, we are using a load balanacer

Re: Customizing BMC Remedy Knowledge Management 7.5

If you create a resource folder under the: ar system applications\BMC Remedy Knowledge Management\data\kms_conf\Resource and then add the KmsL10n_en.properties file you can modify it and it will show in rkm webpage. I stopped tomcat and did this, restarted tomcat and the changes I made to the

Re: Customizing BMC Remedy Knowledge Management 7.5

Sent before I meant to, I was able to modify the headings on the main page and even the headings on the tabs etc... under the headings. The main heading section is in the document under this section ## #TemplateServlet.java

Re: RKM/Tomcat Issue

well if I do that it works, but customers want to not have to do that. From what I have heard and seen there is nothing to fix this, just the way XLM reads certain things, but I as hoping :) On Tue, May 25, 2010 at 5:14 PM, cpgold cpg...@gmail.com wrote: ** The only thing I can think of is

MT 7.1 and AR Server 7.0

Is it OK to Run MidTier version 7.1 against an AR System 7.0 server? Want to know if anyone has experienced any issues with this configuration. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend

Re: Mailbox disabled

Hi Anne, Thanks for your reply. We've fixed the issue, without restarting the process, by updating the record again in the form. We've enabled and, after, disabled the mailbox and the cache seems to be updated, the log is not being generated anymore. Thanks and regards, Rogerio Aguiar On Qua

Re: MT 7.1 and AR Server 7.0

Yes, it is and officially supported also. I currently run 7.5 against 7.0.1 but I've also ran 7.1 without any problems. According to the compatibility matrix, 7.1 is supported for 7.0, you should have no issues. I would actually recommend you check out 7.5, as you then get Safari and Chrome

Re: MT 7.1 and AR Server 7.0

Ø I would actually recommend you check out 7.5, as you then get Safari and Chrome support FYI, Chrome is not officially supported on any version of AR System currently. And Safari support was added in AR System 7.1.00 -David J. Easter Sr. Product Manager, Enterprise Service Management BMC

Attachment Virus Scanning

Hi All, Is anyone aware of software that Remedy can call or interface with to scan files before they are attached to a form? TIA, Mike -- View this message in context: http://old.nabble.com/Attachment-Virus-Scanning-tp28684105p28684105.html Sent from the ARS (Action Request System) mailing

Re: MT 7.1 and AR Server 7.0

Ok…I was gonna hafta go check out the matrix and verify that….I wish Chrome was supported… From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Easter, David Sent: Wednesday, May 26, 2010 11:55 AM To: arslist@ARSLIST.ORG Subject: Re: MT 7.1 and AR

Re: MT 7.1 and AR Server 7.0

Safari support in 7.1 did not work well, official or not. At least in my experience. I know Chrome is not officially supported as well, but since it is apparently based off the same code as Safari, it works by accident I guess :) From: Action Request System discussion list(ARSList)

Re: MT 7.1 and AR Server 7.0

Thanks for the replies, I will check out 7.5 MT vs AR 7.0.1 On May 26, 1:09 pm, Maher, Jeff jma...@fas.harvard.edu wrote: Safari support in 7.1 did not work well, official or not. At least in my experience. I know Chrome is not officially supported as well, but since it is apparently

6.3 arsql log - how to read?

looking at a sql log from ars 6.3 -- how do you interpret ??? What is TID and RPC ID and Client-RPC. I can guess at most - but thought I would get opinions. Ultimately - the goal is to find the start and end times of a select or insert etc... Is that even possible with a 6.3 log? 7.5 logs

Re: 6.3 arsql log - how to read?

Hi John, Well, the TID is the thread id. It seems to be a number that is assigned to each thread as it starts up. Sometimes you can see ids with number over 1000, but in the same log there will only be a limited number of threads, as defined in the configuration of the server. Maybe threads die

Re: Tomcat 5.5.25 SSO Mid Tier Failure

I replaced the SSOAuthenticator file with another and it worked. Thanks for all the suggestions. Christopher Puente Enterprise Remedy Engineer HQ USSOCOM, Team EITC (813)826-3017 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On

Single Sign On and Remedy

Hello All, I have been tasked with coming up with a Single Sign On solution using Remedy as the source. I think the People form would be the obvious place to start. I am curious to know if anyone else has done anything similar or if there is some Out of the Box solution available that integrates

Re: adv SSO Plugin voice commentary

-- Sent from my Palm Pre On 10 May 2010 22:30, John Baker jba...@javasystemsolutions.com wrote: Listers, As some of you will be aware, JSS enjoy creating movies to demonstrate Single Sign On for AR System, but people have told us that a commentary would be nice. Therefore, if you've

Re: adv SSO Plugin voice commentary

-- Sent from my Palm Pre On 10 May 2010 22:30, John Baker jba...@javasystemsolutions.com wrote: Listers, As some of you will be aware, JSS enjoy creating movies to demonstrate Single Sign On for AR System, but people have told us that a commentary would be nice. Therefore, if you've got a

Re: 6.3 arsql log - how to read?

** John,I'm trying to think of *why* I would have kept a 6.3 log file lying around and cannot think of a good reason here :-)But, since you have the thread ID, you could consider that the next statement on that thread ID is the worst case for the preceding statement having completed. If you don't

Re: Single Sign On and Remedy

The classic doc on SSO is on the BMC support site. Here's the link I turn up (this is valid for ARS 7.1): http://documents.bmc.com/supportu/documents/57/12/65712/65712.pdf This directs you through the free option, which essentially is allowing the customer to use their domain password to

Re: BMC's Sample SSO White Paper/Code

Your welcome :) Danny Single Sign On (SSO) for ARS and ITSM http://www.javasystemsolutions.com/jss/ssoplugin -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rodriguez, Rafael J x23718 Sent: 26 May 2010 17:16 To:

Mac ODBC Driver

Greetings ARList! Trying to extract data from Remedy using ODBC to Excel on a Mac. Anyone suggestions? Thanks, Russ ___ UNSUBSCRIBE or access ARSlist Archives at

Re: Attachment Virus Scanning

From midTier you can go through a proxy and that proxy server can virus scan before it get to the Server. For User tool this is what we did. We used a custom Upload Servlet with a DV front end for the User Tool. The Servlet uploaded to a special directory where a Virus scanner was run. Then the

monitor Remedy escalations performance

Hi ARSListers,   I'm currently doing a comparison on two Remedy servers that run on two different platforms (Soalris 10 and Windows 2008). I want to know if there are available tools that I can download to check the performance of the escalations running on both systems. I already used AR

Re: monitor Remedy escalations performance

Hi, RRR|Log will give you the time each escalation takes to run and the number of records found. You can search per thread. It is not free to use in that capacity though. It also gives you a whole bunch of useful statistical information, and log file navigation/drill-down functionality.

Re: Incoming email create

Hi Kevin, Make use of below template to specify TCP and RPC port numbers. Schema: HPD:HelpDesk Server: TestServer Login: Testuser Password: 12345 Action: Submit TCP:[TCP port number] For Specifying RPC number use RPC :[RPC port number] Regards, Yogendra DISCLAIMER: The opinions, statements,