9 views

Description

SCCM 2012 v2 Computer Identity transform fails with "Object object has exceeded maximum permitted size of 268435456" in the "buildByTransformMap" function in the field map script for "sys_id"

Steps to Reproduce

 

  1. In the "SCCM 2012 v2 Computer Identity" transform map, add 18 new fields (where source field is not "[Script]").

  2. Import a large amount of records from SCCM.

    A verification test used 41,680 records.

    Observe the following message (occurred at row 1500 in the test):

    "WARNING *** WARNING *** Object object has crossed the warning threshold of 134217728 with current size 136554496"

    Observe the following message (at row 3000 in the test):

    WARNING *** WARNING *** Object object has crossed the warning threshold of 134217728 with current size 140392032
    WARNING *** WARNING *** Javascript compiler exception: Object object has exceeded maximum permitted size of 268435456 in:
    WARNING *** WARNING *** Unable to resolve target record, coalesce values not present: [Script]

    At this point, the transform fails to update the target record until row 5456 after the following occurs:

    [0:00:00.322] Compacting large row block (file.write: imp_sccm2012v2_computer_id 5456 rows 20905648 saveSize)
    [0:00:00.003] Expanding large row block (file.read: imp_sccm2012v2_computer_id, 4544 rows, 238624 dataSize)

    The transform continues without warnings until row 6900:

    WARNING *** WARNING *** Object object has crossed the warning threshold of 134217728 with current size 134568768

    At row 8500, the "exceeded" message occurs again and the transform fails to update the target record until row 10000, again after the following occurs:

    [0:00:00.284] Compacting large row block (file.write: imp_sccm2012v2_computer_id 4544 rows 17386160 saveSize)
    [0:00:00.002] Expanding large row block (file.read: imp_sccm2012v2_computer_id, 10000 rows, 160000 dataSize)

 

 

Workaround

In the buildByTransformMap function in the field map script for sys_id, change:

ciData[gr.target_field+''] = source[gr.source_field+''];

to:

ciData[gr.target_field+''] = source[gr.source_field+''].toString();


Related Problem: PRB1248223

Seen In

There is no data to report.

Intended Fix Version

London

Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-04-12 05:52:15
Published:2018-04-12