Options
Error when installing load balanced portal
Jerrett_Ferguson
Customer IT Monkey ✭
Hi,
I've got 3 management servers and I am attempting to put the portal on all three:
Primary Management Server - Portal, cache builder service and analytics
Secondary Mgmt Server - Portal
Secondary Mgmt Server - Portal
I plan on load balancing the two secondary management servers at a later date but right now when I install the portal on the two secondary mgmt servers, I get an error:
3/10/2017 8:28:54 AM Failed to Deploy DacPac via DacServices API: server=<sql>;Trusted_Connection=True; Could not deploy package.
3/10/2017 8:28:57 AM Failed to Populating Default Datasource Configuration items SM16SST_Prod on <sql> : Invalid object name 'DataSourceConfiguration'.
3/10/2017 8:28:57 AM Failed to Populating Default Datasource Configuration items SM16SST_Prod on <sql> : Invalid object name 'DataSourceConfiguration'.
The portal installed fine on the primary management server, I'm just having problems with these secondary management servers. I did see this article about installing the dacpac file manually: https://community.cireson.com/discussion/926/support-faq-manual-installion-of-the-dacpac-file
but is that necessary for the secondary portal servers? Any other ideas? I'm also seeing these errors, which I'm assuming are related:
Warning SQL72015: The table [dbo].[KnowledgeArticle] is being dropped and re-created since all non-computed columns within the table have been redefined.
Warning SQL72030: If this deployment is executed, changes to [dbo].[KnowledgeArticle] might introduce run-time errors in [dbo].[p_ManagementPackFinishInstall].
Warning SQL72030: If this deployment is executed, changes to [dbo].[KnowledgeArticle] might introduce run-time errors in [dbo].[KnowledgeView].
Warning SQL72030: If this deployment is executed, changes to [dbo].[KnowledgeArticle] might introduce run-time errors in [dbo].[p_DeleteObsoleteLanguagePacks].
Warning SQL72030: If this deployment is executed, changes to [dbo].[KnowledgeArticle] might introduce run-time errors in [dbo].[p_DeleteObsoleteMonitoringObjects].
Warning SQL72030: If this deployment is executed, changes to [dbo].[KnowledgeArticle] might introduce run-time errors in [dbo].[p_FindLanguagePacksNotInSnapshot].
Warning SQL72030: If this deployment is executed, changes to [dbo].[KnowledgeArticle] might introduce run-time errors in [dbo].[p_MPSelectForExport].
Warning SQL72030: If this deployment is executed, changes to [dbo].[KnowledgeArticle] might introduce run-time errors in [dbo].[p_MPSelectKnowledgeArticle].
Error SQL72014: .Net SqlClient Data Provider: Msg 207, Level 16, State 1, Line 29 Invalid column name 'EndUserContentType'.
Error SQL72045: Script execution error. The executed script:
I've got 3 management servers and I am attempting to put the portal on all three:
Primary Management Server - Portal, cache builder service and analytics
Secondary Mgmt Server - Portal
Secondary Mgmt Server - Portal
I plan on load balancing the two secondary management servers at a later date but right now when I install the portal on the two secondary mgmt servers, I get an error:
3/10/2017 8:28:54 AM Failed to Deploy DacPac via DacServices API: server=<sql>;Trusted_Connection=True; Could not deploy package.
3/10/2017 8:28:57 AM Failed to Populating Default Datasource Configuration items SM16SST_Prod on <sql> : Invalid object name 'DataSourceConfiguration'.
3/10/2017 8:28:57 AM Failed to Populating Default Datasource Configuration items SM16SST_Prod on <sql> : Invalid object name 'DataSourceConfiguration'.
The portal installed fine on the primary management server, I'm just having problems with these secondary management servers. I did see this article about installing the dacpac file manually: https://community.cireson.com/discussion/926/support-faq-manual-installion-of-the-dacpac-file
but is that necessary for the secondary portal servers? Any other ideas? I'm also seeing these errors, which I'm assuming are related:
Warning SQL72015: The table [dbo].[KnowledgeArticle] is being dropped and re-created since all non-computed columns within the table have been redefined.
Warning SQL72030: If this deployment is executed, changes to [dbo].[KnowledgeArticle] might introduce run-time errors in [dbo].[p_ManagementPackFinishInstall].
Warning SQL72030: If this deployment is executed, changes to [dbo].[KnowledgeArticle] might introduce run-time errors in [dbo].[KnowledgeView].
Warning SQL72030: If this deployment is executed, changes to [dbo].[KnowledgeArticle] might introduce run-time errors in [dbo].[p_DeleteObsoleteLanguagePacks].
Warning SQL72030: If this deployment is executed, changes to [dbo].[KnowledgeArticle] might introduce run-time errors in [dbo].[p_DeleteObsoleteMonitoringObjects].
Warning SQL72030: If this deployment is executed, changes to [dbo].[KnowledgeArticle] might introduce run-time errors in [dbo].[p_FindLanguagePacksNotInSnapshot].
Warning SQL72030: If this deployment is executed, changes to [dbo].[KnowledgeArticle] might introduce run-time errors in [dbo].[p_MPSelectForExport].
Warning SQL72030: If this deployment is executed, changes to [dbo].[KnowledgeArticle] might introduce run-time errors in [dbo].[p_MPSelectKnowledgeArticle].
Error SQL72014: .Net SqlClient Data Provider: Msg 207, Level 16, State 1, Line 29 Invalid column name 'EndUserContentType'.
Error SQL72045: Script execution error. The executed script:
0
Best Answer
-
Options
Joe_Burrows
Cireson Devops Super IT Monkey ✭✭✭✭✭
Can you check your SQL connection strings on your secondary servers definitely match the connectionstring on your primary.
Check this in C:\Inetpub\Ciresonportal\web.config
If they are then would recommend raising as a support ticket as easier to troubleshoot in a support session.5
Answers
If the websites load OK on your secondary servers then id say your fine, however your welcome to open a support ticket up if you would like us to take a look.
Cheers
Joe
Check this in C:\Inetpub\Ciresonportal\web.config
If they are then would recommend raising as a support ticket as easier to troubleshoot in a support session.