How to change the status in the Response Tab from R to C (Rejected/Completed)

How to change the status in the Response Tab from R to C

1. First find the mil key for the task

select * from mil;

2. Find the sta key from sta table (R=1 and C=2)

3. Update the RSC Table

update rsc set sta_key = 1 where mil_key = 1300 and rsc_data = 'FAILURE';

Thanks

Table is missing in Form Desginer after editing GTC.

Hi All,

I noticed this few times. While making changes in GTC - say from Full recon to incremental recon - UD_TABLE in form designer is missing in design console and we can see the table in The database.

Solution for this is check the FUG table and check the sdk entry for that table and if it is missing add it.

->select * from fug where sdk_key ='1';  - here whatever your sdk_key is for that table.

-> If not there , Add that entry - It goes out sometime.

-> update fug set fug_rowver= '0000000000000000' where sdk_key='1';

-> Also check for

select unique SDL_CURRENT_VERSION,SDL_LABEL, test.sdl.sdk_key
from test.sdk, test.sdl where sdk.sdk_name = 'UD_TEST' and sdk.sdk_key = sdl.sdk_key;     (Here test. - where test is schema name)

->update ud_test set ud_test_version = 3;

select unique ud_test_version from test.ud_test;

This will update all the users to the new version - ud_test_version.





Thanks