Required details on DB Table and Error codes [Please refer Detailed query ]

[Sathish Kumar R]

1. As part audit we require to know when the application was last uploaded and by whom.
   We are already aware of download-> achieved version option [but we can't check all the apps one by one] and other option we tried export of audit logs but here also we have filtered the csv and export only 1 day of data since csv is not opening dur to huge volume.
   
   Solution required: Is there any other option to capture this info [when the application was last uploaded and by whom] is here any specific DB table can provide these details?

 2.We are planned to enable log monitoring is there any documentation can provide details of error codes?

We are aware of INFO, WARNING, ERROR, FATAL, but whenever we see some error, we also noticed code like RMI TCP Connection(912320) [Mentioned random code for Eg], 

Could you please help with above queries?

[SHARON SHIMANEK]

Hi

You should be able to get all version history that you keep in ESP_AMS_VR.

Sharon

[Sathish Kumar R]

Thank you, Sharon 

Could you please check if you assist on this 2nd question Aswell.

 2.We are planned to enable log monitoring is there any documentation can provide details of error codes?

We are aware of INFO, WARNING, ERROR, FATAL, but whenever we see some error, we also noticed code like RMI TCP Connection(912320) [Mentioned random code for Eg], 

[SHARON SHIMANEK]

Sorry I am not able to help with your 2nd question

Sharon

[Ravi Kiran Kunduri]

dSeries server generally responds with StandardResponse object with more details in it. 

For example - when application is uploaded , you will see the response as 

..... response: userToken=[UserToken[userId=....,tokenId=...]], StandardResponse[statusMessage=Application xxxxx successfully updated, statuscompletioncode=SUCCESS, statusmessageid=AMS00009, infomessages=(), payload=ReadPayload[definition=null, definitionproperties=DefinitionProperties[version=2, versionComments=, modifieduser=xxxx, modifiedtime=Thu Aug 08 14:30:34 IST 2024, lockuser=null, locktime=null, lockid=xxxx], runtimeproperties=RuntimeProperties[]]]

You will get the user details and time values from it. 

Similarly most the responses whether it is warning , error , successful follow the same structure.

Hope it helps!