- Posts: 4
- Thank you received: 0
Empty Data fields have default value 0000-00-00
- m.hochstrasser
- Topic Author
- Offline
- New Member
-
Less
More
8 years 2 weeks ago #13633
by m.hochstrasser
Empty Data fields have default value 0000-00-00 was created by m.hochstrasser
If I pull data from a system A and this hand over to the B system, empty data fields by default in the SQL database is set to 0000-00-00.
The value must have NULL in the data fields, if nothing is transmitted.
Is the configuration not ok or it's a bug.
Thanks for your help and answer
The value must have NULL in the data fields, if nothing is transmitted.
Is the configuration not ok or it's a bug.
Thanks for your help and answer
Please Log in or Create an account to join the conversation.
- Peter.Jonson
-
- Offline
- Platinum Member
-
8 years 2 weeks ago #13634
by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic Empty Data fields have default value 0000-00-00
Are you working with MS SQL server?
(Please read the forum rules)
(Please read the forum rules)
Peter Jonson
ETL Developer
Please Log in or Create an account to join the conversation.
- m.hochstrasser
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 4
- Thank you received: 0
8 years 2 weeks ago #13636
by m.hochstrasser
Replied by m.hochstrasser on topic Empty Data fields have default value 0000-00-00
Application Name: Advanced ETL Processor Entreprise Version: 5.8.2.13
Windows Server 2008 R2 x64
It's a MySQL Database.
The Problem was detected after the update from AdvancedETLEnt5.8.0.16 to AdvancedETLEnt5.8.2.10
We have *.xls and *.csv imported and after the transformation wrote the value 0000-00-00 in the date field in the database. Before was the entry "NULL" in the data field.
Windows Server 2008 R2 x64
It's a MySQL Database.
The Problem was detected after the update from AdvancedETLEnt5.8.0.16 to AdvancedETLEnt5.8.2.10
We have *.xls and *.csv imported and after the transformation wrote the value 0000-00-00 in the date field in the database. Before was the entry "NULL" in the data field.
Please Log in or Create an account to join the conversation.
- Peter.Jonson
-
- Offline
- Platinum Member
-
8 years 2 weeks ago #13644
by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic Empty Data fields have default value 0000-00-00
Can you try latest version please
Peter Jonson
ETL Developer
Please Log in or Create an account to join the conversation.
- m.hochstrasser
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 4
- Thank you received: 0
8 years 2 weeks ago #13648
by m.hochstrasser
Replied by m.hochstrasser on topic Empty Data fields have default value 0000-00-00
I have tested this with the version AdvancedETLPro5.8.2.19. The problem is not solved. See you at the Printscreen 0000-00-00.jpg.
Please Log in or Create an account to join the conversation.
8 years 2 weeks ago #13649
by admin
Mike
ETL Architect
Replied by admin on topic Empty Data fields have default value 0000-00-00
Can you try latest version please
5.8.2.20
- Addressed issues with loading empty date fields into MySQL
- Addressed issues with Split Transformation Function
5.8.2.20
- Addressed issues with loading empty date fields into MySQL
- Addressed issues with Split Transformation Function
Mike
ETL Architect
Please Log in or Create an account to join the conversation.