Topics

All topics

Setup and maintenance

Application status page output

EXAMPLE: The following list of operations is an example of the application status page output, when the site is upgrade from Sitefinity CMS 8.0 to Sitefinity CMS 8.2:

	Sitefinity CMS is Initializing

	System is initializing...

	(23/09/2015 08:53:00) Db Migration Complexity: Extending

	(23/09/2015 08:53:00) Adding a column(s) on an existing table(s).

	(23/09/2015 08:53:00) Adding an index(indices) to an existing table(s).

	(23/09/2015 08:53:00) -- add column for field ControlData.personalizationSegmentId

	ALTER TABLE [sf_object_data] ADD [personalization_segment_id] uniqueidentifier NULL

	(23/09/2015 08:53:00) -- add column for field ControlData.isPersonalized

	ALTER TABLE [sf_object_data] ADD [is_personalized] tinyint NULL

	(23/09/2015 08:53:00) -- add column for field ControlData.ControlData_personalizedControls

	ALTER TABLE [sf_object_data] ADD [personalization_master_id] uniqueidentifier NULL

	(23/09/2015 08:53:00) -- Index 'idx_sf_bjct_dt_prsnlztn_mstr_d' was not detected in the database. It will be created

	CREATE INDEX [idx_sf_bjct_dt_prsnlztn_mstr_d] ON [sf_object_data]([personalization_master_id])

	(23/09/2015 08:53:01) Db Migration Complexity: Extending

	(23/09/2015 08:53:01) Adding a column(s) on an existing table(s).

	(23/09/2015 08:53:01) -- add column for field metadata

	ALTER TABLE [sf_version_chnges] ADD [metadata] varchar(4000) NULL

	(23/09/2015 08:53:01) -- add column for field isSyncedItem

	ALTER TABLE [sf_vesion_items] ADD [synced] tinyint NULL

	(23/09/2015 08:53:01) UPDATE [sf_vesion_items] SET [synced] = 0

	(23/09/2015 08:53:01) ALTER TABLE [sf_vesion_items] ALTER COLUMN [synced] tinyint NOT NULL

	(23/09/2015 08:53:01) PASSED : SiteInitializer: Upgrade to 5800 (method: UpgradePresentationData)

	(23/09/2015 08:53:01) PASSED : SiteInitializer: Upgrade to 5800 (method: RegisterChangeQuestionAndAnswerTemplate)

	(23/09/2015 08:53:01) PASSED : SiteInitializer: Upgrade to 5800 (method: UpgradeDecimalCustomFields)

	(23/09/2015 08:53:03) Db Migration Complexity: Complex

	(23/09/2015 08:53:03) Modifying a column(s) on an existing table(s).

	(23/09/2015 08:53:03) -- Column was read from database as: [password_question] varchar(255) null

	-- modify column for field passwordQuestion

	ALTER TABLE [sf_users] ALTER COLUMN [password_question] NVARCHAR(500) NULL

	(23/09/2015 08:53:06) Db Migration Complexity: Extending

	(23/09/2015 08:53:06) Adding a column(s) on an existing table(s).

	(23/09/2015 08:53:06) -- add column for field subscriptionListId

	ALTER TABLE [sf_scheduled_tasks] ADD [subscr_lst_id] uniqueidentifier NULL

	(23/09/2015 08:53:13) PASSED : Changing the AzureBlobStorageProvider namespace and assembly.

	(23/09/2015 08:53:13) PASSED : 9360e40e-3692-4b67-86c9-60c64de3b919 LibrariesModule: Upgrade to 5900 (AzureBlobStorageProvider is now extracted in a separate Git project. The new assembly is Telerik.Sitefinity.Azure and the new namespace is Telerik.Sitefinity.Azure.BlobStorage.)

	(23/09/2015 08:53:17) Db Migration Complexity: Extending

	(23/09/2015 08:53:17) Adding a column(s) on an existing table(s).

	(23/09/2015 08:53:17) -- add column for field <Framework>k__BackingField

	ALTER TABLE [sf_form_description] ADD [frmwrk] int NULL

	(23/09/2015 08:53:17) UPDATE [sf_form_description] SET [frmwrk] = 0

	(23/09/2015 08:53:17) ALTER TABLE [sf_form_description] ALTER COLUMN [frmwrk] int NOT NULL

	(23/09/2015 08:53:23) Db Migration Complexity: Complex

	(23/09/2015 08:53:23) Adding a column(s) on an existing table(s).

	(23/09/2015 08:53:23) Modifying a column(s) on an existing table(s).

	(23/09/2015 08:53:23) -- add column for field retryCount

	ALTER TABLE [sf_bounce_stat] ADD [retry_count] int NULL

	(23/09/2015 08:53:23) UPDATE [sf_bounce_stat] SET [retry_count] = 0

	(23/09/2015 08:53:23) ALTER TABLE [sf_bounce_stat] ALTER COLUMN [retry_count] int NOT NULL

	(23/09/2015 08:53:23) -- Column was read from database as: [message_status] int not null

	-- modify column for field messageStatus

	ALTER TABLE [sf_bounce_stat] ALTER COLUMN [message_status] int NULL

	(23/09/2015 08:53:23) -- add column for field isProcessing

	ALTER TABLE [sf_bounce_stat] ADD [is_processing] tinyint NULL

	(23/09/2015 08:53:23) UPDATE [sf_bounce_stat] SET [is_processing] = 0

	(23/09/2015 08:53:23) ALTER TABLE [sf_bounce_stat] ALTER COLUMN [is_processing] tinyint NOT NULL

	(23/09/2015 08:53:23) -- add column for field bounceStatus

	ALTER TABLE [sf_bounce_stat] ADD [bounce_status] int NULL

	(23/09/2015 08:53:23) UPDATE [sf_bounce_stat] SET [bounce_status] = 0

	(23/09/2015 08:53:23) ALTER TABLE [sf_bounce_stat] ALTER COLUMN [bounce_status] int NOT NULL

	(23/09/2015 08:53:28) Db Migration Complexity: Extending

	(23/09/2015 08:53:28) Adding a column(s) on an existing table(s).

	(23/09/2015 08:53:28) Adding a foreign key constraint(s) to a new table(s), the create table statement(s) is included as well.

	(23/09/2015 08:53:28) Adding an index(indices) definition for a new table(s), the create table statement(s) is included as well.

	(23/09/2015 08:53:28) Adding a new table(s).

	(23/09/2015 08:53:28) -- Telerik.Sitefinity.DynamicTypes.Model.sf_ec_prdct_book

	CREATE TABLE [sf_ec_prdct_book] (

	[id] uniqueidentifier NOT NULL,

	[release_date] DATETIME NULL, -- sf_ec_prdct_book.ReleaseDate

	[Publisher] NVARCHAR(255) NULL, -- sf_ec_prdct_book.Publisher

	[number_of_pages] INT NULL, -- sf_ec_prdct_book.NumberOfPages

	[i_s_b_n] NVARCHAR(255) NULL, -- sf_ec_prdct_book.ISBN

	[author] NVARCHAR(255) NULL, -- sf_ec_prdct_book.Author

	CONSTRAINT [pk_sf_ec_prdct_book] PRIMARY KEY ([id])

	)

	(23/09/2015 08:53:28) -- Telerik.Sitefinity.DynamicTypes.Model.sf_ec_prdct_generalproduct

	CREATE TABLE [sf_ec_prdct_generalproduct] (

	[id] uniqueidentifier NOT NULL,

	CONSTRAINT [pk_sf_ec_prdct_generalproduct] PRIMARY KEY ([id])

	)

	(23/09/2015 08:53:28) -- Telerik.Sitefinity.DynamicTypes.Model.sf_ec_prdct_software

	CREATE TABLE [sf_ec_prdct_software] (

	[id] uniqueidentifier NOT NULL,

	[release] NVARCHAR(255) NULL, -- sf_ec_prdct_software.Release

	[platform] NVARCHAR(255) NULL, -- sf_ec_prdct_software.Platform

	CONSTRAINT [pk_sf_ec_prdct_software] PRIMARY KEY ([id])

	)

	(23/09/2015 08:53:28) -- Telerik.Sitefinity.DynamicTypes.Model.sf_ec_prdct_song

	CREATE TABLE [sf_ec_prdct_song] (

	[id] uniqueidentifier NOT NULL,

	[release_year] INT NULL, -- sf_ec_prdct_song.ReleaseYear

	[length] NVARCHAR(255) NULL, -- sf_ec_prdct_song.Length

	[artist] NVARCHAR(255) NULL, -- sf_ec_prdct_song.Artist

	[album] NVARCHAR(255) NULL, -- sf_ec_prdct_song.Album

	CONSTRAINT [pk_sf_ec_prdct_song] PRIMARY KEY ([id])

	)

	(23/09/2015 08:53:28) -- add column for field <internal-class-id>

	ALTER TABLE [sf_ec_product] ADD [voa_class] int NULL

	(23/09/2015 08:53:28) UPDATE [sf_ec_product] SET [voa_class] = 0

	(23/09/2015 08:53:28) ALTER TABLE [sf_ec_product] ALTER COLUMN [voa_class] int NOT NULL

	(23/09/2015 08:53:28) -- Telerik.OpenAccess.TrackedList`1[[System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] Telerik.Sitefinity.Ecommerce.Catalog.Model.Product.Department

	CREATE TABLE [sf_ec_product_department] (

	[id] uniqueidentifier NOT NULL,

	[seq] int NOT NULL, -- <sequence>

	[val] uniqueidentifier NULL, -- <value>

	CONSTRAINT [pk_sf_ec_product_department] PRIMARY KEY ([id], [seq])

	)

	(23/09/2015 08:53:28) -- Telerik.OpenAccess.TrackedList`1[[System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] Telerik.Sitefinity.Ecommerce.Catalog.Model.Product.Tags

	CREATE TABLE [sf_ec_product_tags] (

	[id] uniqueidentifier NOT NULL,

	[seq] int NOT NULL, -- <sequence>

	[val] uniqueidentifier NULL, -- <value>

	CONSTRAINT [pk_sf_ec_product_tags] PRIMARY KEY ([id], [seq])

	)

	(23/09/2015 08:53:28) ALTER TABLE [sf_ec_prdct_book] ADD CONSTRAINT [ref_sf_c_prdct_bk_sf__4ADEB946] FOREIGN KEY ([id]) REFERENCES [sf_ec_product]([id]) ON DELETE CASCADE

	(23/09/2015 08:53:28) ALTER TABLE [sf_ec_prdct_generalproduct] ADD CONSTRAINT [ref_sf_c_prdct_gnrlpr_1BF9D988] FOREIGN KEY ([id]) REFERENCES [sf_ec_product]([id]) ON DELETE CASCADE

	(23/09/2015 08:53:28) ALTER TABLE [sf_ec_prdct_software] ADD CONSTRAINT [ref_sf_c_prdct_sftwr__02DBF4EF] FOREIGN KEY ([id]) REFERENCES [sf_ec_product]([id]) ON DELETE CASCADE

	(23/09/2015 08:53:28) ALTER TABLE [sf_ec_prdct_song] ADD CONSTRAINT [ref_sf_c_prdct_sng_sf_60B26BCA] FOREIGN KEY ([id]) REFERENCES [sf_ec_product]([id]) ON DELETE CASCADE

	(23/09/2015 08:53:28) ALTER TABLE [sf_ec_product_department] ADD CONSTRAINT [ref_sf_c_prdct_dprtmn_B6654094] FOREIGN KEY ([id]) REFERENCES [sf_ec_product]([id])

	(23/09/2015 08:53:28) ALTER TABLE [sf_ec_product_tags] ADD CONSTRAINT [ref_sf_c_prdct_tgs_sf_7D33BDB8] FOREIGN KEY ([id]) REFERENCES [sf_ec_product]([id])

	(23/09/2015 08:53:28) -- Index 'idx_sf_c_prduct_department_val' was not detected in the database. It will be created

	CREATE INDEX [idx_sf_c_prduct_department_val] ON [sf_ec_product_department]([val])

	(23/09/2015 08:53:28) -- Index 'idx_sf_ec_product_tags_val' was not detected in the database. It will be created

	CREATE INDEX [idx_sf_ec_product_tags_val] ON [sf_ec_product_tags]([val])

	(23/09/2015 08:53:33) PASSED : 6D7A17E6-533B-4D54-83B8-5D8A33B652A6 ModuleBuilderModule: Upgrade to 5900 (Upgrades the DynamicModuleConfig file to change the value of the 'allowMultiple' taxonomy field to true. This field was not taken into account until now.)

	(23/09/2015 08:53:35) Db Migration Complexity: Extending

	(23/09/2015 08:53:35) Adding an index(indices) to an existing table(s).

	(23/09/2015 08:53:35) -- Index 'idx_sf_rdsgn_md_qry_rl_prnt_md' was not detected in the database. It will be created

	CREATE INDEX [idx_sf_rdsgn_md_qry_rl_prnt_md] ON [sf_rdsgn_media_query_rule]([parent_media_query_id])

	(23/09/2015 08:53:53) Db Migration Complexity: Trivial

	(23/09/2015 08:53:53) Adding an index(indices) definition for a new table(s), the create table statement(s) is included as well.

	(23/09/2015 08:53:53) Adding a new table(s).

	(23/09/2015 08:53:53) -- Telerik.Sitefinity.Translations.Model.Lock

	CREATE TABLE [sf_locks] (

	[lckr] uniqueidentifier NULL, -- locker

	[last_mod] datetime NOT NULL, -- lastModified

	[id] uniqueidentifier NOT NULL, -- id

	CONSTRAINT [pk_sf_locks] PRIMARY KEY ([id])

	)

	(23/09/2015 08:53:53) -- Telerik.Sitefinity.Translations.Model.Job

	CREATE TABLE [sf_tr_jbs] (

	[trg_langs] varchar(2000) NULL, -- targetLanguages

	[prjc_id] uniqueidentifier NULL, -- project

	[id] uniqueidentifier NOT NULL, -- id

	[date_created] datetime NOT NULL, -- dateCreated

	CONSTRAINT [pk_sf_tr_jbs] PRIMARY KEY ([id])

	)

	(23/09/2015 08:53:53) -- Telerik.Sitefinity.Translations.Model.TranslationProject

	CREATE TABLE [sf_tr_prjcts] (

	[title] NVARCHAR(255) NULL, -- title

	[status] int NOT NULL, -- status

	[start_date] datetime NOT NULL, -- startDate

	[site_id] uniqueidentifier NULL, -- siteId

	[retry_count] int NOT NULL, -- retryCount

	[po_ref] NVARCHAR(255) NULL, -- poReference

	[owner] uniqueidentifier NULL, -- owner

	[id] uniqueidentifier NOT NULL, -- id

	[external_id] varchar(255) NULL, -- externalId

	[due_date] datetime NOT NULL, -- dueDate

	[dscrptn] NVARCHAR(255) NULL, -- description

	[date_sent] datetime NULL, -- dateSent

	[date_created] datetime NOT NULL, -- dateCreated

	[date_completed] datetime NULL, -- dateCompleted

	[cnctr] varchar(255) NULL, -- connector

	[act_src_lang] varchar(255) NULL, -- actualSourceLanguage

	CONSTRAINT [pk_sf_tr_prjcts] PRIMARY KEY ([id])

	)

	(23/09/2015 08:53:53) -- Telerik.Sitefinity.Translations.Model.TranslatableSource

	CREATE TABLE [sf_tr_sources] (

	[title] NVARCHAR(255) NULL, -- title

	[src_lang] varchar(255) NULL, -- sourceLanguage

	[site_id] uniqueidentifier NULL, -- siteId

	[root_key] varchar(255) NULL, -- rootKey

	[parnt_id] uniqueidentifier NULL, -- parentId

	[item_type] varchar(255) NULL, -- itemType

	[item_prvdr] varchar(255) NULL, -- itemProvider

	[item_id] uniqueidentifier NULL, -- itemId

	[id] uniqueidentifier NOT NULL, -- id

	CONSTRAINT [pk_sf_tr_sources] PRIMARY KEY ([id])

	)

	(23/09/2015 08:53:53) -- Telerik.Sitefinity.Translations.Model.Translation

	CREATE TABLE [sf_tr_trnsltns] (

	[unique_item_key] varchar(255) NOT NULL, -- uniqueItemKey

	[trns_status] int NOT NULL, -- translationStatus

	[trg_lang] varchar(255) NULL, -- targetLanguage

	[src_vrsn_type] int NOT NULL, -- sourceVersionType

	[tr_source_id] uniqueidentifier NULL, -- <Source>k__BackingField

	[owner] uniqueidentifier NULL, -- owner

	[metadata] varchar(255) NULL, -- metadata

	[job_id] uniqueidentifier NULL, -- <Job>k__BackingField

	[id] uniqueidentifier NOT NULL, -- id

	[ext_status] NVARCHAR(500) NULL, -- externalStatus

	[external_id] varchar(255) NULL, -- externalId

	[err_msg] NVARCHAR(MAX) NULL, -- errorMessage

	[date_modified] datetime NULL, -- dateModified

	[date_created] datetime NOT NULL, -- dateCreated

	[act_src_lang] varchar(255) NOT NULL, -- actualSourceLanguage

	[voa_version] smallint NOT NULL, -- <internal-version>

	CONSTRAINT [pk_sf_tr_trnsltns] PRIMARY KEY ([id])

	)

	(23/09/2015 08:53:53) -- Telerik.Sitefinity.Translations.Model.TranslationUnit

	CREATE TABLE [sf_tr_units] (

	[trns_id] uniqueidentifier NULL, -- translation

	[title] NVARCHAR(255) NULL, -- title

	[trg_val] NVARCHAR(MAX) NULL, -- targetValue

	[src_val] NVARCHAR(MAX) NULL, -- sourceValue

	[prop_name] varchar(255) NULL, -- propertyName

	[ordinal] real NOT NULL, -- ordinal

	[id] uniqueidentifier NOT NULL, -- id

	CONSTRAINT [pk_sf_tr_units] PRIMARY KEY ([id])

	)

	(23/09/2015 08:53:53) -- Index 'idx_tr_prjcts_extrnl_id' was not detected in the database. It will be created

	CREATE INDEX [idx_tr_prjcts_extrnl_id] ON [sf_tr_prjcts]([external_id])

	(23/09/2015 08:53:53) -- Index 'idx_itm_descrtn' was not detected in the database. It will be created

	CREATE INDEX [idx_itm_descrtn] ON [sf_tr_sources]([item_id], [item_type], [item_prvdr])

	(23/09/2015 08:53:53) -- Index 'idx_trns_unq_item_trglang' was not detected in the database. It will be created

	CREATE UNIQUE INDEX [idx_trns_unq_item_trglang] ON [sf_tr_trnsltns]([unique_item_key], [trg_lang])

	(23/09/2015 08:53:53) -- Index 'idx_trns_status' was not detected in the database. It will be created

	CREATE INDEX [idx_trns_status] ON [sf_tr_trnsltns]([trns_status])

	(23/09/2015 08:53:53) -- Index 'idx_trns_extrnl_id' was not detected in the database. It will be created

	CREATE INDEX [idx_trns_extrnl_id] ON [sf_tr_trnsltns]([external_id])

	(23/09/2015 08:53:53) -- Index 'idx_sf_tr_trnsltns_tr_surce_id' was not detected in the database. It will be created

	CREATE INDEX [idx_sf_tr_trnsltns_tr_surce_id] ON [sf_tr_trnsltns]([tr_source_id])

	(23/09/2015 08:53:53) -- Index 'idx_sf_tr_units_trns_id' was not detected in the database. It will be created

	CREATE INDEX [idx_sf_tr_units_trns_id] ON [sf_tr_units]([trns_id])

	(23/09/2015 08:53:54) PASSED : Telerik.Sitefinity.Services.Notifications.Data.OpenAccessNotificationsProvider : Upgrade to 5800 - Removing unused subscriptions. Count: 0

	(23/09/2015 08:53:54) PASSED : Telerik.Sitefinity.Services.Notifications.Data.OpenAccessNotificationsProvider : Upgrade to 5800 - Removing unused subscription lists. Count: 0

	System is initializing...

view raw App_Status_Page.txt hosted with ❤ by GitHub

Want to learn more?

Increase your Sitefinity skills by signing up for our free trainings. Get Sitefinity-certified at Progress Education Community to boost your credentials.

Get started with Integration Hub | Sitefinity Cloud | Sitefinity SaaS

This free lesson teaches administrators, marketers, and other business professionals how to use the Integration hub service to create automated workflows between Sitefinity and other business systems.

Web Security for Sitefinity Administrators

This free lesson teaches administrators the basics about protecting yor Sitefinity instance and its sites from external threats. Configure HTTPS, SSL, allow lists for trusted sites, and cookie security, among others.

Foundations of Sitefinity ASP.NET Core Development

The free on-demand video course teaches developers how to use Sitefinity .NET Core and leverage its decoupled architecture and new way of coding against the platform.

Was this article helpful?

Yes No

Would you like to submit additional feedback?

Your feedback about this content is important

How helpful is this article?

Very helpful Somewhat helpful Not helpful

How can we improve this article?(Optional)

Fix typos or links

Fix incorrect information

Add or update code samples

Add or update illustrations

Add information about...

Send feedback Cancel

Use custom application status pages