{"id":874,"date":"2019-04-07T19:13:08","date_gmt":"2019-04-07T17:13:08","guid":{"rendered":"https:\/\/www.ildico.com\/?p=874"},"modified":"2019-04-07T19:19:39","modified_gmt":"2019-04-07T17:19:39","slug":"english-sap-idm-how-to-change-the-repository-type-of-a-repo-job","status":"publish","type":"post","link":"https:\/\/www.ildico.com\/en\/english-sap-idm-how-to-change-the-repository-type-of-a-repo-job\/","title":{"rendered":"SAP IDM: How to change the repository type of a repo job"},"content":{"rendered":"

When implementing repository jobs, SAP seems to have forgotten a functionality to change the repository type linked to a repository job. The field has been greyed out in Eclipse even when you are in edit mode.<\/p>\n

So how to cope with this? Re-creating all the repo jobs you have set up for e.g. ABAP Load Balanced Connections for the ABAP Dedicated Server connection? A bit much effort. Also when replacing the SAP Repo type by your own you might not want to run through creation again.<\/p>\n

So the answer lies – as often – inside the database. The repo type is mapped inside the mc_jobs table and is determined by two columns, mcRepositoryTypeQN and mcRepositoryTypeId.<\/p>\n

Example<\/p>\n

update mc_jobs set mcRepositoryTypeQN =<\/code>'customer.idm.connector.abap:reptype.ABAPLoadBalancedConnection', <\/code>
\nmcRepositoryTypeId = 11 where jobid = 1234<\/code><\/p>\n

The above statement will update job number 1234 to another repo type.<\/p>\n

How to get the proper values for mcRepositoryTypeQN and mcRepositoryTypeId?<\/p>\n

Well the easiest is to just create a new job for the other repo type, get the job number from Eclipse and then<\/p>\n

select mcRepositoryTypeQN<\/code>,<\/code>mcRepositoryTypeId = 11 from mc_jobs where jobid = 2345<\/code><\/p>\n

Happy IDM programming.<\/p>","protected":false},"excerpt":{"rendered":"

When implementing repository jobs, SAP seems to have forgotten a functionality to change the repository type linked to a repository job. The field has been greyed out in Eclipse even when you are in edit mode. So how to cope… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[22],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ildico.com\/en\/wp-json\/wp\/v2\/posts\/874"}],"collection":[{"href":"https:\/\/www.ildico.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ildico.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ildico.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ildico.com\/en\/wp-json\/wp\/v2\/comments?post=874"}],"version-history":[{"count":2,"href":"https:\/\/www.ildico.com\/en\/wp-json\/wp\/v2\/posts\/874\/revisions"}],"predecessor-version":[{"id":876,"href":"https:\/\/www.ildico.com\/en\/wp-json\/wp\/v2\/posts\/874\/revisions\/876"}],"wp:attachment":[{"href":"https:\/\/www.ildico.com\/en\/wp-json\/wp\/v2\/media?parent=874"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ildico.com\/en\/wp-json\/wp\/v2\/categories?post=874"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ildico.com\/en\/wp-json\/wp\/v2\/tags?post=874"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}