cancel
Showing results for 
Search instead for 
Did you mean: 

Query on Agentry File System Connection

neha_mahanty
Active Participant
0 Kudos

Hi All,

I am exploring the Agentry file system connection.

I followed this link to create a Data Table with the help of File System connection

https://sycloresourcecenter.sap.com/development/kb/howtocreate-and-display-local-data-table-using-we...

But I am not able to achieve this.

My Agentry.ini settings

[File-2]

name=FileConnection

allowPreviousUserLogin=false

enableAuthentication=true

enablePreviousUserAuthentication=false

tempPath=C:\Agentry\ServerDev\FileExample ----------------------------(This is the path where I have kept my text file)

userDomain=

My Text file (AgentryFile.txt) contains

[AgentryFile]
one=one
two=two

[LastUpdates]
AgentryFile: 8:00:00 09/09/2013

and my Data Table settings

But I am not getting any Data Table created in the client.

I also want to create a text file and read in the object and perform read write operation via step and transaction.

Please guide me how to work with the File system connection and achieve the above requirement.

Thanks and Regards

Neha Mahanty

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Neha,

Create a folder withing the root level of the Agentry Server called "Tables" and place the file there.

Step 4 on this page: https://sycloresourcecenter.sap.com/development/kb/howto-create-data-table-file-backend

neha_mahanty
Active Participant
0 Kudos

Hi Steve,

I placed my file under server root directory  C:\Agentry\ServerDev\Tables still it did not worked.

Neha

Former Member
0 Kudos

Please try with your file with the following new line separations

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

[AgentryFile]
one=one
two=two

[LastUpdates]
AgentryFile: 8:00:00 09/09/2013

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

Also are there any errors related to this showing up in your server logs?

neha_mahanty
Active Participant
0 Kudos

Hi Shahid,

I tried your suggestion too but it did not worked .

However this is the log file details

2013/10/15 15:28:10.844: + Thread=4936

2013/10/15 15:28:10.844:   + Thread Pool=Server

2013/10/15 15:28:10.844:     + WorkFunction=0B33F4BC

2013/10/15 15:28:10.844:       + User=nmahanty

2013/10/15 15:28:10.844:         + Server=Agentry

2013/10/15 15:28:10.844:           Update data tables:  Getting back end connections

2013/10/15 15:28:10.844:           Retrieve DataTable definitions:  1 DataTable definitions loaded

2013/10/15 15:28:10.844:           + DataTable=AgentryFile

2013/10/15 15:28:10.844:             Update data table 'agentryfile' for 'User': Client last data update 12:00:01 AM 1/1/1900

2013/10/15 15:28:10.844:             Server definition itself updated 3:04:44 PM 10/15/2013

2013/10/15 15:28:10.844:             Server definition and overrides last updated 3:04:44 PM 10/15/2013

2013/10/15 15:28:10.844:             Retrieve DataTable definitions for 'AgentryFile':  Definition changed for AgentryFile, will force reload

2013/10/15 15:28:10.844:             + BackEnd=File-2

2013/10/15 15:28:10.844:               FileConnection: checking for update for DataTable agentryfile in AgentryFile.txt: client update 12:00:01 AM 1/1/1900

2013/10/15 15:28:10.844:               FileConnection: DataTable agentryfile: server update 12:00:01 AM 1/1/1900

2013/10/15 15:28:10.844:             Data table 'agentryfile' not updated: client is already up-to-date

2013/10/15 15:28:10.844:           Update data tables for 'User':  0 tables to send, last update 3:28:10 PM 10/15/2013

I am attaching the server log file too. if this can help.

Thanks

Neha

Former Member
0 Kudos

I know this seems counter-intuitive, because this is windows, but try renaming your Data Table definition or file name to make sure the case matches. At the moment your data table definition is agentryfile and your file name is AgentryFile.txt. To rename the windows file AgentryFile.txt, you will first have to name it as something else like a.txt, and then name it to agentryfile.txt

Answers (0)