Re: Template with Web Service Submit

[Carl Wilson]

Hi,

Yes, you specify the Template Instance ID on the Interface_Create form to 
utilise an existing Template.

 

  _  

 

Kind Regards,

 

Carl Wilson

 

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of "Rüdiger Tams (priv)"
Sent: 25 October 2015 11:04
To: arslist@ARSLIST.ORG
Subject: Re: Template with Web Service Submit

 

** 

Hi Mark,

 

as far as I remember there should be a field for a Change Template ID in the 
form CHG:ChangeInterface_Create, right?

 

So - when you use the template by using the template ID and this template has a 
different process workflow defined,

a different than the ootb process workflow, the change created from the 
template should follow your different process workflow.

 

HTH

 

Regards

Rüdiger

 

** 

"Brittain, Mark"  hat am 23. Oktober 2015 um 19:35 
geschrieben:

Hi All & TGIF,

 

I have an external web service which creates a record in the 
CHG:ChangeInterface_Create and then of course creates the CHG:Infrastructure 
Change. The type of Changes being requested are for real simple “quick” changes 
and as such needs to have an abbreviated process flow. If I was manually 
creating this type of change, I could use template containing the abbreviated 
process flow.

 

Is there a way to designate in the CHG:ChangeInterface_Create to use a specific 
template or a specific flow process?

 

ARS 7.6.04 SP5

ITSM 7.6.04 SP2

 

Thanks

 

Mark

 

Mark Brittain

Sr. OSD Systems Engineer

ITILv3 Foundation, Continual Service Improvement

NaviSite, Inc. – A Time Warner Cable Company

mbritt...@navisite.com

Office: 315.634.9337

Mobile: 315.882.5360



 

 


  _  



This E-mail and any of its attachments may contain Time Warner Cable 
proprietary information, which is privileged, confidential, or subject to 
copyright belonging to Time Warner Cable. This E-mail is intended solely for 
the use of the individual or entity to which it is addressed. If you are not 
the intended recipient of this E-mail, you are hereby notified that any 
dissemination, distribution, copying, or action taken in relation to the 
contents of and attachments to this E-mail is strictly prohibited and may be 
unlawful. If you have received this E-mail in error, please notify the sender 
immediately and permanently delete the original and any copy of this E-mail and 
any printout.


 

_ARSlist: "Where the Answers Are" and have been for 20 years_


 

_ARSlist: "Where the Answers Are" and have been for 20 years_


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: New column to Incident management console

[Tauf Chowdhury]

I would confirm first that the field is being populated in the incident and 
then also make sure you've assigned proper permissions. 

Sent from my iPhone

> On Oct 26, 2015, at 1:34 AM, shashidhar M S  wrote:
> 
> Hello Experts,
> 
> There is a requirement to add a column  Customer Corporate ID to the table 
> field z2TH Incidents on Incident management console. 
> HPD:CFG_IncidentWatchList is a join form from where the table is getting the 
> data. I added the field Corporate ID to HPD:CFG_IncidentWatchList and added 
> the column to z2TH Incidents table on INC management console. 
> 
> Corporate ID field on HPD:CFG_IncidentWatchList  has valid data, but the same 
> is not displaying in incident Management console. No data is displaying for 
> the column Corporate ID.
> 
> Appreciate your prompt suggestions. Thanks
> 
> Regards,
> Shashi 
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Run process command fails

[LJ LongWing]

That inactive conhost may be the reason it can't be deleted, still in use.


On October 26, 2015 1:18:06 PM Joel Sender  wrote:

Both are excellent suggestions.

Unfortunately, I confirmed the permissions are ‘everyone has full control’ 
and I verified the command in a dos window.


The file is only used when it’s created, as it is then copied into an 
Attachment Field.


All further access is to the copy in the attachment field.



The command that creates the PDF also leaves behind an inactive instance of 
conhost.exe for each failure.


Thanks,

Joel

Joel Senderjdsen...@earthlink.net310.829.5552



From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing

Sent: Monday, October 26, 2015 11:09 AM
To: arslist@ARSLIST.ORG
Subject: Re: Run process command fails



**

Joel,
There are two reasons I can think of that world cause the delete too fail

1. The user performing the command doesn't have access to singe past of the 
effort

2. The file in question I'd in use and cannot be deleted

So, to eliminate 2, can you delete the file manually?  Too eliminate 1, 
make sure file/directory permissions are correct


On October 26, 2015 12:03:25 PM Joel Sender  wrote:

**

I’ve got a production server that suddenly started getting errors when 
running an external OS command.


The escalation first executes “del /f filename.pdf” and then runs the 
command to (re-)create filename.pdf.


The second command will fail if the file already exists, hence the need for 
the first command to delete.


As of last week, the delete command fails, which causes the second command 
to also fail, and leave behind an inactive instance.


The inactive instances took up all available memory and the server halts.



The AR System and Windows logs just show that the two commands fail.

Since no changes were made in ARS, I suspect the problem is in Windows.

Anyone else see something similar?



Environment:

ARS 8.1.1

Custom app

Windows 2003 server



BMC has, thus far, referred me to the OS team.

The OS team, naturally, refers me right back to BMC.

Can the ARSlist help me break this loop before I go fruity?

Joel

Joel Senderjdsen...@earthlink.net310.829.5552




 _


 Avast logo

This email has been checked for viruses by Avast antivirus software.
www.avast.com 


_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Run process command fails

[Jarl Grøneng]

You may need to include the path in the delete command, just in case.

-
J

2015-10-26 18:52 GMT+01:00 Joel Sender :

> **
>
> I’ve got a production server that suddenly started getting errors when
> running an external OS command.
>
> The escalation first executes “del /f filename.pdf” and then runs the
> command to (re-)create filename.pdf.
>
> The second command will fail if the file already exists, hence the need
> for the first command to delete.
>
> As of last week, the delete command fails, which causes the second command
> to also fail, and leave behind an inactive instance.
>
> The inactive instances took up all available memory and the server halts.
>
>
>
> The AR System and Windows logs just show that the two commands fail.
>
> Since no changes were made in ARS, I suspect the problem is in Windows.
>
> Anyone else see something similar?
>
>
>
> Environment:
>
> ARS 8.1.1
>
> Custom app
>
> Windows 2003 server
>
>
>
> BMC has, thus far, referred me to the OS team.
>
> The OS team, naturally, refers me right back to BMC.
>
> Can the ARSlist help me break this loop before I go fruity?
>
> *Joel*
>
> Joel Senderjdsen...@earthlink.net310.829.5552
>
>
> --
> [image: Avast logo] 
>
> This email has been checked for viruses by Avast antivirus software.
> www.avast.com 
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Is there an easy way to move all Change/Incident relationships from one CI to another CI?

[Ben Chernys]

Hi  Thad,

 

You know how to do it easily – Meta-Update J

 

Cheers

Ben

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser
Sent: October-26-15 08:01
To: arslist@ARSLIST.ORG
Subject: Is there an easy way to move all Change/Incident relationships from 
one CI to another CI?

 

** 

Hi,

 

Does anyone have ideas on the best way to reassign all related 
Changes/Incidents/etc from one CI to a different one?  We are working on 
cleaning up our CMDB, and are finding that we have two or more CIs that really 
represent the same thing.  The goal is to consolidate the CIs into one record 
and move all the ITSM relationships onto that one record.  The problem is that 
relationships to ITSM records (Changes/Releases/Incidents) exist across all of 
the duplicates, and each one can have 50+ relationships.  Moving them one at a 
time is painfully time consuming.  I was hoping something already existed that 
would help and I could avoid having to build anything new, which, of course, 
has its own opportunities to screw up.

 

Everything is 8.1, unpatched.

 

Thanks in advance for any thoughts.

Thad

 

_ARSlist: "Where the Answers Are" and have been for 20 years_ 


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Run process command fails

[Misi Mladoniczky]

Hi,

Instead of running a series of commands from an escalation, I would do a
single call to a bat-file you create. This will make sure that it is
synchronously.

If you are running the commands as Run Process, they are forked of from the AR
Server, and you never know which command runs first. You may want to do it as
a Set Fields $PROCESS$ to make sure the server waits for each command to
finish before running the next.

Maybe you are suddenly getting multiple matches in your escalation, and you
are running multiple delete/create-pdf commands simultaneously? This might
apply if you are using Run Process.

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* 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.

> I’ve got a production server that suddenly started getting errors when
> running an external OS command.
>
> The escalation first executes “del /f filename.pdf” and then runs the
> command to (re-)create filename.pdf.
>
> The second command will fail if the file already exists, hence the need for
> the first command to delete.
>
> As of last week, the delete command fails, which causes the second command to
> also fail, and leave behind an inactive instance.
>
> The inactive instances took up all available memory and the server halts.
>
>
>
> The AR System and Windows logs just show that the two commands fail.
>
> Since no changes were made in ARS, I suspect the problem is in Windows.
>
> Anyone else see something similar?
>
>
>
> Environment:
>
> ARS 8.1.1
>
> Custom app
>
> Windows 2003 server
>
>
>
> BMC has, thus far, referred me to the OS team.
>
> The OS team, naturally, refers me right back to BMC.
>
> Can the ARSlist help me break this loop before I go fruity?
>
> Joel
>
> Joel Senderjdsen...@earthlink.net310.829.5552
>
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Run process command fails

[Blairing]

Sorry for joining late in this, but hey, it's a Windows 2003 server. Of course 
it will still run nicely as long as no one touches it, even though both BMC and 
Microsoft will wave the "really really unsupported" flag if you call :-). 

Start by asking "Clippy" to show you all the non-log files that changed in the 
past month or two. :-)



Doug

--
Doug Blair
+1 224-558-5462

Sent from my iPad Air
Auto-corrected typos, misspellings and non-sequiturs are gratefully attributed 
to Steve Jobs :-)

> On Oct 26, 2015, at 12:52 PM, Joel Sender  wrote:
> 
> **
> I’ve got a production server that suddenly started getting errors when 
> running an external OS command.
> The escalation first executes “del /f filename.pdf” and then runs the command 
> to (re-)create filename.pdf.
> The second command will fail if the file already exists, hence the need for 
> the first command to delete.
> As of last week, the delete command fails, which causes the second command to 
> also fail, and leave behind an inactive instance.
> The inactive instances took up all available memory and the server halts.
>  
> The AR System and Windows logs just show that the two commands fail.
> Since no changes were made in ARS, I suspect the problem is in Windows.
> Anyone else see something similar?
>  
> Environment:
> ARS 8.1.1
> Custom app
> Windows 2003 server
>  
> BMC has, thus far, referred me to the OS team.
> The OS team, naturally, refers me right back to BMC.
> Can the ARSlist help me break this loop before I go fruity?
> Joel
> Joel Senderjdsen...@earthlink.net310.829.5552
> 
> 
>   
> This email has been checked for viruses by Avast antivirus software.  
> 
> www.avast.com
> 
> 
> _ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Verizon Walnut Creek,CA Remedy position

[Samuel J Albury III]

Why wouldn't you have an idea of the rate rage for a skilled BMC resource ?

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Verizon Walnut Creek,CA Remedy position

[LJ LongWing]

Sam,
I believe he was looking for what a 'good rate' for a developer in Walnut
Creek would be, vs one in New Yorkthe cost of living may be drastically
different.

http://www.bestplaces.net/cost_of_living/city/california/walnut_creek
vs
http://www.bestplaces.net/cost_of_living/city/new_york/new_york

Strangely, it seems it's cheaper to live in NY than it is Walnut Creek

so...an income of say 50/hr, while not enough to live in either place,
might be more than acceptable in other areas of the country...I think that
was the general question that Ravi was asking

On Mon, Oct 26, 2015 at 4:14 PM, Samuel J Albury III 
wrote:

> Why wouldn't you have an idea of the rate rage for a skilled BMC resource ?
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Verizon Walnut Creek,CA Remedy position

[Rick Cook]

Well, it seems that the client, and perhaps some of the contract agencies
don't have a clear idea.

Rick
On Oct 26, 2015 3:22 PM, "Samuel J Albury III"  wrote:

> Why wouldn't you have an idea of the rate rage for a skilled BMC resource ?
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Is there an easy way to move all Change/Incident relationships from one CI to another CI?

[Jason Miller]

LOL! I thinking of a few possibilities when I saw this post earlier but Ben
is right, Meta-Update would make it very easy.

Jason

On Mon, Oct 26, 2015 at 12:20 PM Ben Chernys <
ben.cher...@softwaretoolhouse.com> wrote:

> **
>
> Hi  Thad,
>
>
>
> You know how to do it easily – Meta-Update J
>
>
>
> Cheers
>
> Ben
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Thad Esser
> *Sent:* October-26-15 08:01
> *To:* arslist@ARSLIST.ORG
> *Subject:* Is there an easy way to move all Change/Incident relationships
> from one CI to another CI?
>
>
>
> **
>
> Hi,
>
>
>
> Does anyone have ideas on the best way to reassign all related
> Changes/Incidents/etc from one CI to a different one?  We are working on
> cleaning up our CMDB, and are finding that we have two or more CIs that
> really represent the same thing.  The goal is to consolidate the CIs into
> one record and move all the ITSM relationships onto that one record.  The
> problem is that relationships to ITSM records (Changes/Releases/Incidents)
> exist across all of the duplicates, and each one can have 50+
> relationships.  Moving them one at a time is painfully time consuming.  I
> was hoping something already existed that would help and I could avoid
> having to build anything new, which, of course, has its own opportunities
> to screw up.
>
>
>
> Everything is 8.1, unpatched.
>
>
>
> Thanks in advance for any thoughts.
>
> Thad
>
>
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
> _ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Verizon Walnut Creek,CA Remedy position

[Scott Philben]

That's where the "rate rage" comes in. 

Sent from my iPhone

> On Oct 26, 2015, at 18:27, Rick Cook  wrote:
> 
> **
> Well, it seems that the client, and perhaps some of the contract agencies 
> don't have a clear idea.
> 
> Rick
> 
>> On Oct 26, 2015 3:22 PM, "Samuel J Albury III"  wrote:
>> Why wouldn't you have an idea of the rate rage for a skilled BMC resource ?
>> 
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> "Where the Answers Are, and have been for 20 years"
> _ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Run process command fails: Resolved (sort of)

[Joel Sender]

First, thank you all for replying!



Second, the Windows version is Server 2008 R2 64Bit (my bad - old documentation)



The OS team discovered that the server hadn’t received an update in the past 12 
months; they are addressing this.

The development server, however, has been updated, which explains why it is 
working just fine.



Misi’s suggestion of a bat file is an upgrade I had recommended; perhaps now is 
will be accepted.



Once again, the ARSlist saved (what’s left of) my sanity!



Joel

Joel Senderjdsen...@earthlink.net310.829.5552



From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Blairing
Sent: Monday, October 26, 2015 2:55 PM
To: arslist@ARSLIST.ORG
Subject: Re: Run process command fails



**

Sorry for joining late in this, but hey, it's a Windows 2003 server. Of course 
it will still run nicely as long as no one touches it, even though both BMC and 
Microsoft will wave the "really really unsupported" flag if you call :-).



Start by asking "Clippy" to show you all the non-log files that changed in the 
past month or two. :-)





Doug



--

Doug Blair

+1 224-558-5462



Sent from my iPad Air

Auto-corrected typos, misspellings and non-sequiturs are gratefully attributed 
to Steve Jobs :-)


On Oct 26, 2015, at 12:52 PM, Joel Sender  wrote:

**

I’ve got a production server that suddenly started getting errors when running 
an external OS command.

The escalation first executes “del /f filename.pdf” and then runs the command 
to (re-)create filename.pdf.

The second command will fail if the file already exists, hence the need for the 
first command to delete.

As of last week, the delete command fails, which causes the second command to 
also fail, and leave behind an inactive instance.

The inactive instances took up all available memory and the server halts.



The AR System and Windows logs just show that the two commands fail.

Since no changes were made in ARS, I suspect the problem is in Windows.

Anyone else see something similar?



Environment:

ARS 8.1.1

Custom app

Windows 2003 server



BMC has, thus far, referred me to the OS team.

The OS team, naturally, refers me right back to BMC.

Can the ARSlist help me break this loop before I go fruity?

Joel

Joel Senderjdsen...@earthlink.net310.829.5552



  _


  Avast logo

This email has been checked for viruses by Avast antivirus software.
www.avast.com 


_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: ITSM 9.0 question - can you test this? -- Resolved

[William Rentfrow]

I am pretty sure this is going to end up being DB-platform specific.  We are on 
Oracle 11g RAC.


I did this advanced search against CFG:Decision Tree Branch:



NOT ('Branch ID') LIKE $NULL$



It returns zero results.  Apparently you can't do a NOT LIKE NULL on our DB 
platform and have it work.



This doesn't work either, which is what is much closer to the SQL issued:



NOT ("%"+'Branch ID'+"%") LIKE $NULL$



This works just fine:



'Branch ID' != $NULL$



Obviously an overlay + fix on the Set Fields qual should fix this permanently.


William Rentfrow
wrentf...@stratacominc.com
Office: 715-204-3061 or 701-232-5697x25
Cell: 715-498-5056

From: William Rentfrow
Sent: Monday, October 26, 2015 10:11 PM
To: William Rentfrow; arslist@ARSLIST.ORG
Subject: RE: ITSM 9.0 question - can you test this?

Okay so I found the problem - kind of...


The workflow that generates that SQL is the first Set Fields of active link 
CFG:PDB:RefreshBranchTable_100 - here is the set fields matching condition 
doing a lookup against CFG:Decision Tree Branch:



('Decision Tree ID' = $Decision Tree ID$) AND ('Main Branch' = "Yes") AND ( NOT 
($z1D Action02$ LIKE (("%" + 'Branch ID') + "%"))) AND ('Status' = "Enabled")



$z1D Action02$ is $NULL$ at that point in the workflow.  It is set after this 
to the Entry ID of the record in the 2nd Set Fields action of the same active 
link (third overall action).



Here's what the SQL generated from that looks like:



SELECT * FROM (SELECT AR_SQL_Alias$1.*, rownum as AR_RowNumber_Alias$1 FROM 
(SELECT T1031.C104130, T1031.C1, T1031.C104224, T1031.C104239, 
T1031.C104241 FROM T1031 WHERE ((T1031.C104215 = N'PDT0002') 
AND (T1031.C104224 = 0) AND (NOT (N'%'||T1031.C1||N'%' LIKE NULL)) AND 
(T1031.C7 = 1)) ORDER BY T1031.C104215 ASC, T1031.C100244 ASC, T1031.C1 
ASC) AR_SQL_Alias$1) WHERE ((AR_RowNumber_Alias$1 > 0) AND 
(AR_RowNumber_Alias$1 < 3))





In our dev environment I created an overlay on that Active Link   I changed the 
"Set Fields" match condition to this:



('Decision Tree ID' = $Decision Tree ID$) AND ('Main Branch' = "Yes")  AND 
('Status' = "Enabled")



and it works.  So that whole C1 NOT LIKE NULL thing is what is causing 
this.   I am 100% sure that is the root cause.



I just have no idea what this is actually saying from the above SQL.



AND (NOT (N'%'||T1031.C1||N'%' LIKE NULL))




William Rentfrow
wrentf...@stratacominc.com
Office: 715-204-3061 or 701-232-5697x25
Cell: 715-498-5056

From: William Rentfrow
Sent: Monday, October 26, 2015 12:48 PM
To: arslist@ARSLIST.ORG
Subject: ITSM 9.0 question - can you test this?

Hello listers -

We've run into an interesting issue.  In IM 9.0 we can select New Incident, 
then fill out a caller's information.

The we select the decision tree link/button and it opens the trees.

Then when we select one it should open the branch window.  It opens an empty 
window.

In ITSM 8.1 it works - and it's all the same base product code.   If you happen 
to have ITSM 9 and a couple of seconds to spare can you try this?

Also for fun I compared the SQL and ARS 9 has a bunch of stuff I don't get - 
like random "N"'s in the SQL

Older working server query:

SELECT  * FROM ( SELECT  
T1031.C1,C104224,C104241,C104130,C104239 FROM T1031 WHERE 
((T1031.C104215 = 'PDT0002') AND (T1031.C104224 = 0) AND NOT 
((' ' LIKE (('%' || T1031.C1) || '%'))) AND (T1031.C7 = 1)) ORDER BY 
C104215 ASC,C100244 ASC, 1 ASC ) WHERE ROWNUM <= 2

New-fangled what is this stuff query:

SELECT * FROM (SELECT AR_SQL_Alias1 FROM (SELECT T1031.C1, T1031.C104239, 
T1031.C104130, T1031.C104241, T1031.C104224 FROM T1031 WHERE 
((T1031.C104215 = N'PDT0002') AND (T1031.C104224 = 0) AND (NOT 
(N'%'||T1031.C1||N'%' LIKE NULL)) AND (T1031.C7 = 1)) ORDER BY 
T1031.C104215 ASC, T1031.C100244 ASC, T1031.C1 ASC) AR_SQL_Alias1 > 0) 
AND (AR_RowNumber_Alias$1 < 3))

William Rentfrow
wrentf...@stratacominc.com
Office: 715-204-3061 or 701-232-5697x25
Cell: 715-498-5056


No virus found in this message.
Checked by AVG - www.avg.com
Version: 2014.0.4830 / Virus Database: 4365/10845 - Release Date: 10/18/15
Internal Virus Database is out of date.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: ITSM 9.0 question - can you test this?

[William Rentfrow]

Okay so I found the problem - kind of...


The workflow that generates that SQL is the first Set Fields of active link 
CFG:PDB:RefreshBranchTable_100 - here is the set fields matching condition 
doing a lookup against CFG:Decision Tree Branch:



('Decision Tree ID' = $Decision Tree ID$) AND ('Main Branch' = "Yes") AND ( NOT 
($z1D Action02$ LIKE (("%" + 'Branch ID') + "%"))) AND ('Status' = "Enabled")



$z1D Action02$ is $NULL$ at that point in the workflow.  It is set after this 
to the Entry ID of the record in the 2nd Set Fields action of the same active 
link (third overall action).



Here's what the SQL generated from that looks like:



SELECT * FROM (SELECT AR_SQL_Alias$1.*, rownum as AR_RowNumber_Alias$1 FROM 
(SELECT T1031.C104130, T1031.C1, T1031.C104224, T1031.C104239, 
T1031.C104241 FROM T1031 WHERE ((T1031.C104215 = N'PDT0002') 
AND (T1031.C104224 = 0) AND (NOT (N'%'||T1031.C1||N'%' LIKE NULL)) AND 
(T1031.C7 = 1)) ORDER BY T1031.C104215 ASC, T1031.C100244 ASC, T1031.C1 
ASC) AR_SQL_Alias$1) WHERE ((AR_RowNumber_Alias$1 > 0) AND 
(AR_RowNumber_Alias$1 < 3))





In our dev environment I created an overlay on that Active Link   I changed the 
"Set Fields" match condition to this:



('Decision Tree ID' = $Decision Tree ID$) AND ('Main Branch' = "Yes")  AND 
('Status' = "Enabled")



and it works.  So that whole C1 NOT LIKE NULL thing is what is causing 
this.   I am 100% sure that is the root cause.



I just have no idea what this is actually saying from the above SQL.



AND (NOT (N'%'||T1031.C1||N'%' LIKE NULL))




William Rentfrow
wrentf...@stratacominc.com
Office: 715-204-3061 or 701-232-5697x25
Cell: 715-498-5056

From: William Rentfrow
Sent: Monday, October 26, 2015 12:48 PM
To: arslist@ARSLIST.ORG
Subject: ITSM 9.0 question - can you test this?

Hello listers -

We've run into an interesting issue.  In IM 9.0 we can select New Incident, 
then fill out a caller's information.

The we select the decision tree link/button and it opens the trees.

Then when we select one it should open the branch window.  It opens an empty 
window.

In ITSM 8.1 it works - and it's all the same base product code.   If you happen 
to have ITSM 9 and a couple of seconds to spare can you try this?

Also for fun I compared the SQL and ARS 9 has a bunch of stuff I don't get - 
like random "N"'s in the SQL

Older working server query:

SELECT  * FROM ( SELECT  
T1031.C1,C104224,C104241,C104130,C104239 FROM T1031 WHERE 
((T1031.C104215 = 'PDT0002') AND (T1031.C104224 = 0) AND NOT 
((' ' LIKE (('%' || T1031.C1) || '%'))) AND (T1031.C7 = 1)) ORDER BY 
C104215 ASC,C100244 ASC, 1 ASC ) WHERE ROWNUM <= 2

New-fangled what is this stuff query:

SELECT * FROM (SELECT AR_SQL_Alias1 FROM (SELECT T1031.C1, T1031.C104239, 
T1031.C104130, T1031.C104241, T1031.C104224 FROM T1031 WHERE 
((T1031.C104215 = N'PDT0002') AND (T1031.C104224 = 0) AND (NOT 
(N'%'||T1031.C1||N'%' LIKE NULL)) AND (T1031.C7 = 1)) ORDER BY 
T1031.C104215 ASC, T1031.C100244 ASC, T1031.C1 ASC) AR_SQL_Alias1 > 0) 
AND (AR_RowNumber_Alias$1 < 3))

William Rentfrow
wrentf...@stratacominc.com
Office: 715-204-3061 or 701-232-5697x25
Cell: 715-498-5056


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Run process command fails

[Joel Sender]

Both are excellent suggestions.

Unfortunately, I confirmed the permissions are ‘everyone has full control’ and 
I verified the command in a dos window.

The file is only used when it’s created, as it is then copied into an 
Attachment Field.

All further access is to the copy in the attachment field.



The command that creates the PDF also leaves behind an inactive instance of 
conhost.exe for each failure.

Thanks,

Joel

Joel Senderjdsen...@earthlink.net310.829.5552



From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Monday, October 26, 2015 11:09 AM
To: arslist@ARSLIST.ORG
Subject: Re: Run process command fails



**

Joel,
There are two reasons I can think of that world cause the delete too fail

1. The user performing the command doesn't have access to singe past of the 
effort
2. The file in question I'd in use and cannot be deleted

So, to eliminate 2, can you delete the file manually?  Too eliminate 1, make 
sure file/directory permissions are correct

On October 26, 2015 12:03:25 PM Joel Sender  wrote:

**

I’ve got a production server that suddenly started getting errors when running 
an external OS command.

The escalation first executes “del /f filename.pdf” and then runs the command 
to (re-)create filename.pdf.

The second command will fail if the file already exists, hence the need for the 
first command to delete.

As of last week, the delete command fails, which causes the second command to 
also fail, and leave behind an inactive instance.

The inactive instances took up all available memory and the server halts.



The AR System and Windows logs just show that the two commands fail.

Since no changes were made in ARS, I suspect the problem is in Windows.

Anyone else see something similar?



Environment:

ARS 8.1.1

Custom app

Windows 2003 server



BMC has, thus far, referred me to the OS team.

The OS team, naturally, refers me right back to BMC.

Can the ARSlist help me break this loop before I go fruity?

Joel

Joel Senderjdsen...@earthlink.net310.829.5552




  _


  Avast logo

This email has been checked for viruses by Avast antivirus software.
www.avast.com 


_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Run process command fails

[Joel Sender]

I’ll continue to push back to the OS team

(makes the most sense to me, but I feel better with ARSlist confirmation of my 
suspicions)

Thanks,

Joel

Joel Senderjdsen...@earthlink.net310.829.5552



From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of William Rentfrow
Sent: Monday, October 26, 2015 11:13 AM
To: arslist@ARSLIST.ORG
Subject: Re: Run process command fails



**

I'd also check to  see if there has been any recent security patches put on the 
server.



William Rentfrow

wrentf...@stratacominc.com

Office: 715-204-3061 or 701-232-5697x25

Cell: 715-498-5056



From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Monday, October 26, 2015 1:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: Run process command fails



**

Joel,
There are two reasons I can think of that world cause the delete too fail

1. The user performing the command doesn't have access to singe past of the 
effort
2. The file in question I'd in use and cannot be deleted

So, to eliminate 2, can you delete the file manually?  Too eliminate 1, make 
sure file/directory permissions are correct

On October 26, 2015 12:03:25 PM Joel Sender  wrote:

**

I’ve got a production server that suddenly started getting errors when running 
an external OS command.

The escalation first executes “del /f filename.pdf” and then runs the command 
to (re-)create filename.pdf.

The second command will fail if the file already exists, hence the need for the 
first command to delete.

As of last week, the delete command fails, which causes the second command to 
also fail, and leave behind an inactive instance.

The inactive instances took up all available memory and the server halts.



The AR System and Windows logs just show that the two commands fail.

Since no changes were made in ARS, I suspect the problem is in Windows.

Anyone else see something similar?



Environment:

ARS 8.1.1

Custom app

Windows 2003 server



BMC has, thus far, referred me to the OS team.

The OS team, naturally, refers me right back to BMC.

Can the ARSlist help me break this loop before I go fruity?

Joel

Joel Senderjdsen...@earthlink.net310.829.5552




  _


  Avast logo

This email has been checked for viruses by Avast antivirus software.
www.avast.com 


_ARSlist: "Where the Answers Are" and have been for 20 years_

  _

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2014.0.4830 / Virus Database: 4365/10845 - Release Date: 10/18/15
Internal Virus Database is out of date.

_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Is there an easy way to move all Change/Incident relationships from one CI to another CI?

[Thad Esser]

Hi,

Does anyone have ideas on the best way to reassign all related
Changes/Incidents/etc from one CI to a different one?  We are working on
cleaning up our CMDB, and are finding that we have two or more CIs that
really represent the same thing.  The goal is to consolidate the CIs into
one record and move all the ITSM relationships onto that one record.  The
problem is that relationships to ITSM records (Changes/Releases/Incidents)
exist across all of the duplicates, and each one can have 50+
relationships.  Moving them one at a time is painfully time consuming.  I
was hoping something already existed that would help and I could avoid
having to build anything new, which, of course, has its own opportunities
to screw up.

Everything is 8.1, unpatched.

Thanks in advance for any thoughts.
Thad

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

ITSM 9.0 question - can you test this?

[William Rentfrow]

Hello listers -

We've run into an interesting issue.  In IM 9.0 we can select New Incident, 
then fill out a caller's information.

The we select the decision tree link/button and it opens the trees.

Then when we select one it should open the branch window.  It opens an empty 
window.

In ITSM 8.1 it works - and it's all the same base product code.   If you happen 
to have ITSM 9 and a couple of seconds to spare can you try this?

Also for fun I compared the SQL and ARS 9 has a bunch of stuff I don't get - 
like random "N"'s in the SQL

Older working server query:

SELECT  * FROM ( SELECT  
T1031.C1,C104224,C104241,C104130,C104239 FROM T1031 WHERE 
((T1031.C104215 = 'PDT0002') AND (T1031.C104224 = 0) AND NOT 
((' ' LIKE (('%' || T1031.C1) || '%'))) AND (T1031.C7 = 1)) ORDER BY 
C104215 ASC,C100244 ASC, 1 ASC ) WHERE ROWNUM <= 2

New-fangled what is this stuff query:

SELECT * FROM (SELECT AR_SQL_Alias1 FROM (SELECT T1031.C1, T1031.C104239, 
T1031.C104130, T1031.C104241, T1031.C104224 FROM T1031 WHERE 
((T1031.C104215 = N'PDT0002') AND (T1031.C104224 = 0) AND (NOT 
(N'%'||T1031.C1||N'%' LIKE NULL)) AND (T1031.C7 = 1)) ORDER BY 
T1031.C104215 ASC, T1031.C100244 ASC, T1031.C1 ASC) AR_SQL_Alias1 > 0) 
AND (AR_RowNumber_Alias$1 < 3))

William Rentfrow
wrentf...@stratacominc.com
Office: 715-204-3061 or 701-232-5697x25
Cell: 715-498-5056


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Run process command fails

[Joel Sender]

I’ve got a production server that suddenly started getting errors when running 
an external OS command.

The escalation first executes “del /f filename.pdf” and then runs the command 
to (re-)create filename.pdf.

The second command will fail if the file already exists, hence the need for the 
first command to delete.

As of last week, the delete command fails, which causes the second command to 
also fail, and leave behind an inactive instance.

The inactive instances took up all available memory and the server halts.



The AR System and Windows logs just show that the two commands fail.

Since no changes were made in ARS, I suspect the problem is in Windows.

Anyone else see something similar?



Environment:

ARS 8.1.1

Custom app

Windows 2003 server



BMC has, thus far, referred me to the OS team.

The OS team, naturally, refers me right back to BMC.

Can the ARSlist help me break this loop before I go fruity?

Joel

Joel Senderjdsen...@earthlink.net310.829.5552



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Run process command fails

[William Rentfrow]

I'd also check to  see if there has been any recent security patches put on the 
server.

William Rentfrow
wrentf...@stratacominc.com
Office: 715-204-3061 or 701-232-5697x25
Cell: 715-498-5056

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Monday, October 26, 2015 1:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: Run process command fails

**

Joel,
There are two reasons I can think of that world cause the delete too fail

1. The user performing the command doesn't have access to singe past of the 
effort
2. The file in question I'd in use and cannot be deleted

So, to eliminate 2, can you delete the file manually?  Too eliminate 1, make 
sure file/directory permissions are correct

On October 26, 2015 12:03:25 PM Joel Sender 
> wrote:
**
I’ve got a production server that suddenly started getting errors when running 
an external OS command.
The escalation first executes “del /f filename.pdf” and then runs the command 
to (re-)create filename.pdf.
The second command will fail if the file already exists, hence the need for the 
first command to delete.
As of last week, the delete command fails, which causes the second command to 
also fail, and leave behind an inactive instance.
The inactive instances took up all available memory and the server halts.

The AR System and Windows logs just show that the two commands fail.
Since no changes were made in ARS, I suspect the problem is in Windows.
Anyone else see something similar?

Environment:
ARS 8.1.1
Custom app
Windows 2003 server

BMC has, thus far, referred me to the OS team.
The OS team, naturally, refers me right back to BMC.
Can the ARSlist help me break this loop before I go fruity?
Joel
Joel Senderjdsen...@earthlink.net
310.829.5552


[Avast logo]


This email has been checked for viruses by Avast antivirus software.
www.avast.com


_ARSlist: "Where the Answers Are" and have been for 20 years_

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2014.0.4830 / Virus Database: 4365/10845 - Release Date: 10/18/15
Internal Virus Database is out of date.
_ARSlist: "Where the Answers Are" and have been for 20 years_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Run process command fails

[LJ LongWing]

Joel,
There are two reasons I can think of that world cause the delete too fail

1. The user performing the command doesn't have access to singe past of the 
effort

2. The file in question I'd in use and cannot be deleted

So, to eliminate 2, can you delete the file manually?  Too eliminate 1, 
make sure file/directory permissions are correct



On October 26, 2015 12:03:25 PM Joel Sender  wrote:

I’ve got a production server that suddenly started getting errors when 
running an external OS command.


The escalation first executes “del /f filename.pdf” and then runs the 
command to (re-)create filename.pdf.


The second command will fail if the file already exists, hence the need for 
the first command to delete.


As of last week, the delete command fails, which causes the second command 
to also fail, and leave behind an inactive instance.


The inactive instances took up all available memory and the server halts.



The AR System and Windows logs just show that the two commands fail.

Since no changes were made in ARS, I suspect the problem is in Windows.

Anyone else see something similar?



Environment:

ARS 8.1.1

Custom app

Windows 2003 server



BMC has, thus far, referred me to the OS team.

The OS team, naturally, refers me right back to BMC.

Can the ARSlist help me break this loop before I go fruity?

Joel

Joel Senderjdsen...@earthlink.net310.829.5552



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"