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 | 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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"