Business Portal 4 is not working on SQL Server 2008

(0) Share

Report

Posted on by M.Keshk

235

BP V4 showing an error "" while installing it on the below environment,- GP Server, Windows Server 2008 Ent. Edt. SP2 "32bit" SQL Server 2008 Ent. Edt. SP2 GP 10 SP4-IIS ServerWindow Server 2003 SP2 "32bit"MOSS 2007 Ent. Edt. SP2

Any suggestions,

*This post is locked for comments

All responses (16)

Answers (0)

M.Keshk 235 on at

Like (0)

Report

Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Business Portal 4 is not working on SQL Server 2008

Hi Rob, do appreciate your valuable support.
Rob Bernhardt on at

Like (0)

Report

Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Business Portal 4 is not working on SQL Server 2008

GP Workflow should have no dependencies on these tables, but remember to backup your db's anyway!
M.Keshk 235 on at

Like (0)

Report

Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Business Portal 4 is not working on SQL Server 2008

Hi, I have GP Workflow installed and running, I just need to confirm that removing these tables will not affect it.
Rob Bernhardt on at

Like (0)

Report

Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Business Portal 4 is not working on SQL Server 2008

You'll want to delete any table in DYNAMICS that starts with Mbf. Make sure you take backups during the process of course! After removing the tables, try to install again. Since those tables no longer exist, it should be treated as a new install.
M.Keshk 235 on at

Like (0)

Report

Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Business Portal 4 is not working on SQL Server 2008

I think someone tried to install BP few years back. Kindly do you have a list of these tables to remove from SQL?
Rob Bernhardt on at

Like (0)

Report

Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Business Portal 4 is not working on SQL Server 2008

It appears that your last installed version of Business Portal was 2.5. BP 4.0 and 4.0 SP2 only support upgrading from BP 2.7 and 3.0. Were you actively using Business Portal, or had someone just installed it in the past to try it out? If it's the latter, you could just clean up your environment (delete some sql tables, make sure SharePoint is ready, etc.) and install BP 4.0 SP2 new.
M.Keshk 235 on at

Like (0)

Report

Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Business Portal 4 is not working on SQL Server 2008

Ver_Major = 2, Ver_Minor = 5
Rob Bernhardt on at

Like (0)

Report

Re: Re: Re: Re: Re: Re: Re: Re: Re: Business Portal 4 is not working on SQL Server 2008

What are the values in the Ver_Major and Ver_Minor?
M.Keshk 235 on at

Like (0)

Report

Re: Re: Re: Re: Re: Re: Re: Re: Business Portal 4 is not working on SQL Server 2008

Hi Rob,

This this the listof features exist in MBFInstalledDatabases table,

Business Framework
GP
GP_COMMON
GP_CONT_NOTIF
HRM_CORE
PD_GP_COMMON
PD_GP_SPECIFIC
PD_GP_V7E
PD_HRM_CORE
PD_HRM_CORE_UI
REPORT_CAT
REQUISITION
Rob Bernhardt on at

Like (0)

Report

Re: Re: Re: Re: Re: Re: Re: Business Portal 4 is not working on SQL Server 2008

Have you ever had BP installed in your environment? I'd recommend looking at the DYNAMICS..MBFInstalledDatabases table if it exists. It lists the features that have been installed previously so that they can be updated.