HANA Output Adapter Tips

While performing some testing, which required the use of a HANA Output adapter, I came across a few common configuration issues. This blog is intended to help other users who may be setting up a HANA output adapter for the first time. Note that the full documentation for the HANA Output adapter is available here.

Debugging tips:

Note: the smart data streaming window attached to the adapter will be referred to as the “feeding object”, as it feeds data to the output table.

1. Check that the login credentials are correct.
   1. In the left panel, beside the “Project Explorer” tab, click on the “Data Services” tab.
   2. Click on the data service you are using in your project. This is shown in the image to the right
   3. In the “Properties” panel at the bottom of HANA Studio, check that the “User*” and  “Password*” fields are correct
2. Check that the object feeding the HANA Output adapter is consistent with the table being outputted to. If a Field Mapping has not been specified,
   1. Check that the same number of columns exist in the feeding object and the output table
   2. Check that the column names of the feeding object schema and output table are identical (case sensitive)
   3. Check that the order of the columns in the feeding object schema is identical to that of the output table
3. If you have specified a Field Mapping and the Data Warehouse Mode property is off, ensure that you have included a mapping for at least one column of the primary key of the feeding object. Without mapping at least one primary key column, the adapter will fail to start.
4. To find potential HANA Output adapter runtime errors (assuming the project compiles successfully):
   1. Run the project
   2. In the Run-Test perspective, under the “Server View” panel on the left, expand your project
   3. Click the drop-down arrow beside your feeding object
   4. Double click the HANA Output adapter to view “_ESP_Connectors”
   5. Runtime errors will appear in the “last_error_message” column
5. Log files could also be useful for finding runtime errors:
   1. Go to the SAP HANA Administration Console perspective
   2. Under the “Systems” tab, double click the system you are working with
   3. Click on the “Diagnosis Files” tab
   4. You may need to scroll down to view the most recent log files
   5. Trace, log and out files reside here and can be viewed by double clicking