Dimension mismatch for inserted vector for the "embedding" column

Problem/Motivation

When trying to index the content it gives this error:

Drupal\ai_vdb_provider_sqlite\Exception\InsertIntoCollectionException: Dimension mismatch for inserted vector for the "embedding" column. Expected 1 dimensions but received 768. in Drupal\ai_vdb_provider_sqlite\SQLiteVectorClient->insertIntoCollection() (line 200 of ai_vdb_provider_sqlite/src/SQLiteVectorClient.php).

Steps to reproduce

Set up an index using sqlite.
Try to index the content.

Proposed resolution

Work out whether this is a configuration issue or a code issue, then either document the issue or fix the bug.

Remaining tasks

Work out the appropriate setup.
Resolve it.

User interface changes

Indexing content works as expected.

API changes

TBD

Data model changes

TBD