SyncPIMSyncPIM
Documentation

Connection Errors

Diagnose and fix connection problems with Akeneo PIM and databases.

Quick Tip: Test connections separately — Akeneo first, then database — to isolate the problem.

🔐Auth Errors

401 / Invalid credentials

⏱️Timeouts

Network / Firewall

🔒SSL/TLS

Certificate issues

🚦Rate Limits

429 Too Many Requests

Akeneo PIM Errors

❌

401 Unauthorized

"Invalid credentials" or "Authentication failed"

Causes

  • • Wrong Client ID or Secret
  • • Incorrect username/password
  • • Expired API credentials
  • • User lacks API permissions

Solutions

  • • Verify in System → API connections
  • • Regenerate Client Secret
  • • Check user has "API" role
  • • Copy without trailing spaces
⏱️

Connection Timeout

"Request timeout" or "ECONNREFUSED"

Causes

  • • Incorrect Akeneo URL
  • • Firewall blocking port 443
  • • Instance temporarily down
  • • Network connectivity issues

Solutions

  • • Verify URL: https://company.cloud.akeneo.com
  • • Test URL in browser
  • • Check Akeneo status page
  • • Contact Akeneo support
🔒

SSL/TLS Certificate Error

"Certificate verification failed"

Causes

  • • Self-signed certificate
  • • Expired SSL certificate
  • • Certificate mismatch

Solutions

  • • Cloud: Contact Akeneo support
  • • Self-hosted: Renew certificate
  • • Use trusted CA certificate
🚦

429 Rate Limit Exceeded

"Too Many Requests"

Causes

  • • Too many API requests
  • • Multiple simultaneous exports
  • • Akeneo plan limits reached

Solutions

  • • Wait 5-10 minutes
  • • Avoid parallel exports
  • • Schedule off-peak hours

Database Errors

🍃

MongoDB

Connection String

bash
mongodb://user:pass@host:27017/db
  ?authSource=admin&ssl=true
Connection refused

→ Check host, port 27017, firewall

Auth failed

→ Add ?authSource=admin

SSL required

→ Add &ssl=true

Atlas: Add IPs in Network Access

🐘

PostgreSQL

Connection String

bash
postgresql://user:pass@host:5432/db
  ?sslmode=require
Connection refused

→ Check host, port 5432, security groups

Permission denied

→ Grant CONNECT + CREATE + INSERT

SSL required

→ Add ?sslmode=require

RDS/Cloud: Configure security groups for our IPs

⏱️

Database Timeout During Export

"Query timeout" or "Connection lost"

Causes

  • • Database overloaded
  • • High network latency
  • • Connection pool exhausted
  • • Long-running queries blocking

Solutions

  • • Use database in same region
  • • Increase connection pool size
  • • Schedule off-peak exports
  • • Use incremental mode

Test Your Connections

Validate connections manually before configuring exports.

1

Test Akeneo Connection

bash
curl -X POST https://your-company.cloud.akeneo.com/api/oauth/v1/token \
  -d "grant_type=password" \
  -d "username=your_username" \
  -d "password=your_password" \
  -u "client_id:client_secret"

✅ Success: JSON with access_token

2

Test MongoDB

bash
mongosh "mongodb://user:pass@host:27017/db?authSource=admin&ssl=true" \
  --eval "db.runCommand({ ping: 1 })"

✅ Success: { ok: 1 }

3

Test PostgreSQL

bash
psql "postgresql://user:pass@host:5432/db?sslmode=require" \
  -c "SELECT version();"

✅ Success: PostgreSQL version string

Common Mistakes
  • • Trailing spaces when copying credentials
  • • Special characters in password not URL-encoded
  • • Using postgres:// instead of postgresql://
  • • Missing database name in connection string

Next Steps

Export Failures

Troubleshoot failed exports

Common Issues

Quick solutions to common problems