Transform Error "Error occured during row update"

[robertpolickosk]

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

[adiddigi]

No turning off a business rule is not the viable solution. We now need to understand what are the business rules that are being run.

Are you inserting the rows or updating the rows. I don't have access to your instance but if you ask me for the brute force approach is - You can enable the business rule and then start deactivating each of the business rule on the cmdb_ci_computer or cmdb_ci table and narrow down the business rules.

Once you narrow down the business rules, you can post it here and we can analyze it.

[Carol14]

hi, maybe you have some fields which in ServiceNow dictionary that type is "IP Address (Validated IPV4, IPV6)", but in your loading file or your data source, that field's data is not in that type.