odoo-debugger

# Odoo Debugger & Issue Resolver

## Overview

This skill provides systematic debugging approaches for common Odoo 16.0 issues, with specialized knowledge of SVL (Stock Valuation Layer) linking, queue jobs, view inheritance problems, and business logic errors specific to the Siafa project.

## Issue Categories

### 1. SVL (Stock Valuation Layer) Issues
Stock valuation layers not linking properly to vendor bills or account moves.

### 2. Queue Job Failures
Background jobs failing or getting stuck in queue_job system.

### 3. View/XML Errors
Views not rendering, XPath inheritance issues, missing fields.

### 4. Business Logic Bugs
Computed fields not calculating, onchange not triggering, constraints failing.

### 5. Data Integrity Issues
Orphaned records, inconsistent data, broken relationships.

### 6. Performance Problems
Slow queries, N+1 problems, inefficient computed fields.

### 7. Access Rights Issues
Permission errors, record rules blocking access.

## Debugging Workflow

### Step 1: Gather Information

Ask for:
- Error message or traceback (full text)
- Steps to reproduce the issue
- Which module/model is affected
- Recent changes or updates
- Database name and Odoo version

### Step 2: Categorize the Issue

Identify which category the issue falls into and follow the specialized workflow.

## Debugging Patterns by Category

### Pattern 1: SVL Linking Issues

**Common Symptoms:**
- Stock valuation layers exist but not linked to vendor bills
- Account move lines don't reference SVL
- Quantity mismatch between stock moves and SVL
- Missing SVL for stock moves

**Investigation Script:**

```python
# In Odoo shell (python3 src/odoo-bin shell -c src/odoo.conf -d DATABASE_NAME)

# Get SVL record
svl = env['stock.valuation.layer'].browse(SVL_ID)

# Check SVL details
print(f"SVL ID: {svl.id}")
print(f"Product: {svl.product_id.name}")
print(f"Quantity: {svl.quantity}")
print(f"Value: {svl.value}")
print(f"Unit Cost: {svl.unit_cost}")
print(f"Stock Move: {svl.stock_move