Transform is not getting transferred full data

Saib1
Tera Guru

Hi All,

I am trying to transfer the data to cmdb_ci_computer table through JDBC connection . When i transform the data partial data is moving to target table.

 

Only few data is getting transferred . When i check the import set table it says State - Pending but not transforming full data.

find_real_file.png

4 REPLIES 4

Saurav11
Kilo Patron
Kilo Patron

Hello,

was the Transformation Map executed after the data have been loaded? Are there any errors or warning in import or system log? Are the "pedning" records referenced to any Import Set?

ram_mandadapu
ServiceNow Employee
ServiceNow Employee

Hi Shohaib,

Please create a support case on https://support.servicenow.com/

Our support team can help you to find the root cause. 

LakshmiNarayan7
Mega Guru

Please check if the following;

1. If the coalesce value is set correctly in the Transform Map.

2. If its a JDBC pull for 20 records on Test, It won't transform the data. We need to do it manually.

3. All the reference fields are set to ignore on New Value, At times that might get stuck.

4. Check the Transform Map if there is any long running Transform Scripts.

Thanks!

Ashish Routray1
Tera Contributor

Hii 

Even i have facing the same issue with network adapter class how you resolve this issue can you guide me.