Migrating from vCenter Server 6.0 to VCSA 6.5 fails with the error: unquoted carriage return found in data

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:

• Migrating from vCenter Server 6.0 to VCSA 6.5 fails with the error:
  
   
  Encountered an internal error. see /var/log/firstboot/vpostgres-firstboot.py_11871_stderr.log
  Resolution:
  This is an unrecoverable error, please retry install. If you run into this error again, please collect a support bundle and open a support request.
   
• In the /var/log/firstboot/vpostgres-firstboot.py_xxx_stderr.log file, you see entries similar to:
   
  2016-12-08T16:54:02.674Z Upgrade import step failed
  2016-12-08T16:54:02.674Z vPostgres firstboot(action=firstboot) failed
   
• In the /var/log/vmware/vpxd/vcdb_import.err file, you see entries similar to:
   
  NOTICE: drop cascades to constraint vdc_entity_lock_metadata_fk on table vdc_entity_lock_metadata
  NOTICE: constraint "vdc_entity_lock_metadata_fk" of relation "vdc_entity_lock_metadata" does not exist, skipping
  ERROR: unquoted carriage return found in data
  HINT: Use quoted CSV field to represent carriage return.
  CONTEXT: COPY vpx_event_arg, line 1164679
   
• In the /var/log/vmware/vpostgres/postgresql-80.log file, you see entries similar to:
   

  VCDB postgres ERROR: unquoted carriage return found in data

  2016-12-08 16:49:48.648 UTC 58498f27.4bdc 8514 VCDB postgres HINT: Use quoted CSV field to represent carriage return.

  2016-12-08 16:49:48.648 UTC 58498f27.4bdc 8514 VCDB postgres CONTEXT: COPY vpx_event_arg, line 1164679

  2016-12-08 16:49:48.648 UTC 58498f27.4bdc 8514 VCDB postgres STATEMENT: COPY VPX_EVENT_ARG FROM STDIN WITH DELIMITER AS ',' CSV QUOTE '"';

  2016-12-08 16:49:49.752 UTC 58498f2a.4bf3 0 VCDB postgres LOG: duration: 3182.597 ms statement: COPY VPX_EVENT FROM STDIN WITH DELIMITER AS ',' CSV QUOTE '"';

  2016-12-08 16:49:50.844 UTC 58498f2b.4bf9 0 VCDB postgres LOG: duration: 3805.675 ms statement: COPY VPX_EVENT FROM STDIN WITH DELIMITER AS ',' CSV QUOTE '"';

  2016-12-08 16:49:51.860 UTC 58498f2c.4c08 0 VCDB postgres LOG: duration: 3111.694 ms statement: COPY VPX_EVENT FROM STDIN WITH DELIMITER AS ',' CSV QUOTE '"';

  2016-12-08 16:49:52.323 UTC 58498f2d.4c0c 0 VCDB postgres LOG: duration: 2560.249 ms statement: COPY VPX_EVENT FROM STDIN WITH DELIMITER AS ',' CSV QUOTE '"';

  2016-12-08 16:49:54.209 UTC 58498eba.4872 0 LOG: Updating instance status...
  
  Note: The preceding log excerpts are only examples. Date, time, and environmental variables may vary depending on your environment.

Resolution

This is a known issue affecting vCenter Server 6.0.

 

In the vcdb_import.err log file and find the table that failed:

For example:

 

ERROR: unquoted carriage return found in data

HINT: Use quoted CSV field to represent carriage return.

CONTEXT: COPY vpx_event_arg, line 1164679

 

To resolve this issue perform one of the following:

• Run the migration again and chose not to migrate the Events and Task data.
• Purge the Task and Event table prior to running the migration again. For more information on purging the tables, see Purging old data from the database used by vCenter Server (1025914).

Additional Information

Resolution : "vPostgres firstboot (action=firstboot) failed" ​​​​​​​
Purging old data from the database used by vCenter Server
vCenter Server 6.0 から VCSA 6.5 への移行がエラー「引用符で囲まれていないキャリッジ リターンがデータに見つかりました (unquoted carriage return found in data)」で失敗する
中文简体：从 vCenter Server 6.0 迁移到 VCSA 6.5 失败并显示错误：在数据中找到不带引号的回车符 (unquoted carriage return found in data)