RiskFabric Processing job immediately fails
Article ID: 251863
Updated On:
Products
Issue/Introduction
The RiskFabric Processing job fails almost immediately after starting and logs the following error in the SQL Server Agent job history:
Previous Nightly job Staging is still running [SQLSTATE 42000](Error 50000). The step failed.
The failing job step is Check for Upgrade or previous nightly jobs running.
Environment
Release : 6.x
Cause
The previous nightly job has not completed, or the RiskFabric Intraday Processing job is running. This can be due to the job hanging or running longer than expected. Refer to the following KB articles to investigate potential causes of the job hanging or running longer than expected:
- Run Loading Procedures job step runs long or hangs without failing (Article ID: 248828)
- RiskFabric Processing job hangs during step Update LDW_Core (Article ID: 216912)
- RiskFabric Processing step Update LDW Core runs slowly after upgrading from 6.5.2.x (Article ID: 203981)
- After upgrading SQL Server 2016 SP2 to CU7 or later, RiskFabric Processing hangs during cube processing (Article ID: 175826)
- RiskFabric Intraday Processing job durations increase every other run (Article ID: 239844)
Note that an under-resourced ICA deployment (relative to the volume of incidents processed) will perform slowly and may be susceptible to environmental issues that degrade or interrupt processing. Environmental factors can include but are not limited to any of the following:
- Host OS instability
- Multiple databases running on the same server as the RiskFabric database, regardless of their distribution across SQL Server instances (i.e., running in the default or named instances)
- Resource contention (e.g., disk I/O, memory consumption, etc.)
- Network bandwidth between the SQL Server host and data sources, or between SQL Server and the SQL Server Analysis Services (SSAS) host
Resolution
Refer to the following KB articles for guidance on investigating and improving processing performance:
- RiskFabric processing performance factors (Article ID: 238796)
- How to improve performance of SQL Server for ICA (Article ID: 172261)
For ICA's resource and topology requirements and recommendations, refer to the following sections of the Symantec Information Centric Analytics Administrator Guide:
Feedback
