About 1.5 million messages are processed every day.
This phenomenon only occurs during peak business periods and is more normal during business downturns.
Does this mean that some configuration adjustments to the router are needed to improve its processing power?

HisEmrRouter's number of job: 10

ADT RoutingRule number of job: 5

Tks

About 1.5 million messages are processed every day.
This phenomenon only occurs during peak business periods and is more normal during business downturns.
Does this mean that some configuration adjustments to the router are needed to improve its processing power?

HisEmrRouter's number of job: 10

ADT RoutingRule number of job: 5

Tks

as above shown, transform is empty . no other function

Tks.

Tks ,It worked,

Maybe you are right. So what's the limit of iris community?

Tks

Yes, I did it in System Management portal, How to find the sql query process? 

I need pick bussiness field from message body on more high level , I don't want to modify every process logic.

And if the business service is builtIn process not custom process.  for example:

EnsLib.HL7.Service.TCPService -> EnsLib.HL7.Operation.TCPOperation

above flow will insert hl7 request and response to table EnsLib_HL7.Message and other message tables. 

I want to get message body to parse it before insert.

But The EnsLib.HL7.Service.TCPService   and EnsLib.HL7.Operation.TCPOperation is builtIn .

So I think ensembe is provide some hook like before and after

EnsLib.HL7.Service.TCPService ->before hook ->sendSync->After hook-> EnsLib.HL7.Operation.TCPOperation

Thank You.

Thank You, I will check .

I tryed ROW_NUMBER() ,got follow error:

Mistake in SQL statement, ERROR #5540: SQLCODE: -359 Message: User defined SQL function 'SQLUSER.ROW_NUMBER' does not exist

The problem is not what I use either ROW_NUMBER() or ROW_NUM fake field.

The point is the flow .Cache first find ROW_NUMBER() in self platform but platform not contain oracle function.

Or is it platform's limit?  I don't know where is the border..

Thank You,

It's a choice, but not the best solution. 

Because on  view the problem still existed.  So I need modify old view. 

Does have any other options?

Thank You .

Thank You, My database is oracle 11g

It use ROWNUM as paging condition ,like this 

select * from order_info where ROWNUM <=3 

But above query can't execute because follow error in ensemble sql console

Not found ROWNUM field in  table order_info

ROWNUM is a fake field for oracle like %VID in Caché  

seems like the query external datase's flow  is Caché  parse -> sql gateway, It cause above problem.