Hi Carl, Really appreciate your help.
I have so far tried Company and People upload and both got stuck on the Load step remaining in status of In Progress. I found that the data is in fact present in staging forms, which would explain why directories do not contain any RESULT files with errors. After more digging, I found records in form DMT:SYS:SequencingEngine that relate to steps in the job. If I manually updated the first step from In Progress to Completed, the rest of the steps in the Job are triggered and complete fine. After more investigation, the only thing I can find in the javaplugin.log file is the following entry (set the logging level to DEBUG there): Requested thread pool executor not found in pool for pool# : null so returning default thread pool executor pool# : 0 Not sure how/where to configure which thread pool the job should be using (and in fact not sure if the above is in any way relevant to the issue). Only other piece of information I found was that there is a workflow which is meant to set the step status to Completed. It appears to originate from form DMT:ThreadManager (hence the potential connection to the message above?). Any ideas/possible ways to further investigate would be greatly appreciated. Thanks Jiri -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carl Wilson Sent: 09 October 2012 18:41 To: arslist@ARSLIST.ORG Subject: Re: Data Management Tool in version 8 replaced by Atrium Integrator Hi, if it did not get past the load, then open the activity (step) and see if there are any errors. If none, you need to check the directory that you have allocated for the initial settings can indeed be written to. There is a test button that may report that it worked, but you need to ensure the directory it creates is there. Also, you need to delete this directory before each test as it tries to re-create it. Under the installation directories, you can find other error logs. If there are no load errors, and there are no other steps completed, it usually indicates the above - no conversion, or conversion hanging whilst loading in the data. When this step runs, you will see the job id created as the directory in the folder specified. It was really picky on the format (UNC) and permissions. I found that you have to cancel these jobs that have hung, and re-create them (there is an option to copy to new once cancelled). I would start at the conversion directory as this is what took a while to get working, but once it did it all ran fine - apart from formatting errors and validation etc. This loader appears to be a much more comprehensive validation tool. Other errors you may see is the steps throwing an error but no description. I have worked out these to be mainly records that already exist in the system, but no actual report raised (you can see these from the staging forms). Cheers Carl http://www.missingpiecessoftware.com/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jiri Pospisil Sent: 09 October 2012 16:22 To: arslist@ARSLIST.ORG Subject: Re: Data Management Tool in version 8 replaced by Atrium Integrator Carl, Thanks for the detailed description of the process. Managed to figure most of it, but pointer to how to troubleshoot will definitely be useful as I am at the moment stuck with the Load step In Progress and nothing else happening (using BMC People template). Checked the arcarte.log file on the server and it reported the job as started and completed with no errors within a couple of seconds, but the step still sits in the In Progress status and there appears no way to move it forward. Same with the job directory where it did not report any errors. Regards Jiri -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carl Wilson Sent: 09 October 2012 16:12 To: arslist@ARSLIST.ORG Subject: Re: Data Management Tool in version 8 replaced by Atrium Integrator Hi, the documentation is now on the BMC wiki (docs.bmc.com). To be honest it is not that straight forward to understand as it is all over the place in terms of structure. A couple of points: - You need to specify a UNC based directory for the tool to be able to do the conversion on the spreadsheets. This cannot use "localhost" in the path and must be in the UNC format. Can be a pain to setup on Windows. Sharing a directory and giving permissions is the easiest I have found to get working. You can then use something along the lines of "\\win-atmsk2nqp0b\c\DataLoad\" - set from Application Administration > Foundation > Advanced Options > System Configuration Settings - System Settings. Ensure the correct permissions for writing to this directory as the tool will create directories and files on the fly. - Spreadsheet Management (Data Management). Here you can download the spreadsheets for population, as well as upload completed spreadsheets for use in the Jobs. You "Copy to New" the spreadsheets from the normal space (BMC Template) to a user space (Users Data), which then becomes selectable in the Jobs Load Activity setup. I suggest you do this one spreadsheet at a time until you are familiar with setting up and configuring jobs. Try not to overwrite the BMC Templates .... You can update the "Copied" spreadsheets when making changes (Users Data), updates will then be re-selectable in the Job steps. - Jobs Console. There are 2 parts to setting up a job to load in data. You first create a job (basic information), then you associate a pre-defined activity (Template) to that job (Steps > Create Using BMC Templates > Select the Template). When you associate a pre-defined template (all the Data Loads are BMC Templates pre-defined) you can then open the Load activity and either select the uploaded spreadsheet (as in the point above - lives in the Users Data) or directly load a spreadsheet into the attachment field. Once this is done (saved), you save the job and set the status to "Built". This will then allow you to run the job (enable the run options) and view the status of the various activities. - There is a couple of places errors will be pushed to. Data Load errors will generate a zip file with the issues encountered (usually Excel data conversions i.e. numbers need to be stored as text, not numbers) and will be found when you open the Load Step in the job. Other errors such as validation, etc can be seen from the Error Management link (Data Management Job Console > Other Functions > Error Management). That should get you started, the Wiki has any troubleshooting steps or additional information for setup and execution. Cheers Carl http://www.missingpiecessoftware.com/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jiri Pospisil Sent: 08 October 2012 12:20 To: arslist@ARSLIST.ORG Subject: Data Management Tool in version 8 replaced by Atrium Integrator Hi all, It appears that in version 8 the data management tool has been replaced by the Atrium Integrator. I am trying to find any documentation on how to use it for foundation data load or updates, but so far with not much luck. Hop it is just me. Can anybody point me in the right direction, i.e. documentation describing how to use the Atrium Integrator to run the pre-defined transformations for loading foundation data. Thanks Jiri Pospisil A copy of the LCH.Clearnet e-mail disclaimer can be found at: www.lchclearnet.com/disclaimer/email LCH.Clearnet Limited, Registered Office: Aldgate House, 33 Aldgate High Street, London EC3N 1EA. Recognised as a Clearing House under the Financial Services & Markets Act 2000. Reg in England No.25932. LCH.Clearnet SA, Siège Social, 18 rue du Quatre Septembre, 75002 Paris, Chambre de Compensation conformément au Code Monétaire et Financier. _______________________________________________________________________________ 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
