DEPLOY

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

STATUS

NUMBER

Yes

STARTDATE

DATE

Yes

ENDDATE

DATE

No

PARTIALDEPLOY

NUMBER(1)

No

SEQUENCENUMBER

NUMBER

F

No

BUILDOID

NUMBER

F

No

DEPLOYENVIRONMENTOID

NUMBER

F

No

LEVELREQUESTOID

NUMBER

F

No

PROPERTYLOGOID

NUMBER

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: DEPLOY_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

STATUS

The Deploy Status indication. This Status indication is derived from the status of the different Deploy Phases.

Possible status indications are:

Wait : The Deploy is waiting to be started.

In progress : The Deploy is ready to be started.

Run : The Deploy is currently being executed.

Success : The Deploy has finished successfully.

Warning : The Deploy has finished successfully, but there were some non-critical errors.

Fail : The Deploy has failed.

Canceled : The Deploy was canceled before it was executed.

Aborted : The Deploy was aborted while it was being executed.

Rejected : The Deploy was rejected.

Key NULL Column Type (Size)

No

STATUS

NUMBER

Value List

0 = Unknown

1 = Canceled

2 = Rejected

3 = Wait

4 = In progress

5 = Run

6 = Fail

7 = Success

8 = Warning

9 = Aborted

STARTDATE

This field indicates the date and time at which the Deploy execution started.

Key NULL Column Type (Size)

Yes

STARTDATE

DATE

ENDDATE

This field indicates the date and time at which the Deploy execution ended.

Key NULL Column Type (Size)

Yes

ENDDATE

DATE

PARTIALDEPLOY

Indication whether the Partial Deploy option is activated or not for this Deploy Environment.

If the option is activated, IKAN ALM will analyze the differences between the two build results on the IKAN ALM Server and only new and modified files will be transported to the Agent.

This is achieved as follows:

Both the newly compiled Build result and the base-line Build (the one the new Build results are compared with) are decompressed (unzipped).

The decompressed files are compared and the following actions are taken:

  • Identical files are deleted and not deployed.

  • Modified and new files (available in the new but not in the base-line

Build results) are transported.

  • For deleted files (available in the base-line Build result, but not in the new one), dummy files with names in the format FileName. to_be_deleted are created. The Deploy Script must be written in such a way, that it deletes the matching files from the Deploy Environment’s Source Location.

Key NULL Column Type (Size)

No

PARTIALDEPLOY

NUMBER(1)

Value List

0 = no

1 = yes

SEQUENCENUMBER

The Sequence Number of the Deploy.

Deploys are executed sequentially in the order of their Sequence Number. Deploys that have the same Sequence Number are executed in parallel.

Key NULL Column Type (Size)

No

SEQUENCENUMBER

NUMBER

BUILDOID

Identifier for the BUILD table.

For more information, refer to the description of the foreign key DEPLOY_FK_1.

See also: DEPLOY_FK_1.

Key NULL Column Type (Size)

F

No

BUILDOID

NUMBER

DEPLOYENVIRONMENTOID

Identifier for the DEPLOYENVIRONMENT table.

For more information, refer to the description of the foreign key DEPLOY_FK_2.

See also: DEPLOY_FK_2.

Key NULL Column Type (Size)

F

No

DEPLOYENVIRONMENTOID

NUMBER

LEVELREQUESTOID

Identifier for the LEVELREQUEST table.

For more information, refer to the description of the foreign key DEPLOY_FK_3.

See also: DEPLOY_FK_3.

Key NULL Column Type (Size)

F

No

LEVELREQUESTOID

NUMBER

PROPERTYLOGOID

Identifier for the PROPERTYLOG table.

For more information, refer to the description of the foreign key DEPLOY_FK_4.

See also: DEPLOY_FK_4.

Key NULL Column Type (Size)

F

No

PROPERTYLOGOID

NUMBER

ARCHIVED

For internal use only.

Key NULL Column Type (Size)

Yes

ARCHIVED

NUMBER(1)

Value List

0 = no

1 = yes

ARCHIVEDDATETIME

For internal use only.

Key NULL Column Type (Size)

Yes

ARCHIVEDDATETIME

DATE

VERSION

For internal use only.

Key NULL Column Type (Size)

No

VERSION

NUMBER

Indexes

Index Primary Unique Column(s) Source Table

DEPLOY_PK

Yes

Yes

OID

DEPLOY_FK_1

No

No

BUILDOID

BUILD

DEPLOY_FK_2

No

No

DEPLOYENVIRONMENTOID

DEPLOYENVIRONMENT

DEPLOY_FK_3

No

No

LEVELREQUESTOID

LEVELREQUEST

DEPLOY_FK_4

No

No

PROPERTYLOGOID

PROPERTYLOG

Relationships

Referenced Tables

BUILD

Refer to the chapter BUILD for a detailed description of the table.

Foreign Key Referenced Column(s)

DEPLOY_FK_1

OID

DEPLOYENVIRONMENT

Refer to the chapter DEPLOYENVIRONMENT for a detailed description of the table.

Foreign Key Referenced Column(s)

DEPLOY_FK_2

OID

LEVELREQUEST

Refer to the chapter LEVELREQUEST for a detailed description of the table.

Foreign Key Referenced Column(s)

DEPLOY_FK_3

OID

PROPERTYLOG

Refer to the chapter PROPERTYLOG for a detailed description of the table.

Foreign Key Referenced Column(s)

DEPLOY_FK_4

OID

Referencing Tables

DEPLOYLOG

Refer to the chapter DEPLOYLOG for a detailed description of the table.

Foreign Key Referencing Column

DEPLOYLOG_FK_1

DEPLOYOID

Report Labels

DEPLOY_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

DEPLOY_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

DEPLOY_BUILDOID_LABEL

English:

OID

French:

OID

German:

OID

DEPLOY_DEPLOYENVIRONMENTOID_LABEL

English:

OID

French:

OID

German:

OID

DEPLOY_ENDDATE_LABEL

English:

End Date/Time

French:

Fin d’exécution

German:

Ausführungsende

DEPLOY_LEVELREQUESTOID_LABEL

English:

OID

French:

OID

German:

OID

DEPLOY_OID_LABEL

English:

OID

French:

OID

German:

OID

DEPLOY_PARTIALDEPLOY_LABEL

English:

Partial Deploy

French:

Déploiement partiel

German:

Partielle Auslieferung

DEPLOY_PROPERTYLOGOID_LABEL

English:

OID

French:

OID

German:

OID

DEPLOY_SEQUENCENUMBER_LABEL

English:

Sequence Number

French:

Numéro de séquence

German:

Sequenznummer

DEPLOY_STARTDATE_LABEL

English:

Start Date/Time

French:

Début d’exécution

German:

Ausführungsbeginn

DEPLOY_STATUS_LABEL

English:

Status

French:

Statut

German:

Status

DEPLOY_VERSION_LABEL

English:

Version

French:

Version

German:

Version