Tipps zu PSP und Vault

PSP: Suche nach reservierten Dokumente erstellen

Unten die Anleitung, hier ein Video von mir dazu:

 

You have enabled resevered documents in Productstream Professional.

You want to search in Productstream for all reserved documents or documents reserved by yourself.

Solution

To do this follow these steps:

1. Create an extended search and run a PSP shell: read() #AIMKEY
   A pop up window occurs and in it there is the value of the AIMKEY.
   Note this AIMKEY
2. Start your SQL Server and run a query on your database:
   SELECT* FROM ELEMENT WHERE AIMKEY=[NotedAIMKEY]
3. On NotedAIMKEY put the AIMKEY which you noted from the shell before
4. On the results go to the NOTE Field and edit the field NOTES:

To get all reserved documents:
(  (CAST(RIGHTS AS int) % 256 ) >= 128 )

To get all documents reserved by the current user:
(  (CAST(RIGHTS AS int) % 256 ) >= 128 )  AND OWNER = '$USERID'

Now go to the extended search in Productstream and the result should be as you expected.

Searching for Reserved Documents in Productstream Professional

Performance Probleme bei der Migration von Productstream 2008/2009 auf Vault (W/C/P) 2011

We have identified a particular sequences of events that can cause major performance problems when migrating from Vault or Productstream 2008\2009 to a Paid-For version of Vault 2010 or 2011 (Paid-For = Vault Workgroup, Vault Collaboration or Vault Professional\Manufacturing)

In Vault\Productstream 2008\2009 you can manually merge properties and mark them as unused. These can be properties such as Design Accelerator\Frame generator properties. When they are migrated to Vault 2010 or Vault 2011 they are translated into User Defined Properties (UDP's). This is intentional

However, when the database is migrated to one of the Paid-For versions of Vault, those UDP's are assigned to the BASE Category. This then causes an immense load on the server. The only way to avoid this is to un-assign all UDP's, (indeed any other unnecessary {read, ALL} properties with high Usage counts) from the BASE category.

Performance issue...Read Carefully To Avoid Performance Degradation