Roku Developer Program

[EnTerr]

Tonight Roku's web services are in SNAFU mode. DB time-outs for developer site. Here is for posterity the exact errors on couple of pages:

[spoiler=owner.roku.com_Developer_Apps:8jna3v4c]

Server Error in '/' Application.

Transaction Timeout

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.TimeoutException: Transaction Timeout

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace: 


[TimeoutException: Transaction Timeout]

[TransactionException: The operation is not valid for the state of the transaction.]
   System.Transactions.TransactionState.EnlistVolatile(InternalTransaction tx, IEnlistmentNotification enlistmentNotification, EnlistmentOptions enlistmentOptions, Transaction atomicTransaction) +53
   System.Transactions.Transaction.EnlistVolatile(IEnlistmentNotification enlistmentNotification, EnlistmentOptions enlistmentOptions) +281
   NHibernate.Transaction.AdoNetWithDistributedTransactionFactory.EnlistInDistributedTransactionIfNeeded(ISessionImplementor session) +469
   NHibernate.Impl.SessionImpl.get_Batcher() +23
   NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) +568
   NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +273
   NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +205
   NHibernate.Loader.Loader.LoadCollection(ISessionImplementor session, Object id, IType type) +452

[GenericADOException: could not initialize a collection: [ASDomain.Data.ChannelDetail.Localizations#49f491ae-0e98-435b-9d52-a4d800b00d08][SQL: SELECT localizati0_.channel_detail_id as channel16_2_, localizati0_.id as id2_, localizati0_.id as id42_1_, localizati0_.name as name42_1_, localizati0_.description as descript3_42_1_, localizati0_.web_description as web4_42_1_, localizati0_.hd_poster_url as hd5_42_1_, localizati0_.screenshots as screensh6_42_1_, localizati0_.fhd_screenshots as fhd7_42_1_, localizati0_.uhd_screenshots as uhd8_42_1_, localizati0_.sd_poster_url as sd9_42_1_, localizati0_.short_description as short10_42_1_, localizati0_.is_default as is11_42_1_, localizati0_.alt_detail_url as alt12_42_1_, localizati0_.keywords as keywords42_1_, localizati0_.fhd_poster_url as fhd14_42_1_, localizati0_.uhd_poster_url as uhd15_42_1_, localizati0_.channel_detail_id as channel16_42_1_, localizati0_.culture_id as culture17_42_1_, culture1_.id as id59_0_, culture1_.culture_code as culture2_59_0_, culture1_.deleted as deleted59_0_, culture1_.description as descript4_59_0_, culture1_.resource_code as resource5_59_0_ FROM channel_localizations localizati0_ left outer join cultures culture1_ on localizati0_.culture_id=culture1_.id WHERE localizati0_.channel_detail_id=?]]
   NHibernate.Loader.Loader.LoadCollection(ISessionImplementor session, Object id, IType type) +776
   NHibernate.Event.Default.DefaultInitializeCollectionEventListener.OnInitializeCollection(InitializeCollectionEvent event) +597
   NHibernate.Impl.SessionImpl.InitializeCollection(IPersistentCollection collection, Boolean writing) +370
   ASDomain.Biz.<>c__DisplayClass118.<GetDeveloperChannels>b__115(RoTransactionDirDB dir) in c:\Users\netops\workspace\channelStore-Upright\web\appstore\upright\ASDomain\Biz\ChannelShared.cs:1961
   Shared.Framework.Transactions.TransactionRunner.InnerRunTransaction(TX tx, Func`2 func) in c:\Users\netops\workspace\channelStore-Upright\web\appstore\upright\Shared\Shared\Framework\Transactions\TransactionRunner.cs:105
   Web.Infrastructure.Storage.RokuChannelService.GetDeveloperChannels(String userid) in c:\Users\netops\workspace\channelStore-Upright\web\appstore\upright\owner.roku.com\Infrastructure\Storage\RokuChannelService.cs:52
   Web.Infrastructure.Storage.DeveloperService.<AllChannels>b__35() in c:\Users\netops\workspace\channelStore-Upright\web\appstore\upright\owner.roku.com\Infrastructure\Storage\DeveloperService.cs:659
   Web.Infrastructure.Utility.CacheUtility.GetFromRequestCache(Func`1 func, String key) in c:\Users\netops\workspace\channelStore-Upright\web\appstore\upright\owner.roku.com\Infrastructure\Utility\CacheUtility.cs:23
   Web.Infrastructure.Storage.DeveloperService.get_AllChannelsViewModel() in c:\Users\netops\workspace\channelStore-Upright\web\appstore\upright\owner.roku.com\Infrastructure\Storage\DeveloperService.cs:736
   Web.Areas.Developer.Controllers.AppsController.Index() in c:\Users\netops\workspace\channelStore-Upright\web\appstore\upright\owner.roku.com\Areas\Developer\Controllers\AppsController.cs:53
   lambda_method(Closure , ControllerBase , Object[] ) +81
   System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +274
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +39
   System.Web.Mvc.Async.<>c__DisplayClass39.<BeginInvokeActionMethodWithFilters>b__33() +120
   System.Web.Mvc.Async.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49() +452
   System.Web.Mvc.Async.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49() +452
   System.Web.Mvc.Async.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49() +452
   System.Web.Mvc.Async.<>c__DisplayClass37.<BeginInvokeActionMethodWithFilters>b__36(IAsyncResult asyncResult) +15
   System.Web.Mvc.Async.<>c__DisplayClass2a.<BeginInvokeAction>b__20() +33
   System.Web.Mvc.Async.<>c__DisplayClass25.<BeginInvokeAction>b__22(IAsyncResult asyncResult) +240
   System.Web.Mvc.<>c__DisplayClass1d.<BeginExecuteCore>b__18(IAsyncResult asyncResult) +28
   System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +15
   System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +53
   System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +15
   System.Web.Mvc.<>c__DisplayClass8.<BeginProcessRequest>b__3(IAsyncResult asyncResult) +42
   System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +15
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +606
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +288

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34280

[/spoiler:8jna3v4c]
[spoiler=owner.roku.com_Developer_Apps_Details_9999:8jna3v4c]

Server Error in '/' Application.

The wait operation timed out

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.ComponentModel.Win32Exception: The wait operation timed out

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace: 


[Win32Exception (0x80004005): The wait operation timed out]

[SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +6675958
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +688
   System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) +689
   System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() +249
   System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() +48
   System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() +64
   System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) +114
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +951
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +82
   System.Data.SqlClient.SqlDataReader.get_MetaData() +135
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6665901
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) +6667768
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +577
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +107
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +288
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +180
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +23
   NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) +845
   NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) +600
   NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +273
   NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +205
   NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister) +481

[GenericADOException: could not load an entity: [ASDomain.Data.Currency#1f771257-32b5-4f37-bac0-79eb96c46384][SQL: SELECT currency0_.id as id60_0_, currency0_.code as code60_0_, currency0_.description as descript3_60_0_, currency0_.resource_code as resource4_60_0_ FROM currencies currency0_ WHERE currency0_.id=?]]
   NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Object id, IType identifierType, Object optionalObject, String optionalEntityName, Object optionalIdentifier, IEntityPersister persister) +842
   NHibernate.Loader.Entity.AbstractEntityLoader.Load(ISessionImplementor session, Object id, Object optionalObject, Object optionalId) +76
   NHibernate.Loader.Entity.AbstractEntityLoader.Load(Object id, Object optionalObject, ISessionImplementor session) +31
   NHibernate.Event.Default.DefaultLoadEventListener.LoadFromDatasource(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) +173
   NHibernate.Event.Default.DefaultLoadEventListener.Load(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) +181
   NHibernate.Event.Default.DefaultLoadEventListener.OnLoad(LoadEvent event, LoadType loadType) +1190
   NHibernate.Impl.SessionImpl.FireLoad(LoadEvent event, LoadType loadType) +402
   NHibernate.Impl.SessionImpl.ImmediateLoad(String entityName, Object id) +445
   NHibernate.Proxy.AbstractLazyInitializer.Initialize() +122
   ListExtensions.ForEach(IEnumerable`1 collection, Action`1 action) in c:\Users\netops\workspace\channelStore-Upright\web\appstore\upright\Common\Utils\Presentation\ListExtensions.cs:12
   ASDomain.Biz.<>c__DisplayClass118.<GetDeveloperChannels>b__115(RoTransactionDirDB dir) in c:\Users\netops\workspace\channelStore-Upright\web\appstore\upright\ASDomain\Biz\ChannelShared.cs:1964
   Shared.Framework.Transactions.TransactionRunner.InnerRunTransaction(TX tx, Func`2 func) in c:\Users\netops\workspace\channelStore-Upright\web\appstore\upright\Shared\Shared\Framework\Transactions\TransactionRunner.cs:105
   Web.Infrastructure.Storage.RokuChannelService.GetDeveloperChannels(String userid) in c:\Users\netops\workspace\channelStore-Upright\web\appstore\upright\owner.roku.com\Infrastructure\Storage\RokuChannelService.cs:52
   Web.Infrastructure.Storage.DeveloperService.<AllChannels>b__35() in c:\Users\netops\workspace\channelStore-Upright\web\appstore\upright\owner.roku.com\Infrastructure\Storage\DeveloperService.cs:659
   Web.Infrastructure.Utility.CacheUtility.GetFromRequestCache(Func`1 func, String key) in c:\Users\netops\workspace\channelStore-Upright\web\appstore\upright\owner.roku.com\Infrastructure\Utility\CacheUtility.cs:23
   Web.Areas.Developer.Controllers.AppsController.Details(Int32 id) in c:\Users\netops\workspace\channelStore-Upright\web\appstore\upright\owner.roku.com\Areas\Developer\Controllers\AppsController.cs:61
   lambda_method(Closure , ControllerBase , Object[] ) +115
   System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +274
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +39
   System.Web.Mvc.Async.<>c__DisplayClass39.<BeginInvokeActionMethodWithFilters>b__33() +120
   System.Web.Mvc.Async.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49() +452
   System.Web.Mvc.Async.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49() +452
   System.Web.Mvc.Async.<>c__DisplayClass37.<BeginInvokeActionMethodWithFilters>b__36(IAsyncResult asyncResult) +15
   System.Web.Mvc.Async.<>c__DisplayClass2a.<BeginInvokeAction>b__20() +33
   System.Web.Mvc.Async.<>c__DisplayClass25.<BeginInvokeAction>b__22(IAsyncResult asyncResult) +240
   System.Web.Mvc.<>c__DisplayClass1d.<BeginExecuteCore>b__18(IAsyncResult asyncResult) +28
   System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +15
   System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +53
   System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +15
   System.Web.Mvc.<>c__DisplayClass8.<BeginProcessRequest>b__3(IAsyncResult asyncResult) +42
   System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +15
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +606
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +288

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34280

[/spoiler:8jna3v4c]

Additionally, the "Streaming Channels" on Roku players does not work, shows "The Roku Channel Store service is currently unavailable. Please try again later."