Sunday, March 25, 2012

DTS Exception loading BI Accelerator data

I have been playing with the BI Accelerator more than once, but I was
never able to build anything that works, so I'd like to see if anyone
can help me.
I'm having a problem during the data load phase: all other phases were
executed correctly, the db and all the cubes were created without
errors, but the msbiso_update.bat (the script that executes the DTS
jobs used to load the data) ends with an exception: "Unhandled
exception at 0x015f20bf in dtsrun.exe: 0xc00000005: Access violation
reading location 0x00000000".
The log files don't show any errors, but looking at the db tables it
seems that only the time dimension tables have been loaded. All the
other tables are empty.
Unfortunately this is blocking, I can't use BI Accelerator if I'm not
able to solve this problem. I entered debug mode to get more
information about the error. In the (unlikely) event that someone is
able to understand the source of the problem looking at the
disassembly, here are a few lines around the error position:
015F20B0 ret 0Ch
015F20B3 mov ecx,dword ptr [esp+10h]
015F20B7 push ebx
015F20B8 push edx
015F20B9 mov eax,dword ptr [ecx+8]
015F20BC push eax
015F20BD mov ecx,dword ptr [eax]
015F20BF call dword ptr [ecx]
015F20C1 mov edi,eax
015F20C3 call 015F1A70
The access violation occurs on the first call instruction (015F20BF).
I checked with the debugger, and the value of ecx is 0.
I'm running windows XP pro with SQL Server 2000 SP3a.
WOW. I've never seen anything like that. Sorry.
You might search the Microsoft KB articles or contact your Technical Account
Manager if you have a support contract. Possibly one of the online PSS
engineers will pickup on this posting and reply.
Make sure you've updated both SQL Server RDBMS and Analysis Services to SP3
on all of your servers.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrea Vincenzi" <andrea.vincenzi@.tiscali.it> wrote in message
news:9be64929.0410081411.41b68cc2@.posting.google.c om...
> I have been playing with the BI Accelerator more than once, but I was
> never able to build anything that works, so I'd like to see if anyone
> can help me.
> I'm having a problem during the data load phase: all other phases were
> executed correctly, the db and all the cubes were created without
> errors, but the msbiso_update.bat (the script that executes the DTS
> jobs used to load the data) ends with an exception: "Unhandled
> exception at 0x015f20bf in dtsrun.exe: 0xc00000005: Access violation
> reading location 0x00000000".
> The log files don't show any errors, but looking at the db tables it
> seems that only the time dimension tables have been loaded. All the
> other tables are empty.
> Unfortunately this is blocking, I can't use BI Accelerator if I'm not
> able to solve this problem. I entered debug mode to get more
> information about the error. In the (unlikely) event that someone is
> able to understand the source of the problem looking at the
> disassembly, here are a few lines around the error position:
> 015F20B0 ret 0Ch
> 015F20B3 mov ecx,dword ptr [esp+10h]
> 015F20B7 push ebx
> 015F20B8 push edx
> 015F20B9 mov eax,dword ptr [ecx+8]
> 015F20BC push eax
> 015F20BD mov ecx,dword ptr [eax]
> 015F20BF call dword ptr [ecx]
> 015F20C1 mov edi,eax
> 015F20C3 call 015F1A70
> The access violation occurs on the first call instruction (015F20BF).
> I checked with the debugger, and the value of ecx is 0.
> I'm running windows XP pro with SQL Server 2000 SP3a.
|||I uninstalled and then reinstalled BI Accelerator, and the problem
disappeared.
DTS was able to complete the scripts, including loading data and
processing the cubes.
Andrea

No comments:

Post a Comment