Symptom
- Access_Violoation of al_engine when DATETIME - INTERVAL is present in Query transform
- DS Designer crashes when viewing Optimized SQL when DATETIME - INTERVAL is present in Query transform
- Error in execution log similar to:
14.0) 03-28-12 08:06:08 (E) (6860:3696) SYS-170101: |Session
Job_DailySiteSum|Work flow WF_someworkflow|Data flow DF_someworkflow System Exception
<ACCESS_VIOLATION> occurred. Process dump is written to
<D:\BusinessObjects\Data
Services\log\BODI_MINI20120328080558_2248.DMP> and
<D:\BusinessObjects\Data Services\log\BODI_FULL20120328080558_2248.DMP>
Process dump is
written to <C:\BusinessObjects\Data
Services\log\BODI_MINI20120328080558_2248.DMP> and
<D:\BusinessObjects\Data
Services\log\BODI_FULL20120328080558_2248.DMP> Call stack:
0x0000000080307D33, MsDB::printBinOpExpr()+0243 byte(s),
d:\im_ds_40_sp_rel\src\dataservices\dataintegrator\codeline\code\src\dbspec\mssql.cpp, line 1438
0x00000000801A4AEB, GenDB::printBin()+1851 byte(s),
d:\im_ds_40_sp_rel\src\dataservices\dataintegrator\codeline\code\src\dbspec\gendb.cpp, line 1820
0x00000000801936D1, GenDB::printExpr()+0193 byte(s),
d:\im_ds_40_sp_rel\src\dataservices\dataintegrator\codeline\code\src\dbspec\gendb.cpp, line 1263
0x0000000080307858, MsDB::printExpr()+0184 byte(s),
d:\im_ds_40_sp_rel\src\dataservices\dataintegrator\codeline\code\src\dbspec\mssql.cpp, line 1858 Registers:
RAX=0000000000208758 RBX=0000000002434F40 RCX=0000000000208758
RDX=0000000000000067 RSI=0000000000000000
RDI=0000000000000000 RBP=0000000000000000 RSP=00000000002086B0
RIP=0000000080307D33 FLG=0000000000010216
R8=0000000080000000 R9=0000000081A00D48 R10=00000000070C23E0
R11=0000000000208EE8 R12=000000000020B1D8
R13=00000000074222B0 R14=00000000017CF720 R15=0000000005AC9F40
Exception code:
C0000005 ACCESS_VIOLATION Fault address:
0000000180307D33 01:0000000000306D33 D:\BusinessObjects\Data
Services\bin\acta.dll
========================================================== 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.
==========================================================
Read more...
Environment
Data Services 4.0 SP1
Product
SAP BusinessObjects Business Intelligence, Edge edition 4.0, version with data integration
Keywords
DS , BODS , DI , BODI , Edge , KBA , EIM-DS , Data Services , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.