8 Replies Latest reply: Oct 31, 2013 3:16 PM by 955124 RSS

    Task Audit Export error An unknown error has occurred in the HSVsysteminfo object

    951367

      When exporting HFM App's Task Audit Data to excel for specific date, Getting the following error "An unknown error has occurred in the HSVsysteminfo object" and others are working good and no error's when view same in HFM

       

      Could some one please provide your inputs on this?


      Thanks,

      RSV

        • 1. Re: Task Audit Export error An unknown error has occurred in the HSVsysteminfo object
          Thanos A

          Hi RSV,

           

          Have you tried to extract the data via the Data audit utility from Consultants Utilities menu?

           

          Regards,

           

          Thanos

          One Truth about...: ..calculation options

          • 2. Re: Task Audit Export error An unknown error has occurred in the HSVsysteminfo object
            951367

            Hi Thanos,

             

            THanks for the reply!

             

            > Using utility I can export the Task & Data Audit data and no issues with this.

            > We can able to see the Task & Data Audit data in workspaceand it's working good, But when exporting to excel that to for particular date, it's throwing the error

             

            Thanks,

            RSV

            • 3. Re: Task Audit Export error An unknown error has occurred in the HSVsysteminfo object
              Thanos A

              Hi RSV,

               

              I had this error in the past.

               

              As far as I remember the issue was related with the number of entries at the log file the specific day.

               

              Regards,

               

              Thanos

              • 4. Re: Task Audit Export error An unknown error has occurred in the HSVsysteminfo object
                951367

                Once again Thanks Thanos!

                 

                You mean that If no of entries is maximum for specific day Then it will getting issue.

                 

                If so, Could you please suggest your inputs, to resolve this issue?

                 

                Thanks,

                RSV

                • 5. Re: Task Audit Export error An unknown error has occurred in the HSVsysteminfo object
                  Thanos A

                  Hi RSV,

                   

                  In order to solve the issue, we got a backup of the <APPNAME>_DATA_AUDIT and  <APPNAME>_TASK_AUDIT tables and then truncate the tables.

                   

                  After that case, we set a maintenance task to truncate these tables once per month. Based on Oracle the size of these table affects the performance of the application (500000 is the suggested limit I think).

                   

                  Regards,

                   

                  Thanos

                  One Truth about...: ..calculation options

                  • 6. Re: Task Audit Export error An unknown error has occurred in the HSVsysteminfo object
                    951367

                    Let me give you clear details reg this issue.

                     

                    we have 3 HFM servers like Server1, Server2 & Server3

                    • Server1: By selecting this server and can able to view & extract Task Audit data perfectly for specific and for all dates also -->using Workspace & Utility
                    • Server2: By selecting this server and can able to view & extract Task Audit data perfectly for specific and for all dates also --> Using Workspace & Utility
                    • Server3: By selecting this server and can't able to view & extract Task Audit data for specific and for all dates---> Using workspace not working & using utility working good.

                     

                    Below is the HSVEventLog for server3:

                     

                    Error*11*loginID*09/16/2013 03:21:54*CHsvSystemInfo.cpp*Line 3370*<?xml version="1.0"?>
                    <EStr><Ref>{A4ADF8A6-4852-45B3-8088-75B3B909F388}</Ref><AppName>AppName</AppName><User/><DBUpdate>1</DBUpdate><ESec><Num>-2147207040</Num><Type>0</Type><DTime>09/16/2013 3:21:54 AM</DTime><Svr>Server3</Svr><File>CHsvSystemInfo.cpp</File><Line>3370</Line><Ver>11.1.2.1.104.3701</Ver></ESec></EStr>
                    *
                    Error*11*loginID*09/16/2013 03:21:54**Line 0*<?xml version="1.0"?>
                    <EStr><Ref>{A4ADF8A6-4852-45B3-8088-75B3B909F388}</Ref><AppName>AppName</AppName><User>admin@Native Directory</User><DBUpdate>1</DBUpdate><ESec><Num>-2147207040</Num><Type>0</Type><DTime>09/16/2013 3:21:54 AM</DTime><Svr>Server3</Svr><File>CHsvSystemInfo.cpp</File><Line>3370</Line><Ver>11.1.2.1.104.3701</Ver></ESec><ESec><Num>-2147207040</Num><Type>1</Type><DTime>09/16/2013 3:21:54 AM</DTime><Svr>USCTAPP40612</Svr><File>CHsvAuditExtract.cpp</File><Line>328</Line><Ver>11.1.2.1.104.3701</Ver></ESec></EStr>
                    *
                    Error*11*loginID*09/16/2013 03:23:53*SystemInfoUsersActivities.cpp*Line 3331*<?xml version="1.0"?>
                    <EStr><Ref>{5D628CC6-0808-4307-AF70-7C7A499F98D9}</Ref><AppName>AppName</AppName><User/><DBUpdate>1</DBUpdate><ESec><Num>-2147207040</Num><Type>1</Type><DTime>09/16/2013 3:23:53 AM</DTime><Svr>Server3</Svr><File>SystemInfoUsersActivities.cpp</File><Line>3331</Line><Ver>11.1.2.1.104.3701</Ver></ESec></EStr>
                    *
                    Error*11*loginID*09/16/2013 03:23:54*SystemInfoUsersActivities.cpp*Line 2161*<?xml version="1.0"?>
                    <EStr><Ref>{5D628CC6-0808-4307-AF70-7C7A499F98D9}</Ref><AppName>AppName</AppName><User/><DBUpdate>1</DBUpdate><ESec><Num>-2147207040</Num><Type>1</Type><DTime>09/16/2013 3:23:53 AM</DTime><Svr>Server3</Svr><File>SystemInfoUsersActivities.cpp</File><Line>3331</Line><Ver>11.1.2.1.104.3701</Ver></ESec><ESec><Num>-2147207040</Num><Type>0</Type><DTime>09/16/2013 3:23:53 AM</DTime><Svr>Server3</Svr><File>SystemInfoUsersActivities.cpp</File><Line>2161</Line><Ver>11.1.2.1.104.3701</Ver></ESec></EStr>
                    *
                    Error*11*loginID*09/16/2013 03:23:54*CHsvSystemInfo.cpp*Line 3370*<?xml version="1.0"?>
                    <EStr><Ref>{3B4F0C43-81B8-416B-95E3-67BB6C8C73D9}</Ref><AppName>AppName</AppName><User/><DBUpdate>1</DBUpdate><ESec><Num>-2147207040</Num><Type>0</Type><DTime>09/16/2013 3:23:54 AM</DTime><Svr>Server3</Svr><File>CHsvSystemInfo.cpp</File><Line>3370</Line><Ver>11.1.2.1.104.3701</Ver></ESec></EStr>
                    *
                    Error*11*loginID*09/16/2013 03:23:54**Line 0*<?xml version="1.0"?>
                    <EStr><Ref>{3B4F0C43-81B8-416B-95E3-67BB6C8C73D9}</Ref><AppName>AppName</AppName><User>admin@Native Directory</User><DBUpdate>1</DBUpdate><ESec><Num>-2147207040</Num><Type>0</Type><DTime>09/16/2013 3:23:54 AM</DTime><Svr>Server3</Svr><File>CHsvSystemInfo.cpp</File><Line>3370</Line><Ver>11.1.2.1.104.3701</Ver></ESec><ESec><Num>-2147207040</Num><Type>1</Type><DTime>09/16/2013 3:23:54 AM</DTime><Svr>USCTAPP40612</Svr><File>CHsvAuditExtract.cpp</File><Line>328</Line><Ver>11.1.2.1.104.3701</Ver></ESec></EStr>
                    *
                    Information*11*loginID*09/16/2013 03:26:58*CHsvDSSystemInfo.cpp*Line 7652*SYSINFO: Application=PTEST; NumUsers=0; UsedPhysicalMem=4876603392; UsedVirtualMem=709824512; PID=8224*
                    Information*11*loginID*09/16/2013 03:26:58*CHsvDSSystemInfo.cpp*Line 7652*<?xml version="1.0"?>
                    <EStr><Ref>{A00091E6-2696-43D1-9098-82599DC5B209}</Ref><AppName>PTEST</AppName><User/><DBUpdate>1</DBUpdate><ESec><Num>0</Num><Type>1</Type><DTime>09/16/2013 3:26:58 AM</DTime><Svr>Server3</Svr><File>CHsvDSSystemInfo.cpp</File><Line>7652</Line><Ver>11.1.2.1.104.3701</Ver><DStr>SYSINFO: Application=PTEST; NumUsers=0; UsedPhysicalMem=4876603392; UsedVirtualMem=709824512; PID=8224</DStr></ESec></EStr>
                    *
                    Information*11*loginID*09/16/2013 03:28:16*CHsvDSSystemInfo.cpp*Line 7652*SYSINFO: Application=COMMA; NumUsers=0; UsedPhysicalMem=4876894208; UsedVirtualMem=688590848; PID=620*
                    Information*11*loginID*09/16/2013 03:28:16*CHsvDSSystemInfo.cpp*Line 7652*<?xml version="1.0"?>
                    <EStr><Ref>{93233B21-A924-48C1-A26C-8A4A0F251D34}</Ref><AppName>COMMA</AppName><User/><DBUpdate>1</DBUpdate><ESec><Num>0</Num><Type>1</Type><DTime>09/16/2013 3:28:16 AM</DTime><Svr>Server3</Svr><File>CHsvDSSystemInfo.cpp</File><Line>7652</Line><Ver>11.1.2.1.104.3701</Ver><DStr>SYSINFO: Application=COMMA; NumUsers=0; UsedPhysicalMem=4876894208; UsedVirtualMem=688590848; PID=620</DStr></ESec></EStr>
                    *
                    Information*11*loginID*09/16/2013 03:29:06*CHsvDSSystemInfo.cpp*Line 7652*SYSINFO: Application=AppName; NumUsers=9; UsedPhysicalMem=4906221568; UsedVirtualMem=1341214720; PID=1204*
                    Information*11*loginID*09/16/2013 03:29:06*CHsvDSSystemInfo.cpp*Line 7652*<?xml version="1.0"?>
                    <EStr><Ref>{0BC9F91F-ABF6-4E58-BD2B-57E4377F0FC8}</Ref><AppName>AppName</AppName><User/><DBUpdate>1</DBUpdate><ESec><Num>0</Num><Type>1</Type><DTime>09/16/2013 3:29:06 AM</DTime><Svr>Server3</Svr><File>CHsvDSSystemInfo.cpp</File><Line>7652</Line><Ver>11.1.2.1.104.3701</Ver><DStr>SYSINFO: Application=AppName; NumUsers=9; UsedPhysicalMem=4906221568; UsedVirtualMem=1341214720; PID=1204</DStr></ESec></EStr>

                     

                    I am not sure why this issue is getting only Server3 and it's working good in other servers

                     

                    Thanks,

                    RSV

                    • 7. Re: Task Audit Export error An unknown error has occurred in the HSVsysteminfo object
                      Thanos A

                      Hi there,

                       

                      Unfortunately, there is nothing specific in the file (at least not for me..)

                       

                      Can you access the table and get the number of entries in servers 1,2 and 3?

                       

                      Regards,

                       

                      Thanos

                      • 8. Re: Task Audit Export error An unknown error has occurred in the HSVsysteminfo object
                        955124

                        Stop all your services , Restart HFM , Start all your services . Your issue should be taken care of !