Error TS2415 Class ‘Subject’ incorrectly extends base class ‘Observable’.

After you setup angularjs 2 in your visual studio 2015, if you get this error:

 

Severity Code Description Project File Line Suppression StateSeverity Code Description Project File Line Suppression StateError TS2415 Class ‘Subject<T>’ incorrectly extends base class ‘Observable<T>’.  Types of property ‘lift’ are incompatible.    Type ‘<R>(operator: Operator<T, R>) => Observable<T>’ is not assignable to type ‘<R>(operator: Operator<T, R>) => Observable<R>’.      Type ‘Observable<T>’ is not assignable to type ‘Observable<R>’.        Type ‘T’ is not assignable to type ‘R’. TypeScript Virtual Projects C:\Users\xxxxxxx\Documents\Visual Studio 2015\Projects\Angular2Demo\Angular2Demo\node_modules\rxjs\Subject.d.ts 16 Active

 

All you have to do is:

Open this file:

tsconfig.json

and add the following line:

 

“noStrictGenericChecks”: true,

 

inside  “compilerOptions”: {

 

the entire file should look like:

 

{
“compilerOptions”: {
“noStrictGenericChecks”: true,
“target”: “es5”,
“module”: “commonjs”,
“moduleResolution”: “node”,
“sourceMap”: true,
“emitDecoratorMetadata”: true,
“experimentalDecorators”: true,
“lib”: [ “es2015”, “dom” ],
“noImplicitAny”: true,
“suppressImplicitAnyIndexErrors”: true
}
}

Advertisements

Select backlog navigation levels for your team in Visual Studio Team Service

 

  1. From your team’s backlog page, click the gear icon (gear icon) to open the common configuration team settings.
    Backlog board, open team settings
  2. Click the Backlogs tab and check the boxes of those backlog levels you want your team to manage.

    Team Services, web portal, team settings dialog, Backlogs tab

  3. To see the changes, open or refresh your team’s backlog web page.

Reff: https://www.visualstudio.com/en-us/docs/work/customize/select-backlog-navigation-levels

SSRS: Repeat rows of a table, if they break across a page

how to repeat rows of a table, if they break across a page.  In the grouping section/pane, turn on advanced, so you can see the static lines:

1

When you select one of those, you will see the border around at least 1 cell of the row that you are selecting, in the table you are on:

2

On the properties pane you will see RepeatOnNewPage. Set that to True:

3

I verified that this does work, as long as the table is built properly.

By simplemsexchange Posted in SSRS

List all SSRS subscriptions

USE [ReportServer];  -- You may change the database name. 
GO 
 
SELECT USR.UserName AS SubscriptionOwner 
      ,SUB.ModifiedDate 
      ,SUB.[Description] 
      ,SUB.EventType 
      ,SUB.DeliveryExtension 
      ,SUB.LastStatus 
      ,SUB.LastRunTime 
      ,SCH.NextRunTime 
      ,SCH.Name AS ScheduleName       
      ,CAT.[PathAS ReportPath 
      ,CAT.[DescriptionAS ReportDescription 
FROM dbo.Subscriptions AS SUB 
     INNER JOIN dbo.Users AS USR 
         ON SUB.OwnerID = USR.UserID 
     INNER JOIN dbo.[CatalogAS CAT 
         ON SUB.Report_OID = CAT.ItemID 
     INNER JOIN dbo.ReportSchedule AS RS 
         ON SUB.Report_OID = RS.ReportID 
            AND SUB.SubscriptionID = RS.SubscriptionID 
     INNER JOIN dbo.Schedule AS SCH 
         ON RS.ScheduleID = SCH.ScheduleID 
ORDER BY USR.UserName 
        ,CAT.[Path];


Refference: https://gallery.technet.microsoft.com/scriptcenter/List-all-SSRS-subscriptions-968ae4d5

Update Statistics Manually. Re-indexing manually

DECLARE @tablename varchar(80),@shemaname varchar(80)
DECLARE @SQL AS NVARCHAR(200)
DECLARE TblName_cursor CURSOR FOR
SELECT t.name,s.name FROM sys.tables t join sys.schemas s
on s.schema_id=t.schema_id


OPEN TblName_cursor

FETCH NEXT FROM TblName_cursor
INTO @tablename,@shemaname

WHILE @@FETCH_STATUS = 0
BEGIN
SET @SQL = 'UPDATE STATISTICS '+@shemaname+'.[' + @TableName + '] WITH FULLSCAN ' ---+ CONVERT(varchar(3), @sample) + ' PERCENT'
PRINT @SQL

EXEC sp_executesql @statement = @SQL

 FETCH NEXT FROM TblName_cursor
 INTO @tablename,@shemaname
END

CLOSE TblName_cursor
DEALLOCATE TblName_cursor

MS SQL add Update Statistics job (Schedule) to get better performance ( Reindexing )

/****** Object: Job [Update CRM Statistics] Script Date: 05/01/2017 09:43:42 ******/
 BEGIN TRANSACTION
 DECLARE @ReturnCode INT
 SELECT @ReturnCode = 0
 /****** Object: JobCategory [[Uncategorized (Local)]]] Script Date: 05/01/2017 09:43:43 ******/
 IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1)
 BEGIN
 EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N'JOB', @type=N'LOCAL', @name=N'[Uncategorized (Local)]'
 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

END

DECLARE @jobId BINARY(16)
 EXEC @ReturnCode = msdb.dbo.sp_add_job @job_name=N'Update CRM Statistics',
 @enabled=1,
 @notify_level_eventlog=3,
 @notify_level_email=0,
 @notify_level_netsend=0,
 @notify_level_page=0,
 @delete_level=0,
 @description=N'No description available.',
 @category_name=N'[Uncategorized (Local)]',
 @owner_login_name=N'xxxx', @job_id = @jobId OUTPUT

/*xxxx = login username for the database which has dbaadmin permission*/
 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
 /****** Object: Step [Update Statistics] Script Date: 05/01/2017 09:43:43 ******/
 EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobId, @step_name=N'Update Statistics',
 @step_id=1,
 @cmdexec_success_code=0,
 @on_success_action=1,
 @on_success_step_id=0,
 @on_fail_action=2,
 @on_fail_step_id=0,
 @retry_attempts=0,
 @retry_interval=0,
 @os_run_priority=0, @subsystem=N'TSQL',
 @command=N'DECLARE @tablename varchar(80),@shemaname varchar(80)
 DECLARE @SQL AS NVARCHAR(200)
 DECLARE TblName_cursor CURSOR FOR
 SELECT t.name,s.name FROM sys.tables t join sys.schemas s
 on s.schema_id=t.schema_id
 OPEN TblName_cursor

FETCH NEXT FROM TblName_cursor
 INTO @tablename,@shemaname

WHILE @@FETCH_STATUS = 0
 BEGIN
 SET @SQL = ''UPDATE STATISTICS ''+@shemaname+''.['' + @TableName + ''] WITH FULLSCAN '' ---+ CONVERT(varchar(3), @sample) + '' PERCENT''
 PRINT @SQL

EXEC sp_executesql @statement = @SQL

FETCH NEXT FROM TblName_cursor
 INTO @tablename,@shemaname
 END

CLOSE TblName_cursor
 DEALLOCATE TblName_cursor
 ',
 @database_name=N'CRM',

/*CRM is the database NAME*/
 @flags=0
 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
 EXEC @ReturnCode = msdb.dbo.sp_update_job @job_id = @jobId, @start_step_id = 1
 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
 EXEC @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id=@jobId, @name=N'Reindexing',
 @enabled=1,
 @freq_type=4,
 @freq_interval=1,
 @freq_subday_type=1,
 @freq_subday_interval=0,
 @freq_relative_interval=0,
 @freq_recurrence_factor=0,
 @active_start_date=20141124,
 @active_end_date=99991231,
 @active_start_time=193000,
 @active_end_time=235959,
 @schedule_uid=N'b5ec9450-ee63-43bc-926f-ab5e36d5dc9e'
 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
 EXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N'(local)'
 IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
 COMMIT TRANSACTION
 GOTO EndSave
 QuitWithRollback:
 IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
 EndSave:

GO

VS2013 An exception occurred while initializing the database

I’m doing a code first Entity database

{“An exception occurred while initializing the database. See the InnerException for details.”}

It was working fine, but I decided to delete the physical database to see it recreate it, but it just fails every time.

I get the error

Cannot attach the file ‘C:\ASP\OdeToFood\OdeToFood\App_Data\OdeToFoodDb.mdf’ as database ‘OdeToFoodDb’.”}

Its code first so I don’t understand why its not recreating the database.

 

 

So deleting the file from Visual Studio was a dumb idea.

SQL still has it registered.

Fire up MS Sql Management Tool, connect to the server in my case

(localdb)\v11.0

You will see the database, still exists, delete it, you will get an error. The file doesn’t exist. Refresh and its gone from SQL. Now run your code again and all is good.

So delete the DB from the management tool not visual studio