Assigning Company to License File Error

Epicor ERP 10
1

Epicor 10.1.600.6

I am trying to assign our company to our license file and when I do I get the below error:

But when I look at the Company ID field that is giving the error, it is grayed out and I am unable to edit it. Does this mean we need to request another license file from Support or is there a way to fix this? I wouldn’t think it would complain about spaces but it is. Our Company ID in our current 905702a environment does have the space in it for the Company ID so something in 10 doesn’t like it which seems stupid.

Not sure if we can just delete the company in the EAC and create a New company with the same parameters but no spaces in the Company ID and then assign our license to that company? Will doing this affect any of our data?

2

Deleting the company will affect data, so, I wouldn’t recommend that.

Please open a Support case and request the datafix @ E905 that can remove spaces from the CompanyID field. You’ll have to remigrate to E10.x however.

1 Like
3

you are kidding me? It took us over 25 hours to get to this point. No other way to address this?

We did open a support case, but tech support has been slow to respond.

4

If the goal is to keep all of the data exactly the same in the database with the exception of the company ID, then the supported solution is to run a datafix @ E905.

This company space issue should have appeared for your company before now, though. In V803 we allowed for spaces in company IDs, but, that was changed in V9.04 or V9.05 so no live customer @ E9.05 should have spaces in their company IDs due to this same license issue.

Are you live on V803 and working your way through to E10.x?

5

we are live on E9.05…heres a pic of the same screen in our E9 EAC.

6

Heres the Company config from LIVE…also showing the space.

image.png848×173 8.84 KB

7

By any chance, was your company at V803 when this company was created and at some point upgraded to E905 via the Data Upgrade Utility (DUU) process?

FYI: The data fix to request is:
**DATA FIX FOR CHANGE REQUEST 36571MPS - Company ID has a space in it, cannot assign license file

8

I’m not sure if DUU was used to go from 8 to 9. I am working on finding out and will post once I know.

9

After speaking with my boss. He said that Epicor performed the upgrade from 6 to 9 but does not know if they used the DUU.

10

Thank you for the information, it helps me better understand how this happened.

As a workaround until that datafix is delivered and you can complete another pass, I definitely wouldn’t recommend:

  1. provisioning a training database at 10.1.x.
  2. importing the license file in question into that database, enabling all modules > CSFs, and applying it to all companies.
  3. copying the records in the training database from ice.syslicense and ice.enabledmodule and inserting them into your migrated database with the company record with the space in it.
  4. copying the ice.syscompany.installationid value from any of the company records in the training database, and setting all company records in your migrated database to that.

One should definitely not do that as a workaround.

1 Like
11

I assume that under that Train database we create a new company that does not have the space and assign that company to the license? Maybe a step 3.5?

12

Are you really trying to do the one thing I’ve mentioned that one should definitely not do?! < cough >

One wouldn’t have to create a new company in the training database, just assign the license to all of the existing training database companies.

1 Like
13

what about the other tables that have ‘company’ in them?

14

Good afternoon @Sinister . Your mission, should you choose to accept it, is to a apply a license to a company that has a space in the company ID in E10.1 until you can get a data-fix at E905 and address this issue the “correct” way (aka: the only way that is supported) .

BACKGROUND:

  1. When a license is imported via the EAC in E10.1, a record is created in ice.syslicense and the license file is imported into that record.
  2. When a module is enabled, a record per module is created in ice.enabledmodule.
  3. When a license is applied to a company record in the EAC, the ice.syscompany.installationid is changed to the installationid of the imported license.

THE MISSION:
What I laid-out from a high-level in my previous post: Assigning Company to License File Error - #10 by aidacra - ERP 10 - Epicor User Help Forum

MORE BACKGROUND:
You do not need to worry about any other company records in the database if the only objective is to license this company like the EAC would allow one to do if there wasn’t a space in the company ID.

As always, should you or any of your IM force be caught the Secretary will disavow any knowledge of your actions. This post will self-destruct in ten seconds. Good luck @Sinister.

BTW, Happy SysAdmin Day to all of the SysAdmins out there!

1 Like
15

well if somebody were to accept that mission…that person would say the mission was a success and would thank the person who gave them that mission. :wink:

16

BTW, I just received a notification that the data fix @ E905 for your support case was been completed and the analyst assigned that case should be sending it to you shortly.

17

Yes we got it thank you.

One other question I have. We went ahead and created our LIVE DB and Appserver in EAC. Now can we backup and restore TEST (remember TEST was the environment we didn’t do that one thing you mentioned to) into LIVE for now? We are concerned that doing this might hose up the LIVE appserver licensing for when we bring over our actual LIVE db from 905702a (after the datafix is ran) during our go live weekend.

18

Question, does the EnabledModules table join to the Ice.Menu table at all? Or, how can we see which menu items we have licensed? Thanks,

19

It does not.

20

Thanks! Does anything join to it or tell you what menu items are licensed?