# JDBCBuildMap Rule

**URL:** <https://developer.sailpoint.com/discuss/t/jdbcbuildmap-rule/190077>\
**Category:** IIQ Discussion and Questions\
**Tags:** jdbc-connector, identityiq, aggregation\
**Created:** [December 5, 2025, 10:18am UTC](https://developer.sailpoint.com/discuss/t/jdbcbuildmap-rule/190077 "2025-12-05T10:18:12Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![GovindaJagtap](https://avatars.discourse-cdn.com/v4/letter/g/9dc877/32.png) [@GovindaJagtap](https://developer.sailpoint.com/discuss/u/GovindaJagtap)\
**Post date:** [December 5, 2025, 10:18am UTC](https://developer.sailpoint.com/discuss/t/jdbcbuildmap-rule/190077/1 "2025-12-05T10:18:12Z")

</div>

## Which IIQ version are you inquiring about?

\*8.5  
\*

## Please share any images or screenshots, if relevant.

_[Please insert images here, otherwise delete this section]_

## Please share any other relevant files that may be required (for example, logs).

_[Please insert files here, otherwise delete this section]_

## Share all details about your problem, including any error messages you may have received.

```auto
import sailpoint.connector.JDBCConnector;
import java.util.Map;

Map map = JDBCConnector.buildMapFromResultSet(result, schema);

// Read ID safely
String id = (String) map.get(“id”);

// Skip if id is missing
if (id == null || !id.startsWith(“1a”)) {
Map skipmap=new HashMap();
skipmap.put(“id”,“skip_”+id); // safe skip
return skipmap;
}

// Return map for valid rows
return map;

```

ERROR: Getting error Index value for[id] on new object was null

I used SQL Query option and Custiomization Rule its working fine but for hands-on purpose I also want to explore the JDBC build map

can you please help on this?

---

<div class="post-metadata">

**Author:** ![RajGopal](https://avatars.discourse-cdn.com/v4/letter/r/e5b9ba/32.png) [@RajGopal](https://developer.sailpoint.com/discuss/u/RajGopal)\
**Post date:** [December 7, 2025, 8:48am UTC](https://developer.sailpoint.com/discuss/t/jdbcbuildmap-rule/190077/2 "2025-12-07T08:48:19Z")

</div>

Hi,  
In my opinion , When performing JDBC Aggregation in SailPoint IIQ, the **Build Map Rule cannot return a partial or incomplete map**. IIQ enforces the presence of all required schema attributes for every row returned.

In your application schema, attributes such as the **Identity attribute (id)** and the **Display Attribute** are marked as mandatory. Because of this, SailPoint expects **every map returned by the Build Map Rule** to include these attributes.

Thanks,  
RajGopal.

---

<div class="post-metadata">

**Author:** ![drosenbauer](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/drosenbauer/32/3381_2.png) [@drosenbauer](https://developer.sailpoint.com/discuss/u/drosenbauer)\
**Post date:** [December 8, 2025, 5:05pm UTC](https://developer.sailpoint.com/discuss/t/jdbcbuildmap-rule/190077/3 "2025-12-08T17:05:38Z")

</div>

> [@GovindaJagtap](#):
>
> `Map skipmap=new HashMap();`

This isn’t true. IIQ does enforce the existence of all attributes that do stuff, though, particularly the native identity and any attributes used to “merge” rows. Your error suggests that your “id” attribute is missing while attempting to merge rows (that’s what it means by index value), though your rule does appear always ensure that it exists.

Note that this is case-sensitive for the JDBC connector.

How do you have it configured in the actual application?

---

<div class="post-metadata">

**Author:** ![GovindaJagtap](https://avatars.discourse-cdn.com/v4/letter/g/9dc877/32.png) [@GovindaJagtap](https://developer.sailpoint.com/discuss/u/GovindaJagtap)\
**Post date:** [December 10, 2025, 7:29am UTC](https://developer.sailpoint.com/discuss/t/jdbcbuildmap-rule/190077/4 "2025-12-10T07:29:36Z")

</div>

// Skip if id is missing  
if (id == null || !id.startsWith(“1a”)) {  
return new HashMap();  
}

Hi Devin, the above error is getting for this condition  
just want to skip or ignore those rows who not match the conditi

---

<div class="post-metadata">

**Author:** ![drosenbauer](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/drosenbauer/32/3381_2.png) [@drosenbauer](https://developer.sailpoint.com/discuss/u/drosenbauer)\
**Post date:** [December 10, 2025, 8:33pm UTC](https://developer.sailpoint.com/discuss/t/jdbcbuildmap-rule/190077/5 "2025-12-10T20:33:09Z")

</div>

Yes, in that code you just pasted now (which is different than the original) you’ll get the error you reported. You do need to return at least the required fields in your Map, and they need to be non-null.

---

<div class="post-metadata">

**Author:** ![narayanag](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/narayanag/32/25441_2.png) [@narayanag](https://developer.sailpoint.com/discuss/u/narayanag)\
**Post date:** [December 10, 2025, 8:55pm UTC](https://developer.sailpoint.com/discuss/t/jdbcbuildmap-rule/190077/6 "2025-12-10T20:55:40Z")

</div>

> [@GovindaJagtap](#):
>
> \*\*[Govinda Jagtap](https://developer.sailpoint.com/discuss/u/govindajagtap) -\*\*Welcome to the SailPoint developer community! You’ll learn a lot by helping others
> 
> **Looks like you want to learn the build map working behavior.**
> 
> this error means the connector is trying to create an object whose **index/identity attribute (`id`) is null**, so IIQ bails out: _“Index value for [id] on new object was null._

Please share application Schema and share Jdbc query

Ensure your `SELECT` returns the identity column with the **same name** as in the schema (use `AS id` if needed).

---

<div class="post-metadata">

**Author:** ![pallavi](https://sea1.discourse-cdn.com/sailpoint/discuss/user_avatar/developer.sailpoint.com/pallavi/32/17939_2.png) [@pallavi](https://developer.sailpoint.com/discuss/u/pallavi)\
**Post date:** [December 29, 2025, 5:57am UTC](https://developer.sailpoint.com/discuss/t/jdbcbuildmap-rule/190077/7 "2025-12-29T05:57:10Z")

</div>

Hi @GovindaJagtap,

Please implement customisation rule to implement this requirement. Refer this thread for more details: [JDBCBuildMap Rule issue - #13 by naveenkumar3](https://developer.sailpoint.com/discuss/t/jdbcbuildmap-rule-issue/190065/13)

Thanks,

Pallavi

---

<div class="post-metadata">

**Author:** ![GovindaJagtap](https://avatars.discourse-cdn.com/v4/letter/g/9dc877/32.png) [@GovindaJagtap](https://developer.sailpoint.com/discuss/u/GovindaJagtap)\
**Post date:** [December 29, 2025, 6:58am UTC](https://developer.sailpoint.com/discuss/t/jdbcbuildmap-rule/190077/8 "2025-12-29T06:58:32Z")

</div>

Hi @pallavi , Thank you! I will be proceeding with Customization rule.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/sailpoint/original/2X/f/f2136700ed5e3703e0b85e02f6be799dacca7735.png) [@system](https://developer.sailpoint.com/discuss/u/system)\
**Post date:** [February 27, 2026, 6:59am UTC](https://developer.sailpoint.com/discuss/t/jdbcbuildmap-rule/190077/9 "2026-02-27T06:59:06Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.