Hi GoodData team,  I have connected a Postgres da...
# gooddata-platform
j
Hi GoodData team,  I have connected a Postgres database successfully. However, I’m having a problem of loading (please check the screenshot & the attached log). Please help
Copy code
2022-02-15T09:36:22.548+0100 [INFO]: Data distribution worker started
2022-02-15T09:36:22.548+0100 [INFO]: Request id: "data_load_oqmNy9tdwG_CHrbQR9Bu9:gqYPZVExBjUOWEvq:Z0SBd5yfRzeVnRpF"
2022-02-15T09:36:22.548+0100 [INFO]: Data source: "6206329981fbdc0001e53901"
2022-02-15T09:36:22.548+0100 [INFO]: Additional parameters: {GDC_DE_SYNCHRONIZE_ALL=true, PROCESS_ID=bf2aaf9a-f5e8-44de-a406-d446418144d6}
2022-02-15T09:36:22.548+0100 [INFO]: Synchronization mode: all mapped datasets (default)
2022-02-15T09:36:32.832+0100 [INFO]: Synchronized datasets: [dataset.orders]
2022-02-15T09:36:32.833+0100 [INFO]: 

====================== Mapping Validation ======================

Mapping Validation is OK

====================== End of Mapping Validation ======================


2022-02-15T09:36:32.833+0100 [INFO]: 

====================== Output Stage -> LDM mapping ======================


Output Stage table/view: ORDERS (full, shared) -> Dataset: dataset.orders
LASTCHECKUNI[INT4] -> fact.orders.lastcheckuni{FACT}[INT]
DEFAULTER[INT4] -> fact.orders.defaulter{FACT}[INT]
DISCOUNTSUM[NUMERIC(12,2)] -> fact.orders.discountsum{FACT}[DECIMAL(12,2)]
MAINWAITER[INT4] -> fact.orders.mainwaiter{FACT}[INT]
GUIDSTRING[VARCHAR(38)] -> label.orders.guidstring{LABEL}[VARCHAR(38)]
UOT[INT4] -> fact.orders.uot{FACT}[INT]
TABLEID[INT4] -> fact.orders.tableid{FACT}[INT]
IBASICCURRENCY[INT4] -> fact.orders.ibasiccurrency{FACT}[INT]
INATIONALCURRENCY[INT4] -> fact.orders.inationalcurrency{FACT}[INT]
IDENTINVISIT[INT4] -> label.orders.identinvisit{LABEL}[INT]
FLAGS[INT4] -> fact.orders.flags{FACT}[INT]
MIDSERVER[INT4] -> label.orders.midserver{LABEL}[INT]
IAUTHORROLE[INT4] -> fact.orders.iauthorrole{FACT}[INT]
TOPAYSUM[NUMERIC(12,2)] -> fact.orders.topaysum{FACT}[DECIMAL(12,2)]
ICREATOR[INT4] -> fact.orders.icreator{FACT}[INT]
STARTSERVICE[TIMESTAMP] -> startservice{DATE}[DATE]
CRC32[INT4] -> fact.orders.crc32{FACT}[INT]
TOTALDISHPIECES[FLOAT8] -> fact.orders.totaldishpieces{FACT}[DECIMAL(12,2)]
COT[INT4] -> fact.orders.cot{FACT}[INT]
ENDSERVICE[TIMESTAMP] -> endservice{DATE}[DATE]
ISBANQUET[INT2] -> fact.orders.isbanquet{FACT}[INT]
DURATION[INT4] -> fact.orders.duration{FACT}[INT]
FISCORDERSTATE[INT2] -> fact.orders.fiscorderstate{FACT}[INT]
PAID[INT2] -> fact.orders.paid{FACT}[INT]
INVOICEUNI[INT4] -> fact.orders.invoiceuni{FACT}[INT]
ILASTUSER[INT4] -> fact.orders.ilastuser{FACT}[INT]
GUESTSCOUNT[INT4] -> fact.orders.guestscount{FACT}[INT]
BRIGADE[INT4] -> fact.orders.brigade{FACT}[INT]
UNCLOSEDPREPAYSUM[NUMERIC(12,2)] -> fact.orders.unclosedprepaysum{FACT}[DECIMAL(12,2)]
BANQUETSTATE[INT4] -> fact.orders.banquetstate{FACT}[INT]
PROMOCODE[VARCHAR(40)] -> label.orders.promocode{LABEL}[VARCHAR(40)]
PAIDSUM[NUMERIC(12,2)] -> fact.orders.paidsum{FACT}[DECIMAL(12,2)]
LASTSERVICE[TIMESTAMP] -> lastservice{DATE}[DATE]
NUMONTABLE[VARCHAR(255)] -> label.orders.numontable{LABEL}[VARCHAR(255)]
ORDERNAME[VARCHAR(12)] -> label.orders.ordername{LABEL}[VARCHAR(12)]
ICREATORROLE[INT4] -> fact.orders.icreatorrole{FACT}[INT]
IAUTHOR[INT4] -> fact.orders.iauthor{FACT}[INT]
STATIONID[INT4] -> fact.orders.stationid{FACT}[INT]
DBSTATUS[INT4] -> fact.orders.dbstatus{FACT}[INT]
TABLENAME[VARCHAR(15)] -> label.orders.tablename{LABEL}[VARCHAR(15)]
UNCLOSEDPRICESUM[NUMERIC(12,2)] -> fact.orders.unclosedpricesum{FACT}[DECIMAL(12,2)]
SEQNUMBER[INT4] -> fact.orders.seqnumber{FACT}[INT]
PRICELISTSUM[NUMERIC(12,2)] -> fact.orders.pricelistsum{FACT}[DECIMAL(12,2)]
ICOMMONSHIFT[INT4] -> fact.orders.icommonshift{FACT}[INT]
ORIGINALORDERID[INT4] -> fact.orders.originalorderid{FACT}[INT]
STATE[INT2] -> fact.orders.state{FACT}[INT]
FINISHEDSERVICE[INT2] -> fact.orders.finishedservice{FACT}[INT]
OPENTIME[TIMESTAMP] -> opentime{DATE}[DATE]
TRANSACT_GUID[VARCHAR(38)] -> label.orders.transact_guid{LABEL}[VARCHAR(38)]

====================== End of Output Stage -> LDM mapping ======================


2022-02-15T09:36:32.850+0100 [INFO]: 

====================== Data distribution scope ======================


2022-02-15T09:36:32.850+0100 [INFO]: Project="ryb7b4w3ggb357tlhmeannhdnp0yllje"; datasets=[{dataset.orders, full}]
2022-02-15T09:36:32.850+0100 [INFO]: 

====================== End of Data distribution scope ======================


2022-02-15T09:36:32.850+0100 [INFO]: 

====================== Downloading and integrating data ======================


2022-02-15T09:37:08.004+0100 [INFO]: Data for project="ryb7b4w3ggb357tlhmeannhdnp0yllje" was downloaded. Datasets: [{dataset.orders, upsert, rows=134210, size=42367999 bytes}]
2022-02-15T09:37:13.021+0100 [WARN]: Project "ryb7b4w3ggb357tlhmeannhdnp0yllje" was not integrated. Reason: Date (time) 1899-12-30 00:00:00 (parsed as [y=1899,m=12,d=30]) is badly formatted or is out of supported limits (strptime format: %Y-%m-%d) in orders.csv at line 4
2022-02-15T09:37:23.028+0100 [INFO]: 

====================== End of downloading and integrating data ======================


2022-02-15T09:37:23.029+0100 [ERROR]: Data distribution worker failed. Reason: All projects failed to load.
Screen Shot 2022-02-22 at 14.48.54.png
m
Hi Jade, I see there is a date field out of the supported range. You will need to fix it so the loading can finish successfully:
Copy code
Reason: Date (time) 1899-12-30 00:00:00 (parsed as [y=1899,m=12,d=30]) is badly formatted or is out of supported limits (strptime format: %Y-%m-%d) in orders.csv at line 4
The supported range is: 1900-01-01 to 2050-12-31.
j
I see, let me check in again