Skip to Content
author's profile photo Vijay Viswanath Subramanian
0
Vijay Viswanath Subramanian

SDS Streaming - Adapter failed to start because initialisation failing

Posted on Oct 26, 2019 at 08:56 PM 172 Views Last edit Oct 26, 2019 at 09:05 PM 2 rev.

Hi Experts

When we try to stream Standard JSON messages using SDS, adapters aren't starting, in particularly the output adapter comes as DEAD, whereas the input adapter says continues. Following messages are taken from HANA Studio diagnose tab:

I could get the following error message: from .trc file

HANA Output Adapter has failed to access connection information in HANA system table.

SAP HANA Output adapter failed to prepare for bulk loading of target database table

SAP HANA Output adapter cannot start because initialization of a ChildLoader component has failed.

Error retrieving column 1 value from result set.

A result row is skipped due to error retrieving column data.

Following Message in *.out file:

sslstream Socket error: Couldn't read from SSL

could someone help me to resolve or to understand about this issue?

Regards

Vijay

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Robert Waywell
    Robert Waywell
    Posted on Oct 28, 2019 at 09:05 PM
    0

    If you are using Studio, then from the data service connection check that you can navigate to the table that the HANA output adapter is targeting.

    If you can, then based on the error, check the order of the columns in the table relative to the order of the columns in the output stream feeding the HANA output adapter. If the columns don't appear in the same order in the output stream as they do in the HANA table, then you will need to define the permutations similar to this example:

    ATTACH OUTPUT ADAPTER HANA_ALARM_OUTPUT TYPE hana_out TO ALARM_TEMP 
PROPERTIES
	service = 'dat373_xxx_service' ,
	sourceSchema = 'DAT373_XXX' ,
	table = 'ALARM_HISTORY ,
	dataWarehouseMode = 'INSERTONLY',
	permutation = 'MACHINEID=MACHINEID:EVENT_TIME=ALARM_TIME:LOCATION=ALARM_LOCATION:ALARM_TYPE=ALARM_TYPE:ALARM_DESC=ALARM_DESCRIPTION';
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.