8 Replies Latest reply: Oct 9, 2013 12:13 PM by HFM_Dev RSS

    Metadata load "unspecified error"

    Rodney P

      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"
          Thanos A

          Hi there,

           

          Can you check the log files for more details?

           

          Regards,

           

          Thanos

          • 2. Re: Metadata load "unspecified error"
            Rodney P

            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

              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"
                Thanos A

                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

                  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"
                    Thanos A

                    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

                      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

                        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