insights
2023.4
false
- 发行说明
- 入门指南
- 访问和权限
- 安装和升级
- 与 Insights 交互
- 历史数据导出
- 日志
- 性能和可扩展性
重要 :
请注意此内容已使用机器翻译进行了部分本地化。
![](https://docs.uipath.com/_next/static/media/grid.05ebd128.png?w=3840&%3Bq=100)
Insights
Last updated 2024年9月4日
使用克隆的数据库升级
对于本地部署到云的迁移,需要将 Insights 数据库升级到版本 2023.4。 由于此升级会扰乱您的环境,因此可以考虑克隆数据库并升级克隆的 Insights 数据库 (DB)。
为更加谨慎起见,在以下步骤中,我们将同时克隆 Orchestrator DB 和 Insights DB。
- 检查 Insights 数据库版本 - 您可以通过查看
dbo.__MigrationHistory
表中的最新行来检查 Insights 数据库的版本。 示例:SELECT * FROM [insights].[dbo].[__MigrationHistory] ORDER BY MigrationId DESC;
SELECT * FROM [insights].[dbo].[__MigrationHistory] ORDER BY MigrationId DESC; - 克隆 Orchestrator DB 和 Insights DB - 有多种工具可用于克隆 DB。 例如:
- 数据迁移 Assistant 。
- Microsoft SQL Server Management Studio。
- 对克隆的数据库运行升级命令 - 按照说明升级 Insights 数据库
如何为 Orchestrator PaaS 手动创建/迁移 Insights DB?进行以下调整:
- 在第二步,不应使用 PaaS Orchestrator 安装介质链接,而应使用以下下载内容: https ://download.uipath.com/versions/23.4.3/UiPathOrchestrator.zip
- 在第七步,对于 Orchestrator DB 连接字符串,请使用克隆的 OrchDB 连接字符串。
- 在步骤 9 中,对于 Insights 数据库连接字符串,请使用克隆的 Insights 数据库连接字符串。
PS C:\Users\uipath\Desktop\UiPath.Orchestrator.Cli> .\UiPath.Orchestrator.Cli.exe database upgrade-database -d Insights -c ".\UiPath.Orchestrator.dll.config" --connection-string "Server=localhost;Initial Catalog=insights_clone_1; User Id=uuuuu; Password=ppppp;" Database upgrade started... Database upgrade complete.
PS C:\Users\uipath\Desktop\UiPath.Orchestrator.Cli> .\UiPath.Orchestrator.Cli.exe database upgrade-database -d Insights -c ".\UiPath.Orchestrator.dll.config" --connection-string "Server=localhost;Initial Catalog=insights_clone_1; User Id=uuuuu; Password=ppppp;" Database upgrade started... Database upgrade complete.备注:- 使用克隆数据库的连接字符串可防止污染实际数据库。
- 如果内部发生错误,该命令可能不会将错误回显到终端。 继续执行下面的第四步,以验证数据库是否已成功升级。
- 检查克隆的 Insights 数据库的版本。
SELECT * FROM [insights_clone_1].[dbo].[__MigrationHistory] ORDER BY MigrationId DESC;
SELECT * FROM [insights_clone_1].[dbo].[__MigrationHistory] ORDER BY MigrationId DESC; - 验证每个表中是否存在以下列:
- dbo.作业注意:
Id
列只能包含正数。Id, TenantId, CreationTime, StartTime, EndTime, JobKey, JobSource, EnvName, NULL as OrgUnitCode, OrgUnitName, OrganizationUnitId, ProcessName, DisplayName, OrgUnitFullyQualifiedName, RuntimeType,
Id, TenantId, CreationTime, StartTime, EndTime, JobKey, JobSource, EnvName, NULL as OrgUnitCode, OrgUnitName, OrganizationUnitId, ProcessName, DisplayName, OrgUnitFullyQualifiedName, RuntimeType, - dbo.JobEvents
Id, TenantId, ProcessVersion, RobotName, RobotType, HostMachineName, JobId, TimeStamp, Action, JobState, UserName, RuntimeType,
Id, TenantId, ProcessVersion, RobotName, RobotType, HostMachineName, JobId, TimeStamp, Action, JobState, UserName, RuntimeType, - dbo.QueueItems
Id, TenantId, Priority, QueueName, ProcessingStatus, ReviewStatus, RobotName, RobotType, CreationTime, StartProcessing, EndProcessing, CreatorJobId, ExecutorJobId, SecondsInPreviousAttempts, AncestorId, RetryNumber, DeferDate, DueDate, Progress, SpecificData, AnalyticsData, Output, ProcessingExceptionType, ProcessingExceptionReason, Reference, ReviewerUserName, OrgUnitCode, OrgUnitName, OrganizationUnitId, OrgUnitFullyQualifiedName, ProcessingExceptionDetails,
Id, TenantId, Priority, QueueName, ProcessingStatus, ReviewStatus, RobotName, RobotType, CreationTime, StartProcessing, EndProcessing, CreatorJobId, ExecutorJobId, SecondsInPreviousAttempts, AncestorId, RetryNumber, DeferDate, DueDate, Progress, SpecificData, AnalyticsData, Output, ProcessingExceptionType, ProcessingExceptionReason, Reference, ReviewerUserName, OrgUnitCode, OrgUnitName, OrganizationUnitId, OrgUnitFullyQualifiedName, ProcessingExceptionDetails, - dbo.QueueItemEvents
Id, TenantId, QueueItemId, TimeStamp, Action, UserName, ProcessingStatus, QueueDefinitionId, JobOrgUnitFullyQualifiedName, JobOrganizationUnitId,
Id, TenantId, QueueItemId, TimeStamp, Action, UserName, ProcessingStatus, QueueDefinitionId, JobOrgUnitFullyQualifiedName, JobOrganizationUnitId, - dbo.RobotLogs
Id, TenantId, OrganizationUnitId, TimeStamp, JobKey, MachineId, ProcessName, WindowsIdentity, RobotName, RawMessage, Message, LevelOrdinal,
Id, TenantId, OrganizationUnitId, TimeStamp, JobKey, MachineId, ProcessName, WindowsIdentity, RobotName, RawMessage, Message, LevelOrdinal, - dbo.Tenants注意:租户 ID 必须为正数。
Id, Name, Key
Id, Name, Key
- dbo.作业