Rick, You are getting these ARX files from where? I don't have an answer for you unfortunately, but I'm willing to help if I can. Is this a custom system or ITSM. What version of Remedy Server, as well as Import tool. Are you performing the import through the GUI or through command line, if through command line, what options are chosen.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rick Westbrock Sent: Wednesday, October 10, 2012 4:25 PM To: [email protected] Subject: Illegal Group Reference error during data import Hello all- I have run into an issue importing a large ARX file and can't seem to track down any information about the error that nearly every record is logging: "Illegal group reference". The data import log doesn't show the offending field but the only field that I can find on this form that would be trying to translate a group ID number from the Group form (which is what I assume is generating the error) is field 112. I checked multiple failed records in the log file and they all have valid group ID numbers that are found in the Group form. The syntax in the ARX file is "5985;" and since group 5985 does exist on the server I can't figure out the root cause of the error. I imported with filters suppressed so and in any case I turned on filter logging on one pass and it didn't show any filters firing as expected. Has anyone run into this problem before and have any suggestions? My first, smaller import had about a 30% failure rate for this error on about 5000 records but I have over 80,000 records to import to this form. My first thought was that maybe old records had a group ID that was obsolete but every record that I looked at in the log file had what looks like a valid group ID and these were all currently open tickets. I get the same behavior on my dev and QA servers (both Windows with MS-SQL database on a separate server). Below is a sample entry from the log, I only included the fields up to 112, below that are the field description lines from the ARX file: [Wed Oct 10 14:31:56.532] WARN - Exception encountered java.lang.IllegalArgumentException: Illegal group reference at java.util.regex.Matcher.appendReplacement(Unknown Source) at java.util.regex.Matcher.replaceAll(Unknown Source) at java.lang.String.replaceAll(Unknown Source) at com.bmc.arsys.apiext.data.KeywordExpander.expandAllKeywords(Unknown Source) at com.bmc.arsys.apiext.data.EntryFactory.applyMappings(Unknown Source) at com.bmc.arsys.apiext.data.EntryFactory.createEntry(Unknown Source) at com.bmc.arsys.apiext.data.BaseImporter.createEntry(Unknown Source) at com.bmc.arsys.apiext.data.BaseImporter.handleDataEvent(Unknown Source) at com.bmc.arsys.apiext.data.BaseImporter$1.handleEvent(Unknown Source) at com.bmc.arsys.apiext.data.Parser.fireEvent(Unknown Source) at com.bmc.arsys.apiext.data.arx.ARXParser.parseFile(Unknown Source) at com.bmc.arsys.apiext.data.arx.ARXImporter.if(Unknown Source) at com.bmc.arsys.apiext.data.arx.ARXImporter.startImport(Unknown Source) at com.bmc.arsys.apiext.data.BaseImporter.call(Unknown Source) at com.bmc.arsys.apiext.data.BaseImporter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) [Wed Oct 10 14:31:56.532] INFO - Skipping import of record as instructed by user [Wed Oct 10 14:31:56.532] INFO - Error importing record 2: Illegal group reference DATA "ABCD00000011111" "john.doe" 1190676633 "" "jane.smith" 1201294523 8 "TRACKING FORM" "1190676633AR_IMPORT1190676633AR_IMPORT" "5985;" FIELDS "Entry ID " "Submitter" "Create Date" "Assigned To" "Last Modified By" "Modified Date" "Status" "Short Description" "Status-History" "Assignee Group" FLD-ID 1 2 3 4 5 6 7 8 15 112 -Rick ___________________________ Rick Westbrock [email protected] _______________________________________________________________________________ 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"
