Appreciations accepted

Vladlen Litvinov, the author: If you have some job offer for me, I'm ready to discuss it. View Vladlen Litvinov's profile on LinkedIn

Password

Thursday, December 13, 2012

Help yourself or the bugtracking in WebSphere products for Dummies (Part 2)

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!
  
 
 
 

2 comments:

  1. 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.

    ReplyDelete
  2. Hi Vladlen,

    Thanks for the useful info.

    ReplyDelete