Virtual machine fails to acquire IP address during deployment for specific users in VMware Aria Automation

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

• When deploying a new virtual machine in VMware Aria Automation, the deployment may fail to acquire an IP address for specific users. Other users can deploy virtual machines and acquire IP addresses successfully in the same environment.
• When reviewing the external IPAM integration, the failure produces the following error log on the IPAM side:
  

  Failed to create new address. SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'description' at row 1 id: first_free hostname: VM_name description: Reserved by vRA for {user_name}
  

Environment

Aria Automation 8.18.x

Cause

This issue is caused by a string length restriction within the external PHP IPAM database.

The description string generated by VMware Aria Automation during the IP reservation process (which includes the username) exceeds the maximum allowed character length for the description column in the PHP IPAM database.

This causes a string truncation error (SQLSTATE[22001]), resulting in a failed database transaction and preventing the IP address from being allocated.

Resolution

Because this is an issue with the external PHP IPAM database schema and not VMware Aria Automation, you must increase the allowed string size on the external IPAM side.

Engage PHP IPAM vendor to fix the database constraint.