# Migration error UpdateCNVProgs.sql on ERP1.01.200.0

**Category:** [Epicor ERP 10](https://www.epiusers.help/c/e10/5)
**Created:** 2016-11-17 15:41 UTC
**Views:** 1423
**Replies:** 14
**URL:** https://www.epiusers.help/t/migration-error-updatecnvprogs-sql-on-erp1-01-200-0/36342

---

## Post #1 by @wi11king777

Received the following error during test migration 9.05.702A to UD10.1.400.21
================================================================
Error	Upgrade Process	UpdateCNVProgs.sql	Invalid column name 'LastRunLevel'.
update Ice.CnvProgs set ProgStatus = '', ProgressP
Execute Phase Complete: 44954.0733829 seconds

Starting Cleanup Phase...
   - Upgrade Process  ERP10.1.200.0
Cleanup Phase: 0.0577585 seconds
DB Migration process is cancelled by the user.
The total execution time is 3192.5404 minutes.
================================================================

We do not use ICE, so I uncheck all the mentions of ICE in the migration before starting. 

Looking at Ice.CNVProgs I don't see a column named 'LastRunLevel'.

Any ideas.

---

## Post #2 by @josecgomez

ICE is any table related to the framework trust me you DO use ICE. You should do the migration with ALL the checkboxes checked.
Did you run your data scrubbers in your 9 DB before migration / get fixes from Epicor? If you didn't do that, do that first
Then start you migration over again without UnChecking anything

---

## Post #3 by @Bart_Elia

Correct. ICE is all the gory, geeky underpinning. Honestly did not realize you could uncheck that. (SCR coming!).

ICE is the security, User maintenance, BPMs, BAQs, Menu.... you probably need those :)

---

## Post #4 by @aidacra

<img src="/uploads/default/original/1X/78c05cbb897a8ca82d942f3fd033e5d8a3243288.jpg" width="100" height="100">

Unchecking something in the migration process shouldn't be done unless Support has said to do so as part of a troubleshooting step only  - each one of those steps is important, and not running something now can have consequences later on.  If you still receive this error after starting over on the migration with all of the steps checked, please let us know.

---

## Post #5 by @wi11king777

Ran with the ICE (everything checked and get the following error).

I will do data scrubber again. 

FYI: I don't have 905.702 installed on the test system, I am using the backup from my 9.05.702A system to perform the migration. 

<img src="/uploads/default/original/1X/23380b5042b7830fb25b828fe28b2ac636217a5e.PNG" width="690" height="409">

---

## Post #6 by @aidacra

The scrubber won't address this particular issue.  One of the sequence tables in E905 has a NULL for currentvalue.  Support can provide you a process to resolve.  Please call in/open a Support ticket via epicweb.epicor.com and someone from my team will definitely be able to assist.

---

## Post #7 by @jgiese.wci

You don’t need to have 702 installed you are for sure good there, but I would blow away this current restored DB and restore a new copy to run the scrubbers against and test migration on.

Start clean instead of trying to run migration on the same one again and see how that goes.
Joshua Giese
Technology Solutions : CTO
Direct Phone:    920.593.8299
Office Phone:    920.437.6400 x342
[http://wcibags.com/email/emailFooter4.jpg]<http://www.wcibags.com/>

---

## Post #8 by @wi11king777

Thank you for your help. I am putting a Epicor service call in.

---

## Post #9 by @josecgomez

Is there a ReSequence Conversion in 9? Or am I remembering incorrectly? I am 92% sure there is a ReSequence DB conversion you can run in 9 before moving to 10

---

## Post #10 by @aidacra

there is, but, it doesn't adjust the sequence table's current value when it is NULL. 
<img src="/uploads/default/original/1X/cd2d73aac74e806de336d8ec13538d70f7962c1b.png" width="360" height="19">

---

## Post #11 by @Mark_Wonsil

Nate Silver says…

[http://epiusers.help/user_avatar/epiusers.help/josecgomez.trigemco/45/31_1.png]

josecgomez.trigemco<http://epiusers.help/users/josecgomez.trigemco> Certified Epicor Consultant
November 17



I am 92% sure there is a ReSequence DB conversion you can run in 9 before moving to 10

---

## Post #12 by @josecgomez

Too Soon man... Too Soon
<img src="/uploads/default/original/1X/bafbebc7220f5c1022d5e329b40f702de9e69357.jpg" width="288" height="162">

---

## Post #14 by @josecgomez

<img src="/uploads/default/original/1X/d79d699ce1ee0173adb457baadad05b054350001.jpg" width="620" height="372">

---

## Post #15 by @Mark_Wonsil

That certainly was the popular opinion…

(Hope you know the forum admin or we’re going to get into trouble…)

---

## Post #16 by @josecgomez

haha it was just a joke the admin's can take a joke.... Right? @rbucek @Manasa... I'll take one for the team... #now back to your regularly scheduled programming... *cough* Epicor Rainbows and Kittens!

---


**Canonical:** https://www.epiusers.help/t/migration-error-updatecnvprogs-sql-on-erp1-01-200-0/36342
**Original content:** https://www.epiusers.help/t/migration-error-updatecnvprogs-sql-on-erp1-01-200-0/36342