Hi all,
I need your assistance to solving the situation which is important for my project. I need to modify the logfiles which I know generated automatically. I just need to add some field in the perflog/web_api_details.csv file.
How shall I do this? Is there a way to manipulate log4jconfig.xml in Appian cloud environment to capture additional information in perflog/web_api_details .csv file.
Please suggest. Thanks in Advance.
Discussion posts and replies are publicly visible
I don't think this is possible. Some logs can be updated to change the logging level but I'm not aware of a way to add additional columns to any logs. What is your use case?
Thanks for your quick response Peter.
We are trying track unique identifier for individual api call. When the api call made need to add the unique reference number for each api call in web_api_details.csv file and need track on database also.
Thank You.
Sorry, I don't think my repsonse was very clear. The issue isn't with the logging - the logging will work great and will always return the correct UUID. The problem is then trying to figure out which integration is related to that UUID. That's the procedure that is pretty much entirely manual.
Likely what you will need to do is to go to each integration in your design environment and export all of them. The export log contains the UUID and the name of each integration that you can get from the export Then, manually create a table that includes the UUID and a description of the integration. If you have a large number of integrations, this may take a while. Once you have this table, then you can match them up with your log.
Thanks a lot Peter. Your responses have given as a lot of insights and clarity for our development. Appreciate it. We will design the system based on your guidance.
Regards,
Thiru
Hi Peter,We need some help to understand the fields belonging from the file integration_details.csv.We already gone through the link below to understand these fields details like Mean total time, Mean preparation time, Mean execution time and Mean transform time and we don’t find complete information.https://docs.appian.com/suite/help/21.1/Logging.html#integration-performance-logsWe have some assumptions, please confirm that our assumptions are correct or not?Mean preparation time: We assumed that the mean preparation time is the time taken to request parameters, post the calls sending to the external api's.Mean execution time:- We assumed that the mean execution time is the time taken api to prepare the response parameter and send it back to the calling appian application.Mean transform time:- We assume that the mean transform time is the time taken by the appian application to process the data coming in as part of response parameter from external api.We already know that the mean total time is summation of Mean preparation time, Mean execution time and mean transform time. We also wanted to know that network latency time is included with mean total time? if not, then please confirm which component(Mean prepare time, Mean execution time, Mean transform time) is carrying the network latency time. Thanks in advance.
Sourav.
The easiest way to think about it is that prepare and transform are both time that Appian spends creating the request structure and formatting the sponse respsectively. The execution time is all the time between the request getting sent and receiving a response back, so it would include the latency time. I think the integration designer actually explains this well by showing that the middle time is "Send | Wait | Receive".
Hi peter.
We need your assistance on these two fields Integration UUID and connected system UUID in Integration_Details.csv.
We see that in integration_details.csv, that mean time values are calculated by aggregating based on certain columns. Please explain which columns are used for aggregation logic. Is it combination of Integration UUID and connected system UUID? Also, what if the frequency for aggregation? is it 1(one) Hour?.
Thanks in advance.
Thanks,
Nandhakishore.
It should just be integration UUID that is used for grouping on the data. Also all Details logs are written to once per hour: docs.appian.com/.../Logging.html
Hello Peter,
We need your assistance. How do we populate the integration UUID in database table. Is there any possible way to store the integration UUID. Please guide us.
Thanks in advance,
Nandakishore.
This is the part that's probably entirely manual - you'll have to identify the integration UUID from the export log and then create a table and insert a each UUID with its corresponding name. I'd recommend inserting this directly into the database in your development environment and then deploy the entire table to production.
Hope you are doing good.
Can you please tell us, what is the "Timestamp" in Integration_details.csv?
Is it the time captured on or before starting the process or Is it the time captured after completion of the process?
Could you please share your view regarding the above question.
The timestamp in the details log is simply the time when the entry was added. Remember, the details log works by aggregating all the information for the past hour, so really the timetamp should show in 1 hour increments. It doesn't have any relation to the time the integration was executed, except that it occurred in the past hour.