SQL Tracing to troubleshoot E0025 result code

E0025 Result Code means processing cannot be completed and tracking down the reason can be complicated. One way to troubleshoot is performing a SQL trace. 

• Clear the claim with the E0025
• Launch SQL Server Management Studio (SSMS)
• Navigate to Tools > SQL Server Profiler
• Connect to the SQL instance where the qc_core database is located
• On the Event Selection tab, select the Show All Columns checkbox 
• Select the Column Filters button
  • Select the DatabaseName filter
  • Expand the '+" next to 'Like'
  • Enter the qc_core database name 
  • Select the OK button
• Select the Run button
• Navigate back to QC and adjudicate the claim
• After the claim has been adjudicated and the E0025 applied, go back to the SQL trace and click on Stop.
• In the SQL trace results, press CTRL+F on your keyboard to bring up the find form. 
• Enter "ERR_" in the Find What text field and select TextData in the Search in Column dropdown. 

• Select the Find Next button. If no results are found, select the Find Previous button instead. 

At this point in the trace is where the E0025 error occurred. You can use the preceding entries in the SQL Trace and work with the queries in SQL to try and find the cause of the E0025 including previous data you’ve already accumulated in the troubleshooting process.