Troubleshooting
Problem
Error::ORA-942:: while running factory setup.
Symptom
Sometimes a user might face the following error while running Factory Setup.
Error Message[java] 2010-07-29 07:27:57,487:ERRORDTL:main: [1280402877481]
[java] <Errors>
[java]
<Error ErrorCode="ORA-942"</div> <div>[java] ErrorDescription="ORA-00942: table
or view does not exist
" ErrorRelatedMoreInfo="">
[java]
<Attribute Name="ErrorCode" Value="ORA-942"/>
[java] <Attribute
Name="ErrorDescription" Value="ORA-00942: table or view does not
exist
"/>
[java] <Attribute Name="SQLState"
Value="42000"/>
[java] <Attribute Name="TransactionIsolationLevel"
Value="2"/>
[java] <Attribute Name="SQLStatement" Value=" SELECT
/*YANTRA*/ YFS_LOCALE.* FROM YFS_LOCALE YFS_LOCALE "/>
[java]
<Attribute Name="DBErrorCode" Value="942"/>
[java] <Error
ErrorCode="java.sql.SQLSyntaxErrorException"</div> <div>[java]
ErrorDescription="" ErrorRelatedMoreInfo="ORA-00942: table or view does not
exist
">
[java] <Stack>java.sql.SQLSyntaxErrorException:
ORA-00942: table or view does not exist
[java] at
oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)</div
>
[java] at
oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
[java] at
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
[java]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
Resolving The Problem
Resolution:- User might face this issue during a fresh installation and the root cause is that a table or view might be missing in the database. Follow these steps to get rid of the error
1) Run the dbverify.
It wil generate the SQL script for database at <Install_dir>\bin folder
2) Execute the auto generated SQL script on database
3)
Finally run the factory setup again.
[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Historical Number
NFX9620
Product Synonym
[<p><b>]Severity[</b><p>];Normal
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21557351