Access Violation error in BODS 12.2 Version

dataservices job design
1

Hi ,

Can you please help me in resolving this:

System Exception <ACCESS_VIOLATION> occurred. Process dump is written to <D:\Program Files\Business Objects\BusinessObjects
Data Services\log\BODI_MINI20120425041312_251696.DMP> and <D:\Program Files\Business Objects\BusinessObjects Data
Services\log\BODI_FULL20120425041312_251696.DMP>
Process dump is written to <D:\Program Files\Business Objects\BusinessObjects Data
Services\log\BODI_MINI20120425041312_251696.DMP> and <D:\Program Files\Business Objects\BusinessObjects Data
Services\log\BODI_FULL20120425041312_251696.DMP>
Call stack:
0023:76EDA43E, RtlDllShutdownInProgress()+48362 byte(s)
0023:75623F01, HeapFree()+0020 byte(s)
0023:7C34218A, free()+0057 byte(s)
0023:00DC7FA3, BindArray_desc::clean()+0019 byte(s), x:\src\eval\bind.cpp, line 0474+0006 byte(s)
0023:00DC8C41, BindArrayVector::cleanVector()+0033 byte(s), x:\src\eval\bind.cpp, line 0622+0013 byte(s)
0023:00EB2992, LoadDB::close()+3954 byte(s), x:\src\loader\loaddb.cpp, line 1575
0023:00D88085, XTran_desc::close()+0069 byte(s), x:\src\core\xtran.cpp, line 0491
0023:00D8A19D, XTran_desc::~XTran_desc()+0061 byte(s), x:\src\core\xtran.cpp, line 0376
0023:00D8AD98, XTran_desc::`scalar deleting destructor’()+0008 byte(s)
0023:00D84EDB, XDataflow_desc::executeInline()+1755 byte(s), x:\src\core\xnet.cpp, line 0717
0023:00D95C9C, XDataflow_info::execute()+0716 byte(s), x:\src\core\net.cpp, line 0232
0023:00D837BC, XDataflow_desc::execute()+0108 byte(s), x:\src\core\xnet.cpp, line 0345
0023:00D93B9B, XDataflow_info::compute()+0219 byte(s), x:\src\core\net.cpp, line 0326+0011 byte(s)
0023:00D93E44, XDataflow_info::compute()+0228 byte(s), x:\src\core\net.cpp, line 0433
0023:00CF9B9C, AE_Main_Process_Options()+26988 byte(s), x:\src\xterniface\actamainexp.cpp, line 3203+0013 byte(s)
0023:00CFF2D1, AE_Main()+1505 byte(s), x:\src\xterniface\actamainexp.cpp, line 0818+0030 byte(s)
0023:00402DE8
Registers:
EAX=06A97F50 EBX=06A97F58 ECX=06173DE8 EDX=00206880 ESI=021D0000
EDI=00000000 EBP=0026215C ESP=00262150 EIP=76EDA43E FLG=00010246
CS=0023 DS=002B SS=002B ES=002B FS=0053 GS=002B
Exception code: C0000005 ACCESS_VIOLATION
Fault address: 76EDA43E 01:0001A43E C:\Windows\SysWOW64\ntdll.dll
==========================================================
Please collect the following and send to Customer Support:
1. Log files(error_, monitor_, trace_*) associated with this failed job.
2. Exported Atl file of this failed job.
3. DDL statements of tables referenced in this failed job.
4. Data to populate the tables referenced in the failed job. If not possible, get the last few rows (or sample of them) when
the job failed.
5. Core dump, if any, generated from this failed job.
==========================================================

I have to load 7 tables with 45 million records (each table) .When i execute for the first time job runs fine,but second time fails with avove mentioned error. I have fine tuned the code but still i am getting this issue.database is Sql server 2008.

Thanks for quick help.

Indira

indirank1 (BOB member since 2007-12-11)

2

Whats the file size? Is more than 2GB then BODS cannot process. Could you try changing the pageable to memory settings?

Also try restarting the BODS and check for cartesian product.

Thanks,
Arun

Arun.K :us: (BOB member since 2011-10-18)

3

Thanks Arun.

If i change pageable to memory it throws error saying it can not process.
what you mean by restarting the BODS and check for cartesian product?
Yes it is consuming more than 2 GB.For this only i need some workaround ASAP.

indirank1 (BOB member since 2007-12-11)

4

Go to services.msc and you have Business Objects Data Services, which can be restarted. Cartesian product is basically cross join or no relationship between the tables, so number of records multiples each time you dump.

Thanks,
Arun

Arun.K :us: (BOB member since 2011-10-18)

5

What is that file size here?

What kind of operations you do in the DF ? Could you elaborate? 45 Million on each table is something to be reviewed. You should probably play around with the Join Rank. Are the 7 tables joined at one shot or in steps? Guess the issue happens when loading the database. Is your target table indexed or partitioned?

How you load the Target? Bulk Load or regular load? What is the commit size?

ganeshxp :us: (BOB member since 2008-07-17)

6

I am calculating the previuos row value using the Prev_ro_value function of BODS.

I am not joining the all tables.Each target table size will pile up to 45 miillion records.

indirank1 (BOB member since 2007-12-11)

7

What is that? I still don’t buy it!!! So what does 7 tables does here if you were not joining? Would you mind posting a snap of your DF???

And a previous_row_value function? On how many records does this function acts on?

ganeshxp :us: (BOB member since 2008-07-17)

8

Hello,
I have a similar error on a very simple dataflow, that worked fine until last night.
It merges 7 tables into a target table, total amount of records 53k.
I’m using BODS 12.2.2.3, on windows server 2008, reading from AS400 and writing to MS Sql Server 2008 R2.

There are no datetime fields; I tried already to replicate the dataflow, to change the target table, I rebuilt the query objects, and the merge. The only thing that seems to work is to delete one of the source tables.
The dataflow is pageable, and from the task manager the engine grows up to max 300k. There are 32 GB free on the hard disk where Data Services is installed. The user is Administrator.

Below is the error message.

I believe there’s something wrong in the machine settings, because I get dump errors quite easily, and for no apparent reason.
Any help of what could be wrong?

Thanks in advance,
Silvia

(12.2) 06-07-12 12:42:44 (E) (3180:4576) SYS-170101: |Session GLOBAL_INTRADAY_DWH|Work flow STG_ALL|Work flow STG_DIMENSION|Work flow STG_D_CONTO|Data flow STG_ANPAR00F
System Exception <ACCESS_VIOLATION> occurred. Process dump is written to <C:\Program Files (x86)\Business
Objects\BusinessObjects Data Services\log\BODI_MINI20120607124242_4772.DMP>
Call stack:
0023:7792E39E, RtlInitUnicodeString()+0406 byte(s)
0023:7792E003, RtlFreeHeap()+0126 byte(s)
0023:76E314DD, HeapFree()+0020 byte(s)
0023:75244C39, free()+0205 byte(s)
0023:648436F0, SQLDisconnect()+146272 byte(s)
0023:64841F1B, SQLDisconnect()+140171 byte(s)
0023:64842B71, SQLDisconnect()+143329 byte(s)
0023:64842975, SQLDisconnect()+142821 byte(s)
0023:6484370F, SQLDisconnect()+146303 byte(s)
0023:64846BBC, SQLDisconnect()+159788 byte(s)
0023:6486B6AF, SQLFreeHandle()+14319 byte(s)
0023:6486823E, SQLFreeHandle()+0894 byte(s)
0023:64868077, SQLFreeHandle()+0439 byte(s)
0023:73789716, SQLDriverConnect()+1855 byte(s)
0023:737DA278, SQLFreeStmt()+0098 byte(s)
0023:00D3078A, ConnODBC::SQLFreeStmt()+0106 byte(s), x:\src\conn\connodbc.cpp, line 0923+0094 byte(s)
0023:00B92F37, OdbcDB::before_close_db_connection()+0103 byte(s), x:\src\dbspec\odbcdb.cpp, line 6564
0023:00BA4780, OdbcDB::close()+0016 byte(s), x:\src\dbspec\odbcdb.cpp, line 0495
0023:00FF3FB7, RdrDB::close()+0263 byte(s), x:\src\reader\rdrdb.cpp, line 1308
0023:00F137C5, XTran_desc::close()+0069 byte(s), x:\src\core\xtran.cpp, line 0496
0023:00F1554D, XTran_desc::~XTran_desc()+0061 byte(s), x:\src\core\xtran.cpp, line 0381
0023:00F15EA8, XTran_desc::`scalar deleting destructor’()+0008 byte(s)
0023:00F10E6B, XDataflow_desc::executeInline()+1755 byte(s), x:\src\core\xnet.cpp, line 0717
0023:00F20DBC, XDataflow_info::execute()+0716 byte(s), x:\src\core\net.cpp, line 0232
0023:00F0F73F, XDataflow_desc::execute()+0111 byte(s), x:\src\core\xnet.cpp, line 0345
0023:00F1ED2B, XDataflow_info::compute()+0219 byte(s), x:\src\core\net.cpp, line 0326+0011 byte(s)
0023:00F1EFD4, XDataflow_info::compute()+0228 byte(s), x:\src\core\net.cpp, line 0433
0023:0083A10C, AE_Main_Process_Options()+27260 byte(s), x:\src\xterniface\actamainexp.cpp, line 3225+0013 byte(s)
0023:0083F841, AE_Main()+1505 byte(s), x:\src\xterniface\actamainexp.cpp, line 0826+0030 byte(s)
0023:00402DE8
Registers:
EAX=6F3F0003 EBX=06CCAF28 ECX=05BA0000 EDX=06CCAF28 ESI=06C95F8F
EDI=06CCAF20 EBP=00271D2C ESP=00271CF8 EIP=7792E39E FLG=00010202
CS=0023 DS=002B SS=002B ES=002B FS=0053 GS=002B
Exception code: C0000005 ACCESS_VIOLATION
Fault address: 7792E39E 01:0001E39E C:\Windows\SysWOW64\ntdll.dll
==========================================================
Please collect the following and send to Customer Support:
1. Log files(error_, monitor_, trace_*) associated with this failed job.
2. Exported Atl file of this failed job.
3. DDL statements of tables referenced in this failed job.
4. Data to populate the tables referenced in the failed job. If not possible, get the last few rows (or sample of them) when
the job failed.
5. Core dump, if any, generated from this failed job.
==========================================================

silvia.entradi (BOB member since 2012-06-07)