Loading

×Sorry to interrupt
This page has an error. You might just need to refresh it.
[NoErrorObjectAvailable] Uncaught ReferenceError: addCTracking is not defined
Failing descriptor: {markup://c:KM_ArticleThemeLayout}

Refresh

Cookie Preference Center

General Information on cookies

When you visit our website, we use cookies to ensure that we give you the best experience. This information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies by clicking on the different category headings to find out more and change your settings. However, blocking some types of cookies may impact your experience on the site and the services we are able to offer. Further information can be found in our

Cookie Policy.

Strictly Necessary

Strictly Necessary

Always Active

Strictly Necessary

Strictly necessary cookies are always enabled since they are essential for our website to function. They enable core functionality such as security, network management, and website accessibility. You can set your browser to block or alert you about these cookies, but this may affect how the website functions. For more information please visit www.aboutcookies.org or www.allaboutcookies.org.

Cookie Details‎

Performance

Performance

Performance

Performance cookies are used to analyze the user experience to improve our website by collecting and reporting information on how you use it. They allow us to know which pages are the most and least popular, see how visitors move around the site, optimize our website and make it easier to navigate.

Cookie Details‎

Please confirm your settings by refreshing the page.

Functional

Functional

Functional

Functional cookies help us keep track of your past browsing choices so we can improve usability and customize your experience. These cookies enable the website to remember your preferred settings, language preferences, location and other customizable elements such as font or text size. If you do not allow these cookies, then some or all of these services may not function properly.

Cookie Details‎

Advertising

Advertising

Advertising

Advertising cookies are used to send you relevant advertising and promotional information. They may be set through our site by third parties to build a profile of your interests and show you relevant advertisements on other sites. These cookies do not directly store personal information, but their function is based on uniquely identifying your browser and internet device.

Cookie Details‎

Advertising Cookies

Consent Leg.Interest

Select All Vendors

Select All Vendors

Select All Hosts

Select All

Clear Filters

Information storage and access

Apply

Confirm My Choices Reject All Allow All

My Subscriptions

Loading

Knowledge Base

vCenter Server 6.0 から VCSA 6.5 への移行がエラー「引用符で囲まれていないキャリッジ リターンがデータに見つかりました (unquoted carriage return found in data)」で失敗する (2148219)

Last Updated: 7/10/2019Categories: TroubleshootingTotal Views: 1Language:
JapaneseEnglish

1 like this article

Subscribe to get an email
newsletter with new updates

1 people found this helpful Please provide article feedback:

Symptoms

免責事項：これは英文の記事「Migrating from vCenter Server 6.0 to VCSA 6.5 fails with the error: unquoted carriage return found in data (2148219)」の日本語訳です。記事はベストエフォートで翻訳を進めているため、ローカライズ化コンテンツは最新情報ではない可能性があります。最新情報は英語版の記事で参照してください。

Purpose

vCenter Server 6.0 から VCSA 6.5 への移行が次のエラーで失敗する。

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.

/var/log/firstboot/vpostgres-firstboot.py_xxx_stderr.log ファイルに、次のようなエントリが記録される。

2016-12-08T16:54:02.674Z   Upgrade import step failed
2016-12-08T16:54:02.674Z   vPostgres firstboot(action=firstboot) failed

/var/log/vmware/vpxd/vcdb_import.err ファイルに、次のようなエントリが記録される。

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

/var/log/vmware/vpostgres/postgresql-80.log ファイルに、次のようなエントリが記録される。

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...

注：前述のログの引用は単なる例です。日付、時間、および環境変数は、環境によって異なる場合があります。

Resolution

これは既知の問題で、vCenter Server 6.0 に影響します。

vcdb_import.err ログ ファイルで、失敗したテーブルを見つけます。

例：

ERROR:  unquoted carriage return found in data
HINT:  Use quoted CSV field to represent carriage return.
CONTEXT:  COPY vpx_event_arg, line 1164679

この問題を解決するには、次のいずれかを実行します。

もう一度移行を実行し、タスクおよびイベントのデータを移行しないようにする。

もう一度移行を実行する前に、タスクおよびイベントのテーブルを消去する。テーブルの消去の詳細については、「Purging old data from the database used by vCenter Server (1025914)」を参照してください。

Related Information

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

Detectable by VMware SkylineTM

Actions

Copy

link to clipboard
copied!

Print

Language:
JapaneseEnglish

Attachments

Additional Resources

No results for undefined

Ask The Community

Get answers quickly from VMware experts in the community

Post Subject

CONTINUE IN COMMUNITIES

Related Products:

Related Versions:

Support Assistant