Great Plains    Dexterity    Dynamics     eEnterprise     Microsoft CRM    Microsoft RMS    Crystal Reports    SQL   .Net    C#      International    Chicago    Illinois    Customizations    Great Plains Programming    Development    Offshore Programming    FRx    ReportWriter    Integration Manager    POS    Upgrade    Data Recovery    Conversion    EDI    Barcoding    SQL    Multicurrency    Microsoft Business Solutions    Great Plains Certified Master    FAQ    Forum    Continuum for VB    Btrieve    Ctree    Pervasive SQL.2000    Great Plains Business Portal    eOrder    eView    eRequisition    Intellisol    Kampdata    Mekorma    Horizon    Wennsoft    Naperville    Schaumburg    Lombard    Hinsdale    Aurora    Rockford    Downers Grove    Brazil    Moscow    Montreal    Mexico    USA    Canada    California

Issue

'Server Error in '/BusinessPortal' Application. The server process could not be started because the configured identity is incorrect. Check the username and password' occurs when launching Business Portal.

Resolutions

Resolution 1

Check C:\Program Files\Microsoft Business Solutions\Business Portal\bin
DBAuthenticationUtility.exe utility to see if the server name matches your current SQL servername Machine name and your SQL servername.  You can determine your SQL servername by running the following statement in query analyzer:

select @@servername

Resoluton 2

On the IIS machine where Business Portal is installed, navigate to Administrative Tools - Component Services.  After Component Services opens; Expand the plus symbol next to Component Services | Computers | My Computer | Com+ Applications
Locate the Microsoft.BusinessFramework.Identity component and choose Properties.  

When the properties window opens click on the Identity Tab and change the  user account to a user in the local admin group and set or reset the password.

Product: Great Plains
Versions: 7.0, 7.5
Modules: Business Portal

Cannot open database requested in login DYNAMICS. Login fails: When launching the Business Portal Web Site.

Check the SQL rights on the BuisnessPortalUser login. 

In SQL Enterprise Manager:

The BuisnessPortalUser SQL login needs to have access to the DYNAMICS and company databases.
In addition the BuisnessPortalUser SQL login needs to be a member of the Public, DYNGRP, and BFGROUP roles for those databases.

You may also need to run the grant 7.0 script against the company and DYNAMICS databases for both the DYNGRP and BFGROUP SQL roles.

Product: Great Plains, Solomon
Versions: 5.5, 7.0, 7.5
Modules: Business Portal

SYMPTOMS

After you select all the setup options during the Business Portal 2.0 installation, you may receive the following error message at the end of the install process:

     Business Portal installation ended prematurely.

When you try to remove Business Portal 2.0, the SQL Server name appears as %servername%.

CAUSE

This problem may occur if the Distributed Transaction Coordinator service is not running or if the logon account for the service is not Network Service. NT Authority\Network Service is an internal local account in Windows Server 2003.    

RESOLUTION

1. Change the name of the SQL Server from %servername% to the actual SQL Server name in the  ~privatefile.dbauthentication.config file. By default, this file is located at C:\Inetpub\wwwroot\bin. In the following example, the SQL Server name is MBSCHRIS4\DOCI2000.

<?xml version="1.0" encoding="utf-8"?>
<servers>
  <server>
    <name>MBSCHRIS4\DOCI2000</name>

Product: Great Plains, Solomon
Versions: 5.x, 7.0, 7.5
Modules: Business Portal


How To Uninstall Business Portal

Here are the steps to completely remove the Business Portal 1.x:

On the IIS Server

1. Uninstall Microsoft Business Portal 1.x for Great Plains\Solomon from Add\Remove Programs in the Control Panel.

2. Uninstall Microsoft SQL Server Digital Dashboard from Add\Remove Programs in the Control Panel. 

Note - This listing will only appear in Add\Remove Programs if you are currently logged into the machine as the user that did the installation of Microsoft SQL Server Digital Dashboard. If you are not logged in as that user, you will need to log out of your windows session and log back into Windows as that user. 

3. Go to Start | Programs | Administrative Tools and Launch Internet Services Manager (IIS) and confirm that the DAVCatalog, Dashboard, and Business Portal virtual directories have been removed.

4. Delete the following folders if they exist:

C:\Program Files\Microsoft Business Solutions\Business Portal
C:\Program Files\SQL Server Digital Dashboard
C:\Program Files\Microsoft SQL Server CE
C:\Winnt\Microsoft .NET\Framework\v1.0.3705\Temporary ASP.NET\business portal

5. Remove all temporary files from the following 2 folders - (user profile folder below is the name of the user who installed Business Portal)

C:\Documents and Settings\userprofile\Local Settings\Temp
C:\WINNT\Temp

6. Go to Start | Run and type REGEDIT.  Delete the following registry keys if they exist:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Business Framework
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Business Portal

WARNING - If a mistake is made on any of the instructions listed below, you may not be able to restart your system. If you are not familiar with the Registry, please seek assistance from Microsoft or your local Microsoft support representative. Microsoft can be reached at 1-800-426-9400.

IMPORTANT - Back up your Windows system before making these changes. It is also important to create a new Emergency Repair Disk.

7. Remove the COM+ objects for the Business Portal by following these steps:

a. Go to Start | Programs | Administrative Tools | Component Services.
b. Click the plus in front of Component Services.
c. Click the plus in front of Computers.
d. Click the plus in front of My Computer.
e. Click the plus in front of COM+ Applications.
f. Right-click on each COM+ Object that begins with Microsoft.BusinessFramework and select Delete.

8. Reboot the IIS Server Machine. 

If you also want to remove Microsoft .Net Framework 1.0, follow these steps:

1. Uninstall Microsoft .Net Framework (English) v1.0.3705 from Add\Remove Programs in the Control Panel.

a.  Delete the folder C:\Winnt\Microsoft .NET if it is not being used for anything else.
b.  Delete the folder C:\WINDOWS\Microsoft.NET\Framework\v1.0.3705

On the SQL Server

1.  Launch Enterprise Manager, right-click the database named DAVCatalog and choose delete.

2.  Under Security | Logins, remove the SQL login created during the BP installation

3.  Execute the REMOVE_DYNAMICS script below in Query Analyzer against the DYNAMICS database to remove the SQL objects.  If on Solomon, execute the REMOVE_DYNAMICS script below in Query Analyzer against the SYSTEM database.

4.  Execute the REMOVE_COMPANY script below in Query Analyzer against each Company database to remove the SQL objects.  If on Solomon, execute the REMOVE_COMPANY script below in Query Analyzer against each Application database.

REMOVE_DYNAMICS

REMOVE_COMPANY

Product: Great Plains, Solomon
Versions: 7.0, 7.5
Modules: Business Portal

SUMMARY

This article describes some troubleshooting steps to use when FRx reports do not display in Business Portal.

The FRx Integration Service is running and the FRx configuration file seems to be set up correctly; however, when you select an FRx report from the center page where the report was assigned to, the FRx report content does not display.
 
MORE INFORMATION

Use the following troubleshooting steps:

1. FRx Integration only allows you to specify one company database, when in Business Portal verify you are checking the reports catalog for the correct company listed in the FRx Configuration Utility.

2.  Share the FRx folder at the root (example C:\FrxBPShare) and make sure Everyone has full control. 

Note - If you have a subfolder as the FRx shared folder, make sure you have entered the correct UNC path for this shared folder.  For example, if you have subfolder2 shared and subfolder2 is under folder1 (and folder1 is on the C root of MyServer and NOT shared), then your reports path and reports UNC path will look similar to the following in the FRx Configuration tool:

    Reports Path = C:\folder1\subfolder2\*.HTM
    Reports UNC path = \\MyServer\subfolder2">\\MyServer\subfolder2

Note: the text in the utility is case sensitive so make sure the paths match what you see in windows explorer.

3.  Check the properties for the FRx Business Portal Integration Service (FRxBPIS) and make sure the executable path is pointing to C:\FrxBPShare\FRxBPIS.exe

To access the FRx Business Portal Integration Service, click Start, click Settings, and then click Control Panel.  In Control Panel, double-click Administrative Tools, double-click Services, and then double-click on FRx Business Portal Integration Service. 

If the executable path is not pointing to C:\FrxBPShare\FRxBPIS.exe, check your FRx configuration by double-clicking the FRxBPISConfigToo.exe in the FrxBPShare shared folder and verify the Reports UNC Path and Reports Path are correct.

If the configuration file has the correct Reports Path, but the executable path in the service is pointing to a different path than the Reports Path, follow these steps:

    a.  Disable or Stop the FRx Business Portal Integration Service. (Click Start, click Settings, and then click Control Panel.  In Control Panel, double-click Administrative Tools, and then double-click Services.) Use Task Manager to delete the FRxBPIS.exe process(es) and then restart the computer.

    b.  From a command prompt, run the following command in the FrxBPShare folder to add the FRx Business Portal Integration service to the Services console:

     FRxBPIS /Service

c. Verify the executable path in the FRx Business Portal Integration Service is correct.

4. View the ReportCatalog table in the Company database you specified in the FRx Configuration and make sure you have an entry like the following:

    PRODNAME = FRxReporter
    Business_Desk_Report_Nam = the name of your FRx report - for example,  xxx.HTM
    Report_URL = \\MyServer\FrxBPShare\

If the entry in the ReportCatalog is wrong, you may remove the HTM file from the FRx shared folder then let the FRxBPIS service update the table.  (By default, the FRxBPIS service runs every 30 seconds).  The FRxBPIS service will remove the entry since you removed the HTM file.  Then copy the HTM file back to the FRx shared folder.  The next time the FRxBPIS service runs, it will repopulate the ReportCatalog table.

Note: Viewing Frx reports from the share depends on having network connectivity otherwise the report may just show as blank.

Printable Link
Email this link

Document ID: 33320
Date Created: 10/1/2003
Date Last Modified: 5/18/2004
Language: English - United States
Country: USA
Product: Great Plains, Solomon
Versions: 5.x, 7.0, 7.5
Modules: Business Portal

Issue

How do you display only the customers for the Salesperson that is currently logged on to Microsoft Business Solutions Business Portal?

Resolution

Note - You will need to have someone with Business Portal Administrator rights to complete the steps below.

1.  In Business Portal, set up the Salesperson Advanced Roles for the user.

a.  Go to Admin-Users.

b.  Select the appropriate user (example Paul W.).

c.  Click on the Modify button by Advanced Roles. 

d.  Select the Roles "Salesperson / YourCompanyName".

e.  Then check the Salesperson's Alias ID you want to tie the Business Portal User to.  
      
2.  Modify the query for the Customer list so the query will return the results for the salesperson that is currently logged into Business Portal.

a.  Go to Sales | Customers.

b.  Click on the drop down by Customer List and select Modify Existing Query.

c.  In the Modify Query window, click on Restrict Rows tab.

d.  Click on Advanced.
    
e.  Click on the magnifying glass by Add and select Salesperson Salesperson ID (Great Plains)  in the Customer Columns.

f.  Click OK.

g.  Change the argument to "is equal to".

h.  Click on the blue right arrow button.

i.  In the Advanced Restrictions window, select Variables, and then select Current Salesperson ID.

j.  Click OK.

k.  Click Save.

3.  Share the query so that it is available to anyone who has access to the Customerlist webpart.

a.  Go to Admin | Portal Elements |Query.

b.  Click on the + by Data Viewer.

c.  Click on the + by Customer List-Customer List.

d.  Click on the + sign by your personal folder (example - jolso - northamerica) and you will see the modified query you just save under this folder.

e.  Click on the modified query then click on the Rename button on the right to rename the query to something more descriptive like Customer List - SalespersonID
    
f.  Click OK.

4.  Move the query from your personal folder to the Customer List folder so it will be available to anyone who has access to the Customer list in the Sales Center page.

a.  Click on the Move to Folder button on the right.

b.  Highlight the Customer List-Customer List folder.

c.  Click OK.

5. Navigate to Sales | Customers.  Now you will see that the customer list webpart has 2 queries when you click on the drop down under Customer Lists.  User will now have the option of selecting either one of the query when in the Customer List webparts. 

SUMMARY

This article describes installation recommendations for Windows SharePoint Services and Business Portal 2.0 if you want to demonstrate Business Portal on a stand-alone computer.

MORE INFORMATION

If you want to demo Business Portal 2.0 on a stand-alone computer, consider the following recommendations for installing Windows SharePoint Services 2.0 (WSS) and Business Portal 2.0. 

These steps assume you already have your back office accounting (Solomon or Great Plains) program installed on this computer.

1. Log into the computer as the local administrator account to do the installations.

2. Install Windows SharePoint Services 2.0 using the "Typical" installation method. This will create a SharePoint WMSDE instance of SQL Server on the same computer as IIS (except with Windows Server 2003 Web Edition). You do not have the search functionality of WSS, but for demo purposes this is a quick and easy way to install against the default IIS Web site.

3. During the Business Portal installation, clear the Enhanced Security check box. This feature requires Active Directory which will not be available.

4. During the Business Portal installation, use the ComputerName when prompted for your domain and use the local administrator account and password. If a local computer account is used during the Business Portal installation, you will not be able to add domain accounts to Business Portal.  To add domain accounts, see the section titled Using the Network Service account for network Access in the Business Portal installation manual. The manual is located on the Business Portal CD in the Documentation folder and is named BusinessPortalInstallation.pdf.

5. Add the loop back IP address and your ComputerName to the Hosts file located in C:\WINDOWS\system32\drivers\etc.

In the following example, the localhost entry typically already exists.  Add a second entry with the same IP address and replace the <ComputerName> with your actual ComputerName.

127.0.0.1       localhost
127.0.0.1       <ComputerName>

6. Add the loop back IP address and your FRxShare to the LMhosts file located in C:\WINDOWS\system32\drivers\etc.

The file at this location is named LMhosts.sam. Copy and then rename this file to LMhosts with no extension. Add the entries for the FRxShare to the bottom of the LMhosts file.

127.0.0.1      \\ComputerName\frxshare

REFERENCES

If you want to demo other Web applications on the same computer, it is best to install them on a separate Web site instead of the default. For more information, see the White Paper entitled Integrating other Web applications with Business Portal 2.x and Windows SharePoint Services 2.0.
https://mbs.microsoft.com/partnersource/products/businessportal/documentation/whitepapers/

Keywords: standalone, stand alone

Product: Great Plains
Versions: 6.0, 7.0
Modules: Business Portal, eEmployee, eOrder, eProducts, eRequisition, eTimesheets, PS Time and Expense

Issue

Access Denied or Registry Permissions Problems occur when installing Web Products.

Note - There seems to be some problems with 'Crystal Decisions Reports 8.0.0.371' and Registry Permissions per Microsoft Knowledge Base Article - 269383 - PRB: 'Error Accessing the System Registry' Message When Displaying VB/VBA References.

Resolution

If the IIS machine has had Crystal Reports 8.0 ever installed, you should run the Hot fix from Microsoft Knowledge Base Article - 269383. The Article indicates the problem has been fixed 'with Crystal Reports Version 8.0.0.441 or higher'.

SYMPTOMS

Business Portal pages are missing content like links and images, hyperlinks do not respond when they are clicked, and a warning icon appears in the status bar.  When you double-click the warning icon, a "permission denied" error is displayed.

CAUSE

Business Portal is being accessed through the IIS Server's IP address (http://123.456.7.89/businessportal) instead of its name (http://servername/businessportal).

RESOLUTION

Enter the computer name of the IIS server in the Address field of your browser when connecting to Business Portal.

Keywords: error on page

SUMMARY

This article discusses how to create a Salesperson Restricted Customer query in Great Plains or Solomon Business Portal.

MORE INFORMATION

1.  Log on to Business Portal as an Administrator.

2.  Click the Admin tab, and then click Users.

3.  Select the User for whom the query is being created.

4.  Verify that a valid Advanced Role of "Salesperson / CompanyName" exists with a valid Back Office ID for this user.

5.  Click Data Permissions from the Admin tab.

6.  From Data Permissions List, expand Customer, and then click Customer Restricted.

7.  Scroll to the bottom and add Salesperson to the Role Associations.

8.  Click the Sales tab. 

9.  Click Queries.

10.  Click New Query.

11.  Click Next in the Create a Query Web Page Dialog.

12.  Select the Customer Business Entity with a Data Permission of Customer - Restricted, and then click Next.

13.  Select desired options and then click Next on each screen until you see the Save Query option.

14.  Assign a descriptive name (like Customer √ Salesperson Restricted) at the Save Query screen, and then click Next.

15.  Click Finish to create the query.

16.  Click the Admin tab and select Portal Elements | Queries.

17.  Expand QueryPages | Sales | Personal | (User Folder) and select the query saved in step 14.

18.  Click Move to Folder.

19.  In Browse for Folder, click Data Viewer | Customers, and then click OK.

Note It is strongly recommended that none of the original queries be deleted.  If they are deleted, Business Portal must be reinstalled to retrieve the queries.  To save the original queries, create a new folder named Original Queries, move the original queries to this folder, and create the same directory structure as the DataViewer.