Adding,Removing, and Repositing apps is not currently available

在Storefront使用远程数据库进行部署的时候，我们发现，当正常配置完成以后，我们会发现，从网页登陆以后，一直提示以下错误：

Adding,removing, and respositing apps is not currently available.Any changes you make will not be preserved for future sessions.Please contact your help desk.

在Event Log中，我们可以发现以下日志：

在检查了数据库的连接以后，发现数据库的连接也没有问题。而在检查Exception的时候发现，应该是在执行某些命令（ExecuteStoreCommands）的时候发生异常，而检查数据库表的时候，我们发现，storefront的数据库表下没有创建表，而手动创建了表以后，一切恢复正常。

所以，总结下来，storefront使用远程的数据库需要进行以下步骤：

1. 使用Management Studio创建数据库
2. 使用以下脚本创建对应的Table
   
   1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88

   /* 请替换下面的storefront为您自己的数据库的名称*/ USE [storefront]   /****** Object:  Table [dbo].[User]  ******/ SET ANSI_NULLS ON   SET QUOTED_IDENTIFIER ON   CREATE TABLE [dbo].[User]( [id] [int] IDENTITY(1,1) NOT NULL,     [username] [nvarchar](100) COLLATE latin1_general_CS_AS_KS NOT NULL, CONSTRAINT [PK_users] PRIMARY KEY CLUSTERED (     [id] ASC )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF) ON [PRIMARY] ) ON [PRIMARY]   CREATE UNIQUE NONCLUSTERED INDEX [username_idx] ON [dbo].[User] (     [username] ASC )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF) ON [PRIMARY]   /****** Object:  Table [dbo].[Subscription]  ******/ SET ANSI_NULLS ON   SET QUOTED_IDENTIFIER ON   CREATE TABLE [dbo].[Subscription]( [id] [int] IDENTITY(1,1) NOT NULL, [subscription_ref] [varchar](32) COLLATE latin1_general_CS_AS_KS NOT NULL,     [resource_id] [nvarchar](400) COLLATE latin1_general_CS_AS_KS NOT NULL, [user_id] [int] NOT NULL,     [status] [int] NOT NULL,     [metadata] [nvarchar](max) NULL,     [secure_metadata] [nvarchar](max) NULL, CONSTRAINT [PK_subscriptions] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF) ON [PRIMARY] ) ON [PRIMARY]   CREATE UNIQUE NONCLUSTERED INDEX [subscription_ref_idx] ON [dbo].[Subscription] ( [subscription_ref] ASC )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF) ON [PRIMARY]   CREATE NONCLUSTERED INDEX [user_resource_idx] ON [dbo].[Subscription] ( [user_id] ASC, [resource_id] ASC )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = OFF) ON [PRIMARY]   /****** Object:  Default [DF_subscriptions_status] ******/ ALTER TABLE [dbo].[Subscription] ADD  CONSTRAINT [DF_subscriptions_status]   DEFAULT ((0)) FOR [status]   /****** Object:  ForeignKey [FK_subscriptions_user_id] ******/ ALTER TABLE [dbo].[Subscription]   WITH CHECK ADD  CONSTRAINT [FK_subscriptions_user_id] FOREIGN KEY([user_id]) REFERENCES [dbo].[User] ([id])   ALTER TABLE [dbo].[Subscription] CHECK CONSTRAINT [FK_subscriptions_user_id]   CREATE TABLE [dbo].[SchemaDetails](     [major_version] [int] NOT NULL, [minor_version] [int] NOT NULL,     [details] [nvarchar](max) NULL ) ON [PRIMARY]   INSERT INTO [dbo].[SchemaDetails] ([major_version], [minor_version]) VALUES (1, 0)

3. 使用Management Studio创建Security Login
4. 设置该Login的权限为db_datawriter和db_datareader
5. 配置storefront，创建store以及storeweb等等

如果希望全部通过脚本来实现，请参考以下链接：

http://support.citrix.com/proddocs/topic/dws-storefront-10/dws-deploy-multi-database.html

关于无法正常保存订阅结果的问题，还可能是SQL的一个Bug，请参考以下KB解决：

http://support.citrix.com/article/CTX133096