---
name: common-apex-runtime-errors
description: "Diagnosing and resolving common Apex runtime exceptions: NullPointerException, QueryException, DmlException, ListException, LimitException, TypeException. Use when debugging Apex runtime failures or writing defensive code. NOT for error handling framework design (use error-handling-framework). NOT for governor limit prevention strategies (use governor-limits). NOT for structuring try/catch blocks (use exception-handling)."
category: apex
salesforce-version: "Spring '25+"
well-architected-pillars:
  - Reliability
  - Operational Excellence
triggers:
  - "Apex class throws NullPointerException and I don't know where the null is coming from"
  - "QueryException: List has more than 1 row for assignment to SObject — how do I fix this?"
  - "DmlException on insert failing with required field missing or duplicate value error"
  - "LimitException Too many SOQL queries in my trigger — what does that mean and how do I debug it?"
  - "Apex debug log shows FATAL_ERROR or EXCEPTION_THROWN event — how do I read it?"
  - "ListException Index was out of range — how do I trace the cause in Apex?"
tags:
  - NullPointerException
  - QueryException
  - DmlException
  - LimitException
  - TypeException
  - runtime-errors
  - debugging
  - exception-diagnosis
inputs:
  - Debug log with FATAL_ERROR or EXCEPTION_THROWN event, or a stack trace from a test failure
  - The Apex class or trigger name and approximate line number where the exception occurred
  - Exception class name (e.g. System.NullPointerException, System.QueryException)
outputs:
  - Per-exception root-cause diagnosis and corrective code pattern
  - Defensive coding checklist for the specific exception type encountered
  - Decision table mapping exception type to the correct resolution approach
dependencies: []
version: 1.0.0
author: Pranav Nagrecha
updated: 2026-04-05
---

# Common Apex Runtime Errors

Use this skill when an Apex class or trigger throws a runtime exception and you need to identify the root cause and apply the correct fix. It covers the six most common exception types — NullPointerException, QueryException, DmlException, ListException, LimitException, and TypeException/StringException — each with diagnosis path and resolution pattern.

---

## Before Starting

Gather this context before working on anything in this domain:

- Open the debug log for the failed transaction. Set log level to APEX_CODE: FINEST or at minimum APEX_CODE: ERROR. The `FATAL_ERROR` or `EXCEPTION_THROWN` event line contains the exception class, message, and line number.
- Confirm which Apex class and method (or trigger + handler) produced the failure. Automated test failures include a stack trace; production failures require a debug log or platform event capture.
- Know whether the execution is synchronous (trigger, Visualforce, REST callout) or asynchronous (Queueable, Batch, Scheduled). Async contexts suppress some exceptions from UI surfacing.

---

## Core Concepts

The Apex runtime throws built-in exceptions that are subclasses of `System.Exception`. Most are catchable in a `try/catch` block — but `LimitException` is explicitly uncatchable and must be prevented upstream. Each exception class carries a distinct message format that maps directly to a root cause.

### NullPointerException

Thrown when code dereferences a variable that is `null`. Common triggers:

- A SOQL query that returns no rows is assigned directly to an SObject variable (`Account a = [SELECT Id FROM Account WHERE Id = :someId];`). If zero rows match, `a` is `null`. Any field access on `a` (`a.Name`) throws immediately.
- An Apex method returns `null` and the caller chains a method call on the result without a null check.
- A `Map.get()` call returns `null` because the key is absent, and the return value is used without checking.

Resolution: Always check for `null` before accessing members. For SOQL scalars, wrap in a try/catch for `QueryException` or use a `List` and check `.isEmpty()`. For map lookups, use `map.containsKey(key)` before calling `.get()`.

### QueryException

Thrown in two scenarios:

1. **Too few rows:** A SOQL query assigned directly to a scalar SObject variable returns zero rows. Message: `List has no rows for assignment to SObject`.
2. **Too many rows:** The same scalar assignment returns two or more rows. Message: `List has more than 1 row for assignment to SObject`.

Resolution: Use a `List<SObject>` instead of a scalar when the result set size is uncertain. Check `list.isEmpty()` before accessing `list[0]`. When exactly one row is expected and a miss is a true error, catch `QueryException` explicitly and surface a meaningful error rather than letting the raw exception propagate.

### DmlException

Thrown when a DML operation (insert, update, delete, upsert) fails at the database level. Common causes:

- Required field is null on the record being inserted or updated.
- A duplicate rule fires and rejects the record.
- Mixed SObject types passed to a single DML statement (e.g. inserting both `Account` and `Contact` in one `insert` list — this is allowed; the error occurs when inserting SObjects of two types in the same statement using the multi-object DML restriction in certain contexts).
- A before-trigger or validation rule blocks the record.

The `DmlException` is the only common exception that carries per-row error details. Use `e.getNumDml()`, `e.getDmlMessage(i)`, `e.getDmlIndex(i)`, and `e.getDmlFields(i)` to extract which records failed and why.

Resolution: Validate required fields before DML. Use Database.insert/update/delete with `allOrNone=false` and inspect `Database.SaveResult[]` for partial-success scenarios. Log per-row `getDmlMessage` errors rather than only the top-level exception message.

### ListException

Thrown when code accesses a List index that does not exist. Message: `List index out of bounds: N`. Common causes:

- `myList[0]` is accessed after the list was populated by a filtered SOQL query that returned no rows.
- A loop uses a manual index variable that increments past the list size.

Resolution: Check `list.size() > index` or `!list.isEmpty()` before indexed access. Prefer `for (SObject o : list)` iteration over manual index loops.

### LimitException — UNCATCHABLE

Thrown when a governor limit is exceeded: CPU time, SOQL queries, DML rows, heap size, callouts, and so on. Message examples: `Too many SOQL queries: 101`, `Apex CPU time limit exceeded`.

**LimitException cannot be caught with try/catch.** Any `catch (LimitException e)` block will never execute. The transaction is terminated by the platform immediately.

Resolution: Use `Limits.getQueries()` / `Limits.getLimitQueries()` guards before issuing SOQL inside loops. Bulkify triggers. Move heavy work to Queueable or Batch Apex. The `governor-limits` skill covers prevention patterns in depth.

### TypeException and StringException

`TypeException` is thrown when an explicit cast fails (e.g. casting an Integer to a Date) or when `JSON.deserialize` produces a type mismatch. `StringException` is thrown by `String.format()` when the argument count does not match the placeholder count.

Resolution: Validate input types before casting. Use `instanceof` for runtime type checks. Prefer `JSON.deserializeUntyped()` with manual type checks over strongly-typed deserialization when the input shape is uncertain.

---

## Common Patterns

### Pattern: SOQL-safe scalar assignment

**When to use:** Any time you expect exactly one row from a SOQL query but the data could theoretically return zero or multiple rows (i.e., almost always).

**How it works:**

```apex
List<Account> accounts = [SELECT Id, Name FROM Account WHERE Id = :recordId LIMIT 1];
if (accounts.isEmpty()) {
    throw new AuraHandledException('Account not found: ' + recordId);
}
Account acc = accounts[0];
```

**Why not the alternative:** Direct scalar assignment `Account acc = [SELECT Id FROM Account WHERE Id = :recordId]` throws `QueryException` on zero rows and on two or more rows. Both failure modes are common in real orgs where data is inconsistent.

### Pattern: DML with per-row error capture

**When to use:** Bulk DML operations where partial success is acceptable and each failed row must be logged.

**How it works:**

```apex
List<Database.SaveResult> results = Database.insert(records, false);
for (Integer i = 0; i < results.size(); i++) {
    if (!results[i].isSuccess()) {
        for (Database.Error err : results[i].getErrors()) {
            System.debug('Row ' + i + ' failed: ' + err.getMessage()
                + ' Fields: ' + err.getFields());
        }
    }
}
```

**Why not the alternative:** `insert records;` with `allOrNone=true` (the default) rolls back the entire batch on a single-row validation failure, which is rarely the right behavior for bulk operations.

### Pattern: LimitException prevention guard

**When to use:** Any trigger or service method that issues SOQL inside a loop or recursively.

**How it works:**

```apex
if (Limits.getQueries() + 1 >= Limits.getLimitQueries()) {
    // Log and abort gracefully — do NOT attempt the query
    System.debug(LoggingLevel.ERROR, 'SOQL limit near — aborting query batch');
    return;
}
List<Contact> contacts = [SELECT Id FROM Contact WHERE AccountId IN :accountIds];
```

**Why not the alternative:** You cannot catch `LimitException`. If the limit is crossed, the transaction terminates with no opportunity to log or recover.

---

## Decision Guidance

| Exception | Root Cause | Resolution |
|---|---|---|
| NullPointerException on SObject field | SOQL returned 0 rows into scalar variable | Use List + isEmpty() check |
| NullPointerException on method chain | Method returned null, caller chained without guard | Add null check before chaining |
| QueryException: List has no rows | Scalar SOQL on zero-row result | Use List or catch QueryException |
| QueryException: List has more than 1 row | Scalar SOQL matched multiple rows | Add WHERE filters or use LIMIT 1 |
| DmlException: required field missing | Field blank on record before DML | Validate fields before insert/update |
| DmlException: duplicate value | Duplicate rule or unique constraint hit | Check for existing record first or use upsert |
| ListException: index out of bounds | Indexed access on empty or short list | Check list.size() before access |
| LimitException: Too many SOQL queries | SOQL inside loop | Bulkify: move SOQL outside loop |
| LimitException: CPU time exceeded | Nested loops or heavy string ops on large sets | Move work to Batch Apex |
| TypeException | Invalid cast or JSON type mismatch | Use instanceof check before cast |
| StringException | String.format argument count mismatch | Match placeholder count to argument list |

---

## Recommended Workflow

Step-by-step instructions for an AI agent or practitioner diagnosing an Apex runtime exception:

1. Open the debug log or test failure stack trace. Locate the `FATAL_ERROR` or `EXCEPTION_THROWN` event line. Note the exception class, message text, and line number.
2. Match the exception class to the six types in this skill (NullPointerException, QueryException, DmlException, ListException, LimitException, TypeException/StringException). If the class is not one of these, escalate to the `exception-handling` skill.
3. For NullPointerException: identify the null source — SOQL scalar result, method return value, or map lookup. Apply null guard or switch to List-based SOQL pattern.
4. For QueryException: switch scalar SOQL assignment to `List<SObject>` and add isEmpty() guard. For DmlException: add `Database.insert/update/delete` with `allOrNone=false` and log per-row errors using `getDmlMessage(i)`.
5. For LimitException: confirm via `Limits.*` API whether the limit is being approached. Bulkify the operation. If the fix requires architectural changes (e.g. moving to Batch Apex), flag for design review.
6. Apply defensive code pattern from the relevant section above. Add or update a unit test that exercises the failure path (zero-row SOQL, DML validation failure, boundary index access) to confirm the fix holds under real data conditions.
7. Run `python3 skills/apex/common-apex-runtime-errors/scripts/check_common_apex_runtime_errors.py --manifest-dir force-app/main/default/classes` to scan for unguarded patterns in the codebase.

---

## Review Checklist

Run through these before marking work in this area complete:

- [ ] No scalar SOQL assignment without a null guard or QueryException catch
- [ ] No DML statement that swallows failures silently (all DML errors are logged or surfaced)
- [ ] No SOQL query inside a for loop (bulkification verified)
- [ ] LimitException is not wrapped in a try/catch (it is uncatchable — prevention is the only path)
- [ ] Unit tests cover the zero-row, multi-row, and validation-failure paths for all affected methods
- [ ] Debug log reviewed for EXCEPTION_THROWN events at ERROR or FATAL level before closing the issue

---

## Salesforce-Specific Gotchas

Non-obvious platform behaviors that cause real production problems:

1. **LimitException is uncatchable** — Unlike every other built-in exception, `System.LimitException` cannot be caught in a `try/catch` block. Code that wraps DML or SOQL in try/catch and expects to catch a limit breach will silently fail to catch it. The transaction terminates without entering any catch block.
2. **Null SOQL scalar vs. empty List** — `Account a = [SELECT Id FROM Account WHERE Id = :id]` returns `null` when zero rows match, but a `List<Account>` query returns an empty list. Many developers expect the scalar form to throw `QueryException` immediately, but the exception is deferred to the first field access on the null reference, making stack traces misleading.
3. **DmlException row index mismatch after partial-success** — When using `Database.insert(records, false)`, the `SaveResult` array index maps to the original `records` list, not a filtered list of failed records. Using `getDmlIndex(i)` on the exception (from `allOrNone=true` mode) is required to find the source record; iterating the result array directly gives you the right index only in `allOrNone=false` mode.

---

## Output Artifacts

| Artifact | Description |
|---|---|
| Corrective code diff | Replace unsafe SOQL scalar / unguarded DML / indexed list access with the safe pattern for the specific exception type |
| Defensive checklist | Per-exception review checklist confirming all failure paths are covered |
| Checker report | Output of `check_common_apex_runtime_errors.py` listing unguarded patterns in the scanned Apex class directory |

---

## Related Skills

- `exception-handling` — Use for structuring try/catch/finally blocks and custom exception class design; this skill covers per-exception diagnosis, not framework structure
- `governor-limits` — Use for systematic governor limit prevention strategies; this skill covers LimitException diagnosis only
- `error-handling-framework` — Use for org-wide error capture, logging, and alerting patterns
- `debug-logs-and-developer-console` — Use for navigating debug logs and setting log levels to capture EXCEPTION_THROWN events