Issue

I am receiving the following error message, while trying to load an A2L file.

tts.core.dataViewer.DataManager.__UpdateApplicationObject: (sqlite3.DatabaseError) database disk image is malformed
[SQL: INSERT INTO coding_items (name, base_data_type, byte_order, bit_length, parent_file, long_identifier) VALUES (?, ?, ?, ?, ?, ?)]
[parameters: ('ECU_VALUE_NAME', 'FLOAT', -1, 0, 15, None)]
(Background on this error at: http://sqlalche.me/e/4xp6)

Error when parsing the A2L file (ECU: SOME_ECU_NAME): (sqlite3.DatabaseError) database disk image is malformed
[SQL: INSERT INTO coding_items (name, base_data_type, byte_order, bit_length, parent_file, long_identifier) VALUES (?, ?, ?, ?, ?, ?)]
[parameters: ('ECU_VALUE_NAME', 'FLOAT', -1, 0, 15, None)]
(Background on this error at: http://sqlalche.me/e/4xp6)

Traceback (most recent call last):
  File ".\Lib\site-packages\sqlalchemy\engine\base.py", line 1249, in _execute_context
  File ".\Lib\site-packages\sqlalchemy\engine\default.py", line 580, in do_execute
sqlite3.DatabaseError: database disk image is malformed
                        
The above exception was the direct cause of the following exception:
                        
Traceback (most recent call last):
  File "tts\core\dataViewer\DataManager.py", line 250, in __UpdateApplicationObject
  File "tts\testModule\measCalib\DoA2l.py", line 67, in QueryA2lData
  File "tts\testModule\measCalib\DoA2l.py", line 148, in __GetA2lDataByParsing
  File "tts\testModule\measCalib\parser\a2l\A2lLoader.py", line 46, in Parse
  File "tts\testModule\measCalib\parser\a2l\A2lLoader.py", line 171, in __ParseFile
  File "tts\testModule\measCalib\parser\a2l\A2lLoader.py", line 400, in ProcessLine
  File "tts\core\dataViewer\DBAccess.py", line 442, in InsertToDb
  File "tts\core\dataViewer\DBAccess.py", line 436, in CommitChanges
  File ".\Lib\site-packages\sqlalchemy\orm\session.py", line 1027, in commit
  File ".\Lib\site-packages\sqlalchemy\orm\session.py", line 494, in commit
  File ".\Lib\site-packages\sqlalchemy\orm\session.py", line 473, in _prepare_impl
  File ".\Lib\site-packages\sqlalchemy\orm\session.py", line 2470, in flush
  File ".\Lib\site-packages\sqlalchemy\orm\session.py", line 2608, in _flush
  File ".\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 68, in __exit__
  File ".\Lib\site-packages\sqlalchemy\util\compat.py", line 153, in reraise
  File ".\Lib\site-packages\sqlalchemy\orm\session.py", line 2568, in _flush
  File ".\Lib\site-packages\sqlalchemy\orm\unitofwork.py", line 419, in execute
  File ".\Lib\site-packages\sqlalchemy\orm\unitofwork.py", line 521, in execute_aggregate
  File ".\Lib\site-packages\sqlalchemy\orm\unitofwork.py", line 589, in execute
  File ".\Lib\site-packages\sqlalchemy\orm\persistence.py", line 245, in save_obj
  File ".\Lib\site-packages\sqlalchemy\orm\persistence.py", line 1137, in _emit_insert_statements
  File ".\Lib\site-packages\sqlalchemy\engine\base.py", line 988, in execute
  File ".\Lib\site-packages\sqlalchemy\sql\elements.py", line 287, in _execute_on_connection
  File ".\Lib\site-packages\sqlalchemy\engine\base.py", line 1107, in _execute_clauseelement
  File ".\Lib\site-packages\sqlalchemy\engine\base.py", line 1253, in _execute_context
  File ".\Lib\site-packages\sqlalchemy\engine\base.py", line 1473, in _handle_dbapi_exception
  File ".\Lib\site-packages\sqlalchemy\util\compat.py", line 398, in raise_from_cause
  File ".\Lib\site-packages\sqlalchemy\util\compat.py", line 152, in reraise
  File ".\Lib\site-packages\sqlalchemy\engine\base.py", line 1249, in _execute_context
  File ".\Lib\site-packages\sqlalchemy\engine\default.py", line 580, in do_execute
sqlalchemy.exc.DatabaseError: (sqlite3.DatabaseError) database disk image is malformed
SQL: INSERT INTO coding_items (name, base_data_type, byte_order, bit_length, parent_file, long_identifier) VALUES (?, ?, ?, ?, ?, ?)]
[parameters: ('ECU_VALUE_NAME', 'FLOAT', -1, 0, 15, None)]
(Background on this error at: http://sqlalche.me/e/4xp6)

Solution

The database is corrupted. In order to solve this you need to delete the A2L cache on your system.

Please navigate to the following path (C:\Users\USER\AppData\Roaming\TraceTronic\) and look into the subfolder of your respective ecu.test version.

Inside you find data_cache_a2l.sdb.

Delete this file and try to start the configuration in ecu.test again.

[A2L] Cache error

Issue

Solution