How can we help you today? How can we help you today?

Crash at startup

The last version has 6.11 crashed at startup, I test another smartassembly product to check problem
All of them crashed at startup with no clue about reason .... this is the snapshot

fe4u2tgm74bs.png
Abufahmi
0

Comments

12 comments

Sort by
  • Russell D
    This means that SmartAssembly can't connect to the database. If you've upgraded from before 6.11, then you'll need to migrate over to a SQL database. If you're installing 6.11 fresh you'll need a SQL instance to connect to

    See https://documentation.red-gate.com/sa6/troubleshooting/unexpected-behavior-and-technical-questions/transferring-sa-data-from-mdb-to-sql-server, and https://documentation.red-gate.com/display/SA6/Migrating+your+SmartAssembly+Database+to+SQL for more information on this.
    Russell D
    0
  • pipiscrew
    @Russell D implement SQLite
    https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
    pipiscrew
    0
  • Russell D
    It's been talked about before, even bundling it with SA, but we're not planning on it anytime soon I'm afraid.
    Russell D
    0
  • Abufahmi
    pipiscrew wrote: »
    Russell D wrote: »
    This means that SmartAssembly can't connect to the database. If you've upgraded from before 6.11, then you'll need to migrate over to a SQL database. If you're installing 6.11 fresh you'll need a SQL instance to connect to

    See https://documentation.red-gate.com/sa6/troubleshooting/unexpected-behavior-and-technical-questions/transferring-sa-data-from-mdb-to-sql-server, and https://documentation.red-gate.com/display/SA6/Migrating+your+SmartAssembly+Database+to+SQL for more information on this.

    I have installed version 6.9 and it was working fine, But when upgraded to 6.11
    problem came up .....
    You said "need to migrate over to a SQL database" how to do it ?
    Abufahmi
    0
  • Russell D
    As per the link above, https://documentation.red-gate.com/display/SA6/Migrating+your+SmartAssembly+Database+to+SQL.
    Russell D
    0
  • Abufahmi
    Russell D wrote: »

    Sir ....
    Program does not open !!! how to use info from link !!!
    Is there any command to add it to SQL express, Or can i add it manually
    by SQL management ??
    Abufahmi
    0
  • Russell D
    Ok well you'll need to install Express, if you haven't already, then run the data migration tool - as per the instructions above - to copy your data over.

    Then edit the SmartAssembly.settings file in C:\ProgramData\Red Gate\SmartAssembly to point to the instance of SQL Express, eg
    <Options>
        <Database AutoCategorize="0" DatabaseEngine="1" LastProject="{7358f96c-7d57-46ad-b296-663ae778375b}" Server=".\SQLEXPRESS" />
    </Options>

    Before you do anything, make sure you back up your database.mdb file which should be in the same Programdata location.
    Russell D
    0
  • Abufahmi
    Russell D wrote: »
    Ok well you'll need to install Express, if you haven't already, then run the data migration tool - as per the instructions above - to copy your data over.

    Then edit the SmartAssembly.settings file in C:\ProgramData\Red Gate\SmartAssembly to point to the instance of SQL Express, eg
    <Options>
        <Database AutoCategorize="0" DatabaseEngine="1" LastProject="{7358f96c-7d57-46ad-b296-663ae778375b}" Server=".\SQLEXPRESS" />
    </Options>

    Before you do anything, make sure you back up your database.mdb file which should be in the same Programdata location.


    First, I would like to thank you, Sir, for your time and for your cooperation with me
    Secondly, I will inform you of what happened with me:
    When I added the previous code nothing changed, so I had to do the following:
    - Remove the program
    - Manually delete all program folder paths
    - All values ​​relating to the program have been deleted in the Registry
    - Installed the installation of the program and thank God worked

    But the beginning of its operation comes the message:
    90rl5hmlfgpk.png

    When I went to the previous database folder path to edit .settings
    I found .settings but there is no database.mdb .... is that ok with this version
    Abufahmi
    0
  • Russell D
    After receiving that error click ok, then you can configure the database in Options as it should load the program.

    Uninstalling SA doesn't touch the database, did you manually delete C:\ProgramData\Red Gate\SmartAssembly?
    Russell D
    0
  • Abufahmi
    Russell D wrote: »
    After receiving that error click ok, then you can configure the database in Options as it should load the program.

    Uninstalling SA doesn't touch the database, did you manually delete C:\ProgramData\Red Gate\SmartAssembly?

    I do configured from option then .settings showed then configured it
    And about directory "ProgramData\Red Gate" yes i also delete it before
    new installation
    Abufahmi
    0
  • Russell D
    Ok well that folder will have contained your smartassembly.mdb. Did you migrate your data over before deleting it?

    Are you up and running then?
    Russell D
    0
  • Abufahmi
    Russell D wrote: »
    Ok well that folder will have contained your smartassembly.mdb. Did you migrate your data over before deleting it?

    Are you up and running then?

    Of course not sir, the program was not working then.
    Frankly I wonder how the program works now and without a database ??

    u5y9xy5ampzh.png
    Abufahmi
    0

Add comment

Please sign in to leave a comment.