| Giving "Data Access Error" and "ORA-00942: table or view does not exist", On Import Screen For Some Locations In FDM Application | |||||
|
|
|||||
| Modified 31-AUG-2010 | |||||
Applies to:
Hyperion Financial Data Quality Management - Version: 9.3.1.0.00 to 11.1.2.0.00 - Release: 9.3 to 11.1Information in this document applies to any platform.
Symptoms
On the import screen for some locations when importing a file the process fails with the error "Data access error".Choosing Tools > View Error Log displays the following error:
Description...................................... ORA-00942: table or view does not exist
SELECT CatKey AS DCount From tDataSegxxWhere (((PartitionKey) = 816) AND ((CatKey) = 12) AND (TO_CHAR(PeriodKey,N'YYYYMMDD') Between N'20100831' And N'20100831') AND ((CalcAcctType) Between -1000 and 1000) And (ROWNUM <= 1))
Procedure........................................ clsDataAccess.farsFireHose
Component........................................ upsWDataWindowDM
ERROR:
Description...................................... Data access error.
Procedure........................................ clsSQLMgr.fTrialBalanceCheck
Component........................................ upsWObjectsDM
Cause
The "Total No. of Data Segments" configuration setting has been updated from the default value of 50 to 100. After adjusting this value the "Tools > Manage Data Segments > Create New Segments" command must be ran. Currently the command has not been ran. The application beleives that there is a total number of 100 data segments, but only 50 exist in the application database schema.
When the FDM application reaches location 51 it will attempt to and use tdataseg51 which does not exists resulting in the error:
"ORA-00942: table or view does not exist".
Solution
A) Choose Tools > Manage Data Segments > Create New Segments
B) Set the value to 100 and choose "save and close"
C) You will be prompted to increase the number of data segments and click OK and this will create the additional data segment tables.
D) Click OK to the success message indicating how many data segments were added.
GKontos
Comments