Dave Wallace is out of the office.

[David Wallace]

I will be out of the office starting  09/28/2010 and will not return until
09/29/2010.

I will be OOO 9/28 & 9/29 (Tue & Wed).  If you need immediate assistance
then email SMT-ProdEng.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

[REMEDY 6] License Issue Date is current date

[Kali Obsum]

Hi,
 
Has anyone encountered that when you check the licenses in a server, the
issue date is the current date (date today)? Is there a mechanism that
automatically adds licenses? Also, what effect/impact does it have on
the system?
 
e.g. When we checked yesterday, Issue Date is Sept 28. When we checked
today, Issue Date is Sept 29.
 
Regards,
Kali
 

NOTICE 
The information contained in this email is confidential. If you are not the 
intended recipient, you must not disclose or use the information in this email 
in any way. If you received it in error, please tell us immediately by return 
email and delete the document.  We do not guarantee the integrity of any 
e-mails or attached files and are not responsible for any changes made to them 
by any other person.


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

OT:Re: Anyone has made use of this web based survey engine?

[Joe DeSouza]

Hi Chas,

I think I may have heard of Survey Monkey before.. I'm not intending to 
do anything with any of these at the moment but was just going through the 
features of the one I found just in case it is useful at some point. I will go 
through your suggestion too.. Thanks for that tip..

Joe
 
** 



From: "Roberts, Chas" 
To: arslist@ARSLIST.ORG
Sent: Tue, September 28, 2010 6:40:46 PM
Subject: Re: Anyone has made use of this web based survey engine?

Joe,
 
Survey Monkey is the best thing for this purpose.  It has a funny name but very 
good features and reliability, and you can use “SurveyMK.com/yoursurveycode” so 
it looks like “Survey Marketing”
 
 
 
Yours truly,
 
Charles H. Roberts, 4th  
 
 
Riverside County Information Technology
Office:  951-486-7780
   Cell:  951-840-8699
 eMail:  crobe...@riversidecountyit.org
 
 
From:Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] 
On Behalf Of Joe DeSouza
Sent: Tuesday, September 28, 2010 3:14 PM
To: arslist@ARSLIST.ORG
Subject: OT: Anyone has made use of this web based survey engine?
 
** 
http://www.esurveyspro.com/
 
I just came across it after I filled up a frequent traveler survey. It looks 
like they have a free edition too but appears like they might display 
advertisements etc on the free version..
 
Joe
 
_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_

This email is confidential and intended solely for the use of the individual(s) 
to whom it is addressed. The information contained in this message may be 
privileged and confidential and protected from disclosure.

If you are not the author's intended recipient, be advised that you have 
received this email in error and that any use, dissemination, forwarding, 
printing, or copying of this email is strictly prohibited. If you have received 
this email in error please delete all copies, both electronic and printed, and 
contact the author immediately.




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: Anyone has made use of this web based survey engine?

[Roberts, Chas]

Joe,

Survey Monkey is the best thing for this purpose.  It has a funny name but very 
good features and reliability, and you can use "SurveyMK.com/yoursurveycode" so 
it looks like "Survey Marketing"



Yours truly,

Charles H. Roberts, 4th


Riverside County Information Technology
Office:  951-486-7780
   Cell:  951-840-8699
 eMail:  crobe...@riversidecountyit.org


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza
Sent: Tuesday, September 28, 2010 3:14 PM
To: arslist@ARSLIST.ORG
Subject: OT: Anyone has made use of this web based survey engine?

**
http://www.esurveyspro.com

I just came across it after I filled up a frequent traveler survey. It looks 
like they have a free edition too but appears like they might display 
advertisements etc on the free version..

Joe

_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_


This email is confidential and intended solely for the use of the individual(s) 
to whom it is addressed. The information contained in this message may be 
privileged and confidential and protected from disclosure.

If you are not the author's intended recipient, be advised that you have 
received this email in error and that any use, dissemination, forwarding, 
printing, or copying of this email is strictly prohibited. If you have received 
this email in error please delete all copies, both electronic and printed, and 
contact the author immediately.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

OT: Anyone has made use of this web based survey engine?

[Joe DeSouza]

http://www.esurveyspro.com

I just came across it after I filled up a frequent traveler survey. It looks 
like they have a free edition too but appears like they might display 
advertisements etc on the free version..

Joe



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
  

Re: [REMEDY 6] ARDSERR 8747

[LJ LongWing]

Ah...all you need to know is howgranted I'm still running 32 Bit...I can 
readily cause my application to have Malloc errors...I've become quite an 
expert on it in fact...I've needed to re-design my application several times to 
avoid it...:)

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky
Sent: Tuesday, September 28, 2010 1:28 PM
To: arslist@ARSLIST.ORG
Subject: Re: [REMEDY 6] ARDSERR 8747

Hi,

At least not that many words ;-)

Sure, but I think it is kind of uncommon to get malloc failiures. At least
in 64-bit systems. A malloc failiure usually indicates some kind of memory
leak inside the application in question.

Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.

> Sure it does...it specifies that it's an OS level error...similar to a
> MALLOC...so you need to look at your environment, instead of inside remedy
> :)
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky
> Sent: Tuesday, September 28, 2010 11:04 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: [REMEDY 6] ARDSERR 8747
>
> Hi,
>
> The complete description doesn't say that much...
>
> http://rrr.se/cgi/arerrr?n=8747
>
> I think you may have to turn on some additional logging to get to the
> bottom of this.
>
> Best Regards - Misi, RRR AB, http://www.rrr.se
>
> Products from RRR Scandinavia:
> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
> Find these products, and many free tools and utilities, at http://rrr.se.
>
>> This looks like a DSO error. The DS stands for Distributed Server..
>>
>> Import the AR System Error Messages form, from the def file found in the
>> help subdirectory of the AR Server installation directory of the AR
>> Server.
>> This directory will also have arx files to import. Import these files
>> into
>> the AR System Error Messages form after importing the form.
>>
>> You will then be able to browse for error 8747 to see its complete
>> description. I do not have a ready installation right now or I'd do it
>> for
>> you.
>>
>> Hope this helps.
>>
>> Cheers
>>
>> Joe
>>   -Original Message-
>>   From: Action Request System discussion list(ARSList)
>> [mailto:arsl...@arslist.org]on Behalf Of Kali Obsum
>>   Sent: Tuesday, September 28, 2010 6:19 AM
>>   To: arslist@ARSLIST.ORG
>>   Subject: [REMEDY 6] ARDSERR 8747
>>
>>
>>   **
>>   Hi,
>>
>>   Anyone knows about this error: ARDSERR 8747
>>
>>   Regards,
>>   Kali
>>
>>   NOTICE
>>
>>   The information contained in this email is confidential. If you are
>> not
>> the intended recipient, you must not disclose or use the information in
>> this
>> email in any way. If you received it in error, please tell us
>> immediately
>> by
>> return email and delete the document. We do not guarantee the integrity
>> of
>> any e-mails or attached files and are not responsible for any changes
>> made
>> to them by any other person.
>>
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>>
>> --
>> This message was scanned by ESVA and is believed to be clean.
>>
>>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Remedy Developer/Admin Opening in Washington D.C.

[Moe Elnabawi]

All,

 

Not sure if this is appropriate, but my company is looking for a Remedy 
Developer/Admin.  I figured that some of you might be interested.  

 

If any of you would be interested, feel free to send me an updated resume.  If 
you prefer, you can call me at 703-256-2000.

 

- Moe

 

Washington D.C.

 


Highly visible position where you will maintain Remedy applications in Windows 
2000/XP/2008/Vista environment, providing support and applications 
administration that encompasses Helpdesk, SLA, CMDB, Multi-tenancy, Asset 
Management, Change Management, Dashboards, Mid-tier, Web Services, Java API and 
Migrator, Crystal Reports and other Remedy applications for our government 
client. You will be tasked with identifying, assessing, and evaluating 
moderately complex product/service solutions requiring a blend of strong sales, 
marketing and technical skills. You will take the lead on coordinating 
resolution of product/service issues, upgrades, and problems. You will interact 
with management at customer site to assess major business processes and address 
product/service needs. This position will also offer training opportunities on 
the latest versions and capabilities of BMC Remedy. 

Position Requirements:
- Bachelor’s degree (in Computer Science, Information Systems, Engineering or 
related field) or equivalent training and certifications plus nine years of 
related experience
- Must possess strong knowledge and experience in Remedy versions 6.x in a 
Windows and SQL environment
- Able to install or upgrade Remedy out of the box, including 
server/applications like Help Desk, SLA, CMDB, Asset Management, and 
configuration of these applications as required
- Able to maintain BMC software and apply BMC Remedy Patches
- Able to apply, release, and maintain licenses
- Able to develop work flows to enforce business practices and industry best 
practices in IT service management.
- Possess an in-depth knowledge of design, configuration and testing of Remedy 
Applications on 6.x
- Working knowledge of Remedy Migrator
- Proficient with Crystal Reports creation, development, Enterprise services, 
and SQL and store procedures
- Knowledgeable in system documentation and must be able to conduct user 
training in all aspects of the Remedy application
-Working Knowledge of Remedy 7.x, Web Services, Java API, Change management, 
Dashboards a plus but not required.

 





Moe Elnabawi


Applications Delivery Lead


APEX Systems, Inc.
3190 Fairview Park Dr.


Suite
 200


Falls Church
, VA 22042


Office: (703) 256-2000 


Toll Free: (888) 242-1515 



Fax: (703) 842-8275


maelnab...@apexsystemsinc.com


www.apexsystemsinc.com 



















 

 



  






 

-Original Message-
From:Misi Mladoniczky m...@rrr.se 
To: "arslist@ARSLIST.ORG" ;
Sent: Sep 28, 2010 03:29:00 PM
Subject: Re: [REMEDY 6] ARDSERR 8747

Hi, 

At least not that many words ;-) 

Sure, but I think it is kind of uncommon to get malloc failiures. At least 
in 64-bit systems. A malloc failiure usually indicates some kind of memory 
leak inside the application in question. 

Best Regards - Misi, RRR AB, http://www.rrr.se 

Products from RRR Scandinavia: 
* RRR|License - Not enough Remedy licenses? Save money by optimizing. 
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. 
Find these products, and many free tools and utilities, at http://rrr.se. 

> Sure it does...it specifies that it's an OS level error...similar to a 
> MALLOC...so you need to look at your environment, instead of inside remedy 
> :) 
> 
> -Original Message- 
> From: Action Request System discussion list(ARSList) 
> [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky 
> Sent: Tuesday, September 28, 2010 11:04 AM 
> To: arslist@ARSLIST.ORG 
> Subject: Re: [REMEDY 6] ARDSERR 8747 
> 
> Hi, 
> 
> The complete description doesn't say that much... 
> 
> http://rrr.se/cgi/arerrr?n=8747 
> 
> I think you may have to turn on some additional logging to get to the 
> bottom of this. 
> 
> Best Regards - Misi, RRR AB, http://www.rrr.se 
> 
> Products from RRR Scandinavia: 
> * RRR|License - Not enough Remedy licenses? Save money by optimizing. 
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. 
> Find these products, and many free tools and utilities, at http://rrr.se. 
> 
>> This looks like a DSO error. The DS stands for Distributed Server.. 
>> 
>> Import the AR System Error Messages form, from the def file found in the 
>> help subdirectory of the AR Server installation directory of the AR 
>> Server. 
>> This directory will also have arx files to import. Import these files 
>> into 
>> the AR System Error Messages form after importing the form. 
>> 
>> You will then be able to browse for error 8747 to see its complete 
>> description. I do not have a ready installation right now or I'd do it 
>> for 
>> you. 
>> 
>> Hope this helps. 
>> 
>> Cheers 
>> 
>> Joe 
>> -Original Message- 
>> From: Ac

Re: [REMEDY 6] ARDSERR 8747

[Misi Mladoniczky]

Hi,

At least not that many words ;-)

Sure, but I think it is kind of uncommon to get malloc failiures. At least
in 64-bit systems. A malloc failiure usually indicates some kind of memory
leak inside the application in question.

Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.

> Sure it does...it specifies that it's an OS level error...similar to a
> MALLOC...so you need to look at your environment, instead of inside remedy
> :)
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky
> Sent: Tuesday, September 28, 2010 11:04 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: [REMEDY 6] ARDSERR 8747
>
> Hi,
>
> The complete description doesn't say that much...
>
> http://rrr.se/cgi/arerrr?n=8747
>
> I think you may have to turn on some additional logging to get to the
> bottom of this.
>
> Best Regards - Misi, RRR AB, http://www.rrr.se
>
> Products from RRR Scandinavia:
> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
> Find these products, and many free tools and utilities, at http://rrr.se.
>
>> This looks like a DSO error. The DS stands for Distributed Server..
>>
>> Import the AR System Error Messages form, from the def file found in the
>> help subdirectory of the AR Server installation directory of the AR
>> Server.
>> This directory will also have arx files to import. Import these files
>> into
>> the AR System Error Messages form after importing the form.
>>
>> You will then be able to browse for error 8747 to see its complete
>> description. I do not have a ready installation right now or I'd do it
>> for
>> you.
>>
>> Hope this helps.
>>
>> Cheers
>>
>> Joe
>>   -Original Message-
>>   From: Action Request System discussion list(ARSList)
>> [mailto:arsl...@arslist.org]on Behalf Of Kali Obsum
>>   Sent: Tuesday, September 28, 2010 6:19 AM
>>   To: arslist@ARSLIST.ORG
>>   Subject: [REMEDY 6] ARDSERR 8747
>>
>>
>>   **
>>   Hi,
>>
>>   Anyone knows about this error: ARDSERR 8747
>>
>>   Regards,
>>   Kali
>>
>>   NOTICE
>>
>>   The information contained in this email is confidential. If you are
>> not
>> the intended recipient, you must not disclose or use the information in
>> this
>> email in any way. If you received it in error, please tell us
>> immediately
>> by
>> return email and delete the document. We do not guarantee the integrity
>> of
>> any e-mails or attached files and are not responsible for any changes
>> made
>> to them by any other person.
>>
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>>
>> --
>> This message was scanned by ESVA and is believed to be clean.
>>
>>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: [REMEDY 6] ARDSERR 8747

[LJ LongWing]

Sure it does...it specifies that it's an OS level error...similar to a 
MALLOC...so you need to look at your environment, instead of inside remedy :)

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Misi Mladoniczky
Sent: Tuesday, September 28, 2010 11:04 AM
To: arslist@ARSLIST.ORG
Subject: Re: [REMEDY 6] ARDSERR 8747

Hi,

The complete description doesn't say that much...

http://rrr.se/cgi/arerrr?n=8747

I think you may have to turn on some additional logging to get to the
bottom of this.

Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.

> This looks like a DSO error. The DS stands for Distributed Server..
>
> Import the AR System Error Messages form, from the def file found in the
> help subdirectory of the AR Server installation directory of the AR
> Server.
> This directory will also have arx files to import. Import these files into
> the AR System Error Messages form after importing the form.
>
> You will then be able to browse for error 8747 to see its complete
> description. I do not have a ready installation right now or I'd do it for
> you.
>
> Hope this helps.
>
> Cheers
>
> Joe
>   -Original Message-
>   From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org]on Behalf Of Kali Obsum
>   Sent: Tuesday, September 28, 2010 6:19 AM
>   To: arslist@ARSLIST.ORG
>   Subject: [REMEDY 6] ARDSERR 8747
>
>
>   **
>   Hi,
>
>   Anyone knows about this error: ARDSERR 8747
>
>   Regards,
>   Kali
>
>   NOTICE
>
>   The information contained in this email is confidential. If you are not
> the intended recipient, you must not disclose or use the information in
> this
> email in any way. If you received it in error, please tell us immediately
> by
> return email and delete the document. We do not guarantee the integrity of
> any e-mails or attached files and are not responsible for any changes made
> to them by any other person.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: Set Fields from SQL

[Matthew Perrault]

Thanks Doug,
I tried that.
I tried a whole variety of ways of passing it through (5 different ways).
What you suggested was actually my first version of it.
But the ARS engine kept sticking an extra single quote in place causing the SQL 
query to error out.
What was strange was how it worked correctly on a patch level of 7.0 but then 
stopped working when we increased the patch level.
And we were told that the earlier version was a defect and that it had been 
fixed
Sounds like the fix was a defect
Granted that was back in the 7.0 ARS version, so it may be different now.

Thanks,
Matt

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Mueller, Doug
Sent: Monday, September 27, 2010 2:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: Set Fields from SQL

Matthew,

OR, you just have the SQL command defined like

$WHERE_CLAUSE$

and then when you finish building your WHERE clause like you are today, you
simply set the WHERE_CLAUSE field to

"SELECT C1 FROM T1 WHERE " + $WHERE_CLAUSE$

and then you own and control the entire syntax of the SQL yourself, you have
built the command you want.  And you execute it.

The issue is a matter of having the system protect you and do all the handling
of protecting quotes in values  (like if the name being substituted was
o'malley) or one where you want to take all responsibility for formatting and
making sure the command is right.

We support either option.

You don't have to go the direction of putting the clause in a table and using
a stored procedure.  You can just build the entire command yourself instead of
building just 1/2 of it.

Just another option that is a bit simpler and more efficient.

Doug Mueller 

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Matthew Perrault
Sent: Monday, September 27, 2010 11:42 AM
To: arslist@ARSLIST.ORG
Subject: Re: Set Fields from SQL

The only issue I have with this,
Is I have a filter that has a Direct SQL action.
In it I specify the SQL command like:
SELECT C1 FROM T1 Where '$WHERE_CLAUSE$'

I dynamically build the where clause and set it into that field.
So I have something like Name = 'shmoe' and eye_color = 'Blue'
Unfortunately the ARS engine comments out the 'shmoe' and 'Blue'
To look like ''shmoe'' and ''Blue''
This then causes the SQL to fail.

What I was forced to do was drop the Where Clause into a SQL table,
Build the SELECT statement through a Stored Procedure using an EXEC statement.

It works but it was a cludgy way of doing things.
I would love for on the DIRECT SQL action, a check box to say turn off 
Commentation,
So that it won't add those extra quotes.

I did submit a request, but of course BMC just rejected it.
Thanks guys

Matt P.
-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF ABW 72 
ABW/SCOOA
Sent: Monday, September 27, 2010 12:32 PM
To: arslist@ARSLIST.ORG
Subject: Re: Set Fields from SQL

Roy, if you have more information on this, you can look up 'SQL
Injection'.



Thanks,

Gary Opela, Jr.
Sr. Remedy Engineer
Avaya Phone Admin
RSP Cert, Sec+
COMM: 405 582 4272


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Mueller, Doug
Sent: Monday, September 27, 2010 12:27 PM
To: arslist@ARSLIST.ORG
Subject: Re: Set Fields from SQL

Roy,

What you are seeing is what is designed.

We protect you against illegal SQL or someone trying to play with
breaking
your SQL by sticking SQL inside other SQL by properly protecting against
any
bad SQL by always quoting any text substituted into the command.  This
prevents
anyone from mis-appropriating your SQL command with bad text.

Now, you also found that we gave you an out.  If you as Administrator
make
the ENTIRE SQL command a substitution, then we give up and say you are
substituting the entire command so you must know what you are doing and
we
assume you are doing whatever protecting from bad SQL the customer may
do.



For those who wonder "what does he mean bad sql"?

What if you had a command like the following:

SELECT a FROM b WHERE ColName = '$subs parameter$'

If the user would enter

aa'; DROP TABLE xx; Select a from b where ColName = 'xyz

as the data value for subs paramter  They can "complete the
command", issue
another SQL command, and then do something so that the command is valid
again
to avoid an error.  This would allow bad SQL to be submitted by the
customer.

By always quoting and escaping any user quotes, we prevent that.

If you create the entire command yourself, you have to protect against
the
end user entering text that is like the above that could affect your SQL
command syntax


I hope this explaination helps with why the system works the way it
does.

Doug Mueller 

-Original Message-
From: Action Request System dis

Re: [REMEDY 6] ARDSERR 8747

[Misi Mladoniczky]

Hi,

The complete description doesn't say that much...

http://rrr.se/cgi/arerrr?n=8747

I think you may have to turn on some additional logging to get to the
bottom of this.

Best Regards - Misi, RRR AB, http://www.rrr.se

Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.

> This looks like a DSO error. The DS stands for Distributed Server..
>
> Import the AR System Error Messages form, from the def file found in the
> help subdirectory of the AR Server installation directory of the AR
> Server.
> This directory will also have arx files to import. Import these files into
> the AR System Error Messages form after importing the form.
>
> You will then be able to browse for error 8747 to see its complete
> description. I do not have a ready installation right now or I'd do it for
> you.
>
> Hope this helps.
>
> Cheers
>
> Joe
>   -Original Message-
>   From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org]on Behalf Of Kali Obsum
>   Sent: Tuesday, September 28, 2010 6:19 AM
>   To: arslist@ARSLIST.ORG
>   Subject: [REMEDY 6] ARDSERR 8747
>
>
>   **
>   Hi,
>
>   Anyone knows about this error: ARDSERR 8747
>
>   Regards,
>   Kali
>
>   NOTICE
>
>   The information contained in this email is confidential. If you are not
> the intended recipient, you must not disclose or use the information in
> this
> email in any way. If you received it in error, please tell us immediately
> by
> return email and delete the document. We do not guarantee the integrity of
> any e-mails or attached files and are not responsible for any changes made
> to them by any other person.
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: ITSM 7.5 or 7.6, need an instance for a demo...tomorrow

[Joe D'Souza]

One of the drawback to that as I would see is, it would be useful to only
those who own a Migrator license and use a Migrator. I would be a 'subtle'
kind of a marketing tool for the Migrator though.. I have worked with a
number of customers and through my personal experience can easily say that
maybe just about maybe 5% to 10% (10 would be too high I think) use that
tool. But then again I may have just had the fortune or misfortune of
working mostly with those that don't.. I think I may have worked with the
Migrator tool on about just 4 or 5 projects in my entire ARS life..

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of patrick zandi
  Sent: Tuesday, September 28, 2010 11:35 AM
  To: arslist@ARSLIST.ORG
  Subject: Re: ITSM 7.5 or 7.6, need an instance for a demo...tomorrow


  ** I think it would also be nice for BMC to provide a full Migrator "DEF"
of ARS Alone, ARS with Full /AIE/CMDB/ITSM suite installed, with Each
Released version for Difference reports / checking and verification of Clean
install. Huge customer benefit and BMC SALES benefit as well to purchase the
Migrator, which would in turn (prayerfully) provide a better tool.

  Just another Thought.


  On Tue, Sep 28, 2010 at 11:26 AM, Joe D'Souza  wrote:

**
I think this is a great idea too..

This won't be just useful for the purpose of demo but also for
comparisons as to how far one has deviated from the original application.
Sometimes its easy for a customer to loose visibility of where they have
gone after installing the original application while on their quest for
customizing the application to fit their needs.. If the customization has
been done really well with an eye for both functionality as well as
aesthetics, its not easy to point out what has been customized.

Another great advantage of this would be to correct some configuration
data that a customer might have accidentally modified, rendering an
application unusable or unstable.. I have noticed several requests in the
past from the ARS List from listers here who request for such information.
It would be better available to customers facing such incidents..

Such kind of demo environments for every major release that has changed
the look and feel or added functionality, would be quite useful in all these
kind of situations. A scripted import of the database, to the original
version backed up immediately after the install, could overwrite any changes
in data that customers might make during the business day.

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of patrick zandi
  Sent: Monday, September 27, 2010 1:22 PM
  To: arslist@ARSLIST.ORG

  Subject: Re: ITSM 7.5 or 7.6, need an instance for a demo...tomorrow


  ** Ya know, this brings up a thought... Dave?  do you think it is
feasible to have a couple of servers with 2 or 3 instances of the latest
version for people to Demo over the web. Seems to be this is a Sales
promotion.. Demo Lab Free for a day, then it is wiped .. After all with the
BMC Bladelogic, you should be able to schedule a provisioned install on a
small ESX server no problem, (every 3 days or something) and customers who
have access to the WEB Support can login and check it out, play, and pook
around.


  On Mon, Sep 27, 2010 at 1:07 PM, Rabi Tripathi 
wrote:

--- On
Thanks a lot! It came handy...to supplement my talking points.

--- On Thu, 9/23/10, strauss  wrote:

> From: strauss 
> Subject: Re: ITSM 7.5 or 7.6, need an instance for a
demo...tomorrow
> To: arslist@ARSLIST.ORG
> Date: Thursday, September 23, 2010, 5:56 PM

> I do have a sample data 7.6.03 system
> on a VM you could use... nothing you could hurt there.
> All of my 7.6.00 systems have been upgraded to 7.6.03 or are
> off-limits pre-production.
>
> Christopher Strauss, Ph.D.
> Call Tracking Administration Manager
> University of North Texas Computing & IT Center
> http://itsm.unt.edu/

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: Incident Management Remedy_Login_ID

[Andre Hughes]

Hi Jorge,

It may be best to modify the 2 fitlers -

CTM:PPL:LOGINCannotSubmitLogin_151_E
CTM:PPL:LOGINCannotChange_151_E

and add AND ($USER$ != "AR_ESCALATOR") to the Run If Qualification. This way
you don't need to add a bogus Remedy user account.

Andre

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: ITSM 7.5 or 7.6, need an instance for a demo...tomorrow

[patrick zandi]

I think it would also be nice for BMC to provide a full Migrator "DEF" of
ARS Alone, ARS with Full /AIE/CMDB/ITSM suite installed, with Each Released
version for Difference reports / checking and verification of Clean install.
Huge customer benefit and BMC SALES benefit as well to purchase the
Migrator, which would in turn (prayerfully) provide a better tool.

Just another Thought.

On Tue, Sep 28, 2010 at 11:26 AM, Joe D'Souza  wrote:

> **
> I think this is a great idea too..
>
> This won't be just useful for the purpose of demo but also for comparisons
> as to how far one has deviated from the original application. Sometimes its
> easy for a customer to loose visibility of where they have gone after
> installing the original application while on their quest for customizing the
> application to fit their needs.. If the customization has been done really
> well with an eye for both functionality as well as aesthetics, its not easy
> to point out what has been customized.
>
> Another great advantage of this would be to correct some configuration data
> that a customer might have accidentally modified, rendering an application
> unusable or unstable.. I have noticed several requests in the past from the
> ARS List from listers here who request for such information. It would be
> better available to customers facing such incidents..
>
> Such kind of demo environments for every major release that has changed the
> look and feel or added functionality, would be quite useful in all these
> kind of situations. A scripted import of the database, to the original
> version backed up immediately after the install, could overwrite any changes
> in data that customers might make during the business day.
>
> Joe
>
> -Original Message-
> *From:* Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org]*on Behalf Of *patrick zandi
> *Sent:* Monday, September 27, 2010 1:22 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: ITSM 7.5 or 7.6, need an instance for a demo...tomorrow
>
> ** Ya know, this brings up a thought... Dave?  do you think it is feasible
> to have a couple of servers with 2 or 3 instances of the latest version for
> people to Demo over the web. Seems to be this is a Sales promotion.. Demo
> Lab Free for a day, then it is wiped .. After all with the BMC Bladelogic,
> you should be able to schedule a provisioned install on a small ESX server
> no problem, (every 3 days or something) and customers who have access to the
> WEB Support can login and check it out, play, and pook around.
>
> On Mon, Sep 27, 2010 at 1:07 PM, Rabi Tripathi  wrote:
>
>> --- On
>> Thanks a lot! It came handy...to supplement my talking points.
>>
>> --- On Thu, 9/23/10, strauss  wrote:
>>
>> > From: strauss 
>> > Subject: Re: ITSM 7.5 or 7.6, need an instance for a demo...tomorrow
>> > To: arslist@ARSLIST.ORG
>> > Date: Thursday, September 23, 2010, 5:56 PM
>>  > I do have a sample data 7.6.03 system
>> > on a VM you could use... nothing you could hurt there.
>> > All of my 7.6.00 systems have been upgraded to 7.6.03 or are
>> > off-limits pre-production.
>> >
>> > Christopher Strauss, Ph.D.
>> > Call Tracking Administration Manager
>> > University of North Texas Computing & IT Center
>> > http://itsm.unt.edu/
>> >
>> > -Original Message-
>> > From: Action Request System discussion _attend WWRUG10 
>> > www.wwrug.comARSlist: "Where the Answers Are"_
>>
>


-- 
Patrick Zandi

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: ITSM 7.5 or 7.6, need an instance for a demo...tomorrow

[Joe D'Souza]

I think this is a great idea too..

This won't be just useful for the purpose of demo but also for comparisons
as to how far one has deviated from the original application. Sometimes its
easy for a customer to loose visibility of where they have gone after
installing the original application while on their quest for customizing the
application to fit their needs.. If the customization has been done really
well with an eye for both functionality as well as aesthetics, its not easy
to point out what has been customized.

Another great advantage of this would be to correct some configuration data
that a customer might have accidentally modified, rendering an application
unusable or unstable.. I have noticed several requests in the past from the
ARS List from listers here who request for such information. It would be
better available to customers facing such incidents..

Such kind of demo environments for every major release that has changed the
look and feel or added functionality, would be quite useful in all these
kind of situations. A scripted import of the database, to the original
version backed up immediately after the install, could overwrite any changes
in data that customers might make during the business day.

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of patrick zandi
  Sent: Monday, September 27, 2010 1:22 PM
  To: arslist@ARSLIST.ORG
  Subject: Re: ITSM 7.5 or 7.6, need an instance for a demo...tomorrow


  ** Ya know, this brings up a thought... Dave?  do you think it is feasible
to have a couple of servers with 2 or 3 instances of the latest version for
people to Demo over the web. Seems to be this is a Sales promotion.. Demo
Lab Free for a day, then it is wiped .. After all with the BMC Bladelogic,
you should be able to schedule a provisioned install on a small ESX server
no problem, (every 3 days or something) and customers who have access to the
WEB Support can login and check it out, play, and pook around.


  On Mon, Sep 27, 2010 at 1:07 PM, Rabi Tripathi  wrote:

--- On
Thanks a lot! It came handy...to supplement my talking points.

--- On Thu, 9/23/10, strauss  wrote:

> From: strauss 
> Subject: Re: ITSM 7.5 or 7.6, need an instance for a demo...tomorrow
> To: arslist@ARSLIST.ORG
> Date: Thursday, September 23, 2010, 5:56 PM

> I do have a sample data 7.6.03 system
> on a VM you could use... nothing you could hurt there.
> All of my 7.6.00 systems have been upgraded to 7.6.03 or are
> off-limits pre-production.
>
> Christopher Strauss, Ph.D.
> Call Tracking Administration Manager
> University of North Texas Computing & IT Center
> http://itsm.unt.edu/
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org]
> On Behalf Of Rabi Tripathi
> Sent: Thursday, September 23, 2010 3:58 PM
> To: arslist@ARSLIST.ORG
> Subject: ITSM 7.5 or 7.6, need an instance for a
> demo...tomorrow
>
> Hi all, this is a long shot, but I am trying any way.
> Anybody with ITSM 7.5 or 7.6 instance willing to let me use
> it tomorrow for a demo?
>
> I am doing an internal demo. 4 VM disks with ITSM that
> somebody was nice to send me turned out to be unusable.
>
> All I need to do is setup a few people and CIs ahead of
> time and then create a few IM/PM/CM records during the demo.
> It would be nice if I could access it some time today to
> setup my storyline.
>
> TIA.
>
>
>
>
>

___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers
> Are"
>
>

___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers
> Are"
>





___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"




  --
  Patrick Zandi
  _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: [REMEDY 6] ARDSERR 8747

[Joe D'Souza]

This looks like a DSO error. The DS stands for Distributed Server..

Import the AR System Error Messages form, from the def file found in the
help subdirectory of the AR Server installation directory of the AR Server.
This directory will also have arx files to import. Import these files into
the AR System Error Messages form after importing the form.

You will then be able to browse for error 8747 to see its complete
description. I do not have a ready installation right now or I'd do it for
you.

Hope this helps.

Cheers

Joe
  -Original Message-
  From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org]on Behalf Of Kali Obsum
  Sent: Tuesday, September 28, 2010 6:19 AM
  To: arslist@ARSLIST.ORG
  Subject: [REMEDY 6] ARDSERR 8747


  **
  Hi,

  Anyone knows about this error: ARDSERR 8747

  Regards,
  Kali

  NOTICE

  The information contained in this email is confidential. If you are not
the intended recipient, you must not disclose or use the information in this
email in any way. If you received it in error, please tell us immediately by
return email and delete the document. We do not guarantee the integrity of
any e-mails or attached files and are not responsible for any changes made
to them by any other person.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

[REMEDY 6] ARDSERR 8747

[Kali Obsum]

Hi,
 
Anyone knows about this error: ARDSERR 8747
 
Regards,
Kali
 

NOTICE 
The information contained in this email is confidential. If you are not the 
intended recipient, you must not disclose or use the information in this email 
in any way. If you received it in error, please tell us immediately by return 
email and delete the document.  We do not guarantee the integrity of any 
e-mails or attached files and are not responsible for any changes made to them 
by any other person.


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Re: Remedy 6.3 - DSO Process always stopping

[Kaye Bernales]

Thanks Doug!
 
Actually, we noticed the increase in number of records when the process
started dying frequently.  There was also a time we got ARERR 8747 on
logs but it's no longer appearing in current logs.  We know this could
be a memory issue.  Any ideas how to fix / address this?
 
Also, we're operating on a server group configuration (4 application
servers with DSO only enabled on one server).  There was a recent
cleanup on licenses - not sure if this could be related though.  But
would there be anything we could check further?
 
Thanks!
Kaye
 
 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Doug Blair
Sent: Monday, 27 September 2010 9:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy 6.3 - DSO Process always stopping


** 
Hi Kaye!

There are lots of factors that can slow DSO down but your biggest issue
is the 20 records. In addition to looking at indexing on the pending
table take a long look at all the different cases that are triggering a
DSO record. In particular, make sure that any filter that fires on merge
includes 

AND $USER$ != "Distributed Server"

So you don't go back and forth between servers. 




Doug 

--
Doug Blair
Sent from my iPhone4, typographic errors likely
+1-224-558-5462

On Sep 26, 2010, at 8:23 PM, Kaye Bernales
 wrote:



** 
Hi List,
 
We are running on AR System 6.3 (Solaris - Sybase).  We've
recently been having problems with DSO process.  The DSO queue grew up
to more than 200k records and process seems to always die.  AR Monitor
doesn't seem to be restarting it.  The process slowed down and we got to
a point where it only processes 1000 records per hour.  We tried
restarting the Remedy service and it made processing faster - however,
after a few hours, it started slowing down again.  
 
There are no problems with Database nor Unix servers.
 
Any ideas why DSO process keeps on dying and how we could get
more information?
 
Thanks!
Kaye

NOTICE 

The information contained in this email is confidential. If you
are not the intended recipient, you must not disclose or use the
information in this email in any way. If you received it in error,
please tell us immediately by return email and delete the document. We
do not guarantee the integrity of any e-mails or attached files and are
not responsible for any changes made to them by any other person.

 

_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ 

_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Job (Remedy ITSM 7 Consultant/Developer US Based)

[Greg Park]

 

Company:  Fusion Resource Management

Role:   Remedy Consultant (ITSM7)

Duration:   Contract or Permanent

Start:  ASAP

Location:   Various

Rate:   $Market

Position Summary:   Contract or Permanent opportunities for
US based experienced Remedy ITSM 7 Consultant/Developer

Reference:

 

Remedy ITSM 7 Consultant/Developer

 

Fusion Resource Management, a division of Fusion Business Solutions, is
currently looking to engage experienced Remedy Consultants with hands-on
experience of implementing and configuring Remedy ITSM7 (any modules) on
US or international customer sites. We currently have a range of
openings for experienced Consultants with ITSM7 experience to work on
Fusion and customer projects in the US, UK and Europe. If you have
technical exposure to any of the ITSM7 modules please contact our
Resource Manager for more information on available contracts.

 

About Fusion Business Solutions

 

Fusion, a Remedy partner since 1996 has delivered on over 200 Remedy
projects enabling us to become the No.1 Remedy partner in the UK and
number 2 in EMEA. We deliver market leading competitive solutions to
over 185 blue-chip customers. Fusion's Resourcing division is a
dedicated resourcing division leveraging our ITSM expertise to add value
to our customers' resourcing requirements.

 

 

 

 

Greg Park

 

Business Development Manager

 

Fusion Business Solutions (UK) Ltd

Tel: +44 (0) 208 814 6194

Mob: +44 (0) 7815 576 613

www.fusion.co.uk  

 

Fusion is the largest consultancy in Europe that focuses exclusively on
BMC Software solutions

 

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Resolved: Authentication Error

[Ram Rudra]

List,

 

Resolved

 

Changed the admin password of midtier as it is in ar.cfg file

 

Thanks,

Rambabu Rudra

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Ram Rudra
Sent: Tuesday, September 28, 2010 1:09 PM
To: arslist@ARSLIST.ORG
Subject: Authentication Error

 

** 

Hi List,

 

ARERR [623] 

Authentication failed  

 

I am able to login in User tool, but not in Mid-tier. Please help me in this
regard.

 

Thanks,

Rambabu Rudra

System Administrator | Managed Services 

 

_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

Authentication Error

[Ram Rudra]

Hi List,

 

ARERR [623] 

Authentication failed  

 

I am able to login in User tool, but not in Mid-tier. Please help me in this
regard.

 

Thanks,

Rambabu Rudra

System Administrator | Managed Services 

 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"