Business Analytics ba.log file

AAshok
AAshok Member Posts: 53
edited 2011-02-09 in NAV/Navision Classic Client
Hi All,

i am facing an error when i use to run the business analytic configurator

Below is the ba.log file which is created when i used to run the two different databases with same SQL Server 2005 and the same configurator.exe and same BA objects and same BA tables data, only the database is different

********************** Started: Tuesday, September 30, 2008 5:56:47 PM **********************
Language: w1
Database: XXX-Navision
Dynamics NAV version: 5
5:56:54 PM: Initialize
Read XML
5:56:55 PM: Check for SQL Server 2005
5:56:55 PM: Check for Analysis Services 2005
5:57:06 PM: Installation started
5:57:06 PM: Build Internal Representation
Companies
Enumerations
Shared Dimensions
Cubes
5:57:10 PM: Installation completed
********************** Started: Tuesday, September 30, 2008 5:57:32 PM **********************
Language: w1
Database: XXX-training
Dynamics NAV version: 5
5:57:32 PM: Initialize
Read XML
5:57:32 PM: Check for SQL Server 2005
5:57:32 PM: Check for Analysis Services 2005
5:57:34 PM: Installation started
5:57:34 PM: Build Internal Representation
Companies
Enumerations
Shared Dimensions
Cubes
Reference Dimensions
Virtual Cubes
Transfer
Period Table Tasks
5:57:40 PM: Install Custom SSIS Tasks


the BA objects, BA data is same for both the databases.

I am getting error in Database: XXX-Navision in "Build Interface representation" with error "Object reference not set to an instance of an object"
but for database XXX-training there is no error & its working fine.

i don't no why the
Reference Dimensions
Virtual Cubes
Transfer
Period Table Tasks
are not creating for the database XXX-Navision and it is creating for XXX- Training


Can anyone please help me... ](*,) ](*,) ](*,) ](*,) ](*,) ](*,) ](*,) ](*,)

Thanks in advance...

Comments

  • ashbhardwaj
    ashbhardwaj Member Posts: 89
    Have u Created any cube in this database ? or modified any existing one?
    try it after removing the new cube or ur modification.

    Hope it works fine after updating XML & run configurator.exe again
  • AAshok
    AAshok Member Posts: 53
    Hi

    i have not created or modified any cube or code or anything......

    i am working with DEFAULT BA Database which is pre-defined.

    Thank You.
  • AAshok
    AAshok Member Posts: 53
    Hi All,

    Good news to all,

    I have solved my Build Internal Representation issue,

    but in the same process i am getting one more issue..

    the issue is in "Create SQL Server Database", in the process, suddenly the process window is terminated and i cant see the window...

    Please help me if anyone knows


    Thanks in advance...
  • nileshmandani
    nileshmandani Member Posts: 2
    Hi ! Ashok..

    The problem is small and simple but took a long time to resolve.

    The table propery is change - DATA PER COMPANY to "NO".
    And that's the bug @ BA from Microsoft.
    DATA PER COMPANY - NO is not supported by Microsoft.

    Regards,
    Nilesh
  • AAshok
    AAshok Member Posts: 53
    Hi Nilesh,

    Thanks for reply.

    so... how r u? how is life going on...say hi to all ....


    Thank you
    Ashok.A
  • 246peter
    246peter Member Posts: 2
    Hi AAshok and all,

    I have same problem with Build Internal Representation. ( Nav 4.0 SP3, SQL 2005 )
    I am working with DEFAULT BA database without changes any of cubes.
    I have latest version of Configurator.exe dowloaded from partnersource.
    below is the ba.log
    please, help me to solve it

    Thank you.

    Language: w1
    Database:
    Dynamics NAV version: 5
    13:15:00: Initialize
    Read XML
    13:15:00: Check for SQL Server 2005
    13:15:00: Check for Analysis Services 2005
    13:15:01: Installation started
    13:15:01: Build Internal Representation
    Companies
    Enumerations
    Shared Dimensions
    Cubes
    13:15:01: Installation completed
  • nileshmandani
    nileshmandani Member Posts: 2
    Respected,

    Check each table of cube for the property called "Data Per Company".
    The property must set to "NO" for all the table which your cube does contain.

    Regards,
    Nilesh
  • 246peter
    246peter Member Posts: 2
    Hi Nilesh,

    thank you for your reply.

    I checked property "Data Per Company" before.
    Each table used in cubes have DataPerCompany = Yes. I checked it twice :(

    Any other ideas ?

    thanks in advance
  • iscott
    iscott Member Posts: 4
    246peter wrote:
    Hi Nilesh,

    thank you for your reply.

    I checked property "Data Per Company" before.
    Each table used in cubes have DataPerCompany = Yes. I checked it twice :(

    Any other ideas ?

    thanks in advance
    Duid you get any help with this i'm getting the same error
  • Lijnco
    Lijnco Member Posts: 22
    I'm having the same problem to, on Nav2009 and BA analytics.
    When running the configurator to update the cubes, the following error occurs:
    Object reference not set to an Instance of an object.
    It occurs at the first step of the second screen, after the SQL check. (making internal representation)

    I updated .net framework because the service "Microsoft .NET Framework NGEN v4.0.30319_X64" and "Microsoft .NET Framework NGEN v4.0.30319_X86" doesn't start.
  • Lijnco
    Lijnco Member Posts: 22
    Seemed that the Server agent wasn't running #-o

    But now, the configurator doesn't start at all.
    The log reports the following error:

    .net runtime error 5000:

    EventType clr20r3, P1 configurator.exe, P2 4.0.0.27, P3 4a826bde, P4 mscorlib, P5 2.0.0.0, P6 4be90358, P7 344a, P8 21c, P9 system.io.ioexception, P10 NIL.
  • johanna
    johanna Member Posts: 369
    AAshok wrote:
    Hi All,

    Good news to all,

    I have solved my Build Internal Representation issue,

    Hi AAshok,

    What did you do to solve issue Build Internal Representation issue ?
    Thanks before :)
    Best regards,

    Johanna

Categories