This discussion is archived
14 Replies Latest reply: Nov 11, 2013 1:15 PM by Emmanuel Algarin RSS

Error detected while attempting to run job

Emmanuel Algarin Newbie
Currently Being Moderated

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 Explorer
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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
    user10132385 Journeyer
    Currently Being Moderated

    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 Explorer
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Explorer
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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 Explorer
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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,

Legend

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