DEPLOYLOG

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

PHASE

NUMBER

No

PHASENAME

VARCHAR2(255)

Yes

PHASEVERSION

VARCHAR2(50)

No

STATUS

NUMBER

Yes

MESSAGE

CLOB

Yes

STACKTRACE

CLOB

Yes

ALMLOG

CLOB

F

No

DEPLOYOID

NUMBER

F

No

LOGFORMATOID

NUMBER

Yes

PROPERTYLOGOID

NUMBER

Yes

STARTDATETIME

DATE

Yes

ENDDATETIME

DATE

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: DEPLOYLOG_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

PHASE

The sequence number of the Deploy Phase.

Key NULL Column Type (Size)

No

PHASE

NUMBER

PHASENAME

The name of the Deploy Phase at the moment the logging took place. This name defines at the same time the function of the Phase.

Key NULL Column Type (Size)

No

PHASENAME

VARCHAR2(255)

PHASEVERSION

The version of the Deploy Phase at the moment the logging was done.

Key NULL Column Type (Size)

Yes

PHASEVERSION

VARCHAR2(50)

STATUS

The status of the Deploy Phase.

Key NULL Column Type (Size)

No

STATUS

NUMBER
Value List

-1 = Not executed

0 = Success

1 = Warning

2 = Fail

3 = Run

4 = Aborted

MESSAGE

The log of the Phase.

Key NULL Column Type (Size)

Yes

MESSAGE

CLOB

STACKTRACE

In case the Phase encountered an error, this field contains the complete Stack Trace generated by the failed Phase.

Key NULL Column Type (Size)

Yes

STACKTRACE

CLOB

ALMLOG

The actual Deploy Log generated by the Deploy tool using the format defined by the LOGFORMATOID.

Key NULL Column Type (Size)

Yes

ALMLOG

CLOB

DEPLOYOID

Identifier for the DEPLOY table at the moment the log item was created.

See also: DEPLOYLOG_FK_1.

Key NULL Column Type (Size)

F

No

DEPLOYOID

NUMBER

LOGFORMATOID

Internal identifier of the object.

See also: DEPLOYLOG_FK_2.

Key NULL Column Type (Size)

F

No

LOGFORMATOID

NUMBER

PROPERTYLOGOID

Internal identifier of the object.

Key NULL Column Type (Size)

Yes

PROPERTYLOGOID

NUMBER

STARTDATETIME

The date and time at which the Deploy Phase execution was started.

Key NULL Column Type (Size)

Yes

STARTDATETIME

DATE

ENDDATETIME

The date and time at which the Deploy Phase execution ended.

Key NULL Column Type (Size)

Yes

ENDDATETIME

DATE

ARCHIVED

For internal use only.

Key NULL Column Type (Size)

Yes

ARCHIVED

NUMBER(1)

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

DEPLOYLOG_PK

Yes

Yes

OID

DEPLOYLOG_FK_1

No

No

DEPLOYOID

DEPLOY

DEPLOYLOG_FK_2

No

No

LOGFORMATOID

LOGFORMAT

Relationships

Referenced Tables

DEPLOY

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

Foreign Key Referenced Column(s)

DEPLOYLOG_FK_1

OID
LOGFORMAT

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

Foreign Key Referenced Column(s)

DEPLOYLOG_FK_2

OID

Referencing Tables

No referencing tables available.

Report Labels

DEPLOYLOG_ALMLOG_LABEL

English:

ALM Log

French:

Journal ALM

German:

ALM Protokoll

DEPLOYLOG_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

DEPLOYLOG_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

DEPLOYLOG_DEPLOYOID_LABEL

English:

OID

French:

OID

German:

OID

DEPLOYLOG_ENDDATETIME_LABEL

English:

End Date/Time

French:

Fin d’exécution

German:

Ausführungsende

DEPLOYLOG_LOGFORMATOID_LABEL

English:

Log Format OID

French:

OID Format du Journal

German:

Protokollformat OID

DEPLOYLOG_MESSAGE_LABEL

English:

Log

French:

Trace

German:

Protokoll

DEPLOYLOG_OID_LABEL

English:

OID

French:

OID

German:

OID

DEPLOYLOG_PHASE_LABEL

English:

Phase

French:

Phase

German:

Phase

DEPLOYLOG_PHASENAME_LABEL

English:

Phase Name

French:

Nom de Phase

German:

Name der Phase

DEPLOYLOG_PHASEVERSION_LABEL

English:

Phase Version

French:

Version de la Phase

German:

Phasenversion

DEPLOYLOG_PROPERTYLOGOID_LABEL

English:

Property Log OID

French:

OID du Journal des propriétés

German:

Eigenschaftenprotokoll OID

DEPLOYLOG_STACKTRACE_LABEL

English:

Stack Trace

French:

Trace de pile

German:

Stack-Trace

DEPLOYLOG_STARTDATETIME_LABEL

English:

Start Date/Time

French:

Début d’exécution

German:

Ausführungsbeginn

DEPLOYLOG_STATUS_LABEL

English:

Status

French:

Statut

German:

Status

DEPLOYLOG_VERSION_LABEL

English:

Version

French:

Version

German:

Version