Recollecting reporting data

[Nina_Makkonen]

Symptoms

Reporting couldn’t collect data for a specific date/time from the Monitoring database.

Solution

1. Check if the History database has data for the date/time in question.

a) Connect to the database using Microsoft SQL Management Studio.

b) Go to XXX_DSArea database and select it.

c) Copy the following script and execute it:

select convert(varchar(13),TimeStamp,121), count(*)

from TAContactLog

group by convert(varchar(13),TimeStamp,121)

order by convert(varchar(13),TimeStamp,121

2. If no data exists in the DSArea database, check if the Monitoring History database server "XXX_History" has historical data for the given date/time. 

a. Run the same query as above. 

b. If data exists, you'll need to use the CopyLogData tool to copy the history data from the Monitoring database server  "XXX_History" into the "XXX_DSArea" database. For more information, see Copying data from History database to DSArea database.

3. If data exists, use the rollback function to delete the dates in question. This step is only needed if the report has some data. This is done to avoid duplicate values.

a. Open Online Monitoring and go to Tools > Reporting Settings.

b. In the DTE Reporting view, select the date/time and click Roll Back.

4. To recollect the data, run the Data Transformation Engine (DTE) job for the days:

a. Run Command Prompt as an administrator.

b. Locate the BCM_DTE.exe file. This should be under the Reporting database installation \contents\bin directory, for example C:\Sinch\Contact Pro\Reporting Database Server\contents\bin.

c. Change directory to the above path and enter the following in the command line: "BCM_DTE.exe [VU_Name] "YYYY-MM-DD HH:MM:SS" "YYYY-MM-DD HH:MM:SS".

 For example: BCM_DTE.exe ACME_Reporting "2013-10-30 22:00:00" "2013-10-31 13:00:00” 

The time period doesn’t have to be full hours. You can use a period of 15 minutes.

NOTE: The start and end time parameters are always UTC time, so when you are recollecting the data, you need to pay close attention and convert your local time to UTC or else you could be risking missing some data.

5. If you use Micorsoft Reporting Services reports, run database full process either by:

• Executing the "XXX: Reporting OLAP database management" found in Microsoft SQL Server Management Studio -> SQL Server Agent -> Jobs -> "XXX: Reporting OLAP database management". This will run the Process Full.

or

• Manually running the Process Full directly against the OLAP database:

a. Connect to the Analysis Services Engine using Microsoft SQL Management Studio.

b. Right-click on the OLAP database and then choose Process.

c. Make sure the process type is set as Process Full and then click OK.