on 08-26-2014 7:46 PM
We are attempting to add a web service job and getting a duplicate name issue. I believe we have a caching issue where this job name may already exist but we are unable to see it on the web services status page.
Is there a data services repository database table where I can find these web services jobs listed and clean it up from the backend?
what is the complete version of DS ? yes the problem could be with the displaying of batch jobs already published as WS, I remember there was a bug in early version of 4.1 SP1
check if you see the job along with repo name under
webServiceEnabledJobs in %DS_COMMON_DIR%\conf\admin.xml file ? if yes, then the problem is with display
the issue was with invalid Unicode characters in the description of job/wf/df
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is version 4.0, sp2, patch 5. We are upgrading this in a month to 4.2, sp1, patch 4.
I have found the job listed under a different repository than what we are trying to add it from in the admin.xml file. It seems that I can edit the file and delete the data. I close and reopen the file and it is gone but as soon as I try to add the job again I get the duplicate message and I find it again in the xml file under the other repository.
Any idea how I can get around that?
you can delete the entry from Admin.xml ,for that do the following
Stop tomcat
delete the entry
logon to Designer, connect to local repo that was in the Admin.xml, open properties of the job, click on attributes, you see a attribute named Webservice Enabled with value TRUE change that value to FALSE, if it is not their then it's fine
close designer
now Start tomcat
one more thing, since this job is showing up in admin.xml, was it also showing up in the webservices page ? if yes, delete it from there instead of manual delete
Hello Ken,
Are you able to resolve this issue? If yes, please advise how you did?
We go the same issue long time back and we able to fix by editing the admin.xml file. But got the same issue after 2 months of time. None of the added jobs not showing up in the webservice configuration in the Management console. But admin.xml has every job we added.
Now we are tying to modify admin.xml(turn off tomcat and modify and turn on) but changed are not effecting to the webservice config. When adding job to the webservice config. we got the same error saying job already exists.
Appreciate if you can advise on this.
Thanks
Venky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Go to the local object library in the
Designer-->Local Object Library-->right-click on data flows (both Normal and ABAP)--> repository-->Calculate Usage Dependencies
And wait for some time until Data services populates the AL_USAGE table(Back-end Repository Table).
Once done, you'll receive a pop up message.
Then do the following query to retrieve the number of jobs associated to that repository.
SELECT
AL_USAGE.PARENT_OBJ,
AL_USAGE.PARENT_OBJ_DESC,
AL_USAGE.PARENT_OBJ_TYPE,
AL_USAGE.DESCEN_OBJ,
AL_USAGE.DESCEN_OBJ_DESC,
AL_USAGE.DESCEN_OBJ_TYPE,
AL_USAGE.DESCEN_OBJ_USAGE,
AL_USAGE.DESCEN_OBJ_DS,
AL_USAGE.DESCEN_OBJ_OWNER,
AL_USAGE.DEPTH
FROM AL_USAGE
WHERE AL_USAGE.PARENT_OBJ_TYPE = 'Job'
Now check for your Job which is causing duplicate constraint and delete it.
Regargds,
Mubashir Hussain
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry guys. Not trying to be difficult on this but isn't the AL_HISTORY table just information about the execution statistics of jobs? At this point we are just trying to get the job added as a web service but it thinks it is already a web service. We are not even at the point of executing it yet.
The job name can be found in the object library. Go to object library and check the job using job name and where it is used.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Not sure I follow...In the designer if I go to the object library there is no "where used" on the job itself.
What I am looking for is a back end repository table that would show this job established as a web service (i.e. the error indicates that somewhere it thinks this is already set up as a web service).
I have a feeling we have a disconnect somewhere and internally it thinks this is already set as a web service job but it is not. If I can clean it up in the back end I can recreate it as a web service job.
Thanks,
Ken
There is no option there that shows me if it is being used as a web service. Here is my issue with some screen shots.
I look at my current web service enabled jobs looking for B_JOB_CP_MDR_to_GW_EMP but it is not in the list.
I attempt to add it from repository DWXDS9
It throws an error and tells me there is already a web service with this name...
Now there has got to be an internal data services table somewhere that has this job listed as a web service. I am just trying to figure out what that table may be to determine if we can do some type of cleanup on it so we can add this job again as a web service (so it is visible to us).
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.