TriniDBA

Problem:

After running the SYSAUDIT report, the following error appears under Integration Broker Audits:

(IBRK-05): Service Operation with missing service:
Service Operation Service
 - ---------------- -------
 PV_ORDER_XCBL3 PV_ORDER_XCBL3
 1 Total Rows

Solution:

1. Check the “Data Management” PeopleBook, under the “Ensuring Data Integrity” section for information on resolving Integration Broker errors.

2. Check the Service Operations (PSOPERATION) and Service’s (PSSERVICE) tables in the fsdmo and fsdev databases.

select * from PSOPERATION where IB_SERVICENAME like 'PV_ORDER%'
select * from PSSERVICE where IB_SERVICENAME like 'PV_ORDER%'

Note that PV_ORDER_XCBL3 appears in the PSOPERATION table in fsdev, but not in the PSSERVICE table. Note also that PV_ORDER_XCBL3 appears only in fsdev, but not in fsdmo.

Therefore, backup the row containing PV_ORDER_XCBL3 and then delete the row from the PSOPERATION table in the fsdev instance:

select * from PSOPERATION where IB_SERVICENAME = 'PV_ORDER_XCBL3'
delete from PSOPERATION where IB_SERVICENAME = 'PV_ORDER_XCBL3'

3. Deleting the record introduced an IBRK-06 error on the SYSAUDIT report. To restore the data that was deleted:

insert into PSOPERATION
 (IB_OPERATIONNAME, VERSION, DEFAULTVER, RTNGTYPE, IB_USERPWDREQ, IB_SERVICENAME, IB_ALIASNAME, LASTUPDDTTM, 
LASTUPDOPRID, OBJECTOWNERID, DESCR, DESCRLONG)
 values
 ('PV_ORDER_XCBL3', 1, 'VERSION_1', 'A', 'N', 'PV_ORDER_XCBL3', '', '2008-12-11 16:47:00.000', 'SVP1', 
'DPV', 'xCBL Order', NULL)

4. In PIA, navigate to Integration Broker > Service Utilities > Service Administration. Click the Service Operations tab. Expand Delete and in the Service Operation field, enter PV_ORDER_XCBL3. Check Select, and then click Delete.

Under Results, ‘Successful delete’ appears.

After rerunning SYSAUDIT, the exception no longer appears.