question Transform Map Isn't Transforming in ServiceNow AI Platform forum

Transform Map Isn't Transforming

johnfeist — Mon, 02 May 2022 22:15:18 GMT

I have a very simple data source that is populated via JDBC from one of my SQL Server databases. The data are two elements, employee number and cost center. I've built a transform map to load the updates into sys_user. Here's what that map looks like

When I run the transform, noting seems to be happening. It shows successful completion but the logs show no inserts, changes, errors, skips etc.

I wrote a little script, separate from the transform map, that just grabs the data from the import set and iterates through looking for matching employee numbers. That script shows that if finds all twenty employee numbers with some cost centers matching source = target and some not. After the map "runs" thee are no changes.

I know this must be something simple that I'm missing so if anyone can tell me what that is I'll be most grateful to get this done.

:{)

Re: Transform Map Isn't Transforming

Allen Andreas — Mon, 02 May 2022 22:20:07 GMT

Hello,

Have you verified the contents on the import set table to see if there is data actually there?
Can you open those records and see if there's data actually there?
Can you give more information as far as where you're running your script that is giving you some insight?
Have you checked your system logs for any information?
Have you verified this transform map is the one actually associated with the data source/import table?

Please mark reply as Helpful/Correct, if applicable. Thanks!

Re: Transform Map Isn't Transforming

johnfeist — Tue, 03 May 2022 13:16:18 GMT

Hi Allen,

To answer your questions:

Yes, I've brought the table up in list view and the values are there. I've also accessed those same data via script.
Yes, clicking from list view the data are there.
It's a simple script, defines a GlideRecord on u_get_cost_centers. From there it queries the table and gets a Row Count which matches the number of records imported (test 20). Then is just iterates through the GlideRecord looking for matching employee_number records in sys_user displaying the result via gs.print.
The various logs show nothing more.
Yes, the source table on the form shows u_get_cost_centers.

I'm most interested as to what it is that I'm doing wrong so I'll appreciate any insights you can provide.

:{)

Re: Transform Map Isn't Transforming

Allen Andreas — Tue, 03 May 2022 13:36:50 GMT

Hi,

Can you remove the check for the 'Run Business Rules' checkbox. Unless you have a direct need to run business rules on that the target table for this update, it's not recommended to have that checkbox checked as it's extra processing that may not be needed. With that said, there could be something causing those updates to not push due to some downstream BR process.

Outside of that, I understand you're interested in what you're doing wrong, that's what we're here to discuss 🙂 -- I'm just asking some initial question to get a better understand of what is going on and what you have or have not tried thus far.

So when you're saying:

"It shows successful completion but the logs show no inserts, changes, errors, skips etc."

You mean in the System Import Sets > Transform History it's not showing any values in the inserts, updates, ignored, skipped, or errors column?

We need to get a better understanding of where you've precisely checked for this because having a green successful bar (or may be blue - I forget) once you conduct the transform and then you saying 0's across all of those columns...it would imply that there's nothing in the import set at all.

Please mark reply as Helpful/Correct, if applicable. Thanks!

Re: Transform Map Isn't Transforming

johnfeist — Tue, 03 May 2022 14:25:06 GMT

Hi Allen,

Thanks for the reply.

I unchecked the Apply Business Rules box and reran, no joy.

Following is a step by step of what I've done:

I loaded clean data:

Then I opened in list view:

and then one row:

Then I go to the transform map and hit the Transform link:

I click on Transform and get the following immediately:

When I go into the Transform History and open that record I get:

If I try to run the load again I get an error that there is nothing to load.

I hope this gives a complete picture.

:{)

Re: Transform Map Isn't Transforming

Allen Andreas — Tue, 03 May 2022 15:13:12 GMT

Hi,

I noticed that your result keeps being 20, are you doing the "test load 20 records" functionality as part of this? You didn't mention that and that's important as the result will always be 0 as the test load doesn't actually transform them and insert them.

So please do without the test load.

Alternatively, you can click "reprocess" on the import set and that would work as well, I believe.

Please mark reply as Helpful/Correct, if applicable. Thanks!

Re: Transform Map Isn't Transforming

johnfeist — Tue, 03 May 2022 15:29:34 GMT

Thank you Allen. Once I hit reprocess everything worked as expected,

:{)