Error 4502 generic что это

When attempting to drop a SQL Server login (with no database mappings or server role membership), has anyone ever gotten the following error and had the action aborted:
  • Remove From My Forums

  • Question

  • When attempting to drop a SQL Server login (with no database mappings or server role membership), has anyone ever gotten the following error and had the action aborted:

    Msg 4502, Level 16, State 1, Procedure sp_checkusernotloggedin, Line 14
    View or function ‘sys.dm_exec_sessions’ has more column names specified than columns defined.
    Msg 0, Level 20, State 0, Line 0
    A severe error occurred on the current command.  The results, if any, should be discarded.

    I’m running 64-bit SQL Server 2005 Standard Edition (9.00.1399.06). I’m executing the following statement:

    Cheers,
    CA

    Adam

Answers

  • 9.00.1399.06! That’s SQL 2005 RTM! Download and install Service Pack 4. I don’t know for a fact, but I would expect that to resolve the issue.

    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    • Proposed as answer by

      Friday, October 21, 2011 1:57 AM

    • Marked as answer by
      Peja Tao
      Wednesday, October 26, 2011 7:59 AM

Источник
  • Remove From My Forums

  • Question

  • When attempting to drop a SQL Server login (with no database mappings or server role membership), has anyone ever gotten the following error and had the action aborted:

    Msg 4502, Level 16, State 1, Procedure sp_checkusernotloggedin, Line 14
    View or function ‘sys.dm_exec_sessions’ has more column names specified than columns defined.
    Msg 0, Level 20, State 0, Line 0
    A severe error occurred on the current command.  The results, if any, should be discarded.

    I’m running 64-bit SQL Server 2005 Standard Edition (9.00.1399.06). I’m executing the following statement:

    Cheers,
    CA

    Adam

Answers

  • 9.00.1399.06! That’s SQL 2005 RTM! Download and install Service Pack 4. I don’t know for a fact, but I would expect that to resolve the issue.

    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    • Proposed as answer by

      Friday, October 21, 2011 1:57 AM

    • Marked as answer by
      Peja Tao
      Wednesday, October 26, 2011 7:59 AM

Источник

Hello,

       We have errors in operations manager log on server SCOM — 4502 and 31400 (Errors appear always together) — 

Log Name:      Operations Manager
Source:        Health Service Modules
Date:          12/6/2017 4:34:07 PM
Event ID:      31400
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      ***************
Description:
An exception occured processing a group membership rule. The rule will be unloaded.
 Subscription ID: bff0cccd-407b-45fd-8eae-d5c0cae21183
 Rule ID: 706941af-f01b-b426-b22a-66388c47570c
 Group ID: de2ea177-b32f-b490-6cba-147b8639faa6
 Group type name: Microsoft.Windows.InternetInformationServices.InstanceGroup
 Exception: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at Microsoft.EnterpriseManagement.DataAccessLayer.EntityKeyValuePairCache.GetManagedEntityKeyValuePairs(Guid baseManagedEntityId, Guid managedTypeId, Int32 mtvRow, QueryResults mtvQueryResults, IList`1 keyPropPairs, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.DataAccessLayer.EntityKeyValuePairCache.GetManagedEntityKeyValuePairs(Guid baseManagedEntityId, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.DataAccessLayer.EntityKeyValuePairCache.GetKeyValuePairs(Guid baseManagedEntityId, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.ExpressionEvaluatorForSnapshot.GetAllByTypeRelationshipChangesForSnapshot(Guid groupInstanceId, Guid groupTypeId, Guid relationshipId, Guid targetManagedTypeId, IList`1 excludeList, DatabaseConnection
databaseConnection)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.MembershipRuleEvaluator.EvaluateSnapshot(MembershipSubscription subscription, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.MembershipRuleEvaluator.EvaluateDifference(MembershipSubscription membershipSubscription, List`1 membershipChanges, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.MembershipRuleEvaluator.EvaluateDifference(MembershipSubscription subscription, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.MembershipCalculationManager.SnapshotCalculation(MembershipSubscription membershipSubscription, DatabaseConnection databaseConnection)
Event Xml:
<Event xmlns=»http://schemas.microsoft.com/win/2004/08/events/event»>
  <System>
    <Provider Name=»Health Service Modules» />
    <EventID Qualifiers=»49152″>31400</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime=»2017-12-06T12:34:07.000000000Z» />
    <EventRecordID>8460428</EventRecordID>
    <Channel>Operations Manager</Channel>
    <Computer>*****************</Computer>
    <Security />
  </System>
  <EventData>
    <Data>bff0cccd-407b-45fd-8eae-d5c0cae21183</Data>
    <Data>706941af-f01b-b426-b22a-66388c47570c</Data>
    <Data>de2ea177-b32f-b490-6cba-147b8639faa6</Data>
    <Data>Microsoft.Windows.InternetInformationServices.InstanceGroup</Data>
    <Data>System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at Microsoft.EnterpriseManagement.DataAccessLayer.EntityKeyValuePairCache.GetManagedEntityKeyValuePairs(Guid baseManagedEntityId, Guid managedTypeId, Int32 mtvRow, QueryResults mtvQueryResults, IList`1 keyPropPairs, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.DataAccessLayer.EntityKeyValuePairCache.GetManagedEntityKeyValuePairs(Guid baseManagedEntityId, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.DataAccessLayer.EntityKeyValuePairCache.GetKeyValuePairs(Guid baseManagedEntityId, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.ExpressionEvaluatorForSnapshot.GetAllByTypeRelationshipChangesForSnapshot(Guid groupInstanceId, Guid groupTypeId, Guid relationshipId, Guid targetManagedTypeId, IList`1 excludeList, DatabaseConnection
databaseConnection)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.MembershipRuleEvaluator.EvaluateSnapshot(MembershipSubscription subscription, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.MembershipRuleEvaluator.EvaluateDifference(MembershipSubscription membershipSubscription, List`1 membershipChanges, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.MembershipRuleEvaluator.EvaluateDifference(MembershipSubscription subscription, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.MembershipCalculationManager.SnapshotCalculation(MembershipSubscription membershipSubscription, DatabaseConnection databaseConnection)</Data>
  </EventData>
</Event>

и

Log Name:      Operations Manager
Source:        HealthService
Date:          12/6/2017 4:34:07 PM
Event ID:      4502
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:     **************
Description:
A module of type «Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.GroupCalculationModule» reported an exception System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at Microsoft.EnterpriseManagement.DataAccessLayer.EntityKeyValuePairCache.GetManagedEntityKeyValuePairs(Guid baseManagedEntityId, Guid managedTypeId, Int32 mtvRow, QueryResults mtvQueryResults, IList`1 keyPropPairs, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.DataAccessLayer.EntityKeyValuePairCache.GetManagedEntityKeyValuePairs(Guid baseManagedEntityId, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.DataAccessLayer.EntityKeyValuePairCache.GetKeyValuePairs(Guid baseManagedEntityId, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.ExpressionEvaluatorForSnapshot.GetAllByTypeRelationshipChangesForSnapshot(Guid groupInstanceId, Guid groupTypeId, Guid relationshipId, Guid targetManagedTypeId, IList`1 excludeList, DatabaseConnection
databaseConnection)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.MembershipRuleEvaluator.EvaluateSnapshot(MembershipSubscription subscription, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.MembershipRuleEvaluator.EvaluateDifference(MembershipSubscription membershipSubscription, List`1 membershipChanges, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.MembershipRuleEvaluator.EvaluateDifference(MembershipSubscription subscription, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.MembershipCalculationManager.SnapshotCalculation(MembershipSubscription membershipSubscription, DatabaseConnection databaseConnection) which was running as part of rule «Microsoft.Windows.InternetInformationServices.InstanceGroupDiscovery.Rule»
running for instance «IIS Instance Group» with id:»{DE2EA177-B32F-B490-6CBA-147B8639FAA6}» in management group «inm-scom».
Event Xml:
<Event xmlns=»http://schemas.microsoft.com/win/2004/08/events/event»>
  <System>
    <Provider Name=»HealthService» />
    <EventID Qualifiers=»49152″>4502</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime=»2017-12-06T12:34:07.000000000Z» />
    <EventRecordID>8460429</EventRecordID>
    <Channel>Operations Manager</Channel>
    <Computer>*************</Computer>
    <Security />
  </System>
  <EventData>
    <Data>inm-scom</Data>
    <Data>Microsoft.Windows.InternetInformationServices.InstanceGroupDiscovery.Rule</Data>
    <Data>IIS Instance Group</Data>
    <Data>{DE2EA177-B32F-B490-6CBA-147B8639FAA6}</Data>
    <Data>Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.GroupCalculationModule</Data>
    <Data>System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at Microsoft.EnterpriseManagement.DataAccessLayer.EntityKeyValuePairCache.GetManagedEntityKeyValuePairs(Guid baseManagedEntityId, Guid managedTypeId, Int32 mtvRow, QueryResults mtvQueryResults, IList`1 keyPropPairs, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.DataAccessLayer.EntityKeyValuePairCache.GetManagedEntityKeyValuePairs(Guid baseManagedEntityId, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.DataAccessLayer.EntityKeyValuePairCache.GetKeyValuePairs(Guid baseManagedEntityId, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.ExpressionEvaluatorForSnapshot.GetAllByTypeRelationshipChangesForSnapshot(Guid groupInstanceId, Guid groupTypeId, Guid relationshipId, Guid targetManagedTypeId, IList`1 excludeList, DatabaseConnection
databaseConnection)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.MembershipRuleEvaluator.EvaluateSnapshot(MembershipSubscription subscription, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.MembershipRuleEvaluator.EvaluateDifference(MembershipSubscription membershipSubscription, List`1 membershipChanges, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.MembershipRuleEvaluator.EvaluateDifference(MembershipSubscription subscription, DatabaseConnection databaseConnection)
   at Microsoft.EnterpriseManagement.Mom.DatabaseQueryModules.MembershipCalculationManager.SnapshotCalculation(MembershipSubscription membershipSubscription, DatabaseConnection databaseConnection)</Data>
  </EventData>
</Event>

Do you have any ideas? How can we resolve this problem?

Источник

Thread Rating:

  • 47 Vote(s) — 3.21 Average
  • 1
  • 2
  • 3
  • 4
  • 5

  **
Location Offline
Junior Member

Reputation:
0

Thanks Given: 14
Thanks Received: 85 (28 Posts)

Posts: 
147 
Threads: 
9

Joined: Dec 2011


1

11-12-2012, 09:22 AM

hey vis buddy or anyone…i lost my sub to alldta and now im installing on old xp machine for now. i have aug 2001 10.50. i install it offline wont ever go online and i hit stop process setup when asks to find key. then i drop the crack i bouight from vis and the ini into the alldata folder. i get the error. i uninstall over and over same thing. i noticed there i sno .ini in the folder if i dont put it the install dont put it there.i thought maybe bad crack so i used the one on my home pc and it still gives me error. is it needing the old .dll file being xp or what…i fucken lost but gong home to work home to owrk suckls. why wont this work…as soon as i hoit alldata itsays fatel error 4502…im flippen!

Thanks given by:

Reputation:
70

Thanks Given: 1021
Thanks Received: 737 (169 Posts)

Posts: 
592 
Threads: 
22

Joined: Feb 2012


2

11-12-2012, 11:19 AM

mine works great no problems!

«Two there should be; no more, no less. One to embody power, the other to crave it.»

If this helped you click the thanks button!Fing32

Thanks given by:

uhaulkid  **
Location Offline
Junior Member

Reputation:
0

Thanks Given: 14
Thanks Received: 85 (28 Posts)

Posts: 
147 
Threads: 
9

Joined: Dec 2011


3

11-12-2012, 03:58 PM

(11-12-2012, 11:19 AM)impaler11 Wrote: mine works great no problems!

Ya so does mine at home..thats why i dont understand…ive never ever had one i coukdnt figure out….i went back told old crarks and messed with the .dll files and got it to ooen further but stll not right….whats weird is alldata dont install the .inin. if i go and copy the ini into alldata folder it does not iverwrite one it was never there. Does it place it eosewhere on xp. Its been si long since i had xp macbine…this is driving me nuts i spent hours on it to get almost nowhere

Thanks given by:

mj02x  ****
Location Offline
Senior Member

Reputation:
7

Thanks Given: 322
Thanks Received: 66 (49 Posts)

Posts: 
283 
Threads: 
6

Joined: Nov 2011


4

01-03-2013, 02:21 PM

(11-12-2012, 09:22 AM)uhaulkid Wrote: hey vis buddy or anyone…i lost my sub to alldta and now im installing on old xp machine for now. i have aug 2001 10.50. i install it offline wont ever go online and i hit stop process setup when asks to find key. then i drop the crack i bouight from vis and the ini into the alldata folder. i get the error. i uninstall over and over same thing. i noticed there i sno .ini in the folder if i dont put it the install dont put it there.i thought maybe bad crack so i used the one on my home pc and it still gives me error. is it needing the old .dll file being xp or what…i fucken lost but gong home to work home to owrk suckls. why wont this work…as soon as i hoit alldata itsays fatel error 4502…im flippen!

Kid. I’m having the same issues with Alldata on XP. Have you found a solution?

Thanks given by:

mj02x  ****
Location Offline
Senior Member

Reputation:
7

Thanks Given: 322
Thanks Received: 66 (49 Posts)

Posts: 
283 
Threads: 
6

Joined: Nov 2011


5

01-11-2013, 05:12 AM

(01-03-2013, 02:21 PM)mj02x Wrote:

(11-12-2012, 09:22 AM)uhaulkid Wrote: hey vis buddy or anyone…i lost my sub to alldta and now im installing on old xp machine for now. i have aug 2001 10.50. i install it offline wont ever go online and i hit stop process setup when asks to find key. then i drop the crack i bouight from vis and the ini into the alldata folder. i get the error. i uninstall over and over same thing. i noticed there i sno .ini in the folder if i dont put it the install dont put it there.i thought maybe bad crack so i used the one on my home pc and it still gives me error. is it needing the old .dll file being xp or what…i fucken lost but gong home to work home to owrk suckls. why wont this work…as soon as i hoit alldata itsays fatel error 4502…im flippen!

Kid. I’m having the same issues with Alldata on XP. Have you found a solution?

Installed on an old laptop with xp sp3. No problems whatsoever.
These xp’s are weired!!!!

Any news about a fix?

Thanks given by:

Reputation:
0

Thanks Given: 8
Thanks Received: 0 (0 Posts)

Posts: 
10 
Threads: 
1

Joined: Sep 2012


6

06-10-2013, 07:02 PM

firewall is blocking alldata from communicating….

Thanks given by:

mj02x  ****
Location Offline
Senior Member

Reputation:
7

Thanks Given: 322
Thanks Received: 66 (49 Posts)

Posts: 
283 
Threads: 
6

Joined: Nov 2011


7

06-10-2013, 07:29 PM

How come only XP? And only on some XP installs……..

Thanks given by:

Reputation:
740

Thanks Given: 233
Thanks Received: 2112 (138 Posts)

Posts: 
253 
Threads: 
43

Joined: Apr 2011


8

02-02-2014, 10:55 AM

I had same issue, I copied the alldata icon to the desktop and ran it from there, no more error. mine is 10.52SS

Reputation:
70

Thanks Given: 1021
Thanks Received: 737 (169 Posts)

Posts: 
592 
Threads: 
22

Joined: Feb 2012


9


BMW 
02-02-2014, 11:00 AM

(11-12-2012, 03:58 PM)uhaulkid Wrote:

(11-12-2012, 11:19 AM)impaler11 Wrote: mine works great no problems!

Ya so does mine at home..thats why i dont understand…ive never ever had one i coukdnt figure out….i went back told old crarks and messed with the .dll files and got it to ooen further but stll not right….whats weird is alldata dont install the .inin. if i go and copy the ini into alldata folder it does not iverwrite one it was never there. Does it place it eosewhere on xp. Its been si long since i had xp macbine…this is driving me nuts i spent hours on it to get almost nowhere

I have 3 computer at my shop 2 are xp pro with sp3 with mitchell and alldata and 1 in my private office with windows 7 sp1 x64bit with no problems at all since last october 2013.What kind of error it gives?

«Two there should be; no more, no less. One to embody power, the other to crave it.»

If this helped you click the thanks button!Fing32

Thanks given by:

Possibly Related Threads…

AA+MHH

Replies: 44

Views: 74,412

AA+MHH

Users browsing this thread: 1 Guest(s)

Источник

Понравилась статья? Поделить с друзьями:
  • Error 450 фн неисправен
  • Error 45 initializing sql plus internal error
  • Error 4448 the wolf driver encountered a corruption in the compressed files resource table
  • Error 444 майнкрафт
  • Error 442 minecraft скачать