Page 1 of 1
Cannot delete routine
Posted: Tue Mar 05, 2013 7:33 pm
by jhmckeever
Hi,
I created a server routine then attempting to rename or delete it from the designer gave me the following error:
Code: Select all
Unable to rename the item.
The reference to entity "B" must end with the ';' delimiter.
Any thoughts anybody?
Thanks,
John.
Posted: Wed Mar 06, 2013 12:21 am
by ray.wurlod
Something internal fouled up in generating the query against XMETA?
Can you drag the routine to a different folder?
Posted: Wed Mar 06, 2013 6:00 pm
by jhmckeever
Nope ...
Code: Select all
Error message: An error occurred when executing the operation:
Exception type: ReposAccessException
Exception message:
Exception source: IBM.DataStage.RepositoryAccess
Exception stack trace:
...
... although I DID manage to rename the routine from within the routine editor window. Any idea of the strategy to employ when xmeta gets corrupted like this?
PS. I have to say, in general, I'm seeing a lot of flakiness in the 9.1 client. Datasets also occasionally fail to display their tabs on their editors, for example.
Posted: Wed Mar 06, 2013 10:38 pm
by jhmckeever
FYI, I fixed this using the following process:
1. Create a new routine (or use an existing one) and compile it
2. Export it
3. Edit the exported file and replace all instances of the routine's name with the name of the corrupt routine you can't delete
4. Import the renamed routine
5. Locate the routine and delete it.
Hope this might help someone who encounters a similar problem
John.
Posted: Thu Mar 07, 2013 2:54 am
by ray.wurlod
Did you contact your official support provider with a view to getting the problem investigated and, perhaps, fixed?