support@anygate.com
02 6256 5500Database Conversion Errors
Posted 2024-03-22 오후 6:44:00 · 관리자
Dear customer.
Sorry for inconvenience. below are my opinion and background knowwledge.
- I assume that you are converting file db(sqlite) to maria db for your project.
- We changed field size of 'description' and 'name' from 50 to 129 for maria db and mssql at most tables like [scada_analog, scada_status.]
- File db (SQLite) is not strict for checking data field size. So some data may be overflowed when converting data from file db to maria db.
- For those error, you may better to modify your source db`s data fitting in 129 size. (I changed discription and name field`s size to 129 for maria db)
2024-03-21 12:31:26 : Processing table : scada_status (121/168)
2024-03-21 12:31:26 : Reading table data count...
2024-03-21 12:31:26 : Copying table data...
2024-03-21 12:31:26 : Data too long for column 'description' at row 1
2024-03-21 12:31:26 : Reading table data count...
2024-03-21 12:31:26 : Copying table data...
2024-03-21 12:31:26 : Data too long for column 'description' at row 1
2024-03-21 12:31:26 : Processing table : scada_calculation (120/168)
2024-03-21 12:31:26 : Reading table data count...
2024-03-21 12:31:26 : Copying table data...
2024-03-21 12:31:26 : Data too long for column 'description' at row 1
2024-03-21 12:31:26 : Reading table data count...
2024-03-21 12:31:26 : Copying table data...
2024-03-21 12:31:26 : Data too long for column 'description' at row 1
- You can check maria db`s schema by creating new empty project, you can browse using mariadb db browser, and compare your origin data`s field size.
- For your data(core_dc_month_statistics), you should check you data`s size. a Query table is good for viewing custom data. you can put query to table and then you can see db data.
This is sample project for Query table : Link
This is answer for your question.
Q. HMI is not opening the same project
-> Which version do you user? PowerScene Lite or PowerScene Network? If Powerscene server running background, you can`t run another project.
Here is manual , how to run powerscene( in korean language), you may ask your korean colleauge(sorry)
Q. I also tried on another PC, in this case, it simply crashes without providing an error message.
-> To run powerscene, you must install PowerScene at first not using patch. Patch just is for update, So if you want to use powerscene another computer,
Please install at first and then, you can simply update powerscene using patch file.
I test more than 20 file db project converting from file db to maria db and i fixed some problems. I attach patch file and install file too.
Please try new patch version and if you still have problem,
I hope you provide your database file for fixing conversion problem.
Here is new link:)
PowerScene Lite Install for Py3 PowerSceneLiteSetup_x64_py3.exe
PowerScene Network Install for Py3 : PowerSceneSetup_x64_py3.exe
If you have problem, please let us know,
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
