Re : database restore

2012-02-23 Thread Frex Popo
Thanks.   The OS for both oracle databases is unix. but one server is installed on unix and the other on windows.      De : Roger Justice rjust2...@aol.com À : arslist@ARSLIST.ORG Envoyé le : Mardi 21 février 2012 19h44 Objet : Re: database restore ** The

Re : database restore

2012-02-23 Thread Frex Popo
Thanks Fred. Both databases are on solaris. De : Grooms, Frederick W frederick.w.gro...@xo.com À : arslist@ARSLIST.ORG Envoyé le : Mardi 21 février 2012 19h48 Objet : Re: database restore Depends on what Unix? A database running on Solaris

Re: Question:What is the best way to migrate data,def, config?

2012-02-23 Thread Misi Mladoniczky
Hi, I recommend using ARAdmin/DevStudio to import definitions, except the system forms. You have to find out what kind of modification you have done to these. Typical changes might be permission changes on the User form etc. Apply these changes manually to the new server. I have a tool that can

Re: Job opportunities for foreigners

2012-02-23 Thread Elry
Jose... Come to Canada buddy. Lots of work in Vancouver, Toronto, and Montreal. Canada is always looking for technical professionals. On Feb 23, 1:31 am, Jose Huerta jose.hue...@sm2baleares.es wrote: Hi all, Thank you for your answers (including the ones from people that reply me

Re: Job opportunities for foreigners

2012-02-23 Thread Bajwa, Ibrar
I concur! Ibrar Bajwa Remedy Analyst Brookfield Corporate Operations Technology Services 1 Adelaide Street East, Suite 1400, Toronto, ON M5C 2V9 T 416.649.8249, F 416.649.8245 ibrar.ba...@brookfield.com View important disclosures and information about our e-mail policies

Re: Create a View form of a remote oracle DB on ARSystem (MS SQL)

2012-02-23 Thread Reiser, John J
Mark and Fred, Back from vacation and back into the remote issue. I created a simple test view in the MS SQL database ARSystem using the following syntax SELECT CAST(CONTROL_UNIQUE_ID AS int) AS UNIQUE_ID, CAST(CONTROL_NUM AS varchar) AS Control_Num, CAST(PLANT_CODE AS varchar)

Re: Remedy on Demand question

2012-02-23 Thread Easter, David
Hi David, Remedy OnDemand has an option where you can set up an additional reporting server to run reports from, for example, BMC Analytics (as a service). Best to contact your BMC sales representative for information on the best configuration option for your business needs. -David J.

7.6.04 sp2 midtier problems

2012-02-23 Thread patrick zandi
Symptoms: tomcat crashes, *CATALINA.OUT:::* - Connects to HOSTNAME: through *Java Rpc failed *with: ERROR (90): Cannot establish a network connection to the AR System server; Connection HOSTNAME: ERROR (90): Cannot establish a network connection to the AR System server; Connection

Re: Remedy on Demand question

2012-02-23 Thread John Sundberg
I have heard rumblings of a PAAS -- Platform As A Service. Where -- you can get raw Remedy and skip the ITSM --- is this true? From my experience -- this could be quite nice... As -- you REALLY REALLY REALLY REALLY REALLY (^ 1000) don't want to touch a machine if ITSM is on it. Yet - business

Re: Remedy on Demand question

2012-02-23 Thread David Ferguson
Thanks David, how would I access that reporting server from my network? VPN access and then ODBC, secure ODBC, etc? What is the method of connectivity I would have to access the data for querying at the reporting server database level? thanks, David On Thu, Feb 23, 2012 at 10:38 AM, Easter,

Re: OLE Integration

2012-02-23 Thread Pierson, Shawn
If you get them to go to the Mid-Tier and use Firefox for their browser (Firefox is supported by BMC) then they have instant spell check technology available, and when they are forced to upgrade they won't have to deal with different User Tool versions or support issues. Thanks, Shawn Pierson

Not Matching Lengths

2012-02-23 Thread LJ LongWing
List, Our Dev server started crashing a few days ago and we had a VERY hard time trying to identify the cause. After several days of trial and error, one of the developers on the team noticed that a field length in the DB was not the same as a field length in Remedy. After further

Re: Not Matching Lengths

2012-02-23 Thread pascale . sterrett
Seeing the same issue on all 9 servers. This is from one of them AR System Email User Instruction Templates Short Description 60 254 AR System Email Templates Short Description 60 254 AR System Email MessagesShort Description 60 254 AR System Email

Re: Remedy on Demand question

2012-02-23 Thread Easter, David
There are multiple ways that customers gain access to the resources within Remedy OnDemand and your BMC representative can work with you to tailor the offering to your needs. VPN is a common way to create a secure link between a customer datacenter and resources within the Remedy OnDemand

Re: Not Matching Lengths

2012-02-23 Thread Andrew C Goodall
I ran the query and returned 878 rows. I'm not too concerned with the ones where the RemedyMaxLength is smaller than the DBMaxlength, but I am concerned about the ones where the DBMaxlength is less than the RemedyMaxLength - it's those that could cause fatal errors / crashes. I modified your

Re: 7.6.04 sp2 midtier problems

2012-02-23 Thread Terje Moglestue
Patrick I think you are into something here. We got a few unexplainable crashes. We have not had time to look into them in more details. Your findings sounds identical to what I have seen. I do think we at sporadic random got DNS issues for some of our remote users. If your findings are

Re: Remedy on Demand question

2012-02-23 Thread Easter, David
At this time, a way to accomplish having just AR System loaded into a cloud-based environment would be to form a relationship with a cloud-services vendor like Amazon. They can provide the OS and DB environment where you can then load whatever software that you are currently entitled to -

Re: Not Matching Lengths

2012-02-23 Thread pascale . sterrett
I did not post the customized ones. But I do see the majorities of those are also from Join forms. But on a particular prod server I end up with over 600 mismatch. And almost half have the DB size smaller then Remedy. I will have to keep an eye on those... As if we didn't have enough on

Re: ARS 7.5 patch 008 download (was RE: Approval Engine Issues)

2012-02-23 Thread Easter, David
The current vision within BMC is to utilize the EPD for any new patches moving forward. It is still being decided whether to retain the Heritage site for legacy purposes. So yes, to be assured of finding the latest patches, one should go to the EPD at this time. -David J. Easter Manager of

Re: Not Matching Lengths

2012-02-23 Thread LJ LongWing
I don’t want to be an alarmist…in fact, I try hard not to be….but wouldn’t we all expect that Remedy is properly keeping the DB length ‘the same’ as what Remedy expects it to be?I certainly would at least. Would anyone else consider this a bug? From: Action Request System discussion

Re: Not Matching Lengths

2012-02-23 Thread LJ LongWing
Those would be of upmost concern to me.because if Remedy thinks it can insert 200 chars, but the DB can only handle 150.that'll cause issues. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew C Goodall Sent: Thursday, February 23, 2012 10:40

Re: Kinetic products / ARInside

2012-02-23 Thread Misi Mladoniczky
Hi John, If I get a 1:1 ratio between ACTLs and FLTRs after an implementation, I am satisfied. If I get more ACTLs than FLTRs, I have succumbed too much to the detailed demands of the end users ;-) Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR

Re: Kinetic products / ARInside

2012-02-23 Thread Jose Huerta
It's not succumbing, it's satisfaying! :) Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca

Re: Not Matching Lengths

2012-02-23 Thread Danaceau, Chris (CONTR)
LJ from your results below it looks like for the fields in question the database is allocating the max length for the data type it associates with the field. The question is either 1) Why is that done for these particular fields or 2) Why is it not done for ALL fields? -- Chris Danaceau

Re: Not Matching Lengths

2012-02-23 Thread JD Hood
On a 7.6.04p2 ITSM Pre-Config Stack Installer environment (MS SQLServer) There's 931 fields with different lengths. Exactly 100 of those fields have a DB length less than ARS length and a quick scan through that list looks like all of those are joins. But, no DB weirdness has manifested, so

Re: Not Matching Lengths

2012-02-23 Thread Wirasat Siddiqi
What I have noticed is that if you decrease the database length from Remedy, it does not decrease from the database. It keeps the prior length on the database. However, if you increase the size, it increases in the database. Thanks, Wirasat From: JD Hood hood...@gmail.com To:

Re: Not Matching Lengths

2012-02-23 Thread Mueller, Doug
Everyone, Just a couple of comments on this thread (including lots of comments that have come in over the past few hours). First, it is not a surprise to us that there are differences in lengths in the DB and in the Remedy length under some conditions. This is actually a designed behavior of

Re: Kinetic products / ARInside

2012-02-23 Thread Axton
Yep, satisfying just like that last cigarette I had. No succumbing involved. On Thu, Feb 23, 2012 at 12:33 PM, Jose Huerta jose.hue...@sm2baleares.eswrote: ** It's not succumbing, it's satisfaying! :) Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971

Re: Not Matching Lengths

2012-02-23 Thread Jose Huerta
That's a good answer! Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca

GIS and Atrium CMDB

2012-02-23 Thread Jose Huerta
One customer demands us to geo-localize the CI. The idea is to upload the maps of their offices and show the CI's on the map. He has a WiFi network capable of localizing the wireless assets. We also now, from the switches where each device is connected. So all this information could be in the CMDB

Re: Not Matching Lengths

2012-02-23 Thread Tommy Morris
So are most of you seeing this on join forms? Just curious, we ran into a problem with form corruption a while back when we imported a join form from one environment to another. It was enough corruption that it required a complete DB restore to correct the issue. We have since just adopted a

Re: Not Matching Lengths

2012-02-23 Thread John Sundberg
Good answer… A takeaway from this is - database restructuring is to be avoided, unless necessary. (Which I 100% agree - especially for a production system) -John On Thu, Feb 23, 2012 at 1:46 PM, Mueller, Doug doug_muel...@bmc.com wrote: Everyone, Just a couple of comments on this thread

Re: Not Matching Lengths

2012-02-23 Thread pascale . sterrett
In our case, yes, the majority are from Join forms. But we still have a lot of those fields that are on regular forms with the DB length being smaller then the Remedy length. I do not recall any issues (yet), but as someone else said, it is something to keep in mind in case we do encounter an

Re: GIS and Atrium CMDB

2012-02-23 Thread John Sundberg
Great minds think alike… :) I was poking around with this concept this morning. This was helpful to me… http://radar.oreilly.com/2012/02/how-to-create-visualization-facebook-vacation.html?google_editors_picks=true -John On Thu, Feb 23, 2012 at 2:16 PM, Jose Huerta

Re: Not Matching Lengths (server hang)

2012-02-23 Thread LJ LongWing
Dougthat does make sense...thank you for the in depth analysislet me ask you this question. I was going through my system doing performance tuning. I found a situation where a Web Service was creating records on output of the call... I make a call to WS and it returns a result to form

Re: Kinetic products / ARInside

2012-02-23 Thread Jason Miller
John did say that much of the Kinetic products are written in Java so I am figuring many of the ACTLs are for UI and much of the processing that filters would do in a pure Remedy app are done by the Java instead. Jason On Thu, Feb 23, 2012 at 10:16 AM, Misi Mladoniczky m...@rrr.se wrote: Hi

Re: GIS and Atrium CMDB

2012-02-23 Thread Jose Huerta
My idea is to load a custom image like in the next example: http://econym.org.uk/gmap/example_custommap1.htm Then create custom markers for any type of CI and load the map. The balloon of the mark can show the name of the CI and an hyperlink to the Asset form. Jose M. Huerta Project Manager**

SLM error's out during the copy mode

2012-02-23 Thread John . Atherly
I'm trying to use the copy button in the SLM console and I keep on getting the below error. I have tried to create one manualy but also get the below error. I looked at the active link action 7 and it is doing a push to the form SLM:Clonebase but no field is set to have an unique index.

Re: GIS and Atrium CMDB

2012-02-23 Thread Pierson, Shawn
It sounds cool, but I personally would tie the lat/long coordinates to the Site record rather than each individual CI. If you were tracking things that were truly mobile such as cell phones, then it might make sense to track it on the CI level but it seems to me like it would make life easier

Re: GIS and Atrium CMDB

2012-02-23 Thread Tommy Morris
dcTracker by Raritan. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jose Huerta Sent: Thursday, February 23, 2012 2:17 PM To: arslist@ARSLIST.ORG Subject: GIS and Atrium CMDB ** One customer demands us to geo-localize the CI. The idea is to

Re: Not Matching Lengths

2012-02-23 Thread LJ LongWing
Awesome Doug...thank you for that thorough explanationbased on that, I have revised the query to be. Of which, I now 'don't see a problem' :) select a.name, f.fieldName, fc.maxLength as 'RemedyMaxLength', c.CHARACTER_MAXIMUM_LENGTH as 'DBMaxLength' from arschema a inner join field f

Remedy on Demand question

2012-02-23 Thread John Baker
Hello, David appears to have forgotten to mention SSO Plugin, the only SSO product for BMC products that's been thoroughly tested with third party SAML providers. So you can deploy SSO Plugin for RoD and integrate with your corporate authentication infrastructure for true SSO over the

Re: Kinetic products / ARInside

2012-02-23 Thread Misi Mladoniczky
Hi Jose, I am a programmer, I don't satisfy... Remedy (BMC) wrote the GUI, why should I need to add stuff to the GUI via ACTLs? The inner workings of your app is supposed to be controlled by filters and escalations, that should be enough! :-) Best Regards - Misi, RRR AB, http://rrr.se

Re: Kinetic products / ARInside

2012-02-23 Thread Jose Huerta
The users could also connect to Remedy via web service... That should be enough! I don't know why they need a GUI when all actions can be performed via web service!. Wait, Why using web services, when they can connect using the API! :) Regards, Jose M. Huerta Project Manager** Movil: 661 665

Re: Not Matching Lengths (server hang)

2012-02-23 Thread Mueller, Doug
LJ, Not sure what was causing the problem in your situation. Obviously the answer is that it could have been any number of things I just don't know what. As it was a crash, it is obviously something that the system didn't handle well. Definitely submit a bug on the issue -- indicating

Re: Kinetic products / ARInside

2012-02-23 Thread Jason Miller
Just let them work at the DB level :) On Thu, Feb 23, 2012 at 1:48 PM, Jose Huerta jose.hue...@sm2baleares.eswrote: ** The users could also connect to Remedy via web service... That should be enough! I don't know why they need a GUI when all actions can be performed via web service!. Wait,

Re: GIS and Atrium CMDB

2012-02-23 Thread Mueller, Doug
At the end of the day, there are several topics here. What is the best way to represent location in the CMDB What is the best way to display the data, select a location to say display, plot a map, something else that is about CONSUMING the location data that is in the CMDB As far as

Re: Not Matching Lengths (server hang)

2012-02-23 Thread LJ LongWing
So to restructure, I don't need to make my 'new' size larger than the current DB size, just larger than the current ar size? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug Sent: Thursday, February 23, 2012

Re: Not Matching Lengths (server hang)

2012-02-23 Thread Mueller, Doug
LJ, Correct. We don't pay attention to the current DB size, just the current AR size. So, if you make it longer than the current AR size, we will issue a restructure command to the DB. Doug -Original Message- From: Action Request System discussion list(ARSList)

Logging the contents of the XML thats sent while consuming a external web service..

2012-02-23 Thread Joe Martin D'Souza
I’m guessing Fiddler should be able to capture this? If not are there any tools I could install on the AR Server to capture the contents (exact XML that’s sent across to the provider). I tried API/Filter logging and neither does this. And the Mid Tier Web Service logging option is for web

Re: Not Matching Lengths (server hang)

2012-02-23 Thread LJ LongWing
Nike -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug Sent: Thursday, February 23, 2012 3:50 PM To: arslist@ARSLIST.ORG Subject: Re: Not Matching Lengths (server hang) LJ, Correct. We don't pay attention to

Re: Not Matching Lengths (server hang)

2012-02-23 Thread LJ LongWing
LOL...Nice -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug Sent: Thursday, February 23, 2012 3:50 PM To: arslist@ARSLIST.ORG Subject: Re: Not Matching Lengths (server hang) LJ, Correct. We don't pay

Re: GIS and Atrium CMDB

2012-02-23 Thread Jose Huerta
1.- The mobile CI's are semi-mobile I mean, they are mainly static, but the user can move it sometimes. 2.- The organization is very large (6 square km area, more than 6.000 rooms and 6.000 users). There are a lot of reason to display the CI's in a map. And also is not only about which room, but

Re: Logging the contents of the XML thats sent while consuming a external web service..

2012-02-23 Thread Grooms, Frederick W
Go into the pluginsvr directory and update the log4j_pluginsvr.xml file changing the logging level to INFO or DEBUG. You may also update the output file location Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe

Re: Logging the contents of the XML thats sent while consuming a external web service..

2012-02-23 Thread Joe Martin D'Souza
Thanks Kiran, Fred, Will do that.. Joe -Original Message- From: Grooms, Frederick W Sent: Thursday, February 23, 2012 7:02 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Logging the contents of the XML thats sent while consuming a external web

Re: Question:What is the best way to migrate data,def, config?

2012-02-23 Thread Amol Dixit
I suggest Migrator. Migrator had the capability to migrate the definations as well as data. config is nothing but data again. Also in future if you need move the deltas we have Delta Data Migrator (DDM) Amol Dixit The opinions, statements, and/or suggested courses of action expressed in this