Knowledgebase: FDM
Giving "Data Access Error" and "ORA-00942: table or view does not exist", On Import Screen For Some Locations In FDM Application
Posted by Priya Doyle on 07 February 2011 12:11 PM

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.1
Information 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:
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.

References

FDM_11.1.1.3_DBA_guide.pdf



(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: