Re: Atrium Core 9.1.07 issue

[Ravindrakumar Rodge]

1. As you are accessing from midtier, I would check with fiddler log to
find out the call, that will help me identify it's corresponding midtier
call in midtier log which in turn will help with server side API call in
server API, SQL, fltr logs. I have a feeling that +VER call would be
failing.

Regards,
Ravi


On Wed 4 Sep, 2019, 10:55 AM Shivanand Jeerigiwad, <
shivanand.jeerigi...@gmail.com> wrote:

> Hi Kunal/Salman,
>
> No records stuck in the OBJSTR forms.
>
>
> Mid Tier : 9.1.08
> AR Server : 9.1.07
> Atrium Core: 9.1.07
> Linux Box
>
> Regards,
>
> Shiva
> +91 9986985798
>
>
>
> On Tue, Sep 3, 2019 at 9:49 PM Salman Shaikh 
> wrote:
>
>> Can you share the OS details on which AR/Atrium Core installed?
>>
>> On Tue, Sep 3, 2019, 8:12 PM Kunal Shah  wrote:
>>
>>> Check the below form.
>>>
>>> Form : OBJSTR:Class and OBJSTR:Attribute definition check any pending
>>> record.
>>>
>>>
>>> Regards
>>> Kunal Shah
>>>
>>> On Tue, Sep 3, 2019, 7:56 PM Shivanand Jeerigiwad <
>>> shivanand.jeerigi...@gmail.com> wrote:
>>>
 Hi Kunal

 Tried with that option already.  No help as such..

 On Tue, Sep 3, 2019, 7:48 PM Kunal Shah  wrote:

> Hello
>
>
> Perform the mid tier hard cache flush on all the mid tier.
>
>
> Regards
> Kunal Shah
>
> On Tue, Sep 3, 2019, 3:28 PM Shivanand Jeerigiwad <
> shivanand.jeerigi...@gmail.com> wrote:
>
>> HI Team,
>>
>> After upgrading to 9.1.07 we are not able login to the Atrium Core.
>>
>> Getting below error.
>> Atrium Core Console doesn't work, Authentication Error, Message box
>> says [Object Object]
>>
>> It was fixed in 7.6.04 SP1.. Now same issue we can see in 9.1.07...
>> Is anybody faced this issue or any solutions ?
>>
>>
>> Regards,
>>
>> Shiva
>> +91 9986985798
>>
>> --
>> 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
>>
> --
> 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: Installer is performing a secondary server install/upgrade, No forms will be imported.

[Ravindrakumar Rodge]

Wonder if the Operating-mode parameter playing any role which decides if
all servers are upgraded or not in server group. We have that parameter
available in 9.x.

Worth checking it.

Regards,
Ravi

On Mon, Apr 29, 2019, 9:46 AM Thomas Miskiewicz  wrote:

> Doug
>
>
> You said: Even if you change that dbversion, that shouldn’t solve the
> problem.  Even though the key was supposed to be the version number,
> simply changing it doesn’t make the DB structure the old version.
>
>
> That’s exactly my point: Can someone please reveal to us the specific
> criteria by which the installer decides whether a server is secondary vs
> primary.
>
>
> I do have servers that were upgraded successfully and are considered
> primary. I don’t see any difference in DB structure between secondary and
> primary servers and it’s be illogical if it were or if the rule once
> primary always primary applied.
>
>
> Once you’re in a server group you should be able to take any server out of
> the group. So if there is a particular DB in place I guess you wouldn’t be
> able to do that as the primary/ secondary thing is set in stone. Just a
> thought!
>
>
> Thomas
>
> On 29. Apr 2019, at 05:50, Reif, Douglas  wrote:
>
> Thomas,
>
> I’m sure there was a lot of thought put into this by Engineering with the
> intention of making the install process easier.
>
> When the installer changes were made, it was with the plan to help
> customers out by automating some of the decisions made by the installer.
>
> Having said that, I understand exactly what you are talking about.I
> can’t do much about the way the installer behaves other than suggest an
> Idea on the Communities page.   But as far as the installer choosing the
> wrong option,  I will look into that a little more.
>
> I am traveling this week and may not get back right away. But I’ll do my
> best.
>
> If there is an open case with this, you can ask the Support person to
> contact me and I will work with them.
>
>
>
> One more thing.  Even if you change that dbversion, that shouldn’t solve
> the problem.  Even though the key was supposed to be the version number,
> simply changing it doesn’t make the DB structure the old version.  As far
> as I know, there is no way to downgrade the db other than actually
> reverting the db
>
> Thanks,
>
> Doug
>
>
>
>
>
>
>
> *From:* ARSList [mailto:arslist-boun...@arslist.org
> ] * On Behalf Of *Thomas Miskiewicz
> *Sent:* Saturday, April 27, 2019 9:46 PM
> *To:* ARSList 
> *Subject:* [EXTERNAL] Re: Installer is performing a secondary server
> install/upgrade, No forms will be imported.
>
>
>
> The thing is that I have reset the currdbversion but that doesn’t do
> anything.
>
>
>
> Well in the last pre installation screen the info “Installer is
> performing a secondary server install/upgrade, No forms will be imported”
> disappeared indeed but it did appear after the fact at the end of the
> installation. So there must be more to it than just currdbversion.
>
>
>
> With other fresh installations I’ve noticed for instance that if you set
> the alias and the host name to different values you end up with the same
> problem. Why? Unfortunately I’ve noticed to late with this server and I’m
> trying to recover from that costly “mistake”.
>
>
>
> Why doesn’t the installer make such a guessing game out of this? Cannot we
> just ask primary/secondary and make this more transparent and manageable?
>
>
> On 28. Apr 2019, at 00:04, Reif, Douglas  wrote:
>
> Was there doubt with what I stated earlier?
>
> If what I said doesn’t jive with reality,  I can go back and do some more
> research but all the evidence I’ve seen points to the CurrDBVersion being
> the key.
>
> Let me know if you see the currDBversion and dbversion in the control
> table being 57 (not higher)  and yet it still thinks it is  secondary
> install when installing 1902.
>
> As I mentioned, the Secondary install believes that the DB was already
> upgraded. If this is not the case,  there could be a situation where it
> doesn’t follow the rules and we will have to look into that
>
>
>
> DougR
>
>
>
>
>
>
>
> *From:* ARSList [mailto:arslist-boun...@arslist.org
> ] *On Behalf Of *Thomas Miskiewicz
> *Sent:* Saturday, April 27, 2019 7:59 AM
> *To:* ARSList 
> *Subject:* [EXTERNAL] Re: Installer is performing a secondary server
> install/upgrade, No forms will be imported.
>
>
>
> Thanks Abhijit,
>
>
>
> I upgraded from 9.1.04 to the latest version and the installer still says
> it’s a secondary server.
>
>
>
> This server is just an archive and it’s running fine so I think I’ll leave
> it like this.
>
>
>
> It remains a mystery to me that BMC apparently doesn’t know the exact
> procedure they use to determine whether it’s a primary or a secondary
> server.
>
>
>
> After spending countless hours with their support to no avail I’m giving
> up.
>
>
>
>
>
> Thomas
>
>
> On 27. Apr 2019, at 13:30, Abhijit Hendre  wrote:
>
> For 9.1.04 , there is a roll back utility to roll back platform upgrade
> 

Re: FTS reindex

[Ravindrakumar Rodge]

I second LJ. there will be an indexer Java process which you can kill upon
cleaning of the ft pending and ft collection content.

If even that doesn't work.

Remove fts license.

Regards,
Ravindrakumar

On Thu, Jan 17, 2019, 5:08 AM Kevin Shaffer  It still says re-index in progress, is there a way to reset that flag?
>
>
>
> [image: Partner Logo-EmailSig] 
>
> Kevin Shaffer
>
> Partner IT, Inc.
>
> (C) 316-208-5341
>
> (O) 888-380-8899
>
> (F) 708-887-1704
>
>
>
> *From:* ARSList  *On Behalf Of *La Grua, Ed
> via ARSList
> *Sent:* Wednesday, January 16, 2019 2:25 PM
> *To:* ARSList 
> *Cc:* La Grua, Ed 
> *Subject:* RE: FTS reindex
>
>
>
> Just delete all the records in ft_pending.
>
>
>
> delete from ft_pending
>
> commit
>
>
>
>
>
> Regards,
>
>
>
> Ed La Grua
>
> CTO Operations | Application Production Support for CTO | 222 Broadway,
> New York, N.Y.|w 212.647.4311| c 917.583.0443
>
>
>
> *From:* ARSList [mailto:arslist-boun...@arslist.org] *On Behalf Of *Kevin
> Shaffer
> *Sent:* Wednesday, January 16, 2019 3:20 PM
> *To:* ARSList
> *Subject:* FTS reindex
>
>
>
> 8.1.02
>
>
>
> Is there a way to force stop a FTS re-index?  We had a mistake in in our
> configuration and we want to re-index but we have a re-index already in
> progress.
>
>
>
> [image: Partner Logo-EmailSig]
> 
>
> Kevin Shaffer
>
> Partner IT, Inc.
>
> (C) 316-208-5341
>
> (O) 888-380-8899
>
> (F) 708-887-1704
>
>
> --
>
> This message, and any attachments, is for the intended recipient(s) only,
> may contain information that is privileged, confidential and/or proprietary
> and subject to important terms and conditions available at
> http://www.bankofamerica.com/emaildisclaimer. If you are not the intended
> recipient, please delete this message.
> --
> 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: Unsubscribe

[Ravindrakumar Rodge]

Hi,


You need to check.
1. Escalations are running on the server or not.
2. How many records stuck on cai:events form and clean unwanted stuck
records.
3. Ensure cai:plugin registry has threads defined as documented. (form name
CAI:Plugin Registry)
4. Ensure the z1DAction values are defined in the escalation in below link
as it is escalation responsible for processing the records.

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

5. Check with arerror.log and arjavaplugin. लोग with Debug Mode for more
details.

6. Enable Api sql fltr and reproduce the issue. That will give some inputs
and leads.

Try to do performance check and ensure your servers are properly configured
for threads.

Regards,
Ravindrakumar

On Tue, Mar 27, 2018, 10:48 AM Mark Rushton  wrote:

>
>
> Sent from my iPhone 6 
>
> On 26 Mar 2018, at 19:28, Tauf Chowdhury  wrote:
>
> Totally doing this from memory but I’m pretty sure the reason is that the
> query is looking at the product catalog form and timing out. You can try to
> be more specific in your query or do some tuning on those tables.
>
>
> Sent from my iPhone
>
> On Mar 26, 2018, at 2:03 PM, LJ LongWing  wrote:
>
> Well, for #1, you are issuing a query to the db that's not returning in
> the 120 second timeoutfor #2 you are getting disconnected from the
> DBboth scenarios are pointing to a DB that is either overwhelmed, or
> under performing...I would highly recommend working with your DBA to figure
> out what's happening at the DB level first.
>
> On Mon, Mar 26, 2018 at 11:52 AM, Dinesh Kumar  wrote:
>
>> Hi All,
>>
>> We are facing below issue in our environment which causes a higher impact
>> and Business critical.
>>
>>
>>
>> SRM Fulfillment requests are not getting generated.
>>
>>
>>
>> The requests are getting struck in the *CAI Events* form in the Running
>> status for all the events (SRM_OUT_RESTART_SR_SUBMIT, TMS_OUT_GET_DATA).
>>
>> We could see that PDT’s are also not getting connected to the Service
>> Requests. (adding screenshot).
>>
>>
>>
>>
>>
>> We are getting time out errors in the plugin and ARERR logs for the
>> certain requests.
>>
>>
>>
>> *Error-1:*
>>
>>
>>
>> 2018-02-14 09:12:55,772 ERROR [pool-2-thread-4]
>> com.bmc.itsm.cai.filterapi.cai.worker.BaseEventWorker
>> (BaseEventWorker.java:166) - CAI plugin failed to update error code of
>> event:TMHAA5V0GJ3KKAPEER8HBGHK64BVRP. Failed with following exception.
>> ERROR (94): Timeout during database query -- consider using more specific
>> search criteria to narrow the results, and retry the operation;
>> ATVIEUUSMS006:2000 ONC/RPC call timed out
>>
>>
>>
>> *Error-2:*
>>
>>
>>
>> Wed Feb 14 09:24:49 2018 390627 : The SQL database operation failed.
>> (ARERR 552)
>>
>> Wed Feb 14 09:24:49 2018 ORA-03135: connection lost contact
>>
>> Process ID: 315236
>>
>> Session ID: 411 Serial number: 60447
>>
>> Wed Feb 14 09:24:49 2018 lastsql UPDATE T2457 SET
>> C112=';100018;',C5='Remedy Application Service',C6=1518531886 WHERE C1
>> = 'PDT5704'
>>
>> Wed Feb 14 09:24:53 2018 390627 : SQL database is now available (ARNOTE
>> 592)
>>
>> SRM:ProcessDefinitionTemplate_Base(T2457) is getting locked and we are
>> not able to create any request fulfillment after that.  Then we need to
>> manually release.
>>
>>
>>
>> Has one faced this kind of issues.
>>
>>
>> Thanks,
>>
>> Dinesh kumar.
>>
>> --
>> 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: 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.

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

Re: What is locking my account?

[Ravindrakumar Rodge]

Hi Thomas,

I just tried extracting the API call and below is the API call I figured
out based on RPC ID.

   
   /* Di Mär 13 2018 19:43:43.2420 */ *+RCU
 ARReleaseCurrentUser *-- ize0578 as user ize0578 from Unidentified Client
(protocol 25) at IP address 2.104.1.205 using RPC // :q:0.0s
   
   /* Di Mär 13 2018 19:43:43.2430 */ SELECT
entryId, allowedClientType, authUserName, badPwd, badPwdTotal, email,
fixedLicChange, licType, licTypeApp, licTypeFText, licTypeReserv1,
licensePool, longAuthString, longCompGroup, longGroup, notifyMech,
password, pwdChange, serverId, shortAuthString, shortCompGroup, shortGroup,
timestamp, userName, validateKey FROM user_cache WHERE (entryId =
'109')
   
   /* Di Mär 13 2018 19:43:43.2440 */ OK
   
   /* Di Mär 13 2018 19:43:43.2470 */
LOGOUT ize0578 (local provided session id 1683 not found)
   
   /* Di Mär 13 2018 19:43:43.2490 */ *-RCU
OK*


This looks like the user is released and so you are getting this LOGOUT.

Now if your account is getting locked, I would suggest you to check out on
below things.
1. If your environment is configured with AREA-LDAP, check with
arjavaplugin.log in debug mode.
2. If this is integrated with RSSO, check with trace logs of RSSO, which
can be enabled from RSSO Admin Console.

Those will give you more clarity as to why the user is not able to login OR
is getting locked out.

Regards,
Ravindrakumar

On Wed, Mar 21, 2018 at 3:41 AM, Thomas Miskiewicz 
wrote:

> We used that method before with same results.
>
> The we switched to this example:
> http://soleauthority.net/entry-inspector-a-java-filterapi-plugin-sample/
>
>
>
> On Wed 21. Mar 2018 at 09:24, Jarl Grøneng  wrote:
>
>>
>> When you create a new ARServerUser object, should`t you do a login?
>>
>> arCtx.login();
>>
>>
>>
>> --
>> J
>>
>> 2018-03-20 18:45 GMT+01:00 Thomas Miskiewicz :
>>
>>> Thanks for pointing this out, Fred, bu there is no error in my code.
>>>
>>> I just mad a mistake extracting snippets. The code looks like this:
>>>
>>> public List filterAPICall(ARPluginContext context, List
>>> inValues)
>>> {
>>> if (context!=null) {
>>> String sPort=context.getARConfigEntry("TCD-Specific-Port");
>>> Integer port=new Integer(sPort);
>>>
>>>
>>> ARServerUser arCtx = new ARServerUser(context, "de_DE",
>>> "localhost");
>>> arCtx.setPort(port);
>>> }
>>> }
>>>
>>>
>>> On Mar 20, 2018, at 5:23 PM, Grooms, Frederick W <
>>> frederick.w.gro...@xo.com> wrote:
>>>
>>> Maybe I’m confused, but I think there may be an error in your code
>>> You are setting the port to  serverPort, but your integer value is just
>>> port
>>>
>>>
>>> *From:* ARSList [mailto:arslist-boun...@arslist.org
>>> ] *On Behalf Of *Thomas Miskiewicz
>>> *Sent:* Tuesday, March 20, 2018 11:12 AM
>>> *To:* ARSList 
>>> *Subject:* Re: What is locking my account?
>>>
>>> Thank you Keith, good to know.
>>>
>>> 1. We’re not windows.
>>>
>>> 2. We don’t have more than one server defined in the mid-tier
>>>
>>> I rather thing that it’s related to a ARS bug which attacks when we use
>>> our ARF Plugin.
>>>
>>>
>>> Thomas
>>>
>>>
>>> On Mar 20, 2018, at 5:05 PM, spearmint.l...@gmail.com wrote:
>>>
>>> I haven't followed this whole thread, so not sure if this was mentioned.
>>> We had a problem in the past where if you had more than one AR server
>>> defined in the mid-tier, then anytime you try to login it attempts to log
>>> into each AR server defined. So if you have three AR servers defined, and
>>> your Windows system is set to lock after three bad attempts, then just one
>>> incorrect password when trying to log in will lock you out.
>>>
>>> Regards,
>>> Keith
>>>
>>> On Tue, Mar 20, 2018 at 6:14 AM Thomas Miskiewicz 
>>> wrote:
>>>
>>> Unfortunately it’s still locking.
>>>
>>> I enabled all kinds of debugs and see this:
>>>
>>> Di Mär 20 10:41:19.086 2018 Preparing context to be sent to
>>> pluginserver -  User : NULL, sessionId : 0, authGuid : NULL, cacheId :
>>> 9279, threadId : 366
>>> 360393 Di Mär 20 10:41:19.099 2018 Preparing context to be sent to
>>> pluginserver -  User : NULL, sessionId : 0, authGuid : NULL, cacheId :
>>> 9280, threadId : 366
>>> 360394 Di Mär 20 10:41:19.109 2018 Preparing context to be sent to
>>> pluginserver -  User : NULL, sessionId : 0, authGuid : NULL, cacheId :
>>> 9281, threadId : 366
>>> 360395 Di Mär 20 10:41:19.118 2018 Preparing context to be sent to
>>> pluginserver -  User : NULL, sessionId : 0, authGuid : NULL, cacheId :
>>> 9282, threadId : 366
>>> 360396 Di Mär 20 10:41:33.252 2018   >> 447731>   >> Application Service (Pool 1) > 
>>> /* Di Mär 20 2018 10:41:33.2520 */ Escalation Trace Log -- ON (AR Server
>>> 9.1.04 201711272256)
>>> 360397 Di Mär 20 10:41:33.418 2018   >> 447731>   >> Application Service (Pool 1) > 
>>> /* Di 

Re: Dev Studio broken after Upgrade to 9.1.03.001

[Ravindrakumar Rodge]

Try with the option of clearing the cache as shown in the screenshot.

Also clear the workspace OR try with a different workspace.

Regards,
Ravindrakumar



On Thu, Mar 22, 2018 at 1:09 AM, Thomas Miskiewicz 
wrote:

> The solutions was: the Private-RPC-Socket: 390601 1 2 was missing in the
> ar.conf
>
> I don’t understand why this dumb installer cannot automatically check the
> ar.conf for standard parameters. As a matter of fact Dev Studio was working
> just fine before the upgrade and we would expect that it keeps working
> after the upgrade.
>
>
> On Mar 21, 2018, at 5:31 PM, LJ LongWing  wrote:
>
> You ran the log from
> 11:16:16
> to
> 11:17:41
>
> That's just under 1.5 mintimeouts occur at the 2 min window if I'm not
> mistaken
>
> Please turn on API/SQL before trying to load the items, wait for the
> timeout, and turn them off, if you already did that, I don't see any
> problems...the longest API call that finished within the relatively short
> window you provided lasted a whole 1 second.  Tell us what user id you are
> using to do the call with
>
> There were 3 API calls that started around the beginning of the log that
> didn't finish in the 1.5 min of logbut because we don't have the end of
> them, we can't determine how long they ran for
>
> On Wed, Mar 21, 2018 at 9:12 AM, Thomas Miskiewicz 
> wrote:
>
>>
>>
>>
>> Attached - so far I don’t see the reason for this behavior.
>>
>> On Mar 21, 2018, at 4:08 PM, LJ LongWing  wrote:
>>
>> With Timeouts, I always look to the API/SQL logs for helptrack what
>> sql calls are taking place and how long they are taking.
>>
>> On Wed, Mar 21, 2018 at 8:06 AM, Thomas Miskiewicz 
>> wrote:
>>
>>> Hi Listers,
>>>
>>> we have successfully upgraded our archive stand alone server from
>>> 8.1.00.002 to 9.1.03.001 Hotfix from Oct 2017.
>>>
>>> We can login and work using the Mid Tier.
>>>
>>> Dev Studio takes ages to log in. At other times the login works
>>> smoothly, we can load the form list but we cannot open the Active Link,
>>> Filter, Guides Lists as we get a time one saying that the server is busy.
>>>
>>> Any ideas where to start looking? The support has no clue so far.
>>>
>>>
>>> Thomas
>>>
>>> --
>>> 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
>
>


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

Re: [Non-DoD Source] Need input on Delta load - Spoon client

[Ravindrakumar Rodge]

There is NGIE:Delta form that holds the last successful run which can be
used to run the job for delta part.

Regards,
Ravindrakumar

On Aug 29, 2017 12:15 AM, "Scott Philben"  wrote:

> **
> I am in the middle of this. Here is what I did (based on a thing I found
> on Communities). You have to set a checksum value in the data stream the
> first time you call AD. Then the second time you can do a DB call to the
> table you are using (I have a staging form) and filter out the ones that
> already exist based on that same checksum value. If there is no checksum
> difference, it gets passed to Dummy, otherwise it goes through to the
> AROutput step.
>
> Not quite done with testing it, but it seems to be doing what I need.
>
> [image: PastedImage-1.png]
>
> On Aug 28, 2017, at 02:37 PM, Joe D'Souza  wrote:
>
> There is something funky about the AR API that is used by Pentaho Spoon.
> If I recall correctly, the $OPERATION$ value at the time of create as well
> as update is CREATE. Something funky like that. I do not recall specifics,
> but you could try a small experiment to ascertain this for yourself.
>
>
>
> Create a filter on Remedy that writes to a temp field the $OPERATION$
> value. You will notice that irrespective of the type of operation, the
> $OPERATION$ value is always CREATE.
>
>
>
> So in effect it appears like Pentaho really does not know the difference.
> I didn’t have the opportunity to look deeper into this at the time I was
> working on a Spoon job recently, but it appeared to me like it processes
> all records irrespective during a execution.. Thankfully since Pentaho does
> a massive update using a data pipe that can be sized appropriately
> according to the expected size of the feeds, performance is not really that
> much of a concern if you have your JVMs configured correctly.
>
>
>
> One way to process only the delta from the AR side would be to have
> Pentaho work on a staging form instead of the load form, and then have
> similar workflow like the load form to check for duplicates on both the
> People and the Load form and process only those records that do not get
> tagged as a duplicate on either the load nor the people form.
>
>
>
> Joe
>
>
> --
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Shivanand Jeerigiwad
> *Sent:* Monday, August 28, 2017 7:21 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: [Non-DoD Source] Need input on Delta load - Spoon client
>
>
>
> **
>
> Hi Ryan,
>
>
>
> Yes, i am passing.. My scenario is like in a day if i process 100 records
> it successfully creates people record. But the next day it should not
> consider the same old records unless if it is not updated at LDAP side. How
> i can achieve this?
>
>
> Regards,
>
> Shiva
> +91 9986985798
>
>
>
>
>
> On Mon, Aug 28, 2017 at 4:47 PM, Nicosia, Ryan J CTR USSOCOM SOCOM J631 <
> ryan.nicosia@socom.mil> wrote:
>
> Are you passing "VALIDATELOAD" into z1D_Action field?  That triggers the
> workflow to run.
>
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] On Behalf Of Shivanand Jeerigiwad
> Sent: Monday, August 28, 2017 6:32 AM
> To: arslist@ARSLIST.ORG
> Subject: [Non-DoD Source] Need input on Delta load - Spoon client
>
> **
> Hi team,
>
> I am trying to achieve the LDAP People Integration. I can able to pull
> people records from LDAP server to BMC staging i.e CTM:LoadPeople form.
> However, not getting how to achieve the delta load.
>
> If anybody has done, please let me know.
>
>
> Regards,
>
> Shiva
> +91 9986985798
>
> _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"
>
>
>
> _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: HIRING REMEDY ENGINEERS

[Ravindrakumar Rodge]

Hi,

I am interested with the above mentioned profile.

Please find my attached profile..

Regards,
Ravindrakumar
(+91) 9028792208

On 10 Mar 2017 11:07 p.m., "Del Wester"  wrote:

> **
> I'm interested in learning more. Please find my resume attached.
>
>
> Thanks,
> Del Wester
> 214-682-1764
> delwes...@gmail.com
>
>
>
> On Fri, Mar 10, 2017 at 10:41 AM, Jen Loeffler 
> wrote:
>
>> **
>>
>> I am looking to hire Remedy Engineers for our contract in Fort Huachuca,
>> Arizona ---
>>
>> Great Pay and will help with relocation if needed.
>>
>> Secure contract and you would be a direct hire of QBE.
>>
>> candidates must have a security clearance (SECRET).
>>
>>
>>
>> Please shoot me your resume, if interested.
>>
>>
>>
>> Thank you,
>>
>>
>>
>> Jen Loeffler
>>
>> Sr. Program Manager/AFSO
>>
>> jen.loeff...@qbe.net
>>
>> Office Line: 571-248-7490 ext. 1001 <(571)%20248-7490>
>>
>> Cell: 571-455-9132 <(571)%20455-9132>
>>
>>
>>
>> [image: qbe_logo]
>>
>> 14600 Washington Street
>>
>> Haymarket, VA 20169
>>
>>
>>
>> _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"


march_17_Resume_Ravindrakumar.pdf
Description: Adobe PDF document

Re: 9.1 Upgrade Change HostID

[Ravindrakumar Rodge]

Upgrade of itsm on top of AR should not change host id. Remedy doesn't make
changes or touches host I'd during installation.

If upgrade should have changed the host id then that should have got
changed during AR upgrade only which I believe must have not happened.

I am not sure if the server is hosted on VM or Physical machine, but if the
server is hosted on VM then VM has settings that makes host id static or
dynamic. You might would like to check with that??

Regards,
Ravindrakumar

On 2 Sep 2016 5:32 pm, "Frank Caruso"  wrote:

> We are in the process of upgrading our ITSM 81.02 environment to ITSM
> 9.1.  After the ARS portion of the upgrade we are noticing that the HostID
> used for licensing changes. This is an upgrade in place and some for the
> servers have been around for more 2 years with the same license key. The
> arerror.log file has the following entry after ARS is upgraded and the
> server is restarted:
>
> Thu Sep 01 08:48:54.978 2016 Action Request System(R) Server (x64) Version
> 9.1.00.001 201606141104
> (c) Copyright 1991-2016 BMC Software, Inc.
> Thu Sep 01 08:48:58.552 2016 Thu Sep 01 08:48:58.552 2016 Loading AR
> System objects information...
> Thu Sep 01 08:50:54.088 2016 success
> Thu Sep 01 08:50:54.603 2016 390600 : The server identifier has changed
> but the current "AR Server" license key will still be honored. (ARNOTE
> 9827) Old Host ID: 005056937825, Current Host ID: 0050569361AF
>
> BMC assures me that nothing has changed with 9.1 in how it gets the HostID
> yet on three server upgrades the same thing has happened?
>
> Anyone else experience this or have an explanation on why this might be
> happening?
>
> TIA
> Frank Caruso
>
> 
> ___
> 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: Remedy 9.0.01 - CPU utilization and write license issues

[Ravindrakumar Rodge]

I hope you are aware about floating license known issues in 9.x versions so
that will answer your questions of license.

For cpu utilization check if there is any integration with ws or any heavy
operation is being carried out by remedy.

You can now collect heap dump and thread dump using jvisualvm tool.

Regards,
Ravindrakumar

On 5 Jul 2016 6:43 am, "Tauf Chowdhury"  wrote:

> As all things server related it could be many things but:
> 1. Is it the areerver process causing the utilization?
> If no, check antivirus or some other agent like splunk or something.
> If yes:
> 1. Run logging if you can pinpoint the time. Could be runaway escalation
> or scheduled report or if there is a job pulling from an external DB,
> slowness at the source could cause processing to slow and overflow at the
> AR level too.
>
>
> Sent from my iPhone
>
> > On Jul 4, 2016, at 7:41 PM, Kaur  wrote:
> >
> > Yes, we have separated db and mid tier server.
> > We increased the CPU count from 4 to 8 and RAM from 16GB to 32 GB. Even
> when there is no activity on the server and only 20 users are logged in,
> CPU utilization is going up to 80% bringing down the remedy services. Also,
> increased the java heap size in server.config file.
> > We are still having issues and its happening every 3rd day.
> >
> > Please suggest!
> >
> > 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"
>

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

Re: Blank Body in AR System Email Messages form

[Ravindrakumar Rodge]

What do you observe in log when you send an plain text mail, html mail from
Outlook.
Can you check with the content type in debug email logs. when sending an
email to incoming configured email.

Regards,
Ravindrakumar
On 16-Sep-2015 11:38 AM, "Satpal Singh Ply" 
wrote:

> **
> Hello Terri,
>
> We have seen this issue, this might happen due to Exchange Server Version
> or the format of an email has. Please find the KB below, this might help
> you to resolve the issue.
>
>
> https://kb.bmc.com/infocenter/index?page=content=KA362351=search=en_US=1441776705345
>
> Regards,
> Satpal Singh
>
> On Thu, Sep 3, 2015 at 12:41 AM, Terri Lockwood <
> teresa.lockw...@sungard.com> wrote:
>
>> **
>>
>> Thank you John.  Both the Plain Text Body and HTML Body fields are blank
>> in the AR System Email Messages form.  Under Advanced Options/Attachment
>> Alternatives I do see the .eml file but again it is blank as well.  I
>> forgot to mention that this is an intermittent issue…doesn’t happen all the
>> time so logging is tough as well.  Troubleshooting continues…..
>>
>>
>>
>> *TERRI*
>>
>>
>>
>> *From:* Action Request System discussion list(ARSList) [mailto:
>> arslist@ARSLIST.ORG] *On Behalf Of *Reiser, John J
>> *Sent:* Wednesday, September 02, 2015 2:16 PM
>> *To:* arslist@ARSLIST.ORG
>> *Subject:* Re: Blank Body in AR System Email Messages form
>>
>>
>>
>> **
>>
>> Terri,
>>
>> I’ve seen this and the message body usually ends up in the HTML Body tab
>> on the AR System Email form.
>>
>> Also, in the advanced options tab there are three more tabs. The
>> Attachment Alternatives has an Attachment Pool and one of the attachments
>> is almost always a an email file.
>>
>> So the data are there you may need to change workflow to retrieve it into
>> the ticket.
>>
>>
>>
>> Maybe there’s a way to force your email inbox to only accept ( or convert
>> to) plain text.
>>
>> Thank you,
>>
>> ---
>> John J. Reiser
>> Building 760-J202
>> Remedy Developer/Administrator
>>
>> Senior Software Development Analyst
>> Lockheed Martin - MST Moorestown Region
>> The star that burns twice as bright burns half as long.
>> Pay close attention and be illuminated by its brilliance. - paraphrased
>> by me
>>
>>
>>
>> *From:* Action Request System discussion list(ARSList) [
>> mailto:arslist@ARSLIST.ORG ] *On Behalf Of *Terri
>> Lockwood
>> *Sent:* Wednesday, September 02, 2015 1:54 PM
>> *To:* arslist@ARSLIST.ORG
>> *Subject:* EXTERNAL: Blank Body in AR System Email Messages form
>>
>>
>>
>> **
>>
>> I am hoping someone has had this same issue and can help me.  I do
>> already have a ticket with BMC as well.
>>
>>
>>
>> When our customers send an email to our email address it comes into the
>> mailbox complete and I can see it.  However, when it gets pushed to the AR
>> System Email Messages form the “Plain Text Body” field is blank.  It,
>> therefore, gets pushed into the ticket with a blank body as well.  BMC is
>> looking at our logs but I was hoping someone has seen this and maybe can
>> provide a solution.
>>
>>
>>
>> Thank you,
>>
>>
>>
>> ~~~
>>
>> Terri
>>
>>
>>
>> ARS 7.6.04
>>
>> ITSM 7.6.03
>>
>> Midtier 7.6.04
>>
>> Windows 2008
>>
>> MS SQL 2008 R2 SP2
>>
>>
>>
>> _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: sample data in ITSM

[Ravindrakumar Rodge]

Installing sample data is at users discretion. Usually that can help you
with testing of apps after installation.

Regards,
Ravindrakumar
On 13-Sep-2015 2:01 AM, "Omega LiPO"  wrote:

> **
> If you need to understand the flow, sample data can help
> --
> From: Kiran Patil 
> Sent: ‎12/‎09/‎2015 23:56
> To: arslist@ARSLIST.ORG
> Subject: Re: sample data in ITSM
>
> **
>
> You can ignore sample data.
>
> On Sat 12 Sep, 2015 17:51 Sandeep Pandey  wrote:
>
>> **
>> Dear List,
>>
>> I am going to install fresh ITSM version 9.0 in production environment.
>> My query is about sample data which comes with installer. Do we required
>> sample data to check while installing fresh installation because this will
>> unnecessarily consume user licenses aprrox # 15.
>>
>> What are the advantages/disadvantages of sample data while ITSM
>> operational?
>>
>> Thanks.
>>
>> BR,
>> Sandy
>> _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: Question on overlays - when?

[Ravindrakumar Rodge]

Yes 7.6.04
On 12-Sep-2015 1:48 PM, "Jason Miller"  wrote:

> **
> It was in the 7.6.03 beta and was removed for GA to address some issues
> found. It went GA in 7.6.04.
>
> On Fri, Sep 11, 2015 at 9:09 AM LJ LongWing  wrote:
>
>> **
>>
>> Yes, 7.6.03 did not have overlay, 7.6.04 did :)
>> On Fri, Sep 11, 2015 at 8:24 AM, Walters, Mark 
>> wrote:
>>
>> **
>>
>> My bad – it was 7.6.04.
>>
>>
>>
>> *From:* Walters, Mark
>> *Sent:* 11 September 2015 15:59
>> *To:* arslist@ARSLIST.ORG
>> *Subject:* RE: Question on overlays - when?
>>
>>
>>
>> 8.1
>>
>>
>>
>> Mark
>>
>>
>>
>> *From:* Action Request System discussion list(ARSList) [
>> mailto:arslist@ARSLIST.ORG ] *On Behalf Of *
>> richard@bwc.state.oh.us
>> *Sent:* 11 September 2015 15:47
>> *To:* arslist@ARSLIST.ORG
>> *Subject:* Question on overlays - when?
>>
>>
>>
>> **
>>
>> In which version of ARserver/Remedy did the base and overlay forms
>>
>> first appear?
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Portions of this message may be confidential under an exemption to Ohio's
>> public records law or under a legal privilege. If you have received this
>> message in error or due to an unauthorized transmission or interception,
>> please delete all copies from your system without disclosing, copying, or
>> transmitting this message. Portions of this message may be confidential
>> under an exemption to Ohio's public records law or under a legal privilege.
>> If you have received this message in error or due to an unauthorized
>> transmission or interception, please delete all copies from your system
>> without disclosing, copying, or transmitting this message. Portions of this
>> message may be confidential under an exemption to Ohio's public records law
>> or under a legal privilege. If you have received this message in error or
>> due to an unauthorized transmission or interception, please delete all
>> copies from your system without disclosing, copying, or transmitting this
>> message.
>>
>> _ARSlist: "Where the Answers Are" and have been for 20 years_
>> BMC Software Limited Registered Office: Building E2, Eskdale Road,
>> Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in
>> England No. 1927903 The content of this email is confidential. If you are
>> not the addressee, you may not distribute, copy or disclose any part of it.
>> If you receive this message in error, please delete this from your system
>> and notify the sender immediately. _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: Scheduled Report is not running in BMC remedy 8.1

[Ravindrakumar Rodge]

You can try with the steps mentioned in my last mail and see if that helps.

Regards,
Ravi
On 07-Sep-2015 1:34 PM, "Jithin T.R" <jithin.t.radhakrish...@gmail.com>
wrote:

> **
> Hi Bruce,
>
> Thanks for your time.
>
> I have issue with Scheduled web report.
>
> Hi Ravi,
>
> Thank you for your time on this.
>
> However, we are not getting any error while running this report manually
> and it occurs only for scheduled report.
>
> Today some users received an error through email as below.
>
>
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:199)
>
> org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:75)
> com.bmc.arsys.plugins.report.RunReport.executeReport(Unknown Source)
> com.bmc.arsys.plugins.report.RunReport.runReport(Unknown Source)
> com.bmc.arsys.plugins.report.PublishReport$1.run(Unknown Source)
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
> java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
> java.util.concurrent.FutureTask.run(FutureTask.java:138)
>
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
>
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> java.lang.Thread.run(Thread.java:662)
>
> Thanks & Regards,
> Jithin
>
> On Fri, Sep 4, 2015 at 8:55 PM, Ravindrakumar Rodge <raviru...@gmail.com>
> wrote:
>
>> **
>>
>> Hi Jatin,
>>
>> In Remedy 8.1 report uses a Java plugin called as ARSYS ARDBC
>> REPORTENGINE.
>> This plugin configuration is present in ar. Cfg file and it runs on port
>> .
>> Since this is java plugin it's logs will be generated in arjavaplugin.log
>> under dB folder.
>>
>> If you see any errors on the screen while running the reports then we can
>> enable api sql fltr logs and check with the plugin related work flow.
>>
>> if you can take back up of your birt folder under pluginsvr.
>> Delete the birt folder n take the same folder from one of working
>> environment.
>> Place the birt folder of working environment in same non working
>> location.
>> Now from the backup folder of birt navigate to lib folder under that you
>> will find a folder with your server name.
>> Copy that n place it in the working copied folder.
>>
>> Restart the Web server to take changes effect.
>>
>> That should help resolve the issue. Let me know if that helps you.
>>
>> Regards,
>> Ravindrakumar
>> On 04-Sep-2015 4:02 PM, "Jithin T.R" <jithin.t.radhakrish...@gmail.com>
>> wrote:
>>
>>> **
>>> Hi Team,
>>>
>>> Our customers are reporting  that scheduled report is not running in BMC
>>> Remedy 8.1 (it was running).  These reports are created using AR System
>>> Report console and scheduled using OOTB feature comes with 8.1.
>>>
>>> Could you please help me to trouble shoot this issue ?
>>>
>>> Which logs I should go through ?
>>>
>>> is there any plug-in log (Report Scheduler plug-in ) ? From the online
>>> documents this plug-in is related with BIRT
>>>
>>> Thanks & Regards,
>>> Jithin
>>> _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: Scheduled Report is not running in BMC remedy 8.1

[Ravindrakumar Rodge]

Hi Jatin,

In Remedy 8.1 report uses a Java plugin called as ARSYS ARDBC REPORTENGINE.
This plugin configuration is present in ar. Cfg file and it runs on port
.
Since this is java plugin it's logs will be generated in arjavaplugin.log
under dB folder.

If you see any errors on the screen while running the reports then we can
enable api sql fltr logs and check with the plugin related work flow.

if you can take back up of your birt folder under pluginsvr.
Delete the birt folder n take the same folder from one of working
environment.
Place the birt folder of working environment in same non working location.
Now from the backup folder of birt navigate to lib folder under that you
will find a folder with your server name.
Copy that n place it in the working copied folder.

Restart the Web server to take changes effect.

That should help resolve the issue. Let me know if that helps you.

Regards,
Ravindrakumar
On 04-Sep-2015 4:02 PM, "Jithin T.R" 
wrote:

> **
> Hi Team,
>
> Our customers are reporting  that scheduled report is not running in BMC
> Remedy 8.1 (it was running).  These reports are created using AR System
> Report console and scheduled using OOTB feature comes with 8.1.
>
> Could you please help me to trouble shoot this issue ?
>
> Which logs I should go through ?
>
> is there any plug-in log (Report Scheduler plug-in ) ? From the online
> documents this plug-in is related with BIRT
>
> Thanks & Regards,
> Jithin
> _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: Server Information

[Ravindrakumar Rodge]

I see the version that you are using is 8.1,  I believe there must be C
plug in and Java plug in entries would be present. Try either commenting of
C plug in or Java plugin.

C plugin would be entries as
- Plugin : server administration. dll
- plugin-path: path to plugin location

JAVA Plugin would be :
- Server-Plugin-Alias: ARSYS. ARDBC. SERVERADMINISTRATION ARSYS. ARDBC.
SERVERADMINISTRATION :

Other option would be to collect the working Def and place it in non
working environment.

Let me know if that helps.

Regards,
Ravindrakumar
On 28-Aug-2015 9:38 PM, "Fannin, Teresa S." <
teresa.s.fan...@accenturefederal.com> wrote:

> **
>
> All,
>
> If I select Server Information I get a timeout error.  System 8.1 ITSM,
>  Windows 8,  SQl DB 12.
>
> Working with BMC they suggest to delete the following and reimport from
> the serveradmin.def file.
>
> 1) AR System Administration: Add Or Remove Licenses
>
> 2) AR System Administration: License Review
>
> 3) AR System Administration: Server Information
>
> 4) AR System Administration: Support Form
>
>
>
> Now, import serveradmin.def file by using developer studio to re-import
> all the above forms back to remedy.
>
> The default location of the serveradmin.def is :-
>
> \ARserver installation directory\ arsever name\arserver\install
> form\en\serveradmin.def.
>
>
>
> AR System Administration: Add Or Remove Licensescould not be found in
> the def file
>
> AR System Administration: License Review replaced with the one
> from the def file
>
> AR System Administration: Server Information  replaced with the one
> from the def file
>
> AR System Administration: Support Formreplaced with the
> one from the def file
>
>
>
> Restart services.
>
>
>
>
>
> But still have the same problem.
>
>
>
> Any ideas?
>
> Thanks,
>
> Teresa
>
>
>
>
>
>
> _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: Reports cutting off at 2000 records

[Ravindrakumar Rodge]

There's a parameter in ar. cfg which sets the server cache size.
Server-side-chunk-size:
It must be set to 2000.
Also check if the server is licensed or its being used in evaluation mode.
Evaluation mode only retrieve 2000 records from any form.

- Ravindrakumar
On 20-Feb-2015 10:13 PM, Terri Lockwood teresa.lockw...@sungard.com
wrote:

 **

 I've got a dilemma that I'm hoping you experts can help me with.  Have a
 development system with version 8.1.01.  I'm trying to pull company
 records and have tried both from AR User and from MidTier.  I can pull
 2412 records from both but when I make a report on the web it is only
 showing 2000 records. (Report from User tool reports on all 5000)  I went
 into the System Admin console and found that under the Configuration tab
 the *Max Entries Returned By GetList* was set to 2000.  I have changed
 it to 5000 and saved it.  I cleared both browser and server cache but it
 will still only return 2000 records using the web.  I then restarted both
 the app and midtier server.  Sill the same.  Where am I missing another
 setting?  Thanks in advance for your help!





 ~~~

 Terri



 ARS 8.1.01

 ITSM 8.1.01

 Midtier 8.1.01

 Windows 2008 R2

 MS SQL 2008 R2 SP2


  _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: Reports cutting off at 2000 records

[Ravindrakumar Rodge]

Adding to above also check if in preferences user is set to retrieve those
many records only due to which you are getting 2000 records.


-Ravindrakumar
On 22-Feb-2015 7:37 PM, Ravindrakumar Rodge raviru...@gmail.com wrote:

 There's a parameter in ar. cfg which sets the server cache size.
 Server-side-chunk-size:
 It must be set to 2000.
 Also check if the server is licensed or its being used in evaluation mode.
 Evaluation mode only retrieve 2000 records from any form.

 - Ravindrakumar
 On 20-Feb-2015 10:13 PM, Terri Lockwood teresa.lockw...@sungard.com
 wrote:

 **

 I've got a dilemma that I'm hoping you experts can help me with.  Have a
 development system with version 8.1.01.  I'm trying to pull company
 records and have tried both from AR User and from MidTier.  I can pull
 2412 records from both but when I make a report on the web it is only
 showing 2000 records. (Report from User tool reports on all 5000)  I
 went into the System Admin console and found that under the Configuration
 tab the *Max Entries Returned By GetList* was set to 2000.  I have
 changed it to 5000 and saved it.  I cleared both browser and server
 cache but it will still only return 2000 records using the web.  I then
 restarted both the app and midtier server.  Sill the same.  Where am I
 missing another setting?  Thanks in advance for your help!





 ~~~

 Terri



 ARS 8.1.01

 ITSM 8.1.01

 Midtier 8.1.01

 Windows 2008 R2

 MS SQL 2008 R2 SP2


  _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