How do we delete a project we cannot see?DSR.ADMIN: An account called 'carlb04' already exists.
Brad.
Moderators: chulett, rschirm, roy
How do we delete a project we cannot see?DSR.ADMIN: An account called 'carlb04' already exists.
Brad.Failed to connect to host: edwdev2.wellsfargo.com, project: carlb04
( The directory you are connecting to either is not a UV account or does not exist (39125))
Code: Select all
DELETE UV.ACCOUNT carlb04;
Code: Select all
VERIFY.SQL carlb04;
Also, I tried to recreate the project in Administrator and am now getting this error:>VERIFY.SQL carlb04;
** Invalid VERIFY.SQL operation.
1 verify operation discontinued.
Items marked with a '!' are information messages only.
Items marked with a '*' can be fixed by using the FIX option to VERIFY.SQL.
Items marked with a '**' are situations where VERIFY.SQL could not continue.
So obviously, the scheam is still out there. What is my next step?DSR.ADMIN: A schema called 'carlb04' already exists. This must be dropped before the project can be created.
Code: Select all
>VERIFY.SQL SCHEMA carlb04
Checking permission.
* '/u001/dev/Ascential/DataStage/Projects/carlb04' is not a DataStage account.
* Data for the schema 'carlb04' should be deleted.
2 fixable errors found.
Items marked with a '!' are information messages only.
Items marked with a '*' can be fixed by using the FIX option to VERIFY.SQL.
Items marked with a '**' are situations where VERIFY.SQL could not continue.
And hey, I was able to recreate the project, too!>VERIFY.SQL SCHEMA carlb04 FIX
Checking permission.
* '/u001/dev/Ascential/DataStage/Projects/carlb04' is not a DataStage account.
* Deleting catalog data for schema 'carlb04'.
* Deleting table data for 'EXAMPLE1'.
* Deleting columns data for 'PRODUCT'.
* Deleting columns data for 'CODE'.
* Deleting columns data for 'QTY'.
* Deleting columns data for 'DATE'.
* Deleting ownership record for user 'dsadm' on table 'EXAMPLE1'.
2 errors fixed.
Items marked with a '!' are information messages only.
Items marked with a '*' have been fixed.
Items marked with a '**' are situations where VERIFY.SQL could not continue.