How To clean Outsystem Logs table with help of advance sql query

How To clean Outsystem Logs table with help of advance sql query

  

How To clean Outsystem Logs table with help of advance sql query.

Hi Deep,

You need to write delete query in advanced sql with transactions. If you write simple delete query it will not work.


Thanks,

Rajat

All log Table can i delete ?i want to delete ldf file. how to delete ldf file?i am facing some database size issue

Deep,

Please try once as shown in below image.



Thanks,

Rajat Agrawal

All log Table can i delete ?i want to delete ldf file. how to delete ldf file?i am facing some database size issue

Arkyadeep Bharadwaj wrote:

Ohho Yes, they are system entity and not allowed to perform any operations.

I just send you scripts but not tried at my end.


Thanks,

Rajat


same script i executed.for read only purpose what i have to do

Arkyadeep Bharadwaj wrote:

same script i executed.for read only purpose what i have to doTwo

What do you mean by read only entity?

System entity or read only entity in different modules?


Thanks,

Rajat

Rajat Agrawal wrote:system entity.i think i need admin permissions.

Arkyadeep Bharadwaj wrote:

same script i executed.for read only purpose what i have to doTwo

What do you mean by read only entity?

System entity or read only entity in different modules?


Thanks,

Rajat



system entity.i think i need admin permissions.


What type of OS license you have?

Enterprise

Arkyadeep Bharadwaj wrote:

Enterprise

OnCloud or OnPremises?

OS will not give you admin access for OnCloud.

Simple way create one screen, put aggregate to fetch all records then pass in a loop to delete it.

Or write advanced query in preparation to delete all records.

Thanks,

Rajat


Rajat Agrawal wrote:

Arkyadeep Bharadwaj wrote:

Enterprise

OnCloud or OnPremises?

OS will not give you admin access for OnCloud.

Simple way create one screen, put aggregate to fetch all records then pass in a loop to delete it.

Or write advanced query in preparation to delete all records.

Thanks,

Rajat


Hi Arkyadeep,

You cannot delete data from Outsystems Entity just by testing. You have to write advance query in some actions or in preparation to delete all the rows.


Regards,

Himanshu



Hi,

To take care of db size issues you can use forge components like this https://www.outsystems.com/forge/component/423/dbcleaner/?Unfollow=False and https://www.outsystems.com/forge/1195/

Regards,

Marcelo