Skip to main content

Celonis Product Documentation

Troubleshooting FAQ

Note

When I extract a table from SAP, the extraction fails and in the logs I see the term "SAPSQL_PARSE_ERROR". What does this mean and how can I fix it?

Please check that all your filters do not contain the table name:

MARC.WERKS = '1000'     -- wrong
WERKS = '1000'          -- correct

The first filter will lead to a failed extraction with a SAPSQL_PARSE_ERROR message.

Solution: Remove all table names from extraction filters.

The same error also appears when a column is filtered on a text list and the list contains duplicate values

FNAME IN ('CMGST', 'CMGST', 'LIFSK','ABGRU', 'NETPR', 'SPART', 'LFMNG', 'MATNR', 'WERKS', 'ROUTE','EDATU','MBDAT', 'WADAT','BMENG','BSTKD', 'BSTDK', 'VSART', 'SDABW', 'ZTERM', 'INCO1', 'INCO2','FAKSK')

Solution: Remove all duplicate values.

Note

Necessary Celonis function not implemented in SAP: Function ...

Either the RFC module was not installed or it was installed in a different system than specified in the data connection. Please check the transport import logs and that it was executed without errors.

Note

No OS permission to open file '...'

The means that the user running the SAP system does not have permission to read or write into the specified temporary folder. Please check that the directory exists. Please also verify the permission of the OS user, e.g. by running the transaction AL11.

Note

Not able to list directory <directory path> SUBRC 4

The SAP system access the specified directory. Please check that the directory that is specified in Z_CELONIS_TARGET exists, see 01 - Celonis RFC Module: Requirements and Installation Step B.

Note

Error receiving answer: 1

The SAP system cannot reach the SAP extractor on the defined port. Please check your firewall settings between the SAP system and the extractor server and make sure that the port is accessible from the SAP system.

Note

JOB_CLOSE - Error during call for jobname CEL_EX_TABLENAME

This can have the root cause that there is no Batch Workprocess existing on the Application Server on which the Job was supposed to run.

In case you are using a message server in your connection, enable the 'Run on any SAP Server' option in the advanced Settings.

Alternatively, you can connect to another server (on which Batch Workprocess are defined) directly.

Note

java.lang.UnsatisfiedLinkError: /tmp/snappy-1.1.7-0a734946-3c3b-4c68-8ca8-d30525961329-libsnappyjava.so: failed to map segment from shared object

This error applies for Extractor Installations on Linux.

Possible solutions to resolve it:

  1. Check whether “/tmp/snappy-1.1.7-<UUID>-libsnappyjava.so” exists. If it doesn’t, restart the connector and make sure not to delete the new version of the file

    OR

  2. “/tmp” may be mounted with “noexec”, or similarly configuration of it is forbidding the loading of libraries from it. Please create a new temporary directory mounted elsewhere, then change the start command of the connector to “java -Djava.io.tmpdir=/path/to/new/dir -jar connector-sap.jar”

Note

How to configure a proxy on the Extractor service with NTLM authentication?

The Extractor currently only supports basic (or no) authentication for the proxy. In case your proxy uses NTLM authentication you might see the following error in the Extractor logs

2021-10-27 16:11:39.234 INFO [,,,] 1084 — [uplink-thread-0] c.celonis.uplink.manager.UplinkManager : Uplink could not connect: 'Unexpected 407 received (<HTML><HEAD><TITLE>Proxy Authentication Required</TITLE></HEAD><BODY BGCOLOR="white" FGCOLOR="black"><H1>Proxy Authentication Required</H1><HR><FONT FACE="Helvetica,Arial"><B>_Description: Please login with username and password.</B></FONT><HR></BODY>_) when querying 'https://team.cluster.celonis.cloud/uplink/api/public/uplink'', waiting 3000ms before retrying -EOM-

2021-10-27 16:11:41.719 WARN [,,,] 1084 — [uplink-thread-1] o.a.http.impl.auth.HttpAuthenticator : NEGOTIATE authentication error: No valid credentials provided (Mechanism level: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt)) -EOM-

2021-10-27 16:11:41.719 WARN [,,,] 1084 — [uplink-thread-1] o.a.http.impl.auth.HttpAuthenticator : NTLM authentication error: Credentials cannot be used for NTLM authentication: org.apache.http.auth.UsernamePasswordCredentials -EOM-

2021-10-27 16:11:41.719 ERROR [,,,] 1084 — [uplink-thread-1] c.c.uplink.manager.UplinkRequestService : HTTP 4xx encountered -EOM-

Solution:

  • Starting the Extractor by adding the additional cmd line argument before -jar

    -Djava.net.useSystemProxies=true
  • disabling the proxy configuration in our application-local.yml file

=> With this option the windows proxy settings will be used. The requirement is that these have been configured with windows already.

This means that there are not enough resources on the SAP server. You can change an extraction parameter on Celonis side to reduce the extraction impact. In the Event Collection, navigate to Data Connection, and in the "advanced settings" set the parameters "Number of rows to store in memory" and "Number of rows from the joined table to store in memory" to 5000.

image2022-3-9_17-33-16.png