SAP Knowledge Base Article - Preview

1704557 - Access_Violation error when running DS jobs with DATETIME arithmetic

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.