Applications Systems

Error while executing script- Invalid object name 'APM_ComponentStatus_Hourly' for SolarWinds Platform 2023.3 and below

This article will walkthrough how to resolve the following error: Orion Database FAILED Database configuration failed: • Error while executing script- Invalid object name 'APM_ComponentStatus_Hourly'.

First published date

4/12/2023 10:40 PM

Last published date

2/19/2025 8:36 PM

Overview

When running the configuration wizard, the following error may occur:

Error while executing script- Invalid object name 'APM_ComponentStatus_Hourly'.

Error while executing script- Invalid object name 'APM_ComponentStatus_Hourly.png

Product section

Server Application Monitor

Cause

Known bug on 2023

Resolution

To resolve this issue, please upgrade to SolarWinds Platform 2023.4 and above.  If upgrade is not possible, perform the steps below to workaround the issue:

Please note that these queries contain the GO command that is incompatible with Orion Database Manager and will not work.

Instead, Microsoft SQL Studio Manager will need to be used. 

APM_ComponentStatus_Hourly

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[APM_ComponentStatus_Hourly](
[ID] [bigint] NOT NULL,
[ApplicationID] [int] NOT NULL,
[ComponentID] [bigint] NOT NULL,
[Availability] [int] NOT NULL,
[PercentAvailability] [float] NOT NULL,
[TimeStamp] [datetime] NOT NULL,
[RecordCount] [bigint] NOT NULL,
CONSTRAINT [PK_APM_ComponentStatus_Hourly] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
 

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.


APM_ComponentStatus_Daily

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[APM_ComponentStatus_Daily](
[ID] [bigint] NOT NULL,
[ApplicationID] [int] NOT NULL,
[ComponentID] [bigint] NOT NULL,
[Availability] [int] NOT NULL,
[PercentAvailability] [float] NOT NULL,
[TimeStamp] [datetime] NOT NULL,
[RecordCount] [bigint] NOT NULL,
CONSTRAINT [PK_APM_ComponentStatus_Daily] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
 

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.