1 of 1 people found this helpful
You can use the following command:
Or you can also delete from Repository Manager GUI..
Hi Yogesh ,
So first I need to connect to the repository and then run the above command ? Since this will be used one time to delete couple of folders (5 or 6) and ultimately this will go into PROD after testing in DEV/UAT/SIT Environments so how can i proceed with this.Also for deleting multiple folders we need to fire multiple commands :
pmrep deletefolder -n <folder_name>
List all the folders in a file, say fldrslist. Use the below command:
cat fldrslist | while read line; do pmrep deletefolder -n $line; done
This statement will delete all the folders which you have listed in the file.
To connect to the repository, use the below command:
pmrep connect -r <reponame> -d <Domain> -n <username> -x <password>
What OS are you working on?
I am working on SunOS
I am having trouble deleting a folder.....gives the below error:
[[REP_12014] An error occurred while accessing the repository Microsoft OLE DB Provider for SQ
L Server: The transaction log for database 'REPO' is full. To find out why space i
n the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
SQL State: 42000 Native Error: 9002
State: 4 Severity: 17
SQL Server Message: The transaction log for database 'REPO' is full. To find out why spa
ce in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
Database driver error...
Function Name : Execute
SQL Stmt : DELETE FROM OPB_EXTN_ATTR WHERE WORKFLOW_ID = 0 AND SESSION_INST_ID = 0 AND SESSION_I
D IN (SELECT TASK_ID FROM OPB_TASK WHERE TASK_TYPE = 68 AND SUBJECT_ID = ?)]
Failed to execute deletefolder.
Any idea how to resolve this error?
The issue is not with Informatica, rather the underlying database as per the error - "The transaction log for database 'REPO' is full". You will need to work with your DBA to resolve the issue of the full transaction log.
After I deleted a folder from a repository, I created a new folder again with the same name in the same repository.But workflows in it failed as it was pointing to the instance id of the earlier same named folder which i deleted. Why?
Does anyone know how to do this with Powershell?
Something like Powershell.exe -Command "cat fldrslist | while read line; do pmrep deletefolder -n $line; done"
Except that is not PowerShell syntax. I would like to do it in a .BAT script in Windows.