Running BA configurator more than once

ta5
ta5 Member Posts: 1,164
Hi
If configurator has to be run more than once (in development scenario) and when deploying changes to the customer site, the BA Database has to be deleted in a first step.

Can this behavior be changed? Maybe with some parameters for configurator.exe?

Regards
Thomas

Comments

  • kine
    kine Member Posts: 12,562
    No, there is no such a parameter. Sorry.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • vyanku
    vyanku Member Posts: 791
    I got this type of problem.
    When I run Configurator many times the ba database in SQL gets curropted . Even after deleting that database we got problem again and agian. After that only solution is to ininstall sql. But If we install and uninstall SQL two three times it will also gets currupted.
    Is there any proper solution for this type of problem?
  • kine
    kine Member Posts: 12,562
    vyanku wrote:
    I got this type of problem.
    When I run Configurator many times the ba database in SQL gets curropted . Even after deleting that database we got problem again and agian. After that only solution is to ininstall sql. But If we install and uninstall SQL two three times it will also gets currupted.
    Is there any proper solution for this type of problem?

    It seems that the problem is elsewhere. I never had this problem. I recommend to check your HDDs and memory. It sounds like HW problem...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • vyanku
    vyanku Member Posts: 791
    HDD Problem?? How it is possible.??
    I got errors like "Parent already exist","BA Configurated get currepted" etc.
  • kine
    kine Member Posts: 12,562
    you wrote
    But If we install and uninstall SQL two three times it will also gets currupted.

    without details, it looks like the database is corrupted in a way that cannot be used -> HW problem.

    But because the Configurator delete the db each time the cube is generated, the problem will be somewhere else.

    Which version of configurator you are using? Which version of NAV?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • vyanku
    vyanku Member Posts: 791
    I am using BA version 4.0 and navision version 4.0 SP2
  • kine
    kine Member Posts: 12,562
    I recommend to use newest BA Configurator, which can be downloaded from PartnerSource. I recommend to update all BA objects in your DB to SP3 version. BA Configurator for SP3 was improved...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • ta5
    ta5 Member Posts: 1,164
    kine wrote:
    But because the Configurator delete the db each time the cube is generated, the problem will be somewhere else.

    Which version of configurator you are using? Which version of NAV?

    I actually dont have problems with that, it's just a bit inconvenient, especially if I have do this remote by phone :shock:

    Anyway, does your configurator the db delete by itselfe?

    Regards
    Thomas
  • vyanku
    vyanku Member Posts: 791
    No
  • kine
    kine Member Posts: 12,562
    The DB is not removed automatically just if there is some opened session to this DB. It means, you need to be sure, that there is no active session using the DB. If there is such a session, you need to kill it.

    (sometimes there is no user connected to the DB, but still some session is opened...)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • vyanku
    vyanku Member Posts: 791
    then what must be the problem? :-k
    All problems are occured when I run One cube containing multiple cubes.
    Just like default cube. :-k
    Is it possible that we create multiple cubes and make all of them active.And run all of them???? ](*,)
  • kine
    kine Member Posts: 12,562
    1) In NAV 4.0 you can have just one BA Database active with more cubes
    2) In NAV 5.0 you can have more BA DB active
    3) Check the ba.log in configurator directory for more info
    4) Enable logging on SQL AS to have more info about the problem
    5) Check event log for more info
    6) DEFAULT db in NAV are in some language versions screwed up. Better is to create some new cubes from scratch
    7) Be sure that you are using as newest objects and configurator as possible.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • vyanku
    vyanku Member Posts: 791
    Where I got the latest version of BA Configurator for NAV 4.0 SP2.(Not for SP3)
  • vyanku
    vyanku Member Posts: 791
    When I run cube with multiple cube
    it shows me error
    Unable to ceate cube
    This key already accociated with the element of this collection

    It dosend shows any error in eventviewer.