sqlserver logfile usage query fails with arithmetic overflow error
Article ID: 129960
Updated On:
Products
DX Infrastructure Management
NIMSOFT PROBES
Issue/Introduction
logfile_usage query errors after after upgrading from sqlserver v5.40 to v5.42
"Arithmetic overflow error converting expression to data type int."
"Arithmetic overflow error converting expression to data type int."
Cause
- defect
Environment
- robot v7.95 HF5
- hub v7.93
- hub v7.93
Resolution
- Upgrading to sqlserver-5.42T2.zip resolved the problem
This fix will be added to the next GA version of the probe.
In the meantime, please contact UIM support if you need this version to resolve the same issue reported in this article.
1. Import the sqlserver-5.42T2.zip to your local archive.
2. Rt-click and download vs2017_vcredist_x86(32-bit OS) or vs2017_vcredist_x64(64-bit OS) probe in the archive, based on the operating on which IM is installed.
3. Deactivate the sqlserver probe
4. Deploy the hotfix/sqlserver test build
5. Activate the sqlserver probe
This fix will be added to the next GA version of the probe.
In the meantime, please contact UIM support if you need this version to resolve the same issue reported in this article.
1. Import the sqlserver-5.42T2.zip to your local archive.
2. Rt-click and download vs2017_vcredist_x86(32-bit OS) or vs2017_vcredist_x64(64-bit OS) probe in the archive, based on the operating on which IM is installed.
3. Deactivate the sqlserver probe
4. Deploy the hotfix/sqlserver test build
5. Activate the sqlserver probe
Additional Information
Please Open a Support Ticket to get the sqlserver-5.42T2.zip or Newer versions
Feedback
Yes
No
Powered by
