Microsoft Dynamics GP (Archived)

Activating Manufacturing Module

(0) Share

Report

Posted on by Irfan.Rasheed

717

Hi,

We have upgraded to GP 2010R2 from GP 9 (routing GP 10).

Now we want to use Manufacturing Module in current version. Earlier it was not registered.

Once we add Manufacturing Module using ‘Program and Features’ under ‘Control Panel’. ‘Add/Remove Feature’ install Manufacturing module in current version. But when we ran GP Utilities, we have got this message in ‘Duinstall.txt’ file

‘Failure encountered ON 1/15/2014 at 11:30:34 PM. Error: Product 346 does not support upgrading from version 8.0.0.’

We shall be highly obliged, if someone assist in this regard.

Regards.

Irfan Rasheed

*This post is locked for comments

All responses (15)

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report

RE: Activating Manufacturing Module

Hi All,

I solved this problem. I changed the value in fields DB_verBuild and DB_verOldBuild in DB_upgrade table for PRODID 309 and 3180 (FA and AA) to latest version of 309 and 3180 after 2010 SP4 upgrade
Community Member on at

Like (0)

Report

RE: Activating Manufacturing Module

Hi,

I ran into same problem while upgrading from version 2010 SP4 (MicrosoftDynamicsGP11-KB3030067-ENU) to GP2015 R2.

While running GP utilities I am getting the following errors:

Failure encountered ON 11/17/2015 at 2:58:59 PM. Error: Product 309 does not support upgrading from version 11.0.1952.

Failure encountered ON 11/17/2015 at 2:59:00 PM. Error: Product 3180 does not support upgrading from version 11.0.2047.

Can anybody help me here?
Community Member on at

Like (0)

Report

RE: Activating Manufacturing Module

I think I've figured it out. In addition to all the steps above, if your initial GP installation was 8.0 or earlier, you need to do the following in the DYNAMICS database:

drop procedure dbo.msys80DummyProc

drop table SYPS0100

It seems that Dynamics utils takes the presence of both those objects as an indication that the manufacturing module was installed with GP8.0. I don't know about other modules.

Patrice
SeanY 165 on at

Like (0)

Report

RE: Activating Manufacturing Module

Mine looks like above by the way. I might have manually issued an update statement to set columns after the Utilities. There was one additional step in. That is the step I am having hard time remembering.
SeanY 165 on at

Like (0)

Report

RE: Activating Manufacturing Module

I fixed this but have been thinking really hard back to Nov14 to figure out how but can't remember. The only thing that comes to mind is to do what Jonathan F said above in all dbs instances. I will keep thinking. I like to help you.
Community Member on at

Like (0)

Report

RE: Activating Manufacturing Module

Was a solution discovered for this?

I was receiving the message at first for more than one product:

Failure encountered ON 1/30/2015 at 11:09:40 AM. Error: Product 309 does not support upgrading from version 10.0.1289.
Failure encountered ON 1/30/2015 at 11:09:40 AM. Error: Product 346 does not support upgrading from version 10.0.1290.
Failure encountered ON 1/30/2015 at 11:09:40 AM. Error: Product 414 does not support upgrading from version 10.0.1304.

I removed the records for those PRODID (Fixed Assets, Manufacturing, Human Resources) from:

DYNAMICS..DB_Upgrade
DYNAMICS..DU000020
DYNAMICS..DU000030

Specifically for Manufacturing, I also ran the following:

Drop Table BM010116
Drop Table PK010033
Drop view EXPV1001
Drop view JCV2002
Drop view JCV2004
Drop View EXPV1000
Drop View EXPV1002
Drop View EXPV1003
Drop View ManufacturingOrders

GP Utilities still returns the error, but only for Manufacturing, and with version 8.0.0

'Failure encountered ON 1/30/2015 at 4:59:42 PM. Error: Product 346 does not support upgrading from version 8.0.0.'

The DB_Upgrade table once again has a record for PRODID 346.

How is GP Utilities adding the record back to the DB_Upgrade table??
Amy Wharmby 862 on at

Like (0)

Report

RE: Activating Manufacturing Module

I am having the same issue. I ran the scripts but when I run GP utilities something is writing a record to DB_Upgrade for prodid 346 with a version 8.0. So then I receive an error Product 346 does not support upgrading from version 8.0.0. What is causing this to write this record to DB_upgrade table.

Thanks,
SeanY 165 on at

Like (0)

Report

RE: Activating Manufacturing Module

I am getting the same error message. The only thing that shows up in the db_upgrade table is Dynamics database. I delete the record and I get "error Product 346 doesn't support upgrading." There must be another table or view in the Dynamics database. I ran your scripts against all my companies. Do you know what other table or view might be in the dynamics db? Thanks.
Suggested answer

Irfan.Rasheed 717 on at

Like (0)

Report

RE: Activating Manufacturing Module

Thanks a lot Jonathan for detailed reply.

I have ran scripts and then add Manf Module. It works.
Verified answer

Jonathan Fear on at

Like (0)

Report

RE: Activating Manufacturing Module

Since Manf wasn't properly upgraded you will need to reinitialize it. This will drop all tables for this module in this company so all data will be lost.

This issue is typically due to Manufacturing objects not being correct. Since Manufacturing is not being used we can simply reinstall the module with a few scripts. Make sure you have backups of your databases before you run these scripts:

Delete DYNAMICS..DB_Upgrade where PRODID = 346and db_name = 'xxxx'

Delete DYNAMICS..DU000020 where PRODID = 346 and companyID = xx

Delete DYNAMICS..DU000030 where PRODID = 346 and companyID = xx

You can find the Companyid by running the following script:

select CMPANYID,CMPNYNAM,INTERID from Dynamics..SY01500

Last you need to run the following drop scripts against each company you need to reinstall the module for:

Drop Table BM010116

Drop Table PK010033

Drop view EXPV1001

Drop view JCV2002

Drop view JCV2004

Drop View EXPV1000

Drop View EXPV1002

Drop View EXPV1003

Drop View ManufacturingOrders