Access Violation issue while loading data in SAP HANA using Data Services 4.0

[Former Member]

Hi,

Does anyone encounter this issue while loading data in SAP HANA using data services 4.0

Thanks

Sudhir

5992 7344 SYS-170101 9/25/2012 5:47:01 PM |Session TemplateJob|Data flow _DF_Test

5992 7344 SYS-170101 9/25/2012 5:47:01 PM System Exception <ACCESS_VIOLATION> occurred. Process dump is written to <D:\SAP BusinessObjects\Data

5992 7344 SYS-170101 9/25/2012 5:47:01 PM Services\log\BODI_MINI20120925174653_3924.DMP> and <D:\SAP BusinessObjects\Data Services\log\BODI_FULL20120925174653_3924.DMP>

5992 7344 SYS-170101 9/25/2012 5:47:01 PM Process dump is written to <D:\SAP BusinessObjects\Data Services\log\BODI_MINI20120925174653_3924.DMP> and <D:\SAP

5992 7344 SYS-170101 9/25/2012 5:47:01 PM BusinessObjects\Data Services\log\BODI_FULL20120925174653_3924.DMP>

5992 7344 SYS-170101 9/25/2012 5:47:01 PM Call stack:

5992 7344 SYS-170101 9/25/2012 5:47:01 PM 0x000000006E338EBD, aligned_free()+0013 byte(s)

5992 7344 SYS-170101 9/25/2012 5:47:01 PM 0x00000000EEFFCEB5, SQLDBC::SQLDBC_Callback::leave_SQLDBC_ConnectProperties_dtor()+602165 byte(s)

5992 7344 SYS-170101 9/25/2012 5:47:01 PM 0x00000000EEF680C6, ConfigDriver()+28566 byte(s)

5992 7344 SYS-170101 9/25/2012 5:47:01 PM 0x00000000EEF75DE6, SQLDBC::SQLDBC_Callback::leave_SQLDBC_ConnectProperties_dtor()+48998 byte(s)

5992 7344 SYS-170101 9/25/2012 5:47:01 PM 0x00000000EEF7FC17, SQLDBC::SQLDBC_Callback::leave_SQLDBC_ConnectProperties_dtor()+89495 byte(s)

5992 7344 SYS-170101 9/25/2012 5:47:01 PM Registers:

5992 7344 SYS-170101 9/25/2012 5:47:01 PM RAX=00000000EF2B7DB8  RBX=0000000000000000  RCX=0000000007310050  RDX=0000000007310050  RSI=0000000000000001

5992 7344 SYS-170101 9/25/2012 5:47:01 PM RDI=0000000000000000  RBP=00000000091ECDD0  RSP=00000000091ECC70  RIP=000000006E338EBD  FLG=0000000000010206

5992 7344 SYS-170101 9/25/2012 5:47:01 PM R8=00000000EEFFCEB5   R9=00000000EFA49830  R10=0000000000000005  R11=0000000000000001  R12=00000000071C40A0

5992 7344 SYS-170101 9/25/2012 5:47:01 PM R13=00000000091ED2B8  R14=00000000071C72B8  R15=0000000000000004

5992 7344 SYS-170101 9/25/2012 5:47:01 PM Exception code: C0000005 ACCESS_VIOLATION

5992 7344 SYS-170101 9/25/2012 5:47:01 PM Fault address:  000000006E338EBD 01:0000000000067EBD C:\Windows\system32\MSVCR100.dll

[Former Member · Accepted solution]

Hi All,

The problem has been resolved.

Currently, we are having multi blade HANA server (master and slave).
All new tables created are sitting in Slave Blade Server and we are
having problem only in loading tables that are in Slave Server.
We don't have problem in loading tables in Master Server. I discovered this with lot of testing.

We added IP address in the host file for the slave node and it resolved
the issue.

Thanks

Sudhir

[rama_shankar3 · Accepted solution]

Sudhir:

Thanks for sharing the solution to your problem. It is an interesting scenario / problem even though basis team should have checked this prior to turn loose the system to developers.

Rama

[Former Member]

Hi Sudhir,

Please login to the HANA Studio with the same id/pwd that you are using to connect to HDB in BODS and check if you have access to insert records into a table. This is an access issue for the id you are using to connect to HANA in BODS.

Regards,

Vijay

[Former Member]

Hi Vijay,

Thanks for your answer.

I will try and let you know.

But, when I see the roles/authorization of that user, I can see full access to that Schema including dropping.

But, I will test and let you know.

Again, I have no problem in loading data from one SQL Server database to another SQL Server database. But, I have problem in loading data from one table of HANA Schema to another table of the same Schema in HANA by Data Services (Access Voilation issue pop up).

Thanks

Sudhir

[Former Member]

Hi Vijay,

I login to the HANA Studio with the same id/pwd that I am using to connect to HDB in BODS.

I could able to insert the records in the table from HANA Studio.

Thanks

Sudhir

[Former Member]

Hi Sudhir,

Could you describe what you are doing when that is the case?

- Configuring the DataSource

- Running a job?

- Citrix environment?

- Virtual machine?

Is this happening on more than one machine? (set up another job server on another machine if needed)

I believe that the important lines are:

5992 7344 SYS-170101 9/25/2012 5:47:01 PM Call stack:

5992 7344 SYS-170101 9/25/2012 5:47:01 PM 0x000000006E338EBD, aligned_free()+0013 byte(s)

5992 7344 SYS-170101 9/25/2012 5:47:01 PM 0x00000000EEFFCEB5, SQLDBC::SQLDBC_Callback::leave_SQLDBC_ConnectProperties_dtor()+602165 byte(s)

5992 7344 SYS-170101 9/25/2012 5:47:01 PM 0x00000000EEF680C6, ConfigDriver()+28566 byte(s)

...

1 PM Exception code: C0000005 ACCESS_VIOLATION  C:\Windows\system32\MSVCR100.dll

So the dll is a standard windows one (as opposed to a DS dll like acta...) and it looks there is a problem with the connection ? Although I don't know if this is a cause or a consequence of the error.

I'm curious to know if this happens on another windows machine as well..

Regards

Norbert

[Former Member]

Hi Norbert,

Thanks for your reply.

This issue came when I am running the  simple job.

The issue is very intermittent. When it happens, then Administrator needs to restart the DS Services and login into Designer and run any simple job. Then, it will go away. It is happening in other machine too.

The issue is too often when I will pull data from the View in the source system.

You mentioned that it might be problem with the connection.

What and Where connection?

Appreciate for your help.

Sudhir

[henrique_pinto]

He's probably talking about the System DSN Data Source you create in the Administrative Tools -> Data Source (ODBC) option of the DS server.

Which version of the HANA (ODBC) client have you installed there?

Make sure it's up to date with the HANA DB version.

[Former Member]

HANA Version: Version: 1.0.31

Thanks

Sudhir

[lucas_oliveira]

Hi Sudhir,

There's no current evidence of error in HANA here, so I'd try the DS community before digging into HANA. Maybe these guys can help you out: http://scn.sap.com/community/data-services/content

Regards,

Lucas de Oliveira

[Former Member]

Hi Lucas,

I have no problem in loading in SQL Server Database. The issue arises only when loading in the HANA Database.

Thanks

Sudhir