"Error 80040E14" When Loading Data HFM is Unable to Create New Database Tables (Doc ID 760573.1)

Last updated on AUGUST 08, 2016

Applies to:

Hyperion Financial Management - Version 4.0.2.1.00 to 11.1.2.0.00 [Release 4.0 to 11.1]
Information in this document applies to any platform.

Symptoms

An HFM Windows client user cannot browse to new scenario/year combinations - it was noticed that the necessary new data tables are not being created by HFM in its repository database

When trying to load data from a load file, the error message 80040E14 was displayed.

The HsvEventLog.log file shows error messages in the CHsxSQLHelperTableDefinition.cpp file.

An example message from the HsvEventLog.log file is...

 

<?xml version="1.0" ?>
<EStr>
<Ref>{278811E7-90A7-477A-B192-EA6D9443D485}</Ref>
<User></User>
<DBUpdate>80104808</DBUpdate>
<ESec>
<Num HEX=0x80040E14>-2147217900</Num>
<Description Src=ADO>One or more errors occurred during processing of command.</Description>
<Type>1</Type>
<DTime>1/9/2009 2:36:12 PM</DTime>
<Svr>LSHPFM203</Svr>
<File>CHsxSQLHelperTableDefinition.cpp</File>
<Line>2451</Line>
<Ver>4.0.2.0.967</Ver>
<DStr>Incorrect syntax near the keyword 'PRIMARY'.</DStr>
<ExErr></ExErr>
<PSec>
<Param>TEST_DCT_4_2009</Param>
</PSec>
</ESec>
</EStr>

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms