3 weeks ago - last edited 3 weeks ago
Dear Experts,
I am trying to extracting the data from BW queries to Datasphere, I am getting the below error message. As i checked the Trace (ST01), there is no Auth error in the trace.
2025-01-16 06:46:13,909 [ERROR] [852a8bfd-328d-48e0-a29e-c38d50d7e7e555806] ABAPAdapter | ABAPAdapter$6.run [] - Error while trying to preload table and description dictionary : com.sap.conn.jco.JCoException: (104) JCO_ERROR_SYSTEM_FAILURE: You do not have authorization for this function (raised by system [QIS|rb3qisa0.server.bosch.com|46]) Message 868 of class SO type E
2025-01-16 06:46:13,925 [ERROR] [528b373c-b217-430e-8688-d96956b9e40d47119] ABAPAdapter | ABAPAdapter$6.run [] - Error while trying to preload table and description dictionary : com.sap.conn.jco.JCoException: (104) JCO_ERROR_SYSTEM_FAILURE: You do not have authorization for this function (raised by system [QIS|rb3qisa0.server.bosch.com|46]) Message 868 of class SO type E
2025-01-16 06:46:17,081 [ERROR] [7aa3869f-f332-4c11-b5c8-0ce3be45d60156630] ABAPAdapter | ABAPAdapter$6.run [] - Error while trying to preload table and description dictionary : com.sap.conn.jco.JCoException: (104) JCO_ERROR_SYSTEM_FAILURE: You do not have authorization for this function (raised by system [QIS|rb3qisa0.server.bosch.com|46]) Message 868 of class SO type E
2025-01-16 06:46:17,112 [ERROR] [fa8b6571-ba08-45bb-95f0-7e021f60e6b44750] ABAPAdapter | ABAPAdapter$6.run [] - Error while trying to preload table and description dictionary : com.sap.conn.jco.JCoException: (104) JCO_ERROR_SYSTEM_FAILURE: You do not have authorization for this function (raised by system [QIS|rb3qisa0.server.bosch.com|46]) Message 868 of class SO type E
2025-01-16 06:46:24,519 [ERROR] [19cc6ece-85fe-4df6-ad39-4a19dee4a83213619] ABAPAdapter | ABAPAdapter$6.run [] - Error while trying to preload table and description dictionary : com.sap.conn.jco.JCoException: (104) JCO_ERROR_SYSTEM_FAILURE: You do not have authorization for this function (raised by system [QIS|rb3qisa0.server.bosch.com|46]) Message 868 of class SO type E
2025-01-16 06:46:24,566 [ERROR] [446d36ee-cd6f-4db0-90dd-deb3955bed2249536] ABAPAdapter | ABAPAdapter$6.run [] - Error while trying to preload table and description dictionary : com.sap.conn.jco.JCoException: (104) JCO_ERROR_SYSTEM_FAILURE: You do not have authorization for this function (raised by system [QIS|rb3qisa0.server.bosch.com|46]) Message 868 of class SO type E
2025-01-16 06:46:24,847 [ERROR] [0f546e2b-556e-47aa-b4fa-a998c72419e061835] ABAPAdapter | ABAPAdapter$6.run [] - Error while trying to preload table and description dictionary : com.sap.conn.jco.JCoException: (104) JCO_ERROR_SYSTEM_FAILURE: You do not have authorization for this function (raised by system [QIS|rb3qisa0.server.bosch.com|46]) Message 868 of class SO type E
2025-01-16 06:46:24,894 [ERROR] [675fb19e-9733-43a2-803a-1c3a4555aaa463041] ABAPAdapter | ABAPAdapter$6.run [] - Error while trying to preload table and description dictionary : com.sap.conn.jco.JCoException: (104) JCO_ERROR_SYSTEM_FAILURE: You do not have authorization for this function (raised by system [QIS|rb3qisa0.server.bosch.com|46]) Message 868 of class SO type E
2025-01-16 06:46:25,003 [ERROR] [f5c5921d-31b5-4a93-aede-299b12909c857777] ABAPAdapter | ABAPAdapter$6.run [] - Error while trying to preload table and description dictionary : com.sap.conn.jco.JCoException: (104) JCO_ERROR_SYSTEM_FAILURE: You do not have authorization for this function (raised by system [QIS|rb3qisa0.server.bosch.com|46]) Message 868 of class SO type E
2025-01-16 06:47:05,566 [ERROR] [f5c5921d-31b5-4a93-aede-299b12909c857777] ABAPAdapter | TableLoaderExtractor.checkError [] - Error for "BW"."BEX_QUAERY_NAME" : Error while accessing Error while extracting from source 6ZTF41N0V8B3IKEBNSOYN14HN (type InfoProvider) An exception was raised.
2025-01-16 06:47:05,566 [ERROR] [f5c5921d-31b5-4a93-aede-299b12909c857777] DPFramework | AsyncHandler.processStreamingExecuteStatement [] - AH(41897): Exception while processing request "SDA Response for ABAPAdapter of type SUCCESS_MSG responding to STREAMING_SET_STATEMENT"
2025-01-16 06:47:05,566 [ERROR] [f5c5921d-31b5-4a93-aede-299b12909c857777] DPFramework | AsyncHandler.processStreamingExecuteStatement [] - AH(41897): com.sap.hana.dp.adapter.sdk.AdapterException: Error for "BW"."LSUPCI_600M_SDS_I11" : Error while accessing Error while extracting from source 6ZTF41N0V8B3IKEBNSOYN14HN (type InfoProvider) An exception was raised. Context: Error for "BW"."LSUPCI_600M_SDS_I11" : Error while accessing Error while extracting from source 6ZTF41N0V8B3IKEBNSOYN14HN (type InfoProvider) An exception was raised.
at com.sap.hana.dp.abapadapter.TableLoaderExtractor.checkError(TableLoaderExtractor.java:954)
at com.sap.hana.dp.abapadapter.TableLoaderExtractor.odpFetchNext(TableLoaderExtractor.java:973)
at com.sap.hana.dp.abapadapter.TableLoaderExtractor.executeStatement(TableLoaderExtractor.java:1583)
at com.sap.hana.dp.abapadapter.ABAPAdapter.executeStatemen...
Thanks.
Request clarification before answering.
The error log you've provided indicates an issue with SAP ABAP Adapter's connectivity or permissions during data extraction and table preloading from a source system. Here's a breakdown of the key issues and potential next steps:
Key Issues:
1. Authorization Issue:
The primary error states:
Jco exception: (104) JCO_ERROR_SYSTEM_FAILURE: You do not have authorization for this function
This indicates that the user account or service being used does not have sufficient permissions in the SAP system ([QIS|rb3qisa0.server.bosch.com|46]).
2. Data Extraction Failure:
Another error states:
Error while extracting from source 6ZTF41N0V8B3IKEBNSOYN14HN (type Info Provider)
This suggests a failure while accessing an Info provider (possibly a BW Query or a table).
3. Code-Specific Errors:
Errors in methods like TableLoaderExtractor.checkError() and odpFetchNext() suggest issues with SAP HANA DP Adapter logic during streaming execution.
---
Suggested Resolutions:
1. Check User Authorizations:
Ensure the user account used by the ABAPAdapter has the necessary roles and authorizations for:
Reading tables and metadata.
Executing the required SAP functions or queries.
Specifically, verify the authorization object S_TABU_DIS (for table access) or S_RFC (for RFC calls) as they might be missing.
2. Validate InfoProvider Configuration:
Confirm that the InfoProvider (6ZTF41N0V8B3IKEBNSOYN14HN) is active and accessible.
Check for query definitions, and ensure they are not locked or corrupted.
3. Adapter and Connection Settings:
Verify the connection details in the ABAPAdapter configuration. Ensure the target SAP system (QIS) is reachable and that the connection settings are valid.
Test the connection manually to check for network issues.
4. Debug the ABAPAdapter Code:
Review the methods mentioned (checkError, odpFetchNext, etc.) to see if any specific exceptions are being mishandled or need refinement.
5. Logs and Trace Analysis:
Enable detailed SAP Gateway and JCo traces to pinpoint the root cause of the issue.
Review SAP system logs (ST22, SM21) for further clues on the exception raised.
6. Consult SAP Notes:
Search for SAP Notes related to JCo errors and ABAPAdapter issues. Start with the keywords "JCO_ERROR_SYSTEM_FAILURE" and "InfoProvider access failure."
7. Contact SAP Support:
If the issue persists, gather the following details for SAP support:
Adapter configuration.
Exact steps leading to the error.
All related logs (JCo, SAP, and Adapter).
Let me know if you'd like further help troubleshooting or interpreting any other errors.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
5 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.