Ask the Community
Groups
I am using Kaseya Reporting Services with a SQL 2008 R2 database and receive System.OverflowException errors - Connect IT Community | Kaseya
<main> <article class="userContent"> <p>KB#: KKB000509</p> <p> </p> <p>QUESTION</p> <p>I am using Kaseya Reporting Services with a SQL 2008 R2 database and receive System.OverflowException errors</p> <p><br>ANSWER</p> <p>In some instances, using a SQL 2008 R2 database may produce the following error(s):</p> <ul><li>System.OverflowException: Value was either too large or too small for an Int32.</li> <li>There was an error during the render phase of the report generation. An error has occurred during report processing</li> </ul><p>These errors are specific to Microsoft SQL 2008 R2 builds prior to build 10.50.1746.0. Microsoft has released hotfixes to resolve these errors. </p> <p>To verify your current SQL build number, please take the following steps:</p> <ul><li>On your SQL server, open SQL Server Management Studio</li> <li>Connect to your Kaseya database</li> <li>Click New Query</li> <li><a href="https://kaseya.vanillacommunities.com/profile/version" rel="nofollow">@version</a></li> <li>Click the Execute button</li> <li>The version and build number will be displayed in the results window</li> </ul><p> </p> <p> <img src="/attachments/token/nvjyak2eq4lbwbv/?name=7215.SQL_build.png-550x0.png" alt="7215.SQL_build.png-550x0.png" class="embedImage-img importedEmbed-img"></img></p> <p>If you are running a build prior to 10.50.1746.0, please review the <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F2359606">Microsoft KB article</a> for this issue and apply the necessary <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F2345451">hotfix</a> to your SQL server.</p> <p><br>MORE INFORMATION</p> <p>Microsoft KB article with error information: <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F2359606">http://support.microsoft.com/kb/2359606</a> </p> <p> </p> <p>Microsoft link to download hotfix: <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F2345451">http://support.microsoft.com/kb/2345451</a> </p> </article> </main>