This page guides you to check whether the transaction is invalid because of a large SCC group, for more information about SCC refer to Transaction Configuration Center - Information - Definition and impacts of the large Strongly Connected Component
Official documentation
- CAST AIP 8.3 : TCC - CAST Transaction Configuration Center
- CAST AIP 8.2 : TCC - CAST Transaction Configuration Center
- CAST AIP 8.1 : TCC - CAST Transaction Configuration Center
- CAST AIP 8.0 : TCC - CAST Transaction Configuration Center
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
Get the content of the largest SCC, for this refer to Transaction Configuration Center - Information - How to get the content of the large SCC
Check if the transactions are part of the transactions having an element which ends up to the SCC group so the transaction is not completely discovered by TCC
Get all the callers of SCC Group:
create temporary table tmp_caller_scc ( object_id int ) ; truncate table tmp_caller_scc; insert into tmp_caller_scc(object_id) select distinct a.CALLER_ID from CTV_LINKS a join FP_LargestSCC scc on a.CALLER_ID = scc.object_id where not exists ( select 1 from FP_LargestSCC where a.CALLED_ID = object_id );
Get all the details such as childtype=0 calling these:
create temporary table tmp_detail ( object_id int , child_id int ) ; insert into tmp_detail ( object_id, child_id ) select distinct d.object_id , d.child_id from dss_transactiondetails d join dss_keysextra t on t.object_id = d.object_id join CTV_LINKS a on a.CALLER_ID = d.child_id join tmp_caller_scc b on b.object_id = a.CALLED_ID where d.childtype = 0 ;
Get the transactions:
select * from tmp_detail d join dss_transaction t on t.object_id = d.object_id join dss_keysextra k on k.object_id = t.object_id join cdt_objects n on n.object_id = t.form_id order by 2 ;
In our example the result is as follows
If you find transactions in this list, it explains why transaction is incomplete in TCC