pfpagealloc error

I am running Sql Server 2005 SP 2 CTP and keep getting an error which says Internal Error pfpagealloc.cpp file is corrupt. This did not happen with SP1 and is very speradic. I get the problem when using both excel and the visual studio browser to manipulate an anylsis services database. I can then try again and everything works. I also get the same problem sometimes with my overnight rebuild of the cube.

Paul

Please, please. If you can catch the repro schenario, create a report with http://connect.microsoft.com/sql.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

We just applied SP 2 CTP and we are periodically getting the same error.

However, if we run the same MDX query immediately, we do not encounter it again. We can then run many other MDX queries without incident, but eventually we will generate the error again.

Error message is below:

Executing the query ...

Internal error: An unexpected error occurred (file 'pfpagealloc.cpp', line 428, function 'PFPageAllocator::PFPageAllocator').

Internal error: An unexpected error occurred (file 'pfpagealloc.cpp', line 428, function 'PFPageAllocator::PFPageAllocator').

Internal error: An unexpected error occurred (file 'pfpagealloc.cpp', line 428, function 'PFPageAllocator::PFPageAllocator').

Internal error: An unexpected error occurred (file 'pfpagealloc.cpp', line 428, function 'PFPageAllocator::PFPageAllocator').

Internal error: An unexpected error occurred (file 'pfpagealloc.cpp', line 428, function 'PFPageAllocator::PFPageAllocator').

Execution complete

|||

Please report this with http://connect.microsoft.com/sql.

This looks like a memory pressure problem. See if you get enoght memory for Analysis Server.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

This is exactly the issue I was getting and I did try to log my problem with connect. Unfortunately they obviously needed log files to be able to trace the problem and as unfortunately the system was live I had to go back to sp1.

Please let me know if you have any luck with a resolution I will contine to check on connect site.

pfpagealloc error

I am running Sql Server 2005 SP 2 CTP and keep getting an error which says Internal Error pfpagealloc.cpp file is corrupt. This did not happen with SP1 and is very speradic. I get the problem when using both excel and the visual studio browser to manipulate an anylsis services database. I can then try again and everything works. I also get the same problem sometimes with my overnight rebuild of the cube.

Paul

Please, please. If you can catch the repro schenario, create a report with http://connect.microsoft.com/sql.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

We just applied SP 2 CTP and we are periodically getting the same error.

However, if we run the same MDX query immediately, we do not encounter it again. We can then run many other MDX queries without incident, but eventually we will generate the error again.

Error message is below:

Executing the query ...

Internal error: An unexpected error occurred (file 'pfpagealloc.cpp', line 428, function 'PFPageAllocator::PFPageAllocator').

Internal error: An unexpected error occurred (file 'pfpagealloc.cpp', line 428, function 'PFPageAllocator::PFPageAllocator').

Internal error: An unexpected error occurred (file 'pfpagealloc.cpp', line 428, function 'PFPageAllocator::PFPageAllocator').

Internal error: An unexpected error occurred (file 'pfpagealloc.cpp', line 428, function 'PFPageAllocator::PFPageAllocator').

Internal error: An unexpected error occurred (file 'pfpagealloc.cpp', line 428, function 'PFPageAllocator::PFPageAllocator').

Execution complete

|||

Please report this with http://connect.microsoft.com/sql.

This looks like a memory pressure problem. See if you get enoght memory for Analysis Server.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

This is exactly the issue I was getting and I did try to log my problem with connect. Unfortunately they obviously needed log files to be able to trace the problem and as unfortunately the system was live I had to go back to sp1.

Please let me know if you have any luck with a resolution I will contine to check on connect site.

sql

Permission Issues On REPL folder

I'm replicating a database from a SQL server in our DMZ to a server in the
internal network. There is only a one way trust from internal box to
external box (external box cannot see internal). I setup DMZ database as
Publisher and Distributor. The internal box can only pull. When I initiate
a PULL I get a permission's error on REPL folder: The process could not
read file
'\\ServerName\REPLDATA\unc\ServerName_SQLDB_TRANS\ 20060117141721\SPECIAL_PRICES_1.sch' due to OS error 1326.
Any thoughts on how to resolve this permission issue.
thanks
rob
from your internal network on your subscriber can you ping ServerName your
publisher by the netbios name? If not make an entry in the hosts file.
Then using qa can you issue a xp_cmdshell 'net view \\ServerName' and how
about a 'dir \\ServerName\REPLDATA\unc\ServerName_SQLDB_TRANS\' ?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:46A6A4E8-0A5F-487F-9DFA-D7E01E02CFBB@.microsoft.com...
> I'm replicating a database from a SQL server in our DMZ to a server in the
> internal network. There is only a one way trust from internal box to
> external box (external box cannot see internal). I setup DMZ database as
> Publisher and Distributor. The internal box can only pull. When I
> initiate
> a PULL I get a permission's error on REPL folder: The process could not
> read file
> '\\ServerName\REPLDATA\unc\ServerName_SQLDB_TRANS\ 20060117141721\SPECIAL_PRICES_1.sch'
> due to OS error 1326.
> Any thoughts on how to resolve this permission issue.
> thanks
> rob
>
|||I can ping server with netbios name. I can access share folder using
\\servername\share\ at cmd prompt.
When I run "net view" at the xp_cmdshell I get "System error 5 has occurred"
and "Access is denied"
When I run "dir" at xp_cmdshell I get "Logon failure: unknown user name or
bad password."
Its definitely user access error. I can get the two servers to communicate
in windows, but not sure how to pass security thru to another sql server on
a separate network (DMZ).
thanks again
rob
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OiaaERKHGHA.3904@.TK2MSFTNGP10.phx.gbl...
> from your internal network on your subscriber can you ping ServerName your
> publisher by the netbios name? If not make an entry in the hosts file.
> Then using qa can you issue a xp_cmdshell 'net view \\ServerName' and how
> about a 'dir \\ServerName\REPLDATA\unc\ServerName_SQLDB_TRANS\' ?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> news:46A6A4E8-0A5F-487F-9DFA-D7E01E02CFBB@.microsoft.com...
>