How to resolve errors when "Extract tables: SAP Connector"

Hello,

Looks like permission issue within database, check if user that used can get the table metadata.

Service desk probably may provide you with more details.

Best Regards,

Mateusz Dudek

Thank you for your response.

I'm thinking of checking the database permissions and the response from the service desk.

Best Regards,

Omachi Satoshi

Hello Dudek,

I was proposed by customer support to check the following Extractor logs on the SAP side, but I haven't found the problem yet.

2022-03-29 17:45:07.469 WARN [,,,] 3017 --- [pool-6-thread-6] c.c.c.e.r.RetryFactory$RetryListener   : Method getTableMetadata - Call cc20bf3f-0b9b-44ff-ac41-ee21a75572a1 threw SapJCoConnectorException during remote call: Error executing function /CELONIS/FM_GET_TABLE_METADATA -- retries left: 12 --EOM--  

cloud.celonis.connector.sap.exceptions.SapJCoConnectorException: Error executing function /CELONIS/FM_GET_TABLE_METADATA

at cloud.celonis.connector.sap.api.PollingSapApiV3.executeFunction(PollingSapApiV3.java:513)

at cloud.celonis.connector.sap.api.PollingSapApi.executeFunction(PollingSapApi.java:741)

at cloud.celonis.connector.sap.api.PollingSapApiV3.doGetTableMetadata(PollingSapApiV3.java:214)

at cloud.celonis.connector.sap.api.SapApi.lambda$getTableMetadata$8(SapApi.java:213)

at cloud.celonis.connector.sap.api.SapApi.lambda$retry$15(SapApi.java:514)

at cloud.celonis.cloudutilities.extraction.retry.RetryFactory.lambda$execute$1(RetryFactory.java:42)

at org.springframework.retry.support.RetryTemplate.doExecute(RetryTemplate.java:287)

at org.springframework.retry.support.RetryTemplate.execute(RetryTemplate.java:164)

at cloud.celonis.cloudutilities.extraction.retry.RetryFactory.execute(RetryFactory.java:42)

at cloud.celonis.connector.sap.api.SapApi.retry(SapApi.java:508)

at cloud.celonis.connector.sap.api.SapApi.retry(SapApi.java:493)

at cloud.celonis.connector.sap.api.SapApi.getTableMetadata(SapApi.java:213)

at cloud.celonis.connector.sap.service.SapConnectorService.getExtractionTableMetadata(SapConnectorService.java:362)

at cloud.celonis.connector.sap.service.SapConnectorService.extractTable(SapConnectorService.java:336)

at cloud.celonis.connector.sap.service.SapConnectorService.lambda$execute$1(SapConnectorService.java:145)

at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)

at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)

at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)

at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)

at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)

at java.base/java.lang.Thread.run(Thread.java:833)

Caused by: com.sap.conn.jco.JCoException: - 

 SAPMSSY1 / (line: 0 )

at com.sap.conn.jco.rt.AbstractConnection.generateJCoException(AbstractConnection.java:595)

at com.sap.conn.jco.rt.ClientConnection.executeInternal(ClientConnection.java:1978)

at com.sap.conn.jco.rt.ClientConnection.execute(ClientConnection.java:2164)

at com.sap.conn.jco.rt.ClientConnection.execute(ClientConnection.java:2031)

at com.sap.conn.jco.rt.RfcDestination.execute(RfcDestination.java:2024)

at com.sap.conn.jco.rt.RfcDestination.execute(RfcDestination.java:1988)

at com.sap.conn.jco.rt.AbapFunction.execute(AbapFunction.java:305)

at cloud.celonis.connector.sap.api.PollingSapApiV3.executeFunction(PollingSapApiV3.java:509)

... 20 common frames omitted

Caused by: com.sap.conn.rfc.exceptions.RfcException: - 

 SAPMSSY1 / (line: 0 )

at com.sap.conn.rfc.engine.RfcIoOpenCntl.RfcReceive(RfcIoOpenCntl.java:2068)

at com.sap.conn.jco.rt.ClientConnection.executeInternal(ClientConnection.java:1919)

... 26 common frames omitted

Caused by: com.sap.conn.rfc.exceptions.RfcGetException: - 

 SAPMSSY1 / (line: 0 )

at com.sap.conn.rfc.engine.RfcImp.ab_rfcerror(RfcImp.java:928)

at com.sap.conn.rfc.engine.RfcGet.ab_rfcget(RfcGet.java:181)

at com.sap.conn.rfc.engine.RfcRcv.ab_rfcreceive(RfcRcv.java:41)

at com.sap.conn.rfc.engine.RfcIoOpenCntl.RfcReceive(RfcIoOpenCntl.java:2006)

... 27 common frames omitted

What do you think we can do to help reduce this problem?

Best Regards,

Omachi Satoshi