Transform Error "Error occured during row update"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-13-2015 05:39 AM
Fellow Developers/Admins,
On two different Transform Maps I am getting errors where the only message is "Error occured during row update." Both Transform Maps have a Target Table of Computer (cmdb_ci_computer). On one of the Tranform maps it does this will all rows it tries to update. On the other, it only does it when the import rows are from a specific LDAP Data Source. It runs without errors on the other four LDAP Data Sources that use the same Import Table and Transform Map. My issue is that I have no idea how to debug an error with no usable error message. I have tried putting as much logging in the various Transform Scripts and Field Scripts as I can but none has led to an indication of where the error is. Has anyone else seen this error and been able to identify the source?
Thank you in advance for your time and consideration.
Robert Polickoski
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-13-2015 02:53 PM
I am thinking if you have "run business rules" checked there is something wrong with one of the business rules that's causing the issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-14-2015 05:48 AM
Dear Abhiram,
Thank you. I turned off Run Business Rules and the error no longer occurs. However, I still do not know what the actual error is to be able to address it. And I am not sure that just turning of Run Business Rules is a viable solution. This seems to be a significant shortcoming in the error-trapping system in ServiceNow.
Respectfully,
Robert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-14-2015 05:54 AM
Hello Robert,
Turn on business rule debugging, keep "run business rules" checked, run the transform map to find out the exact error.
May be at the time of import, it was conflicting any of the business rule condition, configured on the target table.
Thanks,
Subhankar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-14-2015 12:55 PM
Dear Subhankar,
Thank you. Unfortunately, there is no debug output from Debug Business Rules during the Transform.
Respectfully,
Robert