Transform Map is not working

sam352120
Kilo Guru

‎06-08-2016 06:39 AM

Hi All,

I have created one Data source of JDBC type,   which is able to load data into Import set table using "Test load 20 Record".

My problem is the transform map is not working properly , I can see the data source is populating   data to import set table but the data is not populating in my target table.

I have tried with direct field mapping also I have tried with transform script , both are not working, I used some log and found out error as source and target is undefined but in my transform map both source_table and target_table has proper table name.

please share your idea.

0 Helpfuls
  • 6,055 Views
17 REPLIES 17

prabh
Mega Expert

‎07-03-2016 04:14 AM

Hi,



I am also facing the same issue. Did you get the solution for this.



Thanks,


Preety


0 Helpfuls

martygrinstead
ServiceNow Employee
ServiceNow Employee
In response to prabh

‎07-20-2016 05:53 PM

This is a fairly old post, so it may have already been answered.



When you "Test Load 20 records", they will not be transformed (by design).   The state of the records = "Test" and those are not expected to be processed.   They only exist to confirm your data source was setup correctly.



There is a trick to get these processed, but the best option is to do a full load, then step through the process of selecting the transform map, and executing it.



The log file should provide some detailed description of any error you encounter.   Providing these details will help us figure out what's going wrong.



Regards,


Marty


Prasad43
Tera Guru

‎05-30-2019 01:01 AM

This is expected bahaviour..
 
https://hi.service-now.com/kb_view.do?sysparm_article=KB0563963
 
 
Importing data using Load All Records or Test Load 20 Records
919 views
Number: KB0563963 
 

Importing data using Load All Records or Test Load 20 Records 

 

Objective
The objective of this note is to explain the difference of importing records from data sources using the options Load All Records and Test Load 20 Records.

 

Procedure
Load All Records and Test Load 20 Records are UI actions located on the related links for a particular data source.

Data sources are located at System Import Sets > Administration > Data Sources.

The usage of these following UI actions is similar, but the use case for each is quite different. 

Load All Records

This UI action is used when the data has already being validated and you are ready to transform the data using the Transform option to import the data into the target table. This action sets the internal state of the import to Loaded. Note that the Transform option to run the transformation maps will only process imports with this state.

Test Load 20 Records

This UI action is generally used to validate the records that you want to import without the initial intention of running a transformation map to the target table. This action sets the internal state of the import to Load, therefore the transformation map is skipped.

If needed, the Test 20 Records UI action allows you to ultimately run the Transform option, but a Reprocess action is required.

Reprocess

This UI action changes the internal state of the test import from Load to Loaded. As a result, you can now run the Transform option for the subset of 20 records"test loaded from the import set.

  

Conclusion

The action Load All Records is used when the data has already being validated and is ready to be transformed into the target table.

Skipping the transformation map is the standard behavior for the action Test Load 20 Records. This action is recommended for validation purposes, however, the transform and import can be forced for the 20 records imported during the test load by using the Reprocess action.