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

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

book

Article ID: 315238

calendar_today

Updated On:

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:


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)