Solved

Streams notice for Error Message

  • 12 October 2020
  • 2 replies
  • 522 views

Userlevel 6
Badge +17

Hello, 

I’m looking to see if it is possible to generate a Streams notice when an IFS Error Message occurs. Specifically, I’m looking to build an alert for the Insufficient material error message when attempting to Ship WIP to a Supplier. Any help would be greatly appreciated. Thank you.

 

icon

Best answer by ShawnBerk 13 October 2020, 01:42

View original

2 replies

Userlevel 7
Badge +28

Yes, this should be doable with a combination of these Event Actions to get the triggered notification directly into a stream

 

https://community.ifs.com/technology-infrastructure-cloud-integration-dev-tools-50/event-with-stream-action-942

 

https://community.ifs.com/technology-infrastructure-cloud-integration-dev-tools-50/apps9-does-anyone-have-any-events-running-on-background-jobs-to-notifiy-if-one-finishes-in-warning-or-error-state-4068

 

The second post is a little different in that it is around a background job error, but the concept should be similar. You just have to trace out using the debug tool how the message box is triggered and try to trigger the action associated with that event.  I would think it possible with a custom event.  

Userlevel 6
Badge +17

Hi @sawantrahul I did find the debug error/security check. However, reading the linked articles, I’m not sure how to go about actually building the Streams event when this error message triggers. 

The error from debug is below. I'm not sure which Logical Unit I would use. I’ve tried looking for ShopOrderOperation and SecurityCheckpoint, but I’m not seeing which table to connect to and configure. 

 

Start Time: 11:05:48 AM,527
Category : Server Invoke[PL/SQL Command]
Sub Category : Error exception!
Info : BEGIN 
&AO.SHOP_ORDER_OPERATION_API.Report_Ship_Wip_To_Suppl(:p0 ,:p1 ,:p2 ,:p3 ,:p4 ,:p5 ); 
commit; 
EXCEPTION 
WHEN &AO.Error_SYS.Err_Security_Checkpoint THEN 
raise; 
WHEN OTHERS THEN 
rollback; 
raise; 
END;
Thread : 0x0011 - IFS Application Explorer Form Thread
Requested URL : https://servername.domain.com:49080/main/default/plsqlgateway/AccessPlsql/Invoke?dlgShipWipToSupplier
Redirected URL : 
Request Id : 87add8f7-b1e2-4f27-9f36-e5374cc4a027
Duration (ms): 212
DB Statements Executed : 4
DB Rows Fetched : 0
External Calls : -1
GZip Acc/Req/Resp : 1/1/1
Bytes Sent : 1561
Bytes Sent Compressed : 786
Bytes Sent Compression Ratio : 50%
Bytes Received : 66730
Buffer Parsing (ms) : 0
Record Parsing (ms) : 
Exception : ORA-20110: Insufficient material. Issuing could not be done for the part

Reply