Showing posts with label address. Show all posts
Showing posts with label address. Show all posts

Tuesday, March 27, 2012

ERROR: BPool::map: No remappable address

We are running SQL two node active-active cluster. Since yester day It failed over because of â'BPool::map: No remappable address foundâ' error.
Did some one face the problem? As this is a critical server, we need to fix the same at the earliest. Your valuable input is required.
Is this because of low memory or is it a bug'
( Sql Instance is running with 8GB memory and total OS memory is 15GB)
Following is the part of Logs before fail over:
Todays log:
2004-03-04 11:43:14.30 spid77 BPool::Map: no remappable address found.
2004-03-04 11:43:14.30 spid6 BPool::Map: no remappable address found.
2004-03-04 11:43:14.30 spid85 BPool::Map: no remappable address found.
2004-03-04 11:43:14.30 spid79 BPool::Map: no remappable address found.
2004-03-04 11:43:14.31 spid55 BPool::Map: no remappable address found.
2004-03-04 11:43:14.44 spid6 Buffer Distribution: Stolen=191234 Free=1498 Procedures=204
Inram=0 Dirty=19842 Kept=0
I/O=67, Latched=949, Other=814174
2004-03-04 11:43:14.44 spid6 Buffer Counts: Commited=1027968 Target=1027968 Hashed=835036
InternalReservation=213 ExternalReservation=22524 Min Free=1024
2004-03-04 11:43:14.44 spid6 Procedure Cache: TotalProcs=20 TotalPages=204 InUsePages=202
2004-03-04 11:43:14.44 spid6 Dynamic Memory Manager: Stolen=124482 OS Reserved=1616
OS Committed=1592
OS In Use=1567
Query Plan=560 Optimizer=0
General=12887
Utilities=1334 Connection=249
2004-03-04 11:43:14.44 spid6 Global Memory Objects: Resource=2068 Locks=112941
SQLCache=82 Replication=2
LockBytes=2 ServerGlobal=44
Xact=42
2004-03-04 11:43:14.44 spid6 Query Memory Manager: Grants=5 Waiting=7 Maximum=89476 Available=0
2004-03-04 11:43:14.44 spid79 Buffer Distribution: Stolen=191226 Free=1506 Procedures=204
Inram=0 Dirty=19842 Kept=0
I/O=67, Latched=948, Other=814175
2004-03-04 11:43:14.44 spid79 Buffer Counts: Commited=1027968 Target=1027968 Hashed=835028
InternalReservation=213 ExternalReservation=22524 Min Free=1024
2004-03-04 11:43:14.44 spid79 Procedure Cache: TotalProcs=20 TotalPages=204 InUsePages=202
2004-03-04 11:43:14.44 spid79 Dynamic Memory Manager: Stolen=124482 OS Reserved=1616
OS Committed=1592
OS In Use=1567
Query Plan=560 Optimizer=0
General=12887
Utilities=1334 Connection=249
Yesterday log:
2004-03-03 14:50:27.72 spid90 BPool::Map: no remappable address found.
2004-03-03 14:50:27.74 spid109 BPool::Map: no remappable address found.
2004-03-03 14:50:27.74 spid56 BPool::Map: no remappable address found.
2004-03-03 14:50:27.74 spid52 BPool::Map: no remappable address found.
2004-03-03 14:50:27.75 spid105 BPool::Map: no remappable address found.
2004-03-03 14:50:27.75 spid104 BPool::Map: no remappable address found.
2004-03-03 14:50:27.80 spid100 BPool::Map: no remappable address found.
2004-03-03 14:50:27.80 spid111 BPool::Map: no remappable address found.
2004-03-03 14:50:27.80 spid100 BPool::Map: no remappable address found.
2004-03-03 14:50:27.89 spid109 Buffer Distribution: Stolen=191002 Free=1171 Procedures=174
2004-03-03 14:50:27.89 spid56 Buffer Distribution: Stolen=191002 Free=1171 Procedures=174
Inram=0 Dirty=10927 Kept=0
I/O=0, Latched=1214, Other=823480
Inram=0 Dirty=10927 Kept=0
I/O=0, Latched=1214, Other=823480
2004-03-03 14:50:27.91 spid56 Buffer Counts: Commited=1027968 Target=1027968 Hashed=835622
InternalReservation=250 ExternalReservation=2278 Min Free=1024
2004-03-03 14:50:27.91 spid109 Buffer Counts: Commited=1027968 Target=1027968 Hashed=835622
InternalReservation=250 ExternalReservation=2278 Min Free=1024
2004-03-03 14:50:27.91 spid56 Procedure Cache: TotalProcs=21 TotalPages=174 InUsePages=170
2004-03-03 14:50:27.91 spid109 Procedure Cache: TotalProcs=21 TotalPages=174 InUsePages=170
2004-03-03 14:50:27.91 spid56 Dynamic Memory Manager: Stolen=117319 OS Reserved=1632
OS Committed=1608
OS In Use=1599
Query Plan=865 Optimizer=14
General=5999
Utilities=838 Connection=403
2004-03-03 14:50:27.91 spid109 Dynamic Memory Manager: Stolen=117319 OS Reserved=1632
OS Committed=1608
OS In Use=1599
Query Plan=865 Optimizer=14
General=5999
Utilities=838 Connection=403
2004-03-03 14:50:27.91 spid56 Global Memory Objects: Resource=3621 Locks=112718
SQLCache=94 Replication=2
LockBytes=2 ServerGlobal=62
Xact=74
2004-03-03 14:50:27.91 spid109 Global Memory Objects: Resource=3621 Locks=112718
SQLCache=94 Replication=2
LockBytes=2 ServerGlobal=62
Xact=74
2004-03-03 14:50:27.91 spid56 Query Memory Manager: Grants=5 Waiting=10 Maximum=76134 Available=0
2004-03-03 14:50:27.91 spid109 Query Memory Manager: Grants=5 Waiting=10 Maximum=76134 Available=0
2004-03-03 14:50:27.91 spid104 Buffer Distribution: Stolen=191003 Free=1170 Procedures=174
Inram=0 Dirty=10927 Kept=0
I/O=0, Latched=1214, Other=823480
2004-03-03 14:50:27.91 spid104 Buffer Counts: Commited=1027968 Target=1027968 Hashed=835621
InternalReservation=250 ExternalReservation=2278 Min Free=1024
2004-03-03 14:50:27.91 spid104 Procedure Cache: TotalProcs=21 TotalPages=174 InUsePages=170
2004-03-03 14:50:27.91 spid104 Dynamic Memory Manager: Stolen=117319 OS Reserved=1632
OS Committed=1608
OS In Use=1599
Query Plan=865 Optimizer=14
General=5999
Utilities=838 Connection=403
2004-03-03 14:50:27.91 spid104 Global Memory Objects: Resource=3621 Locks=112718
SQLCache=94 Replication=2
LockBytes=2 ServerGlobal=62
Xact=74I would contact PSS about this one
http://support.microsoft.com/default.aspx?scid=fh;en-us;Prodoffer41a
I can't recall seeing this before but it sounds like there may be an issue
with AWE. Do you have both /3GB and /PAE enabled or just /PAE in boot.ini ?
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hemant" <anonymous@.discussions.microsoft.com> wrote in message
news:2F94E672-07F4-4554-9D0D-BC2F7CC3E164@.microsoft.com...
> We are running SQL two node active-active cluster. Since yester day It
failed over because of "BPool::map: No remappable address found" error.
> Did some one face the problem? As this is a critical server, we need to
fix the same at the earliest. Your valuable input is required.
> Is this because of low memory or is it a bug'
> ( Sql Instance is running with 8GB memory and total OS memory is 15GB)
> Following is the part of Logs before fail over:
> Todays log:
>
> 2004-03-04 11:43:14.30 spid77 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.30 spid6 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.30 spid85 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.30 spid79 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.31 spid55 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.44 spid6 Buffer Distribution: Stolen=191234
Free=1498 Procedures=204
> Inram=0 Dirty=19842 Kept=0
> I/O=67, Latched=949, Other=814174
> 2004-03-04 11:43:14.44 spid6 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835036
> InternalReservation=213 ExternalReservation=22524
Min Free=1024
> 2004-03-04 11:43:14.44 spid6 Procedure Cache: TotalProcs TotalPages=204 InUsePages=202
> 2004-03-04 11:43:14.44 spid6 Dynamic Memory Manager: Stolen=124482 OS
Reserved=1616
> OS Committed=1592
> OS In Use=1567
> Query Plan=560 Optimizer=0
> General=12887
> Utilities=1334 Connection=249
> 2004-03-04 11:43:14.44 spid6 Global Memory Objects: Resource=2068
Locks=112941
> SQLCache=82 Replication=2
> LockBytes=2 ServerGlobal=44
> Xact=42
> 2004-03-04 11:43:14.44 spid6 Query Memory Manager: Grants=5 Waiting=7
Maximum=89476 Available=0
> 2004-03-04 11:43:14.44 spid79 Buffer Distribution: Stolen=191226
Free=1506 Procedures=204
> Inram=0 Dirty=19842 Kept=0
> I/O=67, Latched=948, Other=814175
> 2004-03-04 11:43:14.44 spid79 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835028
> InternalReservation=213 ExternalReservation=22524
Min Free=1024
> 2004-03-04 11:43:14.44 spid79 Procedure Cache: TotalProcs TotalPages=204 InUsePages=202
> 2004-03-04 11:43:14.44 spid79 Dynamic Memory Manager: Stolen=124482 OS
Reserved=1616
> OS Committed=1592
> OS In Use=1567
> Query Plan=560 Optimizer=0
> General=12887
> Utilities=1334 Connection=249
> Yesterday log:
> 2004-03-03 14:50:27.72 spid90 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.74 spid109 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.74 spid56 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.74 spid52 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.75 spid105 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.75 spid104 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.80 spid100 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.80 spid111 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.80 spid100 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.89 spid109 Buffer Distribution: Stolen=191002
Free=1171 Procedures=174
> 2004-03-03 14:50:27.89 spid56 Buffer Distribution: Stolen=191002
Free=1171 Procedures=174
> Inram=0 Dirty=10927 Kept=0
> I/O=0, Latched=1214, Other=823480
> Inram=0 Dirty=10927 Kept=0
> I/O=0, Latched=1214, Other=823480
> 2004-03-03 14:50:27.91 spid56 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835622
> InternalReservation=250 ExternalReservation=2278
Min Free=1024
> 2004-03-03 14:50:27.91 spid109 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835622
> InternalReservation=250 ExternalReservation=2278
Min Free=1024
> 2004-03-03 14:50:27.91 spid56 Procedure Cache: TotalProcs=21
TotalPages=174 InUsePages=170
> 2004-03-03 14:50:27.91 spid109 Procedure Cache: TotalProcs=21
TotalPages=174 InUsePages=170
> 2004-03-03 14:50:27.91 spid56 Dynamic Memory Manager: Stolen=117319 OS
Reserved=1632
> OS Committed=1608
> OS In Use=1599
> Query Plan=865 Optimizer=14
> General=5999
> Utilities=838 Connection=403
> 2004-03-03 14:50:27.91 spid109 Dynamic Memory Manager: Stolen=117319 OS
Reserved=1632
> OS Committed=1608
> OS In Use=1599
> Query Plan=865 Optimizer=14
> General=5999
> Utilities=838 Connection=403
> 2004-03-03 14:50:27.91 spid56 Global Memory Objects: Resource=3621
Locks=112718
> SQLCache=94 Replication=2
> LockBytes=2 ServerGlobal=62
> Xact=74
> 2004-03-03 14:50:27.91 spid109 Global Memory Objects: Resource=3621
Locks=112718
> SQLCache=94 Replication=2
> LockBytes=2 ServerGlobal=62
> Xact=74
> 2004-03-03 14:50:27.91 spid56 Query Memory Manager: Grants=5
Waiting=10 Maximum=76134 Available=0
> 2004-03-03 14:50:27.91 spid109 Query Memory Manager: Grants=5
Waiting=10 Maximum=76134 Available=0
> 2004-03-03 14:50:27.91 spid104 Buffer Distribution: Stolen=191003
Free=1170 Procedures=174
> Inram=0 Dirty=10927 Kept=0
> I/O=0, Latched=1214, Other=823480
> 2004-03-03 14:50:27.91 spid104 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835621
> InternalReservation=250 ExternalReservation=2278
Min Free=1024
> 2004-03-03 14:50:27.91 spid104 Procedure Cache: TotalProcs=21
TotalPages=174 InUsePages=170
> 2004-03-03 14:50:27.91 spid104 Dynamic Memory Manager: Stolen=117319 OS
Reserved=1632
> OS Committed=1608
> OS In Use=1599
> Query Plan=865 Optimizer=14
> General=5999
> Utilities=838 Connection=403
> 2004-03-03 14:50:27.91 spid104 Global Memory Objects: Resource=3621
Locks=112718
> SQLCache=94 Replication=2
> LockBytes=2 ServerGlobal=62
> Xact=74
>
Posted by ling at 9:52 PM 0 comments
Labels: , , , , , , , , , , , , , , , ,

ERROR: BPool::map: No remappable address

We are running SQL two node active-active cluster. Since yester day It faile
d over because of “BPool::map: No remappable address found” error.
Did some one face the problem? As this is a critical server, we need to fi
x the same at the earliest. Your valuable input is required.
Is this because of low memory or is it a bug'
( Sql Instance is running with 8GB memory and total OS memory is 15GB)
Following is the part of Logs before fail over:
Todays log:
2004-03-04 11:43:14.30 spid77 BPool::Map: no remappable address found.
2004-03-04 11:43:14.30 spid6 BPool::Map: no remappable address found.
2004-03-04 11:43:14.30 spid85 BPool::Map: no remappable address found.
2004-03-04 11:43:14.30 spid79 BPool::Map: no remappable address found.
2004-03-04 11:43:14.31 spid55 BPool::Map: no remappable address found.
2004-03-04 11:43:14.44 spid6 Buffer Distribution: Stolen=191234 Free=14
98 Procedures=204
Inram=0 Dirty=19842 Kept=0
I/O=67, Latched=949, Other=814174
2004-03-04 11:43:14.44 spid6 Buffer Counts: Commited=1027968 Target=102
7968 Hashed=835036
InternalReservation=213 ExternalReservation=22524 Min Free=1024
2004-03-04 11:43:14.44 spid6 Procedure Cache: TotalProcs=20 TotalPages=
204 InUsePages=202
2004-03-04 11:43:14.44 spid6 Dynamic Memory Manager: Stolen=124482 OS R
eserved=1616
OS Committed=1592
OS In Use=1567
Query Plan=560 Optimizer=0
General=12887
Utilities=1334 Connection=249
2004-03-04 11:43:14.44 spid6 Global Memory Objects: Resource=2068 Locks
=112941
SQLCache=82 Replication=2
LockBytes=2 ServerGlobal=44
Xact=42
2004-03-04 11:43:14.44 spid6 Query Memory Manager: Grants=5 Waiting=7 M
aximum=89476 Available=0
2004-03-04 11:43:14.44 spid79 Buffer Distribution: Stolen=191226 Free=15
06 Procedures=204
Inram=0 Dirty=19842 Kept=0
I/O=67, Latched=948, Other=814175
2004-03-04 11:43:14.44 spid79 Buffer Counts: Commited=1027968 Target=102
7968 Hashed=835028
InternalReservation=213 ExternalReservation=22524 Min Free=1024
2004-03-04 11:43:14.44 spid79 Procedure Cache: TotalProcs=20 TotalPages=
204 InUsePages=202
2004-03-04 11:43:14.44 spid79 Dynamic Memory Manager: Stolen=124482 OS R
eserved=1616
OS Committed=1592
OS In Use=1567
Query Plan=560 Optimizer=0
General=12887
Utilities=1334 Connection=249
Yesterday log:
2004-03-03 14:50:27.72 spid90 BPool::Map: no remappable address found.
2004-03-03 14:50:27.74 spid109 BPool::Map: no remappable address found.
2004-03-03 14:50:27.74 spid56 BPool::Map: no remappable address found.
2004-03-03 14:50:27.74 spid52 BPool::Map: no remappable address found.
2004-03-03 14:50:27.75 spid105 BPool::Map: no remappable address found.
2004-03-03 14:50:27.75 spid104 BPool::Map: no remappable address found.
2004-03-03 14:50:27.80 spid100 BPool::Map: no remappable address found.
2004-03-03 14:50:27.80 spid111 BPool::Map: no remappable address found.
2004-03-03 14:50:27.80 spid100 BPool::Map: no remappable address found.
2004-03-03 14:50:27.89 spid109 Buffer Distribution: Stolen=191002 Free=11
71 Procedures=174
2004-03-03 14:50:27.89 spid56 Buffer Distribution: Stolen=191002 Free=11
71 Procedures=174
Inram=0 Dirty=10927 Kept=0
I/O=0, Latched=1214, Other=823480
Inram=0 Dirty=10927 Kept=0
I/O=0, Latched=1214, Other=823480
2004-03-03 14:50:27.91 spid56 Buffer Counts: Commited=1027968 Target=102
7968 Hashed=835622
InternalReservation=250 ExternalReservation=2278 Min Free=1024
2004-03-03 14:50:27.91 spid109 Buffer Counts: Commited=1027968 Target=102
7968 Hashed=835622
InternalReservation=250 ExternalReservation=2278 Min Free=1024
2004-03-03 14:50:27.91 spid56 Procedure Cache: TotalProcs=21 TotalPages=
174 InUsePages=170
2004-03-03 14:50:27.91 spid109 Procedure Cache: TotalProcs=21 TotalPages=
174 InUsePages=170
2004-03-03 14:50:27.91 spid56 Dynamic Memory Manager: Stolen=117319 OS R
eserved=1632
OS Committed=1608
OS In Use=1599
Query Plan=865 Optimizer=14
General=5999
Utilities=838 Connection=403
2004-03-03 14:50:27.91 spid109 Dynamic Memory Manager: Stolen=117319 OS R
eserved=1632
OS Committed=1608
OS In Use=1599
Query Plan=865 Optimizer=14
General=5999
Utilities=838 Connection=403
2004-03-03 14:50:27.91 spid56 Global Memory Objects: Resource=3621 Locks
=112718
SQLCache=94 Replication=2
LockBytes=2 ServerGlobal=62
Xact=74
2004-03-03 14:50:27.91 spid109 Global Memory Objects: Resource=3621 Locks
=112718
SQLCache=94 Replication=2
LockBytes=2 ServerGlobal=62
Xact=74
2004-03-03 14:50:27.91 spid56 Query Memory Manager: Grants=5 Waiting=10
Maximum=76134 Available=0
2004-03-03 14:50:27.91 spid109 Query Memory Manager: Grants=5 Waiting=10
Maximum=76134 Available=0
2004-03-03 14:50:27.91 spid104 Buffer Distribution: Stolen=191003 Free=11
70 Procedures=174
Inram=0 Dirty=10927 Kept=0
I/O=0, Latched=1214, Other=823480
2004-03-03 14:50:27.91 spid104 Buffer Counts: Commited=1027968 Target=102
7968 Hashed=835621
InternalReservation=250 ExternalReservation=2278 Min Free=1024
2004-03-03 14:50:27.91 spid104 Procedure Cache: TotalProcs=21 TotalPages=
174 InUsePages=170
2004-03-03 14:50:27.91 spid104 Dynamic Memory Manager: Stolen=117319 OS R
eserved=1632
OS Committed=1608
OS In Use=1599
Query Plan=865 Optimizer=14
General=5999
Utilities=838 Connection=403
2004-03-03 14:50:27.91 spid104 Global Memory Objects: Resource=3621 Locks
=112718
SQLCache=94 Replication=2
LockBytes=2 ServerGlobal=62
Xact=74I would contact PSS about this one
http://support.microsoft.com/defaul...us;Prodoffer41a
I can't recall seeing this before but it sounds like there may be an issue
with AWE. Do you have both /3GB and /PAE enabled or just /PAE in boot.ini ?
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hemant" <anonymous@.discussions.microsoft.com> wrote in message
news:2F94E672-07F4-4554-9D0D-BC2F7CC3E164@.microsoft.com...
> We are running SQL two node active-active cluster. Since yester day It
failed over because of "BPool::map: No remappable address found" error.
> Did some one face the problem? As this is a critical server, we need to
fix the same at the earliest. Your valuable input is required.
> Is this because of low memory or is it a bug'
> ( Sql Instance is running with 8GB memory and total OS memory is 15GB)
> Following is the part of Logs before fail over:
> Todays log:
>
> 2004-03-04 11:43:14.30 spid77 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.30 spid6 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.30 spid85 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.30 spid79 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.31 spid55 BPool::Map: no remappable address found.
> 2004-03-04 11:43:14.44 spid6 Buffer Distribution: Stolen=191234
Free=1498 Procedures=204
> Inram=0 Dirty=19842 Kept=0
> I/O=67, Latched=949, Other=814174
> 2004-03-04 11:43:14.44 spid6 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835036
> InternalReservation=213 ExternalReservation=22524
Min Free=1024
> 2004-03-04 11:43:14.44 spid6 Procedure Cache: TotalProcs=20
TotalPages=204 InUsePages=202
> 2004-03-04 11:43:14.44 spid6 Dynamic Memory Manager: Stolen=124482 OS
Reserved=1616
> OS Committed=1592
> OS In Use=1567
> Query Plan=560 Optimizer=0
> General=12887
> Utilities=1334 Connection=249
> 2004-03-04 11:43:14.44 spid6 Global Memory Objects: Resource=2068
Locks=112941
> SQLCache=82 Replication=2
> LockBytes=2 ServerGlobal=44
> Xact=42
> 2004-03-04 11:43:14.44 spid6 Query Memory Manager: Grants=5 Waiting=7
Maximum=89476 Available=0
> 2004-03-04 11:43:14.44 spid79 Buffer Distribution: Stolen=191226
Free=1506 Procedures=204
> Inram=0 Dirty=19842 Kept=0
> I/O=67, Latched=948, Other=814175
> 2004-03-04 11:43:14.44 spid79 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835028
> InternalReservation=213 ExternalReservation=22524
Min Free=1024
> 2004-03-04 11:43:14.44 spid79 Procedure Cache: TotalProcs=20
TotalPages=204 InUsePages=202
> 2004-03-04 11:43:14.44 spid79 Dynamic Memory Manager: Stolen=124482 OS
Reserved=1616
> OS Committed=1592
> OS In Use=1567
> Query Plan=560 Optimizer=0
> General=12887
> Utilities=1334 Connection=249
> Yesterday log:
> 2004-03-03 14:50:27.72 spid90 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.74 spid109 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.74 spid56 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.74 spid52 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.75 spid105 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.75 spid104 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.80 spid100 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.80 spid111 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.80 spid100 BPool::Map: no remappable address found.
> 2004-03-03 14:50:27.89 spid109 Buffer Distribution: Stolen=191002
Free=1171 Procedures=174
> 2004-03-03 14:50:27.89 spid56 Buffer Distribution: Stolen=191002
Free=1171 Procedures=174
> Inram=0 Dirty=10927 Kept=0
> I/O=0, Latched=1214, Other=823480
> Inram=0 Dirty=10927 Kept=0
> I/O=0, Latched=1214, Other=823480
> 2004-03-03 14:50:27.91 spid56 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835622
> InternalReservation=250 ExternalReservation=2278
Min Free=1024
> 2004-03-03 14:50:27.91 spid109 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835622
> InternalReservation=250 ExternalReservation=2278
Min Free=1024
> 2004-03-03 14:50:27.91 spid56 Procedure Cache: TotalProcs=21
TotalPages=174 InUsePages=170
> 2004-03-03 14:50:27.91 spid109 Procedure Cache: TotalProcs=21
TotalPages=174 InUsePages=170
> 2004-03-03 14:50:27.91 spid56 Dynamic Memory Manager: Stolen=117319 OS
Reserved=1632
> OS Committed=1608
> OS In Use=1599
> Query Plan=865 Optimizer=14
> General=5999
> Utilities=838 Connection=403
> 2004-03-03 14:50:27.91 spid109 Dynamic Memory Manager: Stolen=117319 OS
Reserved=1632
> OS Committed=1608
> OS In Use=1599
> Query Plan=865 Optimizer=14
> General=5999
> Utilities=838 Connection=403
> 2004-03-03 14:50:27.91 spid56 Global Memory Objects: Resource=3621
Locks=112718
> SQLCache=94 Replication=2
> LockBytes=2 ServerGlobal=62
> Xact=74
> 2004-03-03 14:50:27.91 spid109 Global Memory Objects: Resource=3621
Locks=112718
> SQLCache=94 Replication=2
> LockBytes=2 ServerGlobal=62
> Xact=74
> 2004-03-03 14:50:27.91 spid56 Query Memory Manager: Grants=5
Waiting=10 Maximum=76134 Available=0
> 2004-03-03 14:50:27.91 spid109 Query Memory Manager: Grants=5
Waiting=10 Maximum=76134 Available=0
> 2004-03-03 14:50:27.91 spid104 Buffer Distribution: Stolen=191003
Free=1170 Procedures=174
> Inram=0 Dirty=10927 Kept=0
> I/O=0, Latched=1214, Other=823480
> 2004-03-03 14:50:27.91 spid104 Buffer Counts: Commited=1027968
Target=1027968 Hashed=835621
> InternalReservation=250 ExternalReservation=2278
Min Free=1024
> 2004-03-03 14:50:27.91 spid104 Procedure Cache: TotalProcs=21
TotalPages=174 InUsePages=170
> 2004-03-03 14:50:27.91 spid104 Dynamic Memory Manager: Stolen=117319 OS
Reserved=1632
> OS Committed=1608
> OS In Use=1599
> Query Plan=865 Optimizer=14
> General=5999
> Utilities=838 Connection=403
> 2004-03-03 14:50:27.91 spid104 Global Memory Objects: Resource=3621
Locks=112718
> SQLCache=94 Replication=2
> LockBytes=2 ServerGlobal=62
> Xact=74
>
Posted by ling at 9:51 PM 0 comments
Labels: , , , , , , , , , , , , , , ,

Friday, March 9, 2012

Error with using nvarchar datatype

Hi, I have created a database using VWD to keep values of urls and have structured it as...

Prefix (http://, network name),address(www.name.com), andname (name of address), theaddress field has been defined as a nvarchar(MAX).

Most of the addresses updated into the address field work, except something like:www.java-scripts.net/javascripts/Image-Rollover-Script.phtml.

I get this error:

Cannot open user default database. Login failed.
Login failed for user 'NETWORKNAME\ASPNET'.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'NETWORKNAME\ASPNET'.

Source Error:

Line 1176: if (((this.Adapter.InsertCommand.Connection.State & System.Data.ConnectionState.Open) Line 1177: != System.Data.ConnectionState.Open)) {Line 1178: this.Adapter.InsertCommand.Connection.Open();Line 1179: }Line 1180: try {

I can insert something likewww.google.com into theaddresses field without any errors. Any ideas why?
If it is a nvarchar type it should be able to except all sorts of characters??

The error itself has nothing to do with datatypes. It's a connection error which implies that you have invalid credentials in the connection string (it seems to run using integrated Windows authentication).

|||

Hello, I apologise, but i was checking something in the database when I was writing this post. After closing the connection and re-entering the field entry >www.java-scripts.net/javascripts/Image-Rollover-Script.phtml

Here is the error i have been getting:

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Source Error:

Line 1095: this.Adapter.SelectCommand = this.CommandCollection[0];Line 1096: TasksDataSet.intranet_addressesDataTable dataTable = new TasksDataSet.intranet_addressesDataTable();Line 1097: this.Adapter.Fill(dataTable);Line 1098: return dataTable;Line 1099: }

Hope this makes sense. If I delete the submitted value from the database and re-enter something likewww.google.com, it works fine.
So why would a URL likewww.java-scripts.net/javascripts/Image-Rollover-Script.phtml cause the above error?

|||

Ah, the dreaded ConstraintException.. The error is in the DataTable, not in the query execution. You can get a better error message by catching the exception and sending it to this method:

public static string ConstraintExceptionToString(ConstraintException ce, DataTable dt) {return"Constraint Exception [" + ce.Message +"] in " + dt.TableName +" (" + dt.Rows.Count +" rows)\n" + DataTableErrorsToString(dt);}public static string DataTableErrorsToString(DataTable dt) {StringBuilder sb =new StringBuilder();for (int x=0; xif (dr.HasErrors) {sb.Append("\tError in row " + x +": " + dr.RowError +"\n");}}return sb.ToString();}
|||

Very interesting, where abouts would I place the above script?

|||

Oohh...don't say "script"... .NET developers will look strangely upon you...Smile

The methods are just helper methods that will retrieve the actual constraint error. For simplicity's sake we can add them to the same class as your data filling method.

this.Adapter.SelectCommand =this.CommandCollection[0];
 TasksDataSet.intranet_addressesDataTable dataTable =new TasksDataSet.intranet_addressesDataTable();
try{this.Adapter.Fill(dataTable);
}
catch(ConstraintException ce)
{
throw new ConstraintException(ConstraintExceptionToString(ce,dataTable),ce);
}
return dataTable;
}
public static string ConstraintExceptionToString(ConstraintException ce, DataTable dt)
{
return"Constraint Exception [" + ce.Message +"] in " + dt.TableName +" (" + dt.Rows.Count +" rows)\n" +
DataTableErrorsToString(dt);
}
public static string DataTableErrorsToString(DataTable dt)
{
StringBuilder sb =new StringBuilder();
for (int x=0; x < dt.Rows.Count; x++)
{
DataRow dr = dt.Rows[x];
if (dr.HasErrors)
{
sb.Append("\tError in row " + x +": " + dr.RowError +"\n");
}
}
return sb.ToString();
}


|||

Cheers Gunteman, I'll have to remember that for my future post! Ahem, one more question.

I am working with Visual Web Developer, and the files I am working with are...

index.aspx (holds the gridview and dataset information), The TaskDataSet.xsd and the database itself.
In which of the files in my Visual Web Developer do I place the above method, or do I open a class in VWD to place it into?

I did have a try implementing the above before posting, but still not sure where it goes...

I appreciate any more help you can pass my way :-)

|||

You would probably be better off using nvarchar(2048) than nvarchar(max). As far as I am aware, there isn't a defined limit, but most browsers (IE, etc.) won't handle more than that, and some proxies/security scanners won't allow more than 1024.

|||

Hi, thanks for the reply. I have updated it from MAX to 2048, so thats very cool to know.

But it hasnt fixed my problem with inserting the following address into my database:www.java-scripts.net/javascripts/Image-Rollover-Script.phtml

|||

jamesstar:

I did have a try implementing the above before posting, but still not sure where it goes...

I appreciate any more help you can pass my way :-)

If you look closely you''ll see that I've just continued from the portion of your code that was visible in the error message.

|||

Ah yes, I see now... :-D

Hmm, that code comes from a temporary App_Code (something).cs file within the framework.
So I gather even if I changed that one file, it wouldnt be permanent, I will do some further research and see if I can locate the hard copy of that file.

I thought you might be able to create a CS file inside the App_Code folder that could be shared across all files.

Okay, chat soon.

|||

Okay, after visiting a few more forums and hands in head. I started reading through each line in the error code and noticed the dataset code had not updated itself.

It was still referencing each column in the table with nvarchar(MAX), even though I had updated the database.

So I deleted my current dataset file and re-inserted it back in... and now, wonderfully enough... my aspx page works!

Yahhh ~ Thank you!!

*** Don't give up hope, just keep going forward ;-)

Posted by ling at 2:01 AM 0 comments
Labels: , , , , , , , , , , , , , , , , ,

Sunday, February 26, 2012

Error whils accessing Report Manager through browser

Hi friends ,

We are using SQL Server Reporting Services 2005. When I want to access Report Server through browser I am giving IP address as

http://<servername>/ReportServer

this is working fine

but when I want to access Report Manager and when I am giving IP address as

http://<servername>/Reports

I am getting error as followes :

The configuration file contains an element that is not valid. The configuration element is not a configuration file element.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: The configuration file contains an element that is not valid. The configuration element is not a configuration file element.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace:

[Exception: The configuration file contains an element that is not valid. The configuration element is not a configuration file element.]

Microsoft.ReportingServices.Diagnostics.RSConfiguration.ThrowInvalidFormat(String element) +41

Microsoft.ReportingServices.Diagnostics.RSConfiguration.ParseDocument() +135

Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +32

[ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.]

Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +166

Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName) +62

Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location) +296

Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation) +134

Microsoft.ReportingServices.UI.Global.get_ConfigurationManager() +84

Microsoft.ReportingServices.UI.Global.get_Configuration() +4

Microsoft.ReportingServices.UI.GlobalApp.Application_AuthenticateRequest(Object sender, EventArgs e) +84

System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92

System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

Where I am going wrong.

we are now in the stage of deploying and we are getting this kind of errors

can you help me out ?

sandeey

Hi,

seems that you screwed up the configuration files. To see which one is corrupted (your web services seems to work), navigate to C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager or the appropiate path in your installation and validate the XML files by the schema mentioned in the header of the file.

If you have no tools to validate through the schema, you can also take a fresh and working file from antoher instalaltion and look for typos or any things that are different to your damaged file.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Posted by ling at 9:29 PM 0 comments
Labels: , , , , , , , , , , , , , , , ,
Subscribe to: Posts (Atom)