-
Notifications
You must be signed in to change notification settings - Fork 8
Conversion failed when converting value to data type #4
Comments
I have a lot of reports, which one are you refering to? |
Oh sorry, it's the "CB Configuration Baseline Compliance by Configuration Item with Values" one. However, a colleague and I found the issue, we believe. The ID's in the error correspond with 'AdminIDs' for Administrative users in SCCM. And the issue only happens to users who are members of multiple groups and/or specified explicitly in the administrative users section in the console. In my case, my user account was explicitly defined as an admin AND I am a member of another group which is also defined as an admin in the console. The error is actually coming from the definition of 'UserSIDs'. My user's UserTokenSIDs as it passes into 'dbo.fn_rbac_GetAdminIDsfromUserSIDs' results in two ID's coming back from the function. But instead of Microsoft listing them as 2 separate values, they concatenate them into one string joined with a comma. Workaround: Fix?: |
Hmm, I will look for a workaround, thanks for reporting this |
No problem, when I get into work, I will post the extra code that got it working. |
For now the simple workaround is to uncomment this line NOTE: This will disable the report security! |
## 4.0 2019-03-14 ### Changes * Speed optimisations * Workaround for issue [Conversion failed when converting value to data type](#4) * Added 'Compliant' Data * Changed OS Caption to static * Removed system info temporary table * Replaced report template with the new streamlined template * Changed report description to static
Implemented workaround, upgraded report template and other optimisations. |
@Yevrag35
Running the report gives me:
How do I begin debugging this?
The text was updated successfully, but these errors were encountered: