275
We have had Businss portal intalled a while and had the Employee Profile working but now we get a Query error. If I open the Details I get the following.
"Microsoft.BusinessFramework.Data.GeneralDatabaseException
Invalid object name 'TWO..Hrm_WorkContactDetails'."
Has anyone else seen this error? How can I fix it?
thanks for any help you can provide.
*This post is locked for comments
Hello Irfan,
Not sure where you're at with this, but if you're at the same spot and error, we may need to have an actual support case opened if you haven't already done so, so a technician can logon to your system and look through the Business Portal environment and look at the tables I mentioned to see what is not setup correctly.
The 'unable to validate company information' error is just as it mentions, in that it is trying to read data from the company database either directly through Business Portal to SQL or through Web Services to SQL, and for whatever reason it cannot do so.
The fact that SQL Configuration fails is also not a good sign as it means it is not able to verify that all SQL objects (tables, procedures, views, etc) for Business Portal are created in the GP databases, which can also lead to this error as well as the 'invalid object' errors you mentioned previously.
If this is a new install/upgrade, you may need to complete uninstall Business Portal, leaving the database objects in place if needed, and then do a new install of BP. We have scripts and batch files that help do this, as it isn't as easy as it is with other applications like reinstalling Dynamics GP.
The problem is it is too complex an issue to troubleshoot over forums such as this, without being able to access your environment and look at it.
Let me know if you have any further questions.
Thank you,
No luck so far Derek. I also ask on another support case (below is its link) but no reply from there as well.
partnersupport.microsoft.com/.../715eae18-837e-4d0f-b99a-894bb0662ffb
Hello Irfan,
Any update on your Business Portal issues?
Thanks,
Usually the 'unable to validate company information' error has to do with the tables I mentioned, whether it be invalid records, records for databases that no longer exist on the SQL instance you're on, etc.
I've seen this also caused by not having Web Services installed, which BP required in some newer versions but it isn't necessarily required in BP for GP 2010 unless you are on a specific SharePoint version, as mentioned in the Dynamics GP 2010 System Requirements for Web Components:
"Business Portal running on Microsoft Office SharePoint Server 2007 Enterprise Edition, Microsoft SharePoint Foundation 2010, Microsoft SharePoint Server 2010 Enterprise Edition or Microsoft SharePoint Server 2010 Standard Edition (NOTE: Standard Edition only supported with Business Portal 5.1 R2 or later) requires Web Services to be installed."
If you are using one of these versions for Business Portal, and require Web Services to be installed, you can verify which GP system and company databases you have Web Services installed on, by running this script:
Select * from DYNAMICS..WSInstallStatus
In this table, you should have 5 records for the DYNAMICS system database and 4 records for each company database. All records should be showing a version of 11.0.#### since you are on Dynamics GP 2010. If any of your company databases don't have Web Services installed on them, you may need to run the Web Services Configuration Wizard to install WS onto that company database.
You mentioned you get this error when running SQL Configuration, after supplying server credentials. Do you mean after supplying the SQL Server information in the 'Connection Information' window or where?
Thanks
Exactly, I tried to ran SQL configuration on Business portal, where I get the message, after supplying server credentials.
Message is 'Unable to validate company information in your backoffice data'.
It seems, a little thing is missing in whole configuration.
Well, the new company database would need to have SQL Configuration ran against it if you plan on using it in Business Portal.
The company drop-down list in BP is taken from the SY01500 table, so even though you may be able to login to BP for this new company database, you still need BP installed onto it, otherwise you'll get errors like you're seeing, where it can't find the company in the back office and 'invalid object names'.
SQL Configuration creates all the database objects (tables, procedures, indexes, views, triggers, etc.) that BP uses, in the databases.
Are you only getting errors on this new company database, or the pre-existing databases as well?
In my case, for 3rd query, there are 29 records for the DYNAMICS system database, where all are on version 3.0.1800 (Business Portal Version 3 for GP 2010R2) whereas Business Framework having 1.2.50327.
As far as other companies are concern, they are all on same version.
Infact we have created a new company in our GP environment, which we need to configure with portal. However, we can access portal of that new company, but in Project Expenses part, we are facing the error, mentioned earlier (An unexpected error has occurred. Please contact your system administrator.)
When the error mentions 'backoffice' data, it could be referring to Business Portal or SQL.
To verify the SQL side first, verify you see the company database, throwing this error, in the following tables:
1. Select CMPANYID,CMPNYNAM,INTERID from DYNAMICS..SY01500
2. Select * from DYNAMICS..DB_Upgrade where PRODID = 0
3. Select * from DYNAMICS..MBFInstalledDatabases
In the SY01500 table, there should be one record for each company database that you have for Dynamics GP, the DYNAMICS/system database won't be listed.
In the DB_Upgrade table, it'll show the DYNAMICS/system database and each company database for GP. Verify that all of these show the same version and that the databases actually exist in SQL.
Lastly, in the MBFInstalledDatabases table, this is a BP table that is similar to the DB_Upgrade table that GP uses. Business Portal uses this table to show each database that has BP installed on it, which modules and at what version.
For example, on my BP 6.1 for Dynamics GP 2013 environment, this table shows 26 records for the DYNAMICS system database, each at a 6.1.1088 version, except for 'Business Framework' which will be the only record that will be different than all the others (it shows 1.2.50707). The company databases should all show here as well and each module installed should be the same version as what the system database shows.
Verify this all shows correctly and let me know if you have any questions.
Also, is this a new install of Business Portal or an upgrade, or is this an existing install that has been working up until recently?
Thanks
Thanks Derek, for the help.
I got resolved the first error, by creating a new table in this DB.
However, after following steps for the resolution of error 2, I am still getting same error.
I have also tried to run SQL Configuration over my BP site, but here I am getting another error 'Unable to validate company information in your backoffice data.'
The first error, if you run this script in SQL Server Mgmt Studio, does it show a table, or come back with the same 'invalid object name.....' error? The query is:
Select * from QKSA..Hrm_WorkContactDetails
Looking at my Business Portal environment, there are approximately 26 or so HRM tables if HRM is installed for Business Portal.
If you're only missing this one table, you could probably script it from another company database if you have others, but if you're missing most of the HRM tables even though you do have HRM installed, you may need to run SQL Configuration against the databases to add the missing objects that BP should've put there when you installed/upgraded it. (make sure to make backups of the databases before any changes)
The second error is generic and doesn't show us anything that we can use.
To get a more detailed error message, try the following:
1. Determine the home directory of your Business Portal site.
a. Open IIS and locate the virtual server hosting your Business Portal site
b. Right click on the virtual server and select Properties
c. Click the Home Directory tab and note the Local Path file location
2. Browse the directory and locate the web.config file
3. Make a backup of this file
4. Open the web.config file and make the following changes:
Find: CallStack="false"
Change to: CallStack="true"
Find: CustomErrors mode="RemoteOnly"
Change to: CustomErrors mode="Off"
5. Save your changes
6. Run IISRESET and launch Business Portal again and re-create the error, it should now give more detail to the actual cause of the 'unexpected error' message.
Also, on the SharePoint/BP server, if you look in the Event Viewer logs, BP sometimes will write errors and warnings in there, so I'd look for any corresponding information in those logs as well.
Thanks
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,403
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
