Ends in:
2 DAYS
18 HRS
17 MIN
17 SEC
Ends in:
2 D
18 H
17 M
17 S
Open Closed

Apb Suite Load Entity From Database Error ( Cannot retrieve tables ) #2802


User avatar
0
MrPaul created

When using ABP Suite Load Entity from Database functionality, it looks that it does not support some schema or table names. The test case has the following [schema].[table] format across the whole database: [SOME_ASSET_DATA].[SOME_SYSTEM_KEY_MAPPING].

Would this kind of format be problematic?

  • ABP CLI version: v5.1.4
  • ABP Suite version: v5.0.0
  • Data Source: MS SQL Server
  • Exception message and stack trace: Cannot retrieve tables! Cannot convert table to entity! Object reference not set to an instance of an object.
  • Steps to reproduce the issue: Load Entity From Database > Set Connection String > Connect

7 Answer(s)
  • User Avatar
    0
    alper created
    Support Team Director

    can you send us the create script of your database with the problematic table. we'll try to create the same schema on our local to see where this occurs.

  • User Avatar
    0
    MrPaul created

    Can I send a .dacpac privately to an email address? :)

  • User Avatar
    0
    alper created
    Support Team Director

    I didn't work with a *.dacpac file. If you explain how can I create the same tables in my oracle server I can solve the issue. send your file or creation scripts to support@abp.io with this support ticket link

  • User Avatar
    0
    MrPaul created

    After generating the script for the entire database and running each piece individually I stumbled upon something I concluded is not supported by the framework:

    CREATE TABLE [ASSET_HIERARCHY](
        [ASSET_LEVEL] [hierarchyid] NOT NULL,
    ) ON [PRIMARY]
    

    There are official libraries that adds support for this MS SQL type:

  • User Avatar
    0
    alper created
    Support Team Director

    oh that's not supported by Suite. You can skip that field and add it manually

  • User Avatar
    0
    MrPaul created

    That's the thing!

    The moment that field shows up in the database the whole functionality goes down, so the error shows up and then no table is available to be selected, no column to select/deselect.

    I would gladly contribute to the suite project, but I sense that's only available for internals.

  • User Avatar
    0
    alper created
    Support Team Director

    created an internal issue (9636) for this

Made with ❤️ on ABP v9.1.0-preview. Updated on December 02, 2024, 12:35