Demantra Quiries

QUIRIES
++++++++++++++++++++++
select * from version_details_history order by upgrade_date desc;
select * from xxdem.sys_params order by pname;
select * from db_exception_log order by err_date desc;
Select * from dba_network_acls;
select * from version_details_history order by upgrade_date
select * from user_id where user_NAME like '%********%';'
select * from WF_EVENT_SUBSCRIPTIONS where rule_function = 'MSD_DEM_EVENT.USER_CHANGE' ;
select pname, pval from sys_params where pname='AppServerURL'
select wf_event_subscriptions.licensed_flag where rule_function = 'MSD_DEM_EVENT.USER_CHANGE';
select * from wf_events where name = 'oracle.apps.fnd.wf.ds.userRole.created';
select * from wf_event_subscriptions where event_filter_guid = (select guid from wf_events where name = 'oracle.apps.fnd.wf.ds.userRole.created');
select * from WF_EVENT_SUBSCRIPTIONS
where rule_function = 'MSD_DEM_EVENT.USER_CHANGE' ;
select * from xxdem.db_exception_log where err_date > sysdate -3 order by err_date desc
select * from xxdem.sys_params order by pname
select * from xxdem.init_params_0 order by pname
select * from xxdem.init_params_1 order by pname
select * from xxdem.wf_schemas
select * from xxdem.wf_process_log order by record_updated desc

TO CHECK ENGINE STATUS 

++++++++++++++++++++++++

set lines 300

SET PAGES 99

col STEP_ID for a8;

col USER_ID for a8;

col USER_NAME for a9;

col SCHEMA_NAME for a35;

col WF_STATUS for a9;

SELECT                  u.user_id,

u.user_name,

w.schema_id,

wf.schema_name,

w.process_id,

decode(w.status,-3,'ENDLESS_LOOP',-2,'FAILED',-1,'TERMINATED',0,'COMPLETED',1,'RUNNING',2,'PAUSED',w.status) wf_status,

w.step_id,

TO_CHAR(w.record_updated, 'MM/DD/YYYY') Run_Date,

TO_CHAR(w.record_updated, 'MM/DD/YYYY HH24:MI:SS') AS "Record Updated",

TO_CHAR(w.record_created, 'MM/DD/YYYY HH24:MI:SS') AS "Record_Created",

TO_CHAR(sysdate,'MM/DD/YYYY HH24:MI:SS') as "Current_Time",

(w.record_updated - w.record_created) * 24 Time_Taken_In_Hrs

FROM Demantra.wf_process_log w,

Demantra.wf_schemas wf,

Demantra.user_id u

WHERE w.schema_id = wf.schema_id

and w.initiator = u.user_id

--   and  w.schema_id = 2102

--  and w.status > 0

order by w.record_created desc;

to check the queues
+++++++++++++++++++++++
select *
from user_objects
where (object_name like 'DEM\_%\_IN%' ESCAPE '\' or object_name like
'ENG\_%\_IN%' ESCAPE '\')
or (object_name like 'DEM\_%\_OUT%' ESCAPE '\' or object_name like
'ENG\_%\_OUT%' ESCAPE '\')
and object_type in ('RULE SET','QUEUE','TABLE')

FSCT ENGINE
+++++++++++++++++
http://<HOSTNAME>:<PORT>/demantra/workflow/login.jsp
http://<HOSTNAME>:<PORT>/engineManager/
http://<HOSTNAME>:<PORT>/engineManager/EngineManagerStarterServlet?command=diag
http://<HOSTNAME>:<PORT>/engineManager/EngineManagerStarterServlet?command=status
http://<HOSTNAME>:<PORT>/engineManager/EngineManagerStarterServlet?command=start&mode=1&profile_id=1

Demantra Anywhere Console URL

+++++++++++++++++++++++++++

http://alpc4khkapf1.ae.ge.com:7003/demantra/portal/anywhereConsole.jsp

Demantra Engine URL's

++++++++++++++++++++

http://<Demantra hostname>:7003/demantra/workflow/login.jsp

http://<Demantra hostname>:7001/engineManager/

http://<Demantra hostname>:7001/engineManager/EngineManagerStarterServlet?command=diag 

http://<Demantra hostname>:7001/engineManager/EngineManagerStarterServlet?command=status 

http://<Demantra hostname>:7001/engineManager/EngineManagerStarterServlet?command=start&mode=1&profile_id=1

Demantra URL's

+++++++++++++++++

http://<demantra servername>:7003/demantra/portal/loginpage.jsp

http://<demantra servername>:7003/demantra/workflow/login.jsp

http://<demantra servername>:7003/demantra/portal/userManagement.jsp

http://<demantra servername>:7003/demantra/admin/adminManagement.jsp