well...you may find yourself in a pickle unfortunately. You are on a version of Remedy that is already on limited support, and goes out of limited support on Sept 21 of this year...so you have a very small window of opportunity to get a fix from BMC, if it's not already too late...but I would certainly expect this to be a bug in the tool.
Secondly, the tool you are using is 'Legacy', in that it has been replaced by another tool altogether in newer versions, so it's not likely that if it wasn't already fixed, that a backport would even be available.... You may (if you haven't already) want to try and upgrade to the latest patch (8 if I remember correctly), and see if it's fixed there... On Wed, Jul 31, 2013 at 11:20 AM, John Kenny <[email protected]> wrote: > Hello All: > > We are running AIE 7.5 and have discovered a bug with AIE in regards to > how it handles building the Primary Key. We run an import of data in CSV > file daily and have been seeing that some of the data records are not > getting loaded into Remedy. What we discovered was if any of the data in > any column that is used to build the Primary Key has the pattern " AND " > such as Name = "JOHN KENNY AND SONS", AIE fails to build the Primary Key > and AIE aborts its attempt to create a record in Remedy. Remove the " AND > " and the record imports fine. It appears that when AIE goes to build the > Primary Key and sees " AND " in the data it treats as the "AND" operator. > In our case simply removing any reference to " AND " from the data prior to > AIE import is not an option. > > Has anyone experienced this issue and if so, is there a fix or workaround > you can share. > > Thanx in advance > > John > > > _______________________________________________________________________________ > 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"
