Hello
I am receiving the following error for subscriptions we create:
ReportingServicesService!library!c24!10/22/2004-21:27:04:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 1355;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
IMPORTANT: These subscriptions were working last week but after applying
ALL the outsanding Windows 2003 patches the problem showed up. Also, it
doesn't matter which delivery extension (including custom) we choose.. we get
the same 1355 error. We can run the reports interactively through report
manager so the issue is definetly subscription related.
We are running the following software:
- Windows 2003 including ALL patches released to date (latest monthly
patches appear to be causing this issue)
- SQL Server 2000 SP3a
- SQL Reporting Services Standard Addition SP1
- Exchange 2000. I only mention this as other posts have suggested this is
Lotus notes issue. In our case it doesn't matter which delivery extension we
choose.
I can get the subscriptions to work using a god like account (ie has domain
admin rights) so the issue appears to center around which user account
actually owns the subscription. If I modify the subscription with any other
account the subscription continues to function properly.
My question is how is the OwnerID found in Subscription table actualy used
becuase this appear to be the key to resolving this issue?
Regards
Kevin WeirA follow-up to my own post:
Here is sample eror log messages containing error:
ReportingServicesService!dbpolling!c24!10/22/2004-21:27:03:: EventPolling
processing item cb787fc0-b06b-4bc0-aa65-386991109995
ReportingServicesService!dbpolling!7dc!10/22/2004-21:27:03:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!library!c24!10/22/2004-21:27:03:: Schedule
90015ab7-ec96-4891-b51f-c3ff202da46b executed at 10/22/2004 9:27:03 PM.
ReportingServicesService!schedule!c24!10/22/2004-21:27:03:: Creating Time
based subscription notification for subscription:
bb790a12-151c-4074-a79b-61c158088965
ReportingServicesService!library!c24!10/22/2004-21:27:04:: Schedule
90015ab7-ec96-4891-b51f-c3ff202da46b execution completed at 10/22/2004
9:27:04 PM.
ReportingServicesService!dbpolling!c24!10/22/2004-21:27:04:: EventPolling
finished processing item cb787fc0-b06b-4bc0-aa65-386991109995
ReportingServicesService!dbpolling!c24!10/22/2004-21:27:04::
NotificationPolling processing item a7712007-71d4-44cc-81c0-5a68b9bbdf6a
ReportingServicesService!dbpolling!7dc!10/22/2004-21:27:04::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!library!c24!10/22/2004-21:27:04:: i INFO: Call to
RenderFirst( '/Test' )
ReportingServicesService!library!c24!10/22/2004-21:27:04:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 1355;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!c24!10/22/2004-21:27:04:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!c24!10/22/2004-21:27:04:: Error
sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
The Report Server has encountered a configuration error; more details in the
log files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32&
executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!c24!10/22/2004-21:27:04:: Notification
a7712007-71d4-44cc-81c0-5a68b9bbdf6a completed. Success: False, Status:
Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files, DeliveryExtension: Report Server Email,
Report: Test, Attempt 0
ReportingServicesService!dbpolling!c24!10/22/2004-21:27:04::
NotificationPolling finished processing item
a7712007-71d4-44cc-81c0-5a68b9bbdf6a
ReportingServicesService!library!c24!10/22/2004-21:27:47:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs|||If anyone else reads this and has same problem I applied Windows 2003 hotfix
834859 which resolved the problem
http://support.microsoft.com/default.aspx?scid=kb;en-us;834859
"Kevin Weir" wrote:
> Hello
> I am receiving the following error for subscriptions we create:
> ReportingServicesService!library!c24!10/22/2004-21:27:04:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files, AuthzInitializeContextFromSid: Win32 error: 1355;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files
> IMPORTANT: These subscriptions were working last week but after applying
> ALL the outsanding Windows 2003 patches the problem showed up. Also, it
> doesn't matter which delivery extension (including custom) we choose.. we get
> the same 1355 error. We can run the reports interactively through report
> manager so the issue is definetly subscription related.
> We are running the following software:
> - Windows 2003 including ALL patches released to date (latest monthly
> patches appear to be causing this issue)
> - SQL Server 2000 SP3a
> - SQL Reporting Services Standard Addition SP1
> - Exchange 2000. I only mention this as other posts have suggested this is
> Lotus notes issue. In our case it doesn't matter which delivery extension we
> choose.
> I can get the subscriptions to work using a god like account (ie has domain
> admin rights) so the issue appears to center around which user account
> actually owns the subscription. If I modify the subscription with any other
> account the subscription continues to function properly.
> My question is how is the OwnerID found in Subscription table actualy used
> becuase this appear to be the key to resolving this issue?
> Regards
> Kevin Weir
>
Showing posts with label receiving. Show all posts
Showing posts with label receiving. Show all posts
Tuesday, March 20, 2012
Sunday, February 19, 2012
Broken hyperlinks in subscription emails
Users are receiving link-only subscriptions with broken links where the break
always starts with an exclamation mark. It looks like this in email source
view:
<table><tr><td><span>My comment text added to
subscription</span></td></tr></table><table><tr><td><span>The report is
accessible at the following address:</span></td><tr><td><a
href="http://links.10026.com/?link=http://servername/reportportal/viewreport.aspx?%2fEncoded+Report+Name&Par1=Encoded+param+value&&Par2=Encoded+param+value&r!
s%3aParameterLanguage=en-US">http://servername/reportportal/viewreport.aspx?%2fEncoded+Report+Name&Par1=Encoded+param+value&&Par2=Encoded+param+value&rs%3aParameterLanguage=en-US</a></td></tr></table>
Any suggestions how to fix or work around this?I have updated Reporting Services to version 9.00.2040.00 but I am still
getting broken hyperlinks in subscription emails.
"PeterG" wrote:
> Users are receiving link-only subscriptions with broken links where the break
> always starts with an exclamation mark. It looks like this in email source
> view:
> <table><tr><td><span>My comment text added to
> subscription</span></td></tr></table><table><tr><td><span>The report is
> accessible at the following address:</span></td><tr><td><a
> href="http://links.10026.com/?link=http://servername/reportportal/viewreport.aspx?%2fEncoded+Report+Name&Par1=Encoded+param+value&&Par2=Encoded+param+value&r!
> s%3aParameterLanguage=en-US">http://servername/reportportal/viewreport.aspx?%2fEncoded+Report+Name&Par1=Encoded+param+value&&Par2=Encoded+param+value&rs%3aParameterLanguage=en-US</a></td></tr></table>
> Any suggestions how to fix or work around this?
>
always starts with an exclamation mark. It looks like this in email source
view:
<table><tr><td><span>My comment text added to
subscription</span></td></tr></table><table><tr><td><span>The report is
accessible at the following address:</span></td><tr><td><a
href="http://links.10026.com/?link=http://servername/reportportal/viewreport.aspx?%2fEncoded+Report+Name&Par1=Encoded+param+value&&Par2=Encoded+param+value&r!
s%3aParameterLanguage=en-US">http://servername/reportportal/viewreport.aspx?%2fEncoded+Report+Name&Par1=Encoded+param+value&&Par2=Encoded+param+value&rs%3aParameterLanguage=en-US</a></td></tr></table>
Any suggestions how to fix or work around this?I have updated Reporting Services to version 9.00.2040.00 but I am still
getting broken hyperlinks in subscription emails.
"PeterG" wrote:
> Users are receiving link-only subscriptions with broken links where the break
> always starts with an exclamation mark. It looks like this in email source
> view:
> <table><tr><td><span>My comment text added to
> subscription</span></td></tr></table><table><tr><td><span>The report is
> accessible at the following address:</span></td><tr><td><a
> href="http://links.10026.com/?link=http://servername/reportportal/viewreport.aspx?%2fEncoded+Report+Name&Par1=Encoded+param+value&&Par2=Encoded+param+value&r!
> s%3aParameterLanguage=en-US">http://servername/reportportal/viewreport.aspx?%2fEncoded+Report+Name&Par1=Encoded+param+value&&Par2=Encoded+param+value&rs%3aParameterLanguage=en-US</a></td></tr></table>
> Any suggestions how to fix or work around this?
>
Labels:
break,
broken,
database,
email,
emails,
exclamation,
hyperlinks,
link-only,
links,
mark,
microsoft,
mysql,
oracle,
receiving,
server,
sql,
starts,
subscription,
subscriptions,
users
Sunday, February 12, 2012
BPool error
I'm receiving this in my SQL errorlog:
ERRORLOG:2004-04-20 10:43:56.95 spid85 BPool::Map: no remappable address
found.
ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Distribution:
Stolen=126759 Free=1305 Procedures=0
ERRORLOG: Inram=0 Dirty=12894 Kept=0
ERRORLOG: I/O=50738, Latched=108, Other=1643204
ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Counts: Commited=1835008
Target=1835008 Hashed=1706944
ERRORLOG: InternalReservation=192 ExternalReservation=17101 Min Free=1024
ERRORLOG:2004-04-20 10:43:57.09 spid85 Procedure Cache: TotalProcs=0
TotalPages=0 InUsePages=0
ERRORLOG:2004-04-20 10:43:57.09 spid85 Dynamic Memory Manager:
Stolen=1178 OS Reserved=1648
ERRORLOG: OS Committed=1626
ERRORLOG: OS In Use=1616
ERRORLOG: Query Plan=20 Optimizer=0
ERRORLOG: General=2079
ERRORLOG: Utilities=151 Connection=252
ERRORLOG:2004-04-20 10:43:57.09 spid85 Global Memory Objects:
Resource=1770 Locks=131
ERRORLOG: SQLCache=92 Replication=2
ERRORLOG: LockBytes=2 ServerGlobal=53
ERRORLOG: Xact=75
ERRORLOG:2004-04-20 10:43:57.09 spid85 Query Memory Manager: Grants=2
Waiting=0 Maximum=138095 Available=66837
It looks very similar to what's mentioned in MS article 319477, except I
never receive an error 17803.
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?> I'm receiving this in my SQL errorlog:
> ERRORLOG:2004-04-20 10:43:56.95 spid85 BPool::Map: no remappable
address
> found.
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Distribution:
> Stolen=126759 Free=1305 Procedures=0
> ERRORLOG: Inram=0 Dirty=12894 Kept=0
> ERRORLOG: I/O=50738, Latched=108, Other=1643204
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Counts: Commited=1835008
> Target=1835008 Hashed=1706944
> ERRORLOG: InternalReservation=192 ExternalReservation=17101 Min Free=1024
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Procedure Cache: TotalProcs=0
> TotalPages=0 InUsePages=0
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Dynamic Memory Manager:
> Stolen=1178 OS Reserved=1648
> ERRORLOG: OS Committed=1626
> ERRORLOG: OS In Use=1616
> ERRORLOG: Query Plan=20 Optimizer=0
> ERRORLOG: General=2079
> ERRORLOG: Utilities=151 Connection=252
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Global Memory Objects:
> Resource=1770 Locks=131
> ERRORLOG: SQLCache=92 Replication=2
> ERRORLOG: LockBytes=2 ServerGlobal=53
> ERRORLOG: Xact=75
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Query Memory Manager: Grants=2
> Waiting=0 Maximum=138095 Available=66837
>
> It looks very similar to what's mentioned in MS article 319477, except I
> never receive an error 17803.
> I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
> configured to use 14GB from a total of 16GB on the server.
> Does anyone have any suggestions for how to address this?
--
Please open an incident with your local Microsoft Product Support so this
can be looked at.
Regards,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
ERRORLOG:2004-04-20 10:43:56.95 spid85 BPool::Map: no remappable address
found.
ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Distribution:
Stolen=126759 Free=1305 Procedures=0
ERRORLOG: Inram=0 Dirty=12894 Kept=0
ERRORLOG: I/O=50738, Latched=108, Other=1643204
ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Counts: Commited=1835008
Target=1835008 Hashed=1706944
ERRORLOG: InternalReservation=192 ExternalReservation=17101 Min Free=1024
ERRORLOG:2004-04-20 10:43:57.09 spid85 Procedure Cache: TotalProcs=0
TotalPages=0 InUsePages=0
ERRORLOG:2004-04-20 10:43:57.09 spid85 Dynamic Memory Manager:
Stolen=1178 OS Reserved=1648
ERRORLOG: OS Committed=1626
ERRORLOG: OS In Use=1616
ERRORLOG: Query Plan=20 Optimizer=0
ERRORLOG: General=2079
ERRORLOG: Utilities=151 Connection=252
ERRORLOG:2004-04-20 10:43:57.09 spid85 Global Memory Objects:
Resource=1770 Locks=131
ERRORLOG: SQLCache=92 Replication=2
ERRORLOG: LockBytes=2 ServerGlobal=53
ERRORLOG: Xact=75
ERRORLOG:2004-04-20 10:43:57.09 spid85 Query Memory Manager: Grants=2
Waiting=0 Maximum=138095 Available=66837
It looks very similar to what's mentioned in MS article 319477, except I
never receive an error 17803.
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?> I'm receiving this in my SQL errorlog:
> ERRORLOG:2004-04-20 10:43:56.95 spid85 BPool::Map: no remappable
address
> found.
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Distribution:
> Stolen=126759 Free=1305 Procedures=0
> ERRORLOG: Inram=0 Dirty=12894 Kept=0
> ERRORLOG: I/O=50738, Latched=108, Other=1643204
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Counts: Commited=1835008
> Target=1835008 Hashed=1706944
> ERRORLOG: InternalReservation=192 ExternalReservation=17101 Min Free=1024
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Procedure Cache: TotalProcs=0
> TotalPages=0 InUsePages=0
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Dynamic Memory Manager:
> Stolen=1178 OS Reserved=1648
> ERRORLOG: OS Committed=1626
> ERRORLOG: OS In Use=1616
> ERRORLOG: Query Plan=20 Optimizer=0
> ERRORLOG: General=2079
> ERRORLOG: Utilities=151 Connection=252
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Global Memory Objects:
> Resource=1770 Locks=131
> ERRORLOG: SQLCache=92 Replication=2
> ERRORLOG: LockBytes=2 ServerGlobal=53
> ERRORLOG: Xact=75
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Query Memory Manager: Grants=2
> Waiting=0 Maximum=138095 Available=66837
>
> It looks very similar to what's mentioned in MS article 319477, except I
> never receive an error 17803.
> I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
> configured to use 14GB from a total of 16GB on the server.
> Does anyone have any suggestions for how to address this?
--
Please open an incident with your local Microsoft Product Support so this
can be looked at.
Regards,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Labels:
addressfound,
bpool,
bpoolmap,
database,
error,
errorlog2004-04-20,
errorlogerrorlog2004-04-20,
microsoft,
mysql,
oracle,
receiving,
remappable,
server,
spid85,
sql
BPool error
I'm receiving this in my SQL errorlog:
ERRORLOG:2004-04-20 10:43:56.95 spid85 BPool::Map: no remappable address
found.
ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Distribution:
Stolen=126759 Free=1305 Procedures=0
ERRORLOG: Inram=0 Dirty=12894 Kept=0
ERRORLOG: I/O=50738, Latched=108, Other=1643204
ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Counts: Commited=1835008
Target=1835008 Hashed=1706944
ERRORLOG: InternalReservation=192 ExternalReservation=17101 Min Free=1024
ERRORLOG:2004-04-20 10:43:57.09 spid85 Procedure Cache: TotalProcs=0
TotalPages=0 InUsePages=0
ERRORLOG:2004-04-20 10:43:57.09 spid85 Dynamic Memory Manager:
Stolen=1178 OS Reserved=1648
ERRORLOG: OS Committed=1626
ERRORLOG: OS In Use=1616
ERRORLOG: Query Plan=20 Optimizer=0
ERRORLOG: General=2079
ERRORLOG: Utilities=151 Connection=252
ERRORLOG:2004-04-20 10:43:57.09 spid85 Global Memory Objects:
Resource=1770 Locks=131
ERRORLOG: SQLCache=92 Replication=2
ERRORLOG: LockBytes=2 ServerGlobal=53
ERRORLOG: Xact=75
ERRORLOG:2004-04-20 10:43:57.09 spid85 Query Memory Manager: Grants=2
Waiting=0 Maximum=138095 Available=66837
It looks very similar to what's mentioned in MS article 319477, except I
never receive an error 17803.
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?
> I'm receiving this in my SQL errorlog:
> ERRORLOG:2004-04-20 10:43:56.95 spid85 BPool::Map: no remappable
address
> found.
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Distribution:
> Stolen=126759 Free=1305 Procedures=0
> ERRORLOG: Inram=0 Dirty=12894 Kept=0
> ERRORLOG: I/O=50738, Latched=108, Other=1643204
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Counts: Commited=1835008
> Target=1835008 Hashed=1706944
> ERRORLOG: InternalReservation=192 ExternalReservation=17101 Min Free=1024
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Procedure Cache: TotalProcs=0
> TotalPages=0 InUsePages=0
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Dynamic Memory Manager:
> Stolen=1178 OS Reserved=1648
> ERRORLOG: OS Committed=1626
> ERRORLOG: OS In Use=1616
> ERRORLOG: Query Plan=20 Optimizer=0
> ERRORLOG: General=2079
> ERRORLOG: Utilities=151 Connection=252
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Global Memory Objects:
> Resource=1770 Locks=131
> ERRORLOG: SQLCache=92 Replication=2
> ERRORLOG: LockBytes=2 ServerGlobal=53
> ERRORLOG: Xact=75
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Query Memory Manager: Grants=2
> Waiting=0 Maximum=138095 Available=66837
>
> It looks very similar to what's mentioned in MS article 319477, except I
> never receive an error 17803.
> I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
> configured to use 14GB from a total of 16GB on the server.
> Does anyone have any suggestions for how to address this?
Please open an incident with your local Microsoft Product Support so this
can be looked at.
Regards,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
ERRORLOG:2004-04-20 10:43:56.95 spid85 BPool::Map: no remappable address
found.
ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Distribution:
Stolen=126759 Free=1305 Procedures=0
ERRORLOG: Inram=0 Dirty=12894 Kept=0
ERRORLOG: I/O=50738, Latched=108, Other=1643204
ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Counts: Commited=1835008
Target=1835008 Hashed=1706944
ERRORLOG: InternalReservation=192 ExternalReservation=17101 Min Free=1024
ERRORLOG:2004-04-20 10:43:57.09 spid85 Procedure Cache: TotalProcs=0
TotalPages=0 InUsePages=0
ERRORLOG:2004-04-20 10:43:57.09 spid85 Dynamic Memory Manager:
Stolen=1178 OS Reserved=1648
ERRORLOG: OS Committed=1626
ERRORLOG: OS In Use=1616
ERRORLOG: Query Plan=20 Optimizer=0
ERRORLOG: General=2079
ERRORLOG: Utilities=151 Connection=252
ERRORLOG:2004-04-20 10:43:57.09 spid85 Global Memory Objects:
Resource=1770 Locks=131
ERRORLOG: SQLCache=92 Replication=2
ERRORLOG: LockBytes=2 ServerGlobal=53
ERRORLOG: Xact=75
ERRORLOG:2004-04-20 10:43:57.09 spid85 Query Memory Manager: Grants=2
Waiting=0 Maximum=138095 Available=66837
It looks very similar to what's mentioned in MS article 319477, except I
never receive an error 17803.
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?
> I'm receiving this in my SQL errorlog:
> ERRORLOG:2004-04-20 10:43:56.95 spid85 BPool::Map: no remappable
address
> found.
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Distribution:
> Stolen=126759 Free=1305 Procedures=0
> ERRORLOG: Inram=0 Dirty=12894 Kept=0
> ERRORLOG: I/O=50738, Latched=108, Other=1643204
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Counts: Commited=1835008
> Target=1835008 Hashed=1706944
> ERRORLOG: InternalReservation=192 ExternalReservation=17101 Min Free=1024
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Procedure Cache: TotalProcs=0
> TotalPages=0 InUsePages=0
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Dynamic Memory Manager:
> Stolen=1178 OS Reserved=1648
> ERRORLOG: OS Committed=1626
> ERRORLOG: OS In Use=1616
> ERRORLOG: Query Plan=20 Optimizer=0
> ERRORLOG: General=2079
> ERRORLOG: Utilities=151 Connection=252
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Global Memory Objects:
> Resource=1770 Locks=131
> ERRORLOG: SQLCache=92 Replication=2
> ERRORLOG: LockBytes=2 ServerGlobal=53
> ERRORLOG: Xact=75
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Query Memory Manager: Grants=2
> Waiting=0 Maximum=138095 Available=66837
>
> It looks very similar to what's mentioned in MS article 319477, except I
> never receive an error 17803.
> I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
> configured to use 14GB from a total of 16GB on the server.
> Does anyone have any suggestions for how to address this?
Please open an incident with your local Microsoft Product Support so this
can be looked at.
Regards,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Labels:
addressfound,
bpool,
bpoolmap,
database,
error,
errorlog2004-04-20,
errorlogerrorlog2004-04-20,
microsoft,
mysql,
oracle,
receiving,
remappable,
server,
spid85,
sql
BPool error
I'm receiving this in my SQL errorlog:
ERRORLOG:2004-04-20 10:43:56.95 spid85 BPool::Map: no remappable address
found.
ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Distribution:
Stolen=126759 Free=1305 Procedures=0
ERRORLOG: Inram=0 Dirty=12894 Kept=0
ERRORLOG: I/O=50738, Latched=108, Other=1643204
ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Counts: Commited=1835008
Target=1835008 Hashed=1706944
ERRORLOG: InternalReservation=192 ExternalReservation=17101 Min Free=1024
ERRORLOG:2004-04-20 10:43:57.09 spid85 Procedure Cache: TotalProcs=0
TotalPages=0 InUsePages=0
ERRORLOG:2004-04-20 10:43:57.09 spid85 Dynamic Memory Manager:
Stolen=1178 OS Reserved=1648
ERRORLOG: OS Committed=1626
ERRORLOG: OS In Use=1616
ERRORLOG: Query Plan=20 Optimizer=0
ERRORLOG: General=2079
ERRORLOG: Utilities=151 Connection=252
ERRORLOG:2004-04-20 10:43:57.09 spid85 Global Memory Objects:
Resource=1770 Locks=131
ERRORLOG: SQLCache=92 Replication=2
ERRORLOG: LockBytes=2 ServerGlobal=53
ERRORLOG: Xact=75
ERRORLOG:2004-04-20 10:43:57.09 spid85 Query Memory Manager: Grants=2
Waiting=0 Maximum=138095 Available=66837
It looks very similar to what's mentioned in MS article 319477, except I
never receive an error 17803.
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?> I'm receiving this in my SQL errorlog:
> ERRORLOG:2004-04-20 10:43:56.95 spid85 BPool::Map: no remappable
address
> found.
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Distribution:
> Stolen=126759 Free=1305 Procedures=0
> ERRORLOG: Inram=0 Dirty=12894 Kept=0
> ERRORLOG: I/O=50738, Latched=108, Other=1643204
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Counts: Commited=1835008
> Target=1835008 Hashed=1706944
> ERRORLOG: InternalReservation=192 ExternalReservation=17101 Min Free=1024
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Procedure Cache: TotalProcs=0
> TotalPages=0 InUsePages=0
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Dynamic Memory Manager:
> Stolen=1178 OS Reserved=1648
> ERRORLOG: OS Committed=1626
> ERRORLOG: OS In Use=1616
> ERRORLOG: Query Plan=20 Optimizer=0
> ERRORLOG: General=2079
> ERRORLOG: Utilities=151 Connection=252
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Global Memory Objects:
> Resource=1770 Locks=131
> ERRORLOG: SQLCache=92 Replication=2
> ERRORLOG: LockBytes=2 ServerGlobal=53
> ERRORLOG: Xact=75
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Query Memory Manager: Grants=2
> Waiting=0 Maximum=138095 Available=66837
>
> It looks very similar to what's mentioned in MS article 319477, except I
> never receive an error 17803.
> I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
> configured to use 14GB from a total of 16GB on the server.
> Does anyone have any suggestions for how to address this?
--
Please open an incident with your local Microsoft Product Support so this
can be looked at.
Regards,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
ERRORLOG:2004-04-20 10:43:56.95 spid85 BPool::Map: no remappable address
found.
ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Distribution:
Stolen=126759 Free=1305 Procedures=0
ERRORLOG: Inram=0 Dirty=12894 Kept=0
ERRORLOG: I/O=50738, Latched=108, Other=1643204
ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Counts: Commited=1835008
Target=1835008 Hashed=1706944
ERRORLOG: InternalReservation=192 ExternalReservation=17101 Min Free=1024
ERRORLOG:2004-04-20 10:43:57.09 spid85 Procedure Cache: TotalProcs=0
TotalPages=0 InUsePages=0
ERRORLOG:2004-04-20 10:43:57.09 spid85 Dynamic Memory Manager:
Stolen=1178 OS Reserved=1648
ERRORLOG: OS Committed=1626
ERRORLOG: OS In Use=1616
ERRORLOG: Query Plan=20 Optimizer=0
ERRORLOG: General=2079
ERRORLOG: Utilities=151 Connection=252
ERRORLOG:2004-04-20 10:43:57.09 spid85 Global Memory Objects:
Resource=1770 Locks=131
ERRORLOG: SQLCache=92 Replication=2
ERRORLOG: LockBytes=2 ServerGlobal=53
ERRORLOG: Xact=75
ERRORLOG:2004-04-20 10:43:57.09 spid85 Query Memory Manager: Grants=2
Waiting=0 Maximum=138095 Available=66837
It looks very similar to what's mentioned in MS article 319477, except I
never receive an error 17803.
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?> I'm receiving this in my SQL errorlog:
> ERRORLOG:2004-04-20 10:43:56.95 spid85 BPool::Map: no remappable
address
> found.
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Distribution:
> Stolen=126759 Free=1305 Procedures=0
> ERRORLOG: Inram=0 Dirty=12894 Kept=0
> ERRORLOG: I/O=50738, Latched=108, Other=1643204
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Buffer Counts: Commited=1835008
> Target=1835008 Hashed=1706944
> ERRORLOG: InternalReservation=192 ExternalReservation=17101 Min Free=1024
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Procedure Cache: TotalProcs=0
> TotalPages=0 InUsePages=0
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Dynamic Memory Manager:
> Stolen=1178 OS Reserved=1648
> ERRORLOG: OS Committed=1626
> ERRORLOG: OS In Use=1616
> ERRORLOG: Query Plan=20 Optimizer=0
> ERRORLOG: General=2079
> ERRORLOG: Utilities=151 Connection=252
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Global Memory Objects:
> Resource=1770 Locks=131
> ERRORLOG: SQLCache=92 Replication=2
> ERRORLOG: LockBytes=2 ServerGlobal=53
> ERRORLOG: Xact=75
> ERRORLOG:2004-04-20 10:43:57.09 spid85 Query Memory Manager: Grants=2
> Waiting=0 Maximum=138095 Available=66837
>
> It looks very similar to what's mentioned in MS article 319477, except I
> never receive an error 17803.
> I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
> configured to use 14GB from a total of 16GB on the server.
> Does anyone have any suggestions for how to address this?
--
Please open an incident with your local Microsoft Product Support so this
can be looked at.
Regards,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Posts (Atom)