Leonard, It worked fine after I manually imported into Load forms. Validate and promote worked as expected. 1. No, when I try to load the mapping file that DMT provided, it gives me a syntax error. It appears that some values are being passed to the map file, so the import tool is unable to read them properly. I can view them in wordpad to validate my manual maps though. 2. No error logs were generated in DMT log folder, and I didn't check ARS, too deep into it's logs. Thanks for trying to help me out.
Thanks, Mark ________________________________ From: Action Request System discussion list(ARSList) on behalf of Leonard Neely - FOJ Sent: Fri 3/13/2009 2:00 PM To: arslist@ARSLIST.ORG Subject: Re: Data Management Tool Error Mark, It looks like you have a workaround, but just a few more questions. 1. Are you able to load the mapping file in the AR Import tool? 2. There are a number of import logs that get generated when you run the DMT import process. Do these logs have any clue as to where/why its failing? Leonard -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Lev Sent: Friday, March 13, 2009 10:37 AM To: arslist@ARSLIST.ORG Subject: Re: Data Management Tool Error J.T. Ya, I even went so far as to take the latest download and put it in every place it was installed. The convert to csv works, so I'm using ARImport to load the CSV's into the appropriate xxx:LOADform staging form, and then the validate is working. There seems to be something haywire with this piece, but it looks like a workaround exists. Thanks! Mark ----------------------------------------------------------- ________________________________ From: Action Request System discussion list(ARSList) on behalf of Shyman, Jonathan Sent: Fri 3/13/2009 1:33 PM To: arslist@ARSLIST.ORG Subject: Re: Data Management Tool Error Mark, After you installed Admin 7.1 p6 did you verify the arimportcmd path in the data management tool to make sure it is pointed to the right place? J.T. Shyman Column Technologies Cell: 404-242-5407 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Lev Sent: Friday, March 13, 2009 12:56 PM To: arslist@ARSLIST.ORG Subject: Re: Data Management Tool Error Thanks Chris, This may be a dumb question, but how do I locate that document? I tried searching for SW00276159 in KB, but no results. I downloaded and installed Admin 7.1 p6 and the arimportcmd.exe and it's still not working. I restarted ARS, clients, etc. I'll have to open an issue I suspect... Thanks, Mark Mark Lev Sr. Systems Consultant 703-672-4390 732-859-5827 (cell) mark....@rightstarsystems.com ----------------------------------------------------------- RightStar Systems, Inc. 100 East Street SE, Suite 202 Vienna, VA 22180 USA ----------------------------------------------------------- ________________________________ From: Action Request System discussion list(ARSList) on behalf of Danaceau, Chris Sent: Fri 3/13/2009 11:48 AM To: arslist@ARSLIST.ORG Subject: Re: Data Management Tool Error ** Mark, I JUST ran into the same issue. For me the cause turned out to be the Admin tool (actually, the arimportcmd.exe that is bundled with it). I was advised to patch my Admin tool to 7.1 patch 1 or higher. I installed patch 4 and the imports worked after that. The problem is not with the DM tool, it is a defect with the import tool. Here is the related defect id: SW00276159 -- Chris Danaceau This e-mail and its attachments are confidential and solely for the intended addressee(s). Do not share or use them without Fannie Mae's approval. If received in error, contact the sender and delete them. ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Lev Sent: Friday, March 13, 2009 10:37 AM To: arslist@ARSLIST.ORG Subject: Data Management Tool Error ** Hello, I am having a problem with Data Management Tool, and was hoping someone could help. ARS 7.1 ITSM 7.03 Windows OS SQL Server All latest patches Error occurs when trying to Import CSV Files. The convert worked. Following is the error: (I've xx'd out the password) ... <ACTL> Checking DLD:DIP:Import_ProcessBatch (100) <ACTL> -> Passed qualification -- perform if actions <ACTL> 0: Set Fields <ACTL> Process: "C:\Program Files\BMC Software\BMC Remedy ITSM Data Management Tool\Data Load\Import.bat" C:\Program?Files\AR?System\Admin C:\Program?Files\BMC?Software\BMC?Remedy?ITSM?Data?Management?Tool Skittles CTM-LoginID 2693 0 ? xxxx Foundation <ACTL> z1D Char02 (1000000066) = **** **** Unable to load mappings from file. 1 ... I would greatly appreciate anyones help. Thanks, Mark __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"