Hi,
I am getting the below error when I try to open a record in a User business class. Is there any way to track which field is causing this error?
Take the exception ID that you redacted and go to Administration Console > Other > Exception Log Inquiry and see if the system can find a detailed stack trace. That sometimes will point you to a specific line in the LPL where that field was being accessed and by looking at that line you could know.
The exception log doesn't provide which specific field or line in the business class is throwing this exception (when I open or click on next/previous actions). This UBC has many records, however the exception is occurring only for specific records, I don't see any issue with the data.
If it only happens on certain records when you go prev/next through your result set I'd suggest taking these steps:
1. Find a record that triggers the error.
2. Edit the UI form in config console and iteratively comment out one field at a time and retest.
3. When you find that the form renders for a previously problematic record you'll know that the field you just commented out is the one triggering the exception.
Based on the fact that it is trying to convert a string to a number, I'd focus on the fields in your UBC that are Numeric or Decimal or Integer first.
The issue seems to be with the Sets that we created on the BC. The Set has a couple of Alpha fields and a date field (which can be left blank while creating a record). After commenting/removing the date field from the set, the exception is gone. It seems to be happening only for the records with blank date.
Thank you so much for your prompt replies.