SOLVED Message error to When I try to add a new boundary

tiagobial · Dec 17, 2022

Hello,

I'm trying to add a new boundary on my SCCM however I'm getting the following message error does anybody know why ?
My SCCM is 2107.

Garth · Dec 19, 2022

Check your permissions within CM.

tiagobial · Dec 19, 2022

Garth said:
Check your permissions within CM.

I'm part of Full Administrator group.

Garth · Dec 19, 2022

tiagobial said:
I'm part of Full Administrator group.

But do you have FULL admin to all areas of CM? e.g. not limited to a site or collection?

MJ-Tech · Dec 19, 2022

I had a similar issue before (but not from boundaries).
I was able to install the servicing components without issue after rebooting the server.

I'm not sure if this is useful.

tiagobial · Dec 20, 2022

I already rebooted the server, plus I also updated the server, and the issue is still the same.

tiagobial · Dec 20, 2022

Garth said:
But do you have FULL admin to all areas of CM? e.g. not limited to a site or collection?

If I'm full admin where I can look to make sure I have those permissions?

pauljebastin · Dec 21, 2022

tiagobial said:
Hello,

I'm trying to add a new boundary on my SCCM however I'm getting the following message error does anybody know why ?
My SCCM is 2107.

View attachment 4946 View attachment 4947

View attachment 4948

Were you successfully added boundary or boundary groups before?
Check under administrator users if Security scopes assigned to All Instances of the objects that are related to the assigned security roles or other options?

tiagobial · Dec 21, 2022

Yeap, my account is part of All instances Scope, and to answer your questions this is my first time trying to create a boundary in my company.

Thanks for the help.

pauljebastin · Dec 22, 2022

tiagobial said:
Yeap, my account is part of All instances Scope, and to answer your questions this is my first time trying to create a boundary in my company.

View attachment 4950

Thanks for the help.

The error looks more specific to database (i guess), I could that you already rebooted the server, is ConfigMgr database also in the same server? if not please try rebooting your DB server as well. If this didnot please please upload Smsprov.log file. Thanks

tiagobial · Dec 22, 2022

This is what i got from SMSPROV.LOG, I agree there is something weird with the database I don't know what; I already rebooted the database too.

PutInstanceAsync SMS_Boundary SMS Provider 12/22/2022 8:24:13 AM 13372 (0x343C)
IExtClassManager::ValidateAuthenticationLevel... SMS Provider 12/22/2022 8:24:13 AM 13372 (0x343C)
CExtProviderClassObject:

oPutInstanceInstance SMS Provider 12/22/2022 8:24:13 AM 13372 (0x343C)
*** insert into vSMS_Boundary (BoundaryFlags, BoundaryType, DisplayName, Value, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) values (0, 1, N'', N'Azure', N'S609215-AD01\gramachotsa', N'12/22/2022 16:24:13', N'S609215-AD01\gramachotsa', N'12/22/2022 16:24:13')~;~ select scope_identity() SMS Provider 12/22/2022 8:24:13 AM 13372 (0x343C)
*** [42000][524][Microsoft][SQL Server Native Client 11.0][SQL Server]A trigger returned a resultset and the server option 'disallow results from triggers' is true. : vSMS_Boundary_iu SMS Provider 12/22/2022 8:24:13 AM 13372 (0x343C)
*~*~[42000][524][Microsoft][SQL Server Native Client 11.0][SQL Server]A trigger returned a resultset and the server option 'disallow results from triggers' is true. : vSMS_Boundary_iu ThreadID : 13372 , DbError: 524 , Sev: 16~*~* SMS Provider 12/22/2022 8:24:13 AM 13372 (0x343C)
*~*~C:\__w\1\s\src\SiteServer\SDK_Provider\SMSProv\ssputility.cpp(1880) : SQL command failed: insert into vSMS_Boundary (BoundaryFlags, BoundaryType, DisplayName, Value, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) values (0, 1, N'', N'Azure', N'S609215-AD01\gramachotsa', N'12/22/2022 16:24:13', N'S609215-AD01\gramachotsa', N'12/22/2022 16:24:13')~;~ select scope_identity()~ SQL Error: [42000][524][Microsoft][SQL Server Native Client 11.0][SQL Server]A trigger returned a resultset and the server option 'disallow results from triggers' is true. : vSMS_Boundary_iu~*~* SMS Provider 12/22/2022 8:24:13 AM 13372 (0x343C)
*~*~SQL command failed: insert into vSMS_Boundary (BoundaryFlags, BoundaryType, DisplayName, Value, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) values (0, 1, N'', N'Azure', N'S609215-AD01\gramachotsa', N'12/22/2022 16:24:13', N'S609215-AD01\gramachotsa', N'12/22/2022 16:24:13')~;~ select scope_identity() [42000][524][Microsoft][SQL Server Native Client 11.0][SQL Server]A trigger returned a resultset and the server option 'disallow results from triggers' is true. : vSMS_Boundary_iu~*~* SMS Provider 12/22/2022 8:24:13 AM 13372 (0x343C)
ERROR: SQL command failed: insert into vSMS_Boundary (BoundaryFlags, BoundaryType, DisplayName, Value, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) values (0, 1, N'', N'Azure', N'S609215-AD01\gramachotsa', N'12/22/2022 16:24:13', N'S609215-AD01\gramachotsa', N'12/22/2022 16:24:13')~;~ select scope_identity() SMS Provider 12/22/2022 8:24:13 AM 13372 (0x343C)
CExtUserContext::LeaveThread : Releasing IWbemContextPtr=-633345056 SMS Provider 12/22/2022 8:24:13 AM 13372 (0x343C)

pauljebastin · Dec 22, 2022

tiagobial said:
This is what i got from SMSPROV.LOG, I agree there is something weird with the database I don't know what; I already rebooted the database too.

View attachment 4954

PutInstanceAsync SMS_Boundary SMS Provider 12/22/2022 8:24:13 AM 13372 (0x343C)
IExtClassManager::ValidateAuthenticationLevel... SMS Provider 12/22/2022 8:24:13 AM 13372 (0x343C)
CExtProviderClassObject:oPutInstanceInstance SMS Provider 12/22/2022 8:24:13 AM 13372 (0x343C)
*** insert into vSMS_Boundary (BoundaryFlags, BoundaryType, DisplayName, Value, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) values (0, 1, N'', N'Azure', N'S609215-AD01\gramachotsa', N'12/22/2022 16:24:13', N'S609215-AD01\gramachotsa', N'12/22/2022 16:24:13')~;~ select scope_identity() SMS Provider 12/22/2022 8:24:13 AM 13372 (0x343C)
*** [42000][524][Microsoft][SQL Server Native Client 11.0][SQL Server]A trigger returned a resultset and the server option 'disallow results from triggers' is true. : vSMS_Boundary_iu SMS Provider 12/22/2022 8:24:13 AM 13372 (0x343C)
*~*~[42000][524][Microsoft][SQL Server Native Client 11.0][SQL Server]A trigger returned a resultset and the server option 'disallow results from triggers' is true. : vSMS_Boundary_iu ThreadID : 13372 , DbError: 524 , Sev: 16~*~* SMS Provider 12/22/2022 8:24:13 AM 13372 (0x343C)
*~*~C:\__w\1\s\src\SiteServer\SDK_Provider\SMSProv\ssputility.cpp(1880) : SQL command failed: insert into vSMS_Boundary (BoundaryFlags, BoundaryType, DisplayName, Value, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) values (0, 1, N'', N'Azure', N'S609215-AD01\gramachotsa', N'12/22/2022 16:24:13', N'S609215-AD01\gramachotsa', N'12/22/2022 16:24:13')~;~ select scope_identity()~ SQL Error: [42000][524][Microsoft][SQL Server Native Client 11.0][SQL Server]A trigger returned a resultset and the server option 'disallow results from triggers' is true. : vSMS_Boundary_iu~*~* SMS Provider 12/22/2022 8:24:13 AM 13372 (0x343C)
*~*~SQL command failed: insert into vSMS_Boundary (BoundaryFlags, BoundaryType, DisplayName, Value, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) values (0, 1, N'', N'Azure', N'S609215-AD01\gramachotsa', N'12/22/2022 16:24:13', N'S609215-AD01\gramachotsa', N'12/22/2022 16:24:13')~;~ select scope_identity() [42000][524][Microsoft][SQL Server Native Client 11.0][SQL Server]A trigger returned a resultset and the server option 'disallow results from triggers' is true. : vSMS_Boundary_iu~*~* SMS Provider 12/22/2022 8:24:13 AM 13372 (0x343C)
ERROR: SQL command failed: insert into vSMS_Boundary (BoundaryFlags, BoundaryType, DisplayName, Value, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn) values (0, 1, N'', N'Azure', N'S609215-AD01\gramachotsa', N'12/22/2022 16:24:13', N'S609215-AD01\gramachotsa', N'12/22/2022 16:24:13')~;~ select scope_identity() SMS Provider 12/22/2022 8:24:13 AM 13372 (0x343C)
CExtUserContext::LeaveThread : Releasing IWbemContextPtr=-633345056 SMS Provider 12/22/2022 8:24:13 AM 13372 (0x343C)

Actually I do not see vSMS_Boundary_iu (see screenshot) in my CM Database (Site version 2207)so I am not sure what this table contains. What is your Site version? can you please check what data this table/view contains?
What you can try do is:
1. is your Discovery Methods - Active Directory Forest Discovery enabled (not sure if related but worth checking)?
2. Try run SQL Profiler to trace down the error and find why it throws the SQL error - ask help from DB team.
3. or if you are running lower site version - try installing the latest version so it will update SQL with missed tables/views or remove the ones which are not required. Site Version 2211 is also now available to install.

tiagobial · Dec 28, 2022

pauljebastin said:
Actually I do not see vSMS_Boundary_iu (see screenshot) in my CM Database (Site version 2207)so I am not sure what this table contains. What is your Site version? can you please check what data this table/view contains?
What you can try do is:
1. is your Discovery Methods - Active Directory Forest Discovery enabled (not sure if related but worth checking)?
2. Try run SQL Profiler to trace down the error and find why it throws the SQL error - ask help from DB team.
3. or if you are running lower site version - try installing the latest version so it will update SQL with missed tables/views or remove the ones which are not required. Site Version 2211 is also now available to install.

View attachment 4956

Can you tell me where those tables are? I could not find it.

tiagobial · Dec 28, 2022

Hello Guys I noticed that I'm not SysAdmin of my database, do you think this can be the issue ?

pauljebastin · Jan 3, 2023

tiagobial said:
Hello Guys I noticed that I'm not SysAdmin of my database, do you think this can be the issue ?

View attachment 4962

Nope, that's not the cause

pauljebastin · Jan 3, 2023

tiagobial said:
Can you tell me where those tables are? I could not find it.

View attachment 4961

I am not sure why you are able to find just one table/views, might be DB access not sysadmin role. were your team members can create boundaries or can see other tables?
Have you tried any points suggested?

tiagobial · Jan 5, 2023

pauljebastin said:
I am not sure why you are able to find just one table/views, might be DB access not sysadmin role. were your team members can create boundaries or can see other tables?
Have you tried any points suggested?

Believe me, I have tried everything, I'm almost giving up, and installing a new SCCM don't make any sense.

tiagobial · Jan 5, 2023

Finally, I got it solved after run the following sql query on the database.

USE master
GO

BEGIN
EXEC sp_configure 'show advanced options', 1;
RECONFIGURE
EXEC sp_configure 'disallow results from triggers', 0;
RECONFIGURE
END

tiagobial · Jan 10, 2023

Plus, I was not sysadmin of the database I truly believe that if you become sysadmin the problem is going to be solved.

SOLVED Message error to When I try to add a new boundary

Member

Well-Known Member

Member

Well-Known Member

Well-Known Member

Member

Member

Member

Member

Member

Member

Member

Member

Member

Member

Member

Member

Member

Member

Similar threads

Forum statistics

Trending content