Adding new Folders in a new Project impossible

[rmelzer]

Hello everybody,

I just set up a new project within DataStage Administrator and tried to import content from another project. Import fails with messages telling me that the folders I try to import the content to are missing. I then tried to create a folder manually and got the message:
'Unable to create new folder.

The Folder 'Jobs' is locked by user 'xmeta'
(SessionID 'xmeta-1')'

I tried to stop the DataStage Server and the repository database but the error recurs after restart.

I've never seen the error on any of the other three Projects we use. The new project is not a protected project.

Has anyone got an idea what might be the matter?

[chulett]

Something new with 8.x it seems, and I don't recall anyone ever posting this problem before. Involve your official support provider if no-one here has anything to add.

[rmelzer]

Something new with 8.x it seems, and I don't recall anyone ever posting this problem before. Involve your official support provider if no-one here has anything to add.

Hello chulett,

I'll do that, but experimenting with other search terms I just found another thread reporting exactly the same problem:

"Cannot Import Metadata into new project" by NSIT-DVP-01.

[chulett]

Link? Was there any resolution in the thread?

[deanwalker]

Count the rows in XMETALOCKINFO in the xmeta database, there has been an intermittent issue where all the items create when installing the product are left locked.

[rmelzer]

Link? Was there any resolution in the thread? ...

Hi Chulett,

Sorry: here the link:

viewtopic.php?t=115716&highlight=Cannot ... ew+project

The resolution proposed is to restart the Service of the WebSphere Application Server in Windows after creation of a new job. Problem is: Creation of a new job is impossible under AIX. New jobs cannot be saved because all categories are locked.

[rmelzer]

Link? Was there any resolution in the thread? ...

Hi Chulett,

Sorry: here the link:

viewtopic.php?t=115716&highlight=Cannot ... ew+project

The resolution proposed is to restart the Service of the WebSphere Application Server in Windows after creation of a new job. Problem is: Creation of a new job is impossible under AIX. New jobs cannot be saved because all categories are locked.

[rmelzer]

Count the rows in XMETALOCKINFO in the xmeta database, there has been an intermittent issue where all the items create when installing the product are left locked.

Hi Dean,

Punch! There are 1606 items locked by user XMETA.

Is it possible (and advisable) to solve the problem by deleting the rows from XMETALOCKINFO?

[deanwalker]

It is if nobody has logged on since the system started, or at least nobody is actively using the system.

[rmelzer]

It is if nobody has logged on since the system started, or at least nobody is actively using the system.

Hi Dean,

I also got a reply from DS Support now:

"Go to the default IS installation (/IBM/InformationServer/ASBServer/bin) directory and run the cleanup_abandoned_locks.sh script from a telnet session while logged in as root. Please make sure that all users are logged out before you do this.

$ ./cleanup_abandoned_locks.sh

Please enter the IS admin user and password when prompted. Once the process has completed, you will be returned to the UNIX command line and may not see any informational messages."

Running the Script solves the problem.

[bobyon]

Running the Script solves the problem.

Thank you DSXchange!

The script referenced previously solve my problem also.

I am now wondering how those locks got there in the first place and how to avoid them in the future.

Any Ideas?

Thanks,