Error message: Error executing query: Telerik.OpenAccess.RT.sql.SQLException: Conversion failed when converting from a character string to uniqueidentifier. ---> System.Data.SqlClient.SqlException: Conversion failed when converting from a character string to uniqueidentifier. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at OpenAccessRuntime.Intellitrace.Read(DbDataReader reader, String id) at Telerik.OpenAccess.Runtime.Logging.LoggingDbDataReader.Read() at Telerik.OpenAccess.RT.Adonet2Generic.Impl.BufferingReader.ReadNext() --- End of inner exception stack trace --- at Telerik.OpenAccess.RT.Adonet2Generic.Impl.BufferingReader.ReadNext() at Telerik.OpenAccess.RT.Adonet2Generic.Impl.BufferingReader.EnsureRead(Int32 rdpos) at Telerik.OpenAccess.RT.Adonet2Generic.Impl.BufferingReader.SetConverter(ConverterUsage[] usages) at Telerik.OpenAccess.RT.Adonet2Generic.Impl.ResultSetImp.SetConverter(ConverterUsage[] c) at OpenAccessRuntime.Relational.fetch.FetchResultImp.SetResultSet(ResultSet aRs) at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute() SQL: SELECT a.[base_id] AS COL1, b.[voa_class] AS COL2, a.[Bio] AS COL3, a.[bio_en] AS COL4, a.[ContactInformation] AS COL5, a.[contact_information_en] AS COL6, a.[FirstName] AS COL7, a.[first_name_de] AS COL8, a.[first_name_en] AS COL9, a.[first_name_es] AS COL10, a.[first_name_fr] AS COL11, a.[first_name_it] AS COL12, a.[first_name_ja] AS COL13, a.[first_name_nl] AS COL14, a.[first_name_pl] AS COL15, a.[first_name_pt_br] AS COL16, a.[first_name_ru] AS COL17, a.[first_name_tr] AS COL18, a.[first_name_zh] AS COL19, a.[LastName] AS COL20, a.[last_name_en] AS COL21, b.[approval_workflow_state_] AS COL22, b.[approval_workflow_state_en] AS COL23, b.[item_default_url_] AS COL24, b.[item_default_url_en] AS COL25, b.[url_name_] AS COL26, b.[url_name_en] AS COL27, b.[application_name] AS COL28, b.[can_inherit_permissions] AS COL29, b.[date_created] AS COL30, b.[expiration_date] AS COL31, b.[include_in_sitemap] AS COL32, b.[inherits_permissions] AS COL33, b.[last_modified] AS COL34, b.[last_modified_by] AS COL35, b.[original_content_id] AS COL36, b.[ownr] AS COL37, b.[publication_date] AS COL38, b.[status] AS COL39, b.[system_parent_id] AS COL40, b.[system_parent_id] AS COL41, b.[system_parent_type] AS COL42, b.[vrsion] AS COL43, b.[visible] AS COL44, b.[was_published] AS COL45, b.[voa_version] AS COL46 FROM [blogauthors_blogauthor] a JOIN [sf_dynamic_content] AS b ON (a.[base_id] = b.[base_id]) WHERE ((b.[inherits_permissions] <> 0 AND not (EXISTS (SELECT 1 FROM [sf_permissions] c JOIN [sf_dynmc_cntent_sf_permissions] AS d ON (c.[id] = d.[id]) WHERE c.[deny] % 2 <> 0 AND c.[object_id] <> b.[base_id] AND c.[set_name] = ? AND (c.[principal_id] IN (?,?,?)) AND d.[base_id] = b.[base_id])) AND EXISTS (SELECT 1 FROM [sf_permissions] e JOIN [sf_dynmc_cntent_sf_permissions] AS f ON (e.[id] = f.[id]) WHERE e.[grnt] > 0 AND e.[object_id] <> b.[base_id] AND e.[set_name] = ? AND (e.[principal_id] IN (?,?,?)) AND f.[base_id] = b.[base_id]) OR not (b.[inherits_permissions] <> 0) AND not (EXISTS (SELECT 1 FROM [sf_permissions] g JOIN [sf_dynmc_cntent_sf_permissions] AS h ON (g.[id] = h.[id]) WHERE g.[deny] % 2 <> 0 AND g.[object_id] = b.[base_id] AND g.[set_name] = ? AND (g.[principal_id] IN (?,?,?)) AND h.[base_id] = b.[base_id])) AND EXISTS (SELECT 1 FROM [sf_permissions] i JOIN [sf_dynmc_cntent_sf_permissions] AS j ON (i.[id] = j.[id]) WHERE i.[grnt] > 0 AND i.[object_id] = b.[base_id] AND i.[set_name] = ? AND (i.[principal_id] IN (?,?,?)) AND j.[base_id] = b.[base_id]))) AND b.[application_name] = ? AND b.[base_id] = '' AND b.[status] = 2 AND b.[visible] <> 0 ORDER BY COL1 Telerik.OpenAccess.RT.sql.SQLException: Conversion failed when converting from a character string to uniqueidentifier. ---> System.Data.SqlClient.SqlException: Conversion failed when converting from a character string to uniqueidentifier. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at OpenAccessRuntime.Intellitrace.Read(DbDataReader reader, String id) at Telerik.OpenAccess.Runtime.Logging.LoggingDbDataReader.Read() at Telerik.OpenAccess.RT.Adonet2Generic.Impl.BufferingReader.ReadNext() --- End of inner exception stack trace --- at Telerik.OpenAccess.RT.Adonet2Generic.Impl.BufferingReader.ReadNext() at Telerik.OpenAccess.RT.Adonet2Generic.Impl.BufferingReader.EnsureRead(Int32 rdpos) at Telerik.OpenAccess.RT.Adonet2Generic.Impl.BufferingReader.SetConverter(ConverterUsage[] usages) at Telerik.OpenAccess.RT.Adonet2Generic.Impl.ResultSetImp.SetConverter(ConverterUsage[] c) at OpenAccessRuntime.Relational.fetch.FetchResultImp.SetResultSet(ResultSet aRs) at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()
keyboard_arrow_up
rocket icon Quick Access Tools