SQL Queries - CAST Central Base - SQL Queries on Transactions - How to get the list of modified transactions for unchanged objects

Purpose of Query

The purpose of this query is to provide the list of modified transactions on unchanged objects.

Applicable CAST Version

Applicable RDBMS

Query for CSS

To get the list of modified transaction on unchanged objects, install  the attached  stored procedure XXX_TR_REPORT_UNCHANGED_V2.Sql on  CB and run the following:

select XXX_TR_REPORT_UNCHANGED(SNAPSHOTID ) ;

Query result example

“(4956225,30002,EditGeographyPanel,com.att.edge.admin.client.eventrules.defineeventrules.panel.EditGeographyPanel)”
“(4959774,30002,execute,com.att.edge.backend.eventruleengine.EventManagerThreadInvoker.execute)”
“(4959752,30002,run,com.att.edge.backend.messagerouterinterface.MessageRouterSQData.run)”
“(4959775,30002,run,com.att.edge.backend.eventruleengine.EventManagerTestRunNow.run)”
“(4959776,30002,run,com.att.edge.backend.eventruleengine.EventManagerScheduler.run)”
“(4959777,30002,run,com.att.edge.backend.eventruleengine.EventManagerScheduleEditor.run)”
“(4959789,30002,run,com.att.edge.backend.datarouterpublisher.DataRouterDistributorStart.run)”
“(4959862,30002,run,com.att.edge.backend.workorderengine.WorkOrderBanHistory.run)”
“(4959863,30002,run,com.att.edge.backend.workorderengine.RetryWorkRequest.run)”
“(4959865,30002,run,com.att.edge.backend.workorderengine.HandleWorkOrder.run)”
“(4959866,30002,run,com.att.edge.backend.workorderengine.ForceSynchronizationStart.run)”
“(4959867,30002,run,com.att.edge.backend.workorderengine.Event.run)”
“(4959892,30002,run,com.att.edge.backend.rwgdaemonapplication.RWGRoutineWOStatusTracker.run)”
“(4959905,30002,run,com.att.edge.backend.pollingondemand.JobPolling.run)”
“(5681431,30002,run,com.att.edge.backend.handledispatchtimers.ManageDispatchTimers.run)”
“(5858747,30002,run,com.att.edge.backend.eamjobprocessor.EamConfirmReservationsWorkerStart.run)”
“(5990725,30002,run,com.att.edge.backend.messagerouterinterface.MessageRouterSQDataW6Tasks.run)”
“(6072161,30002,run,com.att.edge.backend.kafkarouter.KafkaWorkOrder.run)”
“(6086692,30002,run,com.att.edge.backend.concordrouter.WorkOrderClickTechsPocessor.run)”
“(6031682,30002,scenario/pushPlan/,““S:\Sources\EDGE\Analyzed\javabackend\CPScenarioService\src\main\java\com\att\cp\scenario\controllers
ScenarioDetailsController.java/scenario/PORT/POST/scenario/pushPlan/””)”

Query result interpretation

Query for Oracle

Enter the SQL query

Query result example

Query result interpretation

Query for SQL server

Enter the SQL query

Query result example

Query result interpretation

Notes/comments

Ticket #27533

Related Pages