on 10-26-2019 9:56 PM
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
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';
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.