cancel
Showing results for 
Search instead for 
Did you mean: 

PI 7.1 SFTP sender channel error: Could not add or update entry for filename

former_member434498
Participant
0 Kudos

Hi SCN,

Good day!

We have created an inbound SFTP interface that should pick up files in a host server.

Our PI version is 7.11 and using Seeburger 3.0 SFTP adapter type.

SFTP sender channel is configured as follows:

  • Authentication Method: Private Key Authentication
  • Resource ID: N/A
  • Preferred Cipher: blowfish-cbc

Upon droping the files in the host server, PI is unable to pick up the files and below error description is encountered in the communcation channel logs.

05/02/13 16:48:34   Alert triggered. Polling failed, caused by: Task final state is RETRY or ERROR [2/5/13 4:48 PM]

05/02/13 16:48:34   2013/02/05 - 16:48:34:416 Fatal fault in 'Channel: SFTP_Party_Sample_Sender'. Description: Could not add or update entry for filename <sample_pain.001.001.02_130205144915_9689.xml.20130205140816.err> Details: Could not add or update entry for filename <sample_pain.001.001.02_130205144915_9689.xml.20130205140816.err> [2/5/13 4:48 PM]

05/02/13 16:48:34   Could not add or update entry for filename <sample_pain.001.001.02_130205144915_9689.xml.20130205140816.err> [2/5/13 4:48 PM]

05/02/13 16:48:34 d0f2afcd-6fb3-11e2-98fe-00001212ff86 Error type: COMPONENT_ERROR >> Error date: 2/5/13 4:48 PM >> Description: Could not add or update entry for filename <sample_pain.001.001.02_130205144915_9689.xml.20130205140816.err> [2/5/13 4:48 PM]

05/02/13 16:48:33   Processing task [2/5/13 4:48 PM]

05/02/13 16:48:33   Polling started. [2/5/13 4:48 PM]

I checked related SCN thread http://scn.sap.com/thread/2063194. As per the contributor, the issue occured because there is less disk space in the server and it got solved by freeing some space.

However, it seems that our issue has different cause because the administrator of the host server confirmed that there is more space in the server.

With this, could you please suggest what are other possible causes of this error? and how it can be solved?

Thank you and Regards,

Carlo

Accepted Solutions (1)

Accepted Solutions (1)

prateek
Active Contributor
0 Kudos

Could not add or update entry for filename

The error is not very explanatory and digging in to default traces in NWA would be a good idea.

Another area you may look into is the certificates for authentication.

Regards,

Prateek Raj Srivastava

former_member434498
Participant
0 Kudos

Hi Prateek,

I am able to extract the below logs from NWA default trace. However, I cannot understand what does it mean?

LOCATION [null, null, d276d2c0b11f397fb38525916a0b8e5c-7dd288286cad11e2929f0000121e638b] >> ERROR TYPE [null, COMPONENT_ERROR, not retryable, not fatal]] >> DESCRIPTION [Could not add or update entry for filename <pain_001_002_1000927726.xml> >> Could not add or update entry for filename <pain_001_002_1000927726.xml>] Caused by: com.seeburger.sftp.exception.SFTPTransactionException: Could not add or update entry for filename <pain_001_002_1000927726.xml>

at com.seeburger.sftp.correlation.MessageTracker.updateInboundFile(MessageTracker.java:309)

at com.seeburger.sftp.client.SFTPClient.processPollingRequest(SFTPClient.java:1532)

at com.seeburger.sftp.client.SFTPClient.processRequest(SFTPClient.java:642)

at com.seeburger.sftp.SFTPProcessor.executeOperation(SFTPProcessor.java:436)

at com.seeburger.sftp.SFTPProcessor.execute(SFTPProcessor.java:108)

at com.seeburger.frame.core.FrameWorkListener.syncNewData(FrameWorkListener.java:530)

at com.seeburger.xi.connector.fw.SynchronousTaskExecutor.executeTask(SynchronousTaskExecutor.java:40)

at com.seeburger.xi.connector.queue.QueueProcessorImpl.doInboundTransmission(QueueProcessorImpl.java:2194)

at com.seeburger.xi.connector.queue.QueueProcessorImpl.process(QueueProcessorImpl.java:704)

at com.seeburger.xi.connector.queue.QueueProcessorImpl.run(QueueProcessorImpl.java:254)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:182)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:212)

Caused by: com.seeburger.dt.messageidstore.impl.NoSuchEntryException: MessageId <7ef5b4b0-6cad-11e2-a1cf-41a0c1cacf36> does not exist!

at com.seeburger.dt.messageidstore.spi.db.SimpleAccessHandler.getMessageId(SimpleAccessHandler.java:431)

at com.seeburger.dt.messageidstore.spi.db.SimpleAccessHandler.getMessageId(SimpleAccessHandler.java:298)

at com.seeburger.sftp.correlation.MessageTracker.updateInboundFile(MessageTracker.java:298)

Error: com.seeburger.sftp.exception.SFTPTransactionException: Could not add or update entry for filename <pain_001_002_1000927726.xml> Caused by: com.seeburger.sftp.exception.SFTPTransactionException: Could not add or update entry for filename <pain_001_002_1000927726.xml>
at com.seeburger.sftp.correlation.MessageTracker.updateInboundFile(MessageTracker.java:309)
at com.seeburger.sftp.client.SFTPClient.processPollingRequest(SFTPClient.java:1532)
at com.seeburger.sftp.client.SFTPClient.processRequest(SFTPClient.java:642)
at com.seeburger.sftp.SFTPProcessor.executeOperation(SFTPProcessor.java:436)
at com.seeburger.sftp.SFTPProcessor.execute(SFTPProcessor.java:108)
at com.seeburger.frame.core.FrameWorkListener.syncNewData(FrameWorkListener.java:530)
at com.seeburger.xi.connector.fw.SynchronousTaskExecutor.executeTask(SynchronousTaskExecutor.java:40)
at com.seeburger.xi.connector.queue.QueueProcessorImpl.doInboundTransmission(QueueProcessorImpl.java:2194)
at com.seeburger.xi.connector.queue.QueueProcessorImpl.process(QueueProcessorImpl.java:704)
at com.seeburger.xi.connector.queue.QueueProcessorImpl.run(QueueProcessorImpl.java:254)
at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)
at java.security.AccessController.doPrivileged(Native Method)
at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:182)
at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:212)
Caused by: com.seeburger.dt.messageidstore.impl.NoSuchEntryException: MessageId <91062fe0-6cad-11e2-a1cf-41a0c1cacf36> does not exist!
at com.seeburger.dt.messageidstore.spi.db.SimpleAccessHandler.getMessageId(SimpleAccessHandler.java:431)
at com.seeburger.dt.messageidstore.spi.db.SimpleAccessHandler.getMessageId(SimpleAccessHandler.java:298)
at com.seeburger.sftp.correlation.MessageTracker.updateInboundFile(MessageTracker.java:298)

Answers (4)

Answers (4)

S0003485845
Contributor
0 Kudos

Hello,

Looking at your log, I see the following interesting lines...

-----------------------------

Caused by: com.seeburger.dt.messageidstore.impl.NoSuchEntryException: MessageId <7ef5b4b0-6cad-11e2-a1cf-41a0c1cacf36> does not exist!

at com.seeburger.dt.messageidstore.spi.db.SimpleAccessHandler.getMessageId(SimpleAccessHandler.java:431)

at com.seeburger.dt.messageidstore.spi.db.SimpleAccessHandler.getMessageId(SimpleAccessHandler.java:298)

at com.seeburger.sftp.correlation.MessageTracker.updateInboundFile(MessageTracker.java:298)

Error: com.seeburger.sftp.exception.SFTPTransactionException: Could not add or update entry for filename <pain_001_002_1000927726.xml> Caused by: com.seeburger.sftp.exception.SFTPTransactionException: Could not add or update entry for filename <pain_001_002_1000927726.xml>

at com.seeburger.sftp.correlation.MessageTracker.updateInboundFile(MessageTracker.java:309)

-----------------------------

So on a first look, it seems like there are problems writing some entries into the MessageIDStore / MessageTracking....so I have a few quick questions.

Can you see some entries in the Recovery Monitor ?

Are there any entries in the Module Chain ?

Kind Regards

Stefan

0 Kudos

Hi.

it is usually when you have the same file name which has been created before and you try to put the new one with the same name twice. I can't figure out how it could be possible, but if you wish to check that it is your case you can do the next:

- change adjustment of your sender and set "Create"

- once you selected "create", you will be proposed to check checkbox "Overwrite". Check this one as well.

I hope that can be help.

naveen_chichili
Active Contributor
0 Kudos

Hi,

Just a thought .. any chances of permissions issue?

Regards,

Naveen

prateek
Active Contributor
0 Kudos

Try with a filname with only one "." and see if it makes any difference.

Regards,

Prateek Raj Srivastava

former_member434498
Participant
0 Kudos

Hi Prateek,

Thanks for the response.

But we are able to pick up files with periods on other SFTP interfaces we have.

Aside from the periods, any possible cause? what areas do we have to look into?