SSIS daily job scheduled fails with error in pffilestore.cpp
Hi, Here's the error OnError,NEGOLAPPC,NT AUTHORITY\SYSTEM,ST Limited Stats,{40424D1F-8609-46B7-8B76-55A42C2CC4C9},{776FA897-A327-44FA-8CFD-02FB47309177},7/16/2012 10:19:30 PM,7/16/2012 10:19:30 PM,-1056964608,0x,Internal error: An unexpected error occurred (file 'pffilestore.cpp', line 3352, function 'PFFileStore::HandleDataPageFault'). OnError,NEGOLAPPC,NT AUTHORITY\SYSTEM,IncrementalOLAPUpdatePackage,{F423D795-224C-4060-91D4-39677031038B},{776FA897-A327-44FA-8CFD-02FB47309177},7/16/2012 10:19:30 PM,7/16/2012 10:19:30 PM,-1056964608,0x,Internal error: An unexpected error occurred (file 'pffilestore.cpp', line 3352, function 'PFFileStore::HandleDataPageFault'). OnError,NEGOLAPPC,NT AUTHORITY\SYSTEM,ST Limited Stats,{40424D1F-8609-46B7-8B76-55A42C2CC4C9},{776FA897-A327-44FA-8CFD-02FB47309177},7/16/2012 10:19:31 PM,7/16/2012 10:19:31 PM,-1055129598,0x,Server: The operation has been cancelled. OnTaskFailed,,,ST Limited Stats,,,7/16/2012 2:02:50 PM,7/16/2012 2:02:50 PM,0,0x,(null)
July 17th, 2012 9:16am

Which version of SQL are you using? Try installing the latest Service Pack. FIX: Error message when you run an MDX query in SQL Server 2005 Analysis Services: "An unexpected error occurred (file 'pffilestore.cpp', line 3267, function 'PFFileStore::HandleDataPageFault')"
Free Windows Admin Tool Kit Click here and download it now
July 17th, 2012 9:20am

I am using SQL Server 2005 with service pack 3... I saw the posted you're suggesting but the line # returning the issue is different (3267 vs 3352) so it looks like this is a different issue...
July 17th, 2012 9:30am

Install Microsoft SQL Server 2005 Service Pack 4. The error may go away. Also you may check the hotfix from my previous post.
Free Windows Admin Tool Kit Click here and download it now
July 18th, 2012 2:23am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics