Re: CLM information

2012-02-27 Thread Kunal Sonawala
@Mike, please find answers to your queries: How close it integrated with Remedy? è It comes OOTB integrated with Remedy. You can access it from IT Home Page; and it uses BMC Remedy ITSM Change Management for approvals and BMC SRM for service requests. Does it use Remedy permissions or it

Plugin Error (8760) when accessing Server Information Form

2012-02-27 Thread Kali Obsum
Hi, Has anyone experienced this error when accessing Server Information form? ARERR [8760] Cannot establish a network connection to the AR System Plug-In server : (5121) : RPC: Miscellaneous tli error - System error (Connection refused) Our system has been working for over a year already

Re: Archive Form - Change Table Form?

2012-02-27 Thread Misi Mladoniczky
Hi, They are surely meant to be used in some way. The main thing would be to view and search old archived stuff. I see no reason why you should not be able to change a table with related child-records to be redirected to the archived child-form. Without seeing the WorkLog it is hard to get the co

Re: Archive Form - Change Table Form?

2012-02-27 Thread Jose Huerta
But if you change the parent form (add a new field for instance) the customizations you made on the archived form can be lost. So a "view" (join form) is a better approach. I talk from the experience of modifying the audit form and start getting a lot of problems. Jose M. Huerta Project Manager**

Outbound and inbound email boxes.

2012-02-27 Thread Michael Burton
Hi, Can somebody confirm that we can only have one outbound mailbox configured on our system? To clarify, we have a number of incoming mailboxes set up on our system, but the only outbound one is AREmail_Out, i.e. the default. The functional limitation is that when a user emails in and a tic

Re: Outbound and inbound email boxes.

2012-02-27 Thread Satya Gandhi
Hi Mike, If you are using inbound email messages for each of your ITSM application module, you can make sure that the 'Reply-To' field is passed to the AR System Email messages form. This will ensure though the display email id might be your default emailaddress for your outbox configuration, if t

Re: Outbound and inbound email boxes.

2012-02-27 Thread Grooms, Frederick W
You can define as many outgoing mailboxes as you want. The only restriction is only 1 can be set as default You associate an Incoming and Outgoing mailbox to each other from the "AR System Email Mailbox Configuration" form. Check the Email Engine Guide chapter 2 for setting up mailboxes Fred

Re: The value of a remedy admin

2012-02-27 Thread LJ LongWing
Brian, You may want to check out Salary.com, they may be able to help you come up with a good salary range for a job title in a particular area of the country. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Sent: Sun

Remedy Table Recreation

2012-02-27 Thread Axton
First, some background information: It used to be the case that certain operations would trigger Remedy to recreate a database table: - rename existing table - create new table with the original name - copy the data from the renamed table to the new table - drop the renamed table I remember alteri

Opportunity with a major Fortune 500 oil and gas company

2012-02-27 Thread Rivera, Andrew
The opportunity is located in Bartlesville, OK. Our customer is looking to move quickly on candidates that are actively looking for opportunities. It is a direct placement opportunity with exceptional benefits and compensation packages. Please feel free to email resumes or call me at the contact

Re: The value of a remedy admin

2012-02-27 Thread Axton
It depends largely on what you bring to the table, the company offering the position, and what else the position entails. Consider these different skill sets: - I can write workflow - I can upgrade canned applications - I can write programs using the API (Java, C, etc.) - I can write PL/SQL or T-S

Re: Remedy Table Recreation

2012-02-27 Thread Grooms, Frederick W
I don't believe there are any actions possible from Mid-Tier or the User tool that will cause a table to be recreated. Yes I believe there are still some actions from DevStudio (or the API) that can cause the table to be recreated, but they should be limited to structure changes (and any anyo

Re: Remedy Table Recreation

2012-02-27 Thread LJ LongWing
Axton, Based on recent conversations with Dougshrinking the size of a Char field will NOT cause a recreation of the table...but a re-increase, of a size below the size allowed with the previous size, will...for example Original size: 255 New Size1: 49 New Size2: 50 N

Re: Remedy Table Recreation

2012-02-27 Thread Axton
I read that thread, but the terminology confused me. Just to be clear on the terminology; I am looking for things that issue a DROP TABLE and a CREATE TABLE (in an effort to alter the characteristics of an existing table) and I am not concerned with things that issue an ALTER TABLE. Thanks, Axton

Re: Plugin Error (8760) when accessing Server Information Form

2012-02-27 Thread Axton
I ran into this recently if I have the 'Plugin-Disable-Remote: T' option in the ar.conf file. Axton Grams On Mon, Feb 27, 2012 at 4:45 AM, Kali Obsum wrote: > ** > > Hi, > > > > Has anyone experienced this error when accessing Server Information form? > > ARERR [8760] Cannot establish a network

Re: Remedy Table Recreation

2012-02-27 Thread LJ LongWing
I can't speak definitively on that as I don't watch that level of activity at the DB on a typical basis. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Monday, February 27, 2012 9:50 AM To: arslist@ARSLIST.ORG S

Re: Remedy Table Recreation

2012-02-27 Thread Misi Mladoniczky
Hi, It depends on the database, where different vendors allow for different changes with ALTER TABLE. I think that if you go to/from 255 bytes in character lenght, this requires a datatype change from VARCHAR to TEXT, which will trigger the operation. For all practical purposes, it should be imp

Mid tier - failed to add attachment

2012-02-27 Thread VARGAS, JESUS EMILIO (JESUS EMILIO)
Hi ARList. We have a recurrently issue when we are trying to attach any kind of file via WEB (Internet Explorer, Firefox, etc..) the message is "failed to add attachment" we did the flush cache, clear the cookies and cache for the web browser but still the issue, we need to restart the tomcat s

Re: Mid tier - failed to add attachment

2012-02-27 Thread LJ LongWing
Check your 'cache' folder under the MidTier directory. You may be experiencing a disk full situation? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of VARGAS, JESUS EMILIO (JESUS EMILIO) Sent: Monday, February 27, 2012 10:37 AM To: arslist@ARSLIST.

Re: Remedy Table Recreation

2012-02-27 Thread Axton
Thanks Misi. I'm trying to identify a specific case on Oracle. I don't think this exists any more (as it used to), but I need to try and confirm. Hoping I get lucky and find someone who has run into this. Axton Grams On Mon, Feb 27, 2012 at 11:32 AM, Misi Mladoniczky wrote: > Hi, > > It depen

SRM permissions / auto logout

2012-02-27 Thread John Baker
Hello I recently came across a client with a modified ITSM however I'm not sure if this aspect was modified. If a user linked directly to the SRM console, and logged in, workflow logs the user back out immediately if they do not have the relevant SRM permissions. Is this a common configuratio

Re: Remedy Table Recreation

2012-02-27 Thread Grooms, Frederick W
Try changing a character field from < 4000 characters to > 4000 characters (or unlimited) This should change it from a VARCHAR2 to a CLOB and I think that will cause ARS to do the create new table, copy the data, and rename the tables operation. Fred -Original Message- From: Action Re

Re: Mid tier - failed to add attachment

2012-02-27 Thread VARGAS, JESUS EMILIO (JESUS EMILIO)
Hi The current size for the "cache" folder is 400 Mg, The Hard disk has enough space. (60G) Any other idea? Regards. J. Emilio Vargas From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Lunes, 27

Re: Remedy Table Recreation

2012-02-27 Thread Axton
Close. It creates a temp column and not a temp table: ALTER TABLE T3185 ADD (C536870916Z clob NULL) ALTER TABLE T3185 DROP COLUMN C536870916 ALTER TABLE T3185 RENAME COLUMN C536870916Z TO C536870916 DROP VIEW ztestsql1 CREATE VIEW ztestsql1 (Request_ID,Submitter,Create_Date,Assigned_To,Last_Modif

Re: Remedy Table Recreation

2012-02-27 Thread Peter Romain
I seem to remember years ago that databases would drop a table and rebuild it if you deleted a field but I understand that modern databases don't need to do this. Misi, adding or deleting a CMDB attribute will cause fields to be added to and deleted from tables. Out-of-the-box you'd need admin

Re: Mid tier - failed to add attachment

2012-02-27 Thread LJ LongWing
Check with support regarding configuration that can be done to modify how MidTier handles Attachments. They gave me some parameters a few years ago that makes it not use memory cache, but just deal directly with the file system..if a restart of the Tomcat instance clears it up, you may be having i

Re: The value of a remedy admin

2012-02-27 Thread Brian Pancia
Brian, Like everyone says it really depends, but on average I would say the salary table is as follows: Remedy Admin 1-2 years experience - $55,000 - $65,000 Junior Remedy Developer 1-3 years experience - $65,000 - $85,000 Mid-Level Remedy Developer 3-5 years experience $85,000 - $110,000 Senior

Re: Remedy Table Recreation

2012-02-27 Thread Walters, Mark
Have you checked the Database Reference Guide for your version? There's a section in there that details when/how the tables are modified. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: 27 February 2012

Re: Remedy Table Recreation

2012-02-27 Thread Joe Martin D'Souza
I thought DROP COLUMN always existed since the beginning of times - its just that the AR API didn't use it when it could have in many cases in the earlier days.. But then beginning of times for me was Oracle 7.x and greater and MS-SQL 6.x (6.5 I think) and greater, so am in no position to confir

Re: Remedy Table Recreation

2012-02-27 Thread Grooms, Frederick W
I don't think it was for Oracle or MS-SQL that Remedy used the table recreate method. It was for one of the other databases and Remedy used the same commands for all (to make cross platform development and support the same everywhere). It may even go back as far as when Remedy used to support

Error while consuming a web service - ARERR [9130]...

2012-02-27 Thread Joe Martin D'Souza
I am on AR System 7.6.03 (unpatched) and use Oracle 10.2.0.3.0 – 64 bit – its an all round windows environment. Not that it matters but we have the ITSM apps 7.6.03 (unpatched) along with SRM and RKM installed too. I have used SoapUI and tried to pass the same parameters, and have had no probl

Re: Remedy Table Recreation

2012-02-27 Thread Mueller, Doug
Axton, Well, I can say that the 7.6.04 release for Oracle, MS SQL, and Sybase databases does not drop and recreate any table at the DB level for any operation. Whether that operation is to resize a column, add a column, delete a column, change the constraints on a column, whatever you may do to a

Re: Remedy Table Recreation

2012-02-27 Thread Mueller, Doug
Axton, By the way On the other topic in your message, definition of a primary key. We found that a number of the replication technologies require a table to have a primary key in order to replicate successfully. Since every one of our tables has a primary key -- the entry ID -- and we can d

Re: Error while consuming a web service - ARERR [9130]...

2012-02-27 Thread Sabyson Fernandes
Hey Joe, Check your classpath and make sure that the files exist in the folder it is pointing to. On my servers I have 2 copies of these files. One in a folder where Kinetic is installed and the other in \jre\lib\ext. Saby --- On Mon, 2/27/12, Joe Martin D'Souza wrote: From: Joe Martin D'Sou

Re: Error while consuming a web service - ARERR [9130]...

2012-02-27 Thread Joe Martin D'Souza
Hey Saby, Thanks for your response.. That’s exactly what I’m leaning towards doing pending BMC Support approval (I have a support ticket raised with them).. Unfortunately though, I can’t be trigger happy just yet & attempt that change as I have other developers working on some other bits while

Re: Remedy Table Recreation

2012-02-27 Thread Axton
We did not see a primary key defined for the T, H, or B tables, or the meta-data tables, so we created a primary key on those tables. We did, however, see a unique index on all the T, H, and B tables. We are rethinking our approach because in later versions of Oracle Streams they added an option

Re: Error while consuming a web service - ARERR [9130]...

2012-02-27 Thread Grooms, Frederick W
What version of Java do you have on your server? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, February 27, 2012 3:20 PM To: arslist@ARSLIST.ORG Subject: Re: Error while consuming a web service - ARERR [9130]... **

Re: The value of a remedy admin

2012-02-27 Thread Samuel J Albury III
To summarize my respective colleagues (Brian Pancia not included), a person with knowledge of several technologies with BMC skills tend to demand more of a salary/hourly rate. I recall a conversation I had with some of my colleagues at a dot.com. They were baffled at why they could not break the

Re: Remedy Table Recreation

2012-02-27 Thread Grooms, Frederick W
Axton, I just looked at my 7.6.4 oracle database and all 3 of those tables has a column called RECORDID, although that column is not indexed on any of them. Primary key constraints can also be added after table creation with the alter statement (and they can have the same name as the unique ind

Re: Error while consuming a web service - ARERR [9130]...

2012-02-27 Thread Joe Martin D'Souza
Its 1.6.0_27 Thanks.. Joe From: Grooms, Frederick W Sent: Monday, February 27, 2012 4:33 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Error while consuming a web service - ARERR [9130]... ** What version of Java do you have on your server? From: Acti

Required fields for CTM:People from AIE

2012-02-27 Thread Brian Schwieder
Our people load got mucked up so I'm in the process of trying to rectify the issue using AIE Unfortunatly I keep getting the following [Mon Feb 27 2012 15:54:47.0980] - UpdateDataSchemaEntry: Error accessing form CTM:People UpdateDataSchemaEntry: AR API returned error during ARSetEntry rc = 2

Re: Required fields for CTM:People from AIE

2012-02-27 Thread Grooms, Frederick W
Since you are on 7.6.03 you should be able to open the "AR System Metadata: filter_message" form and look for msgNum 120173. That will tell you what filter number the error was created with (open the "AR System Metadata: filters" form to find the Filter's name). Fred -Original Message---

Re: Required fields for CTM:People from AIE

2012-02-27 Thread Louise Van Hine
what version of ARS/ITSM are you on now Brian?  If you are in 7.6.2-land still  it's a different situation than if you're in the new Atrium. Oh and by the way hi!  how's Thane and company? Louise From: Brian Schwieder To: arslist@ARSLIST.ORG Sent: Monday,

Re: Mid tier - failed to add attachment

2012-02-27 Thread DEE
We have a similiar issue in which we experiencing occasionally. We have reported 2 twice but no solution. Our issue, occurs with non admin users, on create with attachment, the attachment fails to attach. The user has to reattach after the ticket has been created. This is a big issue on our C

Re: Plugin Error (8760) when accessing Server Information Form

2012-02-27 Thread Kali Obsum
Thanks Axton. Unfortunately, that parameter is not in our ar.conf file. Regards, Kali -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Tuesday, February 28, 2012 12:52 AM To: arslist@ARSLIST.ORG Subject: Re: Plu

Re: The value of a remedy admin

2012-02-27 Thread Brian Pancia
Sam, You're a funny guy. I'll remember that next time you call. Hourly and 1099 rates will be a little different. Usually hourly employees get paid straight hours and don't get vacation time or paid time off. If you want to figure out hourly equivalent just divide the salary by 1960. If y

Re: Plugin Error (8760) when accessing Server Information Form

2012-02-27 Thread Axton
Look in the armonitor log and see if it is crashing. If it is, turn the plugin logs to debug and see the last thing it tried to do. On Feb 27, 2012 8:02 PM, "Kali Obsum" wrote: > Thanks Axton. Unfortunately, that parameter is not in our ar.conf file. > > Regards, > Kali > > -Original Message

Re: Mid tier - failed to add attachment

2012-02-27 Thread gok's
Check the Java heap size or try increasing the heap size and check the "attstore" folder if it full empty the folder and restart the mid-tier and Arserver. Thanks VARGAS, JESUS EMILIO (JESUS EMILIO) wrote: > > Hi ARList. > > We have a recurrently issue when we are trying to attach any kind of