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"
