The following errors are noted in the Management Reporter Configuration Console logs after determining reports are not pulling current activity from SL database:
Cannot continue the execution because the session is in the kill state. A severe error occurred on the current command. The results, if any, should be discarded. DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC execution completed. If DBCC printed error messages, contact your system administrator. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Review the resources on the Management Reporter and/or SQL server to ensure the recommended minimum amount of RAM is being met for the programs installed on them. Resources may be too low for the data mart integration task to run. For what is considered a small sized database (50 million GL transactions or less) the recommended RAM per Microsoft is 54 GB (assuming the MR server and SQL server are both on the same server). If you have one MR server and a separate SQL server then the recommendation is 20 GB on the MR server and 32 on the SQL server. Please keep in mind, these recommendations are strictly for MR itself. Any additional programs running on the servers would each require their own additional amounts of RAM.