Search Engine: Elastic

Article ID: 130872, created on May 24, 2017, last review on Aug 29, 2017

  • Applies to:
  • Operations Automation 7.1

Symptoms

The Azure CSP 4.1 upgrade procedure is performed as per:

http://download.automation.odin.com/poa/azurecsp/doc/91974.htm

The azure/deployment/import.py script fails with errors like:

2017-05-22 09:52:23.403 [INFO] Import started. It will take few minutes.
2017-05-22 09:52:23.693 [ERROR] Failed to execute SQL (exit code 1):

In the PostgreSQL logs on the destination node errors like the following may be observed:

< 2017-05-22 21:05:46.990 CEST > ERROR:  invalid input syntax for type numeric: "55,05741066247210"

Or the following:

< 2017-05-24 20:25:33.631 CEST > ERROR:  date/time field value out of range: "14-6-2016 00:00:00 +00:00"

Cause

The CSV file generated during the Export data step was formatted using the Windows date and numbers formatting, which made data exported SQL-incompatible.

This issue could be faced on OS'es with non-English locale.

Resolution

Edit Windows setting in Control Panel > Clock, Language, and Region > Region > Change date, time, or number formats.

Time and date settings on the Formats tab should be edited as:

  • Short date - yyyy-MM-dd
  • Long time - HH:mm:ss

For the number settings in Additional Settings > Numbers and Additional Settings > Currency the decimal symbol should be set as dot sign - ".".

Once it's done - regenerate CSV file as per Export data part of the instruction and continue with the import.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 8c199f0ee4305da1a577740620df4a51 1941880841f714e458ae4dc3d9f3062d

Email subscription for changes to this article
Save as PDF