web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

The Company Drop Down List is empty on the Business Portal 5.1 Home Page

(0) ShareShare
ReportReport
Posted on by 575

Dear All

Actually I'm a facing a very strange problem after installing the GP Business Portal 5.1 which is that The Company Drop Down List is empty on the Business Portal 5.1 Home Page and it doesn't have the list of the companies in GP back end, I log in as a site administrator and I should be able to see all the companies and even for the uses assigned to a specific company,  the drop down list is also empty.

can anyone help me solve this problem since the go live is delayed because of this issue

 

Thanks in advance...

Amr Saad

*This post is locked for comments

I have the same question (0)
  • Rob Bernhardt Profile Picture
    on at

    Amr,

    Is the company dropdown blank for the user who installed Business Portal?  In order for users to have access to these companies, they must be set up under Site Actions > Site Settings > Business Portal Administration > Users.  SharePoint gives your users access to pages, while this pages gives the users access to the data.

    Thanks

    Rob

  • Jonathan Fear Profile Picture
    on at

    Quickest resolution is to uninstall/reinstall BP. I am guessin one of the features did not get installed correctly.

  • Suggested answer
    Community Member Profile Picture
    on at

    Check the following article in KB, it might be the reason:

    support.microsoft.com/.../947927

  • Amr Saad Profile Picture
    575 on at

    Hi Rob

    The problem exists even if I log in with the user which I used during the installation, I checked the privileges for the users in SharePoint and they are OK.

    Dear Jonathan

    Actually I'm trying to fix without re-installing it since the configuration took a lot of time.

    Dear Mohammad

    This configuration I did during the installation and I could see all the web sites created in SharePoint.

    Is there any other component that could affect the Business portal and cause this issue?

    Thanks

    Amr Saad

  • Jonathan Fear Profile Picture
    on at

    I am not sure what you mean by configuration but uninstall/reinstalling BP simply removes and readds the code as long as you do not drop SQL objects. At this point I would recommend opening a support case although we may have to reinstall to ensure the code is correct.

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at

    Hi Rob & Jonathan,

    The BP installation routine is pretty dumb in the way it works... I accidentally selected some of the HRM features not realizing it was not required for the Timesheet / Expense reports and cannot get rid of them now, even if I re-run the setup program and select the features as 'not locally installed'. Somehow this causes now error messages in my BP security and unwanted menu entries on the left side, because the features are not removed...

    Another issue I have is the fact that the Dynamics GP Database server cannot be modified once the BP is installed... If I want to test the upgrade from BP 4.0 to 5.0, there is no way for me to use a Test bed GP server with a copy of the BP server, because I can't change the SQL server instance and make it point to a different server...

    Another point to consider would be to allow the administrator to select between two different options when running the features option, by having the choice to delete the user data and/or to delete only the related BP objects (like stored procédures, views, etc.) that do not affect the data itself. Also the SQL database configuration should allow to select the GP companies you want to include in BP... we have over 15 GP databases, but half of them are Test DB's or archive companies... we don't want those to be available in BP... this is just dumb... Also when you add a new GP company, you sould be able to run the setup only for that new company, not affecting all the other DB's, which I learned the hard way !! because it screwed up my existing configuration for perfect working DB's.

    Just my 2 cents...

    Have a great day,

    Beat

    PS: who can provide a technical assistance related to those unwanted scripts or objects that now causes security errors in my BP ?

  • Rob Bernhardt Profile Picture
    on at

    Beat,

    I'm sorry to hear you're having some issues with BP.  I've provided some thoughts below that I'm hoping could provide some help.

    The BP installation routine is pretty dumb in the way it works... I accidentally selected some of the HRM features not realizing it was not required for the Timesheet / Expense reports and cannot get rid of them now, even if I re-run the setup program and select the features as 'not locally installed'. Somehow this causes now error messages in my BP security and unwanted menu entries on the left side, because the features are not removed...  I'm not sure what BP Security you're referring to, but hopefully this doesn't need to be a problem for your BP users.  If they are not in SharePoint groups that would give them access to these unwanted links, they shouldn't be affected.

    Another issue I have is the fact that the Dynamics GP Database server cannot be modified once the BP is installed... If I want to test the upgrade from BP 4.0 to 5.0, there is no way for me to use a Test bed GP server with a copy of the BP server, because I can't change the SQL server instance and make it point to a different server...

    Another point to consider would be to allow the administrator to select between two different options when running the features option, by having the choice to delete the user data and/or to delete only the related BP objects (like stored procédures, views, etc.) that do not affect the data itself. Also the SQL database configuration should allow to select the GP companies you want to include in BP... we have over 15 GP databases, but half of them are Test DB's or archive companies... we don't want those to be available in BP... this is just dumb... Also when you add a new GP company, you sould be able to run the setup only for that new company, not affecting all the other DB's, which I learned the hard way !! because it screwed up my existing configuration for perfect working DB's.  Thanks for the feedback on the company selection in the install.  We've considered that in the past but obviously haven't prioritized it yet.  Regarding available companies in BP...  if you assign roles for specific companies (not All Companies), your users will only see those companies available as options in the dropdown.

    Just my 2 cents...

    Have a great day,

    Beat

    PS: who can provide a technical assistance related to those unwanted scripts or objects that now causes security errors in my BP ?  Support can help.

     

    Thanks

    Rob

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at

    Hi Rob,

    The security error message is actually poping-up every time I enter into the BP User Administration (not the one from SP) and I get this for every action I do related to a user (add a new role, change or save a modification) :

    " System.Exception: soap:Serer System.Web.Services.Protocols.SoapException: Server was unable to process request. --> System.Exception: Class: Microsoft.Dynamics.Hrm.Entity.YTDFedTaxesFICA is not found or not valid. [...] "

    about 4 other lines are comming to complete this message, but since there is no selection/copy possible, I had to retype it here. At the very end there is a reference to :

    "Microsoft.BusinessFrameWork.Portal.Administration.AC_SecurityAdministrator.GetUserDataAndTaskPermissions"

    As for the company selection from the pull-down list, I'm aware that this exists and I also set the roles for the users accordingly, so they only see the ones they need. For me however as a BP admin, it's cumbersome to navigate thru all the possibilities in the security settings for companies that are not relevant to BP for us... That's what I meant by being able to setup BP selectively for GP companies...

    Also the distinction between wiping out user data and objects only related to the functionnality of BP would be very handy... because obviously the removal of installed features doesn't work... once they are installed, they stick within the GP companies and causes all kinds of issues later on....

    This could also be some sort of SQL clean-up script... The tables that contains user data should remain intact unless specified otherwise, and only the tables for configuration data and/or objects should be deleted.  

    This is something that any normal Windows application would be capable of handling :-).  

    My upgrade system is currently sitting in a Test VLAN together with a copy of my GP server, since I cannot change the name of the system in the BP configuration, thus I need to carry the exact same identity, but those two servers cannot sit in the same network as my current production systems... thus making it extremely difficult to test the upgrade. The BP web site make usage of SSL certificates that are tied to the domain name of that sytem, so I cannot change the server name without breaking some of the security relations to the IIS, which causes all kinds of weird behavior in the IE browser (i.e. 404 page not found, though the ASPX page does exist).

    Due to that configuration, my actual test bed environment is not accessible from / to the internet, thus I cannot get a technical assistance from MS... I need to carry that upgrade first to my production server and then cross the fingers that everything will work as expected after the upgrade. At this point I'll be able to open a ticket with you guys thru our Partner and have a look into...

    My last attempt to get this fixed turned dead when Derek Albaugh looked into this issue, because our BP was on version 4.0, which is not supported with GP 2010... When I spoke to Kelly Youells at Convergence, she said the easiest way to get to right level would be to just upgrade to BP 5.0, because this doesn't require to update the SharePoint services and is should be pretty straightforward.

    Derek sent me a list of all the tables that are involved by the BP 5.x, but that didn't tell me which ones were actually new tables added since 4.0 and those ones may causing me problems now.

    Thanks in advance for your tips and hints.

  • Rob Bernhardt Profile Picture
    on at

    Beat,

    Sorry for your troubles!  It sounds like a data permission or something related to HRM was removed while the assignment to given users or roles was left behind.  Support should be able to help you clean this up through SQL.

    There shouldn't be any new tables that are specific to BP for 5.0.  Dynamics GP adds new tables every release, but Business Portal hasn't added new tables for a couple releases.

    Thanks

    Rob

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at

    Hi Rob,

    I updated tonight our production BP 4.0 to 5.0... the upgrade did produce one SQL error message during the setup of the new BP 5.0, but it was for a company that we don't use in BP, so it was not really a concern.

    After the update was completed and the BP server rebooted a few times, the BP is accessible and seems to work, with one exception... All the embedded web-parts that are using the BP ActiveX are returning an error 404 NOT FOUND... even in the Administration page when trying to edit the requisition management hierarchy... none of the native web-parts are working, even some pages are not showing up completely. The regular SharePoint WSS 3.0 pages are displaying fine. This looks like a permission or security issue on the IIS side, because when browsing the pages from within IIS, they show up just fine too... but the major difference is the URL :  the regular URL is https://bp.contactft.com/BP, whereas when browsing the content within IIS, it shows http://localhost:82/BP... the major difference looks like to be the SSL usage in one case and the FQDN is replaced by 'localhost'...

    The certificate for the SSL was working fine under BP 4.0 and nothing has changed on the server identity side...

    Do you have any idea where to look for to fix this issue ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans