Database Conversion Errors
Posted 2024-03-19 오후 5:26:41 · 관리자
Dear our customer,
We are sorry for making inconvenience.
We will try to find problem as soon as possible,
After solving problem, we will notify you soon.
Thanks
-------------------------------------------------------------
Dear Anygate,
It appears that the database converter assumes the length of data when creating the new tables in the exported database. This causes "Data too long for column '{col}' at row 1" errors during export. This is a common problem with calculation formulas (8000 char) and descriptions (50 char). It is not hard to exceed 50 characters for a point description. Our database in PowerScene has a 256 character limit for descriptions, but when we export/convert the database, the new database shows a limit of 50 characters, resulting in many export errors.
We also encounter this error for some tables: "No data supplied for parameters in prepared statement."
We have a MariaDB license.
Thank you,
RPE