RE: Pentaho Spoon
Thanks …. I realized I forgot to add ARS 8.1.02 From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Ashish Joshi Sent: Thursday, February 15, 2018 12:08 PM To: ARSList <arslist@arslist.org> Subject: Re: Pentaho Spoon Mark's suggestion is on the spot. I guess there's already a hotfix available for this. Please contact BMC Support Regards, Ashish Joshi +91 9766 928 678 On Thu, Feb 15, 2018 at 11:01 PM, Walters, Mark <mark_walt...@bmc.com<mailto:mark_walt...@bmc.com>> wrote: You don’t mention you version but I think are hotfixes to address this – see https://communities.bmc.com/docs/DOC-62897 or contact Support for details. Mark From: ARSList [mailto:arslist-boun...@arslist.org<mailto:arslist-boun...@arslist.org>] On Behalf Of Grooms, Frederick W Sent: 15 February 2018 16:06 To: 'ARSList' <arslist@arslist.org<mailto:arslist@arslist.org>> Subject: Pentaho Spoon Our security team has recently started doing additional scans of our servers and we started getting errors on the Remedy systems stating that HTTP TRACE was enabled. I tracked it down to the embedded Jetty inside the Pentaho Spoon (Atrium Integrator) process. Does anyone know how to disable the HTTP TRACE method of the embedded Jetty? Thanks Fred 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 mailing list ARSList@arslist.org<mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: Pentaho Spoon
Mark's suggestion is on the spot. I guess there's already a hotfix available for this. Please contact BMC Support Regards, Ashish Joshi +91 9766 928 678 On Thu, Feb 15, 2018 at 11:01 PM, Walters, Mark <mark_walt...@bmc.com> wrote: > You don’t mention you version but I think are hotfixes to address this – > see https://communities.bmc.com/docs/DOC-62897 or contact Support for > details. > > > > Mark > > > > *From:* ARSList [mailto:arslist-boun...@arslist.org] *On Behalf Of *Grooms, > Frederick W > *Sent:* 15 February 2018 16:06 > *To:* 'ARSList' <arslist@arslist.org> > *Subject:* Pentaho Spoon > > > > Our security team has recently started doing additional scans of our > servers and we started getting errors on the Remedy systems stating that > HTTP TRACE was enabled. I tracked it down to the embedded Jetty inside the > Pentaho Spoon (Atrium Integrator) process. > > > > Does anyone know how to disable the HTTP TRACE method of the embedded > Jetty? > > > > Thanks > > Fred > 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 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: Pentaho Spoon
You don’t mention you version but I think are hotfixes to address this – see https://communities.bmc.com/docs/DOC-62897 or contact Support for details. Mark From: ARSList [mailto:arslist-boun...@arslist.org] On Behalf Of Grooms, Frederick W Sent: 15 February 2018 16:06 To: 'ARSList' <arslist@arslist.org> Subject: Pentaho Spoon Our security team has recently started doing additional scans of our servers and we started getting errors on the Remedy systems stating that HTTP TRACE was enabled. I tracked it down to the embedded Jetty inside the Pentaho Spoon (Atrium Integrator) process. Does anyone know how to disable the HTTP TRACE method of the embedded Jetty? Thanks Fred 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 mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Pentaho Spoon
Our security team has recently started doing additional scans of our servers and we started getting errors on the Remedy systems stating that HTTP TRACE was enabled. I tracked it down to the embedded Jetty inside the Pentaho Spoon (Atrium Integrator) process. Does anyone know how to disable the HTTP TRACE method of the embedded Jetty? Thanks Fred -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Atrium Integrator Pentaho/Spoon Engine
Hey everyone, I have a no brainer question here. Obviously, we all know Atium Integrator replaces AIE. I have looked everywhere but cannot seem to locate the engine it uses? Does Atrium Integrator use the AIE engine? Sometimes on the old AIE you'd have to restart AIE to get it to run quickly. No biggie, however I am curious does Atrium Integrator have a different engine or is does it leverage the AIE engine? Also - does pentaho/spoon utilize the AIE Engine or since it is a client install is it just utilizing its own engine inside kettle on the client machine? I am looking at this from a server grouping perspective, should we use the same mentality on those other engines when server grouping if Atrium Integrator does indeed utilize some other engine? Sorry for the million questions in one post. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Atrium Integrator Pentaho/Spoon Engine
Spoon is the client that comes with Pentaho. Pentaho is the engine used in AI to do the work. It is loaded as a plugin in one of your plugin servers. If you look in the armonitor.cfg file you should one of the lines loading pentaho jar files. On Fri, Mar 7, 2014 at 1:00 PM, Josh remedyd...@gmail.com wrote: Hey everyone, I have a no brainer question here. Obviously, we all know Atium Integrator replaces AIE. I have looked everywhere but cannot seem to locate the engine it uses? Does Atrium Integrator use the AIE engine? Sometimes on the old AIE you'd have to restart AIE to get it to run quickly. No biggie, however I am curious does Atrium Integrator have a different engine or is does it leverage the AIE engine? Also - does pentaho/spoon utilize the AIE Engine or since it is a client install is it just utilizing its own engine inside kettle on the client machine? I am looking at this from a server grouping perspective, should we use the same mentality on those other engines when server grouping if Atrium Integrator does indeed utilize some other engine? Sorry for the million questions in one post. Thanks ___ 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: Atrium Integrator Pentaho/Spoon Engine
Look for the keyword diserver in armonitor.cfg and that is the java plugin responsible to. Load carte server running Atrium Integrator. Regards, Aditya Sent from my BlackBerry® smartphone from !DEA -Original Message- From: LJ LongWing lj.longw...@gmail.com Sender: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG Date: Fri, 7 Mar 2014 13:14:47 To: arslist@ARSLIST.ORG Reply-To: arslist@ARSLIST.ORG Subject: Re: Atrium Integrator Pentaho/Spoon Engine Spoon is the client that comes with Pentaho. Pentaho is the engine used in AI to do the work. It is loaded as a plugin in one of your plugin servers. If you look in the armonitor.cfg file you should one of the lines loading pentaho jar files. On Fri, Mar 7, 2014 at 1:00 PM, Josh remedyd...@gmail.com wrote: Hey everyone, I have a no brainer question here. Obviously, we all know Atium Integrator replaces AIE. I have looked everywhere but cannot seem to locate the engine it uses? Does Atrium Integrator use the AIE engine? Sometimes on the old AIE you'd have to restart AIE to get it to run quickly. No biggie, however I am curious does Atrium Integrator have a different engine or is does it leverage the AIE engine? Also - does pentaho/spoon utilize the AIE Engine or since it is a client install is it just utilizing its own engine inside kettle on the client machine? I am looking at this from a server grouping perspective, should we use the same mentality on those other engines when server grouping if Atrium Integrator does indeed utilize some other engine? Sorry for the million questions in one post. Thanks ___ 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: Atrium Integrator Pentaho/Spoon Engine
Basically Pentaho has Jobs (Data Exchanges) and Transformations (CI/AR Data mappings). Once you have converted your AIE jobs to AI using their conversion utility in the AI Client install, you can access those jobs from the Mid-Tier in the Atrium Integrator console. If you need to restart a job, you can do it from the console. Any editing of the Jobs and their Transformations has to be from Spoon. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Josh Sent: Friday, March 07, 2014 2:00 PM To: arslist@ARSLIST.ORG Subject: Atrium Integrator Pentaho/Spoon Engine Hey everyone, I have a no brainer question here. Obviously, we all know Atium Integrator replaces AIE. I have looked everywhere but cannot seem to locate the engine it uses? Does Atrium Integrator use the AIE engine? Sometimes on the old AIE you'd have to restart AIE to get it to run quickly. No biggie, however I am curious does Atrium Integrator have a different engine or is does it leverage the AIE engine? Also - does pentaho/spoon utilize the AIE Engine or since it is a client install is it just utilizing its own engine inside kettle on the client machine? I am looking at this from a server grouping perspective, should we use the same mentality on those other engines when server grouping if Atrium Integrator does indeed utilize some other engine? Sorry for the million questions in one post. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years Information contained in this email is subject to the disclaimer found by clicking on the following link: http://www.lyondellbasell.com/Footer/Disclaimer/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Atrium Integrator Pentaho/Spoon Engine
Thanks Jesus, I am indepthly familiar with Atrium Integrator, pentaho spoon and AIE. My question is specifically about the engine that AI runs in. For us who have done large amounts of work with AIE over the years its common practice to restart AIE engine specific instances (AIE 001,002 respectively)to get AIE to run the job immediately versus waiting until AIE comes back around to running it on the AIE engine cycle. My question here is how do I stop/restart the engine that runs Atrium Integrator? Where does it run? When server grouped, it is best practice when doing CMDB work via AIE to push off AIE to its own separate server on the server group, because when doing imports you will dog out Arsystem if its not. My very specific question is how is this done with AI? Is there an engine that runs AI like there was on AIE, normally on AIE we would set the server group ranking form to push off AIE jobs to their own server, how does that work with AI? Is there a method to accomplish this via AI?Is there an engine? This is much deeper level question than simply defining the workings of AI. I appreciate the help thank you again. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Atrium Integrator Pentaho/Spoon Engine
See if this helps. The engine behind the Atrium Integrator that actually runs the jobs remotely is called Carte server. It is a component of Pentaho Suite you use to run jobs remotely. While installing Atrium Integrator, Carte also gets installed on each node. At the run time Atrium Integrator sends the job to Carte and Carte executes them. Carte is an apache web server listening on default port 2. While the job is running in the AI Console you can see a status button, when you click the button, it actually launches the Carte url. From there also you can control the job runs.(Stop,Restart etc..) Coming to AI jobs controlling in a Server Group, while scheduling the job in the AI Console you can select which carte Server(each ARServer will have one Carte server installed) this job should be associated with. You can have one instance of job run in only one node. You cannot loadbalance or concurrently run the same job run instance across multiple ARS nodes. Probably you might have to kill the AI Plugin or restart Carte Web Server or restart ARS itself depending on the kind of issue you are seeing. You can find more details here: https://docs.bmc.com/docs/display/public/ac81/Atrium+Integrator+in+a+server+group+environment ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Date conversion in Pentaho/Spoon
ARSListers, ARS Version: 7.6.04 SP2 MS SQL 20008 I'm learning Pentaho/Spoon (part of the new Atrium Integrator on ARS 7.6.04 SP2) and I'm stumped on how to get dates from a text file input to CMDBOutput. I'm following the sample from BMC. For example, my spreadsheet has a date in US format of 10/13/2007. It's in the text file input as a String type.I'm using the Select Values step to rename and format it. Using BMC's example I'm using the format of M/d/ hh:mm:ss . When I do this, the output fails with: Unparseable date: Sat Oct 13 09:00:00 PDT 2007 I've tried changing the format and selecting from the menus. No luck. I've tried changing the date format on my spreadsheet. I've tried dd/mm/, mm/dd/ and /mm/dd formats with and without time on my spreadsheet with various formats in the Select Values step. I get either the above error or Unparseable date: 10/13/2007 I think I've tried every combination and I'm still not succeeding in getting dates into CMDB. Everything else works great. I'm out of ideas. Anyone have any suggestions? Thank you, Barb Barbara Siebert Senior Consultant QMX Support Services cell phone: 949-637-7522 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are