Troubleshooting
Problem
User sees ORA-904 database error after installing MCSF v8.5 HF3.
Symptom
This error is thrown when a user tries to create a new Organization from the Sterling Application Manager by hitting the '+' icon.
Error Message
<Errors>
<Error
ErrorCode="ORA-904"
ErrorRelatedMoreInfo="">
<Attribute Name="ErrorCode" Value="ORA-904"/>
<Attribute Name="ErrorDescription" Value="ORA-00904:
<Attribute
Name="SQLState" Value="42000"/>
<Attribute
Name="TransactionIsolationLevel" Value="2"/>
Resolving The Problem
In 8.5 HF3, the PLT_DB_COLONY table now has a new STATUS column
added. The HF installation is incomplete and that is the reason this column is
missing from PLT_DB_COLONY table.
Please rerun
the HF installation and make sure that the STATUS column exists in the
PLT_DB_COLONY table.
Historical Number
NFX8613
Product Synonym
[<p><b>]Severity[</b><p>];Normal;[<p><b>]Type[</b><p>];NormalFix
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21555224