[Date Prev] [Date Next] [Prev in Thread] [Next in Thread] [Date Index] [Thread Index]

Re: Limiting AIE data exchange



**
Hi,
 
What versions are you systems on?
 
Check the BMC Atrium Integration Engine User's 7.6.03  Guide under Performance considerations (page 21)
 
--
Regards

Satya

The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or support representative for BMC Software, Inc.


 
On Tue, Nov 29, 2011 at 4:12 PM, jaya munjal <jaya_munjal@yahoo.com> wrote:
**
Hi Satya
 
Is this documented somewhere as I checked with BMC support and they mentioned there is no limit on the data tranfer in a single exchange
 
Regards
Jaya

From: Satya Gandhi <satya.gandhi@GMAIL.COM>
To: arslist@ARSLIST.ORG
Sent: Tuesday, November 29, 2011 9:01 PM

Subject: Re: Limiting AIE data exchange

**
Hi,
 
AIE till v7.6.04 has the 2GB limit on data that can be transferred on a exchange. IF you feel the number of records to be transferred exceeds this 2GB size limit  split it across multiple exchanges and use queries.
 
Satya

On Tue, Nov 29, 2011 at 2:36 PM, jaya munjal <jaya_munjal@yahoo.com> wrote:
**
Thanks Ashutosh, I'll try.
I have been hit by another road block using AIE is that its not transfering more than 40K records, whereas I need to transfer around 7 Lakh records.
 
I get an error in the log file as
 
<ERR   > WaitForThreadsToComplete: Threads Completed: 48 TimerCnt Reached
[Tue Nov 29 2011 06:17:46.3590] - <TID: 004> <STATE >    CreateEntry:      7, GetVendorData:    856 Requests total:   3332, added:   3332, updated:      0, deleted: 0, errors: 0, warnings: 0
[Tue Nov 29 2011 06:17:46.3590] - <TID: 004> <STATE > Waiting for next chunk
[Tue Nov 29 2011 06:17:46.9710] - <TID: 001> <STS   > WaitForThreadsToComplete: Threads Completed: 49
[Tue Nov 29 2011 06:18:09.9390] - <TID: 013> <STATE > Waiting for next chunk
[Tue Nov 29 2011 06:18:09.9490] - <TID: 001> <ERR   > ProcessBulkExchange - Could not obtain Vendor asset list.
[Tue Nov 29 2011 06:18:09.9490] - <TID: 001> <ERR   > Unable to create key lists. No exchange will take place.

From: "Tripathi, Ashutosh" <ashutosh.tripathi@LOGICA.COM>
To: arslist@ARSLIST.ORG
Sent: Tuesday, November 29, 2011 7:42 PM
Subject: Re: Limiting AIE data exchange

**
Hi Jaya,
 
I also faced issue in limiting data using the queries but I was trying to import in Remedy from external data source.
 
It was simply failing for some query (I do not remember), then I tweaked the query and made it simpler, to my surprise it worked that way.
 
What I would suggest here is first you check only with Status = Enabled and see if AIE is able to find differentiate between Enabled and Disabled Site.
 
Next you try with only other part of query that is $SubmitDate$ >= $TIMESTAMP$-8460. This way you will be able to identify which Query AIE does not understand.
 
In my case AIE was able to differentiate both queries independently but not when using together.
 
If this is case with you also probably you need to differentiate records at Remedy form only using an escalation (an option).
 
Thanks,
 
Ashutosh Tripathi | Remedy Application Management Services
DLF IT Park, 5th Block, 4th Floor, Manapakkam, Chennai- 600089 | India
VOIP: 36164 | M: +91 98 84 72 08 90
mailto:ashutosh.tripathi@logica.com | http://www.logica.com/
Logica Pvt Ltd, registered in India (registered number U30007KA1998PTC023830)
Registered Office: 124-125, Divyasree Technopolis, Yemlur P.O.,Off Airport Road, Bangalore 560037, India
 
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of jaya munjal
Sent: Monday, November 28, 2011 2:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Limiting AIE data exchange
 
**
looks there is some bug with AIE 7.6.03 version that its not considering the qualifaction for AIE data exchange. I have opened any issue with BMC but they have as usual collects logs and screenshot but have not been able to confirm if its a syntax issue or a product issue.
 
Anyone else who has any experince of limiting data exchange in AIE using the data query on AR form
 
Regards
Jaya
 
From: Misi Mladoniczky <miz@RRR.SE>
To: arslist@ARSLIST.ORG
Sent: Monday, November 28, 2011 2:01 PM
Subject: Re: Limiting AIE data exchange

Hi,

Strange that they changed this convention...

In other places, such as in a filter/actl set-/push-fields search, you can
also select fields. You can choose both the $-fields and '-fields. The
$-fields is just fixed data, and the '-fields represents columns in the
database.

For example ('Submitter' = $USER$) would translate to something like
('Submitter' = "miz") if I am logged in.

And ($Submitter$ = $USER$) will be something completely different, ("miz"
= "miz") if my name is in the current records Submitter-field.

The latter will match everything in the database...

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


Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
* 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/.


> Hi Misi
>  
> This doesnt work either :-(, on the AIE data exchange there is an option
> to select AR form fields and the Syntax there comes as $field$
>  
> Regards
> jaya
>
> From: Misi Mladoniczky <miz@RRR.SE>
> To: arslist@ARSLIST.ORG
> Sent: Monday, November 28, 2011 12:43 PM
> Subject: Re: Limiting AIE data exchange
>
> Hi,
>
> If you use $-signs, you are typically referencing your current
> transaction, not columns in the database.
>
> I think your query should read:
> 'Status'="Enabled" AND 'SubmitDate' >= $TIMESTAMP$-24*60*60
>
>         Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>
> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
> * 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.
>
>> Hi
>>  
>> I want to transfer only sites which are enabled and have been created in
>> the last 24 hrs to be transfered from SIT:Site form to a table in
>> External
>> database (oracle).
>>  
>> I have defined the below query in the data query section of the AR form
>> data mapping but transfers all records.
>>  
>> $Status$="Enabled" and $SubmitDate$ >= $TIMESTAMP$-8460.
>>  
>> On enabling the SQL logs it still shows no query defined and transfer
>> all
>> records.
>>  
>> I have below questions
>>  
>> 1) Is possible to put a criteria on the data exchange happening from AR
>> System to External DB
>> 2) If its possible then do I need to build the query using some special
>> syntax
>>  
>> Environment.
>> ARS 7.6.03
>> CMDB 7.6.03
>> ITSM 7.6.03
>> DB - Oracle 10g
>> AIE  -7.6.03
>> OS - Windows 2008
>>
>> _______________________________________________________________________________
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

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

Think green - keep it on the screen. This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_


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



--
Regards

Satya

The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or support representative for BMC Software, Inc.
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_


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




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