The CreatorCon Call for Content is officially open! Get started here.

Transform Error "Error occured during row update"

robertpolickosk
Mega Expert

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

6 REPLIES 6

adiddigi
Tera Guru

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.


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


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


Dear Subhankar,



Thank you.   Unfortunately, there is no debug output from Debug Business Rules during the Transform.



Respectfully,


Robert