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_mun...@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.gan...@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_mun...@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.tripa...@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.tripa...@logica.com <name.surn...@logica.com>* | > http://www.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 <m...@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 <m...@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"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"