Delete

Hi,

this is getting unbelievably messy, to be honest. I thought you mentioned you were good in DQL.

Anyway, you should use Folder() predicate, or simply use the i_ancestor_id of dm_folder. A query that works is

select r_object_id from dm_sysobject(all) where DATEDIFF(day,"r_modify_date",DATE('TODAY'))>=30 and any i_folder_id IN(    select r_object_id from dm_folder where any i_ancestor_id in (        select r_object_id from cm_folder where r_object_type = 'cm_trash_folder'))Order by r_object_id

but again, this is pretty messy indeed!

Just to ask a dumb question, does type cm_folder have subtypes?

If not, the

select r_object_id from cm_folder where r_object_type = 'cm_trash_folder'

is pretty much wasted, you should simply skip the "r_object_type='cm_trash_folder", this is the only possible value anyway.

Regards

Jørg

All comments

Obviously, there is one or more objects which causes problems. Using a query like this doesn't return the object in question, as you've noticed.

Simplest way is probably to run a SELECT query, loop thru the collection, instantiate objects and use destroy() method.

This will work for all objects, and throw an understandable error for the ones that don't work.

Regards

Jørg

DCTM_Guru

Please post your DFC code

Haroon_A

Since you are using DFC, why don't you return a collection off of your select query, and use IDfSysObject.destroy (or destroyAllVersions based on your need), this way you can check before destroying if an object is locked, i.e. IDfSysObject.isCheckedOut(), and unlock if needed.

Use delete operation you can then check which dcuments were not deleted. Take a look at this, I have included source code as well, you can modify or extend them.

If you have xcp you can create a simple process with loop,and select all documents and cancel checkout them individually and delete them.

hope it helps

Hi,

here is my dfc code....

IDfQuery query = new DfQuery();
IDfQuery query1 = new DfQuery();
IDfQuery query2 = new DfQuery();
String dqlunlock = "update dm_document object set r_lock_owner = '', set r_lock_machine = '', set r_lock_date = date('nulldate') where r_lock_owner<>' ' and owner_name = '"
+ username + "'";

query.setDQL(dqlunlock);
IDfCollection collection = null;
IDfCollection collection1 = null;

try {

collection = query.execute(session, IDfQuery.DF_EXEC_QUERY);

   collection.next();
   if (collection.getInt("objects_updated") == 0) {
    printWriter.write("\n No documents to unlock" + "\n");
   } else {
    printWriter.write("\n No of objects to unlock are: "
      + collection.getInt("objects_updated"));
    printWriter.write("\n Update query successfully executed !! "
      + "\n");
   }
   String dql = "select r_object_id,object_name from dm_sysobject where any i_folder_id IN(select r_object_id from dm_folder where object_name='Trash' and owner_name = '"
     + username + "')";
   query1.setDQL(dql);

   collection1 = query1.execute(session, IDfQuery.DF_EXEC_QUERY);
   printWriter
     .write("\n Documents present inside Trash folder are as follows:-"
       + "\n");

   int counter = 0;
   while (collection1.next() && collection1 != null) {
    counter++;
    String objectid = collection1.getString("r_object_id");
    String objectname = collection1.getString("object_name");
    printWriter.write("\n Object id is : " + objectid + " ");
    printWriter.write("Object name is : " + objectname + "\n");

   }
   if (counter > 0) {
    printWriter.write("\n Delete in Progress.....");
    String dqlForDeletingDocuments = "delete dm_sysobject OBJECTS where DATEDIFF(day,\"r_modify_date\",DATE('TODAY'))>=30 and any i_folder_id in (select r_object_id from dm_folder where object_name = 'Trash' and owner_name = '"
      + username + "')";
    query2.setDQL(dqlForDeletingDocuments);
    collection = null;
    collection = query2.execute(session, IDfQuery.DF_EXEC_QUERY);
    printWriter.write("\n Delete query successfully executed !! ");

   } else {
    printWriter
      .write("\n There are no documents present inside Trash folder for deletion !!");
   }
} catch (Exception e) {
   e.printStackTrace();
   printWriter.write("Exception in CMTrashFolderDelete "
     + e.getMessage() + "\n");
   throw e;
} finally {
   if (collection != null) {
    collection.close();
   }
   if (session != null) {
    sessionManager.release(session);
   }
}
return 0;

I need to include a query in the above code,where it will find if there are any referenced/linked objects and then destroy them if it satisfies the date condition.

Regards,

Priyanka Ithape

Sorry for the link, here it is. https://community.emc.com/docs/DOC-18506

hope it helps

Hi Imran,

I dont work on xcp.I work on Documentum.!!!

You can still make use of IDfDelete operation. http://developer.emc.com/developer/devcenters/ContentManagement/devsupp/DFCOperationsWhitepaper.pdf

sukumar

To delete all objects , versions and all referenced douments you can use ALL in your delete query as below

delete dm_sysobject(ALL) OBJECTS

Hi sukumar,

After including all in my delete query,

delete dm_sysobject(ALL) OBJECTS where DATEDIFF(day,"r_modify_date",DATE('TODAY'))>=30 and any i_folder_id in (select r_object_id from dm_folder where object_name = 'Trash' and owner_name = 'dmsevcstg')

i am still getting the same error:-

[DM_QUERY_F_UP_DESTROY]fatal: "DELETE: An error has occurred during a destroy operation."

Of course you do!

The (ALL) keyword simply tries to delete non-current versions as well, but it WON'T remove the original problem of yours.

You still do have an object which can't be deleted!!

Regards

Jørg

Hi Jorg,

How do i find out the referenced objects.Is there any query which i can include in my above code?

Regards,

Priyanka

Why do you try to do everything with dql? If everything was possible with dql emc would not have necessarily developed the DFC operations? If you are going to do this with dql then why do you write code? You are executing several queries within your code and you can simply execute them in a dql editor too. And never expect that dql will provide you a meaningful error message to troubleshoot the problem. Yet (update dm_document object set r_lock_owner = '') r_ stands for read only, and you are not allowed to update them. So use dfc operations and then check operation errors, they should provide you more meaningful messages to decode the actual problem.

Hi,

I've had a look at your code, which is pretty much effort which could be achieved a lot simpler.

Imran has already pointed out operations, which are 1 alternative. Personally, I'm trying to avoid them whenever I can, but they do certainly do the job

Are you known with DFC methods for sysobjects at all? Several replies have mentioned .destroy(), .destroyAll() and .unlock() already. These are pretty much the methods you need, and your code should look like

String dql = "select r_object_id from dm_document where ......");//Retrieve a collection, use IDfQuery.DF_QUERYwhile ( coll.next() ) {   IDfSysObject so = (IDfSysObject)<session>.getObject(coll.getId("r_object_id");   if ( so.isCheckedOut() )      so.unlock();   System.out.print("Attempting to delete object with id: " + so.getObjectId() + "-" + so.getObjectName() + "....);   try {       so.destroy();       System.out.println("OK");   } catch (DfException dfe) {      System.out.println("failed." + dfe.getMessage());   }}

You may want to add code to check whether you have delete permission etc etc etc. Get familiar with DFC methods, have a good look at the javadocs, and your done

Good luck

Jørg

Hi Jorg,

Actually i am not familiar with DFC Operations.

I am good with DQL query.

The above code will let me make my entire code change.And i docnt know whteher it takes into consideration all the requirements which i have put into my query's such as owner name and object name.

It will be helpful for me to have some unlink query for documents which are linked or referenced so that i can put in my code and retrieve the documents through collections.

Kindly help,

Thanks and Regards,

Priyanka Ithape

Actually i am not familiar with DFC Operations.I am good with DQL query.

Well, DFC operations as well as DFC methods are well documented, and easy to use. I suggested, and gave you an example on how to use them. DQL is a good start, but you as you can see clearly, it's simply not enough!

The above code will let me make my entire code change.And i docnt know whteher it takes into consideration all the requirements which i have put into my query's such as owner name and object name.

That is/was the entire idea of it! TO be honest, your code is kind of messy, isn't it? You're running 3 different queries, and you would use the same where clause as earlier in order to retrieve the objects. Unlock and delete are achieving your other requirements.

Just give it a try, as you're not able to achieve it by simply running queries, right?

Jørg

Hi Jorg,

I tried your code and it was working great.

But then i need to pass the date clause as well.The docuemnts to be deleted should have their modify date greater than 30.Only those documents need to be deleted.

How can i add that in the code you provided?

Kindly help.

Regards,

Priyanka Ithape

Hi,

simply add the DATEDIFF into the where clause, you have it in the original DELETE query, and this can of course work in a SELECT query as well.

Jørg

Hi Jorg,

I wanted to pass the date as variable in the query.I could do that.

I also want to know the count of documents locked and print them.But even if i write Syso statement,those statements are repeated the time while loop runs.

I want print statements like,

1) no objects to lock.

2) count of objects that are locked

But i am not able to.

I dont want two while loops and making collection null after one while loop and taking another collection.

This will complicate the code.

Can you help me in it.Have copied the code below

Also one doubt,if i write dm_document instead of dm_sysobject in query,it will delete only documents not folders right present inside Trash folder.

Below is the code:-

IDfQuery query = new DfQuery();

String dql = "select r_object_id,object_name from dm_document where DATEDIFF(day,\"r_modify_date\",DATE('TODAY'))>="+Date_var+" and any i_folder_id IN(select r_object_id from dm_folder where object_name='Trash' and owner_name = 'dmsevcstg')";

query.setDQL(dql);

IDfCollection collection = null;

collection = query.execute(session, IDfQuery.DF_QUERY);

while ( collection.next() ) {

IDfSysObject so = (IDfSysObject)session.getObject(collection.getId("r_object_id"));

if ( so.isCheckedOut() ){

so.cancelCheckout();

}

System.out.print("Attempting to delete object with id: " + so.getObjectId() + "-" + so.getObjectName() + "....");

try {

so.destroyAllVersions();

System.out.println("Object deleted");

} catch (DfException dfe) {

System.out.println("Failed." + dfe.getMessage());

}

Thanks,

Priyanka Ithape

yamangoyal

Something like this:

int lockcount=0;

int notlockedcount=0;

while ( collection.next() ) {

IDfSysObject so = (IDfSysObject)session.getObject(collection.getId("r_object_id"));

if ( so.isCheckedOut() ){

so.cancelCheckout();

lockcount++;

}

else

notlockedcount++;

System.out.print("Attempting to delete object with id: " + so.getObjectId() + "-" + so.getObjectName() + "....");

try {

so.destroyAllVersions();

System.out.println("Object deleted");

} catch (DfException dfe) {

System.out.println("Failed." + dfe.getMessage());

}

System.out.print("Document locked:"+lockcount);

System.out.print("Document notlocked:"+notlockedcount);

lastnitescurry

That is/was the entire idea of it! TO be honest, your code is kind of messy, isn't it? You're running 3 different queries, and you would use the same where clause as earlier in order to retrieve the objects. Unlock and delete are achieving your other requirements.Just give it a try, as you're not able to achieve it by simply running queries, right?Jørg

Code is plain horrible but this thread is a fun to read.

I'll throw in the following but I suspect the logic of it will not be understood and hence not used... part of the reason why I don't post so much any more

Do some research, these are good starting points for DQL stuff
Change to DfLogger.debug and DfLogger.info
Move DQL processing code to a utilty class.
1. Always debug print out the DQL sent
2. Always capture DQL execute error and error print out (DfLogger.error) the error message along with the DQL that was issued.
3. Add a method that returns the value of single value select, i.e. COUNT(*)
For reporting, do it seperately, i.e. with DQLs like
1. SELECT COUNT(*) FROM dm_document (ALL) WHERE r_lock_owner NOT NULLSTRING
For DELETE, just use DQL but First check your where, with a select,
1. SELECT COUNT(*) FROM dm_document (ALL) WHERE r_lock_owner IS NULLSTRING AND ???? what ever ???
2. Then
3. DELETE dm_document (ALL) WHERE r_lock_owner IS NULLSTRING AND ???? what ever ???
4. If you got relations or other fancy stuff then you will need to delete them seperately
Does anyone pay attention to performance? That style of coding will kill a system
1. http://tech.dir.groups.yahoo.com/group/dmSmarts/message/100?var=0

Hi All,

I am getting the following error :-

Attempting to delete object with id: 0b00d6da8005ec41-TestUser(J)....Failed.[DM_FOLDER_E_CANT_DESTROY]error: "Cannot destroy folder with path name /IT/Trash/TestUser(J) since it is not empty."#

Since the query which i have written is:-

select r_object_id from dm_sysobject(all) where DATEDIFF(day,"\r_modify_date\",DATE('TODAY'))>="+Date_var+" and any i_folder_id IN(select r_object_id from cm_folder where r_object_type='cm_trash_folder')

It is not unlocking or deleting the documents present inside sub-folders having the folder of type cm_trash_folder.

It is considering only the one level object id of document and folders.

How to modify the above query where it will consider all the object ids of folder heirarchy and it will delete all the documents present inside the folder hierarchy .

Following is the code:-

IDfQuery query = new DfQuery();
String DeleteForTrash = "select r_object_id from dm_sysobject(all) where DATEDIFF(day,\"r_modify_date\",DATE('TODAY'))>="
+ Date_var
+ " and any i_folder_id IN(select r_object_id from cm_folder where r_object_type = 'cm_trash_folder')";
query.setDQL(DeleteForTrash);
IDfCollection collection = null;
IDfCollection collection1 = null;
collection = query.execute(session, IDfQuery.DF_QUERY);
collection1 = query.execute(session, IDfQuery.DF_QUERY);
int countofcheckoutobj = 0;
int lockcount = 0;
int countforcollection = 0;

while (collection.next())

{
IDfSysObject idfobj = (IDfSysObject) session.getObject(collection .getId("r_object_id"));
countforcollection++;

if (lockcount == 0)

{
while (collection1.next())

{
IDfSysObject idfobjchkout = (IDfSysObject) session.getObject(collection1.getId("r_object_id"));

if (idfobjchkout.isCheckedOut())

{
idfobjchkout.cancelCheckout();

      countofcheckoutobj++;
      System.out.println("value for count is"+countforcollection);
          }
        }
    System.out.println("No of objects unlocked are:"
      + countofcheckoutobj );
       }
   lockcount = 1;

   System.out.print("Attempting to delete object with id: "
     + idfobj.getObjectId() + "-" + idfobj.getObjectName() + "....");
   try

{
    idfobj.destroyAllVersions();
    System.out.print("Object deleted"+"\n");
   } catch (DfException dfe) {
    System.out.println("Failed." + dfe.getMessage());
   }

}
System.out.println("Total number of Documents deleted :- "
+ countforcollection);
}

Kindly help,

Priyanka Ithape

Hi,

well, message obviously makes sense, you can't delete folders that aren't empty

Simplest way is to ensure that you delete all documents/sysobjects BEFORE you delete the folders.

You could add

ORDER BY r_object_id

which will return 08/09 objects before folders (0b).

Regards

Jørg

Hi Jorg,

It is just changing the order.

The query below is giving me one level details.I want the sub-folder hierarchy as well.

Please help me in modifying the query.

select r_object_id from dm_sysobject(all) where DATEDIFF(day,\"r_modify_date\",DATE('TODAY'))>="+ Date_var+ " and any i_folder_id IN(select r_object_id from cm_folder where r_object_type = 'cm_trash_folder') Order by r_object_id

Thanks,

Priyanka Ithape

Oh dear,

I didn't look at the query all!

Why don't you use the Folder predicate? Do you have many trash folders?

Jørg

Hi Jorg,

Yes,i have around 800 or so folders by the name Trash.In it there are sub-folders and documents.

Need to delete everything.

Regards,

Priyanka Ithape