Buy or Renew
Buy or Renew
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Start a conversation
2054
Views
0
Helpful
3
Replies

TMS ERROR ... ANYONE KNOW WHAT THIS FIX ACTION IS ???

Go to solution
Chet Cronin
Level 4
Level 4

‎08-30-2016 09:58 PM - edited ‎03-18-2019 06:19 AM

Running TMS 15.2.1

Windows 2008R2

Getting the following error:

The ETL job for TMS Reporting data failed.

Ticket # : 3109 Acknowledge
Delete
Status : Acknowledged 8/31/2016 9:22:33 AM by Chet JNCC-A SME Cronin
Description : The ETL job for TMS Reporting data failed.
How to fix this problem : Check the job in Activity Status and ETL log file for more details.
First Reported : 7/20/2016 4:06:24 AM
Last Reported : 7/20/2016 4:06:24 AM
User Comments : kkk
Chet Cronin
Labels:
0 Helpful
1 Accepted Solution

Accepted Solutions

Go to solution
Wayne DeNardi
VIP Alumni
VIP Alumni

‎08-31-2016 06:18 PM

What does it show in the ETL log file?  (usually found in C:\Program Files (x86)\TANDBERG\TMS\data\Logs\TMSDebug\log-etl.txt)

Wayne

Please remember to mark helpful responses and to set your question as answered if appropriate.

View solution in original post

0 Helpful
3 Replies 3

Go to solution
Wayne DeNardi
VIP Alumni
VIP Alumni

‎08-31-2016 06:18 PM

What does it show in the ETL log file?  (usually found in C:\Program Files (x86)\TANDBERG\TMS\data\Logs\TMSDebug\log-etl.txt)

Wayne

Please remember to mark helpful responses and to set your question as answered if appropriate.

0 Helpful

Go to solution
Chet Cronin
Level 4
Level 4
In response to Wayne DeNardi

‎09-03-2016 03:36 AM

It's a known bug and I was able to clear .

Thank you.

Chet Cronin
0 Helpful

Go to solution
Jayavel Arumugam
Level 1
Level 1
In response to Wayne DeNardi

‎06-04-2018 11:36 PM

2018-05-05T04:05:46.1130000+05:30 344 INFO dwh_ETL_StartNewJob Job 344 started with Instant=2018-05-05 04:05:46.0997672 +05:30
2018-05-05T04:05:46.1370000+05:30 344 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 245651
2018-05-05T04:05:46.1700000+05:30 344 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 50
2018-05-05T04:05:46.1700000+05:30 344 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=245651
2018-05-05T04:05:46.1730000+05:30 344 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-04 08:30:00.000
2018-05-05T04:05:46.1730000+05:30 344 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-05-05 00:00:00.000
2018-05-05T04:05:46.2000000+05:30 344 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 0
2018-05-05T04:05:46.2070000+05:30 344 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=96
2018-05-05T04:05:46.2070000+05:30 344 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=245824
2018-05-05T04:05:46.2070000+05:30 344 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-05 00:00:00.000, @OldestAffectedDate=2018-05-04 08:30:00.000
2018-05-05T04:05:46.2100000+05:30 344 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-05-05T04:05:46.2100000+05:30 344 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-05T04:05:46.2300000+05:30 344 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-05-05T04:05:46.2330000+05:30 344 INFO dwh_ETL_CompleteJob Job 344 completed
2018-05-06T04:05:33.3300000+05:30 345 INFO dwh_ETL_StartNewJob Job 345 started with Instant=2018-05-06 04:05:33.3072693 +05:30
2018-05-06T04:05:33.3430000+05:30 345 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 245824
2018-05-06T04:05:33.4630000+05:30 345 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 0
2018-05-06T04:05:33.4630000+05:30 345 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=245824
2018-05-06T04:05:33.4670000+05:30 345 INFO dwh_ETL_ConvertBridgeCallLogToEvents Exit early due to @OldestAffectedDate being NULL
2018-05-06T04:05:33.4670000+05:30 345 INFO dwh_ETL_fact_BridgeUtilization @OldestAffectedDate is NULL, defaulting to @ProcessUntil
2018-05-06T04:05:33.4670000+05:30 345 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-06 00:00:00.000, @OldestAffectedDate=2018-05-06 00:00:00.000
2018-05-06T04:05:33.4700000+05:30 345 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-05-06T04:05:33.4700000+05:30 345 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-06T04:05:33.5000000+05:30 345 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-05-06T04:05:33.5000000+05:30 345 INFO dwh_ETL_CompleteJob Job 345 completed
2018-05-07T04:05:29.5000000+05:30 346 INFO dwh_ETL_StartNewJob Job 346 started with Instant=2018-05-07 04:05:29.4868501 +05:30
2018-05-07T04:05:29.5070000+05:30 346 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 245824
2018-05-07T04:05:29.5330000+05:30 346 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 0
2018-05-07T04:05:29.5330000+05:30 346 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=245824
2018-05-07T04:05:29.5370000+05:30 346 INFO dwh_ETL_ConvertBridgeCallLogToEvents Exit early due to @OldestAffectedDate being NULL
2018-05-07T04:05:29.5370000+05:30 346 INFO dwh_ETL_fact_BridgeUtilization @OldestAffectedDate is NULL, defaulting to @ProcessUntil
2018-05-07T04:05:29.5370000+05:30 346 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-07 00:00:00.000, @OldestAffectedDate=2018-05-07 00:00:00.000
2018-05-07T04:05:29.5370000+05:30 346 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-05-07T04:05:29.5400000+05:30 346 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-07T04:05:29.5570000+05:30 346 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-05-07T04:05:29.5600000+05:30 346 INFO dwh_ETL_CompleteJob Job 346 completed
2018-05-08T04:22:05.6200000+05:30 347 INFO dwh_ETL_StartNewJob Job 347 started with Instant=2018-05-08 04:22:03.4678109 +05:30
2018-05-08T04:22:17.9770000+05:30 347 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 245824
2018-05-09T04:05:40.3330000+05:30 348 INFO dwh_ETL_StartNewJob Job 348 started with Instant=2018-05-09 04:05:40.3203843 +05:30
2018-05-09T04:05:40.5730000+05:30 348 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 245824
2018-05-09T04:05:41.8570000+05:30 348 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 95
2018-05-09T04:05:41.9000000+05:30 348 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=245824
2018-05-09T04:05:41.9030000+05:30 348 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-07 07:00:01.000
2018-05-09T04:05:41.9030000+05:30 348 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-05-09 00:00:00.000
2018-05-09T04:05:41.9600000+05:30 348 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 0
2018-05-09T04:05:41.9800000+05:30 348 INFO dwh_ETL_ConvertBridgeCallLogToEvents Commit batch 20180507, ProcessingTime=6, RowsProcessed=98
2018-05-09T04:05:41.9870000+05:30 348 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=180
2018-05-09T04:05:41.9870000+05:30 348 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=246175
2018-05-09T04:05:41.9900000+05:30 348 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-09 00:00:00.000, @OldestAffectedDate=2018-05-07 07:00:01.000
2018-05-09T04:05:41.9930000+05:30 348 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-05-09T04:05:41.9970000+05:30 348 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-09T04:05:42.0930000+05:30 348 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 2
2018-05-09T04:05:42.1200000+05:30 348 INFO dwh_ETL_CompleteJob Job 348 completed
2018-05-10T04:05:07.8570000+05:30 349 INFO dwh_ETL_StartNewJob Job 349 started with Instant=2018-05-10 04:05:07.8511917 +05:30
2018-05-10T04:05:07.8600000+05:30 349 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 246175
2018-05-10T04:05:07.9000000+05:30 349 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 44
2018-05-10T04:05:07.9000000+05:30 349 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=246175
2018-05-10T04:05:07.9000000+05:30 349 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-09 08:17:09.000
2018-05-10T04:05:07.9030000+05:30 349 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-05-10 00:00:00.000
2018-05-10T04:05:07.9270000+05:30 349 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 0
2018-05-10T04:05:07.9330000+05:30 349 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=86
2018-05-10T04:05:07.9330000+05:30 349 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=246302
2018-05-10T04:05:07.9330000+05:30 349 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-10 00:00:00.000, @OldestAffectedDate=2018-05-09 08:17:09.000
2018-05-10T04:05:07.9370000+05:30 349 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-05-10T04:05:07.9370000+05:30 349 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-10T04:05:07.9600000+05:30 349 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-05-10T04:05:07.9630000+05:30 349 INFO dwh_ETL_CompleteJob Job 349 completed
2018-05-11T04:05:24.3200000+05:30 350 INFO dwh_ETL_StartNewJob Job 350 started with Instant=2018-05-11 04:05:24.3171730 +05:30
2018-05-11T04:05:24.3230000+05:30 350 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 246302
2018-05-11T04:05:24.3630000+05:30 350 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 39
2018-05-11T04:05:24.3630000+05:30 350 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=246302
2018-05-11T04:05:24.3630000+05:30 350 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-10 08:30:00.000
2018-05-11T04:05:24.3670000+05:30 350 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-05-11 00:00:00.000
2018-05-11T04:05:24.3800000+05:30 350 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 0
2018-05-11T04:05:24.3830000+05:30 350 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=72
2018-05-11T04:05:24.3830000+05:30 350 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=246407
2018-05-11T04:05:24.3870000+05:30 350 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-11 00:00:00.000, @OldestAffectedDate=2018-05-10 08:30:00.000
2018-05-11T04:05:24.3870000+05:30 350 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-05-11T04:05:24.3870000+05:30 350 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-11T04:05:24.4000000+05:30 350 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-05-11T04:05:24.4000000+05:30 350 INFO dwh_ETL_CompleteJob Job 350 completed
2018-05-12T04:05:02.3830000+05:30 351 INFO dwh_ETL_StartNewJob Job 351 started with Instant=2018-05-12 04:05:02.3839230 +05:30
2018-05-12T04:05:02.3900000+05:30 351 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 246407
2018-05-12T04:05:02.4300000+05:30 351 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 59
2018-05-12T04:05:02.4300000+05:30 351 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=246407
2018-05-12T04:05:02.4300000+05:30 351 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-11 08:30:00.000
2018-05-12T04:05:02.4330000+05:30 351 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-05-12 00:00:00.000
2018-05-12T04:05:02.4570000+05:30 351 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 0
2018-05-12T04:05:02.4630000+05:30 351 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=98
2018-05-12T04:05:02.4630000+05:30 351 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=246537
2018-05-12T04:05:02.4630000+05:30 351 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-12 00:00:00.000, @OldestAffectedDate=2018-05-11 08:30:00.000
2018-05-12T04:05:02.4670000+05:30 351 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-05-12T04:05:02.4700000+05:30 351 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-12T04:05:02.4900000+05:30 351 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-05-12T04:05:02.4930000+05:30 351 INFO dwh_ETL_CompleteJob Job 351 completed
2018-05-13T04:05:41.1530000+05:30 352 INFO dwh_ETL_StartNewJob Job 352 started with Instant=2018-05-13 04:05:41.1353337 +05:30
2018-05-13T04:05:41.1600000+05:30 352 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 246546
2018-05-13T04:05:41.1930000+05:30 352 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 4
2018-05-13T04:05:41.1970000+05:30 352 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=246537
2018-05-13T04:05:41.2000000+05:30 352 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-11 23:52:07.000
2018-05-13T04:05:41.2000000+05:30 352 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-05-13 00:00:00.000
2018-05-13T04:05:41.2200000+05:30 352 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 2
2018-05-13T04:05:41.2270000+05:30 352 INFO dwh_ETL_ConvertBridgeCallLogToEvents Commit batch 20180511, ProcessingTime=3, RowsProcessed=3
2018-05-13T04:05:41.2300000+05:30 352 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=24
2018-05-13T04:05:41.2300000+05:30 352 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=246555
2018-05-13T04:05:41.2330000+05:30 352 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-13 00:00:00.000, @OldestAffectedDate=2018-05-11 23:52:07.000
2018-05-13T04:05:41.2370000+05:30 352 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 1
2018-05-13T04:05:41.2400000+05:30 352 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-13T04:05:41.2530000+05:30 352 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 2
2018-05-13T04:05:41.2530000+05:30 352 INFO dwh_ETL_CompleteJob Job 352 completed
2018-05-14T04:05:13.1800000+05:30 353 INFO dwh_ETL_StartNewJob Job 353 started with Instant=2018-05-14 04:05:13.1733178 +05:30
2018-05-14T04:05:13.1870000+05:30 353 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 246555
2018-05-14T04:05:13.2370000+05:30 353 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 0
2018-05-14T04:05:13.2400000+05:30 353 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=246555
2018-05-14T04:05:13.2400000+05:30 353 INFO dwh_ETL_ConvertBridgeCallLogToEvents Exit early due to @OldestAffectedDate being NULL
2018-05-14T04:05:13.2400000+05:30 353 INFO dwh_ETL_fact_BridgeUtilization @OldestAffectedDate is NULL, defaulting to @ProcessUntil
2018-05-14T04:05:13.2400000+05:30 353 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-14 00:00:00.000, @OldestAffectedDate=2018-05-14 00:00:00.000
2018-05-14T04:05:13.2430000+05:30 353 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-05-14T04:05:13.2430000+05:30 353 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-14T04:05:13.2670000+05:30 353 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-05-14T04:05:13.2670000+05:30 353 INFO dwh_ETL_CompleteJob Job 353 completed
2018-05-15T04:05:17.6600000+05:30 354 INFO dwh_ETL_StartNewJob Job 354 started with Instant=2018-05-15 04:05:17.5994199 +05:30
2018-05-15T04:05:17.7470000+05:30 354 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 246555
2018-05-15T04:05:17.8630000+05:30 354 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 44
2018-05-15T04:05:17.8630000+05:30 354 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=246555
2018-05-15T04:05:17.8670000+05:30 354 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-14 08:47:05.000
2018-05-15T04:05:17.8670000+05:30 354 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-05-15 00:00:00.000
2018-05-15T04:05:17.9170000+05:30 354 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 0
2018-05-15T04:05:17.9300000+05:30 354 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=86
2018-05-15T04:05:17.9330000+05:30 354 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=246705
2018-05-15T04:05:17.9330000+05:30 354 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-15 00:00:00.000, @OldestAffectedDate=2018-05-14 08:47:05.000
2018-05-15T04:05:17.9370000+05:30 354 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-05-15T04:05:17.9370000+05:30 354 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-15T04:05:17.9830000+05:30 354 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-05-15T04:05:17.9870000+05:30 354 INFO dwh_ETL_CompleteJob Job 354 completed
2018-05-16T04:05:30.7230000+05:30 355 INFO dwh_ETL_StartNewJob Job 355 started with Instant=2018-05-16 04:05:30.7068457 +05:30
2018-05-16T04:05:30.7330000+05:30 355 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 246705
2018-05-16T04:05:30.7670000+05:30 355 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 65
2018-05-16T04:05:30.7700000+05:30 355 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=246705
2018-05-16T04:05:30.7700000+05:30 355 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-15 09:00:56.000
2018-05-16T04:05:30.7700000+05:30 355 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-05-16 00:00:00.000
2018-05-16T04:05:30.7930000+05:30 355 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 0
2018-05-16T04:05:30.8000000+05:30 355 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=128
2018-05-16T04:05:30.8030000+05:30 355 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=246890
2018-05-16T04:05:30.8030000+05:30 355 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-16 00:00:00.000, @OldestAffectedDate=2018-05-15 09:00:56.000
2018-05-16T04:05:30.8030000+05:30 355 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-05-16T04:05:30.8070000+05:30 355 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-16T04:05:30.8300000+05:30 355 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-05-16T04:05:30.8300000+05:30 355 INFO dwh_ETL_CompleteJob Job 355 completed
2018-05-17T04:05:33.0370000+05:30 356 INFO dwh_ETL_StartNewJob Job 356 started with Instant=2018-05-17 04:05:33.0427682 +05:30
2018-05-17T04:05:33.0400000+05:30 356 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 246890
2018-05-17T04:05:33.0700000+05:30 356 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 57
2018-05-17T04:05:33.0700000+05:30 356 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=246890
2018-05-17T04:05:33.0730000+05:30 356 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-16 08:45:40.000
2018-05-17T04:05:33.0730000+05:30 356 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-05-17 00:00:00.000
2018-05-17T04:05:33.0870000+05:30 356 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 0
2018-05-17T04:05:33.0930000+05:30 356 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=111
2018-05-17T04:05:33.0970000+05:30 356 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=247065
2018-05-17T04:05:33.0970000+05:30 356 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-17 00:00:00.000, @OldestAffectedDate=2018-05-16 08:45:40.000
2018-05-17T04:05:33.0970000+05:30 356 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-05-17T04:05:33.0970000+05:30 356 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-17T04:05:33.1170000+05:30 356 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-05-17T04:05:33.1170000+05:30 356 INFO dwh_ETL_CompleteJob Job 356 completed
2018-05-18T04:05:44.1230000+05:30 357 INFO dwh_ETL_StartNewJob Job 357 started with Instant=2018-05-18 04:05:44.0974951 +05:30
2018-05-18T04:05:44.2970000+05:30 357 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 247065
2018-05-18T04:05:45.5130000+05:30 357 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 90
2018-05-18T04:05:45.5500000+05:30 357 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=247065
2018-05-18T04:05:45.5500000+05:30 357 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-17 08:55:51.000
2018-05-18T04:05:45.5530000+05:30 357 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-05-18 00:00:00.000
2018-05-18T04:05:45.6200000+05:30 357 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 0
2018-05-18T04:05:45.6330000+05:30 357 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=173
2018-05-18T04:05:45.6330000+05:30 357 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=247297
2018-05-18T04:05:45.6370000+05:30 357 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-18 00:00:00.000, @OldestAffectedDate=2018-05-17 08:55:51.000
2018-05-18T04:05:45.6400000+05:30 357 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-05-18T04:05:45.6400000+05:30 357 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-18T04:05:45.6930000+05:30 357 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-05-18T04:05:45.7270000+05:30 357 INFO dwh_ETL_CompleteJob Job 357 completed
2018-05-19T04:05:07.7930000+05:30 358 INFO dwh_ETL_StartNewJob Job 358 started with Instant=2018-05-19 04:05:07.7839372 +05:30
2018-05-19T04:05:07.8030000+05:30 358 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 247297
2018-05-19T04:05:07.8330000+05:30 358 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 88
2018-05-19T04:05:07.8370000+05:30 358 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=247297
2018-05-19T04:05:07.8370000+05:30 358 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-18 08:30:02.000
2018-05-19T04:05:07.8370000+05:30 358 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-05-19 00:00:00.000
2018-05-19T04:05:07.8530000+05:30 358 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 0
2018-05-19T04:05:07.8600000+05:30 358 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=158
2018-05-19T04:05:07.8600000+05:30 358 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=247505
2018-05-19T04:05:07.8630000+05:30 358 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-19 00:00:00.000, @OldestAffectedDate=2018-05-18 08:30:02.000
2018-05-19T04:05:07.8630000+05:30 358 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-05-19T04:05:07.8630000+05:30 358 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-19T04:05:07.8900000+05:30 358 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-05-19T04:05:07.8930000+05:30 358 INFO dwh_ETL_CompleteJob Job 358 completed
2018-05-20T04:05:31.2230000+05:30 359 INFO dwh_ETL_StartNewJob Job 359 started with Instant=2018-05-20 04:05:31.2315671 +05:30
2018-05-20T04:05:31.2330000+05:30 359 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 247518
2018-05-20T04:05:31.2730000+05:30 359 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 3
2018-05-20T04:05:31.2730000+05:30 359 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=247505
2018-05-20T04:05:31.2730000+05:30 359 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-18 21:13:29.000
2018-05-20T04:05:31.2770000+05:30 359 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-05-20 00:00:00.000
2018-05-20T04:05:31.3000000+05:30 359 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 28
2018-05-20T04:05:31.3030000+05:30 359 INFO dwh_ETL_ConvertBridgeCallLogToEvents Commit batch 20180518, ProcessingTime=3, RowsProcessed=28
2018-05-20T04:05:31.3070000+05:30 359 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=45
2018-05-20T04:05:31.3070000+05:30 359 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=247522
2018-05-20T04:05:31.3070000+05:30 359 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-20 00:00:00.000, @OldestAffectedDate=2018-05-18 21:13:29.000
2018-05-20T04:05:31.3100000+05:30 359 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 1
2018-05-20T04:05:31.3100000+05:30 359 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-20T04:05:31.3370000+05:30 359 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 2
2018-05-20T04:05:31.3370000+05:30 359 INFO dwh_ETL_CompleteJob Job 359 completed
2018-05-21T04:05:25.1330000+05:30 360 INFO dwh_ETL_StartNewJob Job 360 started with Instant=2018-05-21 04:05:25.1203470 +05:30
2018-05-21T04:05:25.1400000+05:30 360 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 247522
2018-05-21T04:05:25.1730000+05:30 360 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 0
2018-05-21T04:05:25.1770000+05:30 360 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=247522
2018-05-21T04:05:25.1770000+05:30 360 INFO dwh_ETL_ConvertBridgeCallLogToEvents Exit early due to @OldestAffectedDate being NULL
2018-05-21T04:05:25.1770000+05:30 360 INFO dwh_ETL_fact_BridgeUtilization @OldestAffectedDate is NULL, defaulting to @ProcessUntil
2018-05-21T04:05:25.1800000+05:30 360 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-21 00:00:00.000, @OldestAffectedDate=2018-05-21 00:00:00.000
2018-05-21T04:05:25.1800000+05:30 360 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-05-21T04:05:25.1800000+05:30 360 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-21T04:05:25.2100000+05:30 360 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-05-21T04:05:25.2100000+05:30 360 INFO dwh_ETL_CompleteJob Job 360 completed
2018-05-22T04:05:30.6370000+05:30 361 INFO dwh_ETL_StartNewJob Job 361 started with Instant=2018-05-22 04:05:30.6234723 +05:30
2018-05-22T04:05:30.7470000+05:30 361 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 247522
2018-05-22T04:05:30.7900000+05:30 361 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 33
2018-05-22T04:05:30.7900000+05:30 361 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=247522
2018-05-22T04:05:30.7900000+05:30 361 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-18 23:53:55.000
2018-05-22T04:05:30.7930000+05:30 361 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-05-22 00:00:00.000
2018-05-22T04:05:30.8200000+05:30 361 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 17
2018-05-22T04:05:30.8230000+05:30 361 INFO dwh_ETL_ConvertBridgeCallLogToEvents Commit batch 20180518, ProcessingTime=0, RowsProcessed=1
2018-05-22T04:05:30.8270000+05:30 361 INFO dwh_ETL_ConvertBridgeCallLogToEvents Commit batch 20180519, ProcessingTime=3, RowsProcessed=16
2018-05-22T04:05:30.8300000+05:30 361 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=81
2018-05-22T04:05:30.8300000+05:30 361 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=247637
2018-05-22T04:05:30.8300000+05:30 361 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-22 00:00:00.000, @OldestAffectedDate=2018-05-18 23:53:55.000
2018-05-22T04:05:30.8330000+05:30 361 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 3
2018-05-22T04:05:30.8330000+05:30 361 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-22T04:05:30.8600000+05:30 361 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 4
2018-05-22T04:05:30.8600000+05:30 361 INFO dwh_ETL_CompleteJob Job 361 completed
2018-05-23T04:05:43.3400000+05:30 362 INFO dwh_ETL_StartNewJob Job 362 started with Instant=2018-05-23 04:05:43.3266473 +05:30
2018-05-23T04:05:43.3500000+05:30 362 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 247637
2018-05-23T04:05:43.4100000+05:30 362 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 46
2018-05-23T04:05:43.4270000+05:30 362 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=247637
2018-05-23T04:05:43.4270000+05:30 362 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-22 08:49:36.000
2018-05-23T04:05:43.4300000+05:30 362 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-05-23 00:00:00.000
2018-05-23T04:05:43.4500000+05:30 362 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 0
2018-05-23T04:05:43.4600000+05:30 362 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=87
2018-05-23T04:05:43.4600000+05:30 362 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=247839
2018-05-23T04:05:43.4600000+05:30 362 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-23 00:00:00.000, @OldestAffectedDate=2018-05-22 08:49:36.000
2018-05-23T04:05:43.4630000+05:30 362 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-05-23T04:05:43.4630000+05:30 362 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-23T04:05:43.4900000+05:30 362 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-05-23T04:05:43.4900000+05:30 362 INFO dwh_ETL_CompleteJob Job 362 completed
2018-05-24T04:05:52.1100000+05:30 363 INFO dwh_ETL_StartNewJob Job 363 started with Instant=2018-05-24 04:05:52.1040926 +05:30
2018-05-24T04:05:52.1170000+05:30 363 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 247839
2018-05-24T04:05:52.1700000+05:30 363 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 49
2018-05-24T04:05:52.1700000+05:30 363 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=247839
2018-05-24T04:05:52.1700000+05:30 363 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-23 07:00:02.000
2018-05-24T04:05:52.1730000+05:30 363 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-05-24 00:00:00.000
2018-05-24T04:05:52.1970000+05:30 363 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 0
2018-05-24T04:05:52.2000000+05:30 363 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=77
2018-05-24T04:05:52.2000000+05:30 363 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=247984
2018-05-24T04:05:52.2030000+05:30 363 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-24 00:00:00.000, @OldestAffectedDate=2018-05-23 07:00:02.000
2018-05-24T04:05:52.2030000+05:30 363 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-05-24T04:05:52.2070000+05:30 363 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-24T04:05:52.2300000+05:30 363 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-05-24T04:05:52.2330000+05:30 363 INFO dwh_ETL_CompleteJob Job 363 completed
2018-05-25T04:05:37.2000000+05:30 364 INFO dwh_ETL_StartNewJob Job 364 started with Instant=2018-05-25 04:05:37.1397518 +05:30
2018-05-25T04:05:37.2170000+05:30 364 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 247994
2018-05-25T04:05:37.2970000+05:30 364 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 38
2018-05-25T04:05:37.3200000+05:30 364 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=247984
2018-05-25T04:05:37.3230000+05:30 364 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-23 23:34:46.000
2018-05-25T04:05:37.3230000+05:30 364 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-05-25 00:00:00.000
2018-05-25T04:05:37.3570000+05:30 364 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 11
2018-05-25T04:05:37.3700000+05:30 364 INFO dwh_ETL_ConvertBridgeCallLogToEvents Commit batch 20180523, ProcessingTime=6, RowsProcessed=14
2018-05-25T04:05:37.3770000+05:30 364 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=96
2018-05-25T04:05:37.3800000+05:30 364 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=248097
2018-05-25T04:05:37.3800000+05:30 364 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-25 00:00:00.000, @OldestAffectedDate=2018-05-23 23:34:46.000
2018-05-25T04:05:37.3830000+05:30 364 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 1
2018-05-25T04:05:37.3870000+05:30 364 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-25T04:05:37.4200000+05:30 364 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 2
2018-05-25T04:05:37.4230000+05:30 364 INFO dwh_ETL_CompleteJob Job 364 completed
2018-05-26T04:05:09.8800000+05:30 365 INFO dwh_ETL_StartNewJob Job 365 started with Instant=2018-05-26 04:05:09.8705416 +05:30
2018-05-26T04:05:09.8900000+05:30 365 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 248097
2018-05-26T04:05:09.9230000+05:30 365 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 60
2018-05-26T04:05:09.9270000+05:30 365 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=248097
2018-05-26T04:05:09.9270000+05:30 365 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-25 08:53:30.000
2018-05-26T04:05:09.9270000+05:30 365 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-05-26 00:00:00.000
2018-05-26T04:05:09.9570000+05:30 365 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 0
2018-05-26T04:05:09.9630000+05:30 365 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=112
2018-05-26T04:05:09.9630000+05:30 365 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=248232
2018-05-26T04:05:09.9670000+05:30 365 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-26 00:00:00.000, @OldestAffectedDate=2018-05-25 08:53:30.000
2018-05-26T04:05:09.9670000+05:30 365 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-05-26T04:05:09.9700000+05:30 365 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-26T04:05:09.9970000+05:30 365 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-05-26T04:05:10.0000000+05:30 365 INFO dwh_ETL_CompleteJob Job 365 completed
2018-05-27T04:05:44.7330000+05:30 366 INFO dwh_ETL_StartNewJob Job 366 started with Instant=2018-05-27 04:05:44.7248036 +05:30
2018-05-27T04:05:44.7400000+05:30 366 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 248232
2018-05-27T04:05:44.7700000+05:30 366 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 1
2018-05-27T04:05:44.7730000+05:30 366 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=248232
2018-05-27T04:05:44.7730000+05:30 366 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-25 17:45:31.000
2018-05-27T04:05:44.7730000+05:30 366 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-05-27 00:00:00.000
2018-05-27T04:05:44.7900000+05:30 366 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 29
2018-05-27T04:05:44.7970000+05:30 366 INFO dwh_ETL_ConvertBridgeCallLogToEvents Commit batch 20180525, ProcessingTime=0, RowsProcessed=28
2018-05-27T04:05:44.7970000+05:30 366 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=29
2018-05-27T04:05:44.7970000+05:30 366 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=248233
2018-05-27T04:05:44.7970000+05:30 366 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-27 00:00:00.000, @OldestAffectedDate=2018-05-25 17:45:31.000
2018-05-27T04:05:44.8000000+05:30 366 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 1
2018-05-27T04:05:44.8000000+05:30 366 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-27T04:05:44.8170000+05:30 366 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 2
2018-05-27T04:05:44.8170000+05:30 366 INFO dwh_ETL_CompleteJob Job 366 completed
2018-05-28T04:05:37.2870000+05:30 367 INFO dwh_ETL_StartNewJob Job 367 started with Instant=2018-05-28 04:05:37.2585822 +05:30
2018-05-28T04:05:37.3430000+05:30 367 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 248233
2018-05-28T04:05:37.3870000+05:30 367 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 0
2018-05-28T04:05:37.3900000+05:30 367 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=248233
2018-05-28T04:05:37.3900000+05:30 367 INFO dwh_ETL_ConvertBridgeCallLogToEvents Exit early due to @OldestAffectedDate being NULL
2018-05-28T04:05:37.3900000+05:30 367 INFO dwh_ETL_fact_BridgeUtilization @OldestAffectedDate is NULL, defaulting to @ProcessUntil
2018-05-28T04:05:37.3900000+05:30 367 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-28 00:00:00.000, @OldestAffectedDate=2018-05-28 00:00:00.000
2018-05-28T04:05:37.3900000+05:30 367 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-05-28T04:05:37.3930000+05:30 367 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-28T04:05:37.4170000+05:30 367 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-05-28T04:05:37.4200000+05:30 367 INFO dwh_ETL_CompleteJob Job 367 completed
2018-05-29T04:05:04.2300000+05:30 368 INFO dwh_ETL_StartNewJob Job 368 started with Instant=2018-05-29 04:05:04.2130877 +05:30
2018-05-29T04:05:04.2400000+05:30 368 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 248233
2018-05-29T04:05:04.2900000+05:30 368 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 24
2018-05-29T04:05:04.2900000+05:30 368 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=248233
2018-05-29T04:05:04.2900000+05:30 368 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-28 06:53:32.000
2018-05-29T04:05:04.2930000+05:30 368 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-05-29 00:00:00.000
2018-05-29T04:05:04.3200000+05:30 368 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 0
2018-05-29T04:05:04.3270000+05:30 368 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=44
2018-05-29T04:05:04.3270000+05:30 368 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=248309
2018-05-29T04:05:04.3300000+05:30 368 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-29 00:00:00.000, @OldestAffectedDate=2018-05-28 06:53:32.000
2018-05-29T04:05:04.3300000+05:30 368 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-05-29T04:05:04.3300000+05:30 368 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-29T04:05:04.3670000+05:30 368 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-05-29T04:05:04.3670000+05:30 368 INFO dwh_ETL_CompleteJob Job 368 completed
2018-05-30T04:05:19.4970000+05:30 369 INFO dwh_ETL_StartNewJob Job 369 started with Instant=2018-05-30 04:05:19.4775229 +05:30
2018-05-30T04:05:19.5000000+05:30 369 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 248309
2018-05-30T04:05:19.5400000+05:30 369 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 57
2018-05-30T04:05:19.5400000+05:30 369 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=248309
2018-05-30T04:05:19.5430000+05:30 369 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-29 09:15:00.000
2018-05-30T04:05:19.5430000+05:30 369 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-05-30 00:00:00.000
2018-05-30T04:05:19.5600000+05:30 369 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 0
2018-05-30T04:05:19.5630000+05:30 369 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=107
2018-05-30T04:05:19.5630000+05:30 369 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=248448
2018-05-30T04:05:19.5670000+05:30 369 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-30 00:00:00.000, @OldestAffectedDate=2018-05-29 09:15:00.000
2018-05-30T04:05:19.5670000+05:30 369 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-05-30T04:05:19.5670000+05:30 369 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-30T04:05:19.5930000+05:30 369 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-05-30T04:05:19.5930000+05:30 369 INFO dwh_ETL_CompleteJob Job 369 completed
2018-05-31T04:05:55.3400000+05:30 370 INFO dwh_ETL_StartNewJob Job 370 started with Instant=2018-05-31 04:05:55.3279288 +05:30
2018-05-31T04:05:55.3500000+05:30 370 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 248448
2018-05-31T04:05:55.4370000+05:30 370 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 122
2018-05-31T04:05:55.4430000+05:30 370 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=248448
2018-05-31T04:05:55.4430000+05:30 370 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-30 06:57:06.000
2018-05-31T04:05:55.4470000+05:30 370 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-05-31 00:00:00.000
2018-05-31T04:05:55.4800000+05:30 370 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 0
2018-05-31T04:05:55.5200000+05:30 370 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=232
2018-05-31T04:05:55.5200000+05:30 370 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=248701
2018-05-31T04:05:55.5230000+05:30 370 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-05-31 00:00:00.000, @OldestAffectedDate=2018-05-30 06:57:06.000
2018-05-31T04:05:55.5270000+05:30 370 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-05-31T04:05:55.5270000+05:30 370 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-05-31T04:05:55.5630000+05:30 370 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-05-31T04:05:55.5630000+05:30 370 INFO dwh_ETL_CompleteJob Job 370 completed
2018-06-01T04:05:54.5300000+05:30 371 INFO dwh_ETL_StartNewJob Job 371 started with Instant=2018-06-01 04:05:54.5190461 +05:30
2018-06-01T04:05:54.5370000+05:30 371 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 248705
2018-06-01T04:05:54.6200000+05:30 371 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 29
2018-06-01T04:05:54.6200000+05:30 371 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=248701
2018-06-01T04:05:54.6230000+05:30 371 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-31 00:02:20.000
2018-06-01T04:05:54.6230000+05:30 371 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-06-01 00:00:00.000
2018-06-01T04:05:54.6500000+05:30 371 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 0
2018-06-01T04:05:54.6570000+05:30 371 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=57
2018-06-01T04:05:54.6570000+05:30 371 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=248798
2018-06-01T04:05:54.6570000+05:30 371 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-06-01 00:00:00.000, @OldestAffectedDate=2018-05-31 00:02:20.000
2018-06-01T04:05:54.6600000+05:30 371 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-06-01T04:05:54.6600000+05:30 371 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-06-01T04:05:54.6870000+05:30 371 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-06-01T04:05:54.6900000+05:30 371 INFO dwh_ETL_CompleteJob Job 371 completed
2018-06-02T04:05:27.0100000+05:30 372 INFO dwh_ETL_StartNewJob Job 372 started with Instant=2018-06-02 04:05:27.0027622 +05:30
2018-06-02T04:05:27.0200000+05:30 372 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 248800
2018-06-02T04:05:27.0900000+05:30 372 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 59
2018-06-02T04:05:27.0900000+05:30 372 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=248798
2018-06-02T04:05:27.0930000+05:30 372 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-05-31 18:27:38.000
2018-06-02T04:05:27.0930000+05:30 372 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-06-02 00:00:00.000
2018-06-02T04:05:27.1270000+05:30 372 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 3
2018-06-02T04:05:27.1270000+05:30 372 INFO dwh_ETL_ConvertBridgeCallLogToEvents Commit batch 20180531, ProcessingTime=3, RowsProcessed=3
2018-06-02T04:05:27.1400000+05:30 372 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=120
2018-06-02T04:05:27.1400000+05:30 372 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=248996
2018-06-02T04:05:27.1400000+05:30 372 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-06-02 00:00:00.000, @OldestAffectedDate=2018-05-31 18:27:38.000
2018-06-02T04:05:27.1430000+05:30 372 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 1
2018-06-02T04:05:27.1430000+05:30 372 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-06-02T04:05:27.1700000+05:30 372 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 2
2018-06-02T04:05:27.1730000+05:30 372 INFO dwh_ETL_CompleteJob Job 372 completed
2018-06-03T04:05:32.6600000+05:30 373 INFO dwh_ETL_StartNewJob Job 373 started with Instant=2018-06-03 04:05:32.6307572 +05:30
2018-06-03T04:05:32.6700000+05:30 373 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 248996
2018-06-03T04:05:32.7300000+05:30 373 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 9
2018-06-03T04:05:32.7330000+05:30 373 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=248996
2018-06-03T04:05:32.7330000+05:30 373 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-06-02 10:10:25.000
2018-06-03T04:05:32.7370000+05:30 373 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-06-03 00:00:00.000
2018-06-03T04:05:32.7630000+05:30 373 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 0
2018-06-03T04:05:32.7670000+05:30 373 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=18
2018-06-03T04:05:32.7670000+05:30 373 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=249048
2018-06-03T04:05:32.7700000+05:30 373 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-06-03 00:00:00.000, @OldestAffectedDate=2018-06-02 10:10:25.000
2018-06-03T04:05:32.7700000+05:30 373 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-06-03T04:05:32.7700000+05:30 373 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-06-03T04:05:32.8000000+05:30 373 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-06-03T04:05:32.8030000+05:30 373 INFO dwh_ETL_CompleteJob Job 373 completed
2018-06-04T04:05:20.4770000+05:30 374 INFO dwh_ETL_StartNewJob Job 374 started with Instant=2018-06-04 04:05:20.4795769 +05:30
2018-06-04T04:05:20.5330000+05:30 374 INFO dwh_ETL_BridgeCallLog Loading rows with Id > 249048
2018-06-04T04:05:20.5730000+05:30 374 INFO dwh_ETL_BridgeCallLog TotalRowsInserted: 24
2018-06-04T04:05:20.5730000+05:30 374 INFO dwh_ETL_ConvertBridgeCallLogToEvents @StartAfterLogId=249048
2018-06-04T04:05:20.5770000+05:30 374 INFO dwh_ETL_ConvertBridgeCallLogToEvents @OldestAffectedDate=2018-06-03 15:34:28.000
2018-06-04T04:05:20.5770000+05:30 374 INFO dwh_ETL_ConvertBridgeCallLogToEvents @ProcessUntil=2018-06-04 00:00:00.000
2018-06-04T04:05:20.6070000+05:30 374 INFO dwh_ETL_ConvertBridgeCallLogToEvents Deleted rows: 0
2018-06-04T04:05:20.6100000+05:30 374 INFO dwh_ETL_ConvertBridgeCallLogToEvents TotalRowsProcessed=41
2018-06-04T04:05:20.6100000+05:30 374 INFO dwh_ETL_ConvertBridgeCallLogToEvents @HighestProcessedLogId=249089
2018-06-04T04:05:20.6130000+05:30 374 INFO dwh_ETL_fact_BridgeUtilization @ProcessUntil=2018-06-04 00:00:00.000, @OldestAffectedDate=2018-06-03 15:34:28.000
2018-06-04T04:05:20.6170000+05:30 374 INFO dwh_ETL_fact_BridgeUtilization Number of stale rows deleted: 0
2018-06-04T04:05:20.6170000+05:30 374 INFO dwh_ETL_fact_BridgeUtilization Existing data detected, running incremental load
2018-06-04T04:05:20.6430000+05:30 374 INFO dwh_ETL_fact_BridgeUtilization Number of rows inserted: 1
2018-06-04T04:05:20.6470000+05:30 374 INFO dwh_ETL_CompleteJob Job 374 completed

0 Helpful
Customers Also Viewed These Support Documents