Cannot delete routine

[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.

[ray.wurlod]

Something internal fouled up in generating the query against XMETA?

Can you drag the routine to a different folder?

[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.

[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.

[ray.wurlod]

Did you contact your official support provider with a view to getting the problem investigated and, perhaps, fixed?