This discussion is archived
8 Replies Latest reply: Oct 9, 2013 10:13 AM by HFM_Dev RSS

Metadata load "unspecified error"

Rodney P Newbie
Currently Being Moderated

While trying to load metadata changes into our system, it seems that all the steps are completed successfully but once it gets to the last step we receive an unspecified error. We have been rebooting the HFM application server to resolve this issue, but there needs to be a more flexible solution as this impacts us heavily taking outages during our month end close periods. Does anyone have any insight as to why this error may be occurring or does anyone else experience this issue?

 

Thanks

 

11.1.2.2

1 HFM server

Windows Server 2008 R2

SQL Server 2008 R2

IE 8

  • 1. Re: Metadata load "unspecified error"
    thanasis_agr Pro
    Currently Being Moderated

    Hi there,

     

    Can you check the log files for more details?

     

    Regards,

     

    Thanos

  • 2. Re: Metadata load "unspecified error"
    Rodney P Newbie
    Currently Being Moderated

    The log files dont give much insight to the issue, here is what is noted:

     

    System Message Summary
    Unspecified error
    System Message Details
    Error Reference Number: {FCB67B06-A4EE-4DE0-8486-5A3479438EE5} Num: -2147467259; User: Type: 0; DTime: 10/1/2013 10:18:29 PM; Svr: GDCUSAP95; Application: THFMPROD
    File Error List
    File: DSCommonMetadataI.cpp Version: 11.1.2.2.000.3609 Line: 3593 Error: (-2147467259)(0x80004005)(Unspecified error)
    File: DSCommonMetadataTI.cpp Version: 11.1.2.2.000.3609 Line: 1000 Error: (-2147467259)(0x80004005)(Unspecified error)
    File: CHsvDsEti.cpp Version: 11.1.2.2.000.3609 Line: 490 Error: (-2147467259)(0x80004005)(Unspecified error)
    File: CHsvDSMLLoadXmlFormat.cpp Version: 11.1.2.2.000.3609 Line: 984 Error: (-2147467259)(0x80004005)(Unspecified error)
    File: CHsvDSMetadataLoad.cpp Version: 11.1.2.2.000.3609 Line: 1275 Error: (-2147467259)(0x80004005)(Unspecified error)
  • 3. Re: Metadata load "unspecified error"
    Rodney P Newbie
    Currently Being Moderated

    Here is the XML Error String:

     

    <?xml version="1.0" ?>
    <EStr>
        <Ref>{FCB67B06-A4EE-4DE0-8486-5A3479438EE5}</Ref>
        <User></User>
        <DBUpdate>107195400</DBUpdate>
        <ESec>
            <Num HEX=0x80004005>-2147467259</Num>
            <Description Src=HFM>Unspecified error</Description>
            <Type>1</Type>
            <DTime>10/1/2013 10:18:29 PM</DTime>
            <Svr>GDCUSAP95</Svr>
            <File>DSCommonMetadataI.cpp</File>
            <Line>3593</Line>
            <Ver>11.1.2.2.000.3609</Ver>
            <DStr></DStr>
            <ExErr>Rowset position cannot be restarted.</ExErr>
        </ESec>
        <ESec>
            <Num HEX=0x80004005>-2147467259</Num>
            <Description Src=HFM>Unspecified error</Description>
            <Type>0</Type>
            <DTime>10/1/2013 10:18:29 PM</DTime>
            <Svr>GDCUSAP95</Svr>
            <File>DSCommonMetadataTI.cpp</File>
            <Line>1000</Line>
            <Ver>11.1.2.2.000.3609</Ver>
            <DStr></DStr>
            <ExErr></ExErr>
        </ESec>
        <ESec>
            <Num HEX=0x80004005>-2147467259</Num>
            <Description Src=HFM>Unspecified error</Description>
            <Type>0</Type>
            <DTime>10/1/2013 10:18:29 PM</DTime>
            <Svr>GDCUSAP95</Svr>
            <File>CHsvDsEti.cpp</File>
            <Line>490</Line>
            <Ver>11.1.2.2.000.3609</Ver>
            <DStr></DStr>
            <ExErr></ExErr>
        </ESec>
        <ESec>
            <Num HEX=0x80004005>-2147467259</Num>
            <Description Src=HFM>Unspecified error</Description>
            <Type>0</Type>
            <DTime>10/1/2013 10:18:29 PM</DTime>
            <Svr>GDCUSAP95</Svr>
            <File>CHsvDSMLLoadXmlFormat.cpp</File>
            <Line>984</Line>
            <Ver>11.1.2.2.000.3609</Ver>
            <DStr></DStr>
            <ExErr></ExErr>
        </ESec>
        <ESec>
            <Num HEX=0x80004005>-2147467259</Num>
            <Description Src=HFM>Unspecified error</Description>
            <Type>0</Type>
            <DTime>10/1/2013 10:18:29 PM</DTime>
            <Svr>GDCUSAP95</Svr>
            <File>CHsvDSMetadataLoad.cpp</File>
            <Line>1275</Line>
            <Ver>11.1.2.2.000.3609</Ver>
            <DStr></DStr>
            <ExErr></ExErr>
        </ESec>
    </EStr>

  • 4. Re: Metadata load "unspecified error"
    thanasis_agr Pro
    Currently Being Moderated

    Hi Rodney,

     

    Based on a previous article or from Oracle support, this issue has been identified as a software defect and it has been logged as bug 13559985 (article 1461679.1). As a workaround is to terminate the HFM related Windows processes (HSvDataSource.exe,HsxServer.exe and CasSecurity.exe) and then load the metadata file again.

     

    Regards,

     

    Thanos

  • 5. Re: Metadata load "unspecified error"
    Rodney P Newbie
    Currently Being Moderated

    This article states that this is an issue for 11.1.2.1 and we are currently on 11.1.2.2, so this shouldn't apply.

  • 6. Re: Metadata load "unspecified error"
    thanasis_agr Pro
    Currently Being Moderated

    Hi Rodney,

     

    My first thought is whether you are on 11.1.2.2 after an upgrade of 11.1.2.1 or it was a fresh installation?

     

    I think the best approach is to create an SR on MySupport.

     

    Regards,

     

    Thanos

  • 7. Re: Metadata load "unspecified error"
    Madhu -Oracle Newbie
    Currently Being Moderated

    Hi

     

    These kind of errors occurs intermittently due some DB issues,Support will recommend you to do the same process (terminate the HFM related Windows processes (HSvDataSource.exe,HsxServer.exe and CasSecurity.exe) and then load the metadata file again.) if you raise a request with Oracle Support

     

    But I would recommend you to apply 300 patch on HFM 11.1.2.2. to avoid all kind of intermittent issues as we have seen couple of issues resolved on 300 patch.

     

    Regards,

    Madhu Dodda.

  • 8. Re: Metadata load "unspecified error"
    HFM_Dev Newbie
    Currently Being Moderated

    Hi,

     

    Please check below lines in your metadata. whether you have used the same delimiter character for metadata properties separator and the same delimiter character for description also??

    If you have used semicolon(;) as metadata separator then you should not use the same delimiter character anywhere else in your metadata file.


    Example:

    If you have used comma(,) as metadata separator then you should not use the same delimiter comma(,) for description separator.


    Open metadata in .app format to find the solution.

    Line: 3593

    Line: 1000

    Line: 490

    Line: 984

    Line: 1275

     

    Regards

    Dev

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points