topic Re: Internal database error: Library used incorrectly. SQLite Error Code=21. in Service

Internal database error: Library used incorrectly. SQLite Error Code=21.

Anonymous — Thu, 20 Dec 2018 23:02:12 GMT

Starting yesterday most of our Power BI report refreshes are failing with the following reason. This is happening to multiple reports in the workspace. The report refreshes used to work perfectly till now.

Internal database error: Library used incorrectly. SQLite Error Code=21. An error occurred while attempting to insert a row into the system table 'Table' in the metadata database.

The data source is SQL Server 2016. Any idea why this could be happening?

The workspace is on P1 capacity. The reports refresh fine on desktop.

Thanks

Re: Internal database error: Library used incorrectly. SQLite Error Code=21.

Anonymous — Mon, 24 Dec 2018 02:10:49 GMT

Hi Anonymous,

I think you are working with SSAS data source and third party sqlite connector, right?

If this is a case, I think this issue should more related to sqlite itself, you can post to sqlite related forum to get better support.

In addition, you can also take a look at following link with same error message:
Unable to Deploy Cubes - Error : Failed to save modifications to the server. Error returned: 'Internal database error: Library used incorrectly. SQLite Error Code=21. An error occurred while attempting to delete a row from the system table 'Table' in the

Regards,

Xiaoxin Sheng

Re: Internal database error: Library used incorrectly. SQLite Error Code=21.

Anonymous — Mon, 24 Dec 2018 02:26:14 GMT

Anonymous

We are not using SSAS and neither a third party SQL lite connector. All the affected reports are using SQL Server 2016 as the data source and models are import based.

Re: Internal database error: Library used incorrectly. SQLite Error Code=21.

Anonymous — Wed, 26 Dec 2018 07:57:14 GMT

HI Anonymous,

Is there any update on your sql server environment? I can't reproduce this on my side, it works when you test with sql 2016.

Can you please open a support ticket to get better support from power bi team? It is free for pro and above licenses.

Regards,
Xiaoxin Sheng

Re: Internal database error: Library used incorrectly. SQLite Error Code=21.

jibanez — Mon, 08 Jul 2019 13:57:31 GMT

I'm having the same problem. I would appreciate any answer