环境：A8-V5
情况描述：由于致远服务到期，表单数据已经在数据库表里手动删除，但是仍然挂起，看着很不舒服，详见下图：
解决：涉及表ctp_affair
select * from ctp_affair where subject like '差旅费报销单 （SAP接口）(休闲海 2016-03-11 11:13)' for update
修改state状态为4即可。
-- Create table
create table CTP_AFFAIR
(
id INTEGER not null,
is_cover_time NUMBER(4),
member_id INTEGER,
sender_id INTEGER,
subject VARCHAR2(1024),
app NUMBER(4),
object_id INTEGER,
sub_object_id INTEGER,
state NUMBER(4),
sub_state NUMBER(4),
hasten_times NUMBER(4),
remind_date INTEGER,
deadline_date INTEGER,
can_due_remind NUMBER(4),
create_date DATE,
receive_time DATE,
complete_time DATE,
remind_interval NUMBER(4),
is_delete NUMBER(4),
track NUMBER(4),
archive_id INTEGER,
addition VARCHAR2(2000),
ext_props VARCHAR2(2000),
update_date DATE,
is_finish NUMBER(4),
body_type VARCHAR2(255),
important_level NUMBER(4),
resent_time NUMBER(4),
forward_member VARCHAR2(255),
identifier VARCHAR2(255),
transactor_id INTEGER,
node_policy VARCHAR2(255),
activity_id INTEGER,
form_app_id INTEGER,
form_id INTEGER,
form_operation_id INTEGER,
templete_id INTEGER,
from_id INTEGER,
over_worktime INTEGER,
run_worktime INTEGER,
over_time INTEGER,
run_time INTEGER,
deal_term_type NUMBER(4),
deal_term_userid INTEGER,
sub_app NUMBER(4),
expected_process_time DATE,
org_account_id INTEGER,
process_id VARCHAR2(255),
is_process_over_time NUMBER(4),
form_multi_operation_id VARCHAR2(4000),
back_from_id INTEGER,
form_relative_static_ids VARCHAR2(255),
form_relative_query_ids VARCHAR2(255),
has_favorite NUMBER(4),
from_type NUMBER(4),
form_recordid INTEGER,
case_id INTEGER,
relation_data_id INTEGER,
firstview_period INTEGER,
firstview_date DATE,
firstresponse_period INTEGER,
signleview_period INTEGER,
pre_approver INTEGER,
auto_run NUMBER(4),
summary_state NUMBER(4)
)
tablespace V3XSPACE
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Create/Recreate indexes
create index IDX_AFFAIR_APP on CTP_AFFAIR (APP)
tablespace V3XSPACE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
create index IDX_AFFAIR_CREATE_DATE on CTP_AFFAIR (CREATE_DATE)
tablespace V3XSPACE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
create index IDX_AFFAIR_RECEIEVE_TIM on CTP_AFFAIR (RECEIVE_TIME)
tablespace V3XSPACE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
create index IDX_AFFAIR_STATE on CTP_AFFAIR (STATE)
tablespace V3XSPACE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
create index IDX_AFFAIR_SUB_STATE on CTP_AFFAIR (SUB_STATE)
tablespace V3XSPACE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
create index IDX_AFFAIR_TRACK on CTP_AFFAIR (TRACK)
tablespace V3XSPACE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
create index IDX_AFFAIR_TT1 on CTP_AFFAIR (MEMBER_ID, STATE, APP, IS_DELETE, ARCHIVE_ID, OBJECT_ID)
tablespace V3XSPACE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
create index IDX_AFFAIR_TT2 on CTP_AFFAIR (MEMBER_ID, STATE, TRACK, IS_DELETE, IS_FINISH)
tablespace V3XSPACE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
create index IDX_AFF_TEM_ID on CTP_AFFAIR (TEMPLETE_ID)
tablespace V3XSPACE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
create index IDX_CTP_AFFAIR_ACTID on CTP_AFFAIR (ACTIVITY_ID)
tablespace V3XSPACE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
create index IDX_CTP_AFFAIR_SUB_APP on CTP_AFFAIR (SUB_APP)
tablespace V3XSPACE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
create index IDX_CTP_AFFAIR_TEMP_1 on CTP_AFFAIR (IS_DELETE, STATE, APP, SUB_APP)
tablespace V3XSPACE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
create index IDX_CTP_AFFAIR_WSLIST on CTP_AFFAIR (MEMBER_ID, STATE, APP, IS_DELETE)
tablespace V3XSPACE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
create index IDX_REF_A_O on CTP_AFFAIR (OBJECT_ID)
tablespace V3XSPACE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
create index IDX_REF_A_S on CTP_AFFAIR (SUB_OBJECT_ID)
tablespace V3XSPACE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
create index IDX_TT1 on CTP_AFFAIR (MEMBER_ID, STATE, APP, SENDER_ID, IS_DELETE, CREATE_DATE)
tablespace V3XSPACE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
create index IDX_TT2 on CTP_AFFAIR (MEMBER_ID, APP, SENDER_ID, CREATE_DATE)
tablespace V3XSPACE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table CTP_AFFAIR
add constraint PK_CTP_AFFAIR primary key (ID)
using index
tablespace V3XSPACE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);