Troubleshooting
Problem
Our project directory was deleted and I want to recreate the same project from DataStage Administrator. But, when I enter the same name as the deleted project, I get the following error:
Error message is "DSA.ADMIN: An account called '
Resolving The Problem
Perform the following to delete the project. You can delete the project from the DS Administrator or on the Unix/Linux server. The instructions for both methods are provided below. Please note you need only perform one method (not both).
From DS Administrator:
- Log on to DS Administrator
- From the Projects tab, select the project
- Click on Command
- In the Command field, type the following command:
LIST UV.ACCOUNT project_name
if you can see the project_name type:
DELETE UV.ACCOUNT project_name
- Now, fix the schema by typing the following commands:
LIST UV_SCHEMA
if you see the project name type:
VERIFY.SQL SCHEMA
project_name FIX
- Check that you cannot see the project_name anymore:
LIST UV_SCHEMA
- If you still see the project then enter:
DROP SCHEMA project_name CASCADE; <== do not forget the semi colon (;)
From Unix/Linux server :
- Log onto DSEngine
- source the dsenv
. ./dsenv
- ./bin/uvsh
- LIST UV.ACCOUNT project_name
if you can see the project_name, type:
DELETE UV.ACCOUNT project_name
- Now, fix the schema by typing the following commands:
LIST UV_SCHEMA
if you see the project name type:
VERIFY.SQL SCHEMA
project_name FIX
- Check that you cannot see the project_name anymore:
LIST UV_SCHEMA
- If you still see the project then enter:
DROP SCHEMA project_name CASCADE; <== do not forget the semi colon (;)
Now, try creating the project.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21420136