14 Replies Latest reply: Nov 11, 2013 3:15 PM by Emmanuel Algarin RSS

    Error detected while attempting to run job

    Emmanuel Algarin

      Hi everyone,


      One of my users tried to run a rule in Hyperion Planning 11.1.1.3 and an error occurred:   Error detected while attempting to run job


      When I went to Essbase, I found that when I launched the rule an error appeared:


      ERROR - 1006059 - Invalid block header: Illegal block type -- Please use the IBH Locate/Fix utilities to find/fix the IBH problem.


      I read that it could be an issue related to corrupted blocks. I'm not familiar with MXL and I read that there are commands that I could run. Someody could provide me help?


      Regards,

        • 1. Re: Error detected while attempting to run job
          userx

          It can be because of many reasons disk size, File system, Direct I/O, Low data cache,

          Was that particular cube migrated ?

          any how include ibhfixthreshold for the cube in .cfg file and provide the output after restarting the app and re doing the process you were trying to complete.

          • 2. Re: Error detected while attempting to run job
            Emmanuel Algarin

            This cube has not been migrated. I can include the ibhfixthreshold but I do not understand the last parameter, if I have to delimit the percentage or the system by default will calculate it.

             

            Regards,

            • 3. Re: Error detected while attempting to run job
              Emmanuel Algarin

              I loaded one bakcup from yesterday and I was not lucky. After this, I changed caches and the rule is working correctly again. How can cache could be affecting my application?

               

              Regards,

              • 4. Re: Error detected while attempting to run job
                AmarnathK

                Have you checked if you have any .xcp files?

                Run VALIDATE Command using ESSCMD and will tell you how many block combinations will have IBH errors.

                 

                Regards

                Amarnath

                ORACLE | Essbase

                • 5. Re: Error detected while attempting to run job
                  SreekumarHariharan

                  Finding IBH Errors

                   

                  You must set the server configuration setting IBHFIXTHRESHOLD in essbase.cfg and restart Essbase Server before you can find and fix IBH Errors


                  Fixing IBH Errors

                   

                  The Maxl command "alter database dbName validate data to filename".

                  Use the Sequence of MaxL Command run :

                  alter application sample disable commands;

                  alter system logout session on database sample.basic;

                  alter database sample.basic validate data to local logfile 'invalid_blocks';

                  alter database sample.basic repair invalid_block_headers;

                   



                  Thanks,

                  Sreekumar Hariharan

                  • 6. Re: Error detected while attempting to run job
                    Emmanuel Algarin

                    Hi Sreekumar,

                     

                    How can I run a MAXL command, I'm new into this and I do not have idea on how to execute it.

                     

                    Regards

                    • 7. Re: Error detected while attempting to run job
                      Emmanuel Algarin

                      Hi!

                       

                      I was able to enter into the MAXL command. In login in and the I started typing the commands, but when I arrived to "Alter database COL.COSTS validate data to local logfile 'invalid_blocks'; " An error appeared: ERROR - 1051544 - message on contacting or from application: [Sat Nov 09 22:23:05]Local///Error<103206> SetActive Commands are Currently Not Being Accepted"

                       

                      How can I proccess in order to execute this commands?

                       

                      Regards,

                      • 8. Re: Error detected while attempting to run job
                        Emmanuel Algarin

                        After several times I tried with the commands, I finally was able to reach the last command. After this, it appeared: "Number of IBH fixed: [8]"

                         

                        It seems that there were invalid blocks; nevertheless, the error stills appear: Error - 1006059 - Invalid block header: Illegal block type -- Please use the IBH Locate/Fix utilities to find/fix the IBH problem

                         

                        If the blocks were fixed why the error is still appearing?

                         

                        Regards,

                        • 9. Re: Error detected while attempting to run job
                          userx

                          xxx544 says it was some connection issue, you can try some earlier backup and run above commands

                          • 10. Re: Error detected while attempting to run job
                            Emmanuel Algarin

                            I tried with a back up, the error is still appearing. I executed again the erro even in MAXL:

                             

                             

                             

                            Essbase MaxL Shell - Release 11.1.1 (ESB11.1.1.3.0B126)

                            Copyright (c) 2000, 2009, Oracle and/or its affiliates.

                            All rights reserved.

                             

                             

                            MAXL> loginas;

                            Enter UserName> admin

                            Enter Password> ********

                            Enter Host> stlwlahyesprd01

                            Enter UserName to Login As> admin

                             

                             

                            OK/INFO - 1051034 - Logging in user [admin].

                            OK/INFO - 1051035 - Last login on Sunday, November 10, 2013 4:18:53 PM.

                            OK/INFO - 1241001 - Logged in to Essbase.

                             

                             

                            MAXL> alter application HYPCOLAN disable commands;

                             

                             

                            OK/INFO - 1056013 - Application HYPCOLAN altered.

                             

                             

                            MAXL> alter system logout session on database HYPCOLAN.COSTS;

                             

                             

                            OK/INFO - 1056092 - Sessions logged out [0].

                            OK/INFO - 1056090 - System altered.

                             

                             

                            MAXL> alter database HYPCOLAN.COSTS validate data to local logfile 'invalid_bloc

                            ks';

                             

                             

                               ERROR - 1051544 - message on contacting or from application:

                            [Sun Nov 10 16:23:02 2013]Local////Error(1013206)

                            SetActive Commands are Currently Not Being Accepted

                             

                             

                            .

                             

                             

                            MAXL>

                            • 11. Re: Error detected while attempting to run job
                              Emmanuel Algarin

                              I have XCP files:

                               

                               

                               

                              ----- Exception Error Log Begin -----

                               

                               

                              Current Date & Time:   Thu Nov 07 13:31:38 2013

                              Process Type:          Application

                              Application Name:      HYPCOLAN

                              Database Name:         COSTS

                              Exception Log File:    c:\Hyperion\logs\essbase\app\HYPCOLAN\COSTS\log00001.xcp

                              Current Thread Id:     5940

                              Exception Code:        0xC0000005=Access Violation

                              Exception Flags:       0x00000000=Continuable

                              Exception Address:     0x603B569F

                              Exception Parameters:  2

                              Exception Parameter 0: 0x00000001=Write Violation

                              Exception Parameter 1: 0x57970000 (Virtual Address)

                               

                               

                              ----- Machine Registers -----

                               

                               

                              General Registers:

                                 EAX=0x795D0E18  EBX=0x5796FFF8  ECX=0x57970038

                                 EDX=0x0DC0F6CC  ESI=0x00000048  EDI=0xFD320000

                               

                               

                              Control Registers:

                                 CS =0x0000001B  EIP=0x603B569F  Flg=0x00010283

                                 SS =0x00000023  ESP=0x024ACBB0  EBP=0x024ACBCC

                               

                               

                              Segment Registers:

                                 DS =0x00000023  ES =0x00000023  FS =0x0000003B

                                 GS =0x00000000

                               

                               

                              Floating Point Registers:

                                 CWD=0xFFFF027F  SWD=0xFFFF3920  TWD=0xFFFF3FFF

                                 EOF=0x603B5699  ESL=0x0505001B  DOF=0x603E9B50

                                 DSL=0xFFFF0023  CRS=0x00000000

                               

                               

                              Register Area (Hex):

                                 00 B0 B0 3A F7 7C 1D 90 CE BF

                                 00 00 00 00 00 00 00 00 00 00

                                 00 00 00 00 00 00 00 00 00 00

                                 00 00 00 00 00 00 00 00 00 00

                                 00 00 00 00 00 00 00 00 00 00

                                 00 00 00 00 00 00 00 00 00 00

                                 00 00 00 00 FC 09 A0 95 26 40

                                 00 00 C0 C6 B2 2C 7B 91 28 40

                               

                               

                              Debug Registers:

                                 DR0=0x00000000  DR1=0x00000000  DR2=0x00000000

                                 DR3=0x00000000  DR6=0x00000000  DR7=0x00000000

                               

                               

                              ----- Stack -----

                               

                               

                              Stack Trace:

                                  0: 0x603b569f ESSSVRD@adReqCurrencyTransBegin + 0x9c22f 0x00000000010cf0a4 0x000000000dc0f6cc 0x000000000dc0f378 0x000000004a25db00

                                  1: 0x603b6ba8 ESSSVRD@adReqCurrencyTransBegin + 0x9d738 0x00000000010cf0a4 0x000000000032af01 0x0000000000000004 0x000000000000198a

                                  2: 0x603bb76b ESSSVRD@adReqCurrencyTransBegin + 0xa22fb 0x00000000010cf0a4 0x000000004a25db00 0x000000000dc0f330 0x000000000da45d00

                                  3: 0x603bc2d1 ESSSVRD@adReqCurrencyTransBegin + 0xa2e61 0x00000000000003a8 0x00000000010cf0a4 0x000000004a25db00 0x00000000214e006c

                                  4: 0x603bc441 ESSSVRD@adReqCurrencyTransBegin + 0xa2fd1 0x000000004a25db00 0x00000000024ad2a8 0x00000000010cf0a4 0x0000000000000000

                                  5: 0x603bf614 ESSSVRD@adReqCurrencyTransBegin + 0xa61a4 0x00000000010cf0a4 0x000000000025db00 0x0000000000000000 0x00000000010cf0a4

                                  6: 0x6037dc5f ESSSVRD@adReqCurrencyTransBegin + 0x647ef 0x0000000000000002 0x0000000000000000 0x00000000010cf0a4 0x00000000024ad2a8

                                  7: 0x6037e28d ESSSVRD@adReqCurrencyTransBegin + 0x64e1d 0x00000000010cf0a4 0x00000000024ad2a8 0x0000000000000002 0x0000000000000000

                                  8: 0x60376993 ESSSVRD@adReqCurrencyTransBegin + 0x5d523 0x000000000013003a 0x0000000000000000 0x00000000010cf0a4 0x00000000004ad200

                                  9: 0x601c902e ESSSVRD@adCSCRConvFixMbrFromBitMap + 0x1115e 0x000000000000012c 0x00000000596ea148 0x0000000000000000 0x00000000024ad40c

                                 10: 0x601af5d2 ESSSVRD@adOdomInc + 0x3172 0x00000000010cf0a4 0x00000000010cc462 0x000000000dc99940 0x000000000dc48fd8

                                 11: 0x601af718 ESSSVRD@adOdomInc + 0x32b8 0x00000000010cf0a4 0x00000000010cc462 0x00000000588edfd8 0x0000000000000000

                                 12: 0x601b02c5 ESSSVRD@adOdomInc + 0x3e65 0x00000000010cf0a4 0x000000000dc2d540 0x00000000010cf0a4 0x00000000604d283d

                                 13: 0x6032eb72 ESSSVRD@adReqCurrencyTransBegin + 0x15702 0x00000000010cf0a4 0x000000000dc6a0a4 0x000000000dc6a008 0x00000000024af660

                                 14: 0x6032db25 ESSSVRD@adReqCurrencyTransBegin + 0x146b5 0x000000000dc6a0a4 0x000000000dc6a008 0x00000000024af660 0x00000000604cfbba

                                 15: 0x603320d8 ESSSVRD@adReqCurrencyTransBegin + 0x18c68 0x00000000010cf0a4 0x000000000000000d 0x00000000024af660 0x0000000000004650

                                 16: 0x602ed5ac ESSSVRD@adThreadRegister + 0x467c 0x00000000010cf0a4 0x0000000000004650 0x0000000000000000 0x0000000000000000

                                 17: 0x602eec17 ESSSVRD@adThreadRegister + 0x5ce7 0x00000000000cf0a4 0x0000000000000000 0x0000000000000000 0x00000000010cf0a4

                                 18: 0x77e6481f kernel32@GetModuleHandleA + 0xdf 0x0000000000000000 0x0000000000000000 0x0000000000000000 0x0000000000000000

                               

                               

                               

                               

                              ----- Application-Wide Configuration -----

                               

                               

                              Server Name:          

                              Application Name:      HYPCOLAN

                              Elapsed App Time:      00:21:23:39

                              Module Count:          16

                              Module  0:             0x00401000 = C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSSVR.EXE

                              Module  1:             0x60001000 = C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSSVRD.DLL

                              Module  2:             0x60B31000 = C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSASOSM.DLL

                              Module  3:             0x60CA1000 = C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSRPM.DLL

                              Module  4:             0x60DC1000 = C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSAPINU.DLL

                              Module  5:             0x60E91000 = C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSOTLSU.DLL

                              Module  6:             0x60F41000 = C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSOTLNU.DLL

                              Module  7:             0x60F81000 = C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSMTDNU.DLL

                              Module  8:             0x61031000 = C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSOPGN.DLL

                              Module  9:             0x61061000 = C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSSHRU.DLL

                              Module 10:             0x61135430 = C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSUTLU.DLL

                              Module 11:             0x61151000 = C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSSDU.DLL

                              Module 12:             0x61171000 = C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSGLOBU.DLL

                              Module 13:             0x61181000 = C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSSECU.DLL

                              Module 14:             0x61191000 = C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSOBJIO.DLL

                              Module 15:             0x611A1000 = C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSDVRQ.DLL

                               

                               

                              ----- Operating System Resources -----

                               

                               

                              System Date & Time:    Thu Nov 07 13:31:39 2013

                              Elapsed OS Time:       13:21:34:36

                              OS Name & Version:     Windows NT 5.02

                              CPU Count:             16

                              CPU Type:              Pentium

                              Correct System Memory information currently not available

                              Swap Flags:

                                 Enabled:            Y

                                 Disabled:           N

                                 File Found:         Y

                                 Denied:             N

                              Swap file(s):          c:\pagefile.sys

                              Correct Swap Space information currently not available

                              Total Drives:          6

                              Current Drive:         3

                              Drive  3:

                                 Drive Name:         C

                                 Volume Label:       Local Disk

                                 Drive Type:         Fixed

                                 File System:        NTFS

                                 Total Drive Space:  142689329 KB

                                 Free Drive Space:   71187620 KB

                                 Used Drive Space:   71501709 KB

                              Drive  4:

                                 Drive Name:         D

                                 Volume Label:       Drive_D

                                 Drive Type:         Fixed

                                 File System:        NTFS

                                 Total Drive Space:  292415096 KB

                                 Free Drive Space:   18586252 KB

                                 Used Drive Space:   273828844 KB

                              Drive  5:

                                 Drive Name:         E

                                 Volume Label:      

                                 Drive Type:         Unknown

                                 File System:        Unknown

                                 Total Drive Space:  0 KB

                                 Free Drive Space:   0 KB

                                 Used Drive Space:   0 KB

                              Drive  6:

                                 Drive Name:         F

                                 Volume Label:      

                                 Drive Type:         Unknown

                                 File System:        Unknown

                                 Total Drive Space:  0 KB

                                 Free Drive Space:   0 KB

                                 Used Drive Space:   0 KB

                              Drive  7:

                                 Drive Name:         G

                                 Volume Label:      

                                 Drive Type:         Unknown

                                 File System:        Unknown

                                 Total Drive Space:  0 KB

                                 Free Drive Space:   0 KB

                                 Used Drive Space:   0 KB

                              Drive 21:

                                 Drive Name:         U

                                 Volume Label:      

                                 Drive Type:         Unknown

                                 File System:        Unknown

                                 Total Drive Space:  0 KB

                                 Free Drive Space:   0 KB

                                 Used Drive Space:   0 KB

                               

                               

                              ----- System-Wide Configuration -----

                               

                               

                              Elapsed Essbase Time:  00:21:23:39

                              Essbase Version:       11.1.1

                              Essbase Description:   ESB11.1.1.3.0B126

                              Network Type:          Windows Sockets

                              Environment Variable:  ARBORPATH                 = c:\Hyperion\products\Essbase\EssbaseServer

                              Environment Variable:  ARBORMSGPATH              = c:\Hyperion\products\Essbase\EssbaseServer\bin

                              Module Count:          16

                              Module  0:

                                 Module Name:        C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSSDU.DLL

                                 Module Version:     11.1.1.1

                                 Module Description: ESB11.1.1.3.0B126.1

                                 Module Use Count:   2

                              Module  1:

                                 Module Name:        C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSGLOBU.DLL

                                 Module Version:     11.1.1.1

                                 Module Description: ESB11.1.1.3.0B126.1

                                 Module Use Count:   2

                              Module  2:

                                 Module Name:        C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSUTLU.DLL

                                 Module Version:     11.1.1.1

                                 Module Description: ESB11.1.1.3.0B126.1

                                 Module Use Count:   2

                              Module  3:

                                 Module Name:        C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSSECU.DLL

                                 Module Version:     11.1.1.1

                                 Module Description: ESB11.1.1.3.0B126.1

                                 Module Use Count:   2

                              Module  4:

                                 Module Name:        C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSOBJIO.DLL

                                 Module Version:     11.1.1.1

                                 Module Description: ESB11.1.1.3.0B126.1

                                 Module Use Count:   2

                              Module  5:

                                 Module Name:        C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSOPGN.DLL

                                 Module Version:     11.1.1.1

                                 Module Description: ESB11.1.1.3.0B126.1

                                 Module Use Count:   2

                              Module  6:

                                 Module Name:        C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSOTLSU.DLL

                                 Module Version:     11.1.1.1

                                 Module Description: ESB11.1.1.3.0B126.1

                                 Module Use Count:   2

                              Module  7:

                                 Module Name:        C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSSHRU.DLL

                                 Module Version:     11.1.1.1

                                 Module Description: ESB11.1.1.3.0B126.1

                                 Module Use Count:   2

                              Module  8:

                                 Module Name:        C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSAPINU.DLL

                                 Module Version:     11.1.1.1

                                 Module Description: ESB11.1.1.3.0B126.1

                                 Module Use Count:   2

                              Module  9:

                                 Module Name:        C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSOTLNU.DLL

                                 Module Version:     11.1.1.1

                                 Module Description: ESB11.1.1.3.0B126.1

                                 Module Use Count:   2

                              Module 10:

                                 Module Name:        C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSRPM.DLL

                                 Module Version:     11.1.1.1

                                 Module Description: ESB11.1.1.3.0B126.1

                                 Module Use Count:   2

                              Module 11:

                                 Module Name:        C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSMTDNU.DLL

                                 Module Version:     11.1.1.1

                                 Module Description: ESB11.1.1.3.0B126.1

                                 Module Use Count:   2

                              Module 12:

                                 Module Name:        C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSASOSM.DLL

                                 Module Version:     11.1.1.1

                                 Module Description: ESB11.1.1.3.0B126.1

                                 Module Use Count:   2

                              Module 13:

                                 Module Name:        C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSDVRQ.DLL

                                 Module Version:     11.1.1.1

                                 Module Description: ESB11.1.1.3.0B126.1

                                 Module Use Count:   2

                              Module 14:

                                 Module Name:        C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSSVRD.DLL

                                 Module Version:     11.1.1.1

                                 Module Description: ESB11.1.1.3.0B126.1

                                 Module Use Count:   2

                              Module 15:

                                 Module Name:        C:\HYPERION\PRODUCTS\ESSBASE\ESSBASESERVER\BIN\ESSSVR.EXE

                                 Module Version:     11.1.1.1

                                 Module Description: ESB11.1.1.3.0B126.1

                                 Module Use Count:   2

                               

                               

                              ----- ESSBASE.CFG Configuration Values -----

                               

                               

                              Configuration Value:   JvmModuleLocation         = c:\Hyperion\common\JRE\Sun\1.5.0\bin\client\jvm.dll

                              Configuration Value:   AuthenticationModule      = CSS

                              Configuration Value:   PORTINC                   = 3

                              Configuration Value:   DataErrorLimit            = 65000

                              Configuration Value:   CalcCacheHigh             = 1100000000

                              Configuration Value:   CalcCacheDefault          = 500000000

                              Configuration Value:   CalcCacheLow              = 30000000

                              Configuration Value:   CalcLockBlockHigh         = 4000000

                              Configuration Value:   CalcLockBlockDefault      = 900000

                              Configuration Value:   CalcLockBlockLow          = 400000

                              Configuration Value:   UpdateCalc                = False

                              Configuration Value:   NetDelay                  = 3000

                              Configuration Value:   NetRetryCount             = 1000

                              Configuration Value:   MultipleBitmapMemCheck    = True

                              Configuration Value:   ParCalcMultipleBitmapMemOpt = True

                              Configuration Value:   DYNCALCCACHEWAITFORBLK    = TRUE

                              Configuration Value:   DYNCALCCACHEBLKRELEASE    = TRUE

                              Configuration Value:   DYNCALCCACHEMAXSIZE       = 600M

                              Configuration Value:   DYNCALCCACHECOMPRBLKBUFSIZE = 400M

                              Configuration Value:   CalcLimitFormulaRecursion = TRUE;

                              Configuration Value:   AGENTPORT                 = 1423

                              Configuration Value:   SERVERPORTBEGIN           = 32768

                              Configuration Value:   SERVERPORTEND             = 33768

                              Configuration Value:   AGENTDESC                 = hypservice_1

                               

                               

                              ----- Client Request Activity -----

                               

                               

                              Server Name:          

                              Application Name:      HYPCOLAN

                              Total Request Threads: 20

                              Avail Request Threads: 19

                              Total Requests:        220

                              Average Requests:      111.000000

                              Weighted Average:      0.007431

                              Statistics Per Minute:

                                 Current Requests:   0

                                 Minimum Requests:   0.000000

                                 Maximum Requests:   111.000000

                              Thread Count:          20

                              Thread Id 3324:

                                 Request Name:        GetAttributeNameSpecs

                                 Database Name:       COSTS

                                 User Name:           admin

                                 Start Time:          Thu Nov 07 13:31:33 2013

                                 End Time:            Thu Nov 07 13:31:33 2013

                              Thread Id 4060:

                                 Request Name:        GetMbrInfo

                                 Database Name:       COSTS

                                 User Name:           admin

                                 Start Time:          Thu Nov 07 13:31:33 2013

                                 End Time:            Thu Nov 07 13:31:33 2013

                              Thread Id 1692:

                                 Request Name:        OtlQueryAttrib

                                 Database Name:       COSTS

                                 User Name:           admin

                                 Start Time:          Thu Nov 07 13:31:33 2013

                                 End Time:            Thu Nov 07 13:31:33 2013

                              Thread Id 736:

                                 Request Name:        OtlQueryAttrib

                                 Database Name:       COSTS

                                 User Name:           admin

                                 Start Time:          Thu Nov 07 13:31:33 2013

                                 End Time:            Thu Nov 07 13:31:33 2013

                              Thread Id 5288:

                                 Request Name:        OtlQueryAttrib

                                 Database Name:       COSTS

                                 User Name:           admin

                                 Start Time:          Thu Nov 07 13:31:33 2013

                                 End Time:            Thu Nov 07 13:31:33 2013

                              Thread Id 784:

                                 Request Name:        OtlQueryMbrs

                                 Database Name:       COSTS

                                 User Name:           admin

                                 Start Time:          Thu Nov 07 13:31:33 2013

                                 End Time:            Thu Nov 07 13:31:33 2013

                              Thread Id 220:

                                 Request Name:        GetSelectedMbrInfo

                                 Database Name:       COSTS

                                 User Name:           admin

                                 Start Time:          Thu Nov 07 13:31:33 2013

                                 End Time:            Thu Nov 07 13:31:33 2013

                              Thread Id 4356:

                                 Request Name:        OtlQueryAttrib

                                 Database Name:       COSTS

                                 User Name:           admin

                                 Start Time:          Thu Nov 07 13:31:33 2013

                                 End Time:            Thu Nov 07 13:31:33 2013

                              Thread Id 6100:

                                 Request Name:        OtlQueryAttrib

                                 Database Name:       COSTS

                                 User Name:           admin

                                 Start Time:          Thu Nov 07 13:31:33 2013

                                 End Time:            Thu Nov 07 13:31:33 2013

                              Thread Id 5944:

                                 Request Name:        OtlQueryAttrib

                                 Database Name:       COSTS

                                 User Name:           admin

                                 Start Time:          Thu Nov 07 13:31:33 2013

                                 End Time:            Thu Nov 07 13:31:33 2013

                              Thread Id 4880:

                                 Request Name:        OtlQueryAttrib

                                 Database Name:       COSTS

                                 User Name:           admin

                                 Start Time:          Thu Nov 07 13:31:33 2013

                                 End Time:            Thu Nov 07 13:31:33 2013

                              Thread Id 1128:

                                 Request Name:        OtlQueryMbrs

                                 Database Name:       COSTS

                                 User Name:           admin

                                 Start Time:          Thu Nov 07 13:31:33 2013

                                 End Time:            Thu Nov 07 13:31:33 2013

                              Thread Id 5728:

                                 Request Name:        OtlQueryAttrib

                                 Database Name:       COSTS

                                 User Name:           admin

                                 Start Time:          Thu Nov 07 13:31:33 2013

                                 End Time:            Thu Nov 07 13:31:33 2013

                              Thread Id 5960:

                                 Request Name:        OtlQueryAttrib

                                 Database Name:       COSTS

                                 User Name:           admin

                                 Start Time:          Thu Nov 07 13:31:33 2013

                                 End Time:            Thu Nov 07 13:31:33 2013

                              Thread Id 1208:

                                 Request Name:        GetOtlUMC

                                 Database Name:       COSTS

                                 User Name:           admin

                                 Start Time:          Thu Nov 07 13:31:33 2013

                                 End Time:            Thu Nov 07 13:31:33 2013

                              Thread Id 5240:

                                 Request Name:        OtlQueryAttrib

                                 Database Name:       COSTS

                                 User Name:           admin

                                 Start Time:          Thu Nov 07 13:31:33 2013

                                 End Time:            Thu Nov 07 13:31:33 2013

                              Thread Id 1768:

                                 Request Name:        OtlQueryAttrib

                                 Database Name:       COSTS

                                 User Name:           admin

                                 Start Time:          Thu Nov 07 13:31:33 2013

                                 End Time:            Thu Nov 07 13:31:33 2013

                              Thread Id 3648:

                                 Request Name:        OtlQueryAttrib

                                 Database Name:       COSTS

                                 User Name:           admin

                                 Start Time:          Thu Nov 07 13:31:33 2013

                                 End Time:            Thu Nov 07 13:31:33 2013

                              Thread Id 1736:

                                 Request Name:        GetOtlInfo

                                 Database Name:       COSTS

                                 User Name:           admin

                                 Start Time:          Thu Nov 07 13:31:33 2013

                                 End Time:            Thu Nov 07 13:31:33 2013

                              Thread Id 5940:

                                 Request Name:        MaxL: Execute

                                 Database Name:       COSTS

                                 User Name:           admin

                                 Start Time:          Thu Nov 07 13:31:38 2013

                                 End Time:            Pending

                               

                               

                              ----- Exception Error Log End -----

                              • 12. Re: Error detected while attempting to run job
                                Emmanuel Algarin

                                I loaded a back up and even though I run the MAXL it still appears:

                                 

                                MAXL> loginas;

                                Enter UserName> admin

                                Enter Password> ********

                                Enter Host> stlwlahyesprd01

                                Enter UserName to Login As> admin

                                 

                                 

                                OK/INFO - 1051034 - Logging in user [admin].

                                OK/INFO - 1051035 - Last login on Monday, November 11, 2013 12:16:46 AM.

                                OK/INFO - 1241001 - Logged in to Essbase.

                                 

                                 

                                MAXL> alter application HYPCOLAN disable commands;

                                 

                                 

                                OK/INFO - 1054014 - Database COSTS loaded.

                                OK/INFO - 1051061 - Application HYPCOLAN loaded - connection established.

                                OK/INFO - 1054027 - Application [HYPCOLAN] started with process id [4932].

                                OK/INFO - 1056013 - Application HYPCOLAN altered.

                                 

                                 

                                MAXL> alter database HYPCOLAN.COSTS validate data to local logfile 'invalid_bloc

                                ks';

                                 

                                 

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                OK/INFO - 1006016 - Invalid block header: Illegal block type.

                                   ERROR - 1042012 - Network error [10054]: Cannot Send Data.

                                   ERROR - 1042012 - Network error [10054]: Cannot Send Data.

                                   ERROR - 1241101 - Unexpected Essbase error 1042012.

                                 

                                 

                                MAXL> alter database HYPCOLAN.COSTS repair invalid_block_headers;

                                 

                                 

                                OK/INFO - 1054014 - Database COSTS loaded.

                                OK/INFO - 1051061 - Application HYPCOLAN loaded - connection established.

                                OK/INFO - 1054027 - Application [HYPCOLAN] started with process id [5084].

                                OK/INFO - 1013155 - Number of IBH fixed: [46].

                                OK/INFO - 1013273 - Database HYPCOLAN.COSTS altered.

                                 

                                The error is still the same: Detail:Cannot calculate. Essbase Error(1006059): Invalid block header: Illegal block type -- Please use the IBH Locate/Fix utilities to find/fix the IBH problem

                                • 13. Re: Error detected while attempting to run job
                                  SreekumarHariharan

                                  IBH errors occurs when there is a mismatch between the .pag file and index (.ind) file .In plain words  the pag file and .ind file are not in sync.

                                   

                                  run this one separately in maxl

                                  alter database HYPCOLAN.COSTS repair invalid_block_headers

                                  Still the ibh error occurs ,then reload the metadata and data from backups and try to re run the batch scheduler.

                                   

                                  After re-running the batch scheduler still the same issue persists ,Then

                                  1.Backup the relational tables of the application in 11.1.1.3

                                  2.Backup essbase objects (rul, otl ,csc, rep)

                                   


                                  Planning Application steps

                                  A)Create a fresh planning application

                                  B)Restore all relational tables of the 11.1.1.3 application  in to the newly created application

                                  C)Restart the Services

                                  d)Copy objects like .csc ,rul,.rep into db (Excluding .otl)

                                  e)Re-import the data into db

                                  f) run the batch scheduler

                                   

                                  Or you can make use of LCM method

                                   

                                  Also try to optimize your planning applications

                                   

                                   

                                  Regards,

                                  Sreekumar Hariharan

                                  • 14. Re: Error detected while attempting to run job
                                    Emmanuel Algarin

                                    The issue is in the Essbase configuration. The business rule was using more resources and uoverdriving memory. In this case, I limited the BR for the valuable crosses and then executed. It is a a memory issue and cache configuration. For this reason we will have an assestment in order to determine the best configuration of the application.

                                     

                                    Regards,