Wednesday, February 3, 2016

1749626 - Data Services job fails when loading into a SAP HANA database

Symptom
When trying to load data into a SAP HANA target table the following error occurs:
Fault address:  000007FEEECA8347 01:0000000000047347 <%link_dir%>\libodbcHDB.dll


Environment
  • SAP HANA
  • Windows
  • Data Services (DS) 4.x


Reproducing the Issue
Create a DS job that loads into a SAP HANA table


Cause
The password for the user listed in the data store is about to expire.


Resolution
  1. Update the SAP HANA user's password or get rid of the password expiration for the user.
  2. If system cannot be unlocked via HANA Studio the SQL for unlocking the users is:
    "ALTER <user> USER ACTIVATE NOW;


Keywords
BODS, BODI, DS, DSXI, DI, Edge, SAP HANA



Header Data

Released On 17.04.2015 18:49:17
Release Status Released to Customer
Component EIM-DS Data Services
Priority Normal
Category Problem

No comments:

Post a Comment