Re: Question: Export attachment Many to many

2011-10-25 Thread Misi Mladoniczky
Hi, If you create a report with your attachment slots, you can export all 5 records in a single run to an ARX file. Your attachments will be placed in a sub directory. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at

Re: AW: kind of selection

2011-10-25 Thread Misi Mladoniczky
Hi, If you go with my suggestion, you can have the same form underneath both tables. My idea was to MOVE things from left to right. How to do this much depends on what end results your are trying to accomplish. You might get better response from the list if you explain that to us. I suggest

Re: Question: Export attachment Many to many

2011-10-25 Thread Ddussie
Thank Misi, Found the code after I posted. That has led to scripting runmacro to grab each request and attachment and appending with entryid. Sincerely, D.Dussie On Oct 25, 2011, at 2:49 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, If you create a report with your attachment slots, you

Email Attachment Weirdness

2011-10-25 Thread Sharon Menachem
Hi All, After a year of successfully sending out emails with between 1-4 attachments included, and an html template, the attachments have stopped going out WITHIN our domain. If the emails are sent to a different domain they go out just fine. These are files, contracts, emails etc i.e.

Re: Email Attachment Weirdness

2011-10-25 Thread Misi Mladoniczky
Hi Sharon, Turn on debug logging on Email Engine. You will see exactly what is passed to your SMTP-server, and you can compare what it receives between the external and internal email. If the attachments are sent to the SMTP-server, something happens outside of Remedy. Best Regards -

Internal Servern Error 500 (Midtiern 7.604)

2011-10-25 Thread Daniel Tillberg
Hi! We have a reported ussue/bug created at BMC since June 2011 regarding a issue that gives some users the error Internal Server Error 500 when opening some of our forms. When the error occurs other users can look at the same form without any problems at all. If we give the user a new

Internal Servern Error 500 (Midtiern 7.604)

2011-10-25 Thread John Baker
Hello Internal server error 500 means the application died processing a request. These issues are typically NullPointerExceptions, which usually take about 30 seconds to resolve. Look for Exception in the Tomcat stdout log and paste what you find. John

Re: Internal Servern Error 500 (Midtiern 7.604)

2011-10-25 Thread patrick zandi
John, By any chance do you have a script that will check for those? and then auto shutdown apache and restart it up? for unix? On Tue, Oct 25, 2011 at 6:02 AM, John Baker jba...@javasystemsolutions.comwrote: Hello Internal server error 500 means the application died processing a request.

Re: Internal Servern Error 500 (Midtiern 7.604)

2011-10-25 Thread Daniel Tillberg
Hi! Thats one of the problems, the stdout.log only gives us the following every time the error occurs: java.lang.NullPointerException Nothing more :( ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org

Re: Internal Servern Error 500 (Midtiern 7.604)

2011-10-25 Thread Daniel Tillberg
No, that would give the users problems during the restart of tomcat, so that is no solution for us. Besides we are using a windows 2008 server enviroment. 2011/10/25 patrick zandi remedy...@gmail.com ** John, By any chance do you have a script that will check for those? and then auto shutdown

Re: kind of selection

2011-10-25 Thread Reiser, John J
Christoph, Table fields are just a view of the data stored in a form. So your first part is correct. The left side table would show results of the Character field of Form 1. Why are you processing this as a table when a menu would do? You can select menu items and have then concatenated

Internal Servern Error 500 (Midtiern 7.604)

2011-10-25 Thread John Baker
Patrick, Unfortunately I don't. Call me old fashioned, but at JSS, we try to fix the bugs before the product goes out of the door and when bugs are reported, we get a patch out as soon as possible (usually within 24 hours) :-) You'd need to monitor stdout*.log on Windows, or catalina.out on

Internal Servern Error 500 (Midtiern 7.604)

2011-10-25 Thread John Baker
Daniel It's very poor to hide the exception, so I doubt it's hidden. It's likely to be printed elsewhere, have you looked in armidtier.log? If there is no exception, I don't understand how BMC can verify/fix it unless they can reproduce. Here's what an exception looks like:

Re: Internal Servern Error 500 (Midtiern 7.604)

2011-10-25 Thread Anders, Thomas (ext)
John, Daniel Our Mid-Tiers/Tomcats create separate txt files in the Tomcat log directory for each exception, e.g. localhost_log.2011-10-24.txt In catalina.out, you will only get the NullPointerException message, not the whole stack trace. You can configure this in Tomcat's server.xml:

Re: Internal Servern Error 500 (Midtiern 7.604)

2011-10-25 Thread Grooms, Frederick W
Tomcat has had a force option for years tomcat/bin/catalina.sh stop -force Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Baker Sent: Tuesday, October 25, 2011 8:50 AM To: arslist@ARSLIST.ORG Subject: Internal

Unable to connect to oracle when starting remedy

2011-10-25 Thread Dan
Hi listers, We had an issue with our server today. The server process stopped and when trying to restart it we can't connect to the database (oracle) due to a bad username/password issue. Checked with our DBA and the oracle password had expired and was locked. Changed it to un-locked and

Re: Unable to connect to oracle when starting remedy

2011-10-25 Thread Chowdhury, Tauf
Dan, in your ar.cfg, you should see entries like this. Make sure the DB user name and PW are correct. Also, can your DBA verify which server the bad requests are coming from? Just make sure there are no apps outside of AR like Analytics or Dashboards that are also trying to use the account and

BMC Analytics Missing form

2011-10-25 Thread John . Atherly
I'm looking in the Universe for the Remedy form User and do not see it. I Imported the Universe and did a refresh on it and it is not listed in the forms. Am I missing a step or is there something I need to turn on the form so Analytics can see it Remedy 7.6

Re: BMC Analytics Missing form

2011-10-25 Thread Chowdhury, Tauf
John, Analytics is basically a pre-packaged universe that BMC has written which encompasses most of the ITSM suite that is forward facing to the user community for reporting such as your Incidents/Changes/Problems/ etc... For something like the User form to be visible as a Universe item, you

Re: BMC Analytics Missing form

2011-10-25 Thread John . Atherly
Not showing up in the drop down box. I believe your first part is correct and I need to do an insert table and insert it. Then it will or should be in the drop down box. Thanks _ John Atherly | APC by

Re: Unable to connect to oracle when starting remedy

2011-10-25 Thread Dan
first thank you for your input. I am running on a UNIX platform so I looked into my ar.conf file. Db-name: Db-user: both are there and correct. I do not see a Db_password entry. only password entries are DSO Remedy-App Mid-Tier they are also not in plain text. our ar.conf file has not been

Re: Unable to connect to oracle when starting remedy

2011-10-25 Thread Daniel Pritchard
fixed Went to my production server and took the Db_password: and value, copied and pasted into the one on my test box and it now works. Now to figure out what happened to the Db_password value to start with.. Thanks for the help

How to create a request automatically from an Incident with a Business Service associated BUT.......

2011-10-25 Thread Alberto Mel.
Hi all I'm doing an integration with the email engine. I create an entry in the HPD:Incident InterfaceCreate and this creates the incident but I want that this creates the related request too. I've checked in the HPD:Incident InterfaceCreate the field Create Request to yes and I've written

Re: Internal Servern Error 500 (Midtiern 7.604)

2011-10-25 Thread patchsk
We are in itsm 7.6.03 p002 and we are also noticing this. We saw this happening when when user tries to open a dialog on click of a menu or button. This does not happen to all the users all the time. Only one or two users notice it while it works fine for all others. As you mentioned the

Discovery ADDM 8.3

2011-10-25 Thread Kathy Morris
Hi, In what instances would you have to log on remotely to the Appliance server with ADDM 8.3? Are there any log files that we should be examining on the Appliance Server directly, that we cannot view via the Admin tool User GUI?

Re: Discovery ADDM 8.3

2011-10-25 Thread patrick zandi
Configuration and functionality is through the gui.. once set up.. I know of no reason to access the server itself outside the gui interface.. but if you are the admin, security scanning.. you want to still have access.. I would highly doubt it.. but someone else on the list might through out

ARS 7.6.04 OOB Groups

2011-10-25 Thread David Abry
All, We have installed ITSM 7.6.04 and SRM 7.6.04. Does someone have a server with the original groups that they can provide in a .csv format? Thanks in advance. David Abry ___ UNSUBSCRIBE or access ARSlist Archives

Internal Servern Error 500 (Midtiern 7.604)

2011-10-25 Thread John Baker
catalina.out contains stack traces for every other application I use, including MidTier :) The log file you mention is enabled by default. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12

Indexes that aren't really there

2011-10-25 Thread L G Robinson
Hi Folks, My AR System is confused about the indexes on a particular form. The AR System believes that there are four indexes on this particular form but in the database (Oracle) there are no entries for this form in the SCHEMA_INDEX table. When I attempt to delete the indexes using Dev Studio, I

Re: Discovery ADDM 8.3

2011-10-25 Thread Rajesh Gullapalli
Kathy, There are several logs on the appliance. See below: export-creds.log export_startup.log tc_shutdown.log tc_startup.log tw_appliance_df.log tw_appliance_du.log tw_appliance_sar.log tw_appserver.log tw_baseline.log tw_cmdbsync_exporter.log tw_consolidation.log tw_cron_update.log

Re: Indexes that aren't really there

2011-10-25 Thread Grooms, Frederick W
So there are indexes on the T table, but no record of them in SCHEMA_INDEX. Then Oracle knows of them, but ARS should not. Have you tried restarting the app (as the index info is held in memory while the server is running) Fred -Original Message- From: Action Request System

Re: ARS 7.6.04 OOB Groups

2011-10-25 Thread Misi Mladoniczky
Hi, You should always use ARX-files, if possible, when working with internal data. I would imagine that you would find an ARX-file containing the groups in the installer package somewhere. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia

Re: Indexes that aren't really there

2011-10-25 Thread L G Robinson
Hi Fred, Nope, it is the other way around Dev Studio says there are indexes, but there are none on the T table nor entries in the SCHEMA_INDEX table. Thanks. Larry On Tue, Oct 25, 2011 at 2:03 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: So there are indexes on the T table,

Re: Indexes that aren't really there

2011-10-25 Thread L G Robinson
Sorry, there is an index on C1 on the T table, as you would expect, but no others. Thanks. Larry On Tue, Oct 25, 2011 at 2:19 PM, L G Robinson n...@ncsu.edu wrote: Hi Fred, Nope, it is the other way around Dev Studio says there are indexes, but there are none on the T table nor entries

Re: Indexes that aren't really there

2011-10-25 Thread Misi Mladoniczky
Hi, I have seen that index creation has failed, but the AR System repository still has the indexes in them. The problem is that you can not recreate the indexes, because the AR System gives you an error while it tries to delete the original index. Just look in the schema_indexes table and

Re: Indexes that aren't really there

2011-10-25 Thread LJ LongWing
Larry, What I would do to take care of this would be to export the form to XML Def.remove all index information from the def.then re-import it..I would expect that to take care of the scenario you are dealing with. From: Action Request System discussion list(ARSList)

Re: ITSM Group name = 1000000022

2011-10-25 Thread Mueller, Doug
Claire, The group ID is the value stored in any definition and the group ID can always be used in any reference to a group. The name is just an alias that is a pretty name to be used when interacting with people. If you want to change the group name from a number to a name, there should be no

Re: Discovery ADDM 8.3

2011-10-25 Thread Kathy Morris
Understood. I can view the logs below by looking under Administration/logs in the GUI. My question was ... is there ever any reason to log on directly to the appliance server for logs and/or troubleshooting. In a message dated 10/25/2011 2:03:32 P.M. Eastern Daylight Time,

Re: Indexes that aren't really there

2011-10-25 Thread L G Robinson
Hi LJ, Thanks for the suggestion. However, I found it easier to do as Misi suggested. I created the indexes that the AR System thought were already there using direct access to the database. Then I was able to delete the indexes using Dev Studio. Finally, after updating, I was able to create the

ITSM - 7.6.04 - Email Templates

2011-10-25 Thread Sanford, Claire
I have a team here that likes to create their own things and then have them send an email to Remedy to create a ticket. In the 6.3 world it was easy. Just send an email to the HPD:HelpDesk or CHG:Change form and it will create the ticket using an email template. Can I do the same thing in the

Re: Discovery ADDM 8.3

2011-10-25 Thread Rajesh Gullapalli
Well... Other than during the initial setup and if you want to edit graph defenitions text file. You would not need to login (BMC also recommends that you do not use command line). ButAdmins would need access to the Applicance. 1) To setup crons (for example:: backups using snapshot tool).

Re: Discovery ADDM 8.3

2011-10-25 Thread Kathy Morris
Thanks. In a message dated 10/25/2011 4:18:23 P.M. Eastern Daylight Time, rgull...@gmail.com writes: ** Well... Other than during the initial setup and if you want to edit graph defenitions text file. You would not need to login (BMC also recommends that you do not use command

Re: Indexes that aren't really there

2011-10-25 Thread Misi Mladoniczky
Hi, It would not. The AR System still thinks the indexes are there, but they are not. Best Regards - Misi, RRR AB, http://rrr.se Larry, What I would do to take care of this would be to export the form to XML Def.remove all index information from the def.then re-import it..I would

Compliance activity for Remedy

2011-10-25 Thread John Sundberg
I was wondering - what kind of compliance events do people use for Remedy? Some examples: Disable all accounts where password has not changed 120 days Remove all accounts that have not been used 365 days Remove groups - where no members exist. Review mid-tier log files for excessive error

Re: ARS 7.6.04 OOB Groups

2011-10-25 Thread David Abry
Thank you. Appreciate it. On Tue, Oct 25, 2011 at 2:11 PM, Misi Mladoniczky m...@rrr.se wrote: Hi, You should always use ARX-files, if possible, when working with internal data. I would imagine that you would find an ARX-file containing the groups in the installer package somewhere.

Re: Indexes that aren't really there

2011-10-25 Thread John Sundberg
What would be great is a util that validates what actually exists is what is thought to exist. And - it could run after every install. And - after every upgrade. And - it could run 1/week as part of compliance. BMC should write this - if it does not already exist. (It would catch tons of

Re: Compliance activity for Remedy

2011-10-25 Thread Joe Martin D'Souza
Consolidating / merging duplicate groups (same members which are not likely to change) if it appears they were created to serve the same functional purpose, may be a good idea too.. Joe From: John Sundberg Sent: Tuesday, October 25, 2011 4:27 PM Newsgroups: public.remedy.arsystem.general To:

Re: Indexes that aren't really there

2011-10-25 Thread Grooms, Frederick W
I have a script (for Oracle) that I wrote a while ago to do just this. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg Sent: Tuesday, October 25, 2011 3:31 PM To: arslist@ARSLIST.ORG Subject: Re:

Re: Compliance activity for Remedy

2011-10-25 Thread Larry Barnes
I would be careful about removing any account that hasn't been active for x number of days. I learned the hard way that deleting an account also deletes the tickets tied to that user. Just my 2 cents worth. Larry B. From: Action Request System discussion

AW: AW: kind of selection

2011-10-25 Thread Wagner, Christoph
Hi listers, this is exactly what I want. I have a ticket form, where each request represents a failure in our company, of course (e.g. Server A is down, Server B is down and so on). For each request the user should select some out of 20 people which have to be notified. For this selection I

Re: Compliance activity for Remedy

2011-10-25 Thread John Sundberg
H That seems like weird workflow to me... But yes - I would agree - it is minimally debatable what is to be done with inactive accounts. You could scramble a password -- making it unknown to anybody - effectively locking it. But - I did not know it deleting records by removing a User

Re: Compliance activity for Remedy

2011-10-25 Thread Joe Martin D'Souza
I was wondering about this too.. I have never seen tickets being deleted as a result of deleting a user account. Loosing access, yes, when the ticket was locked out using 112, but the ticket wasn’t deleted altogether.. Might be some funky customization in my opinion too.. Joe From: John

Re: AW: AW: kind of selection

2011-10-25 Thread Remedy
My original response for a solution is still the way to go. The help guide in developer studio has already done most of the work for you, telling you step by step what to do. Two table fields all pointing to what ever form your people information sits in. Table 1 shows the list of users to

How I create sample data

2011-10-25 Thread John Sundberg
I was recently asked how I make my sample data for: http://demo.kineticdata.com/KinCal/calendar?CalendarName=sample_scheduled_changes I use Klink as my Remedy API (allows me to use straight Ruby) https://github.com/kineticdata/klink Here is my script: require rubygems require kinetic/link

Remedy on Demand - integrations

2011-10-25 Thread John Sundberg
Does anybody know how integrations are supposed to work with ROD? Meaning - if you have a tool that monitors a log file -- and an error is found and you want to create an Incident - what are your options? Can you use the normal Remedy Java API to do so - or do you have to use WebServices --

Re: Compliance activity for Remedy

2011-10-25 Thread Christine Milton Hall
Just a thoughtI believe you can disable the user so that the ID cannot be used and then tickets would not be deleted. I have not heard anything actually deleting the user ID's and it seems like it would not make sense to delete records with the user account c From: Joe Martin D'Souza