This article was written for a specific issue. Please verify all of the symptoms before following the recommendations under "Workaround"
Symptoms:
yyyy-mm-ddT00:00:00.000Z error vpxd[07163] [Originator@6876 sub=Default opID=DbParallelLoad-1c06dac8] [VdbStatement] Execute result code: -1
yyyy-mm-ddT00:00:00.000Z error vpxd[07163] [Originator@6876 sub=Default opID=DbParallelLoad-1c06dac8] [VdbStatement] SQL execution failed: insert into VPX_TABLE (TABLE_NAME, COL_NAME, COL_TYPE, COL_LEN, PK_FL G) values (?, ?, ?, ?, ?)
yyyy-mm-ddT00:00:00.000Z error vpxd[07163] [Originator@6876 sub=Default opID=DbParallelLoad-1c06dac8] [VdbStatement] Execution elapsed time: 20 ms
yyyy-mm-ddT00:00:00.000Z error vpxd[07163] [Originator@6876 sub=Default opID=DbParallelLoad-1c06dac8] [VdbStatement] Statement diagnostic data from driver is 22001:0:1:ERROR: value too long for type character varying(30); --> Error while executing the query ...
yyyy-mm-ddT00:00:00.000Z error vpxd[07163] [Originator@6876 sub=Default opID=DbParallelLoad-1c06dac8] [Vdb::IsRecoverableErrorCode] Unable to recover from 22001:1
yyyy-mm-ddT00:00:00.000Z error vpxd[07163] [Originator@6876 sub=Default opID=DbParallelLoad-1c06dac8] [VdbStatement] SQLError was thrown: "ODBC error: (22001) - ERROR: value too long for type character varying(30); --> Error while executing the query" is returned when executing SQL statement "insert into VPX_TABLE (TABLE_NAME, COL_NAME, COL_TYPE, COL_LEN, PK_FLG) values (?, ?, ?, ?, ?)"
yyyy-mm-ddT00:00:00.000Z error vpxd[07163] [Originator@6876 sub=Default opID=DbParallelLoad-1c06dac8] [VdbSchemaLoader::StoreTableSchemaInfoToDB] Error inserting into VPX_TABLE for table VPX_NON_ORM_VM_CONFIG_INFO: "ODBC error: (22001) - ERROR: value too long for type character varying(30); --> Error while executing the query" is returned when executing SQL statement "insert into VPX_TABLE (TABLE_NAME, COL_NAME, COL_TYPE, COL_LEN, PK_FLG) values (?, ?, ?, ?, ?)"
VMware vCenter Server 6.x
VMware vCenter Server 7.x
VMware vCenter Server 8.x
# shell
# /opt/vmware/vpostgres/current/bin/psql -d VCDB -U postgres
with uopg as (select dvs_id, id, dvportgroup_name, dvportgroup_key, dvportgroup_type, uplink_portgroup_flg from VPX_DVPORTGROUP where uplink_portgroup_flg=1)
select vds.dvs_id, vds.dvportgroup_id , vds.vlan_id, vds.vlan_object_flg from VPX_DVPORT_SETTING vds
join uopg on (vds.dvs_id = uopg.dvs_id and vds.dvportgroup_id=uopg.id)
order by 1,2;
dvs_id | dvportgroup_id | vlan_id | vlan_object_flg
--------+----------------+---------+-----------------
28 | 29 | | 3
701937 | 701938 | 3333 | 1
with vlan as (select dvs_id,dvportgroup_id,runtimeinfo_flg,vlan_id_start,vlan_id_end, dvport_key from VPX_DVPORT_VLAN where dvportgroup_id <> 0 order by 1,2)
select vdvpg.dvs_id, vdvpg.id, dvportgroup_name, vlan.runtimeinfo_flg,vlan.vlan_id_start,vlan.vlan_id_end, vlan.dvport_key from VPX_DVPORTGROUP vdvpg
left join vlan on (vlan.dvs_id=vdvpg.dvs_id and vlan.dvportgroup_id=vdvpg.id)
where vdvpg.uplink_portgroup_flg=1;
dvs_id | id | dvportgroup_name | runtimeinfo_flg | vlan_id_start | vlan_id_end | dvport_key
--------+--------+---------------------------+-----------------+---------------+-------------+------------
2011 | 2012 | dswitch-DVUplinks-2011 | 0 | 0 | 4094 |
701937 | 701938 | dswitch-DVUplinks-701937 | | | |
# update vpx_dvport_setting set vlan_object_flg =3 where dvs_id=<dvs_id> and dvportgroup_id =<dvportgroup_id>;
# update vpx_dvport_setting set vlan_id=NULL where dvs_id=<dvs_id> and dvportgroup_id =<dvportgroup_id>;
# insert into vpx_dvport_vlan (dvs_id, dvportgroup_id, runtimeinfo_flg, vlan_id_start, vlan_id_end) values(<dvs_id>,<dvportgroup_id>,0,0,4094);
# update vpx_dvport_setting set vlan_object_flg =3 where dvs_id=701937 and dvportgroup_id =701938;
# update vpx_dvport_setting set vlan_id=NULL where dvs_id=701937 and dvportgroup_id =701938;
# insert into vpx_dvport_vlan (dvs_id, dvportgroup_id, runtimeinfo_flg, vlan_id_start, vlan_id_end) values(701937,701938,0,0,4094);
# vmon-cli -i vpxd