"Error 80040E14" When Loading Data HFM is Unable to Create New Database Tables

(Doc ID 760573.1)

Last updated on APRIL 16, 2018

Applies to:

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


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" ?>
<Num HEX=0x80040E14>-2147217900</Num>
<Description Src=ADO>One or more errors occurred during processing of command.</Description>
<DTime>1/9/2009 2:36:12 PM</DTime>
<DStr>Incorrect syntax near the keyword 'PRIMARY'.</DStr>



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