Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Batch size parameter for NmsBroadLogRcp

Klaster
Level 2
Level 2

Hi,

 

I have found that table NmsBroadLogRcp is updated in batches 

For ex. like

UPDATE NmsBroadLogRcp SET iStatus=:1, iMsgId=:2, tsEvent=:3, tsLastModified=cast(SYSTIMESTAMP as TIMESTAMP WITH TIME ZONE) WHERE iDeliveryId=:4 AND iStatus=:5 AND ROWNUM<=5000

 

I'm looking for solution how to manage batch size to avoid too many loops.

Those value is any defined parameter ?

 

Thanks in advance

1 Accepted Solution
Adhiyan
Correct answer by
Employee
Employee

Hi Klaster,

 

Are you using mid-sourcing to send deliveries. If yes , there should be an option called NmsMidSourcing_LogsBatchSize

which can be changed to manage size of batch per SOAP call.

 

Regards,
Adhiyan

View solution in original post

1 Reply
Adhiyan
Correct answer by
Employee
Employee

Hi Klaster,

 

Are you using mid-sourcing to send deliveries. If yes , there should be an option called NmsMidSourcing_LogsBatchSize

which can be changed to manage size of batch per SOAP call.

 

Regards,
Adhiyan

View solution in original post