MWO Failed Transactions


Userlevel 1
Badge +3

Can someone help me understand why failed transactions occur in the IFS MWO service 10 App? can someone also educate me on how to interpret those failed transactions in layman's terms? how do I drill down to see those failed transactions in IFS Any Input will be appreciated.

Thanks 

Mesh  


6 replies

Userlevel 5
Badge +8

Hi Mesh,

 

Basically failed transaction shows failed data going from mobile app to backoffice. But there are various types of failed transaction and how to manage those failed transactions.

Hope this link will help you to get an idea on that.

 

https://docs.ifs.com/techdocs/Foundation1/040_administration/415_touch_apps/010_administration/070_trouble_shooting/default.htm#Troubleshooting_Failed_Transactions

 

Best regards,
Dakshinie 

Userlevel 1
Badge +3

Hi Dakshinie,

Many thanks for the Article. 

Please can explain to me of how to interpret this kind of failed transactions in a laymen language? in addition what is the meaning of ORA - 2011? etc. 

 

ORA-20111: WorkOrder.FND_RECORD_NOT_EXIST: The Work Order does not exist.

ORA-06512: at "IFSAPP.ERROR_SYS", line 140

ORA-06512: at "IFSAPP.ERROR_SYS", line 366

ORA-06512: at "IFSAPP.WORK_ORDER_API", line 3545

ORA-06512: at "IFSAPP.WORK_ORDER_API", line 3549

ORA-06512: at "IFSAPP.WORK_ORDER_API", line 55

ORA-06512: at "IFSAPP.WORK_ORDER_API", line 60

ORA-06512: at "IFSAPP.MOBILE_WORK_ORDER_API", line 2495

ORA-06512: at "IFSAPP.MOBILE_WORK_ORDER_API", line 2526

ORA-06512: at "IFSAPP.MOBILE_WORK_ORDER_API", line 2531

ORA-06512: at "IFSAPP.MOBILE_WORK_ORDER_API", line 2580

ORA-06512: at "IFSAPP.MOBILE_WORK_ORDER_API", line 2598

ORA-06512: at "IFSAPP.MOBILE_WORK_ORDER_API", line 2604

ORA-06512: at "IFSAPP.MOBILE_WORK_ORDER_API", line 1159

ORA-06512: at "IFSAPP.MOBILE_WORK_ORDER_API", line 1167

ORA-06512: at "IFSAPP.SERVICE_ENG_APP_SVC", line 27655

ORA-06512: at "IFSAPP.SERVICE_ENG_APP_SVC", line 27666

ORA-06512: at "IFSAPP.SERVICE_ENG_APP_SVC", line 27278

ORA-06512: at "IFSAPP.SERVICE_ENG_APP_SVC", line 27295

ORA-06512: at line 2

Userlevel 1
Badge +3

Can someone pleaseexplain to me the meaning of this error message (see attached document) in a layman language? and how to resolve this kind of failed transaction? 

 

Your help and contribution is deeply appreciated! 

Regards,

Mesh

Userlevel 1
Badge +5

@meshfemi is this this happening with all users or just one? There seems to be a missing element with the data causing the issue. This may happen if, the records was removed by the back office, the user profile is missing set-up elements. 

Was there only one line for the failed transactions?

Userlevel 1
Badge +3

@CSheprutterkey, at the moment it happened to one user as you seen in the document. has this kind of thing happen to you or any user you know before? how do you fix this? 

Many thanks for your input very appreciated.  

Regards,

Mesh

Userlevel 3
Badge +7

Hi Mesh,

The best way to start investigating the failed transaction is to check the first failed transaction that a specific user has got. Is this the only failed transaction this user has got? If not, start with them chronologically and try to resolve the first one. 

Failed transactions are usually grouped to a work task ID, which means that once a failed transaction occurs for a specific work task, all other transactions will also get stuck in the Failed Transactions window. However maybe only the first failed transaction is the actual problem and resolving it will resolve the other transactions automatically.

If the first failed transaction is the one you just pasted here, then if you were to check this error stack in the database, you could find where the issue is. In the failed transaction detail window can you see the input variables and let us know what the WO_NO is on this screen for you (example below)?
 


If you can provide the above information, then it might be easier to diagnose what the actual problem. Perhaps you can send us a screenshot of the list of failed transactions as well.

Best Regards,
Ibrahim 

Reply