We executed the query. OOPS!...
I’ts really, we see a lot of empty cells in UCATYPE column.
Let’s check.
Look through our query:
ucat.description as ucaType
+
left outer join bpm_uca_event_type ucat on ucat.uca_event_type_id = uca.uca_event_type_ref
+
lsw_uca uca
=
we need check select uca_event_type_ref from lsw_uca
The same situation. We see a lot of empty cells in UCA_EVENT_TYPE_REF column.
Stage 3. Solving
Our solution is logical.
UPDATE DB2INST1.LSW_UCA LSW_UCA
SET UCA_EVENT_TYPE_REF = 1
WHERE LSW_UCA.UCA_EVENT_TYPE_REF IS NULL
Refresh our browser AND .... BINGO!
I’ts really, we see a lot of empty cells in UCATYPE column.
Let’s check.
Look through our query:
ucat.description as ucaType
+
left outer join bpm_uca_event_type ucat on ucat.uca_event_type_id = uca.uca_event_type_ref
+
lsw_uca uca
=
we need check select uca_event_type_ref from lsw_uca
The same situation. We see a lot of empty cells in UCA_EVENT_TYPE_REF column.
Stage 3. Solving
Our solution is logical.
UPDATE DB2INST1.LSW_UCA LSW_UCA
SET UCA_EVENT_TYPE_REF = 1
WHERE LSW_UCA.UCA_EVENT_TYPE_REF IS NULL
Refresh our browser AND .... BINGO!
Thanks for the post but please bear in mind that direct database manipulations are un-supported in Business Process Management. so, it would be great if you could put a disclaimer in the beginning of the article around this that this is highly unrecommended and unsupported and that end customer could potentially put themselve under risk of no Product support.
ReplyDeleteHi Vladlen,
ReplyDeleteThanks for the useful info.