Error starting adr serverless with in_memory set to true

[viseshrp]

🔍 Before submitting the issue

• I have searched among the existing issues
• I am using a Python virtual environment

🐞 Description of the bug

Windows 11 24H2
Unified Package Name: 2025-04-28 00:43 P00
CEI Build: a0e677e51

regression test test_initialize_in_memory.py is failing while'st initializing the instance producing the following error

I'm attaching the test to the item but the test fails on start up

📝 Steps to reproduce

output:

D:\Testing\Test_Datasets\ARM_Reports\in_memory_04292025155021>call "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\Scripts\activate.bat"
Traceback (most recent call last):
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\django\db\backends\utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\django\db\backends\sqlite3\base.py", line 328, in execute
return super().execute(query, params)
sqlite3.OperationalError: no such table: data_session

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "D:\Testing\Test_Datasets\ARM_Reports\in_memory_04292025155021\test_initialize_in_memory.py", line 19, in test_init_simple
adr.setup()
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\ansys\dynamicreporting\core\serverless\adr.py", line 540, in setup
self._session = Session.create()
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\ansys\dynamicreporting\core\serverless\base.py", line 46, in wrapper
return func(*args, **kwargs)
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\ansys\dynamicreporting\core\serverless\base.py", line 424, in create
obj.save(force_insert=True, using=target_db)
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\ansys\dynamicreporting\core\serverless\base.py", line 46, in wrapper
return func(*args, **kwargs)
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\ansys\dynamicreporting\core\serverless\base.py", line 337, in save
raise e
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\ansys\dynamicreporting\core\serverless\base.py", line 331, in save
obj._orm_instance.save(**kwargs)
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\django\db\models\base.py", line 814, in save
self.save_base(
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\django\db\models\base.py", line 877, in save_base
updated = self._save_table(
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\django\db\models\base.py", line 1020, in _save_table
results = self._do_insert(
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\django\db\models\base.py", line 1061, in _do_insert
return manager._insert(
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\django\db\models\manager.py", line 87, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\django\db\models\query.py", line 1805, in _insert
return query.get_compiler(using=using).execute_sql(returning_fields)
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\django\db\models\sql\compiler.py", line 1822, in execute_sql
cursor.execute(sql, params)
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\django\db\backends\utils.py", line 102, in execute
return super().execute(sql, params)
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\django\db\backends\utils.py", line 67, in execute
return self._execute_with_wrappers(
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\django\db\backends\utils.py", line 80, in _execute_with_wrappers
return executor(sql, params, many, context)
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\django\db\backends\utils.py", line 84, in _execute
with self.db.wrap_database_errors:
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\django\db\utils.py", line 91, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\django\db\backends\utils.py", line 89, in _execute
return self.cursor.execute(sql, params)
File "D:\Testing\Python_environments\pydynamicreporting\ADR_252_dev_venv\lib\site-packages\django\db\backends\sqlite3\base.py", line 328, in execute
return super().execute(query, params)
django.db.utils.OperationalError: no such table: data_session

💻 Which operating system are you using?

Windows

📀 Which ANSYS version are you using?

2025R2

🐍 Which Python version are you using?

3.9

📦 Installed packages

N/A

[viseshrp]

import os
import docutils
from ansys.dynamicreporting.core.serverless import ADR
from ansys.dynamicreporting.core.serverless import (Item ,HTML, Animation, File, Image, Scene, String, Table, Tree)
import yaml

# Extract ansys install location
with open("awp_root.txt", "r") as awpfile:
    lines = awpfile.readlines()
install_loc = os.path.join(lines[0].strip(), "CEI")

def test_init_simple(ansys_installation, db_directory = None, in_memory = False):
    try:
        adr = ADR(
            ansys_installation=ansys_installation,
            debug=True,
            in_memory=in_memory
        )
        adr.setup()
    except Exception as e:
        raise Exception(f"An error occurred initializing ADR: {e}")
    
    return adr

def create_string(adr):
    #Strings
    try:

        item_text = "This section describes the settings for the simulation: initial conditions, solver settings, and such."
        intro_text = adr.create_item(
            String, name="intro_text", content=item_text, tags=f"dp=dp0 section=intro"
        )
    except Exception as e:
        raise Exception(f"An error occurred while creating a string: {e}")
    
def item_info2json(objectSet):
    # exports json file with objectset data generated by test_query_items
    import json
    from ansys.dynamicreporting.core.utils.encoders import PayloaddataEncoder
    for item in objectSet:
        json_dict = {}
        json_dict['type'] = item.type
        json_dict['name'] = item.name
        json_dict['content'] = item.content
        json_dict['tags'] = item.tags
        with open("res_string_uploaded.json", "w") as jsonfile:
            json.dump(json_dict, jsonfile, cls=PayloaddataEncoder)
    
def test_query_items(adr):
    # queries the database for items
    objs = adr.query(query_type=Item)
    print(f"{objs=}")
    item_info2json(objs)

def test_init_in_memory():
    #Tests startup of database providing a database name and generates a list of the directories in the cwd to check no data for the database was written to disk.
    try:
        db_directory=r".\local_report_memory"
        # Initialise API
        adr_obj = test_init_simple(ansys_installation=install_loc, db_directory=db_directory, in_memory=True)
        ## Basic operations:
        # Upload a generic item
        create_string(adr_obj)
        # Query the item
        test_query_items(adr_obj)

        dir_list = os.listdir()

        with open("res_is_db_created.txt", "w") as textfile:
            # Check if database is contained in the generated list
            if db_directory in dir_list:
                textfile.write(f"{db_directory} has been created.")
            else:
                textfile.write(f"{db_directory} has not been created.")

        adr_obj.close()

    except Exception as e:
        raise Exception(f"An error occurred while initialising in memory mode: {e}")

if __name__ == '__main__':
    
    test_init_in_memory()