Is the patch version of migrator the same as the server? I had issues in the past were they were not and we got into a mess.
Howard On Fri, Jul 10, 2009 at 8:42 AM, Jonas Stumph Stevnsvig < jonas.stumph.stevns...@bec.dk> wrote: > ** Hi everyone > > has anyone experienced problems with the remedy migrator tool? > > we keep encountering problems relating to a non-terminated string for about > 5% of the migrated forms (always the same 5%): > /* fr jul 10 2009 14:02:00.5520 */UPDATE vui SET vuiName=N'Default Admin > View',locale=N'*$*,owner=N'someuser',lastChanged=N'someotheruser',timestamp=1247227320 > WHERE schemaId=414 AND vuiId=536870912 > *** ERROR *** Unclosed quotation mark after the character string > ',timestamp=1247227320 WHERE schemaId=414 AND vuiId=536870912'. (SQL Server > 105)Incorrect syntax near 'someuser'. (SQL Server 102) > > The locale field has not been set, and sometimes it helps to set it and > then delete it - for other forms it still doesn't work, and we have to write > a locale in the field to migrate. > > My guess is that there is some sort of delimiter problem in the migrator, > but does anyone else experience it? > > We're running ARS 7.5 on a MSSQL 2005 Cluster with migrator 7.5 > > > > with regards, > > > *Jonas Stumph Stevnsvig* > Remedy Developer > *BEC* Competence Centre > Phone (+45) 46 38 20 08 > Mobile (+45) 61 56 20 08 > jonas.stumph.stevns...@bec.dk > becrem...@bec.dk > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = hbr4...@gmail.com LinkedIn Profile = http://www.linkedin.com/in/hbr4270 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"