unable to cast object of type stackexchangeprofilingdataprofileddbtransaction to type systemdatasqlclientsqltransaction

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

João 3 posts 94 karma points

Oct 18, 2018 @ 10:51
0

Unable to cast object of type 'StackExchange.Profiling.Data.ProfiledDbTransaction' to type 'System.Data.SqlClient.SqlTransaction'.
Hello!

I upgraded umbraco from 7.5.7 to 7.12.3, and suddenly my logs are filled with the error:
```
umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader ---> System.InvalidCastException: Unable to cast object of type 'StackExchange.Profiling.Data.ProfiledDbTransaction' to type 'System.Data.SqlClient.SqlTransaction'.
   at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters)
   at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
```
I have checked on github and it seems that on version 7.6 it was added some specifications on the type of the profiling transaction -> https://github.com/umbraco/Umbraco-CMS/commit/ab3b04c1659006006f781a7b72e483b18981d5d2

The error is being thrown from here https://github.com/umbraco/Umbraco-CMS/blob/release-7.12.3/src/umbraco.datalayer/SqlHelpers/SqlServer/SqlServerHelper.cs#L107

Does anyone knows what this is about and a way to fix it?

Thanks!
Copy Link

João 3 posts 94 karma points

Oct 19, 2018 @ 13:05

After trying to fix this, I reached a different error with the same underlying cause:

 2018-10-19 15:03:29,897 [P1744/D2/T69] ERROR umbraco.DataLayer.SqlHelper`1[[System.Data.SqlClient.SqlParameter, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] - Error executing query SELECT versionId FROM cmsDocument where nodeid=36757 AND newest = 1 ORDER BY updateDate desc
System.InvalidCastException: Unable to cast object of type 'StackExchange.Profiling.Data.ProfiledDbTransaction' to type 'System.Data.SqlClient.SqlTransaction'.
   at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters) in C:\Dev\Umbraco-CMS\src\umbraco.datalayer\SqlHelpers\SqlServer\SqlServerHelper.cs:line 105
   at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) in C:\Dev\Umbraco-CMS\src\umbraco.datalayer\SqlHelper.cs:line 254
 2018-10-19 15:03:29,897 [P1744/D2/T69] ERROR Umbraco.Core.Sync.DatabaseServerMessenger - DISTRIBUTED CACHE IS NOT UPDATED. Failed to execute instructions (id: 45, instruction count: 1). Instruction is being skipped/ignored
umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader ---> System.InvalidCastException: Unable to cast object of type 'StackExchange.Profiling.Data.ProfiledDbTransaction' to type 'System.Data.SqlClient.SqlTransaction'.
   at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters) in C:\Dev\Umbraco-CMS\src\umbraco.datalayer\SqlHelpers\SqlServer\SqlServerHelper.cs:line 105
   at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) in C:\Dev\Umbraco-CMS\src\umbraco.datalayer\SqlHelper.cs:line 254
   --- End of inner exception stack trace ---
   at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) in C:\Dev\Umbraco-CMS\src\umbraco.datalayer\SqlHelper.cs:line 259
   at umbraco.cms.businesslogic.Content.get_Version()
   at umbraco.cms.businesslogic.web.Document.setupNode()
   at umbraco.content.UpdateDocumentCache(Int32 pageId)
   at Umbraco.Web.Cache.PageCacheRefresher.Refresh(Int32 id)

Because of this I'm unable to publish consistently...

Copy Link

João 3 posts 94 karma points

Oct 19, 2018 @ 16:00

101

For anyone suffering from the same issue, I solved by looking at the connection properties, to try and find one that was castable

https://github.com/Mindbus/Umbraco-CMS/commit/985a6146126567e442c51ae7ed84d44801c9385f

Basically I'm getting served a connection that isn't castable on that point. Still haven't figured out why though...

Copy Link
Alex Skrypnyk 6182 posts 24284 karma points MVP 8x admin c-trib

Oct 19, 2018 @ 20:07

0

Hi João

Thanks for sharing.

Alex

Copy Link
Luis Paulo Silva 2 posts 74 karma points

Oct 22, 2018 @ 09:34

1

Great Job @João! Lets just wait for Umbraco to make an official fix (or use the workaround you made)

Copy Link
is working on a reply...

This forum is in read-only mode while we transition to the new forum.

You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies