Forum Stats

  • 3,851,421 Users
  • 2,263,974 Discussions
  • 7,904,701 Comments

Discussions

Delete ALL OSB PROJECT in 11g

3755663
3755663 Member Posts: 6
edited Aug 31, 2020 3:36AM in SOA Suite Discusssions

Hi All,

As part of upgrade from 11g to 12c oracle recommends to take the export of existing project and delete the entire project.

Number of projects vary across domain, so i want to find project present in a domain and delete it.

Tagged:
3755663

Best Answer

Answers

  • Martien van den Akker
    Martien van den Akker Member Posts: 2,777 Bronze Crown
    edited Aug 11, 2020 4:41AM
  • 3755663
    3755663 Member Posts: 6
    edited Aug 26, 2020 2:29PM

    Hi Martien,

    I went thru the blog and implemented on my system, i am getting the below error on deletion

      File "/$LOGNMAE/products/Middleware/soa/common/wlst/bpm-wlst-commands.jar!/wlstScriptDir/bpmLifecycleTasks.py", line 75, in deleteProject

    TypeError: oracle.bpm.alm.script.legacy.operation.DeleteOperation(): 1st arg can't be coerced to String

    My project name example= FUSION-SYSTEM-PROJECT

  • Martien van den Akker
    Martien van den Akker Member Posts: 2,777 Bronze Crown
    edited Aug 27, 2020 3:15AM

    Ha,

    Funny, I just got the message to mediate the comment on the blog.

    I'm confused about the 'wlst/bpm-wlst-commands.jar!/wlstScriptDir/bpmLifecycleTasks.py' part of the message, together with 'oracle.bpm.alm.script.legacy.operation.DeleteOperation'.

    These seem to relate to Oracle BPM, but it's an OSB related script.

    The script was created for OSB11g, but I assumed it should work with 12c more or less similarly.

    Unfortunately I haven't got the resources/example projects to do a simple test. I may have a look, but it might not be in short notice.

    Maybe someone else has some suggestions?

    Kind regards,

    Martien

  • Martien van den Akker
    Martien van den Akker Member Posts: 2,777 Bronze Crown
    edited Aug 28, 2020 5:06AM Answer ✓

    Could you post your resulting script?

    The Collections identifier come from the import on the top:

    from java.util import Collections

    Apparently it can't find that.

    Regards,
    Martien

  • 3755663
    3755663 Member Posts: 6
    edited Aug 28, 2020 5:16AM

    Hi Martien,

    You are correct, i missed to import it thats why i got an error.

    Issue is resolved and i am able to delete multiple projects in one go by using your code

    Just out of curiosity it doesn't give any warning for dependent  projects it directly , as i tried to restore few deleted sessions i got this warning.

    Is there any way to find out dependent projects?

  • Martien van den Akker
    Martien van den Akker Member Posts: 2,777 Bronze Crown
    edited Aug 31, 2020 3:36AM

    Oeh, I think that's difficult. That's something that's done in the activation step by OSB.

    So, I presume you should know what you're doing and be sure that what you delete is meant to be deleted and not has any dependencies.

    Kind regards,
    Martien