SAP Table and Lookup()

[Former Member]

Hello all,

We want to create a dataflow using lookup() function based on a SAP ECC table (as the lookup table) but when we execute the job, we have a dump:

7008	5144	SYS-170101	8/26/2014 6:23:10 PM	System Exception <ACCESS_VIOLATION> occurred. Process dump option is off. Process is not dumped.
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	Call stack:
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	(null)
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	Registers:
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	RAX=0000000000000000  RBX=00000000063CA7F0  RCX=000000000933E5B0  RDX=000000000933E5D8  RSI=000000000933E5B0
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	RDI=0000000000000000  RBP=0000000008159A90  RSP=000000000933E4C0  RIP=00000000810D9D7E  FLG=0000000000010202
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	R8=0000000000000000   R9=00000000FFFFFFFF  R10=0000000000000008  R11=000000000933E5B0  R12=0000000000000000
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	R13=0000000008159A90  R14=00000000080CCD40  R15=0000000000000000
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	Exception code: C0000005 ACCESS_VIOLATION
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	Fault address:  00000001810D9D7E 01:00000000010D8D7E E:\Program Files\SAP BusinessObjects\Data Services\bin\acta.dll
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	==========================================================
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	Collect the following and send to Customer Support:
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	1. Log files(error_*, monitor_*, trace_*) associated with this failed job.
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	2. Exported ATL file of this failed job.
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	3. DDL statements of tables referenced in this failed job.
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	4. Data to populate the tables referenced in the failed job. If not possible, get the last few rows (or sample of them) when
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	the job failed.
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	5. Core dump, if any, generated from this failed job.
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	==========================================================
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	|Session Z_ASI_TEST_3|Data flow ZZZ_ASI
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	System Exception <ACCESS_VIOLATION> occurred. Process dump option is off. Process is not dumped.
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	Call stack:
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	(null)
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	Registers:
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	RAX=0000000000000000  RBX=00000000063CA7F0  RCX=000000000933E5B0  RDX=000000000933E5D8  RSI=000000000933E5B0
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	RDI=0000000000000000  RBP=0000000008159A90  RSP=000000000933E4C0  RIP=00000000810D9D7E  FLG=0000000000010202
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	R8=0000000000000000   R9=00000000FFFFFFFF  R10=0000000000000008  R11=000000000933E5B0  R12=0000000000000000
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	R13=0000000008159A90  R14=00000000080CCD40  R15=0000000000000000
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	Exception code: C0000005 ACCESS_VIOLATION
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	Fault address:  00000001810D9D7E 01:00000000010D8D7E E:\Program Files\SAP BusinessObjects\Data Services\bin\acta.dll
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	==========================================================
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	Collect the following and send to Customer Support:
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	1. Log files(error_*, monitor_*, trace_*) associated with this failed job.
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	2. Exported ATL file of this failed job.
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	3. DDL statements of tables referenced in this failed job.
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	4. Data to populate the tables referenced in the failed job. If not possible, get the last few rows (or sample of them) when
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	the job failed.
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	5. Core dump, if any, generated from this failed job.
7008	5144	SYS-170101	8/26/2014 6:23:10 PM	==========================================================

And the lookup() function is not allowed.

Do you know how is it possible to use a SAP table as a lookup table with a lokkup functions?

Best regards

Laurent

[Former Member]

Hi,

Use ABAP dataflow to extract SAP data.

And in this ABAP dataflow, use LOOKUP function in query transform.

Also, see whether it is generating ABAP code or not.

Thank you.

Chiranjeevi

[Former Member]

Refer SAP Note 1890726 - System Exception <ACCESS_VIOLATION> occurred. Process dump option is off. Process is not dumped SYS-170101 error - SAP Data Services 4.1 SP1

[Former Member]

Thanks bt our problem clearly apperas when we try to use a SAP ECC table in lookup() funtion

[ahalya_inturi]

Hi Laurent

Direct look up on SAP ECC table may give you error..

You can do lookup in other way as shown below..

1)Extarct and stage the data from SAP ECC table to your staging DB.

   SAP ECC table---> Stage DB

   say table name is Stage_SAP_Tab

2) Import the table Stage_SAP_Tab under specified datastore in BODS

3) Do the lookup on Stage_SAP_Tab where you required SAP Value ..

Hope you will get solution to do lookup on SAP ECC data

Regards

Ahalya