Re: Need to export 12,000,000 or so records...

Bill, If you must have an .arx file you could use the runmacro.exe command. It is not especially fast, but much better than the WUT and you can start it and let it run while you do something else (like sleep). You can include queries with it to filter records as necessary and you can create a b

Re: Need to export 12,000,000 or so records...

Is there an requirement to save the data as arx? Can RRR|Chive do the task, and it may import them to staging forms and then into ITSM? -- Jarl 2009/11/12 William Rentfrow : > ** > > I have roughly 12,000,000 records I need to export to ARX format from CSS > 5.x to do a data migration to IM 7.0

Re: "Resetting" records.

Your best shot is an open window action that searches for the record by either its unique guid if there exists one or by the Request ID.. There is no function as such that does what you want.. Joe From: Alexander Straph To: arslist@ARSLIST.ORG Sent: Thu, Nov

Re: "Resetting" records.

Check out the earlier thread on this topic "Refresh record" PERFORM-ACTION-TABLE-REFRESH 1020 The solution ended up being the above to refresh the results list. 2009/11/13 Alexander Straph : > Hello. > > Trying to find out if there is a run process out there that "resets" a > record.  Now, I kn

Re: Need to export 12,000,000 or so records...

I do not know if you would be interested in going a little old school, but I recently had a situation where I needed to export a bunch of data from a production server environment to a reporting server environment. And by a bunch, I mean over 200 million records from six different forms. In this

Re: Need to export 12,000,000 or so records...

Unfortunately...no DSO :) William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com O 715-592-5185 C 715-410-8056 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Doug Blair Sent: Thursd

Re: Need to export 12,000,000 or so records...

This is not an option unfortunately. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com O 715-592-5185 C 715-410-8056 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tommy Morr

WWRUG09 report

Hi! There are a few minutes left before the start of tonight's "social event" at Body English, the hotel's night club, so i thought you might appreciate a bit of update. Heck, I can't get a beer until 6:45! Today started off with the Innovator awards, in which each of the vendors with a b

Re: Need to export 12,000,000 or so records...

** Bill,Is DSO available?  That will work across server versions, allow some field mapping, and (the reason I like it) allow you to keep the data current as the old server is updated before your cutover.  Don't do it all in one batch, of courseif you can log into both servers from the same user

"Resetting" records.

Hello. Trying to find out if there is a run process out there that "resets" a record. Now, I know that the command PERFORM-ACTION-APPLY simply commits a record to the database, but wondering if there is a similar command that reverts a record to its original state. Kind of like pressing F5 to

Re: Java API - parseQualification Error - Part 2

Thanks for the second opinion, LJ. I'll push and see where that goes. I'm not sure I've reached my bug submission quota for the year, yet, so maybe they'll let me slide this time. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On

Kforce - Job Opportunity - New Jersey - Remedy SME

Need more of a Process/Project Manager/Remedy SME Rate: 50/HR W2 Hourly All Inclusive Contract Duration: 6 Months No Extension Location: New Jersey Skillsets: ITIL Certified (V3 Preferred) PMP a Plus Remedy 7.x ITSM Knowledge with experience in most of the modules Windows/SQL Shop

Re: Java API - parseQualification Error - Part 2

I would personally push them to admit and log a defect. Point being that if they say you can use an ARServerUser object as such parseQualification(String form, String qualification) Parses a given readable qualification string into internal structure. And they are going to put a qua

Re: Java API - parseQualification Error - Part 2

LJ, Field ID or Name is irrelevant. What is suggested is instead of writing: QualifierInfo qual = ctl.parseQualification("Roles", "'Role ID' = -90"); //works in 7.1 just fine also works just fine for qual not having negative sign the work-around is to add the following: List fields = ct

Re: Caught Ecception Error

, Hyderabad - 500 081. AP. India www.gssamerica.com __ Information from ESET NOD32 Antivirus, version of virus signature database 4601 (20091112) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Wher

Re: Need to export 12,000,000 or so records...

Can you just use AIE from 7.x and pull the data directly from the 5.x database? Then stage it all out into separate jobs to reduce performance hit. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of William Rentfrow Sent: Thursday, November 12, 2009 3

Need to export 12,000,000 or so records...

I have roughly 12,000,000 records I need to export to ARX format from CSS 5.x to do a data migration to IM 7.03. The breakdown is roughly something like this: 3,000,000 archived SPRT:Issue records 1,000,000 Person records 6,000,000 Interaction records 2,000,000 misc related records (active SPRT:I

Re: WWRUG ARSLIST Awards

Chris, congratulations! Like someone else said, this was long overdue!   Joe From: Jason Miller To: arslist@ARSLIST.ORG Sent: Wed, November 11, 2009 5:58:28 PM Subject: Re: WWRUG ARSLIST Awards There were some cracks about your last name :) On 11/11/09, LJ Lon

Re: CMDB Application Server Database

Applications and databases are CIs. Build them (the application and database CIs) and establish relationships to them. Look at the Relationships tab, select type configuration element, search and relate them. ComputerSystem --> Application --> DB2 --> Application --> DB1

CMDB Application Server Database

Hello, I have a server in Computer System. I need to display the applications on the server, and the database instances to the applications. How do I associate the applications with a CI. I just see how to add the people and support groups to the CI.

Re: new notifications for emergency expedited changes

I have had some problems using TR values. If it is not working correctly, you can just use the field name without TR.. It is implied that you are looking at the field value at submit time. James On Nov 12, 3:44 pm, "Martinez, Marcelo A" wrote: > James, you're right; I want it to also notify if

Re: new notifications for emergency expedited changes

James, you're right; I want it to also notify if the timing changes to emergency or expedited. I've used something very similar to what you suggested: (('TR.Change Timing' != 'DB.Change Timing') AND (('TR.Change Timing' = "Emergency") OR ('TR.Change Timing' = "Expedited"))) Thank you for your h

Re: Caught Ecception Error

. AP. India www.gssamerica.com <http://www.gssamerica.com/> __ Information from ESET NOD32 Antivirus, version of virus signature database 4601 (20091112) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com _Platinum Sponsor: rmisoluti...@

Re: new notifications for emergency expedited changes

Why not have your filter fire only on Submit? If you want to also notify if the Change Type is changed to expedited or emergency, let it run on submit and modify. Then just enter a Run If qualification: 'Change Type' != "DB.Change Type" AND ('Change Type' = "Emergency" OR 'Change Type' = "Expedite

Re: Caught Ecception Error

In think only in one machine . ___ RAVI CHANDRA . RAMAGIRI Infrastructure Management Services Team System Administrator (O) +91 40 44556600 (351) (C) +91 9985794493 (V) 847-879-4995 Ext:- 351 * ravi.ramag...@gssamerica.com

Re: Connection timed out. Message number = 90 in ars 5.1

It is not the default telnet port. Can you simply see from the ar.conf if a port is set? If it is not set, then either set ARTCPPORT=0 or undefine it. Be careful, some shells need export for spawned processes to get the environment variable. So, it should be "export ARTCPPORT=0" Do a tracerout

Re: Caught Ecception Error

sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. __ Information from ESET NOD32 Antivirus, version of virus s

Re: new notifications for emergency expedited changes

Notifications are working, the theory checks out. The only problem now is that since my filters fire on submit and modify, a notification is created every time there is a change to the emergency or expedited ticket. My question is: How are filters for other "People Support Staff" configured? H

Modify All Functionality in Asset Management

Hi All, Here's the scenario I have at work and would like to solicit your feedback/inputs... OOB: Only 'Asset Admin' users have the create & modify permissions on the CI Client Scenario: Made customizations so that 'Asset User' can also create & modify a particular CI that they currently have a P

Re: Email engine

Install 7.3 in a different folder and you should be able to use both in parallel. But you can have protmapper only for one instance. For the RMI port you can change it in EmailDaemon.properties file in AREmail folder. On Nov 12, 3:26 am, Gianluca Nieri wrote: > Hi, > I have an ars 6.3 with it's o

Re: Caught Ecception Error

rus, version of virus signature database 4600 (20091112) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _

Re: Caught Ecception Error

Yes Kevin , If I am not wrong you are talking about the IE or Fire Fox cache right. Yes I asked to do that from the client side . ___ RAVI CHANDRA . RAMAGIRI Infrastructure Management Services Team System Administrator (O) +91 40

Re: Caught Ecception Error

d please request a hard-copy version. __ Information from ESET NOD32 Antivirus, version of virus signature database 4600 (20091112) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com _Platinum Sponsor: rmisoluti...@verizon

Caught Ecception Error

Hi All , Please can anybody explain why this error will get while we try to login with IE or Fire Fox browser. I have did what LJ and Begosh, Kevin told me to do but still this error occurs. I flush the cache of mid tier and disable the " persistence cache mode ". Is this th

Re: Java API - parseQualification Error - Part 2

Eric, So they are saying the problem is looking up the field name, and if you use the Field ID it works just fine? _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Roys, Eric D Sent: Thursday, November 12, 2009 10:40 AM To: arslist@ARSLIST.O

Re: Java API - parseQualification Error - Part 2

> For anyone interested (part 2 of 2)... > > Secondary response from support (it doesn't error as before): > > Sample API program that works for me.. customer will need to change > the details marked with a " <--" for his test.. > > import com.bmc.arsys.api.*; > import java.util.*; > > pub

Re: Java API - parseQualification Error - Part 1

> For anyone interested (part 1 of 2)... > > From support: > We've tested this issue internally using both 7.1 and 7.5 API. It > looks like there is a defect in the API on how it handles the negative > value. Strangely enough the Mid Tier is able to process the request > with no problems. > >

Fast export utility?

I've downloaded the Fast export utility from Gidd's site. Has anyone had success with this? I have no idea what the prerequisites are and/or what all needs to be configured prior to using this. The documentation is apparently loaded in an .exe file which I can not get to run. William Rentfrow

Re: SLA re-attached

That depends what version of SLM you are using. The 7.1 version has options to allow targets to restart/reopen. 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 by an authorized State O

Re: WWRUG ARSLIST Awards

I think LJ has a 10 or 12 post head start on next year already :-) Doug -- Doug Blair Sent from my iPhone, typographic errors likely +1-224-558-5462 On Nov 12, 2009, at 8:35 AM, "Shellman, David" > wrote: New. Much was because it showed up with a typo as Longwin. Dave -

Re: E-mail engine - incredibly sensitive to formatting?

Fred/Patrick, We moved from a windows install to solaris quite a while back and somewhat surprised we've ever had e-mail going out to multiple recipients then! Will add a filter to the form asap - many thanks. Regards Dave -Original Message- From: Action Requ

Re: WWRUG ARSLIST Awards

New. Much was because it showed up with a typo as Longwin. Dave - dave.shell...@tycoelectronics.com (Wireless) - Original Message - From: Action Request System discussion list(ARSList) To: arslist@ARSLIST.ORG Sent: Thu Nov 12 11:11:00 2009 Subject: Re: WWRUG ARSL

AW: Connection timed out. Message number = 90 in ars 5.1

I would suggest to use driver to check if you can connect to the arserver. here's a sample driver session. Things that I typed in are marked red arad...@affhc126:/mnt/mnt1/arsbin/IN2ARIM1> /apps/ars/ars512p1494/api/src/driver/driver AR System API Driver Active Link Escalation F

Re: Connection timed out. Message number = 90 in ars 5.1

I saw a post yesterday discussing port mapper that suggested it's port 111 _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Llinares, Jordi Sent: Thursday, November 12, 2009 7:54 AM To: arslist@ARSLIST.ORG Subject: Re: Connection timed out.

Re: Process Timeout Limit v7x

I have a filter api timeout (web services) that I've had to increase in the past, but never been able to get the set fields process higher. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Craig Carter Sent: Thursday, Novemb

Re: E-mail engine - incredibly sensitive to formatting?

IT is not an IEEE standard.. I had issues with this Years ago.. ; is a microsoft thing, they snuck it in.. On Thu, Nov 12, 2009 at 11:05 AM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > ** > > Dave, > > > > I’m on Solaris and I have never been able to send emails using semi-colons >

Re: WWRUG ARSLIST Awards

New or old?and 350?...that's almost a post a day for the entire year -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jason Miller Sent: Wednesday, November 11, 2009 3:58 PM To: arslist@ARSLIST.ORG Subject: Re: WWRUG

Re: E-mail engine - incredibly sensitive to formatting?

Dave, I'm on Solaris and I have never been able to send emails using semi-colons (currently on 7.1.0). The internet standards say to use a comma between the addresses (Outlook is the only app I know of to use the semi-colon and if you look at the internet headers in Outlook you see it uses a c

Re: WWRUG ARSLIST Awards

Michael, You're right, of course. Dan looked for the NZ person first. There were a few small technical glitches in the ARSLIST Awards event, and the potential for distraction (and catastrophic sugar rush) was great. The Jet Lag Award might depend on which direction you flew We'll just

Re: WWRUG ARSLIST Awards

Normally, I loathe "me too's", especially to a list server, but on this occasion I'll add my "Me too!" Congratualations Dr. Christopher Strauss, your countless, detailed and thoughtful posts have helped many of us that gather perls of knowledge from this ARList oyster bed, often without posti

Re: WWRUG ARSLIST Awards

Congratulations to all winners -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Frank, Gordon M. (CMS/CTR) Sent: Thursday, November 12, 2009 7:44 AM To: arslist@ARSLIST.ORG Subject: Re: WWRUG ARSLIST Awards I am so glad to

Re: Connection timed out. Message number = 90 in ars 5.1

Hi Ben, When I telnet I use 3 port which is actually the default one. When I have tried in windows like in linux, I do not specify any port, I type netstat -an and I see 3 port. I have set ARTCPPORT=3 and it doesn't work. I'm gonna look for that thread, if you find it, please, post

Re: Q: Process Timeout Limit v7x

Hi Axton, This process has to succeed at some point and the agents want to complete the case at the time they push the button--not come back later. They are processing hundreds of cases and cannot afford to reopen these to see if it worked, try again if it didn't work, etc. We may have to ree

Re: Process Timeout Limit v7x

The problem is that we are transmitting data to an external service and the agent is waiting for a successful response from that service to proceed and complete that case--they don't want to have to come back to it later and it's important this data get where it needs to go. We're already looki

Re: E-mail engine - incredibly sensitive to formatting?

I always comma separate email addresses and I have never had an issue, never had any luck with semicolons. Running ARS 7.1 patch 007 on Windows 2003. Sincerely, Robert Fults Remedy Dev Florida International University From: Barber, David [mailto:david.bar...@cw.com] Sent: Tuesday, November 10,

Re: Published Webservice not returning results

(SOLVED) Eric Sheer genius mate. Went back and double checked, and found that the patch info that was provided to me was not correct. The actual versions were Mid-tier Version :: 7.0.01 200609271856 Server Version :: 7.0.01 200712062121 Downloaded and installed the new mid-tier patch 6

Re: WWRUG ARSLIST Awards

I am so glad to hear that Chris Strauss finally won the MVP award. This was long overdue. Congratulations on the award and I wish I could be there to buy you a beer! Of course Vegas is not known for its Northern Texas beer. Gordon M. Frank Lockheed Martin -Original Message- From: Acti

Re: Import Tool Version 7.1 p7

I'm only merging into the underlying form, not the join form. But this is interested information! Lisa From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ben Chernys Sent: Wednesday, November 11, 2009 4:03 PM To: a

Re: Connection timed out. Message number = 90 in ars 5.1

When you telnet, what port did you specify? Looks like you do have a port set on your ARS server. Port Mapper goes though a special UDP port. Don't know which but I think there was a thread here about that recently. If your ARS server has a specific port set, use it (with export ARTCPPORT=xxx)

Re: Connection timed out. Message number = 90 in ars 5.1

Hi Ben, The libraries are the same version I use in windows, 5.1 but for linux. The files are named arapicmd.log and arapires.log and they don't give us any important message. The message I gave in the other mail was the java stack. However, I can access to the server using telnet [ip-direction

Re: 6.0->7.1 upgrade many columns missing from T509 (User)?

1. Wondering if you can upgrade from 6.0 to 7.1 without applying 6.3. We went from 6.3 to 7.1 and it worked. 2. Take a look at your install log files, specifcally the ones that detail with the SQL that runs, and see if you see any issues. On Thu, Nov 12, 2009 at 3:33 PM, R. Alan Monroe wrote:

6.0->7.1 upgrade many columns missing from T509 (User)?

Has anyone else experienced this? I tried a 6.0->7.1 upgrade on a test server that _appeared_ to work, but afterwards, many columns are missing from T509 (User) (and perhaps other forms, but there's no convenient way to test exhaustively). We can open the User form in both the Admin tool and User

Re: Connection timed out. Message number = 90 in ars 5.1

The grep was for ARTCPPORT; the library being incorrect (version) can cause this error. You should have two files from the tracing. I only see the one. check that you can ping the ARS server from the linux box using the exact same string as in your code. Cheers Ben _ From: Action R

Re: Connection timed out. Message number = 90 in ars 5.1

The library is available. The problem, I think, is related with the connection of this library with the server. We have made the trace, and the jar is connecting to the .so. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Beh

Email engine

Hi, I have an ars 6.3 with it's own email engine running on a Win2003Server. On the same serve I want to install Ars7.3 and it's own email engine. I don't want email 7.3 to upgrade email 6.3, but I want to preserve both. So my questions: - Which is the best way to install the second email engine? -

Re: Connection timed out. Message number = 90 in ars 5.1

Hi Ben, I have checked whether Linux box is behind a different firewall than the Windows box and it's not. I have tried either the "set | grep 3" or "netstat -an | grep 3" commands, and I get nothing. However, I have set ARAPILOGGING=1, and I get the next response: MessageText: Cannot

Re: Connection timed out. Message number = 90 in ars 5.1

Nope. Make sure the Linux box is not behind a different firewall than the Windows box. Make sure also that a port is NOT set in the Linux box with the set | grep. Otherwise, turn the logging on with the export ARAPILOGGING=1 before you run your app and your will have two files in the current dir

Re: Connection timed out. Message number = 90 in ars 5.1

** I think, you could use the strace command for testing your code.If a library could not be found, the strace command will tell you !Tristan _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_

Re: WWRUG ARSLIST Awards

Doug, Don't like to correct, but as I received the Jet Lag award, even if the guy from New Zealand was there I would still have won as NZ is closer to the US than Australia. Regards Michael Poole -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@ars

Re: Connection timed out. Message number = 90 in ars 5.1

Hi Ben, Neither I set the port in the code, nor in an environment variable. If I connect to it in windows and I type in the cmd netstat -an I can see the port which is connecting is 3. Do I have to set this environment variable? Thanks so much for your suppport, Jordi -Original Messag

SSO in WUT.

Hi all!!! Our customer can see that if he is into Remedy SRM and goes to another URL without closing the Remedy session, if he goes again to the SRM page he notices that he doesn't need to log again. I need that when I'm logged in Remedy and through the SRM I open an URL which needs the same auth

Re: Connection timed out. Message number = 90 in ars 5.1

Are you using port mapper? If not then either your code sets the port (after init before any other calls) or you have ARTSPPORT set in your environment. Check that on Windows (set | find ARTCP) and Linux (set | grep ARTCP). Else set client API tracing on with ARAPILOGGING=1 (use export on Linu

Re: Connection timed out. Message number = 90 in ars 5.1

I'm using 5.1 version of both ARS server and, of course, the java API. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: miércoles, 11 de noviembre de 2009 19:20 To: arslist@ARSLIST.ORG Subject: Re: Connecti

Re: WWRUG 2009

Just to share the my last few tweets about Evening with Engineering and Friends for those who can't get to twitter. What a great night! 1. [image: Default_profile_1_normal] jas0nmiller It was great to complement/thank the people who made many 7.5 features hap