RE: Escalation Error

[Hiremath, Raj]

I guess you are making an equal to query on clob data type.
What all is on stack on AR?

Esclation+API+SQL logs may help find the piece.

From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Brittain, Mark
Sent: 19 September 2018 02:02
To: ARList (arslist@ARSLIST.ORG) 
Subject: Escalation Error

HI All

I am seeing two strange escalation errors that I can't identify based on the 
logs.

An application command failed.ERROR (552): The SQL database operation failed.; 
ORA-00932: inconsistent datatypes: expected - got CLOB`

Error while performing escalation action

Both are in pool 1.

I have been able to rule out any custom escalations, very few, and am hoping 
not to have to check each OTB escalation if hopes of finding the bad guys. Has 
anyone encountered this.

ARS 9.1.4.

Thanks
Mark

Mark Brittain  | Senior Systems Engineer | 315.634.9337
125 Elwood Davis Road | Syracuse NY 13212
[new_spectrum]

-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Escalation Error

[Brittain, Mark]

HI All

I am seeing two strange escalation errors that I can't identify based on the 
logs.

An application command failed.ERROR (552): The SQL database operation failed.; 
ORA-00932: inconsistent datatypes: expected - got CLOB`

Error while performing escalation action

Both are in pool 1.

I have been able to rule out any custom escalations, very few, and am hoping 
not to have to check each OTB escalation if hopes of finding the bad guys. Has 
anyone encountered this.

ARS 9.1.4.

Thanks
Mark

Mark Brittain  | Senior Systems Engineer | 315.634.9337
125 Elwood Davis Road | Syracuse NY 13212
[new_spectrum]

-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: Getting error when creating/updating a CI.

[Ravindrakumar Rodge]

The logs you posted is client side workflow logs. You would get details in
server side API,SQL, logs. As this setting is something related to DB. You
will find more information about it in SQL logs.
So you should capture API,SQL,FLTR logs at server side and look for the
error.

Regards,
Ravindrakumar

On Fri, Mar 23, 2018 at 5:16 AM, Harsh <chaudhar...@gmail.com> wrote:

> Hi Ravindra,
>
> As this is specific to CI's and we are not getting the same issue while
> creating updating incident, problem or change therefore this doesn't seems
> to be related with the database.
>
> I already went through the logs but didn't got much information.
>
> Regards,
> Harsh
>
> On Fri, Mar 23, 2018 at 3:34 PM, Ravindrakumar Rodge <raviru...@gmail.com>
> wrote:
>
>> Can you capture API,SQL,FLTR logs and reproduce the issue. Did you also
>> check with restarting of DB services once?
>> What is the DB configuration set. SNAPSHOT ISOLATION &
>> IS_READ_COMMITTED_ON at DB level.
>>
>> https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdc
>> id=kA21400d6dhCAA=Solution
>>
>>
>>
>> Regards,
>> Ravindrakumar
>>
>> On Fri, Mar 23, 2018 at 2:34 AM, Harsh <chaudhar...@gmail.com> wrote:
>>
>>> Hi Ravindra,
>>>
>>> I have also checked the same and it is set to OFF.
>>>
>>> Regards,
>>> Harsh
>>>
>>> On Thu, Mar 22, 2018 at 8:04 PM, Ravindrakumar Rodge <
>>> raviru...@gmail.com> wrote:
>>>
>>>> Also verify the  CONCAT_NULL_YIELDS_NULL at the DB level what it is
>>>> set?
>>>>
>>>> Remedy set's it OFF.
>>>>
>>>> SET CONCAT_NULL_YIELDS_NULL OFF
>>>>
>>>>
>>>> https://docs.bmc.com/docs/ars91/en/viewing-database-audit-re
>>>> cords-609073965.html
>>>>
>>>> Regards,
>>>> Ravindrakumar
>>>>
>>>>
>>>> On Thu, Mar 22, 2018 at 9:32 AM, Ravindrakumar Rodge <
>>>> raviru...@gmail.com> wrote:
>>>>
>>>>> Are there any triggers defined on the database. If so disable those
>>>>> and try.
>>>>>
>>>>> https://communities.bmc.com/docs/DOC-88206
>>>>>
>>>>> https://communities.bmc.com/docs/DOC-80610
>>>>>
>>>>> Thanks.
>>>>>
>>>>> Regards,
>>>>> Ravindrakumar
>>>>>
>>>>>
>>>>>
>>>>> On Thu, Mar 22, 2018 at 7:22 AM, Harsh <chaudhar...@gmail.com> wrote:
>>>>>
>>>>>> Hi Guys,
>>>>>>
>>>>>> We are getting SQL error while creating/updating any ci record in
>>>>>> Remedy 8.1 sp2.
>>>>>>
>>>>>> ARERR [552] The SQL database operation failed. : UPDATE failed
>>>>>> because the following SET options have incorrect settings:
>>>>>> 'CONCAT_NULL_YIELDS_NULL'. Verify that SET options are correct for use 
>>>>>> with
>>>>>> indexed views and/or indexes on computed columns and/or filtered indexes
>>>>>> and/or query notifications and/or
>>>>>>
>>>>>> We checked the filter and sql log but didn't find any relevant
>>>>>> workflow which can cause this error.
>>>>>>
>>>>>> */UPDATE T564 SET C8=N'Unigy360_Offering_excel1'
>>>>>> ,C179=N'OI-2dfb1a20b56c43dcb13b1ba0cd4ad72a',C530032500=0,C5
>>>>>> 30060100=40,C112=N';1000292803;10;',C5=N'chaudhah',C6=1521714379
>>>>>> WHERE C1 = N'4149295' AND ((C6 <= 1521714326) OR (C5 = 
>>>>>> N'chaudhah'))
>>>>>>
>>>>>>  >>>>>  >  /* Thu Mar 22 2018 10:26:19.7740 */*** 
>>>>>> ERROR
>>>>>> ***  UPDATE failed because the following SET options have incorrect
>>>>>> settings: 'CONCAT_NULL_YIELDS_NULL'. Verify that SET options are correct
>>>>>> for use with indexed views and/or indexes on computed columns and/or
>>>>>> filtered indexes and/or query notifications and/or
>>>>>>
>>>>>>  >>>>>  >  /* Thu Mar 22 2018 10:26:19.7740 
>>>>>> */ROLLBACK
>>>>>> TRANSACTION
>>>>>>
>>>>>>
>>>>>> --
>>>>>> *Thanks & regards*
>>>>>> *“Harsh Chaudhary”*
>>>>>> *"Impatience never commanded success**"*
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> ARSList mailing list
>>>>>> ARSList@arslist.org
>>>>>> https://mailman.rrr.se/cgi/listinfo/arslist
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> With Regards,
>>>>> Ravindrakumar M Rodge
>>>>> 9028792208 <(902)%20879-2208>
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> With Regards,
>>>> Ravindrakumar M Rodge
>>>> 9028792208 <(902)%20879-2208>
>>>>
>>>> --
>>>> ARSList mailing list
>>>> ARSList@arslist.org
>>>> https://mailman.rrr.se/cgi/listinfo/arslist
>>>>
>>>>
>>>
>>>
>>> --
>>> *Thanks & regards*
>>> *“Harsh Chaudhary”*
>>> *"Impatience never commanded success**"*
>>>
>>>
>>>
>>> --
>>> ARSList mailing list
>>> ARSList@arslist.org
>>> https://mailman.rrr.se/cgi/listinfo/arslist
>>>
>>>
>>
>>
>> --
>> With Regards,
>> Ravindrakumar M Rodge
>> 9028792208 <(902)%20879-2208>
>>
>> --
>> ARSList mailing list
>> ARSList@arslist.org
>> https://mailman.rrr.se/cgi/listinfo/arslist
>>
>>
>
>
> --
> *Thanks & regards*
> *“Harsh Chaudhary”*
> *"Impatience never commanded success**"*
>
>
>
> --
> ARSList mailing list
> ARSList@arslist.org
> https://mailman.rrr.se/cgi/listinfo/arslist
>
>


-- 
With Regards,
Ravindrakumar M Rodge
9028792208
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: Getting error when creating/updating a CI.

[Ravindrakumar Rodge]

Can you capture API,SQL,FLTR logs and reproduce the issue. Did you also
check with restarting of DB services once?
What is the DB configuration set. SNAPSHOT ISOLATION & IS_READ_COMMITTED_ON
at DB level.

https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdcid=kA21400d6dhCAA=Solution



Regards,
Ravindrakumar

On Fri, Mar 23, 2018 at 2:34 AM, Harsh <chaudhar...@gmail.com> wrote:

> Hi Ravindra,
>
> I have also checked the same and it is set to OFF.
>
> Regards,
> Harsh
>
> On Thu, Mar 22, 2018 at 8:04 PM, Ravindrakumar Rodge <raviru...@gmail.com>
> wrote:
>
>> Also verify the  CONCAT_NULL_YIELDS_NULL at the DB level what it is set?
>>
>> Remedy set's it OFF.
>>
>> SET CONCAT_NULL_YIELDS_NULL OFF
>>
>>
>> https://docs.bmc.com/docs/ars91/en/viewing-database-audit-
>> records-609073965.html
>>
>> Regards,
>> Ravindrakumar
>>
>>
>> On Thu, Mar 22, 2018 at 9:32 AM, Ravindrakumar Rodge <raviru...@gmail.com
>> > wrote:
>>
>>> Are there any triggers defined on the database. If so disable those and
>>> try.
>>>
>>> https://communities.bmc.com/docs/DOC-88206
>>>
>>> https://communities.bmc.com/docs/DOC-80610
>>>
>>> Thanks.
>>>
>>> Regards,
>>> Ravindrakumar
>>>
>>>
>>>
>>> On Thu, Mar 22, 2018 at 7:22 AM, Harsh <chaudhar...@gmail.com> wrote:
>>>
>>>> Hi Guys,
>>>>
>>>> We are getting SQL error while creating/updating any ci record in
>>>> Remedy 8.1 sp2.
>>>>
>>>> ARERR [552] The SQL database operation failed. : UPDATE failed because
>>>> the following SET options have incorrect settings:
>>>> 'CONCAT_NULL_YIELDS_NULL'. Verify that SET options are correct for use with
>>>> indexed views and/or indexes on computed columns and/or filtered indexes
>>>> and/or query notifications and/or
>>>>
>>>> We checked the filter and sql log but didn't find any relevant workflow
>>>> which can cause this error.
>>>>
>>>> */UPDATE T564 SET C8=N'Unigy360_Offering_excel1'
>>>> ,C179=N'OI-2dfb1a20b56c43dcb13b1ba0cd4ad72a',C530032500=0,C5
>>>> 30060100=40,C112=N';1000292803;10;',C5=N'chaudhah',C6=1521714379
>>>> WHERE C1 = N'4149295' AND ((C6 <= 1521714326) OR (C5 = 
>>>> N'chaudhah'))
>>>>
>>>>  >>>  >  /* Thu Mar 22 2018 10:26:19.7740 */*** ERROR
>>>> ***  UPDATE failed because the following SET options have incorrect
>>>> settings: 'CONCAT_NULL_YIELDS_NULL'. Verify that SET options are correct
>>>> for use with indexed views and/or indexes on computed columns and/or
>>>> filtered indexes and/or query notifications and/or
>>>>
>>>>  >>>  >  /* Thu Mar 22 2018 10:26:19.7740 */ROLLBACK
>>>> TRANSACTION
>>>>
>>>>
>>>> --
>>>> *Thanks & regards*
>>>> *“Harsh Chaudhary”*
>>>> *"Impatience never commanded success**"*
>>>>
>>>>
>>>>
>>>> --
>>>> ARSList mailing list
>>>> ARSList@arslist.org
>>>> https://mailman.rrr.se/cgi/listinfo/arslist
>>>>
>>>>
>>>
>>>
>>> --
>>> With Regards,
>>> Ravindrakumar M Rodge
>>> 9028792208 <(902)%20879-2208>
>>>
>>
>>
>>
>> --
>> With Regards,
>> Ravindrakumar M Rodge
>> 9028792208 <(902)%20879-2208>
>>
>> --
>> ARSList mailing list
>> ARSList@arslist.org
>> https://mailman.rrr.se/cgi/listinfo/arslist
>>
>>
>
>
> --
> *Thanks & regards*
> *“Harsh Chaudhary”*
> *"Impatience never commanded success**"*
>
>
>
> --
> ARSList mailing list
> ARSList@arslist.org
> https://mailman.rrr.se/cgi/listinfo/arslist
>
>


-- 
With Regards,
Ravindrakumar M Rodge
9028792208
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: Getting error when creating/updating a CI.

[Harsh]

Hi Ravindra,

I have also checked the same and it is set to OFF.

Regards,
Harsh

On Thu, Mar 22, 2018 at 8:04 PM, Ravindrakumar Rodge <raviru...@gmail.com>
wrote:

> Also verify the  CONCAT_NULL_YIELDS_NULL at the DB level what it is set?
>
> Remedy set's it OFF.
>
> SET CONCAT_NULL_YIELDS_NULL OFF
>
>
> https://docs.bmc.com/docs/ars91/en/viewing-database-
> audit-records-609073965.html
>
> Regards,
> Ravindrakumar
>
>
> On Thu, Mar 22, 2018 at 9:32 AM, Ravindrakumar Rodge <raviru...@gmail.com>
> wrote:
>
>> Are there any triggers defined on the database. If so disable those and
>> try.
>>
>> https://communities.bmc.com/docs/DOC-88206
>>
>> https://communities.bmc.com/docs/DOC-80610
>>
>> Thanks.
>>
>> Regards,
>> Ravindrakumar
>>
>>
>>
>> On Thu, Mar 22, 2018 at 7:22 AM, Harsh <chaudhar...@gmail.com> wrote:
>>
>>> Hi Guys,
>>>
>>> We are getting SQL error while creating/updating any ci record in Remedy
>>> 8.1 sp2.
>>>
>>> ARERR [552] The SQL database operation failed. : UPDATE failed because
>>> the following SET options have incorrect settings:
>>> 'CONCAT_NULL_YIELDS_NULL'. Verify that SET options are correct for use with
>>> indexed views and/or indexes on computed columns and/or filtered indexes
>>> and/or query notifications and/or
>>>
>>> We checked the filter and sql log but didn't find any relevant workflow
>>> which can cause this error.
>>>
>>> */UPDATE T564 SET C8=N'Unigy360_Offering_excel1'
>>> ,C179=N'OI-2dfb1a20b56c43dcb13b1ba0cd4ad72a',C530032500=0,C5
>>> 30060100=40,C112=N';1000292803;10;',C5=N'chaudhah',C6=1521714379
>>> WHERE C1 = N'4149295' AND ((C6 <= 1521714326) OR (C5 = N'chaudhah'))
>>>
>>>  >>  >  /* Thu Mar 22 2018 10:26:19.7740 */*** ERROR
>>> ***  UPDATE failed because the following SET options have incorrect
>>> settings: 'CONCAT_NULL_YIELDS_NULL'. Verify that SET options are correct
>>> for use with indexed views and/or indexes on computed columns and/or
>>> filtered indexes and/or query notifications and/or
>>>
>>>  >>  >  /* Thu Mar 22 2018 10:26:19.7740 */ROLLBACK
>>> TRANSACTION
>>>
>>>
>>> --
>>> *Thanks & regards*
>>> *“Harsh Chaudhary”*
>>> *"Impatience never commanded success**"*
>>>
>>>
>>>
>>> --
>>> ARSList mailing list
>>> ARSList@arslist.org
>>> https://mailman.rrr.se/cgi/listinfo/arslist
>>>
>>>
>>
>>
>> --
>> With Regards,
>> Ravindrakumar M Rodge
>> 9028792208 <(902)%20879-2208>
>>
>
>
>
> --
> With Regards,
> Ravindrakumar M Rodge
> 9028792208 <(902)%20879-2208>
>
> --
> ARSList mailing list
> ARSList@arslist.org
> https://mailman.rrr.se/cgi/listinfo/arslist
>
>


-- 
*Thanks & regards*
*“Harsh Chaudhary”*
*"Impatience never commanded success**"*
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: Getting error when creating/updating a CI.

[Harsh]

Hi Ravindra,

We don't have any triggers written on database. Also we also checked the
form definition and it is also accurate.

Regards,
Harsh

On Thu, Mar 22, 2018 at 8:02 PM, Ravindrakumar Rodge <raviru...@gmail.com>
wrote:

> Are there any triggers defined on the database. If so disable those and
> try.
>
> https://communities.bmc.com/docs/DOC-88206
>
> https://communities.bmc.com/docs/DOC-80610
>
> Thanks.
>
> Regards,
> Ravindrakumar
>
>
>
> On Thu, Mar 22, 2018 at 7:22 AM, Harsh <chaudhar...@gmail.com> wrote:
>
>> Hi Guys,
>>
>> We are getting SQL error while creating/updating any ci record in Remedy
>> 8.1 sp2.
>>
>> ARERR [552] The SQL database operation failed. : UPDATE failed because
>> the following SET options have incorrect settings:
>> 'CONCAT_NULL_YIELDS_NULL'. Verify that SET options are correct for use with
>> indexed views and/or indexes on computed columns and/or filtered indexes
>> and/or query notifications and/or
>>
>> We checked the filter and sql log but didn't find any relevant workflow
>> which can cause this error.
>>
>> */UPDATE T564 SET C8=N'Unigy360_Offering_excel1'
>> ,C179=N'OI-2dfb1a20b56c43dcb13b1ba0cd4ad72a',C530032500=0,
>> C530060100=40,C112=N';1000292803;10;',C5=N'chaudhah',C6=1521714379
>> WHERE C1 = N'4149295' AND ((C6 <= 1521714326) OR (C5 = N'chaudhah'))
>>
>>  >  >  /* Thu Mar 22 2018 10:26:19.7740 */*** ERROR
>> ***  UPDATE failed because the following SET options have incorrect
>> settings: 'CONCAT_NULL_YIELDS_NULL'. Verify that SET options are correct
>> for use with indexed views and/or indexes on computed columns and/or
>> filtered indexes and/or query notifications and/or
>>
>>  >  >  /* Thu Mar 22 2018 10:26:19.7740 */ROLLBACK
>> TRANSACTION
>>
>>
>> --
>> *Thanks & regards*
>> *“Harsh Chaudhary”*
>> *"Impatience never commanded success**"*
>>
>>
>>
>> --
>> ARSList mailing list
>> ARSList@arslist.org
>> https://mailman.rrr.se/cgi/listinfo/arslist
>>
>>
>
>
> --
> With Regards,
> Ravindrakumar M Rodge
> 9028792208 <(902)%20879-2208>
>
> --
> ARSList mailing list
> ARSList@arslist.org
> https://mailman.rrr.se/cgi/listinfo/arslist
>
>


-- 
*Thanks & regards*
*“Harsh Chaudhary”*
*"Impatience never commanded success**"*
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: Getting error when creating/updating a CI.

[Ravindrakumar Rodge]

Also verify the  CONCAT_NULL_YIELDS_NULL at the DB level what it is set?

Remedy set's it OFF.

SET CONCAT_NULL_YIELDS_NULL OFF


https://docs.bmc.com/docs/ars91/en/viewing-database-audit-records-609073965.html

Regards,
Ravindrakumar


On Thu, Mar 22, 2018 at 9:32 AM, Ravindrakumar Rodge <raviru...@gmail.com>
wrote:

> Are there any triggers defined on the database. If so disable those and
> try.
>
> https://communities.bmc.com/docs/DOC-88206
>
> https://communities.bmc.com/docs/DOC-80610
>
> Thanks.
>
> Regards,
> Ravindrakumar
>
>
>
> On Thu, Mar 22, 2018 at 7:22 AM, Harsh <chaudhar...@gmail.com> wrote:
>
>> Hi Guys,
>>
>> We are getting SQL error while creating/updating any ci record in Remedy
>> 8.1 sp2.
>>
>> ARERR [552] The SQL database operation failed. : UPDATE failed because
>> the following SET options have incorrect settings:
>> 'CONCAT_NULL_YIELDS_NULL'. Verify that SET options are correct for use with
>> indexed views and/or indexes on computed columns and/or filtered indexes
>> and/or query notifications and/or
>>
>> We checked the filter and sql log but didn't find any relevant workflow
>> which can cause this error.
>>
>> */UPDATE T564 SET C8=N'Unigy360_Offering_excel1'
>> ,C179=N'OI-2dfb1a20b56c43dcb13b1ba0cd4ad72a',C530032500=0,
>> C530060100=40,C112=N';1000292803;10;',C5=N'chaudhah',C6=1521714379
>> WHERE C1 = N'4149295' AND ((C6 <= 1521714326) OR (C5 = N'chaudhah'))
>>
>>  >  >  /* Thu Mar 22 2018 10:26:19.7740 */*** ERROR
>> ***  UPDATE failed because the following SET options have incorrect
>> settings: 'CONCAT_NULL_YIELDS_NULL'. Verify that SET options are correct
>> for use with indexed views and/or indexes on computed columns and/or
>> filtered indexes and/or query notifications and/or
>>
>>  >  >  /* Thu Mar 22 2018 10:26:19.7740 */ROLLBACK
>> TRANSACTION
>>
>>
>> --
>> *Thanks & regards*
>> *“Harsh Chaudhary”*
>> *"Impatience never commanded success**"*
>>
>>
>>
>> --
>> ARSList mailing list
>> ARSList@arslist.org
>> https://mailman.rrr.se/cgi/listinfo/arslist
>>
>>
>
>
> --
> With Regards,
> Ravindrakumar M Rodge
> 9028792208
>



-- 
With Regards,
Ravindrakumar M Rodge
9028792208
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: Getting error when creating/updating a CI.

[Ravindrakumar Rodge]

Are there any triggers defined on the database. If so disable those and try.

https://communities.bmc.com/docs/DOC-88206

https://communities.bmc.com/docs/DOC-80610

Thanks.

Regards,
Ravindrakumar



On Thu, Mar 22, 2018 at 7:22 AM, Harsh <chaudhar...@gmail.com> wrote:

> Hi Guys,
>
> We are getting SQL error while creating/updating any ci record in Remedy
> 8.1 sp2.
>
> ARERR [552] The SQL database operation failed. : UPDATE failed because the
> following SET options have incorrect settings: 'CONCAT_NULL_YIELDS_NULL'.
> Verify that SET options are correct for use with indexed views and/or
> indexes on computed columns and/or filtered indexes and/or query
> notifications and/or
>
> We checked the filter and sql log but didn't find any relevant workflow
> which can cause this error.
>
> */UPDATE T564 SET C8=N'Unigy360_Offering_excel1',C179=N'OI-
> 2dfb1a20b56c43dcb13b1ba0cd4ad72a',C530032500=0,C530060100=
> 40,C112=N';1000292803;10;',C5=N'chaudhah',C6=1521714379 WHERE C1
> = N'4149295' AND ((C6 <= 1521714326) OR (C5 = N'chaudhah'))
>
>>  /* Thu Mar 22 2018 10:26:19.7740 */*** ERROR
> ***  UPDATE failed because the following SET options have incorrect
> settings: 'CONCAT_NULL_YIELDS_NULL'. Verify that SET options are correct
> for use with indexed views and/or indexes on computed columns and/or
> filtered indexes and/or query notifications and/or
>
>>  /* Thu Mar 22 2018 10:26:19.7740 */ROLLBACK
> TRANSACTION
>
>
> --
> *Thanks & regards*
> *“Harsh Chaudhary”*
> *"Impatience never commanded success**"*
>
>
>
> --
> ARSList mailing list
> ARSList@arslist.org
> https://mailman.rrr.se/cgi/listinfo/arslist
>
>


-- 
With Regards,
Ravindrakumar M Rodge
9028792208
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Getting error when creating/updating a CI.

[Harsh]

Hi Guys,

We are getting SQL error while creating/updating any ci record in Remedy
8.1 sp2.

ARERR [552] The SQL database operation failed. : UPDATE failed because the
following SET options have incorrect settings: 'CONCAT_NULL_YIELDS_NULL'.
Verify that SET options are correct for use with indexed views and/or
indexes on computed columns and/or filtered indexes and/or query
notifications and/or

We checked the filter and sql log but didn't find any relevant workflow
which can cause this error.

*/UPDATE T564 SET
C8=N'Unigy360_Offering_excel1',C179=N'OI-2dfb1a20b56c43dcb13b1ba0cd4ad72a',C530032500=0,C530060100=40,C112=N';1000292803;10;',C5=N'chaudhah',C6=1521714379
WHERE C1 = N'4149295' AND ((C6 <= 1521714326) OR (C5 = N'chaudhah'))
   
   /* Thu Mar 22 2018 10:26:19.7740 */*** ERROR
***  UPDATE failed because the following SET options have incorrect
settings: 'CONCAT_NULL_YIELDS_NULL'. Verify that SET options are correct
for use with indexed views and/or indexes on computed columns and/or
filtered indexes and/or query notifications and/or
   
   /* Thu Mar 22 2018 10:26:19.7740 */ROLLBACK
TRANSACTION


-- 
*Thanks & regards*
*“Harsh Chaudhary”*
*"Impatience never commanded success**"*
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: Google Chrome and Advanced Search error

[LJ LongWing]

Tauf,
I think the issue he's dealing with is not a blocking, but a
truncating.more than likely he will find that if he uses something like
Fiddler to look at the backchannel calls that are being made, his Chrome is
not allowing the full URL to be played out to the Mid-Tier server whereas
the other browsers are, and that's what's causing the issue at hand.

On Fri, Feb 9, 2018 at 3:51 PM, Tauf Chowdhury <taufc...@gmail.com> wrote:

> It actually sounds like the Chrome build you are using is blocking an HTTP
> request causing the 404 error. You can try disabling some security features
> to see if that works.
>
> Sent from my iPhone
>
> On Feb 9, 2018, at 5:20 PM, Joel D Sender <jdsen...@earthlink.net> wrote:
>
> I usually see that message when a slow server appears to have timed-out,
> or after a long period of inactivity (on my part).
>
> You can wait for the server to respond, or hit refresh.
>
> HTH,
>
> *Joel*
>
> Joel Sender  *   jdsen...@earthlink.net
>
>
>
> *From:* ARSList [mailto:arslist-boun...@arslist.org
> <arslist-boun...@arslist.org>] *On Behalf Of *Fawver, Dustin
> *Sent:* Friday, February 9, 2018 1:30 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Google Chrome and Advanced Search error
>
>
>
> Greetings!
>
>
>
> I’m sending this out to see if anyone else has encountered this.  Part of
> what I have to do involves long strings in the Advanced Search field.
> Normally this is not a problem.  Recently I’ve encountered this error in
> Google Chrome when trying to run a search with a string that’s a little
> over 1k characters long.
>
>
>
> 
>
>
>
> Firefox and MS Edge have no issues with processing the string.  Before
> this error occurs, there’s an empty pop-up window that hangs there for
> about 5 seconds.  Right now I have a single AR and Mid-Tier server, so the
> load balancing things that I saw when searching wouldn’t apply.  Nothing’s
> changed on the server aside from Windows updates.  Fortunately this really
> isn’t affecting anyone else but me and of course there’s an easy workaround.
>
>
>
> Thanks!
>
> Dustin Fawver
>
> Sr. Help Desk Technician
>
> Information Technology Services
>
>
>
> P: 423-439-4648 <(423)%20439-4648>
>
> itsh...@etsu.edu
>
>  <http://www.etsu.edu/helpdesk>
>
>
>
>
> <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient_term=icon>
>  Virus-free.
> www.avast.com
> <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient_term=link>
> <#m_-6331059606662127474_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
> --
> ARSList mailing list
> ARSList@arslist.org
> https://mailman.rrr.se/cgi/listinfo/arslist
>
>
> --
> ARSList mailing list
> ARSList@arslist.org
> https://mailman.rrr.se/cgi/listinfo/arslist
>
>
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: Google Chrome and Advanced Search error

[Tauf Chowdhury]

It actually sounds like the Chrome build you are using is blocking an HTTP 
request causing the 404 error. You can try disabling some security features to 
see if that works. 

Sent from my iPhone

> On Feb 9, 2018, at 5:20 PM, Joel D Sender <jdsen...@earthlink.net> wrote:
> 
> I usually see that message when a slow server appears to have timed-out, or 
> after a long period of inactivity (on my part).
> You can wait for the server to respond, or hit refresh.
> HTH,
> Joel
> Joel Sender  *   jdsen...@earthlink.net 
>  
> From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Fawver, Dustin
> Sent: Friday, February 9, 2018 1:30 PM
> To: arslist@ARSLIST.ORG
> Subject: Google Chrome and Advanced Search error
>  
> Greetings!
>  
> I’m sending this out to see if anyone else has encountered this.  Part of 
> what I have to do involves long strings in the Advanced Search field.  
> Normally this is not a problem.  Recently I’ve encountered this error in 
> Google Chrome when trying to run a search with a string that’s a little over 
> 1k characters long.
>  
> 
>  
> Firefox and MS Edge have no issues with processing the string.  Before this 
> error occurs, there’s an empty pop-up window that hangs there for about 5 
> seconds.  Right now I have a single AR and Mid-Tier server, so the load 
> balancing things that I saw when searching wouldn’t apply.  Nothing’s changed 
> on the server aside from Windows updates.  Fortunately this really isn’t 
> affecting anyone else but me and of course there’s an easy workaround.
>  
> Thanks!
> Dustin Fawver
> Sr. Help Desk Technician
> Information Technology Services
>  
> P: 423-439-4648
> itsh...@etsu.edu
> 
>  
> 
>   Virus-free. www.avast.com
> -- 
> ARSList mailing list
> ARSList@arslist.org
> https://mailman.rrr.se/cgi/listinfo/arslist
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

RE: Google Chrome and Advanced Search error

[Joel D Sender]

I usually see that message when a slow server appears to have timed-out, or
after a long period of inactivity (on my part).

You can wait for the server to respond, or hit refresh.

HTH,

Joel

Joel Sender  *<mailto:jdsen...@earthlink.net> jdsen...@earthlink.net  

 

From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Fawver,
Dustin
Sent: Friday, February 9, 2018 1:30 PM
To: arslist@ARSLIST.ORG
Subject: Google Chrome and Advanced Search error

 

Greetings!

 

I'm sending this out to see if anyone else has encountered this.  Part of
what I have to do involves long strings in the Advanced Search field.
Normally this is not a problem.  Recently I've encountered this error in
Google Chrome when trying to run a search with a string that's a little over
1k characters long.

 



 

Firefox and MS Edge have no issues with processing the string.  Before this
error occurs, there's an empty pop-up window that hangs there for about 5
seconds.  Right now I have a single AR and Mid-Tier server, so the load
balancing things that I saw when searching wouldn't apply.  Nothing's
changed on the server aside from Windows updates.  Fortunately this really
isn't affecting anyone else but me and of course there's an easy workaround.

 

Thanks!

Dustin Fawver

Sr. Help Desk Technician

Information Technology Services

 

P: 423-439-4648

itsh...@etsu.edu

 <http://www.etsu.edu/helpdesk> itslogo

 



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Google Chrome and Advanced Search error

[Fawver, Dustin]

Greetings!

I'm sending this out to see if anyone else has encountered this.  Part of what 
I have to do involves long strings in the Advanced Search field.  Normally this 
is not a problem.  Recently I've encountered this error in Google Chrome when 
trying to run a search with a string that's a little over 1k characters long.

[cid:image001.png@01D3A1C2.E7E1F930]

Firefox and MS Edge have no issues with processing the string.  Before this 
error occurs, there's an empty pop-up window that hangs there for about 5 
seconds.  Right now I have a single AR and Mid-Tier server, so the load 
balancing things that I saw when searching wouldn't apply.  Nothing's changed 
on the server aside from Windows updates.  Fortunately this really isn't 
affecting anyone else but me and of course there's an easy workaround.

Thanks!
Dustin Fawver
Sr. Help Desk Technician
Information Technology Services

P: 423-439-4648
itsh...@etsu.edu
[itslogo]<http://www.etsu.edu/helpdesk>

-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: 9.1.04 Upgrade freezes without error

[Thomas Miskiewicz]

Well, I was asking why does Mid Tier need /etc/profile access? What didn’t the 
original 9.1.03.001 need that access and the 9.1.04 suddenly does.


> On 18. Dec 2017, at 22:34, LJ LongWing <lj.longw...@gmail.com> wrote:
> 
> Yes, it's the Server and various CMDB and other components that live and 
> reside on the OS that require /etc/profileas you said Mid-Tier simply 
> resides inside of the Tomcat containernot the OS directly :)
> 
> On Mon, Dec 18, 2017 at 2:32 PM, Thomas Miskiewicz <tmisk...@gmail.com 
> <mailto:tmisk...@gmail.com>> wrote:
> LJ at the same time I could just use the .war version and be happy, i.e. it 
> looks like the Mid Tier can live without /etc/profile...
> 
> 
>> On 18. Dec 2017, at 22:27, LJ LongWing <lj.longw...@gmail.com 
>> <mailto:lj.longw...@gmail.com>> wrote:
>> 
>> Thomas,
>> The installer updates the /etc/profile with some references to BMC scripts 
>> that set various environment variables needed for various elements of the 
>> system to function.
>> 
>> On Mon, Dec 18, 2017 at 2:23 PM, Thomas Miskiewicz <tmisk...@gmail.com 
>> <mailto:tmisk...@gmail.com>> wrote:
>> Question Abhijeet - just tried to upgrade Mid Tier 9.1.03 to 9.1.04 on our 
>> dev system as non-root. Can you enlighten me why does the installer need 
>> /etc/profile?
>> 
>> 
>>> On 18. Dec 2017, at 17:06, Gadgil, Abhijeet <abhijeet_gad...@bmc.com 
>>> <mailto:abhijeet_gad...@bmc.com>> wrote:
>>> 
>>> Hello Kevin, pl stay with JDK 1.8 or 8.0 [the way it is referred generally]
>>> Compatibility matrix is available at 
>>> https://docs.bmc.com/docs/itsm91/files/608490635/781014284/2/1513161242343/BMC_Remedy_AR_System_9_1_00_Compatibility_Matrix_Dec_2017.pdf
>>>  
>>> <https://docs.bmc.com/docs/itsm91/files/608490635/781014284/2/1513161242343/BMC_Remedy_AR_System_9_1_00_Compatibility_Matrix_Dec_2017.pdf>
>>>  
>>>  
>>> From: ARSList [mailto:arslist-boun...@arslist.org 
>>> <mailto:arslist-boun...@arslist.org>] On Behalf Of Kevin M Candelaria
>>> Sent: 18 December 2017 20:54
>>> To: ARSList <arslist@arslist.org <mailto:arslist@arslist.org>>
>>> Subject: Re: 9.1.04 Upgrade freezes without error
>>>  
>>> Any Java version recommended for 9.1.04?
>>> I am using 8u45
>>>  
>>>  
>>>  
>>> -- 
>>> ARSList mailing list
>>> ARSList@arslist.org <mailto:ARSList@arslist.org>
>>> https://mailman.rrr.se/cgi/listinfo/arslist 
>>> <https://mailman.rrr.se/cgi/listinfo/arslist>
>> 
>> 
>> --
>> ARSList mailing list
>> ARSList@arslist.org <mailto:ARSList@arslist.org>
>> https://mailman.rrr.se/cgi/listinfo/arslist 
>> <https://mailman.rrr.se/cgi/listinfo/arslist>
>> 
>> 
>> -- 
>> ARSList mailing list
>> ARSList@arslist.org <mailto:ARSList@arslist.org>
>> https://mailman.rrr.se/cgi/listinfo/arslist 
>> <https://mailman.rrr.se/cgi/listinfo/arslist>
> 
> 
> --
> ARSList mailing list
> ARSList@arslist.org <mailto:ARSList@arslist.org>
> https://mailman.rrr.se/cgi/listinfo/arslist 
> <https://mailman.rrr.se/cgi/listinfo/arslist>
> 
> 
> -- 
> ARSList mailing list
> ARSList@arslist.org
> https://mailman.rrr.se/cgi/listinfo/arslist

-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: 9.1.04 Upgrade freezes without error

[LJ LongWing]

Yes, it's the Server and various CMDB and other components that live and
reside on the OS that require /etc/profileas you said Mid-Tier simply
resides inside of the Tomcat containernot the OS directly :)

On Mon, Dec 18, 2017 at 2:32 PM, Thomas Miskiewicz <tmisk...@gmail.com>
wrote:

> LJ at the same time I could just use the .war version and be happy, i.e.
> it looks like the Mid Tier can live without /etc/profile...
>
>
> On 18. Dec 2017, at 22:27, LJ LongWing <lj.longw...@gmail.com> wrote:
>
> Thomas,
> The installer updates the /etc/profile with some references to BMC scripts
> that set various environment variables needed for various elements of the
> system to function.
>
> On Mon, Dec 18, 2017 at 2:23 PM, Thomas Miskiewicz <tmisk...@gmail.com>
> wrote:
>
>> Question Abhijeet - just tried to upgrade Mid Tier 9.1.03 to 9.1.04 on
>> our dev system as non-root. Can you enlighten me why does the installer
>> need /etc/profile?
>>
>>
>> On 18. Dec 2017, at 17:06, Gadgil, Abhijeet <abhijeet_gad...@bmc.com>
>> wrote:
>>
>> Hello Kevin, pl stay with JDK 1.8 or 8.0 [the way it is referred
>> generally]
>> Compatibility matrix is available at https://docs.bmc.com/docs/i
>> tsm91/files/608490635/781014284/2/1513161242343/BMC_Remedy_
>> AR_System_9_1_00_Compatibility_Matrix_Dec_2017.pdf
>>
>>
>> *From:* ARSList [mailto:arslist-boun...@arslist.org
>> <arslist-boun...@arslist.org>] *On Behalf Of *Kevin M Candelaria
>> *Sent:* 18 December 2017 20:54
>> *To:* ARSList <arslist@arslist.org>
>> *Subject:* Re: 9.1.04 Upgrade freezes without error
>>
>> Any Java version recommended for 9.1.04?
>> I am using 8u45
>>
>>
>>
>> --
>> ARSList mailing list
>> ARSList@arslist.org
>> https://mailman.rrr.se/cgi/listinfo/arslist
>>
>>
>>
>> --
>> ARSList mailing list
>> ARSList@arslist.org
>> https://mailman.rrr.se/cgi/listinfo/arslist
>>
>>
> --
> ARSList mailing list
> ARSList@arslist.org
> https://mailman.rrr.se/cgi/listinfo/arslist
>
>
>
> --
> ARSList mailing list
> ARSList@arslist.org
> https://mailman.rrr.se/cgi/listinfo/arslist
>
>
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: 9.1.04 Upgrade freezes without error

[Thomas Miskiewicz]

LJ at the same time I could just use the .war version and be happy, i.e. it 
looks like the Mid Tier can live without /etc/profile...

> On 18. Dec 2017, at 22:27, LJ LongWing <lj.longw...@gmail.com> wrote:
> 
> Thomas,
> The installer updates the /etc/profile with some references to BMC scripts 
> that set various environment variables needed for various elements of the 
> system to function.
> 
> On Mon, Dec 18, 2017 at 2:23 PM, Thomas Miskiewicz <tmisk...@gmail.com 
> <mailto:tmisk...@gmail.com>> wrote:
> Question Abhijeet - just tried to upgrade Mid Tier 9.1.03 to 9.1.04 on our 
> dev system as non-root. Can you enlighten me why does the installer need 
> /etc/profile?
> 
> 
>> On 18. Dec 2017, at 17:06, Gadgil, Abhijeet <abhijeet_gad...@bmc.com 
>> <mailto:abhijeet_gad...@bmc.com>> wrote:
>> 
>> Hello Kevin, pl stay with JDK 1.8 or 8.0 [the way it is referred generally]
>> Compatibility matrix is available at 
>> https://docs.bmc.com/docs/itsm91/files/608490635/781014284/2/1513161242343/BMC_Remedy_AR_System_9_1_00_Compatibility_Matrix_Dec_2017.pdf
>>  
>> <https://docs.bmc.com/docs/itsm91/files/608490635/781014284/2/1513161242343/BMC_Remedy_AR_System_9_1_00_Compatibility_Matrix_Dec_2017.pdf>
>>  
>>  
>> From: ARSList [mailto:arslist-boun...@arslist.org 
>> <mailto:arslist-boun...@arslist.org>] On Behalf Of Kevin M Candelaria
>> Sent: 18 December 2017 20:54
>> To: ARSList <arslist@arslist.org <mailto:arslist@arslist.org>>
>> Subject: Re: 9.1.04 Upgrade freezes without error
>>  
>> Any Java version recommended for 9.1.04?
>> I am using 8u45
>>  
>>  
>>  
>> -- 
>> ARSList mailing list
>> ARSList@arslist.org <mailto:ARSList@arslist.org>
>> https://mailman.rrr.se/cgi/listinfo/arslist 
>> <https://mailman.rrr.se/cgi/listinfo/arslist>
> 
> 
> --
> ARSList mailing list
> ARSList@arslist.org <mailto:ARSList@arslist.org>
> https://mailman.rrr.se/cgi/listinfo/arslist 
> <https://mailman.rrr.se/cgi/listinfo/arslist>
> 
> 
> -- 
> ARSList mailing list
> ARSList@arslist.org
> https://mailman.rrr.se/cgi/listinfo/arslist

-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: 9.1.04 Upgrade freezes without error

[Adams, Peter]

To be specific: As mentioned in the compatibility document, Java 9 (or higher) 
is not supported for any version of Remedy AR System across any 
platform/operating system at this time.
We’re planning to test Java 9 and give a support statement at a later time.

Peter


From: ARSList <arslist-boun...@arslist.org> on behalf of "Gadgil, Abhijeet" 
<abhijeet_gad...@bmc.com>
Reply-To: ARSList <arslist@arslist.org>
Date: Monday, December 18, 2017 at 8:06 AM
To: ARSList <arslist@arslist.org>
Subject: RE: 9.1.04 Upgrade freezes without error

Hello Kevin, pl stay with JDK 1.8 or 8.0 [the way it is referred generally]
Compatibility matrix is available at 
https://docs.bmc.com/docs/itsm91/files/608490635/781014284/2/1513161242343/BMC_Remedy_AR_System_9_1_00_Compatibility_Matrix_Dec_2017.pdf


From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Kevin M 
Candelaria
Sent: 18 December 2017 20:54
To: ARSList <arslist@arslist.org>
Subject: Re: 9.1.04 Upgrade freezes without error


Any Java version recommended for 9.1.04?

I am using 8u45




-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

RE: 9.1.04 Upgrade freezes without error

[Gadgil, Abhijeet]

Hello Kevin, pl stay with JDK 1.8 or 8.0 [the way it is referred generally]
Compatibility matrix is available at 
https://docs.bmc.com/docs/itsm91/files/608490635/781014284/2/1513161242343/BMC_Remedy_AR_System_9_1_00_Compatibility_Matrix_Dec_2017.pdf


From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Kevin M 
Candelaria
Sent: 18 December 2017 20:54
To: ARSList <arslist@arslist.org>
Subject: Re: 9.1.04 Upgrade freezes without error


Any Java version recommended for 9.1.04?

I am using 8u45




-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

RE: 9.1.04 Upgrade freezes without error

[Gadgil, Abhijeet]

Kevin, can you run the logzipper and send the logs [to check inline with your 
comment around "just quits"]?

From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Kevin M 
Candelaria
Sent: 18 December 2017 05:50
To: ARSList <arslist@arslist.org>
Subject: Re: 9.1.04 Upgrade freezes without error


You guys aren't alone. I'm doing a 9.100 to 9.104. I have had to install itsm, 
SRM and slm 2x. First time the installer just quits with no logs or errors. The 
midtier keeps crashing for no reason on me and my. Midtier objects menu is 
saying things like remedy rule engine is a hidden object so email engine is 
running but not working. I'll address all that once everything is finally 
installed and upgraded.


Sent from my Verizon, Samsung Galaxy smartphone
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

Re: 9.1.04 Upgrade freezes without error

[Kevin M Candelaria]

So far the only issues I am having is email engine would stay in waiting state. 
Fixed that and it can send mail but the remedy engine isn't processing system 
notifications at all. Also non admin users can not see any assignees in any 
support group.







From: ARSList <arslist-boun...@arslist.org> on behalf of Thomas Miskiewicz 
<tmisk...@gmail.com>
Sent: Monday, December 18, 2017 10:39 AM
To: ARSList
Subject: Re: 9.1.04 Upgrade freezes without error

We used 1.8 u121 - I don’t think it’s a Java Problem.

On 18. Dec 2017, at 16:35, LJ LongWing 
<lj.longw...@gmail.com<mailto:lj.longw...@gmail.com>> wrote:

Any version of 1.8 above update 45 I think it wasthe compatibility matrix 
states the actual versionbut you will want to stay in 1.8.

On Mon, Dec 18, 2017 at 8:24 AM, Kevin M Candelaria 
<ke...@temple.edu<mailto:ke...@temple.edu>> wrote:

Any Java version recommended for 9.1.04?

I am using 8u45




From: ARSList <arslist-boun...@arslist.org<mailto:arslist-boun...@arslist.org>> 
on behalf of Kevin M Candelaria <ke...@temple.edu<mailto:ke...@temple.edu>>
Sent: Sunday, December 17, 2017 7:20 PM
To: ARSList
Subject: Re: 9.1.04 Upgrade freezes without error


This sender failed our fraud detection checks and may not be who they appear to 
be. Learn about spoofing<http://aka.ms/LearnAboutSpoofing>
Feedback<http://aka.ms/SafetyTipsFeedback>

You guys aren't alone. I'm doing a 9.100 to 9.104. I have had to install itsm, 
SRM and slm 2x. First time the installer just quits with no logs or errors. The 
midtier keeps crashing for no reason on me and my. Midtier objects menu is 
saying things like remedy rule engine is a hidden object so email engine is 
running but not working. I'll address all that once everything is finally 
installed and upgraded.


Sent from my Verizon, Samsung Galaxy smartphone


 Original message 
From: Scott Philben <sphil...@mac.com<mailto:sphil...@mac.com>>
Date: 12/17/17 12:37 PM (GMT-05:00)
To: ARSList <arslist@arslist.org<mailto:arslist@arslist.org>>
Cc: "Viswanathan, Murali" 
<murali_viswanat...@bmc.com<mailto:murali_viswanat...@bmc.com>>
Subject: Re: 9.1.04 Upgrade freezes without error

I’ve had a lot of problems getting the AR System server service on Windows to 
restart during installs and upgrades. Check to see if it is running. Sometimes 
you can just start it manually and it will continue. Sometimes not.

Otherwise, in order to get our upgrade working from 7.6.04 —> 9.00.01 we have 
to stop off at 8.1 first. So I ran that installer, then ran the 9.0 installer. 
Why? No idea. BMC recommended it.

On Dec 16, 2017, at 09:38, Thomas Miskiewicz 
<tmisk...@gmail.com<mailto:tmisk...@gmail.com>> wrote:

Hello Listers,

we’re trying to upgrade from 7.6.04 to 9.1.04. After each attempt the installer 
stops in the post upgrade execution (see attachment) and silence for >1 hour. 
No updates in any of the log files Shall we wait, shall we stop. No one can 
tell not even BMC. Awesome job guys!

Last arsystem_install_log.txt entries:

27366   LOG EVENT {Description=[Skipping execution of SampleAppDEF stage group]}
27367 (Dec 16 2017 02:34:37.554 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27368   LOG EVENT {Description=[Skipping execution of TwitterDEF stage group]}
27369 (Dec 16 2017 02:34:37.554 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27370   LOG EVENT {Description=[Skipping execution of ServerAdmin stage group]}
27371 (Dec 16 2017 02:34:37.554 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27372   LOG EVENT {Description=[Skipping execution of ConfigCheck Plugin def 
stage group]}
27373 (Dec 16 2017 02:34:37.554 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27374   LOG EVENT {Description=[Skipping execution of WaitForRecache1 stage 
group]}
27375 (Dec 16 2017 02:34:37.554 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27376   LOG EVENT {Description=[Skipping execution of ImportSchemasDATA stage 
group]}
27377 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27378   LOG EVENT {Description=[Skipping execution of TwitterDATA stage group]}
27379 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27380   LOG EVENT {Description=[Skipping execution of Flashboard Import stage 
group]}
27381 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27382   LOG EVENT {Description=[Skipping execution of ReportLocaleEscalations 
stage group]}
27383 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27384   LOG EVENT {Description=[Skipping execution of 
RemoveActiveLinksNotRequiredFrom71 stage g

RE: 9.1.04 Upgrade freezes without error

[Gadgil, Abhijeet]

Last call that went out is SSI call. You said nothing seems to be happening on 
the server, if that is true best would be to take a thread dump of java process 
and checking if any locks are seen on database tables.
If you see that since the time you posted this, the installation has completed, 
pl send the logs using logzipper such that we can atleast check how much time 
did post upgrade tasks take.

Generally if you are doing an upgrade on a standalone server the post upgrade 
tasks should complete within 30 mins.

Regards,
Abhijeet


From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Thomas 
Miskiewicz
Sent: 16 December 2017 20:08
To: ARSList <arslist@arslist.org>
Cc: Viswanathan, Murali <murali_viswanat...@bmc.com>
Subject: 9.1.04 Upgrade freezes without error

Hello Listers,

we’re trying to upgrade from 7.6.04 to 9.1.04. After each attempt the installer 
stops in the post upgrade execution (see attachment) and silence for >1 hour. 
No updates in any of the log files Shall we wait, shall we stop. No one can 
tell not even BMC. Awesome job guys!

Last arsystem_install_log.txt entries:

27366   LOG EVENT {Description=[Skipping execution of SampleAppDEF stage group]}
27367 (Dec 16 2017 02:34:37.554 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27368   LOG EVENT {Description=[Skipping execution of TwitterDEF stage group]}
27369 (Dec 16 2017 02:34:37.554 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27370   LOG EVENT {Description=[Skipping execution of ServerAdmin stage group]}
27371 (Dec 16 2017 02:34:37.554 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27372   LOG EVENT {Description=[Skipping execution of ConfigCheck Plugin def 
stage group]}
27373 (Dec 16 2017 02:34:37.554 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27374   LOG EVENT {Description=[Skipping execution of WaitForRecache1 stage 
group]}
27375 (Dec 16 2017 02:34:37.554 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27376   LOG EVENT {Description=[Skipping execution of ImportSchemasDATA stage 
group]}
27377 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27378   LOG EVENT {Description=[Skipping execution of TwitterDATA stage group]}
27379 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27380   LOG EVENT {Description=[Skipping execution of Flashboard Import stage 
group]}
27381 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27382   LOG EVENT {Description=[Skipping execution of ReportLocaleEscalations 
stage group]}
27383 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27384   LOG EVENT {Description=[Skipping execution of 
RemoveActiveLinksNotRequiredFrom71 stage group]}
27385 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27386   LOG EVENT {Description=[Skipping execution of ARFeatureChangeState 
stage group]}
27387 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27388   LOG EVENT {Description=[Skipping execution of ARChangeSampleState stage 
group]}
27389 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27390   LOG EVENT {Description=[Skipping execution of RegisterARServer stage 
group]}
27391 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27392   LOG EVENT {Description=[Skipping execution of PublishingReports stage 
group]}
27393 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.StageGroup,
27394   LOG EVENT {Description=[Executing stage group [name=set 
AttachmentExceptionList,filters=[com.bmc.smbu.install.common.rule.engine.InstallMode@16ce8d58],stages=[[level=set
 AttachmentExceptionList,commands=[[a  
rguments=[subCommand=setsvrinfo,logDir=/appexec/bmc/ar/arsprodapp31spk,logName=ARServer-RIK_PostInstall,file=null,guid=null,mode=null,componentMask=null,propertyName=null,propertyStatus=null,serverInfoParamet
  er=401,serverInfoValue=AR System Publish Report(90104), AR System 
Resource Definitions(41103), UDM:Import(46093), UDM:ImportProcessor(46093), 
Data Visualization Definition(41054), Data Visualization Module(41  006), 
Data Visualization System Files(41024), Report(212), Report 
Definition(2010012), AR System Administration: Server Information(16356), AR 
System Administration: Server Information:Save Attachment(163  62), AR 
System User Central File(20020), Visualizer Module Images(42083), Visualizer 
Module Registration(42004), AR System Administration: Add Or Remove 
Licenses(15437), AR System License: Save Produse Attach  ment(16362), AR 
System Licenses(15437), AR System Licenses(15438), AR System Licenses 
Audit(15437), AR System Licenses Audit(15438), AR System Licenses 
Console(15

Re: 9.1.04 Upgrade freezes without error

[Thomas Miskiewicz]

We used 1.8 u121 - I don’t think it’s a Java Problem.

> On 18. Dec 2017, at 16:35, LJ LongWing <lj.longw...@gmail.com> wrote:
> 
> Any version of 1.8 above update 45 I think it wasthe compatibility matrix 
> states the actual versionbut you will want to stay in 1.8.
> 
> On Mon, Dec 18, 2017 at 8:24 AM, Kevin M Candelaria <ke...@temple.edu 
> <mailto:ke...@temple.edu>> wrote:
> Any Java version recommended for 9.1.04?
> 
> I am using 8u45
> 
>  
>  
> From: ARSList <arslist-boun...@arslist.org 
> <mailto:arslist-boun...@arslist.org>> on behalf of Kevin M Candelaria 
> <ke...@temple.edu <mailto:ke...@temple.edu>>
> Sent: Sunday, December 17, 2017 7:20 PM
> To: ARSList
> Subject: Re: 9.1.04 Upgrade freezes without error
>  
> This sender failed our fraud detection checks and may not be who they appear 
> to be. Learn about spoofing <http://aka.ms/LearnAboutSpoofing>   Feedback 
> <http://aka.ms/SafetyTipsFeedback>
> 
> You guys aren't alone. I'm doing a 9.100 to 9.104. I have had to install 
> itsm, SRM and slm 2x. First time the installer just quits with no logs or 
> errors. The midtier keeps crashing for no reason on me and my. Midtier 
> objects menu is saying things like remedy rule engine is a hidden object so 
> email engine is running but not working. I'll address all that once 
> everything is finally installed and upgraded. 
> 
> 
> Sent from my Verizon, Samsung Galaxy smartphone
> 
> 
>  Original message 
> From: Scott Philben <sphil...@mac.com <mailto:sphil...@mac.com>>
> Date: 12/17/17 12:37 PM (GMT-05:00)
> To: ARSList <arslist@arslist.org <mailto:arslist@arslist.org>>
> Cc: "Viswanathan, Murali" <murali_viswanat...@bmc.com 
> <mailto:murali_viswanat...@bmc.com>>
> Subject: Re: 9.1.04 Upgrade freezes without error
> 
> I’ve had a lot of problems getting the AR System server service on Windows to 
> restart during installs and upgrades. Check to see if it is running. 
> Sometimes you can just start it manually and it will continue. Sometimes not. 
> 
> Otherwise, in order to get our upgrade working from 7.6.04 —> 9.00.01 we have 
> to stop off at 8.1 first. So I ran that installer, then ran the 9.0 
> installer. Why? No idea. BMC recommended it.
> 
>> On Dec 16, 2017, at 09:38, Thomas Miskiewicz <tmisk...@gmail.com 
>> <mailto:tmisk...@gmail.com>> wrote:
>> 
>> Hello Listers,
>> 
>> we’re trying to upgrade from 7.6.04 to 9.1.04. After each attempt the 
>> installer stops in the post upgrade execution (see attachment) and silence 
>> for >1 hour. No updates in any of the log files Shall we wait, shall we 
>> stop. No one can tell not even BMC. Awesome job guys!
>> 
>> Last arsystem_install_log.txt entries:
>> 
>> 27366   LOG EVENT {Description=[Skipping execution of SampleAppDEF stage 
>> group]}
>> 27367 (Dec 16 2017 02:34:37.554 PM 
>> +0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
>> 27368   LOG EVENT {Description=[Skipping execution of TwitterDEF stage 
>> group]}
>> 27369 (Dec 16 2017 02:34:37.554 PM 
>> +0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
>> 27370   LOG EVENT {Description=[Skipping execution of ServerAdmin stage 
>> group]}
>> 27371 (Dec 16 2017 02:34:37.554 PM 
>> +0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
>> 27372   LOG EVENT {Description=[Skipping execution of ConfigCheck Plugin def 
>> stage group]}
>> 27373 (Dec 16 2017 02:34:37.554 PM 
>> +0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
>> 27374   LOG EVENT {Description=[Skipping execution of WaitForRecache1 stage 
>> group]}
>> 27375 (Dec 16 2017 02:34:37.554 PM 
>> +0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
>> 27376   LOG EVENT {Description=[Skipping execution of ImportSchemasDATA 
>> stage group]}
>> 27377 (Dec 16 2017 02:34:37.555 PM 
>> +0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
>> 27378   LOG EVENT {Description=[Skipping execution of TwitterDATA stage 
>> group]}
>> 27379 (Dec 16 2017 02:34:37.555 PM 
>> +0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
>> 27380   LOG EVENT {Description=[Skipping execution of Flashboard Import 
>> stage group]}
>> 27381 (Dec 16 2017 02:34:37.555 PM 
>> +0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
>> 27382   LOG EVENT {Description=[Skipping execution of 
>> ReportLocaleEscalations stage group]}
>> 27383 (Dec 16 2017 02:34:37.555 PM 
>> +0100),INFO,com.bmc.smbu.install.common.ru

Re: 9.1.04 Upgrade freezes without error

[LJ LongWing]

Any version of 1.8 above update 45 I think it wasthe compatibility
matrix states the actual versionbut you will want to stay in 1.8.

On Mon, Dec 18, 2017 at 8:24 AM, Kevin M Candelaria <ke...@temple.edu>
wrote:

> Any Java version recommended for 9.1.04?
>
> I am using 8u45
>
>
>
> --
> *From:* ARSList <arslist-boun...@arslist.org> on behalf of Kevin M
> Candelaria <ke...@temple.edu>
> *Sent:* Sunday, December 17, 2017 7:20 PM
> *To:* ARSList
> *Subject:* Re: 9.1.04 Upgrade freezes without error
>
> This sender failed our fraud detection checks and may not
> be who they appear to be. Learn about spoofing
> <http://aka.ms/LearnAboutSpoofing>
> Feedback <http://aka.ms/SafetyTipsFeedback>
>
> You guys aren't alone. I'm doing a 9.100 to 9.104. I have had to install
> itsm, SRM and slm 2x. First time the installer just quits with no logs or
> errors. The midtier keeps crashing for no reason on me and my. Midtier
> objects menu is saying things like remedy rule engine is a hidden object so
> email engine is running but not working. I'll address all that once
> everything is finally installed and upgraded.
>
>
> Sent from my Verizon, Samsung Galaxy smartphone
>
>
>  Original message 
> From: Scott Philben <sphil...@mac.com>
> Date: 12/17/17 12:37 PM (GMT-05:00)
> To: ARSList <arslist@arslist.org>
> Cc: "Viswanathan, Murali" <murali_viswanat...@bmc.com>
> Subject: Re: 9.1.04 Upgrade freezes without error
>
> I’ve had a lot of problems getting the AR System server service on Windows
> to restart during installs and upgrades. Check to see if it is running.
> Sometimes you can just start it manually and it will continue. Sometimes
> not.
>
> Otherwise, in order to get our upgrade working from 7.6.04 —> 9.00.01 we
> have to stop off at 8.1 first. So I ran that installer, then ran the 9.0
> installer. Why? No idea. BMC recommended it.
>
> On Dec 16, 2017, at 09:38, Thomas Miskiewicz <tmisk...@gmail.com> wrote:
>
> Hello Listers,
>
> we’re trying to upgrade from 7.6.04 to 9.1.04. After each attempt the
> installer stops in the post upgrade execution (see attachment) and silence
> for >1 hour. No updates in any of the log files Shall we wait, shall we
> stop. No one can tell not even BMC. Awesome job guys!
>
> Last arsystem_install_log.txt entries:
>
> 27366   LOG EVENT {Description=[Skipping execution of SampleAppDEF stage
> group]}
> 27367 (Dec 16 2017 02:34:37.554 PM +0100),INFO,com.bmc.smbu.
> install.common.rule.engine.Installer,
> 27368   LOG EVENT {Description=[Skipping execution of TwitterDEF stage
> group]}
> 27369 (Dec 16 2017 02:34:37.554 PM +0100),INFO,com.bmc.smbu.
> install.common.rule.engine.Installer,
> 27370   LOG EVENT {Description=[Skipping execution of ServerAdmin stage
> group]}
> 27371 (Dec 16 2017 02:34:37.554 PM +0100),INFO,com.bmc.smbu.
> install.common.rule.engine.Installer,
> 27372   LOG EVENT {Description=[Skipping execution of ConfigCheck Plugin
> def stage group]}
> 27373 (Dec 16 2017 02:34:37.554 PM +0100),INFO,com.bmc.smbu.
> install.common.rule.engine.Installer,
> 27374   LOG EVENT {Description=[Skipping execution of WaitForRecache1
> stage group]}
> 27375 (Dec 16 2017 02:34:37.554 PM +0100),INFO,com.bmc.smbu.
> install.common.rule.engine.Installer,
> 27376   LOG EVENT {Description=[Skipping execution of ImportSchemasDATA
> stage group]}
> 27377 (Dec 16 2017 02:34:37.555 PM +0100),INFO,com.bmc.smbu.
> install.common.rule.engine.Installer,
> 27378   LOG EVENT {Description=[Skipping execution of TwitterDATA stage
> group]}
> 27379 (Dec 16 2017 02:34:37.555 PM +0100),INFO,com.bmc.smbu.
> install.common.rule.engine.Installer,
> 27380   LOG EVENT {Description=[Skipping execution of Flashboard Import
> stage group]}
> 27381 (Dec 16 2017 02:34:37.555 PM +0100),INFO,com.bmc.smbu.
> install.common.rule.engine.Installer,
> 27382   LOG EVENT {Description=[Skipping execution of
> ReportLocaleEscalations stage group]}
> 27383 (Dec 16 2017 02:34:37.555 PM +0100),INFO,com.bmc.smbu.
> install.common.rule.engine.Installer,
> 27384   LOG EVENT {Description=[Skipping execution of
> RemoveActiveLinksNotRequiredFrom71 stage group]}
> 27385 (Dec 16 2017 02:34:37.555 PM +0100),INFO,com.bmc.smbu.
> install.common.rule.engine.Installer,
> 27386   LOG EVENT {Description=[Skipping execution of ARFeatureChangeState
> stage group]}
> 27387 (Dec 16 2017 02:34:37.555 PM +0100),INFO,com.bmc.smbu.
> install.common.rule.engine.Installer,
> 27388   LOG EVENT {Description=[Skipping execution of ARChangeSampleState
> stage group]}
> 27389 (Dec 16 2017 02:34:37.555 PM +0100),INFO,com.bmc.smbu.
>

Re: 9.1.04 Upgrade freezes without error

[Kevin M Candelaria]

Any Java version recommended for 9.1.04?

I am using 8u45





From: ARSList <arslist-boun...@arslist.org> on behalf of Kevin M Candelaria 
<ke...@temple.edu>
Sent: Sunday, December 17, 2017 7:20 PM
To: ARSList
Subject: Re: 9.1.04 Upgrade freezes without error


This sender failed our fraud detection checks and may not be who they appear to 
be. Learn about spoofing<http://aka.ms/LearnAboutSpoofing>
Feedback<http://aka.ms/SafetyTipsFeedback>

You guys aren't alone. I'm doing a 9.100 to 9.104. I have had to install itsm, 
SRM and slm 2x. First time the installer just quits with no logs or errors. The 
midtier keeps crashing for no reason on me and my. Midtier objects menu is 
saying things like remedy rule engine is a hidden object so email engine is 
running but not working. I'll address all that once everything is finally 
installed and upgraded.


Sent from my Verizon, Samsung Galaxy smartphone


 Original message 
From: Scott Philben <sphil...@mac.com>
Date: 12/17/17 12:37 PM (GMT-05:00)
To: ARSList <arslist@arslist.org>
Cc: "Viswanathan, Murali" <murali_viswanat...@bmc.com>
Subject: Re: 9.1.04 Upgrade freezes without error

I’ve had a lot of problems getting the AR System server service on Windows to 
restart during installs and upgrades. Check to see if it is running. Sometimes 
you can just start it manually and it will continue. Sometimes not.

Otherwise, in order to get our upgrade working from 7.6.04 —> 9.00.01 we have 
to stop off at 8.1 first. So I ran that installer, then ran the 9.0 installer. 
Why? No idea. BMC recommended it.

On Dec 16, 2017, at 09:38, Thomas Miskiewicz 
<tmisk...@gmail.com<mailto:tmisk...@gmail.com>> wrote:

Hello Listers,

we’re trying to upgrade from 7.6.04 to 9.1.04. After each attempt the installer 
stops in the post upgrade execution (see attachment) and silence for >1 hour. 
No updates in any of the log files Shall we wait, shall we stop. No one can 
tell not even BMC. Awesome job guys!

Last arsystem_install_log.txt entries:

27366   LOG EVENT {Description=[Skipping execution of SampleAppDEF stage group]}
27367 (Dec 16 2017 02:34:37.554 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27368   LOG EVENT {Description=[Skipping execution of TwitterDEF stage group]}
27369 (Dec 16 2017 02:34:37.554 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27370   LOG EVENT {Description=[Skipping execution of ServerAdmin stage group]}
27371 (Dec 16 2017 02:34:37.554 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27372   LOG EVENT {Description=[Skipping execution of ConfigCheck Plugin def 
stage group]}
27373 (Dec 16 2017 02:34:37.554 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27374   LOG EVENT {Description=[Skipping execution of WaitForRecache1 stage 
group]}
27375 (Dec 16 2017 02:34:37.554 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27376   LOG EVENT {Description=[Skipping execution of ImportSchemasDATA stage 
group]}
27377 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27378   LOG EVENT {Description=[Skipping execution of TwitterDATA stage group]}
27379 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27380   LOG EVENT {Description=[Skipping execution of Flashboard Import stage 
group]}
27381 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27382   LOG EVENT {Description=[Skipping execution of ReportLocaleEscalations 
stage group]}
27383 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27384   LOG EVENT {Description=[Skipping execution of 
RemoveActiveLinksNotRequiredFrom71 stage group]}
27385 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27386   LOG EVENT {Description=[Skipping execution of ARFeatureChangeState 
stage group]}
27387 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27388   LOG EVENT {Description=[Skipping execution of ARChangeSampleState stage 
group]}
27389 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27390   LOG EVENT {Description=[Skipping execution of RegisterARServer stage 
group]}
27391 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27392   LOG EVENT {Description=[Skipping execution of PublishingReports stage 
group]}
27393 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.StageGroup,
27394   LOG EVENT {Description=[Executing stage group [name=set 
AttachmentExceptionList,filters=[com.bmc.smbu.install.common.rule.engine.InstallMode@16ce8d58],stages=[[level=set
 AttachmentExceptionList,commands=[[a  
rguments=[subCommand=setsvrinfo,logDir

Re: 9.1.04 Upgrade freezes without error

[Kevin M Candelaria]

You guys aren't alone. I'm doing a 9.100 to 9.104. I have had to install itsm, 
SRM and slm 2x. First time the installer just quits with no logs or errors. The 
midtier keeps crashing for no reason on me and my. Midtier objects menu is 
saying things like remedy rule engine is a hidden object so email engine is 
running but not working. I'll address all that once everything is finally 
installed and upgraded.


Sent from my Verizon, Samsung Galaxy smartphone


 Original message 
From: Scott Philben <sphil...@mac.com>
Date: 12/17/17 12:37 PM (GMT-05:00)
To: ARSList <arslist@arslist.org>
Cc: "Viswanathan, Murali" <murali_viswanat...@bmc.com>
Subject: Re: 9.1.04 Upgrade freezes without error

I’ve had a lot of problems getting the AR System server service on Windows to 
restart during installs and upgrades. Check to see if it is running. Sometimes 
you can just start it manually and it will continue. Sometimes not.

Otherwise, in order to get our upgrade working from 7.6.04 —> 9.00.01 we have 
to stop off at 8.1 first. So I ran that installer, then ran the 9.0 installer. 
Why? No idea. BMC recommended it.

On Dec 16, 2017, at 09:38, Thomas Miskiewicz 
<tmisk...@gmail.com<mailto:tmisk...@gmail.com>> wrote:

Hello Listers,

we’re trying to upgrade from 7.6.04 to 9.1.04. After each attempt the installer 
stops in the post upgrade execution (see attachment) and silence for >1 hour. 
No updates in any of the log files Shall we wait, shall we stop. No one can 
tell not even BMC. Awesome job guys!

Last arsystem_install_log.txt entries:

27366   LOG EVENT {Description=[Skipping execution of SampleAppDEF stage group]}
27367 (Dec 16 2017 02:34:37.554 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27368   LOG EVENT {Description=[Skipping execution of TwitterDEF stage group]}
27369 (Dec 16 2017 02:34:37.554 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27370   LOG EVENT {Description=[Skipping execution of ServerAdmin stage group]}
27371 (Dec 16 2017 02:34:37.554 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27372   LOG EVENT {Description=[Skipping execution of ConfigCheck Plugin def 
stage group]}
27373 (Dec 16 2017 02:34:37.554 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27374   LOG EVENT {Description=[Skipping execution of WaitForRecache1 stage 
group]}
27375 (Dec 16 2017 02:34:37.554 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27376   LOG EVENT {Description=[Skipping execution of ImportSchemasDATA stage 
group]}
27377 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27378   LOG EVENT {Description=[Skipping execution of TwitterDATA stage group]}
27379 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27380   LOG EVENT {Description=[Skipping execution of Flashboard Import stage 
group]}
27381 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27382   LOG EVENT {Description=[Skipping execution of ReportLocaleEscalations 
stage group]}
27383 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27384   LOG EVENT {Description=[Skipping execution of 
RemoveActiveLinksNotRequiredFrom71 stage group]}
27385 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27386   LOG EVENT {Description=[Skipping execution of ARFeatureChangeState 
stage group]}
27387 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27388   LOG EVENT {Description=[Skipping execution of ARChangeSampleState stage 
group]}
27389 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27390   LOG EVENT {Description=[Skipping execution of RegisterARServer stage 
group]}
27391 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
27392   LOG EVENT {Description=[Skipping execution of PublishingReports stage 
group]}
27393 (Dec 16 2017 02:34:37.555 PM 
+0100),INFO,com.bmc.smbu.install.common.rule.engine.StageGroup,
27394   LOG EVENT {Description=[Executing stage group [name=set 
AttachmentExceptionList,filters=[com.bmc.smbu.install.common.rule.engine.InstallMode@16ce8d58],stages=[[level=set
 AttachmentExceptionList,commands=[[a  
rguments=[subCommand=setsvrinfo,logDir=/appexec/bmc/ar/arsprodapp31spk,logName=ARServer-RIK_PostInstall,file=null,guid=null,mode=null,componentMask=null,propertyName=null,propertyStatus=null,serverInfoParamet
  er=401,serverInfoValue=AR System Publish Report(90104), AR System 
Resource Definitions(41103), UDM:Import(46093), UDM:ImportProcessor(46093), 
Data Visualization Definition(41054), Data Visualization Module(41  006), 
Data Visualization System Files(41024), Report(212), Report 
Definition(2010012), AR System Adminis

Re: 9.1.04 Upgrade freezes without error

[Scott Philben]

I’ve had a lot of problems getting the AR System server service on Windows to 
restart during installs and upgrades. Check to see if it is running. Sometimes 
you can just start it manually and it will continue. Sometimes not. 

Otherwise, in order to get our upgrade working from 7.6.04 —> 9.00.01 we have 
to stop off at 8.1 first. So I ran that installer, then ran the 9.0 installer. 
Why? No idea. BMC recommended it.

> On Dec 16, 2017, at 09:38, Thomas Miskiewicz  wrote:
> 
> Hello Listers,
> 
> we’re trying to upgrade from 7.6.04 to 9.1.04. After each attempt the 
> installer stops in the post upgrade execution (see attachment) and silence 
> for >1 hour. No updates in any of the log files Shall we wait, shall we stop. 
> No one can tell not even BMC. Awesome job guys!
> 
> Last arsystem_install_log.txt entries:
> 
> 27366   LOG EVENT {Description=[Skipping execution of SampleAppDEF stage 
> group]}
> 27367 (Dec 16 2017 02:34:37.554 PM 
> +0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
> 27368   LOG EVENT {Description=[Skipping execution of TwitterDEF stage group]}
> 27369 (Dec 16 2017 02:34:37.554 PM 
> +0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
> 27370   LOG EVENT {Description=[Skipping execution of ServerAdmin stage 
> group]}
> 27371 (Dec 16 2017 02:34:37.554 PM 
> +0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
> 27372   LOG EVENT {Description=[Skipping execution of ConfigCheck Plugin def 
> stage group]}
> 27373 (Dec 16 2017 02:34:37.554 PM 
> +0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
> 27374   LOG EVENT {Description=[Skipping execution of WaitForRecache1 stage 
> group]}
> 27375 (Dec 16 2017 02:34:37.554 PM 
> +0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
> 27376   LOG EVENT {Description=[Skipping execution of ImportSchemasDATA stage 
> group]}
> 27377 (Dec 16 2017 02:34:37.555 PM 
> +0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
> 27378   LOG EVENT {Description=[Skipping execution of TwitterDATA stage 
> group]}
> 27379 (Dec 16 2017 02:34:37.555 PM 
> +0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
> 27380   LOG EVENT {Description=[Skipping execution of Flashboard Import stage 
> group]}
> 27381 (Dec 16 2017 02:34:37.555 PM 
> +0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
> 27382   LOG EVENT {Description=[Skipping execution of ReportLocaleEscalations 
> stage group]}
> 27383 (Dec 16 2017 02:34:37.555 PM 
> +0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
> 27384   LOG EVENT {Description=[Skipping execution of 
> RemoveActiveLinksNotRequiredFrom71 stage group]}
> 27385 (Dec 16 2017 02:34:37.555 PM 
> +0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
> 27386   LOG EVENT {Description=[Skipping execution of ARFeatureChangeState 
> stage group]}
> 27387 (Dec 16 2017 02:34:37.555 PM 
> +0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
> 27388   LOG EVENT {Description=[Skipping execution of ARChangeSampleState 
> stage group]}
> 27389 (Dec 16 2017 02:34:37.555 PM 
> +0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
> 27390   LOG EVENT {Description=[Skipping execution of RegisterARServer stage 
> group]}
> 27391 (Dec 16 2017 02:34:37.555 PM 
> +0100),INFO,com.bmc.smbu.install.common.rule.engine.Installer,
> 27392   LOG EVENT {Description=[Skipping execution of PublishingReports stage 
> group]}
> 27393 (Dec 16 2017 02:34:37.555 PM 
> +0100),INFO,com.bmc.smbu.install.common.rule.engine.StageGroup,
> 27394   LOG EVENT {Description=[Executing stage group [name=set 
> AttachmentExceptionList,filters=[com.bmc.smbu.install.common.rule.engine.InstallMode@16ce8d58],stages=[[level=set
>  AttachmentExceptionList,commands=[[a  
> rguments=[subCommand=setsvrinfo,logDir=/appexec/bmc/ar/arsprodapp31spk,logName=ARServer-RIK_PostInstall,file=null,guid=null,mode=null,componentMask=null,propertyName=null,propertyStatus=null,serverInfoParamet
>   er=401,serverInfoValue=AR System Publish Report(90104), AR System 
> Resource Definitions(41103), UDM:Import(46093), UDM:ImportProcessor(46093), 
> Data Visualization Definition(41054), Data Visualization Module(41  006), 
> Data Visualization System Files(41024), Report(212), Report 
> Definition(2010012), AR System Administration: Server Information(16356), AR 
> System Administration: Server Information:Save Attachment(163  62), AR 
> System User Central File(20020), Visualizer Module Images(42083), Visualizer 
> Module Registration(42004), AR System Administration: Add Or Remove 
> Licenses(15437), AR System License: Save Produse Attach  ment(16362), AR 
> System Licenses(15437), AR System Licenses(15438), AR System Licenses 
> Audit(15437), AR System Licenses Audit(15438), AR System Licenses 
> Console(15437), AR System Licenses Console(15438), AR Sy  stem Message 
> Catalog(158), SHARE:Application_Interface(7009), AR System Version Control: 

Re: Getting error of duplicate contact info while trying to submit service request.

[Abhishek Anand]

The below link contains the required solution with the help of the KA :-

https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdcid=kA21400PHgUCAW=Solution


Regards,
Abhishek Anand

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

Re: Getting error of duplicate contact info while trying to submit service request.

[Abhishek Anand]

Hi,

I am on ITSM 8.1.02 so is it applicable here also??

Also just to reiterate the scenario, details are below:-

Whenever end user is trying to submit the service request via request entry 
console.
The fulfillment ID is not getting generated & error encountered in SRM:Request 
form for the multiple entries.

Also we are having business requirement so that there can be user profiles with 
duplicate Fname, Lname as well as Email IDs.

Please suggest on it .

Early response will be highly appreciated.

Regards,
Abhi.

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

Re: Getting error of duplicate contact info while trying to submit service request.

[Abhishek Anand]

Hi Carl,

Thanks for your kind response.

Please could you provide detail as where to check for the additional fields so 
as to overcome the issue.
As i am unable to trace it out in filters.

Early response will be highly appreciated.

Regards,
Abhi.

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

Re: Getting error of duplicate contact info while trying to submit service request.

[Abhi$hek]

Can you please provide detail as in our scenario , it can be the case that
fname ,lname ,email id can be duplicated as per business requirements.

So we need the solution to avoid the error and end user can easily raise
request via service request.

On 03-Oct-2017 7:26 PM, "Carl Wilson" <carlbwil...@gmail.com> wrote:

> Hi,
> The behaviour is dependent on the version of SRM/ITSM you have installed.
> Some person lookups include additional fields such as Corporate ID, etc,
> so you need to look at the underlying code on the Interface_Create form
> performing the lookup to see what additional values you can supply to make
> the search unique.
> By default the Interface_Create form only need First Name and Last Name,
> however if you supply additional information (see point above) it will be
> used in the lookup to uniquely identify and individual.
>
> You can also add a "middle" name to the First or Last Names in the profile
> to make unique, but other than adding in the additional values to the
> search you would need to modify the underlying person lookup code to get
> round your issue.
>
> --
>
> Kind Regards,
>
> Carl Wilson
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] On Behalf Of Abhishek Anand
> Sent: 03 October 2017 16:07
> To: arslist@ARSLIST.ORG
> Subject: Getting error of duplicate contact info while trying to submit
> service request.
>
> Hi Experts,
>
> We are trying to submit service request from the request entry console
> with users profile having same Fname, Lname as well as email id.
> The Incident is not getting generated with the error:-
>
> 48255: "", "2 records have been found for the Incident contact information
> you have provided.  Please talk to your data administrator to make this
> data unique.";
>
> We are having multiple profiles with same fname,lname as well as same
> email id but its as per business requirement.
> So please assist how to overcome it so that such users can also submit the
> request successfully with fulfillment ids getting generated.
>
> Regards,
> AA
>
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "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: Getting error of duplicate contact info while trying to submit service request.

[Abhi$hek]

Can you please provide the link for the hot fix also is it applicable for
ITSM 8.1 as well??

On 03-Oct-2017 7:57 PM, "André Lalonde" <alalo...@rjrinnovations.com> wrote:

> Hi Abhishek,
> I just dealt with this issue for one of our clients in a 9.1.01
> environment. There's a hotfix available for defect SW00454566 that should
> resolve the problem: contact BMC to have it made available.
>
>
> ANDRÉ LALONDE | Team Lead, Support Services / Chef d’équipe, soutien
> technique
> RjR INNOVATIONS INC. | Connect your Business … All of IT / Branchez votre
> entreprise ... en enTIer
> www.RjRInnovations.com
> Office/Bureau: (613) 233-1915 x 555 | Fax/Télécopieur: (514) 372-1919 |
> Email/Courriel: alalo...@rjrinnovations.com
>
>
>
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] On Behalf Of Abhishek Anand
> Sent: October-03-17 11:07 AM
> To: arslist@ARSLIST.ORG
> Subject: Getting error of duplicate contact info while trying to submit
> service request.
>
> Hi Experts,
>
> We are trying to submit service request from the request entry console
> with users profile having same Fname, Lname as well as email id.
> The Incident is not getting generated with the error:-
>
> 48255: "", "2 records have been found for the Incident contact information
> you have provided.  Please talk to your data administrator to make this
> data unique.";
>
> We are having multiple profiles with same fname,lname as well as same
> email id but its as per business requirement.
> So please assist how to overcome it so that such users can also submit the
> request successfully with fulfillment ids getting generated.
>
> Regards,
> AA
>
> 
> ___
> 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"

Re: Getting error of duplicate contact info while trying to submit service request.

[André Lalonde]

Hi Abhishek,
I just dealt with this issue for one of our clients in a 9.1.01 
environment. There's a hotfix available for defect SW00454566 that should 
resolve the problem: contact BMC to have it made available.


ANDRÉ LALONDE | Team Lead, Support Services / Chef d’équipe, soutien technique
RjR INNOVATIONS INC. | Connect your Business … All of IT / Branchez votre 
entreprise ... en enTIer
www.RjRInnovations.com
Office/Bureau: (613) 233-1915 x 555 | Fax/Télécopieur: (514) 372-1919 | 
Email/Courriel: alalo...@rjrinnovations.com





-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Abhishek Anand
Sent: October-03-17 11:07 AM
To: arslist@ARSLIST.ORG
Subject: Getting error of duplicate contact info while trying to submit service 
request.

Hi Experts,

We are trying to submit service request from the request entry console with 
users profile having same Fname, Lname as well as email id.
The Incident is not getting generated with the error:-

48255: "", "2 records have been found for the Incident contact information you 
have provided.  Please talk to your data administrator to make this data 
unique."; 

We are having multiple profiles with same fname,lname as well as same email id 
but its as per business requirement.
So please assist how to overcome it so that such users can also submit the 
request successfully with fulfillment ids getting generated.

Regards,
AA

___
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: Getting error of duplicate contact info while trying to submit service request.

[Carl Wilson]

Hi,
The behaviour is dependent on the version of SRM/ITSM you have installed.
Some person lookups include additional fields such as Corporate ID, etc, so you 
need to look at the underlying code on the Interface_Create form performing the 
lookup to see what additional values you can supply to make the search unique.
By default the Interface_Create form only need First Name and Last Name, 
however if you supply additional information (see point above) it will be used 
in the lookup to uniquely identify and individual.

You can also add a "middle" name to the First or Last Names in the profile to 
make unique, but other than adding in the additional values to the search you 
would need to modify the underlying person lookup code to get round your issue.

--

Kind Regards,
 
Carl Wilson
 

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Abhishek Anand
Sent: 03 October 2017 16:07
To: arslist@ARSLIST.ORG
Subject: Getting error of duplicate contact info while trying to submit service 
request.

Hi Experts,

We are trying to submit service request from the request entry console with 
users profile having same Fname, Lname as well as email id.
The Incident is not getting generated with the error:-

48255: "", "2 records have been found for the Incident contact information you 
have provided.  Please talk to your data administrator to make this data 
unique."; 

We are having multiple profiles with same fname,lname as well as same email id 
but its as per business requirement.
So please assist how to overcome it so that such users can also submit the 
request successfully with fulfillment ids getting generated.

Regards,
AA

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "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"

Getting error of duplicate contact info while trying to submit service request.

[Abhishek Anand]

Hi Experts,

We are trying to submit service request from the request entry console with 
users profile having same Fname, Lname as well as email id.
The Incident is not getting generated with the error:-

48255: "", "2 records have been found for the Incident contact information you 
have provided.  Please talk to your data administrator to make this data 
unique."; 

We are having multiple profiles with same fname,lname as well as same email id 
but its as per business requirement.
So please assist how to overcome it so that such users can also submit the 
request successfully with fulfillment ids getting generated.

Regards,
AA

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

Re: Error 106 - No entry for statistical operation

[Jason Bess]

Hi Kaur,
 Did you ever find out what this was? We're seeing the same thing. The 
error generates, but no errors in the logs.



Thanks
Jason

On Friday, June 16, 2017 at 3:49:45 PM UTC-5, Kaur wrote:

> Hello All, 
>
> We're getting ARERR 106 - No entry is specified for this statistical 
> operation. 
> It started few days ago and nothing has changed on server/remedy side in 
> last few weeks. 
> Flushing mid -tier cache didn't solve the problem. 
> Active link logs shows an error in Push Fields where it tries to set an 
> integer value to a field (Mostly 0). 
>
> Have anyone experienced this problem before? 
>
> Thanks! 
> Kaur 
>   
>
> ___
>  
>
> 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"

Silent uninstall of remedy client - Windows error 2 occurred while loading the Java VM

[ddussie]

Can any help?

Silent install works. 
Silent uninstall on the remedy client is failing on "Windows error 2
occurred while loading the Java VM" 
on windows 10. 
- BMC provide this solution which did not work for our case 
- The problem is directly with java, searching in Microsoft communities I
found the next article:
https://answers.microsoft.com/en-us/windows/forum/windows8_1-update/launchanywhere-error-windows-error-2-occured-while/9853d01d-d85b-41d0-af23-e9965140fc69

<http://ars-action-request-system.1.n7.nabble.com/file/n125819/2017-07-27_10_35_58-Remedy_Client_-_Windows_10_Uninstall_-_Message_%28HTML%29.png>
 
-- this suggestion from BMC does not work.





--
View this message in context: 
http://ars-action-request-system.1.n7.nabble.com/Silent-uninstall-of-remedy-client-Windows-error-2-occurred-while-loading-the-Java-VM-tp125819.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: Error 106 - No entry for statistical operation

[Su Kaur]

No error in filter and api logs.
No filter being fired on push.
Wondering how this error just randomly started even when nothing modified in 
weeks!

Thanks!
Kaur

> On Jun 16, 2017, at 6:13 PM, Grooms, Frederick W <frederick.w.gro...@xo.com> 
> wrote:
> 
> What does the Filter and API logs show?   
> Even though your Active Link is only pushing an integer, there could be 
> Filters firing (on the form you are pushing to) that are causing the error.
> 
> Fred
> 
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Kaur
> Sent: Friday, June 16, 2017 3:46 PM
> To: arslist@ARSLIST.ORG
> Subject: Error 106 - No entry for statistical operation
> 
> Hello All,
> 
> We're getting ARERR 106 - No entry is specified for this statistical 
> operation.
> It started few days ago and nothing has changed on server/remedy side in last 
> few weeks.
> Flushing mid -tier cache didn't solve the problem.
> Active link logs shows an error in Push Fields where it tries to set an 
> integer value to a field (Mostly 0).
> 
> Have anyone experienced this problem before?
> 
> Thanks!
> Kaur
> 
> 
> ___
> 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: Error 106 - No entry for statistical operation

[Grooms, Frederick W]

What does the Filter and API logs show?   
Even though your Active Link is only pushing an integer, there could be Filters 
firing (on the form you are pushing to) that are causing the error.

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kaur
Sent: Friday, June 16, 2017 3:46 PM
To: arslist@ARSLIST.ORG
Subject: Error 106 - No entry for statistical operation

Hello All,

We're getting ARERR 106 - No entry is specified for this statistical operation.
It started few days ago and nothing has changed on server/remedy side in last 
few weeks.
Flushing mid -tier cache didn't solve the problem.
Active link logs shows an error in Push Fields where it tries to set an integer 
value to a field (Mostly 0).

Have anyone experienced this problem before?

Thanks!
Kaur
 

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

Error 106 - No entry for statistical operation

[Kaur]

Hello All,

We're getting ARERR 106 - No entry is specified for this statistical operation.
It started few days ago and nothing has changed on server/remedy side in last 
few weeks.
Flushing mid -tier cache didn't solve the problem.
Active link logs shows an error in Push Fields where it tries to set an integer 
value to a field (Mostly 0).

Have anyone experienced this problem before?

Thanks!
Kaur
 

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

Re: Error while creating CRQ

[Gupta, Girish]

I think it means that for your company, the change management configuration 
requires that Risk questions are completed before a change is created. Either 
this can be disabled ( which may not be right) or you might update SRD to use a 
change template that has the risk questions taken care of.

Thanks & Regards
Girish


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of babajan baig
Sent: 14 June 2017 12:36 PM
To: arslist@ARSLIST.ORG
Subject: Error while creating CRQ

**
Hello Team,

From SR, CRQ is getting created in Draft status but throwing the below error:-

1: "", "Please ensure all Risk Assessment Questions are answered.";

How to avoid this error?

Thanks in Advance!

Regards,
M Babajan Baig
_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"

Error while creating CRQ

[babajan baig]

Hello Team,

>From SR, CRQ is getting created in Draft status but throwing the below
error:-


*1: "", "Please ensure all Risk Assessment Questions are answered."; *
How to avoid this error?

Thanks in Advance!

Regards,
M Babajan Baig

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

Re: Error message while building SLAs. "The statement has been terminated.String or binary data would be truncated. (SQL Server 8152)"

[Satpal Singh Ply]

Hi Chetan,

If you are also trying to put some special character in the name or
somewhere in SLA it also fails sometime. Check that as well.

I hope this will help.

Regards,
SS

On Thu, May 11, 2017 at 5:07 PM, Ben Cantatore <ben.cantat...@bedbath.com>
wrote:

> ** Chetan,
>
> The issue seems to be due to too much being pushed into too small a
> field.  If you really need all those assignee groups, then edit the SYS:
> ViewSelectionCompanyRoleMapping and modify the database field so the
> input value of 255 is increased a bit more to support what's being pushed
> in.
>
>
>
>
> From:Chetan <chetan.w...@vyomlabs.com>
> To:arslist@ARSLIST.ORG,
> Date:05/11/2017 10:49 AM
> Subject:Error message while building SLAs. "The statement has
> been terminated.String or binary data would be truncated. (SQL Server 8152)"
> Sent by:"Action Request System discussion list(ARSList)" <
> arslist@ARSLIST.ORG>
> --
>
>
>
> I am trying to create a SLA and which I have created successfully but when
> I am clicking on built button I am getting error message "The statement has
> been terminated.String or binary data would be truncated. (SQL Server
> 8152)".
>
> I tried investigating the logs and found that some data is getting
> truncated by SQL and which is throwing a warning, but ARS is picking that
> warning as a error message.
>
> The SQL+FLTR+API logs are as :
>
> */ Start filter processing (phase 1) -- Operation - GET on Application
> Pending - 00017548728
>
>   > /* Wed May 10 2017 14:17:51.3450 */ End of filter processing (phase
> 1) -- Operation - GET on Application Pending - 00017548728
>
>   /*
> Wed May 10 2017 14:17:51.3450 */OK
>
>   /*
> Wed May 10 2017 14:17:51.3450 */UPDATE T1202 SET
> C500012800=0,C5='test.user',C6=1494422271 WHERE C1 = '0002335'
>
>   /*
> Wed May 10 2017 14:17:51.3450 */OK
>
>   /*
> Wed May 10 2017 14:17:51.3450 */UPDATE T1202 SET
> C500048900=0,C5='test.user',C6=1494422271 WHERE C1 = '0002335'
>
>   /*
> Wed May 10 2017 14:17:51.3450 */OK
>
>   /*
> Wed May 10 2017 14:17:51.3450 */UPDATE T1204 SET 
> C500070700=0,C500070400=0,C500070300=0,C500048200='Data
> Event',C500048100='Event',C500047400='',C490021100='HPD:Help
> Desk',C49400='SLM01417_MeasReqAssoc_DE_SubmitModifyMerge',C2='
> appadmin',C5='test.user',C6=1494422271 WHERE C1 = '0002258'
>
>   /*
> Wed May 10 2017 14:17:51.3450 */OK
>
>   /*
> Wed May 10 2017 14:17:51.3450 */UPDATE T1267 SET C300543500=0,C60990=';
> 101324;410;101338;410;101431;410;101516;410;
> 101518;410;101536;410;101339;410;101710;410;
> 101713;410;101665;410;101729;410;101752;410;
> 101777;410;101787;410;101817;410;101818;410;
> 101814;410;',C112=';101324;410;101338;410;
> 101431;410;101516;410;101518;410;101536;410;
> 101339;410;101710;410;101713;410;101665;410;
> 101729;410;101752;410;101777;410;101787;410;
> 101817;410;101818;410;101814;410;;410;',C301450300='HPD:Help
> Desk',C301387400=NULL,C301362600=NULL,C301270100='100560',C300375300='
> AG001A4BF124C8MJnWUw9zMCAA3oYA',C5='test.user',C6=1494422271 WHERE C1 =
> '0001283'
>
>   > /* Wed May 10 2017 14:17:51.3600 */SELECT C1,C2,C3,C4,C5,C6,C7,C8,0,
> C501,C502,C503,C504,C505,C506,C507,C508,C509 FROM T8 WHERE C1 =
> '00017549614'
>
>   > /* Wed May 10 2017 14:17:51.3600 */OK
>
>   > /* Wed May 10 2017 14:17:51.3600 */SELECT entryId,T0,U0,T1,U1,T2,U2,T3,U3
> FROM H8 WHERE entryId = '00017549614'
>
>   > /* Wed May 10 2017 14:17:51.3600 */OK
>
>   > /* Wed May 10 2017 14:17:51.3600 */ Start filter processing (phase 1)
> -- Operation - GET on Application Pending - 00017549614
>
>   > /* Wed May 10 2017 14:17:51.3600 */ End of filter processing (phase
> 1) -- Operation - GET on Application Pending - 00017549614
>
>   /*
> Wed May 10 2017 14:17:51.3600 */* WARNING * The statement has been
> terminated.String or binary data would be truncated. (SQL Server 8152)
>
>   /*
> Wed May 10 2017 14:17:51.3600 */ROLLBACK TRANSACTION
>
>   /*
> Wed May 10 2017 14:17:51.3600 */OK
>
> It looks like it is trying to update the table T1267 which is "SYS:
> ViewSelectionCompanyRoleMapping" and on this form there are 2 fields
> which are exceeding the length limit and which are causing the issue. 1st
> field is 60990 and second one is 112 (Assignee Groups).
>
> The questi

Re: Error message while building SLAs. "The statement has been terminated.String or binary data would be truncated. (SQL Server 8152)"

[Ben Cantatore]

Chetan,

The issue seems to be due to too much being pushed into too small a field. 
 If you really need all those assignee groups, then edit the 
SYS:ViewSelectionCompanyRoleMapping and modify the database field so the 
input value of 255 is increased a bit more to support what's being pushed 
in.




From:   Chetan <chetan.w...@vyomlabs.com>
To: arslist@ARSLIST.ORG, 
Date:   05/11/2017 10:49 AM
Subject:    Error message while building SLAs. "The statement has been 
terminated.String or binary data would be truncated. (SQL Server 8152)"
Sent by:"Action Request System discussion list(ARSList)" 
<arslist@ARSLIST.ORG>



I am trying to create a SLA and which I have created successfully but when 
I am clicking on built button I am getting error message "The statement 
has been terminated.String or binary data would be truncated. (SQL Server 
8152)".
 
I tried investigating the logs and found that some data is getting 
truncated by SQL and which is throwing a warning, but ARS is picking that 
warning as a error message.
 
The SQL+FLTR+API logs are as :
 
*/ Start filter processing (phase 1) -- Operation - GET on Application 
Pending - 00017548728

  /* Wed May 10 
2017 14:17:51.3450 */ End of filter processing (phase 1) -- Operation 
- GET on Application Pending - 00017548728

  
/* Wed May 10 2017 14:17:51.3450 */OK

  
/* Wed May 10 2017 14:17:51.3450 */UPDATE T1202 SET 
C500012800=0,C5='test.user',C6=1494422271 WHERE C1 = '0002335'

  
/* Wed May 10 2017 14:17:51.3450 */OK

  
/* Wed May 10 2017 14:17:51.3450 */UPDATE T1202 SET 
C500048900=0,C5='test.user',C6=1494422271 WHERE C1 = '0002335'

  
/* Wed May 10 2017 14:17:51.3450 */OK

  
/* Wed May 10 2017 14:17:51.3450 */UPDATE T1204 SET 
C500070700=0,C500070400=0,C500070300=0,C500048200='Data 
Event',C500048100='Event',C500047400='',C490021100='HPD:Help 
Desk',C49400='SLM01417_MeasReqAssoc_DE_SubmitModifyMerge',C2='appadmin',C5='test.user',C6=1494422271
 
WHERE C1 = '0002258'

  
/* Wed May 10 2017 14:17:51.3450 */OK

  
/* Wed May 10 2017 14:17:51.3450 */UPDATE T1267 SET 
C300543500=0,C60990=';101324;410;101338;410;101431;410;101516;410;101518;410;101536;410;101339;410;101710;410;101713;410;101665;410;101729;410;101752;410;101777;410;101787;410;101817;410;101818;410;101814;410;',C112=';101324;410;101338;410;101431;410;101516;410;101518;410;101536;410;101339;410;101710;410;101713;410;101665;410;101729;410;101752;410;101777;410;101787;410;101817;410;101818;410;101814;410;;410;',C301450300='HPD:Help
 
Desk',C301387400=NULL,C301362600=NULL,C301270100='100560',C300375300='AG001A4BF124C8MJnWUw9zMCAA3oYA',C5='test.user',C6=1494422271
 
WHERE C1 = '0001283'

  /* Wed May 10 
2017 14:17:51.3600 */SELECT 
C1,C2,C3,C4,C5,C6,C7,C8,0,C501,C502,C503,C504,C505,C506,C507,C508,C509 
FROM T8 WHERE C1 = '00017549614'

  /* Wed May 10 
2017 14:17:51.3600 */OK

  /* Wed May 10 
2017 14:17:51.3600 */SELECT entryId,T0,U0,T1,U1,T2,U2,T3,U3 FROM H8 WHERE 
entryId = '00017549614'

  /* Wed May 10 
2017 14:17:51.3600 */OK

  /* Wed May 10 
2017 14:17:51.3600 */ Start filter processing (phase 1) -- Operation - 
GET on Application Pending - 00017549614

  /* Wed May 10 
2017 14:17:51.3600 */ End of filter processing (phase 1) -- Operation 
- GET on Application Pending - 00017549614

  
/* Wed May 10 2017 14:17:51.3600 */* WARNING * The statement has been 
terminated.String or binary data would be truncated. (SQL Server 8152)

  
/* Wed May 10 2017 14:17:51.3600 */ROLLBACK TRANSACTION

  
/* Wed May 10 2017 14:17:51.3600 */OK
 
It looks like it is trying to update the table T1267 which is 
"SYS:ViewSelectionCompanyRoleMapping" and on this form there are 2 fields 
which are exceeding the length limit and which are causing the issue. 1st 
field is 60990 and second one is 112 (Assignee Groups).
 
The question is Am I correct and if yes, how I can resolve the issue as 
from the logs it looks like it is a part of creating SLA filters which is 
backend activity and I think I can not do anything with that.
 
Please suggest.

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

Error message while building SLAs. "The statement has been terminated.String or binary data would be truncated. (SQL Server 8152)"

[Chetan]

I am trying to create a SLA and which I have created successfully but when I am 
clicking on built button I am getting error message "The statement has been 
terminated.String or binary data would be truncated. (SQL Server 8152)".
 
I tried investigating the logs and found that some data is getting truncated by 
SQL and which is throwing a warning, but ARS is picking that warning as a error 
message.
 
The SQL+FLTR+API logs are as :
 
*/ Start filter processing (phase 1) -- Operation - GET on Application 
Pending - 00017548728
  /* Wed May 10 
2017 14:17:51.3450 */ End of filter processing (phase 1) -- Operation - GET 
on Application Pending - 00017548728
  /* Wed May 10 2017 
14:17:51.3450 */OK
  /* Wed May 10 2017 
14:17:51.3450 */UPDATE T1202 SET C500012800=0,C5='test.user',C6=1494422271 
WHERE C1 = '0002335'
  /* Wed May 10 2017 
14:17:51.3450 */OK
  /* Wed May 10 2017 
14:17:51.3450 */UPDATE T1202 SET C500048900=0,C5='test.user',C6=1494422271 
WHERE C1 = '0002335'
  /* Wed May 10 2017 
14:17:51.3450 */OK
  /* Wed May 10 2017 
14:17:51.3450 */UPDATE T1204 SET 
C500070700=0,C500070400=0,C500070300=0,C500048200='Data 
Event',C500048100='Event',C500047400='',C490021100='HPD:Help 
Desk',C49400='SLM01417_MeasReqAssoc_DE_SubmitModifyMerge',C2='appadmin',C5='test.user',C6=1494422271
 WHERE C1 = '0002258'
  /* Wed May 10 2017 
14:17:51.3450 */OK
  /* Wed May 10 2017 
14:17:51.3450 */UPDATE T1267 SET 
C300543500=0,C60990=';101324;410;101338;410;101431;410;101516;410;101518;410;101536;410;101339;410;101710;410;101713;410;101665;410;101729;410;101752;410;101777;410;101787;410;101817;410;101818;410;101814;410;',C112=';101324;410;101338;410;101431;410;101516;410;101518;410;101536;410;101339;410;101710;410;101713;410;101665;410;101729;410;101752;410;101777;410;101787;410;101817;410;101818;410;101814;410;;410;',C301450300='HPD:Help
 
Desk',C301387400=NULL,C301362600=NULL,C301270100='100560',C300375300='AG001A4BF124C8MJnWUw9zMCAA3oYA',C5='test.user',C6=1494422271
 WHERE C1 = '0001283'
  /* Wed May 10 
2017 14:17:51.3600 */SELECT 
C1,C2,C3,C4,C5,C6,C7,C8,0,C501,C502,C503,C504,C505,C506,C507,C508,C509 FROM T8 
WHERE C1 = '00017549614'
  /* Wed May 10 
2017 14:17:51.3600 */OK
  /* Wed May 10 
2017 14:17:51.3600 */SELECT entryId,T0,U0,T1,U1,T2,U2,T3,U3 FROM H8 WHERE 
entryId = '00017549614'
  /* Wed May 10 
2017 14:17:51.3600 */OK
  /* Wed May 10 
2017 14:17:51.3600 */ Start filter processing (phase 1) -- Operation - GET 
on Application Pending - 00017549614
  /* Wed May 10 
2017 14:17:51.3600 */ End of filter processing (phase 1) -- Operation - GET 
on Application Pending - 00017549614
  /* Wed May 10 2017 
14:17:51.3600 */* WARNING * The statement has been terminated.String or binary 
data would be truncated. (SQL Server 8152)
  /* Wed May 10 2017 
14:17:51.3600 */ROLLBACK TRANSACTION
  /* Wed May 10 2017 
14:17:51.3600 */OK
 
It looks like it is trying to update the table T1267 which is 
"SYS:ViewSelectionCompanyRoleMapping" and on this form there are 2 fields which 
are exceeding the length limit and which are causing the issue. 1st field is 
60990 and second one is 112 (Assignee Groups).
 
The question is Am I correct and if yes, how I can resolve the issue as from 
the logs it looks like it is a part of creating SLA filters which is backend 
activity and I think I can not do anything with that.
 
Please suggest.

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

SOLVED: Creating view form in 9.1.2 Error:5165

[Sinclair, Keith]

Yep, that was it. As soon as he ran:

create view V_EQUIPMENT_LIST
as select * from 

I was able to pull them up. So, yes, we had views in remote DB for 8.1.2 but we 
now have local views in the 9.1.2 DB and all is working. Clearly, I didn't read 
the 9.1.2 instructions carefully.



From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Tuesday, December 20, 2016 11:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: Creating view form in 9.1.2 Error:5165

**
Vinod mentioned yesterday (just after I replied) that 9.x doesn't support 
symonyms and require it to be a view in the Remedy DB that's doing the 
connectionsis it  or is it a view in the remote db.try creating a local 
view if you don't have one and see if that helps

Have you done this?

https://docs.bmc.com/docs/display/public/ars91/Setting+up+a+remote+database+for+view+forms

On Tue, Dec 20, 2016 at 10:47 AM, Sinclair, Keith 
<ksincl...@shoppertrak.com<mailto:ksincl...@shoppertrak.com>> wrote:
**
Well, the columns are the same as the DB link for each system is pointed to the 
same external system, so the link is using the same VIEW table on the external 
DB. Like I said, link works fine in 8.1.2 but same exact DB link which tests 
fine in 9.1.2 DB cannot see squat. I am sure it's something simple but I just 
do not know what at this point.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of LJ 
LongWing
Sent: Monday, December 19, 2016 2:22 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Creating view form in 9.1.2 Error:5165

**
Keith,
If logged into the Remedy DB and issuing the same query, I assume you see the 
values expected.  What are the types of columns available in the remote db and 
what are their sizes?

I know that between 8.x and 9.x Remedy changed from C to Java...which means the 
criteria may have changed a bit as well, but shouldn't have changed 
significantly...

On Mon, Dec 19, 2016 at 1:05 PM, Sinclair, Keith 
<ksincl...@shoppertrak.com<mailto:ksincl...@shoppertrak.com>> wrote:
**
List,

I am banging my head against the wall on this one as I am not finding out any 
decent information. I cannot create a view form that links to an external DB 
whereas the same view form in my 8.1.2 test system connects without issue.

I have gone through both systems and they seem to be an apples to apples 
comparison. Both DB links are public database links. Both are accessible and 
working inside SQL developer. Thoughts?

5165 Error
Table fields must have at least one column.

Table fields must have at least one column. See the section on Tables for more 
information.

91.2 Running RedHat on Oracle 11g

Keith Sinclair
Remedy Development
ShopperTrak Chicago, USA
O 312.676.8289<tel:(312)%20676-8289>
ksincl...@shoppertrak.com<mailto:ksincl...@shoppertrak.com> | 
shoppertrak.com<http://shoppertrak.com>
Retail Profitability, Improved.

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

_ARSlist: "Where the Answers Are" and have been for 20 years_
_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: Creating view form in 9.1.2 Error:5165

[Sinclair, Keith]

Yeah, I just saw that message. I punted it over to our DB and having him take a 
look at it now. Hopefully, that'll be it. Otherwise, I'll have him create them 
as a local view in our DB and see if I can point to that.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Tuesday, December 20, 2016 11:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: Creating view form in 9.1.2 Error:5165

**
Vinod mentioned yesterday (just after I replied) that 9.x doesn't support 
symonyms and require it to be a view in the Remedy DB that's doing the 
connectionsis it  or is it a view in the remote db.try creating a local 
view if you don't have one and see if that helps

Have you done this?

https://docs.bmc.com/docs/display/public/ars91/Setting+up+a+remote+database+for+view+forms

On Tue, Dec 20, 2016 at 10:47 AM, Sinclair, Keith 
<ksincl...@shoppertrak.com<mailto:ksincl...@shoppertrak.com>> wrote:
**
Well, the columns are the same as the DB link for each system is pointed to the 
same external system, so the link is using the same VIEW table on the external 
DB. Like I said, link works fine in 8.1.2 but same exact DB link which tests 
fine in 9.1.2 DB cannot see squat. I am sure it's something simple but I just 
do not know what at this point.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of LJ 
LongWing
Sent: Monday, December 19, 2016 2:22 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Creating view form in 9.1.2 Error:5165

**
Keith,
If logged into the Remedy DB and issuing the same query, I assume you see the 
values expected.  What are the types of columns available in the remote db and 
what are their sizes?

I know that between 8.x and 9.x Remedy changed from C to Java...which means the 
criteria may have changed a bit as well, but shouldn't have changed 
significantly...

On Mon, Dec 19, 2016 at 1:05 PM, Sinclair, Keith 
<ksincl...@shoppertrak.com<mailto:ksincl...@shoppertrak.com>> wrote:
**
List,

I am banging my head against the wall on this one as I am not finding out any 
decent information. I cannot create a view form that links to an external DB 
whereas the same view form in my 8.1.2 test system connects without issue.

I have gone through both systems and they seem to be an apples to apples 
comparison. Both DB links are public database links. Both are accessible and 
working inside SQL developer. Thoughts?

5165 Error
Table fields must have at least one column.

Table fields must have at least one column. See the section on Tables for more 
information.

91.2 Running RedHat on Oracle 11g

Keith Sinclair
Remedy Development
ShopperTrak Chicago, USA
O 312.676.8289<tel:(312)%20676-8289>
ksincl...@shoppertrak.com<mailto:ksincl...@shoppertrak.com> | 
shoppertrak.com<http://shoppertrak.com>
Retail Profitability, Improved.

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

_ARSlist: "Where the Answers Are" and have been for 20 years_
_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: Creating view form in 9.1.2 Error:5165

[LJ LongWing]

Vinod mentioned yesterday (just after I replied) that 9.x doesn't support
symonyms and require it to be a view in the Remedy DB that's doing the
connectionsis it  or is it a view in the remote db.try creating a
local view if you don't have one and see if that helps

Have you done this?

https://docs.bmc.com/docs/display/public/ars91/Setting+up+a+remote+database+for+view+forms

On Tue, Dec 20, 2016 at 10:47 AM, Sinclair, Keith <ksincl...@shoppertrak.com
> wrote:

> **
>
> Well, the columns are the same as the DB link for each system is pointed
> to the same external system, so the link is using the same VIEW table on
> the external DB. Like I said, link works fine in 8.1.2 but same exact DB
> link which tests fine in 9.1.2 DB cannot see squat. I am sure it's
> something simple but I just do not know what at this point.
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *LJ LongWing
> *Sent:* Monday, December 19, 2016 2:22 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Creating view form in 9.1.2 Error:5165
>
>
>
> **
>
> Keith,
>
> If logged into the Remedy DB and issuing the same query, I assume you see
> the values expected.  What are the types of columns available in the remote
> db and what are their sizes?
>
>
>
> I know that between 8.x and 9.x Remedy changed from C to Java...which
> means the criteria may have changed a bit as well, but shouldn't have
> changed significantly...
>
>
>
> On Mon, Dec 19, 2016 at 1:05 PM, Sinclair, Keith <
> ksincl...@shoppertrak.com> wrote:
>
> **
>
> List,
>
>
>
> I am banging my head against the wall on this one as I am not finding out
> any decent information. I cannot create a view form that links to an
> external DB whereas the same view form in my 8.1.2 test system connects
> without issue.
>
>
>
> I have gone through both systems and they seem to be an apples to apples
> comparison. Both DB links are public database links. Both are accessible
> and working inside SQL developer. Thoughts?
>
>
>
> 5165 Error
>
> Table fields must have at least one column.
>
>
>
> Table fields must have at least one column. See the section on Tables for
> more information.
>
>
>
> 91.2 Running RedHat on Oracle 11g
>
>
>
> *Keith Sinclair*
>
> Remedy Development
>
> ShopperTrak Chicago, USA
>
> *O* 312.676.8289 <(312)%20676-8289>
>
> ksincl...@shoppertrak.com | shoppertrak.com
>
> *Retail Profitability, Improved.*
>
>
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_
>
>
>
> _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: Creating view form in 9.1.2 Error:5165

[Sinclair, Keith]

Well, the columns are the same as the DB link for each system is pointed to the 
same external system, so the link is using the same VIEW table on the external 
DB. Like I said, link works fine in 8.1.2 but same exact DB link which tests 
fine in 9.1.2 DB cannot see squat. I am sure it's something simple but I just 
do not know what at this point.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Monday, December 19, 2016 2:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: Creating view form in 9.1.2 Error:5165

**
Keith,
If logged into the Remedy DB and issuing the same query, I assume you see the 
values expected.  What are the types of columns available in the remote db and 
what are their sizes?

I know that between 8.x and 9.x Remedy changed from C to Java...which means the 
criteria may have changed a bit as well, but shouldn't have changed 
significantly...

On Mon, Dec 19, 2016 at 1:05 PM, Sinclair, Keith 
<ksincl...@shoppertrak.com<mailto:ksincl...@shoppertrak.com>> wrote:
**
List,

I am banging my head against the wall on this one as I am not finding out any 
decent information. I cannot create a view form that links to an external DB 
whereas the same view form in my 8.1.2 test system connects without issue.

I have gone through both systems and they seem to be an apples to apples 
comparison. Both DB links are public database links. Both are accessible and 
working inside SQL developer. Thoughts?

5165 Error
Table fields must have at least one column.

Table fields must have at least one column. See the section on Tables for more 
information.

91.2 Running RedHat on Oracle 11g

Keith Sinclair
Remedy Development
ShopperTrak Chicago, USA
O 312.676.8289<tel:(312)%20676-8289>
ksincl...@shoppertrak.com<mailto:ksincl...@shoppertrak.com> | 
shoppertrak.com<http://shoppertrak.com>
Retail Profitability, Improved.

_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: Creating view form in 9.1.2 Error:5165

[Vinod Gaidhani]

Hi Kieth,

Not sure if this is related to synonyms, but I guess from version 9.1 view
form doesnt support synonyms and you will have to convert them to actual
database views.

Thanks,
Vinod Gaidhani.

On Mon, Dec 19, 2016 at 8:05 PM, Sinclair, Keith <ksincl...@shoppertrak.com>
wrote:

> **
>
> List,
>
>
>
> I am banging my head against the wall on this one as I am not finding out
> any decent information. I cannot create a view form that links to an
> external DB whereas the same view form in my 8.1.2 test system connects
> without issue.
>
>
>
> I have gone through both systems and they seem to be an apples to apples
> comparison. Both DB links are public database links. Both are accessible
> and working inside SQL developer. Thoughts?
>
>
>
> 5165 Error
>
> Table fields must have at least one column.
>
>
>
> Table fields must have at least one column. See the section on Tables for
> more information.
>
>
>
> 91.2 Running RedHat on Oracle 11g
>
>
>
> *Keith Sinclair*
>
> Remedy Development
>
> ShopperTrak Chicago, USA
>
> *O* 312.676.8289
>
> ksincl...@shoppertrak.com | shoppertrak.com
>
> *Retail Profitability, Improved.*
>
>
> _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: Creating view form in 9.1.2 Error:5165

[LJ LongWing]

Keith,
If logged into the Remedy DB and issuing the same query, I assume you see
the values expected.  What are the types of columns available in the remote
db and what are their sizes?

I know that between 8.x and 9.x Remedy changed from C to Java...which means
the criteria may have changed a bit as well, but shouldn't have changed
significantly...

On Mon, Dec 19, 2016 at 1:05 PM, Sinclair, Keith <ksincl...@shoppertrak.com>
wrote:

> **
>
> List,
>
>
>
> I am banging my head against the wall on this one as I am not finding out
> any decent information. I cannot create a view form that links to an
> external DB whereas the same view form in my 8.1.2 test system connects
> without issue.
>
>
>
> I have gone through both systems and they seem to be an apples to apples
> comparison. Both DB links are public database links. Both are accessible
> and working inside SQL developer. Thoughts?
>
>
>
> 5165 Error
>
> Table fields must have at least one column.
>
>
>
> Table fields must have at least one column. See the section on Tables for
> more information.
>
>
>
> 91.2 Running RedHat on Oracle 11g
>
>
>
> *Keith Sinclair*
>
> Remedy Development
>
> ShopperTrak Chicago, USA
>
> *O* 312.676.8289 <(312)%20676-8289>
>
> ksincl...@shoppertrak.com | shoppertrak.com
>
> *Retail Profitability, Improved.*
>
>
> _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"

Creating view form in 9.1.2 Error:5165

[Sinclair, Keith]

List,

I am banging my head against the wall on this one as I am not finding out any 
decent information. I cannot create a view form that links to an external DB 
whereas the same view form in my 8.1.2 test system connects without issue.

I have gone through both systems and they seem to be an apples to apples 
comparison. Both DB links are public database links. Both are accessible and 
working inside SQL developer. Thoughts?

5165 Error
Table fields must have at least one column.

Table fields must have at least one column. See the section on Tables for more 
information.

91.2 Running RedHat on Oracle 11g

Keith Sinclair
Remedy Development
ShopperTrak Chicago, USA
O 312.676.8289
ksincl...@shoppertrak.com<mailto:ksincl...@shoppertrak.com> | shoppertrak.com
Retail Profitability, Improved.


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

BIRT Unicode Report Error

[James Stark]

Hi List,
Ran into an issue creating BIRT reports for ARS 8.1 / Midtier 9.1 Running 
Redhat, Apache Tomcat/7.0.59

Created 5 reports that ran successfully, but two of them are giving me the 
following error when run from the report console (they run  correctly from BIRT 
locally on my machine):
"Unable to parse unicode value: ps g"

Thinking it was a font problem, I tried changing the font family from 
sans-serif to Ariel Unicode, but that didn't resolve the issue. It should be 
noted that ONE of the two reports does have a custom barcode font (which has 
been added to the server's lib/font folder). But the other one does not. I have 
examined the data from the record being displayed and found no strange 
characters there either.

Any Thoughts?
Thank you,
James

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

Re: ARMIDTIER Log 623 Error after server reboot RESOLVED

[Hennigan, Sandra H CTR DSS DSS HQ (US)]

Thank you to those that responded over the weekend. Turns out that the system 
folks had added a new certificate but not bound it to port and deleted the old 
cert. 

Sandra



-Original Message-
From: Hennigan, Sandra H CTR DSS DSS HQ (US) 
Sent: Sunday, May 29, 2016 3:36 PM
To: arslist@ARSLIST.ORG
Subject: ARMIDTIER Log 623 Error after server reboot

Anyone out there on a holiday weekend?

We are on ARS & Mid-tier 8.1.01, SQL db
Load-balanced
2 application servers
2 mid-tier servers

All of the servers were restarted Saturday. 
ARS is up and working on both app servers. 
One mid-tier is up and working; no issues. 

Broken mid-tier > 
IIS application pool is started, Tomcat 6 is started (both have been 
restarted). 
Mid-tier config.jsp does not open.

ARMIDTIER.log entry:
Caused due to ERROR (623): Authentication failed

I have googled & BMC Communities the error which all point to the Mid-Tier 
Administrator password or Authentication server setting. The system has been in 
place since 2015 - no change to passwords. 

Question: Can I clear the Mid-Tier Administrator password or Authentication 
server setting in the config.properties and have the system use a NULL password 
and clear the Authentication server? If I reset these in the config.properties 
file - what needs to be restarted? ARS & Mid-tier, ARS only, Mid-tier only?

Any other ideas?  

Assistance is greatly appreciated.  Thank you,

Sandra


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

Re: [Non-DoD Source] Re: ARMIDTIER Log 623 Error after server reboot

[Hennigan, Sandra H CTR DSS DSS HQ (US)]

I copied/pasted the admin passwords from the working Mid-Tier config.properties 
on the working server to the not working Mid-tier config.properties. Tomcat was 
restarted; same output in the armidtier.log

Thank you,

Sandra



-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Sunday, May 29, 2016 5:05 PM
To: arslist@ARSLIST.ORG
Subject: Re: [Non-DoD Source] Re: ARMIDTIER Log 623 Error after server reboot

All active links contained in this email were disabled.  Please verify the 
identity of the sender, and confirm the authenticity of all links contained 
within the message prior to copying and pasting the address to a Web browser.  






No need to restart the app servers, just the tomcat server


On May 29, 2016 2:41:20 PM "Hennigan, Sandra H CTR DSS DSS HQ (US)" 
<sandra.h.hennigan@mail.mil> wrote:

If I copy/paste the password - do I restart the ARS services on the application 
servers?

Thank you,

Sandra



-Original Message-
From: Action Request System discussion list(ARSList) 
[Caution-mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Sunday, May 29, 2016 4:30 PM
To: arslist@ARSLIST.ORG
Subject: [Non-DoD Source] Re: ARMIDTIER Log 623 Error after server reboot

All active links contained in this email were disabled.  Please verify the 
identity of the sender, and confirm the authenticity of all links contained 
within the message prior to copying and pasting the address to a Web browser.






You should be able to copy the password from the config.properties on the 
working server onto the non working one, it might need a format restart, but 
beyond that, I can't imagine what would be causing it


On May 29, 2016 1:36:32 PM "Hennigan, Sandra H CTR DSS DSS HQ (US)"
<sandra.h.hennigan@mail.mil> wrote:

Anyone out there on a holiday weekend?

We are on ARS & Mid-tier 8.1.01, SQL db
Load-balanced
2 application servers
2 mid-tier servers

All of the servers were restarted Saturday.
ARS is up and working on both app servers.
One mid-tier is up and working; no issues.

Broken mid-tier >
IIS application pool is started, Tomcat 6 is started (both have been restarted).
Mid-tier config.jsp does not open.

ARMIDTIER.log entry:
Caused due to ERROR (623): Authentication failed

I have googled & BMC Communities the error which all point to the Mid-Tier 
Administrator password or Authentication server setting. The system has been in 
place since 2015 - no change to passwords.

Question: Can I clear the Mid-Tier Administrator password or Authentication 
server setting in the config.properties and have the system use a NULL password 
and clear the Authentication server? If I reset these in the config.properties 
file - what needs to be restarted? ARS & Mid-tier, ARS only, Mid-tier only?

Any other ideas?

Assistance is greatly appreciated.  Thank you,

Sandra


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

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

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

___
UNSUBSCRIBE or access ARSlist Archives at Caution-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: [Non-DoD Source] Re: ARMIDTIER Log 623 Error after server reboot

[LJ LongWing]

No need to restart the app servers, just the tomcat server


On May 29, 2016 2:41:20 PM "Hennigan, Sandra H CTR DSS DSS HQ (US)" 
<sandra.h.hennigan@mail.mil> wrote:


If I copy/paste the password - do I restart the ARS services on the 
application servers?


Thank you,

Sandra



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

Sent: Sunday, May 29, 2016 4:30 PM
To: arslist@ARSLIST.ORG
Subject: [Non-DoD Source] Re: ARMIDTIER Log 623 Error after server reboot

All active links contained in this email were disabled.  Please verify the 
identity of the sender, and confirm the authenticity of all links contained 
within the message prior to copying and pasting the address to a Web browser.







You should be able to copy the password from the config.properties on the 
working server onto the non working one, it might need a format restart, 
but beyond that, I can't imagine what would be causing it



On May 29, 2016 1:36:32 PM "Hennigan, Sandra H CTR DSS DSS HQ (US)"
<sandra.h.hennigan@mail.mil> wrote:

Anyone out there on a holiday weekend?

We are on ARS & Mid-tier 8.1.01, SQL db
Load-balanced
2 application servers
2 mid-tier servers

All of the servers were restarted Saturday.
ARS is up and working on both app servers.
One mid-tier is up and working; no issues.

Broken mid-tier >
IIS application pool is started, Tomcat 6 is started (both have been 
restarted).

Mid-tier config.jsp does not open.

ARMIDTIER.log entry:
Caused due to ERROR (623): Authentication failed

I have googled & BMC Communities the error which all point to the Mid-Tier 
Administrator password or Authentication server setting. The system has 
been in place since 2015 - no change to passwords.


Question: Can I clear the Mid-Tier Administrator password or Authentication 
server setting in the config.properties and have the system use a NULL 
password and clear the Authentication server? If I reset these in the 
config.properties file - what needs to be restarted? ARS & Mid-tier, ARS 
only, Mid-tier only?


Any other ideas?

Assistance is greatly appreciated.  Thank you,

Sandra


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


___
UNSUBSCRIBE or access ARSlist Archives at Caution-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"

Re: [Non-DoD Source] Re: ARMIDTIER Log 623 Error after server reboot

[Hennigan, Sandra H CTR DSS DSS HQ (US)]

If I copy/paste the password - do I restart the ARS services on the application 
servers?

Thank you,

Sandra



-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Sunday, May 29, 2016 4:30 PM
To: arslist@ARSLIST.ORG
Subject: [Non-DoD Source] Re: ARMIDTIER Log 623 Error after server reboot

All active links contained in this email were disabled.  Please verify the 
identity of the sender, and confirm the authenticity of all links contained 
within the message prior to copying and pasting the address to a Web browser.  






You should be able to copy the password from the config.properties on the 
working server onto the non working one, it might need a format restart, but 
beyond that, I can't imagine what would be causing it


On May 29, 2016 1:36:32 PM "Hennigan, Sandra H CTR DSS DSS HQ (US)" 
<sandra.h.hennigan@mail.mil> wrote:

Anyone out there on a holiday weekend?

We are on ARS & Mid-tier 8.1.01, SQL db
Load-balanced
2 application servers
2 mid-tier servers

All of the servers were restarted Saturday.
ARS is up and working on both app servers.
One mid-tier is up and working; no issues.

Broken mid-tier >
IIS application pool is started, Tomcat 6 is started (both have been restarted).
Mid-tier config.jsp does not open.

ARMIDTIER.log entry:
Caused due to ERROR (623): Authentication failed

I have googled & BMC Communities the error which all point to the Mid-Tier 
Administrator password or Authentication server setting. The system has been in 
place since 2015 - no change to passwords.

Question: Can I clear the Mid-Tier Administrator password or Authentication 
server setting in the config.properties and have the system use a NULL password 
and clear the Authentication server? If I reset these in the config.properties 
file - what needs to be restarted? ARS & Mid-tier, ARS only, Mid-tier only?

Any other ideas?

Assistance is greatly appreciated.  Thank you,

Sandra


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

___
UNSUBSCRIBE or access ARSlist Archives at Caution-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: ARMIDTIER Log 623 Error after server reboot

[LJ LongWing]

You should be able to copy the password from the config.properties on the 
working server onto the non working one, it might need a format restart, 
but beyond that, I can't imagine what would be causing it



On May 29, 2016 1:36:32 PM "Hennigan, Sandra H CTR DSS DSS HQ (US)" 
<sandra.h.hennigan@mail.mil> wrote:


Anyone out there on a holiday weekend?

We are on ARS & Mid-tier 8.1.01, SQL db
Load-balanced
2 application servers
2 mid-tier servers

All of the servers were restarted Saturday.
ARS is up and working on both app servers.
One mid-tier is up and working; no issues.

Broken mid-tier >
IIS application pool is started, Tomcat 6 is started (both have been 
restarted).

Mid-tier config.jsp does not open.

ARMIDTIER.log entry:
Caused due to ERROR (623): Authentication failed

I have googled & BMC Communities the error which all point to the Mid-Tier 
Administrator password or Authentication server setting. The system has 
been in place since 2015 - no change to passwords.


Question: Can I clear the Mid-Tier Administrator password or Authentication 
server setting in the config.properties and have the system use a NULL 
password and clear the Authentication server? If I reset these in the 
config.properties file - what needs to be restarted? ARS & Mid-tier, ARS 
only, Mid-tier only?


Any other ideas?

Assistance is greatly appreciated.  Thank you,

Sandra


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

ARMIDTIER Log 623 Error after server reboot

[Hennigan, Sandra H CTR DSS DSS HQ (US)]

Anyone out there on a holiday weekend?

We are on ARS & Mid-tier 8.1.01, SQL db
Load-balanced
2 application servers
2 mid-tier servers

All of the servers were restarted Saturday. 
ARS is up and working on both app servers. 
One mid-tier is up and working; no issues. 

Broken mid-tier > 
IIS application pool is started, Tomcat 6 is started (both have been 
restarted). 
Mid-tier config.jsp does not open.

ARMIDTIER.log entry:
Caused due to ERROR (623): Authentication failed

I have googled & BMC Communities the error which all point to the Mid-Tier 
Administrator password or Authentication server setting. The system has been in 
place since 2015 - no change to passwords. 

Question: Can I clear the Mid-Tier Administrator password or Authentication 
server setting in the config.properties and have the system use a NULL password 
and clear the Authentication server? If I reset these in the config.properties 
file - what needs to be restarted? ARS & Mid-tier, ARS only, Mid-tier only?

Any other ideas?  

Assistance is greatly appreciated.  Thank you,

Sandra


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


armidtier0.log
Description: armidtier0.log

Re: Change from Normal to Emergency Error

[Brittain, Mark]

I think that’s it. Thanks Kunal.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of kunal das
Sent: Thursday, May 26, 2016 11:22 AM
To: arslist@ARSLIST.ORG
Subject: Re: Change from Normal to Emergency Error

**

Dear Mark,

Thank you for sharing the used case.

The behavior you noticed in 7.6.04 release of Change Management is a known 
Defect SW00438538

You can reach out to BMC Customer support to get the hotfix. Also you may want 
to check the knowledge article 000110366 and test the hotfix attached.

BMC Knowledge Article: 
https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdcid=000110366

I hope this helps.

Regards,

Kunal Das

On Thu, May 26, 2016 at 7:29 PM, Brittain, Mark 
<mbritt...@navisite.com<mailto:mbritt...@navisite.com>> wrote:
**
Hi All,

Running into a strange situation if a user attempts to update the Class/Change 
Timing from Normal to Emergency on an existing Change. ON save (modify) the 
Class gets set back to Normal and the user gets the following message 
ARWARN45538 This change request has been updated since it was opened and will 
be refreshed. Now if a user creates a Change with the Class as Emergency, that 
works fine. I have run the logs and been through all the workflow but can’t 
seem to find why this occurs.

Any ideas/suggestions would be greatly appreciated.
ARS 7.6.04 SP5
ITSM 7.6.04 SP2

Thanks
Mark

Mark Brittain
Sr. Systems Engineer - ITSM
ITILv3 Foundation, Continual Service Improvement
NaviSite, Inc. – A Time Warner Cable Company
mbritt...@navisite.com<mailto:mbritt...@navisite.com>
Office: 315.634.9337
Mobile: 315.882.5360
[navsig]




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: Change from Normal to Emergency Error

[kunal das]

Dear Mark,

Thank you for sharing the used case.

The behavior you noticed in 7.6.04 release of Change Management is a known
Defect *SW00438538*

You can reach out to BMC Customer support to get the hotfix. Also you may
want to check the knowledge article *000110366 *and test the hotfix
attached.

BMC Knowledge Article:
*https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdcid=000110366
<https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdcid=000110366>*

I hope this helps.

Regards,

Kunal Das

On Thu, May 26, 2016 at 7:29 PM, Brittain, Mark <mbritt...@navisite.com>
wrote:

> **
>
> Hi All,
>
>
>
> Running into a strange situation if a user attempts to update the
> Class/Change Timing from Normal to Emergency on an existing Change. ON save
> (modify) the Class gets set back to Normal and the user gets the following
> message ARWARN45538 This change request has been updated since it was
> opened and will be refreshed. Now if a user creates a Change with the Class
> as Emergency, that works fine. I have run the logs and been through all the
> workflow but can’t seem to find why this occurs.
>
>
>
> Any ideas/suggestions would be greatly appreciated.
>
> ARS 7.6.04 SP5
>
> ITSM 7.6.04 SP2
>
>
>
> Thanks
>
> Mark
>
>
>
> *Mark Brittain*
>
> Sr. Systems Engineer - ITSM
>
> ITILv3 Foundation, Continual Service Improvement
>
> *NaviSite, Inc. – A Time Warner Cable Company*
>
> mbritt...@navisite.com
>
> Office: 315.634.9337
>
> Mobile: 315.882.5360
>
> [image: navsig]
>
>
>
> --
>
> 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_

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

Re: [Non-DoD Source] Re: Change from Normal to Emergency Error

[Hennigan, Sandra H CTR DSS DSS HQ (US)]

Check the Company and/or Global Process Flow Configuration and Approval Process 
Configuration. There may be data restrictions/requirements that will need to be 
changed when the Class/Change Timing are changed.

Thank you,

Sandra


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark
Sent: Thursday, May 26, 2016 10:39 AM
To: arslist@ARSLIST.ORG
Subject: [Non-DoD Source] Re: Change from Normal to Emergency Error

All active links contained in this email were disabled. Please verify the 
identity of the sender, and confirm the authenticity of all links contained 
within the message prior to copying and pasting the address to a Web browser. 






**

Hi Tauf,

 

That was a really good idea. Dropped back to Draft from Scheduled, then tried 
to go Emergency and got the same warning message.

 

Mark

 

From: Action Request System discussion list(ARSList) 
[Caution-mailto:arslist@ARSLIST.ORG]On Behalf Of Tauf Chowdhury
Sent: Thursday, May 26, 2016 10:27 AM
To: arslist@ARSLIST.ORG
Subject: Re: Change from Normal to Emergency Error

 

**

Mark,

Which status is the change in? I know that the approval workflow may go nuts if 
you start changing dependent fields past the draft status. 



Sent from my iPhone


On May 26, 2016, at 9:59 AM, Brittain, Mark <mbritt...@navisite.com < 
Caution-mailto:mbritt...@navisite.com > > wrote:

** 

Hi All,

 

Running into a strange situation if a user attempts to update the 
Class/Change Timing from Normal to Emergency on an existing Change. ON save 
(modify) the Class gets set back to Normal and the user gets the following 
message ARWARN45538 This change request has been updated since it was opened 
and will be refreshed. Now if a user creates a Change with the Class as 
Emergency, that works fine. I have run the logs and been through all the 
workflow but can’t seem to find why this occurs.

 

Any ideas/suggestions would be greatly appreciated.

ARS 7.6.04 SP5

ITSM 7.6.04 SP2

 

Thanks

Mark

 

Mark Brittain

Sr. Systems Engineer - ITSM

ITILv3 Foundation, Continual Service Improvement

NaviSite, Inc. – A Time Warner Cable Company

mbritt...@navisite.com < Caution-mailto: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_

_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: Change from Normal to Emergency Error

[Brittain, Mark]

Hi Tauf,

That was a really good idea. Dropped back to Draft from Scheduled, then tried 
to go Emergency and got the same warning message.

Mark

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf Chowdhury
Sent: Thursday, May 26, 2016 10:27 AM
To: arslist@ARSLIST.ORG
Subject: Re: Change from Normal to Emergency Error

**
Mark,
Which status is the change in? I know that the approval workflow may go nuts if 
you start changing dependent fields past the draft status.


Sent from my iPhone

On May 26, 2016, at 9:59 AM, Brittain, Mark 
<mbritt...@navisite.com<mailto:mbritt...@navisite.com>> wrote:
**
Hi All,

Running into a strange situation if a user attempts to update the Class/Change 
Timing from Normal to Emergency on an existing Change. ON save (modify) the 
Class gets set back to Normal and the user gets the following message 
ARWARN45538 This change request has been updated since it was opened and will 
be refreshed. Now if a user creates a Change with the Class as Emergency, that 
works fine. I have run the logs and been through all the workflow but can’t 
seem to find why this occurs.

Any ideas/suggestions would be greatly appreciated.
ARS 7.6.04 SP5
ITSM 7.6.04 SP2

Thanks
Mark

Mark Brittain
Sr. Systems Engineer - ITSM
ITILv3 Foundation, Continual Service Improvement
NaviSite, Inc. – A Time Warner Cable Company
mbritt...@navisite.com<mailto: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: Change from Normal to Emergency Error

[Tauf Chowdhury]

Mark,
Which status is the change in? I know that the approval workflow may go nuts if 
you start changing dependent fields past the draft status. 


Sent from my iPhone

> On May 26, 2016, at 9:59 AM, Brittain, Mark <mbritt...@navisite.com> wrote:
> 
> **
> Hi All,
>  
> Running into a strange situation if a user attempts to update the 
> Class/Change Timing from Normal to Emergency on an existing Change. ON save 
> (modify) the Class gets set back to Normal and the user gets the following 
> message ARWARN45538 This change request has been updated since it was opened 
> and will be refreshed. Now if a user creates a Change with the Class as 
> Emergency, that works fine. I have run the logs and been through all the 
> workflow but can’t seem to find why this occurs.
>  
> Any ideas/suggestions would be greatly appreciated.
> ARS 7.6.04 SP5
> ITSM 7.6.04 SP2
>  
> Thanks
> Mark
>  
> Mark Brittain
> Sr. Systems Engineer - ITSM
> 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_

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

Change from Normal to Emergency Error

[Brittain, Mark]

Hi All,

Running into a strange situation if a user attempts to update the Class/Change 
Timing from Normal to Emergency on an existing Change. ON save (modify) the 
Class gets set back to Normal and the user gets the following message 
ARWARN45538 This change request has been updated since it was opened and will 
be refreshed. Now if a user creates a Change with the Class as Emergency, that 
works fine. I have run the logs and been through all the workflow but can't 
seem to find why this occurs.

Any ideas/suggestions would be greatly appreciated.
ARS 7.6.04 SP5
ITSM 7.6.04 SP2

Thanks
Mark

Mark Brittain
Sr. Systems Engineer - ITSM
ITILv3 Foundation, Continual Service Improvement
NaviSite, Inc. - A Time Warner Cable Company
mbritt...@navisite.com<mailto:mbritt...@navisite.com>
Office: 315.634.9337
Mobile: 315.882.5360
[navsig]




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.

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

Re: Email notifications throws error - Remedy 9

[Su Kaur]

Thanks. That worked.
I cleared out the credentials and tested. All the mailboxes worked as expected.

Thanks!
Kaur

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

Re: Email notifications throws error - Remedy 9

[Su Kaur]

SMTP

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

Re: Email notifications throws error - Remedy 9

[Jayesh]

We faced one issue related to mailbox config in 9.1 but not sure if its related 
to this. In our env after upgrade of ARS mails were staying in email messages 
with status Yes instead of sent. The same configuration was working in 8.1 SP2. 
Finally we got to know from BMC that there is some defect in email engine that 
doesn't support some auth mechanism if you have username and password populated 
in config. We then cleared out both and restarted email engine and then finally 
emails were started flowing from the system 

-Original Message-
From: "Su Kaur" <remedyiss...@gmail.com>
Sent: ‎17-‎05-‎2016 09:31 PM
To: "arslist@ARSLIST.ORG" <arslist@ARSLIST.ORG>
Subject: Re: Email notifications throws error - Remedy 9

I agree LJ. 
Looks like something is wrong with the mailbox configs but these are working on 
prod. I took arx backup of mailbox configs from prod and imported on remedy 9. 
The password and user account fields are intact. Not sure what went wrong 
during import.


Thanks!
Kaur

___
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: Email notifications throws error - Remedy 9

[Walunjkar, Parshuram]

I suspect issue is because of following things
1) Does both of the email engine are running I mean prod and imported 9 email 
engine.   If both email engine running there could chance that exchange is 
rejecting request   which might cause auth failure.
2) Instead of importing arx, Can you please try to create manually mailbox and 
see the result.
Hope this will help.

Thanks
Parshuram


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Su Kaur
Sent: 17 May 2016 9:27 PM
To: arslist@ARSLIST.ORG
Subject: Re: Email notifications throws error - Remedy 9

I agree LJ. 
Looks like something is wrong with the mailbox configs but these are working on 
prod. I took arx backup of mailbox configs from prod and imported on remedy 9. 
The password and user account fields are intact. Not sure what went wrong 
during import.


Thanks!
Kaur

___
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: Email notifications throws error - Remedy 9

[Jason Miller]

What protocol are you sending with (SMTP, MAPI, etc.)?

On Tue, May 17, 2016, 9:01 AM Su Kaur  wrote:

> I agree LJ.
> Looks like something is wrong with the mailbox configs but these are
> working on prod. I took arx backup of mailbox configs from prod and
> imported on remedy 9. The password and user account fields are intact. Not
> sure what went wrong during import.
>
>
> Thanks!
> Kaur
>
>
> ___
> 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: Email notifications throws error - Remedy 9

[Su Kaur]

I agree LJ. 
Looks like something is wrong with the mailbox configs but these are working on 
prod. I took arx backup of mailbox configs from prod and imported on remedy 9. 
The password and user account fields are intact. Not sure what went wrong 
during import.


Thanks!
Kaur

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

Re: Email notifications throws error - Remedy 9

[LJ LongWing]

So, it seems that the ones that are throwing errors have error in
configuration, one where the 'from' is not allowed, and the other where the
user/pass combination is wrong.  Now...based on your statement that these
are the same configs as used in Prodthen one can expect that something
is different between the two, or that they aren't working in prod
either...not entirely sure...but, those don't sound like something wrong
with 9, they sound like something wrong with the mailbox configs :)

On Mon, May 16, 2016 at 10:49 PM, Su Kaur <remedyiss...@gmail.com> wrote:

> **
>
> Notification either returns an ‘Error’ with ‘Client does not have
> permissions to send as this sender' in email logs OR just sits in email
> messages with ‘Send Message->Yes’ and ‘Authentication unsuccessful’ error
> in email logs.
>
> Thanks!
> Kaur
>
> On May 16, 2016, at 1:55 PM, LJ LongWing <lj.longw...@gmail.com
> <lj.longw...@gmail.com>> wrote:
>
> **
> Kaur,
> What is the error if you go look at it?
>
> On Sun, May 15, 2016 at 8:13 PM, Su Kaur <remedyiss...@gmail.com> wrote:
>
>> Hello All,
>>
>> We have a remedy 9 test environment having all the mailbox configurations
>> copied from current prod 7.6.
>> Its a  customized environment with 10 outgoing mailboxes.
>> Some mailboxes are throwing error and the email just sits in the AR
>> System Email Messages with status as "Send Message ->Error"
>> Others are working fine and the notification goes out from remedy to the
>> requester's inbox.
>>
>> What could be the possible reason?
>> Can we have same mailbox configuration on two remedy servers at the same
>> time?
>>
>> Thanks!
>> Kaur
>>
>>
>> ___
>> 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_
>
> _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: Email notifications throws error - Remedy 9

[Su Kaur]

Notification either returns an ‘Error’ with ‘Client does not have permissions 
to send as this sender' in email logs OR just sits in email messages with ‘Send 
Message->Yes’ and ‘Authentication unsuccessful’ error in email logs. 

Thanks!
Kaur

> On May 16, 2016, at 1:55 PM, LJ LongWing <lj.longw...@gmail.com> wrote:
> 
> **
> Kaur,
> What is the error if you go look at it?
> 
>> On Sun, May 15, 2016 at 8:13 PM, Su Kaur <remedyiss...@gmail.com> wrote:
>> Hello All,
>> 
>> We have a remedy 9 test environment having all the mailbox configurations 
>> copied from current prod 7.6.
>> Its a  customized environment with 10 outgoing mailboxes.
>> Some mailboxes are throwing error and the email just sits in the AR System 
>> Email Messages with status as "Send Message ->Error"
>> Others are working fine and the notification goes out from remedy to the 
>> requester's inbox.
>> 
>> What could be the possible reason?
>> Can we have same mailbox configuration on two remedy servers at the same 
>> time?
>> 
>> Thanks!
>> Kaur
>> 
>> ___
>> 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: Email notifications throws error - Remedy 9

[Su Kaur]

I have imported the email mailbox configuration with password field from 
current prod 7.6 to test system 9.0.1. 
I get following message in email error logs

"Authentication unsuccessful. Client does not have permissions to send as this 
sender"

If I update the mailbox configuration record and use a different mailbox/user 
name and password, that works without any issues.
Also, remedy stops sending notifications after 15-20 mins of turning ON the 
email engine. After that, emails just sits in Email Messages and I will have to 
restart the email engine to kick off these notifications.

P.S. Upgrade was successful with email engine warnings. We had to manually 
import 'AR_Email_Workflow.def' file.

Thanks!
Kaur

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

Re: Email notifications throws error - Remedy 9

[LJ LongWing]

Kaur,
What is the error if you go look at it?

On Sun, May 15, 2016 at 8:13 PM, Su Kaur <remedyiss...@gmail.com> wrote:

> Hello All,
>
> We have a remedy 9 test environment having all the mailbox configurations
> copied from current prod 7.6.
> Its a  customized environment with 10 outgoing mailboxes.
> Some mailboxes are throwing error and the email just sits in the AR System
> Email Messages with status as "Send Message ->Error"
> Others are working fine and the notification goes out from remedy to the
> requester's inbox.
>
> What could be the possible reason?
> Can we have same mailbox configuration on two remedy servers at the same
> time?
>
> Thanks!
> Kaur
>
>
> ___
> 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: Email notifications throws error - Remedy 9

[Misi Mladoniczky]

Hi,

Do they not have an accompanying error message?

Anything in the email error logs?

What happens if you change them to "Send" again. Do they always get back to
"Error"?

Have you tried running with debug logging turned on?

There should not be any problems with two identical setups for outgoing
emails. The only problem should be incoming emails where the two servers will
compete for parsing/getting the messages.

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.

> Hello All,
>
> We have a remedy 9 test environment having all the mailbox configurations
> copied from current prod 7.6.
> Its a  customized environment with 10 outgoing mailboxes.
> Some mailboxes are throwing error and the email just sits in the AR System
> Email Messages with status as "Send Message ->Error"
> Others are working fine and the notification goes out from remedy to the
> requester's inbox.
>
> What could be the possible reason?
> Can we have same mailbox configuration on two remedy servers at the same time?
>
> Thanks!
> Kaur
>
> ___
> 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"

Email notifications throws error - Remedy 9

[Su Kaur]

Hello All,

We have a remedy 9 test environment having all the mailbox configurations 
copied from current prod 7.6.
Its a  customized environment with 10 outgoing mailboxes.
Some mailboxes are throwing error and the email just sits in the AR System 
Email Messages with status as "Send Message ->Error" 
Others are working fine and the notification goes out from remedy to the 
requester's inbox.

What could be the possible reason?
Can we have same mailbox configuration on two remedy servers at the same time?

Thanks!
Kaur

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

Re: CMDBBOException occurred: ERROR (120417, Unable to Create SRD

[Sri teja]

Hi,

Am manually creating the SRD. Is the 'SRD arx' is the form name ?

Thanks for your reply.

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

Re: CMDBBOException occurred: ERROR (120417, Unable to Create SRD

[babajan baig]

HI,

First are you creating manually or importing the SRD?

Check if the fields RO Instance ID and Service Recon ID are filled up
properly in the SRD arx..


On Sat, May 7, 2016 at 1:46 AM, Peter Romain <
p.romain.arsl...@parsolutions.co.uk> wrote:

> Sounds like someone has deleted the default
> BMC_GLOBAL_DEFAULT_SRVC_OFFERING CI from BMC_SERVICEOFFERING class in the
> CMDB.
>
> If you have another system check if it exists there and copy it to the
> system causing you a problem.
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] On Behalf Of Sri teja
> Sent: 06 May 2016 19:18
> To: arslist@ARSLIST.ORG
> Subject: CMDBBOException occurred: ERROR (120417, Unable to Create SRD
>
> Help,
>
> Getting below error while trying to create an SRD. Any suggestions would
> be really helpful ?
> Remedy 8.1
>
> CMDBBOException occurred: ERROR (120417): An unknown error occured
> while trying to create a CMDB Relationship Instance between two of the
> business objects; Class : com.bmc.atrium.bol.BORequestableOffering, Id : =
> OI-6679dfb5968f4b48a644bca5ccc3ba54 ; Caused by: ERROR (120040): The
> relationship endpoint instance does not exist.;
> Rel(clsId:BMC.CORE:BMC_DEPENDENCY instId:
> OI-4b59de007fa348549c6a16711600452d can't be created. L-endpoint inst does
> not exist -- , instId: BMC_GLOBAL_DEFAULT_SRVC_OFFERING (ARERR 191005)
>
>
> ___
> 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"

Re: CMDBBOException occurred: ERROR (120417, Unable to Create SRD

[Peter Romain]

Sounds like someone has deleted the default BMC_GLOBAL_DEFAULT_SRVC_OFFERING CI 
from BMC_SERVICEOFFERING class in the CMDB.

If you have another system check if it exists there and copy it to the system 
causing you a problem.


-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sri teja
Sent: 06 May 2016 19:18
To: arslist@ARSLIST.ORG
Subject: CMDBBOException occurred: ERROR (120417, Unable to Create SRD

Help,

Getting below error while trying to create an SRD. Any suggestions would be 
really helpful ?
Remedy 8.1

CMDBBOException occurred: ERROR (120417): An unknown error occured 
while trying to create a CMDB Relationship Instance between two of the business 
objects; Class : com.bmc.atrium.bol.BORequestableOffering, Id : = 
OI-6679dfb5968f4b48a644bca5ccc3ba54 ; Caused by: ERROR (120040): The 
relationship endpoint instance does not exist.; 
Rel(clsId:BMC.CORE:BMC_DEPENDENCY instId: OI-4b59de007fa348549c6a16711600452d 
can't be created. L-endpoint inst does not exist -- , instId: 
BMC_GLOBAL_DEFAULT_SRVC_OFFERING (ARERR 191005)

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

CMDBBOException occurred: ERROR (120417, Unable to Create SRD

[Sri teja]

Help,

Getting below error while trying to create an SRD. Any suggestions would be 
really helpful ?
Remedy 8.1

CMDBBOException occurred: ERROR (120417): An unknown error occured 
while trying to create a CMDB Relationship Instance between two of the business 
objects; Class : com.bmc.atrium.bol.BORequestableOffering, Id : = 
OI-6679dfb5968f4b48a644bca5ccc3ba54 ; Caused by: ERROR (120040): The 
relationship endpoint instance does not exist.; 
Rel(clsId:BMC.CORE:BMC_DEPENDENCY instId: OI-4b59de007fa348549c6a16711600452d 
can't be created. L-endpoint inst does not exist -- , instId: 
BMC_GLOBAL_DEFAULT_SRVC_OFFERING (ARERR 191005)

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

Re: Error while editing a service target in BMC SLM console

[Sri teja]

I have checked people form and i have unrestricted access to all companies, but 
still am getting the same error.

Any ideas please ?

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

Re: Error while editing a service target in BMC SLM console

[munesh konda]

Hi Sri Teja,

Please check your profile in people form whether you got access to the
company you are trying to add in terms n conditions in svt.

Check d below link for more info on access config for people in remedy

https://docs.bmc.com/docs/display/public/itsm90/Configuring+access+for+people

Hope this helps.

Thanks

Regards
Munesh
On 04-May-2016 6:32 pm, "Sri teja" <cooldd...@gmail.com> wrote:

> Hi experts help,
>
> I have an issue editing Service Target. When i am trying to change the
> 'assigned support company'('Assigned Support Company' = "XYZ") name to
> other company in the 'Terms and Conditions' qualification and save it, am
> getting the below error and not able to figure out why ?
>
> ** Note - Each service target must have
> a company (that you have access to) specified in the terms and conditions
> (ARERR 1)
>
>
> ___
> 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"

Error while editing a service target in BMC SLM console

[Sri teja]

Hi experts help,

I have an issue editing Service Target. When i am trying to change the 
'assigned support company'('Assigned Support Company' = "XYZ") name to other 
company in the 'Terms and Conditions' qualification and save it, am getting the 
below error and not able to figure out why ?

** Note - Each service target must have 
a company (that you have access to) specified in the terms and conditions 
(ARERR 1)

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

Re: Admin Error 9911 - SOLVED

[Sinclair, Keith]

I kicked off users that weren’t logging out, which seem to help relieve this 
but the system would only allow me to perform a save or two before the error 
came up again. Restart did fix this completely.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Monday, April 25, 2016 10:49 AM
To: arslist@ARSLIST.ORG
Subject: Re: Admin Error 9911

**
Keith,
As I've never seen this error before, I'm only guessing...but, it seems like 
there is a defined limit (don't know if you can change the limit or not) as to 
how many caches can be in memory at any given point in time.  If the server is 
set in Dev cache mode, I believe that limit is 1...in Prod Cache mode, I guess 
the server manages thingsbut, essentially, every time a change is made that 
requires a re-cache, the server makes a cache copy and then discards the old 
copy when all of the clients that are connected to it are done with their 
transactions.  In your case, it seems like there is a situation where old 
copies are not being discarded...which is either a bug in the server, or you 
have clients that are still using themI can imagine that the only way that 
happens are with long running transactions, or possibly escalations that run 
for an extended period of time?.either way, I think the only thing you can 
do is wait for the old copies to be discarded by the server when its done with 
them...or, as you said...restart the server.

Changing the delay-cache will help multiple saves in short order from creating 
multiple caches, but I don't know if that is a setting that needs a restart to 
take effect or not.

On Mon, Apr 25, 2016 at 8:52 AM, Sinclair, Keith 
<ksincl...@shoppertrak.com<mailto:ksincl...@shoppertrak.com>> wrote:
**
Hi List,

I am getting the following error whenever I try to do anything, like save an 
active link or filter after making a change:

Admin operations are suspended because the number of open caches is at the 
configured limit.; ,  9911

When I found the one entry on BMC’s website, I found it to be unhelpful as I 
have 5gb of free memory and Checking the development cache mode didn’t fix the 
error nor did changing the delay-caching time from 300 to 3600.

Restarting the server isn’t an option right now.

What can I do to resolve this? I am running this on 8.1.2 on LINUX.

Thanks,

Keith Sinclair
Remedy Development
ShopperTrak Chicago, USA
O 312.676.8289
ksincl...@shoppertrak.com<mailto:ksincl...@shoppertrak.com> | 
shoppertrak.com<http://shoppertrak.com>
Retail Profitability, Improved.

_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: Admin Error 9911

[LJ LongWing]

Keith,
As I've never seen this error before, I'm only guessing...but, it seems
like there is a defined limit (don't know if you can change the limit or
not) as to how many caches can be in memory at any given point in time.  If
the server is set in Dev cache mode, I believe that limit is 1...in Prod
Cache mode, I guess the server manages thingsbut, essentially, every
time a change is made that requires a re-cache, the server makes a cache
copy and then discards the old copy when all of the clients that are
connected to it are done with their transactions.  In your case, it seems
like there is a situation where old copies are not being discarded...which
is either a bug in the server, or you have clients that are still using
themI can imagine that the only way that happens are with long running
transactions, or possibly escalations that run for an extended period of
time?.either way, I think the only thing you can do is wait for the old
copies to be discarded by the server when its done with them...or, as you
said...restart the server.

Changing the delay-cache will help multiple saves in short order from
creating multiple caches, but I don't know if that is a setting that needs
a restart to take effect or not.

On Mon, Apr 25, 2016 at 8:52 AM, Sinclair, Keith <ksincl...@shoppertrak.com>
wrote:

> **
>
> Hi List,
>
>
>
> I am getting the following error whenever I try to do anything, like save
> an active link or filter after making a change:
>
>
>
> Admin operations are suspended because the number of open caches is at the
> configured limit.; ,  9911
>
>
>
> When I found the one entry on BMC’s website, I found it to be unhelpful as
> I have 5gb of free memory and Checking the development cache mode didn’t
> fix the error nor did changing the delay-caching time from 300 to 3600.
>
>
>
> Restarting the server isn’t an option right now.
>
>
>
> What can I do to resolve this? I am running this on 8.1.2 on LINUX.
>
>
>
> Thanks,
>
>
>
> *Keith Sinclair*
>
> Remedy Development
>
> ShopperTrak Chicago, USA
>
> *O* 312.676.8289
>
> ksincl...@shoppertrak.com | shoppertrak.com
>
> *Retail Profitability, Improved.*
>
>
> _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"

Admin Error 9911

[Sinclair, Keith]

Hi List,

I am getting the following error whenever I try to do anything, like save an 
active link or filter after making a change:

Admin operations are suspended because the number of open caches is at the 
configured limit.; ,  9911

When I found the one entry on BMC's website, I found it to be unhelpful as I 
have 5gb of free memory and Checking the development cache mode didn't fix the 
error nor did changing the delay-caching time from 300 to 3600.

Restarting the server isn't an option right now.

What can I do to resolve this? I am running this on 8.1.2 on LINUX.

Thanks,

Keith Sinclair
Remedy Development
ShopperTrak Chicago, USA
O 312.676.8289
ksincl...@shoppertrak.com<mailto:ksincl...@shoppertrak.com> | shoppertrak.com
Retail Profitability, Improved.


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

Error Messages

[Thomas Miskiewicz]

Hi Listers,

we use an error handler filter. The filter is triggered when the Web
Service call finds more than one record.

As a result we get something like this:

Error encountered while executing a Web Service :
A CXmlApiException was raised in native code : error 26 : scxmlapi(26)
- Multiple records found (ARERR 9130)
Here Comes our Message  (ARERR 1)

Is it possible to make this error message less elaborate and reduce it to
our message

Here Comes our Message  (ARERR 1)


Thanks
Thomas

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

ARS 9.1 Varchar Conversion utility - JNI error

[Kelly Logan]

Just a quick note if you try to run the Varchar Conversion utility
<https://docs.bmc.com/docs/display/public/brid91/Running+the+VarcharConversion+utility+for+the+MS+SQL+Server>
bundled
with ARS 9.1.00 - The version is not set correctly in the delivered batch
file.

It is set to

:: Set AR API Jar version

set AR_API_VERSION=90_build002

This causes a JNI error as it can't find the "arapi91_build001.jar" file.

Update this line in the batch file to

set AR_API_VERSION=91_build001

And you should be fine.

-- 
Kelly Logan
Senior Consultant
Rapid Technologies, Inc. <http://www.raptek.com>
Office: 313-651-7169
Cell: 313-645-4552

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

Re: Engage 2016 Call for Papers - due March 7 - a discussion suggestion .... technical topics to be covered? URL error fixed below

[Brock, Anne]

Thanks for that correction!

I just got an email that the deadline is extended to March 11, so you have a 
little more time to submit something!

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of arslist
Sent: Monday, March 07, 2016 5:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: Engage 2016 Call for Papers - due March 7 - a discussion 
suggestion  technical topics to be covered? URL error fixed below

**
I head back from support, apparently the problem is that if you click on the 
URL we were given, the final ] is not part of it
I should have noticed that it was black on my screen not blue... The 
following works
https://communities.bmc.com/community/engage/content?filterID=contentstatus[published]~objecttype~objecttype[idea]<https://communities.bmc.com/community/engage/content?filterID=contentstatus%5bpublished%5d~objecttype~objecttype%5bidea%5d>

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of arslist
Sent: March 6, 2016 8:48 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Engage 2016 Call for Papers - due March 7 - a discussion 
suggestion  technical topics to be covered?

**
I have submitted my problem trying to get to where we can vote, I am wondering 
if anyone else is getting this?
When I try to get there, logged in with my Communities ID, I get:
"The area of BMC Communities is visible to registered logged in users. If you 
are logged in when you receive this message then you might not have sufficient 
access privileges to view requested page. Please contact us 
<http://www.bmc.com/forms/nlg/nlg-4200.html> if you need any further 
assistance."

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug
Sent: March 4, 2016 4:01 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Engage 2016 Call for Papers - due March 7 - a discussion 
suggestion  technical topics to be covered?

**
Everyone,

I would strongly encourage you to use the Communities Forum for Engage for 
submitting the "I would like to see but I am not the presenter" type topics.  
That gives visibility to the ideas to everyone.  It gives a chance to vote if 
interested.  It may give you new ideas of things to propose yourself.

Doug

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brock, Anne
Sent: Friday, March 04, 2016 9:56 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Engage 2016 Call for Papers - due March 7 - a discussion 
suggestion  technical topics to be covered?

**
Some of the topics were submitted as Ideas on the Engage forum - you can vote 
on those
https://communities.bmc.com/community/engage/content?filterID=contentstatus[published]~objecttype~objecttype[idea<https://communities.bmc.com/community/engage/content?filterID=contentstatus%5bpublished%5d~objecttype~objecttype%5bidea>]

Not sure if there will be a chance for additional feedback or not; you can ask 
on the forum


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza
Sent: Thursday, March 03, 2016 6:12 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Engage 2016 Call for Papers - due March 7 - a discussion 
suggestion  technical topics to be covered?

**
Where would we get to see a list of ideas that are submitted? Would that be an 
internal list for BMC to review or will that list be published for feedback or 
ratings on ideas that are submitted?

Personally I feel the later is a better idea than having those ideas filtered 
by BMC internally.

Joe


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brock, Anne
Sent: Thursday, March 03, 2016 4:23 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Engage 2016 Call for Papers - due March 7 - a discussion 
suggestion  technical topics to be covered?

Yeah - What he said!
We've had people comment in the past that there weren't enough topics for the 
more technically knowledgeable of you; or not enough topics on things that 
interest you. So please do flood us with topics of interest! Of course, "no 
guarantees" and all that. But would be great to get a good list in! And even 
better if you are able to give the talk!

Anne
*while I do work for BMC I admit I have no say in which topics get chosen and 
which ones don't*


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug
Sent: Thursday, March 03, 2016 11:31 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Engage 2016 Call for Papers - due March 7 - a discussion 
suggestion  technical topics to be covered?

**
Everyone,

I just want to step in here in support of

Re: Engage 2016 Call for Papers - due March 7 - a discussion suggestion .... technical topics to be covered? URL error fixed below

[arslist]

out expenses
becomes much easier.  And, you get to bask in the adoration of the masses
who come to your talk who all want to learn from you!

 

Now on the other side, if there are "talks that you want to see" although
you are not the expert, let's hear about those as well.  There are times
when we have topics or themes that need to be covered and we go and find the
right speaker for a talk on that subject.  So, if there are things you would
really like covered in a talk, please think about a title/abstract (couple
of sentences) about what that talk would be.

 

We would love to be flooded with both kinds of items - talks you want to
propose where you present and talks where you want to be in the audience.

 

 

Now the challenge for you.  In the submissions so far, there is a team OTHER
THAN the Service Support (Remedy products, Discovery, .) that have been
getting a lot of submissions and they are close to - if not there - in
taking over the lead in the number of submissions.  I want to make sure that
there are more submissions of speakers and topic ideas from Service Support
than all other teams COMBINED.  So, let's get busy with submitting those
ideas.

 

Doug Mueller

 

From: Action Request System discussion list(ARSList) [
<mailto:arslist@ARSLIST.ORG> mailto:arslist@ARSLIST.ORG] On Behalf Of
arslist
Sent: Wednesday, March 02, 2016 5:57 PM
To:  <mailto:arslist@ARSLIST.ORG> arslist@ARSLIST.ORG
Subject: Re: Engage 2016 Call for Papers - due March 7 - a discussion
suggestion  technical topics to be covered?

 

** 

let us assume that if we indicate some highly technical development related
topics quickly, that someone who knows that area would submit it if we
showed interest, or that BMC would fill in what we can't.

 

Possibly one might be how to read the new java logs for the core and quickly
know what the true error is (I tend to find a java log rather long  winded
and finger pointing about what caused the issue, so some sort of smart
parser would be nice). I can guess at least one person named John is
chuckling at me right now, so perhaps he could submit that one :)

 

So, think we can gather a top 10 +- of topics that we would love to see
[possibly wanted for years and never see]?

 

Dan

 

From: Action Request System discussion list(ARSList) [
<mailto:arslist@ARSLIST.ORG> mailto:arslist@ARSLIST.ORG] On Behalf Of Brock,
Anne
Sent: March 2, 2016 11:58 AM
To:  <mailto:arslist@ARSLIST.ORG> arslist@ARSLIST.ORG
Subject: ADV: Engage 2016 Call for Papers - due March 7

 

** 

I wanted to remind everyone that the Call for Papers for Engage 2016 ends
March 7th. So if you haven't had a chance to submit your paper yet, you have
under a week!

 

 <https://bmc.g2planet.com/bmcengage2016/cfp>
https://bmc.g2planet.com/bmcengage2016/cfp

 

 

 

Anne Brock

Principal SC

BMC Software

209-417-0481

 <mailto:anne_br...@bmc.com> anne_br...@bmc.com

 

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

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

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

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

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

_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: Goofy Error

[Bala iLink]

Mark,

It appears that the escalation or the workflow triggered by the escalation is 
setting up the 'status' field to NULL, which is a mandatory field. Can you 
check the form name for T1060 in the schema tables and see, why the status is 
updating it to null.

Thanks,
Bala

From: Action Request System discussion list(ARSList) <arslist@ARSLIST.ORG> on 
behalf of Grooms, Frederick W <frederick.w.gro...@xo.com>
Sent: Friday, February 12, 2016 2:37 PM
To: arslist@ARSLIST.ORG
Subject: Re: Goofy Error

Since it is from 390603 it is from an Escalation (At least the Escalation 
kicked off the transaction)

To find it turn on SQL and Filter logging.  Either put them in the same log 
file or find the error in the SQL log and using the TID find it in the Filter 
log

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark
Sent: Thursday, February 11, 2016 3:40 PM
To: arslist@ARSLIST.ORG
Subject: Goofy Error

**
Hi All

Has anyone seen this error before? I thought it was about a KB article with an 
expired review date. But after changing the review date I am still getting this 
error. Get this error in 5 times every minute. Can't find an escalation or 
anything

Thu Feb 11 16:35:21 2016  390603 : The SQL database operation failed. : 
ORA-01407: cannot update ("ARADMIN"."T1060"."C7") to NULL (ARERR 552

ARS 7.6.04 SP5
ITSM 7.6.04 SP2

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

___
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: Goofy Error

[Stone, Brian]

What form is T1060 on your system?

From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on 
behalf of Daniel Wu [danie...@cox.net]
Sent: Thursday, February 11, 2016 9:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Goofy Error

** What form did this occur?

On Thursday, February 11, 2016, Brittain, Mark 
<mbritt...@navisite.com<mailto:mbritt...@navisite.com>> wrote:
**
Hi All

Has anyone seen this error before? I thought it was about a KB article with an 
expired review date. But after changing the review date I am still getting this 
error. Get this error in 5 times every minute. Can’t find an escalation or 
anything

Thu Feb 11 16:35:21 2016  390603 : The SQL database operation failed. : 
ORA-01407: cannot update ("ARADMIN"."T1060"."C7") to NULL (ARERR 552

ARS 7.6.04 SP5
ITSM 7.6.04 SP2

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
[navsig]




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: Goofy Error

[Grooms, Frederick W]

Since it is from 390603 it is from an Escalation (At least the Escalation 
kicked off the transaction)

To find it turn on SQL and Filter logging.  Either put them in the same log 
file or find the error in the SQL log and using the TID find it in the Filter 
log

Fred

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark
Sent: Thursday, February 11, 2016 3:40 PM
To: arslist@ARSLIST.ORG
Subject: Goofy Error

** 
Hi All

Has anyone seen this error before? I thought it was about a KB article with an 
expired review date. But after changing the review date I am still getting this 
error. Get this error in 5 times every minute. Can't find an escalation or 
anything

Thu Feb 11 16:35:21 2016  390603 : The SQL database operation failed. : 
ORA-01407: cannot update ("ARADMIN"."T1060"."C7") to NULL (ARERR 552

ARS 7.6.04 SP5
ITSM 7.6.04 SP2

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

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

Goofy Error

[Brittain, Mark]

Hi All

Has anyone seen this error before? I thought it was about a KB article with an 
expired review date. But after changing the review date I am still getting this 
error. Get this error in 5 times every minute. Can't find an escalation or 
anything

Thu Feb 11 16:35:21 2016  390603 : The SQL database operation failed. : 
ORA-01407: cannot update ("ARADMIN"."T1060"."C7") to NULL (ARERR 552

ARS 7.6.04 SP5
ITSM 7.6.04 SP2

Mark

Mark Brittain
Sr. OSD Systems Engineer
ITILv3 Foundation, Continual Service Improvement
NaviSite, Inc. - A Time Warner Cable Company
mbritt...@navisite.com<mailto:mbritt...@navisite.com>
Office: 315.634.9337
Mobile: 315.882.5360
[navsig]




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.

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

Re: Goofy Error

[Pargeter, Christie M :LSO IS]

I have notes that this query will identify the records that need to be updated 
(Note we are on SQL not Oracle)


select * from tms_task where (Flag = 1) AND (Status < 6000) AND (Status != 
3000) AND (Expected_Time_Out>0)
But it is TMS:SHR:CheckExpectedTimeOut is the object that is failing.

Christie Pargeter  | Sr Technical Analyst | tel 503-415-5149

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark
Sent: Thursday, February 11, 2016 1:40 PM
To: arslist@ARSLIST.ORG
Subject: Goofy Error

**
Hi All

Has anyone seen this error before? I thought it was about a KB article with an 
expired review date. But after changing the review date I am still getting this 
error. Get this error in 5 times every minute. Can't find an escalation or 
anything

Thu Feb 11 16:35:21 2016  390603 : The SQL database operation failed. : 
ORA-01407: cannot update ("ARADMIN"."T1060"."C7") to NULL (ARERR 552

ARS 7.6.04 SP5
ITSM 7.6.04 SP2

Mark

Mark Brittain
Sr. OSD Systems Engineer
ITILv3 Foundation, Continual Service Improvement
NaviSite, Inc. - A Time Warner Cable Company
mbritt...@navisite.com<mailto:mbritt...@navisite.com>
Office: 315.634.9337
Mobile: 315.882.5360
[navsig]




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_

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

Re: Goofy Error

[Daniel Wu]

What form did this occur?

On Thursday, February 11, 2016, Brittain, Mark <mbritt...@navisite.com>
wrote:

> **
>
> Hi All
>
>
>
> Has anyone seen this error before? I thought it was about a KB article
> with an expired review date. But after changing the review date I am still
> getting this error. Get this error in 5 times every minute. Can’t find an
> escalation or anything
>
>
>
> Thu Feb 11 16:35:21 2016  390603 : The SQL database operation failed. :
> ORA-01407: cannot update ("ARADMIN"."T1060"."C7") to NULL (ARERR 552
>
>
>
> ARS 7.6.04 SP5
>
> ITSM 7.6.04 SP2
>
>
>
> Mark
>
>
>
> *Mark Brittain*
>
> Sr. OSD Systems Engineer
>
> ITILv3 Foundation, Continual Service Improvement
>
> *NaviSite, Inc. – A Time Warner Cable Company*
>
> mbritt...@navisite.com
> <javascript:_e(%7B%7D,'cvml','mbritt...@navisite.com');>
>
> Office: 315.634.9337
>
> Mobile: 315.882.5360
>
> [image: navsig]
>
>
>
> --
>
> 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_

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

Selecting more than 10 records in MT report error

[Sinclair, Keith]

Okay, here's something I want to see if anyone else has come across. When a 
user selects 10 records in Mid-Tier, clicks the 'report' button and selects a 
predefined Crystal Report, the report displays all ten records without issue.

When they select 11+, the report, displays with the following error:

This field name is not known. Details: errorKind Error in File 
BillingSiteProfileINSTALLATION111213v2008 
{80500510-C253-4CCB-8850-13FF6F5878C3}.rpt: Error in formula Record_Selection: 
'({CHG_Change.Change_ID_}="C020715")or({CHG_Change.Change_ID_}="C043567")or({CHG_Change.Change_ID_}="C049824")or({CHG_Change.Change_ID_}="C054514")or({CHG_Change.Change_ID_}="C054515")or({CHG_Change.Change_ID_}="C054516")or({CHG_Change.Change_ID_}="C058635")or({CHG_Change.Change_ID_}="C058636")or({CHG_Change.Change_ID_}="C065950")or({CHG_Change.Change_ID_}="C068192")or({CHG_Change.Change_ID_}="C069264")'
 This field name is not known. Details: errorKind

Any ideas why this happens? I have refreshed the report, verified the DB, etc.
Specs: 8.1.2 MT & ARS on CentOS, Oracle11 DB, Tomcat 7.

Keith Sinclair
Remedy Development
ShopperTrak Chicago, USA
O 312.676.8289
ksincl...@shoppertrak.com<mailto:ksincl...@shoppertrak.com> | shoppertrak.com
Retail Profitability, Improved.


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

Re: Selecting more than 10 records in MT report error

[Misi Mladoniczky]

Hi,

My guess would be that it is a specific record that is the problem, rather
than the number of records. Can you check that out?

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

> Okay, here's something I want to see if anyone else has come across. When a
> user selects 10 records in Mid-Tier, clicks the 'report' button and selects a
> predefined Crystal Report, the report displays all ten records without issue.
>
> When they select 11+, the report, displays with the following error:
>
> This field name is not known. Details: errorKind Error in File
> BillingSiteProfileINSTALLATION111213v2008
> {80500510-C253-4CCB-8850-13FF6F5878C3}.rpt: Error in formula Record_Selection:
> '({CHG_Change.Change_ID_}="C020715")or({CHG_Change.Change_ID_}="C043567")or({CHG_Change.Change_ID_}="C049824")or({CHG_Change.Change_ID_}="C054514")or({CHG_Change.Change_ID_}="C054515")or({CHG_Change.Change_ID_}="C054516")or({CHG_Change.Change_ID_}="C058635")or({CHG_Change.Change_ID_}="C058636")or({CHG_Change.Change_ID_}="C065950")or({CHG_Change.Change_ID_}="C068192")or({CHG_Change.Change_ID_}="C069264")'
> This field name is not known. Details: errorKind
>
> Any ideas why this happens? I have refreshed the report, verified the DB, etc.
> Specs: 8.1.2 MT & ARS on CentOS, Oracle11 DB, Tomcat 7.
>
> Keith Sinclair
> Remedy Development
> ShopperTrak Chicago, USA
> O 312.676.8289
> ksincl...@shoppertrak.com<mailto:ksincl...@shoppertrak.com> | shoppertrak.com
> Retail Profitability, Improved.
>
>
> ___
> 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: Selecting more than 10 records in MT report error

[Sinclair, Keith]

Well, the report runs fine with 11+ records when called through the User Tool, 
so I am thinking it's a mid-tier related issue now. Perhaps hitting a 
memory/cache limit?

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Wednesday, February 10, 2016 11:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: Selecting more than 10 records in MT report error

Hi,

My guess would be that it is a specific record that is the problem, rather than 
the number of records. Can you check that out?

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

> Okay, here's something I want to see if anyone else has come across. 
> When a user selects 10 records in Mid-Tier, clicks the 'report' button 
> and selects a predefined Crystal Report, the report displays all ten records 
> without issue.
>
> When they select 11+, the report, displays with the following error:
>
> This field name is not known. Details: errorKind Error in File
> BillingSiteProfileINSTALLATION111213v2008
> {80500510-C253-4CCB-8850-13FF6F5878C3}.rpt: Error in formula Record_Selection:
> '({CHG_Change.Change_ID_}="C020715")or({CHG_Change.Change_ID_}="C043567")or({CHG_Change.Change_ID_}="C049824")or({CHG_Change.Change_ID_}="C054514")or({CHG_Change.Change_ID_}="C054515")or({CHG_Change.Change_ID_}="C054516")or({CHG_Change.Change_ID_}="C058635")or({CHG_Change.Change_ID_}="C058636")or({CHG_Change.Change_ID_}="C065950")or({CHG_Change.Change_ID_}="C068192")or({CHG_Change.Change_ID_}="C069264")'
> This field name is not known. Details: errorKind
>
> Any ideas why this happens? I have refreshed the report, verified the DB, etc.
> Specs: 8.1.2 MT & ARS on CentOS, Oracle11 DB, Tomcat 7.
>
> Keith Sinclair
> Remedy Development
> ShopperTrak Chicago, USA
> O 312.676.8289
> ksincl...@shoppertrak.com<mailto:ksincl...@shoppertrak.com> | 
> shoppertrak.com Retail Profitability, Improved.
>
>
> __
> _ 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"

Re: Selecting more than 10 records in MT report error

[Ludwig, Sally]

The User tool uses a built in viewer and does not interact with the Crystal 
Reports Server/BOXI.So comparing the running of the report in the User Tool 
to the running of the report from the Midtier client is comparing 'apples to 
oranges'.  Most likely there is a Crystal/BOXI setting or webserver setting 
that is truncating the qualification and thus generating the error.  

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Wednesday, February 10, 2016 3:01 PM
To: arslist@ARSLIST.ORG
Subject: Re: Selecting more than 10 records in MT report error

Hi,

That may well be, but 11 is not a big number. Can you please try another set of 
11 records, and also 9 records overlapping record id 11 to make sure that it is 
not related to a specific record?

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

> Well, the report runs fine with 11+ records when called through the 
> User Tool, so I am thinking it's a mid-tier related issue now. Perhaps 
> hitting a memory/cache limit?
>
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
> Sent: Wednesday, February 10, 2016 11:54 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Selecting more than 10 records in MT report error
>
> Hi,
>
> My guess would be that it is a specific record that is the problem, 
> rather than the number of records. Can you check that out?
>
> Best Regards - Misi, RRR AB, http://rrr.se
>
>> Okay, here's something I want to see if anyone else has come across.
>> When a user selects 10 records in Mid-Tier, clicks the 'report' 
>> button and selects a predefined Crystal Report, the report displays 
>> all ten records without issue.
>>
>> When they select 11+, the report, displays with the following error:
>>
>> This field name is not known. Details: errorKind Error in File
>> BillingSiteProfileINSTALLATION111213v2008
>> {80500510-C253-4CCB-8850-13FF6F5878C3}.rpt: Error in formula
>> Record_Selection:
>> '({CHG_Change.Change_ID_}="C020715")or({CHG_Change.Change_ID_}="C043567")or({CHG_Change.Change_ID_}="C049824")or({CHG_Change.Change_ID_}="C054514")or({CHG_Change.Change_ID_}="C054515")or({CHG_Change.Change_ID_}="C054516")or({CHG_Change.Change_ID_}="C058635")or({CHG_Change.Change_ID_}="C058636")or({CHG_Change.Change_ID_}="C065950")or({CHG_Change.Change_ID_}="C068192")or({CHG_Change.Change_ID_}="C069264")'
>> This field name is not known. Details: errorKind
>>
>> Any ideas why this happens? I have refreshed the report, verified the 
>> DB, etc.
>> Specs: 8.1.2 MT & ARS on CentOS, Oracle11 DB, Tomcat 7.
>>
>> Keith Sinclair
>> Remedy Development
>> ShopperTrak Chicago, USA
>> O 312.676.8289
>> ksincl...@shoppertrak.com<mailto:ksincl...@shoppertrak.com> | 
>> shoppertrak.com Retail Profitability, Improved.
>>
>>
>> _
>> _ _ 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"
>

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