TimesTen - Cannot Refresh Cache Group (Doc ID 1638149.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.3.0 and later
Information in this document applies to any platform.

Symptoms

Refresh cache group returning the following error:

alter cache group opms.ccg_o_s_stop set autorefresh state paused;
Command> refresh cache group opms.ccg_o_s_stop commit every 1024 rows;
 5056: The cache operation fails: error_type=, error_code=, error_message: ORA-03106: fatal two-task communication protocol error
 5039: An error occurred while refreshing OPMS.CCG_O_S_STOP: Refresh failed (ORA-03106: fatal two-task communication protocol error
)
The command failed.

refresh cache group opms.ccg_o_s_stop commit every 1024 rows;
 5056: The cache operation fails: error_type=, error_code=, error_message: [TimesTen]TT0871: Column ID cannot be set to null
 5039: An error occurred while refreshing OPMS.CCG_O_S_STOP: Refresh failed ([TimesTen]TT0871: Column ID cannot be set to null
The command failed.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms