Micro Focus Email

Send E-mail

Self-Solve Knowledge Search

Data stuck in stage tables

Data stuck in stage tables

Data stuck in stage tables

Data stuck in stage tables

This document has not been formally reviewed for accuracy and is provided as is.

B-SL:100 HPSL:100 LIB4:false TYPE:errormsg HPTYPE:technical_documents ATT:0

Summary

Data stuck in stage tables in Vertica database

Problem

No Data in reports despite all streams are up to date.

Cause

In OBR version 10.30 we have issue where data is stuck in stage tables like SR_SM_NODE_RES_ and all others.

Fix

Execute below commands:

shiftmaint

datetimemaint

 

Restart Timer service and check that data is moved slowly to Rate tables ex. SR_SM_NODE_RES

Additional Information

Was this document helpful? Feedback