Re: Serious flaw in BMC Remedy Licensing

[Misi Mladoniczky]

Hi,

I am currently looking at another of our customers data, and they are on 8.1
and mainly use the Incident module. But their users seem to hang out in the
Overview Console for the most part.

This has reduced their Incident license requirements to about 50% compared to
the AR license requirements.

This in turn indicates that they can benefit from adding AR licenses instead
of Suite licenses to remedy their shortage, and AR licenses (Service
Management Specialist) is a lot cheaper than Suite licenses.

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.

> We are on 7.6.04 with Mid Tier 8.1.   So, based on Doug and Misi's response it
> sounds like it is fixed in newer releases (we are moving to 9.x this coming
> spring).
>
> That begs a follow up question or 2.
>
> If this is indeed a flaw with 7.6.04, one could argue we have been overpaying
> for licenses since 2012.  Unfortunately, since the user.log logs these
> interactions and we are using the RRR license tool to determine how many
> licenses we need, it appears there is no easy way to figure out how many
> actual write licenses we need and should assign.
>
> 1. Does anybody have any recommendations on how to address with BMC when with
> our annual license renewals?
>
> 2. We have queried SQL with the 1900+ write license consumers and determined
> that 500 of them have never updated a ticket or entered a work log entry in a
> ticket.   Would setting them to Incident "viewer" be a good work around?
>
> 3. Is what has been fixed in 8.x relative to the "flaw" something we can apply
> to our 7.6.04 environment?
>
> Thanks AR listers!!
>
> Ryan
>
> ___
> 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: Serious flaw in BMC Remedy Licensing

[Misi Mladoniczky]

Hi,

I presume that it would be OK to do this in two ways:

1. Create a plugin that uses a generic RESTRICTED READ user to provide the
data you need to read.

2. Leverage the Vendor Form that calls the BMC plugin servicing the Overview
Console. This way it should be possible to create your own table that shows
the same information as the Overview Console, either in the normal Remedy GUI
as a table, or through any integration using the API.

Comments on these ideas would be appreciated.

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.

> Just wondering — say you wrote your own console … how can you not
> “tap” the
> license unless you need it?
> Is this reserved only for the BMC provided consoles?
>
>
> -John
>
>
>
>
> On Mon, Nov 2, 2015 at 11:34 AM, LJ LongWing  wrote:
>
>> **
>> Ryan,
>> As I understand it, this isn't a 'flaw' that needs to be
>> 'backported'...but instead, a change in direction from their long standing
>> stated policies.
>>
>> As I understand it, and somewhat agree with...the reason that a Float
>> Write is accompanied by doing a query, instead of at attempt to write, is
>> quite simple.  If a user is doing a query for some data, they are more than
>> likely trying to find something that they need to modify, and as such, will
>> need a write license in the near future.  Along those lines, if they didn't
>> request a write till they were actually trying to write, it might be
>> frustrating to the user experience.
>>
>> Now...with that said...when the policy was put in place (as I understand
>> it...almost from the beginning...certainly not recent)...there was no
>> concept of an 'overview console' that allowed people to query every form in
>> the system for relevant information and consolidating it into a
>> console/dashboard type of functionalitywhen this was done, and applied
>> the old methodology of 'a query likely means a coming modify', then as you
>> know, this then causes massive quantities of float licenses to be
>> unnecessarily consumed.  When it was pointed out to BMC that this was
>> occurring, and how 'unfair' it was, BMC apparently decided to change it so
>> that the overview console was allowed to do its queries without incurring a
>> penalty on the cost of the system by allocating licenses to everyone in the
>> console.
>>
>> Sowhile it was a design choice with unintended financial
>> consequences...it was not a flaw, or a bugand in order to avoid this
>> feature, you need to be on the version of the tool that changes the
>> direction and avoids this one scenario
>>
>> I'm not a major fan of the 'it's a feature, not a bug' discussion...but in
>> this case, I agree with BMC's logic that it wasn't a bugI don't
>> fundamentally agree with the idea of allocating float write on query...but
>> it's not my tool, and I don't make the rules :)
>>
>> On Mon, Nov 2, 2015 at 9:15 AM, Ryan Nicosia 
>> wrote:
>>
>>> We are on 7.6.04 with Mid Tier 8.1.   So, based on Doug and Misi's
>>> response it sounds like it is fixed in newer releases (we are moving to 9.x
>>> this coming spring).
>>>
>>> That begs a follow up question or 2.
>>>
>>> If this is indeed a flaw with 7.6.04, one could argue we have been
>>> overpaying for licenses since 2012.  Unfortunately, since the user.log logs
>>> these interactions and we are using the RRR license tool to determine how
>>> many licenses we need, it appears there is no easy way to figure out how
>>> many actual write licenses we need and should assign.
>>>
>>> 1. Does anybody have any recommendations on how to address with BMC when
>>> with our annual license renewals?
>>>
>>> 2. We have queried SQL with the 1900+ write license consumers and
>>> determined that 500 of them have never updated a ticket or entered a work
>>> log entry in a ticket.   Would setting them to Incident "viewer" be a good
>>> work around?
>>>
>>> 3. Is what has been fixed in 8.x relative to the "flaw" something we can
>>> apply to our 7.6.04 environment?
>>>
>>> Thanks AR listers!!
>>>
>>> Ryan
>>>
>>>
>>> ___
>>> 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_
>
>
>
>
> --
>
> *John Sundberg*
> Kinetic Data, Inc.
> "Your business. Your process."
>
> 651-556-0930 I john.sundb...@kineticdata.com
> www.kineticdata.com I community.kineticdata.com
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at 

Re: Serious flaw in BMC Remedy Licensing

[Misi Mladoniczky]

Hi,

One more thing. As BMC has clearly accepted this a a BUG, you as customers
should definitely get temporary licenses until you upgrade.

And based on the mumbers below (50%) I think it would be fair to ask BMC to
double your Application license counts until you get a patch installed for the
BUG.

I am not sure if it is enough to upgrade your AR Server to 8.1, or if you need
to upgrade ITSM as well...

And please note that this does not affect the AR license usage. You will still
consume an AR license when you run the Overview Console in 8.1+.

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

> Hi,
>
> I am currently looking at another of our customers data, and they are on 8.1
> and mainly use the Incident module. But their users seem to hang out in the
> Overview Console for the most part.
>
> This has reduced their Incident license requirements to about 50% compared to
> the AR license requirements.
>
> This in turn indicates that they can benefit from adding AR licenses instead
> of Suite licenses to remedy their shortage, and AR licenses (Service
> Management Specialist) is a lot cheaper than Suite licenses.
>
> 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.
>
>> We are on 7.6.04 with Mid Tier 8.1.   So, based on Doug and Misi's response
>> it
>> sounds like it is fixed in newer releases (we are moving to 9.x this coming
>> spring).
>>
>> That begs a follow up question or 2.
>>
>> If this is indeed a flaw with 7.6.04, one could argue we have been
>> overpaying
>> for licenses since 2012.  Unfortunately, since the user.log logs these
>> interactions and we are using the RRR license tool to determine how many
>> licenses we need, it appears there is no easy way to figure out how many
>> actual write licenses we need and should assign.
>>
>> 1. Does anybody have any recommendations on how to address with BMC when
>> with
>> our annual license renewals?
>>
>> 2. We have queried SQL with the 1900+ write license consumers and determined
>> that 500 of them have never updated a ticket or entered a work log entry in
>> a
>> ticket.   Would setting them to Incident "viewer" be a good work around?
>>
>> 3. Is what has been fixed in 8.x relative to the "flaw" something we can
>> apply
>> to our 7.6.04 environment?
>>
>> Thanks AR listers!!
>>
>> Ryan
>>
>> ___
>> 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"
>

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

Notifications for Purchase Requisitions?

[jjohnson]

Is there a reason that there are no notifications for the purchase
requisition module anymore? How are the various roles supposed to know that
a record is available for them to work on?



--
View this message in context: 
http://ars-action-request-system.1.n7.nabble.com/Notifications-for-Purchase-Requisitions-tp123309.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

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

Re: Notifications for Purchase Requisitions?

[Hennigan, Sandra, CTR, DSS]

In 8.1.01, there are 6 SYS:Notification Messages for the Purchase
Requisition module:

Assignment
Re- Assignment
Place Order Notification
Purchase Line Item Cancelled
Purchase Line Item Reduced
Request Pricing

The Asset management module has other notifications that somewhat blend into
the Change & Purchase Requisition modules. Task notifications can make up
another block of messages.

Thank you,

Sandra


-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of jjohnson
Sent: Tuesday, November 03, 2015 9:43 AM
To: arslist@ARSLIST.ORG
Subject: Notifications for Purchase Requisitions?

Is there a reason that there are no notifications for the purchase
requisition module anymore? How are the various roles supposed to know that
a record is available for them to work on?



--
View this message in context:
http://ars-action-request-system.1.n7.nabble.com/Notifications-for-Purchase-
Requisitions-tp123309.html
Sent from the ARS (Action Request System) mailing list archive at
Nabble.com.


___
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"


smime.p7s
Description: S/MIME cryptographic signature

ARGetMultipleEntries returning ARERR 552: ORA-00936: missing expression

[Ben Chernys]

Hi All,

 

ARS / ITSM 8.1.0 >>8.1.00 201301251157<< on Cent OS against Oracle 11.2

 

Interesting trace on this one.  The query worked fine the first go (there is
no query argument to this f) and ARGetMultipleEntries() picked up 100
records from AST:BaseElement.

 

On the second go of 100 records, the SQL log shows a single SQL repeated 100
times for each record, and then (for the status history):

 

ARGetMultipleEntries ==>   
   

ARGetMultipleEntries ==> /* Tue Nov 03 2015 22:56:51.5891 */SELECT
entryId,T0,U0,T1,U1,T2,U2,T3,U3,T4,U4,T5,U5,T6,U6,T7

U7,T8,U8,T9,U9,T10,U10,T11,U11,T12,U12,T13,U13 FROM H1572 WHERE entryId
IN)

ARGetMultipleEntries ==>   
   

ARGetMultipleEntries ==> /* Tue Nov 03 2015 22:56:51.5907 */*** ERROR
***  ORA-00936: missing expression 

 

Interestingly, I think it may be related to not enough space allocated for
the IN expression - as each Id will be more than 15 bytes.  More
interestingly, this table has 0 records.

 

The table in Q (schemaid = 1572) is AST:BaseElement - an infamous join J

 

So, has this been fixed in a server patch?  Has anyone else seen this?

 

Cheers

Ben Chernys

  www.softwaretoolhouse.com

 


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

Re: ARGetMultipleEntries returning ARERR 552: ORA-00936: missing expression

[Rick Cook]

I saw something similar on an AI Transformation (MSSQL) that was performing
a similar function.  I, too, thought it was a space issue.  I removed one
condition (order by) from the SQL query, and it worked.

Rick
On Nov 3, 2015 2:33 PM, "Ben Chernys" 
wrote:

> **
>
> Hi All,
>
>
>
> ARS / ITSM 8.1.0 >>8.1.00 201301251157<< on Cent OS against Oracle 11.2
>
>
>
> Interesting trace on this one.  The query worked fine the first go (there
> is no query argument to this f) and ARGetMultipleEntries() picked up 100
> records from AST:BaseElement.
>
>
>
> On the second go of 100 records, the SQL log shows a single SQL repeated
> 100 times for each record, and then (for the status history):
>
>
>
> ARGetMultipleEntries ==>   
>Demo > 
>
> ARGetMultipleEntries ==> /* Tue Nov 03 2015 22:56:51.5891 */SELECT
> entryId,T0,U0,T1,U1,T2,U2,T3,U3,T4,U4,T5,U5,T6,U6,T7
>
> U7,T8,U8,T9,U9,T10,U10,T11,U11,T12,U12,T13,U13 FROM H1572 WHERE entryId
> IN)
>
> ARGetMultipleEntries ==>   
>Demo > 
>
> ARGetMultipleEntries ==> /* Tue Nov 03 2015 22:56:51.5907 */*** ERROR
> ***  ORA-00936: missing expression
>
>
>
> Interestingly, I think it may be related to not enough space allocated for
> the IN expression – as each Id will be more than 15 bytes.  More
> interestingly, this table has 0 records.
>
>
>
> The table in Q (schemaid = 1572) is AST:BaseElement – an infamous join J
>
>
>
> So, has this been fixed in a server patch?  Has anyone else seen this?
>
>
>
> Cheers
>
> Ben Chernys
>
> www.softwaretoolhouse.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: ARGetMultipleEntries returning ARERR 552: ORA-00936: missing expression

[Ben Chernys]

Thanks Rick, but that can’t be it.  I am doing NO SQL queries.  ONLY an 
ARGetMuplipleEntries() call – which has no query terms at all – so there’s 
nothing I can adjust – unless BMC publishes source J

 

What’s interesting is that an IN expression was attempted to be generated BUT 
only for the Status History and 100 different SQL selects were done for the 100 
records (which worked).  All this is part of the single ARGetMultipleEntries 
call.

 

The question is – has this been fixed in a patch to 8.1.0?

 

Cheers

Ben

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook
Sent: November-03-15 15:36
To: arslist@ARSLIST.ORG
Subject: Re: ARGetMultipleEntries returning ARERR 552: ORA-00936: missing 
expression

 

** 

I saw something similar on an AI Transformation (MSSQL) that was performing a 
similar function.  I, too, thought it was a space issue.  I removed one 
condition (order by) from the SQL query, and it worked. 

Rick

On Nov 3, 2015 2:33 PM, "Ben Chernys"  wrote:

** 

Hi All,

ARS / ITSM 8.1.0 >>8.1.00 201301251157<< on Cent OS against Oracle 11.2

Interesting trace on this one.  The query worked fine the first go (there is no 
query argument to this f) and ARGetMultipleEntries() picked up 100 records from 
AST:BaseElement.

On the second go of 100 records, the SQL log shows a single SQL repeated 100 
times for each record, and then (for the status history):

ARGetMultipleEntries ==>   
ARGetMultipleEntries ==> /* Tue Nov 03 2015 22:56:51.5891 */SELECT 
entryId,T0,U0,T1,U1,T2,U2,T3,U3,T4,U4,T5,U5,T6,U6,T7
U7,T8,U8,T9,U9,T10,U10,T11,U11,T12,U12,T13,U13 FROM H1572 WHERE entryId   IN)
ARGetMultipleEntries ==>   
ARGetMultipleEntries ==> /* Tue Nov 03 2015 22:56:51.5907 */*** ERROR ***  
ORA-00936: missing expression 

Interestingly, I think it may be related to not enough space allocated for the 
IN expression – as each Id will be more than 15 bytes.  More interestingly, 
this table has 0 records.

The table in Q (schemaid = 1572) is AST:BaseElement – an infamous join J

So, has this been fixed in a server patch?  Has anyone else seen this?

Cheers
Ben Chernys
  www.softwaretoolhouse.com


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

Re: ARGetMultipleEntries returning ARERR 552: ORA-00936: missing expression

[Ben Chernys]

More info:

 

Each AST:BaseElement is picked up with “(E0 = '368' and E1 = 
'120' )” and the successful pick up of the Status History seems to 
be missing some qualification terms:

 

ARGetMultipleEntries ==> /* Tue Nov 03 2015 22:55:57.4055 */SELECT 
entryId,T0,U0,T1,U1,T2,U2,T3,U3,T4,U4,T5,U5,T6,U6,T7,U7,T8,U8,T9,U9,T10,U10,T11,U11,T12,U12,T13,U13
 FROM H1572 WHERE entryId

ARARGetMultipleEntries ==> IN ('001', '002', 
'101', '102', '103', '104', 
'105', '106',

ARGetMultipleEntries ==> '107', '108', 
'109', '110', '111', '112', 
'113', '114',

ARGetMultipleEntries ==> '115', '116', 
'117', '118', '119', '120', 
'121', '122')

 

In the Join SQLs, E1 = NULL is often included.  It seems the IN clause on the 
Status History, is for those CIs where E1 is a real ID only.

 

Ben

 

From: Ben Chernys [mailto:ben.cher...@softwaretoolhouse.com] 
Sent: November-03-15 15:56
To: 'arslist@ARSLIST.ORG'
Subject: RE: ARGetMultipleEntries returning ARERR 552: ORA-00936: missing 
expression

 

Thanks Rick, but that can’t be it.  I am doing NO SQL queries.  ONLY an 
ARGetMuplipleEntries() call – which has no query terms at all – so there’s 
nothing I can adjust – unless BMC publishes source J

 

What’s interesting is that an IN expression was attempted to be generated BUT 
only for the Status History and 100 different SQL selects were done for the 100 
records (which worked).  All this is part of the single ARGetMultipleEntries 
call.

 

The question is – has this been fixed in a patch to 8.1.0?

 

Cheers

Ben

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook
Sent: November-03-15 15:36
To: arslist@ARSLIST.ORG
Subject: Re: ARGetMultipleEntries returning ARERR 552: ORA-00936: missing 
expression

 

** 

I saw something similar on an AI Transformation (MSSQL) that was performing a 
similar function.  I, too, thought it was a space issue.  I removed one 
condition (order by) from the SQL query, and it worked. 

Rick

On Nov 3, 2015 2:33 PM, "Ben Chernys"  wrote:

** 

Hi All,

ARS / ITSM 8.1.0 >>8.1.00 201301251157<< on Cent OS against Oracle 11.2

Interesting trace on this one.  The query worked fine the first go (there is no 
query argument to this f) and ARGetMultipleEntries() picked up 100 records from 
AST:BaseElement.

On the second go of 100 records, the SQL log shows a single SQL repeated 100 
times for each record, and then (for the status history):

ARGetMultipleEntries ==>   
ARGetMultipleEntries ==> /* Tue Nov 03 2015 22:56:51.5891 */SELECT 
entryId,T0,U0,T1,U1,T2,U2,T3,U3,T4,U4,T5,U5,T6,U6,T7
U7,T8,U8,T9,U9,T10,U10,T11,U11,T12,U12,T13,U13 FROM H1572 WHERE entryId   IN)
ARGetMultipleEntries ==>   
ARGetMultipleEntries ==> /* Tue Nov 03 2015 22:56:51.5907 */*** ERROR ***  
ORA-00936: missing expression 

Interestingly, I think it may be related to not enough space allocated for the 
IN expression – as each Id will be more than 15 bytes.  More interestingly, 
this table has 0 records.

The table in Q (schemaid = 1572) is AST:BaseElement – an infamous join J

So, has this been fixed in a server patch?  Has anyone else seen this?

Cheers
Ben Chernys
  www.softwaretoolhouse.com


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

Re: ARGetMultipleEntries returning ARERR 552: ORA-00936: missing expression

[Ben Chernys]

Final points.

 

AST:BaseElement is an Outer Join, so there are many entries with no 
AST:Attributes record.  I just happen to have a block of 100 records from 
100-200 with no AST:Attributes.  If I start my query at 101 or 2, I get record 
201 in the same f() call and so the IN clause is generated correctly with one 
ID.  So, I need only to (manually) ensure that any 100 records with no 
AST:Attributes are not requested in one go.  Ugly but easy enough to work 
around for me.

 

The Status History of AST:BaseElement comes from AST:Attributes, so the bug is 
that if the 100 Ids passed to ARGetMultipleEntries() with all NULL as the 
second ID, the SQL is generated with an invalid IN clause.  This is BMC 
supplied data BTW.

 

Still, any word from BMC that this has been patched?  

 

Cheers

Ben

From: Ben Chernys [mailto:ben.cher...@softwaretoolhouse.com] 
Sent: November-03-15 16:16
To: 'arslist@ARSLIST.ORG'
Subject: RE: ARGetMultipleEntries returning ARERR 552: ORA-00936: missing 
expression

 

More info:

 

Each AST:BaseElement is picked up with “(E0 = '368' and E1 = 
'120' )” and the successful pick up of the Status History seems to 
be missing some qualification terms:

 

ARGetMultipleEntries ==> /* Tue Nov 03 2015 22:55:57.4055 */SELECT 
entryId,T0,U0,T1,U1,T2,U2,T3,U3,T4,U4,T5,U5,T6,U6,T7,U7,T8,U8,T9,U9,T10,U10,T11,U11,T12,U12,T13,U13
 FROM H1572 WHERE entryId

ARARGetMultipleEntries ==> IN ('001', '002', 
'101', '102', '103', '104', 
'105', '106',

ARGetMultipleEntries ==> '107', '108', 
'109', '110', '111', '112', 
'113', '114',

ARGetMultipleEntries ==> '115', '116', 
'117', '118', '119', '120', 
'121', '122')

 

In the Join SQLs, E1 = NULL is often included.  It seems the IN clause on the 
Status History, is for those CIs where E1 is a real ID only.

 

Ben

 

From: Ben Chernys [mailto:ben.cher...@softwaretoolhouse.com] 
Sent: November-03-15 15:56
To: 'arslist@ARSLIST.ORG'
Subject: RE: ARGetMultipleEntries returning ARERR 552: ORA-00936: missing 
expression

 

Thanks Rick, but that can’t be it.  I am doing NO SQL queries.  ONLY an 
ARGetMuplipleEntries() call – which has no query terms at all – so there’s 
nothing I can adjust – unless BMC publishes source J

 

What’s interesting is that an IN expression was attempted to be generated BUT 
only for the Status History and 100 different SQL selects were done for the 100 
records (which worked).  All this is part of the single ARGetMultipleEntries 
call.

 

The question is – has this been fixed in a patch to 8.1.0?

 

Cheers

Ben

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook
Sent: November-03-15 15:36
To: arslist@ARSLIST.ORG
Subject: Re: ARGetMultipleEntries returning ARERR 552: ORA-00936: missing 
expression

 

** 

I saw something similar on an AI Transformation (MSSQL) that was performing a 
similar function.  I, too, thought it was a space issue.  I removed one 
condition (order by) from the SQL query, and it worked. 

Rick

On Nov 3, 2015 2:33 PM, "Ben Chernys"  wrote:

** 

Hi All,

ARS / ITSM 8.1.0 >>8.1.00 201301251157<< on Cent OS against Oracle 11.2

Interesting trace on this one.  The query worked fine the first go (there is no 
query argument to this f) and ARGetMultipleEntries() picked up 100 records from 
AST:BaseElement.

On the second go of 100 records, the SQL log shows a single SQL repeated 100 
times for each record, and then (for the status history):

ARGetMultipleEntries ==>   
ARGetMultipleEntries ==> /* Tue Nov 03 2015 22:56:51.5891 */SELECT 
entryId,T0,U0,T1,U1,T2,U2,T3,U3,T4,U4,T5,U5,T6,U6,T7
U7,T8,U8,T9,U9,T10,U10,T11,U11,T12,U12,T13,U13 FROM H1572 WHERE entryId   IN)
ARGetMultipleEntries ==>   
ARGetMultipleEntries ==> /* Tue Nov 03 2015 22:56:51.5907 */*** ERROR ***  
ORA-00936: missing expression 

Interestingly, I think it may be related to not enough space allocated for the 
IN expression – as each Id will be more than 15 bytes.  More interestingly, 
this table has 0 records.

The table in Q (schemaid = 1572) is AST:BaseElement – an infamous join J

So, has this been fixed in a server patch?  Has anyone else seen this?

Cheers
Ben Chernys
  www.softwaretoolhouse.com


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

Open/Execute exe from Mid Tier

[Karthick S]

Hi All,



Is it possible to execute/open an exe from Remedy Mid - Tier tool?



We have placed an exe file in one of our Remedy Server, i have used Run
Process in Active Link to Perform the action.

Command Line - @@:C:\Program Files\MyTestEXE\MyTestEXE.exe

[image: as.jpg]




Please help me out with your ideas.



Regards,

Karthick S

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

Re: Open/Execute exe from Mid Tier

[Suresh Loganathan]

Hi Karthik,

Can you please try with below syntax.

$Process$ @ServerName: Filepath and Filename.

Regards,
GLS...
On 4 Nov 2015 10:06, "Karthick S"  wrote:

> **
>
> Hi All,
>
>
>
> Is it possible to execute/open an exe from Remedy Mid - Tier tool?
>
>
>
> We have placed an exe file in one of our Remedy Server, i have used Run
> Process in Active Link to Perform the action.
>
> Command Line - @@:C:\Program Files\MyTestEXE\MyTestEXE.exe
>
> [image: as.jpg]
> 
>
>
>
> Please help me out with your ideas.
>
>
>
> Regards,
>
> Karthick S
> _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: Notifications for Purchase Requisitions?

[jjohnson]

Thanks Sandra,

The only notification event I see in the system for the Purchase
Requisition module is:

   - Place Order Notification

And it doesn't appear to be firing when an order is supposed to be placed.

On Tue, Nov 3, 2015 at 10:40 AM Hennigan, Sandra, CTR, DSS [via ARS (Action
Request System)]  wrote:

> In 8.1.01, there are 6 SYS:Notification Messages for the Purchase
> Requisition module:
>
> Assignment
> Re- Assignment
> Place Order Notification
> Purchase Line Item Cancelled
> Purchase Line Item Reduced
> Request Pricing
>
> The Asset management module has other notifications that somewhat blend
> into
> the Change & Purchase Requisition modules. Task notifications can make up
> another block of messages.
>
> Thank you,
>
> Sandra
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[hidden email]
> ] On Behalf Of
> jjohnson
> Sent: Tuesday, November 03, 2015 9:43 AM
> To: [hidden email] 
> Subject: Notifications for Purchase Requisitions?
>
> Is there a reason that there are no notifications for the purchase
> requisition module anymore? How are the various roles supposed to know
> that
> a record is available for them to work on?
>
>
>
> --
> View this message in context:
>
> http://ars-action-request-system.1.n7.nabble.com/Notifications-for-Purchase-
> Requisitions-tp123309.html
> Sent from the ARS (Action Request System) mailing list archive at
> Nabble.com.
>
> 
>
> ___
> 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"
>
> *smime.p7s* (7K) Download Attachment
> 
>
>
> --
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://ars-action-request-system.1.n7.nabble.com/Notifications-for-Purchase-Requisitions-tp123309p123310.html
> To unsubscribe from Notifications for Purchase Requisitions?, click here
> 
> .
> NAML
> 
>




--
View this message in context: 
http://ars-action-request-system.1.n7.nabble.com/Notifications-for-Purchase-Requisitions-tp123309p123311.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

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

SLM Import is not working in 9.00 (long, sorry)

[William Rentfrow]

System: SuSe Linux on Oracle 11g RAC remote, non-root install

I have been trying for the better part of a week to get the SLM Import process 
to work.  I have been through literally every KB, community entry, and ARS List 
history (of which I have about 8 years saved and indexed).  Still no go.

So far I have done the following:


1.   Confirmed the path to arimportcmd under the SLM preferences

2.   Verified arimportcmd existed in the above directory and could execute

3.   Tried both with and without the AR install path under SLM preferences

4.   Checked the plugin configuration related to SLM plugins

5.   Verified entries are going into Application Pending when doing other 
stuff than importing, to make sure that the Business Rules engine is alive and 
processing

6.   Took apart the server group and limited it to one server to ensure it 
was hitting the admin server when connecting

7.   Tried creating custom directories for the import/export process which 
are chmod to 777 (full access for everyone) - no luck.

8.   Verified the environment variable for BMC_SLM_HOME did not have extra 
double quotes around it

Here are the only clues I have to the problem - a log file is attached with 
full information (server names and install paths changed to protect customer 
privacy):


1.   When runnning the import command from the log file manually I get this 
return:
log4j:WARN No appenders could be found for logger (com.bmc.arsys.apiext.data).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more 
info.

2.   When I look into the attached log file I see it referencing a file 
that does not exist.  The full command is this:

a.   
/installdir/a00/apps/BMCServiceLevelManagement/BMCSLMInstallJVM/bin/java" 
-DisRik=1 -cp 
"/installdir/a00/ar/api/lib/arapi90_build001.jar:/installdir/a00/ar/api/lib/arapiext90_build001.jar:/installdir/a00/ar/api/lib/log4j-1.2.14.jar:/installdir/a00/ar/pluginsvr/activation.jar"
 com.bmc.arsys.apiext.data.DataImport -h 1 -g 1 -x "someservername" -u "Remedy 
Application Service" -z "/tmp/SLMIMPORT17341-2055220641/cmdDataImport.xml" -l 
"/tmp/SLMIMPORT17341-2055220641/dataImport.log" -a 7900

3.   The file"/tmp/SLMIMPORT17341-2055220641/cmdDataImport.xml" does not 
exist on the server

4.   There is no file named cmdDataImport.xml anywhere on the server - 
hence, I suspect it's supposed to be constructed on the fly from the ARX file 
created by the SLM Export process.

5.   Also, I don't know why this is writing to /tmp when we do not have 
that specified in our environment variables anywhere.

6.   The errors I get in the log are consistent and have not changed since 
day one - see below

11:51:41 02 Nov 2015 Begin SLM Import/Export/Delete Utility.
11:51:41 02 Nov 2015
11:51:41 02 Nov 2015 Input Parameter: COMMAND   = Import
11:51:41 02 Nov 2015 Input Parameter: SERVER= someservername
11:51:41 02 Nov 2015 Input Parameter: TCPPORT   = 7900
11:51:41 02 Nov 2015 Input Parameter: OVERWRITE = No
11:51:41 02 Nov 2015 AR Install Path= /installdir/a00/ar/bin
11:51:41 02 Nov 2015 AR Config Path = 
/installdir/a00/ar/bin/conf
11:51:41 02 Nov 2015 Input Parameter: DATA-FILE = 
/installdir/a00/tmp/1026slm.arx
11:51:41 02 Nov 2015 Input Parameter: LOG-FILE  = 
/installdir/a00/tmp/slmlog3.log
11:51:41 02 Nov 2015
11:51:42 02 Nov 2015 Initialized access to AR system.

11:51:42 02 Nov 2015 Unable to retrieve schema data for form 
 rtn<2>
11:51:42 02 Nov 2015 Unable to retrieve schema data for form  rtn<2>
11:51:42 02 Nov 2015 Unable to retrieve schema data for form 
 rtn<2>
11:51:42 02 Nov 2015 Unable to retrieve schema data for form 
 rtn<2>
11:51:42 02 Nov 2015 Unable to retrieve schema data for form 
 rtn<2>
11:51:42 02 Nov 2015 Unable to retrieve schema data for form  
rtn<2>
11:51:42 02 Nov 2015 Unable to retrieve schema data for form  rtn<2>
11:51:42 02 Nov 2015 Unable to retrieve schema data for form  
rtn<2>
11:51:42 02 Nov 2015 Unable to retrieve schema data for form 
 rtn<2>
11:51:42 02 Nov 2015 Unable to retrieve schema data for form 
 rtn<2>
11:51:42 02 Nov 2015 Unable to retrieve schema data for form  
rtn<2>
11:51:42 02 Nov 2015 Unable to retrieve schema data for form  rtn<2>
11:51:42 02 Nov 2015 Unable to retrieve schema data for form 
 rtn<2>
11:51:42 02 Nov 2015 Unable to retrieve schema data for form 
 rtn<2>
11:51:42 02 Nov 2015 Unable to retrieve schema data for form  
rtn<2>
11:51:42 02 Nov 2015 Unable to retrieve schema data for form  rtn<2>
11:51:42 02 Nov 2015 Unable to retrieve schema data for form 
 rtn<2>
11:51:42 02 Nov 2015 Unable to retrieve schema data for form 
 rtn<2>
11:51:42 02 Nov 2015 Unable to retrieve schema data for form  
rtn<2>
11:51:42 02 Nov 2015 Status - Begin importing SLM Meta Data.
11:51:42 02 Nov 2015 About to parse arx
11:52:17 02 Nov 2015