Renaming the CATEGORY in the Repository
Moderators: chulett, rschirm, roy
Renaming the CATEGORY in the Repository
Hi All,
I renamed the category in the repository from 'Temp' to 'Temp_RM' by using the following SQL in Administrator.
UPDATE DS_JOBS SET CATEGORY='Retro\Assign\Temp_RM' WHERE CATEGORY = 'Retro\Assign\Temp'
The Category is updated and I see category 'Temp_RM' in the DS Designer .
When I navigate to that category in the Designer, the following message is displayed.
"Record Temp in file DS_JOBS does not exist "
After I said 'OK' and I can able to compile and run the jobs.
Please help me with this.
Thanks in advance.
I renamed the category in the repository from 'Temp' to 'Temp_RM' by using the following SQL in Administrator.
UPDATE DS_JOBS SET CATEGORY='Retro\Assign\Temp_RM' WHERE CATEGORY = 'Retro\Assign\Temp'
The Category is updated and I see category 'Temp_RM' in the DS Designer .
When I navigate to that category in the Designer, the following message is displayed.
"Record Temp in file DS_JOBS does not exist "
After I said 'OK' and I can able to compile and run the jobs.
Please help me with this.
Thanks in advance.
The lesson learned is that you should only use the approved methods in the client tools. Revert and try again.
Last edited by ArndW on Thu Jul 24, 2008 9:38 am, edited 1 time in total.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Bad Idea. Use the GUI, Luke! Create a new category and move everything over to it, then delete the old (empty) one. After you undo this, of course.
Last edited by chulett on Thu Jul 24, 2008 4:40 pm, edited 1 time in total.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi all,
Thank you everyone for their replies. The renaming of the Category was done basically tryng to rename all the jobs. I can able to rename the jobs but something messed up while renaming the category. After that, I imported the original jobs and everything is ok except that the I can not able to delete the renamed category. I cleared the clean up resources but not much help.
Can we able to delete that category ?
Thanks again
Thank you everyone for their replies. The renaming of the Category was done basically tryng to rename all the jobs. I can able to rename the jobs but something messed up while renaming the category. After that, I imported the original jobs and everything is ok except that the I can not able to delete the renamed category. I cleared the clean up resources but not much help.
Can we able to delete that category ?
Thanks again
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Perhaps you need first to re-build the indexes in the Repository. CATEGORY is one of the columns indexed. It may be that the delete operation is trying to use that index.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Thanks Ray.ray.wurlod wrote:Perhaps you need first to re-build the indexes in the Repository. CATEGORY is one of the columns indexed. It may be that the delete operation is trying to use that index.
Can we do the re-indexing thru admin. I donot have the admin rights, since I am the only person working on that project, I can get the exclusive access to that project very easily. But can I run that command without having all the admin authorities?
Thanks again
Thanks Ray.ray.wurlod wrote:Perhaps you need first to re-build the indexes in the Repository. CATEGORY is one of the columns indexed. It may be that the delete operation is trying to use that index.
Can we do the re-indexing thru admin. I donot have the admin rights, since I am the only person working on that project, I can get the exclusive access to that project very easily. But can I run that command without having all the admin authorities?
Thanks again
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I don't know. You don't need admin rights specifically, but you do need write permission (obviously) to all objects in the Repository. So I would suspect you're OK - just be very sure you have exclusive access (no non-Administrator clients open, not even yours).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: