E10.1.600.2 Upgrade Error

Epicor ERP 10
1

Hi

Anybody else tried upgrading a test database to 10.1.600.2 yet? Possibly not if people are away at Insights, only slightly jealous that I’m not there!

When it gets to the highlighted task, it fails talking about duplicate key in the Ice.ChgLog table. The records it refers to are related to posting rules I believe. Here is a SQL query showing records meeting the criteria - interestingly one has SchemaName and one doesn’t.

Company

Identifier

SchemaName

TableName

Key1

Key2

Key3

DateStampedOn

LogText

BVD

ACTRevision

ACTRevision

10

10~94

2015-11-13

905 Std revision has been updated by conversion program 160(cvpe0000) on 11/13/15 by MarkDamen

BVD

ACTRevision

Erp

ACTRevision

10

10~94

2015-11-13

13/11/2015 19:28:31: 905 Std revision has been renamed to Base Std by conversion program cvpe0000 by MarkDamen.
13/11/2015 19:28:31: Base Std revision has been updated by conversion program cvpe0000 by MarkDamen.

[/uploads/default/original/2X/c/c2ea0abb26b0e442a971ab7b356f0e187f73e36d.png]

Got a call open with Support, just wondered if anybody else had seen it yet.

Many Thanks
Mark

2

Hi markdamen, We’ve faced to problem too. To solve that, please follow the following instruction.

  1. Financial Management > General Ledger > Setup > Book
    Choose Your GL Book and goto Posting > Conversion, change Package to “Standard” under “Segment Map” section and set appropriate Target Segment in the list.

  2. Run SQL Script Under Database, make sure you do a backup of the database prior on running the script

update ice.cnvprogs
set ProgressPercent=0,ProgStatus=‘ERROR’
where ConversionID = ‘cvpe0000’

  1. Restart IIS Application Pool and run Epicor Conversion program again, then solve the problem
1 Like
3

Thank you Kelvin for pointing out where to go. I did not have to reset the progress flag or anything, I just edited the Posting-Conversion tab as you stated and ran the conversion again, no errors. Thanks again!