こんにちはHabr！
すべてのHPアプリケーションライフサイクル管理（ALM）管理者は、遅かれ早かれ、HP ALMの新しいバージョンにアップグレードする必要があります。 このプロセスの大部分は、HP ALMプロジェクトの移行です。 多くの場合、これはかなり簡単な作業ですが、時々、さらに明確にする必要がある瞬間があります。
この記事では、バックアップおよびその後の更新からHP ALMプロジェクトを復元するためのいくつかのシナリオについて説明します。
そこで、あなたの会社はHP ALMの新しいバージョンにアップグレードすることを決めました。 幸福感が過ぎた後、計画を開始します。 最初に理解する必要があります。新しいバージョンに直接アップグレードできますか。 現在、HP ALMは次の原則に基づいた直接更新をサポートしています。
| v。 11.00 | v。 11.5倍 | v。 12.0x | v。 12.2x | |
| v。 10.x | + | + | ||
| v。 11.00 | + | + | + | |
| v。 11.5倍 | + | + | ||
| v。 12.0x | + |
たとえばv.10.xxからv.12.0xへの別の移行を計画している場合、これも可能です。 これを行うには、以下で説明するすべてを行う必要がありますが、中間バージョンv.10.xx-> 11.5x-> 12.0xへのアップグレードが必要です。 したがって、移行には少し時間がかかります。
次の手順では、使用中のデータベースサーバーのバージョンがHP ALMの新しいバージョンでサポートされていることを確認します。 この情報は、HP WebサイトのHP QC / ALMセクションで簡単に見つけることができます。 データベースサーバーのバージョンが互換性のあるもののリストにあり、新しいバージョンにアップグレードする予定がない場合（後で逆のケースを検討します）、直接更新に進みます。
アップグレードを成功させるには、プロジェクトの一貫した更新を伴うスムーズな移行をお勧めします。 アクティブなプロジェクトが多数ある場合、予期しない状況が発生した場合に安全にプレイする必要があります。 製品のインストールの一部としてすべてのプロジェクトを更新するという急激な移行により、会社全体が機能しなくなる可能性があります。
最初のステップは、官僚的な手順を実行して、新しいサーバーマシンのリソースを取得することです。
次に、HP ALMのインストールに進みます。いつものように、いくつかのオプションがあります。
- 製品全体とプロジェクトのデータベースを更新する
- 新規製品ベースでのクリーンインストール、およびそれに続くプロジェクトの移行と更新
どちらの場合も、たとえば製品データベースを更新すると、すべてのプロジェクトと設定が新しいサーバーに表示されるため、微妙な違いがあります。したがって、すべてのプロジェクトのバックアップを事前に行う必要があります。 2番目の場合、設定と、最も重要なことには、パスワードは新しいサーバーに表示されません。 私はLDAP認証のファンなので、私を怖がらせません。 また、データベース管理者と話をすることもできます-彼は、新しいサーバーにパスワードを転送する方法を見つけます。
スムーズな移行を計画している場合は、クリーンインストールをお勧めしますが、いつものように、次の点に注意してください。生活を楽にするために、同じファイルストレージパス、パスワード、および接続文字列（英語の接続文字列）以前のバージョンで使用されていましたが、「生産的」をフックしないように注意してください。 プロジェクトファイルストレージについては、まだ使用していない場合はネットワークストレージに切り替えることをお勧めします。
次のステップは、新しいバージョンに移行するプロジェクトを選択することです。 移行は、管理サイトで選択したプロジェクトを無効にすることから始めます。 バージョン管理を使用する場合は、すべてのエンティティをチェックイン（返却）する必要があることに注意してください。 次に、データベースサーバー管理者とプロジェクトファイルストレージのコピーを使用して、プロジェクトデータベースのコピーを作成します。
準備はほぼ整っていますが、MS SQLを使用している場合は、プロジェクトデータベースのコピーに対して、 行ごとに次のスクリプトを実行する必要があります。
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
これにより、製品で使用されるデータベースユーザーが復元されたデータベースを使用できるようになります。
次に、プロジェクトのファイルストレージを操作します。 HP ALMサーバーがプロジェクトの詳細を見つけるために使用するファイルを編集する必要があります。 このファイルはdbid.xmlと呼ばれ、パス上にあります。
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
> ...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM ...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM ...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM ...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM ...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
-
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM
...\<repository_location>\\<project_repository_location>
<?xml version="1.0" encoding="UTF-8"?> <ProjectDescription> <PROJECT_NAME>__</PROJECT_NAME> <DB_TYPE>_Oracle___3__MS_SQL__2</DB_TYPE> <DESCRIPTION>___</DESCRIPTION> <DB_CONNSTR_FORMAT>connection_string__________</DB_CONNSTR_FORMAT> <DB_NAME>___</DB_NAME> <DBSERVER_NAME>____________</DBSERVER_NAME> <DB_USER_PASS>_________</DB_USER_PASS> <PR_HAS_VCSDB>______N/Y</PR_HAS_VCSDB> <PHYSICAL_DIRECTORY>____</PHYSICAL_DIRECTORY> <USERS_QUOTA>__</USERS_QUOTA> <PR_IS_ACTIVE>__</PR_IS_ACTIVE> <SAQ_IS_ACTIVE>__</SAQ_IS_ACTIVE> <VM_REPOSITORY /> <PR_LANGUAGE>__</PR_LANGUAGE> <PROJECT_TYPE>__</PROJECT_TYPE> <IS_TEMPLATE>__</IS_TEMPLATE> </ProjectDescription>
* DB_USER_PASS – , , TXT:___
(. onnection string), . , HP ALM .
– dbid.xml. , .
HP ALM. HP ALM.
- :
dbid.xml , /
. , . , .
:
Maintain Project Verification Repair Upgrade
, Upgrade, , , , , . , .
, , .
. – . - , HP ALM :
, . , .
, (Repair Project). , HP ALM.
, ( ) , . . , - . , , Exception .
HP Exception .
( , HP ALM) . , , Exception . :
Exception :
Exception , : tables, views, triggers, columns.
:
<?xml version="1.0" encoding="UTF-8"?> <QC_EXCEPTIONS> <exceptions> <!-- ignore extra column <ColumnMissing> <object pattern="<col name pattern>" type="extra"/> </ColumnMissing> --> <!-- ignore extra table <TableMissing> <object pattern="<table name pattern>" type="extra"/> </TableMissing> --> <!-- ignore extra view <ViewMissing> <object pattern="<view name pattern>" type="extra"/> </ViewMissing> --> </exceptions> </QC_EXCEPTIONS>
-,
.xml
.
, , (, , ) (, HP ALM ).
, . , :
MS SQL
, HP ALM ( ), . , td , :
USE [master] GO CREATE LOGIN [td] WITH PASSWORD=N'tdtdtd', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO
.
EXEC sp_change_users_login 'Report' EXEC sp_change_users_login 'Update_One', 'td', 'td' EXEC sp_changedbowner 'sa'
Oracle
, HP ALM
GRANT "CONNECT" GRANT CREATE SESSION GRANT CREATE SEQUENCE GRANT CREATE TABLE GRANT CREATE TRIGGER GRANT UNLIMITED TABLESPACE GRANT CREATE VIEW GRANT CREATE PROCEDURE GRANT "CTXAPP" ALTER USER DEFAULT ROLE ALL;
, HP ALM
.
-
, ALM . . . , ALM. , . Workflow ALM HP , . .
Tips and Tricks
LDAP , ( ), LDAP? LAB_PROJECT -, . , , , , . , .
: , HP ALM