http://localhost:8080/records/component/diagnostics
installed services:
Record Dashboard:
Find all RQM queue:
select r_object_id, message, sign_off_user, sign_off_date from dmi_queue_item where name=’rqm_queue’
Useful DQL:
To get details on the queue, use the following query.
DQL> select r_object_id, message, sign_off_user, sign_off_date from dmi_queue_item where name=’rqm_queue’
The format of the message is:
profile_id=”0800a9b580007577″ -render=”true” -arg_object_id=”0800a9b5800082cd”
the arg_object_id will be the ID of the work order that was queued.
Below DQL can be run to get the information about the workorder profile:
DQL> select * from dm_media_profile where object_name=’workorder_process’
The other query (based on the work order would be)
DQL> select r_object_id, object_name, master_workorder_id from dmc_rps_work_order where processing_status = ‘ROUTED’
Find all active work orders:
Select r_object_id, object_name, master_workorder_id, processing_status from dmc_rps_work_order where processing_status != ‘COMPLETED’
sql: select all dmc_rps_work_order.r_object_id, dmc_rps_work_order.object_name, dmc_rps_work_order.master_workorder_id, dmc_rps_work_order.processing_status from dmc_rps_work_order_sp dmc_rps_work_order where ((dmc_rps_work_order.processing_status!=N’COMPLETED’)) and (dmc_rps_work_order.i_has_folder = 1 and dmc_rps_work_order.i_is_deleted = 0) 199 Fetched 40 with batch hint 50 199 Commit
Dump of running workorder:
API>dump,c,0802718396a09465
…
USER ATTRIBUTES
object_name : 08027183966a2323
title :
subject :
authors []:
keywords []:
resolution_label :
owner_name : DMADMIN
owner_permit : 7
group_name : docu
group_permit : 1
world_permit : 1
log_entry :
acl_domain : docdbowner
acl_name : dmc_rps_work_order_acl
language_code :
parent_id : 0802718396a0941f
start_process_time : 10/23/2024 10:12:35 AM
last_update_time : 10/23/2024 10:13:40 AM
number_items_to_process : 1000
number_items_processed : 750
number_items_successful : 750
number_items_failed : 0
number_child_wo_created : 0
number_child_wo_processed : 0
number_items_skipped : 0
master_workorder_id : 0802718396a0941f
processing_status : RUNNING
completion_status : PROCESSING
is_complete : F
is_terminated : F
number_items_actioned : 0
operation_name : EVALUATE_RETENTION_DATE
number_items_warned : 0
run_count : 2
all_children_successful : T
start_time : 10/23/2024 9:30:52 AM
route_time : 10/23/2024 9:30:59 AM
wait_time : nulldate
return_time : nulldate
end_time : nulldate
route_duration : 0
process_duration : 0
wait_duration : 0
processor_host : LVDMSPRDRPS01.lockheedfcu.local
partitioning_status : PARTITIONING_NOT_REQUIRED
SYSTEM ATTRIBUTES
r_object_type : dmc_rps_part_work_order
r_creation_date : 10/23/2024 9:30:52 AM
r_modify_date : 10/23/2024 10:13:40 AM
r_modifier : DMADMIN
r_access_date : 10/23/2024 10:13:13 AM
r_composite_id []:
r_composite_label []:
r_component_label []:
r_order_no []:
r_link_cnt : 0
r_link_high_cnt : 0
r_assembled_from_id : 0000000000000000
r_frzn_assembly_cnt : 0
r_has_frzn_assembly : F
r_is_virtual_doc : 0
r_page_cnt : 2
r_content_size : 98518
r_lock_owner :
r_lock_date : nulldate
r_lock_machine :
r_version_label [0]: 3.0
[1]: CURRENT
r_immutable_flag : F
r_frozen_flag : F
r_has_events : F
r_creator_name : DMADMIN
r_is_public : F
r_policy_id : 0000000000000000
r_resume_state : 0
r_current_state : 0
r_alias_set_id : 0000000000000000
r_full_content_size : 98518
r_aspect_name []:
r_object_id : 0802718396a09465
APPLICATION ATTRIBUTES
a_application_type :
a_status :
a_is_hidden : F
a_retention_date : nulldate
a_archive : F
a_compound_architecture :
a_link_resolved : F
a_content_type : xml
a_full_text : T
a_storage_type : filestorex_13
a_special_app :
a_effective_date []:
a_expiration_date []:
a_publish_formats []:
a_effective_label []:
a_effective_flag []:
a_category :
a_is_template : F
a_controlling_app :
a_extended_properties []:
a_is_signed : F
a_last_review_date : nulldate
INTERNAL ATTRIBUTES
i_is_deleted : F
i_reference_cnt : 1
i_has_folder : T
i_folder_id [0]: 0b02718396a09420
i_contents_id : 0602718399f87f1d
i_cabinet_id : 0c02718380000106
i_antecedent_id : 080271839670542b
i_chronicle_id : 08027183966a2323
i_latest_flag : T
i_branch_cnt : 0
i_direct_dsc : F
i_is_reference : F
i_retain_until : nulldate
i_retainer_id []:
i_partition : 0
i_is_replica : F
i_vstamp : 7
RPS Tracing:
API> apply,c,NULL,SET_OPTIONS,OPTION,S,sqltrace,VALUE,B,T
API> apply,c,NULL,SET_OPTIONS,OPTION,S,rpctrace,VALUE,B,T
API> apply,c,NULL,SET_OPTIONS,OPTION,S,ticket_trace,VALUE,B,T
API> apply,c,NULL,SET_OPTIONS,OPTION,S,trace_authentication,VALUE,B,T
API> apply,c,NULL,SET_OPTIONS,OPTION,S,trace_complete_launch,VALUE,B,T
API> apply,c,NULL,SET_OPTIONS,OPTION,S,trace_workflow_agent,VALUE,B,T
API> apply,c,NULL,SET_OPTIONS,OPTION,S,file_store_trace,VALUE,B,T
API> apply,c,NULL,SET_OPTIONS,OPTION,S,trace_http_post,VALUE,B,T
API> apply,c,NULL,SET_OPTIONS,OPTION,S,acs_connector_trace,VALUE,B,T
dfc.tracing.enable=true
dfc.tracing.verbose=true
dfc.tracing.include_rpcs=true
dfc.tracing.max_stack_depth = 20
dfc.tracing.timing_style=date
dfc.tracing.mode=standard
dfc.tracing.date_format=yyyy-MM-dd hh:mm:ss.SSS
dfc.tracing.include_session_id = true
dfc.tracing.max_backup_index = 30
dfc.tracing.file_prefix = DFCTrace
dfc.tracing.log.level = DEBUG
dfc.tracing.print_exception_stack = true
dfc.tracing.dir=/opt/tomcat/webapps/da/logs