web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Cannot select a record...
Microsoft Dynamics AX (Archived)

Cannot select a record in On-hand inventory (InventSum). Closed: No. The SQL database has issued an error.

(0) ShareShare
ReportReport
Posted on by Community Member

Hi All,

I have created an AX query and refer it to a List page form. It is working fine on DEV machine but when i open the form on QA server (AX client), it prompts below error:

  • Cannot select a record in On-hand inventory (InventSum). Closed: No. The SQL database has issued an error.
  • SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]Could not allocate space for object 'dbo.SORT temporary run storage:  143453757112320' in database 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

Is it possible that my form or query is not correct? If not then what can be the issue?

Please advise at your earliest. Thanks in advance.

OnHandInventoryError.jpg

Regards,

Shahzaib Arshad.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Cannot select a record in On-hand inventory (InventSum). Closed: No. The SQL database has issued an error.

    Hi Sukrut,

    Thanks for your reply. Let me check this.

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at
    RE: Cannot select a record in On-hand inventory (InventSum). Closed: No. The SQL database has issued an error.

    Your query is unrelated to the error, it is a disk issue for the SQL Server instance.

    Restarting SQL would empty the currently occupied space within TempDB, but it obviously affects any databases running there. If your QA AX environment's DB is the only one, then stop the AOS, restart SQL, start AX, and see if it works.

    Other than the above, you should be looking into the root cause of the issue with your SQL DBA to determine if your TempDB database is sized correctly or not, and what consumes the disks space. You should have a separate TempDB data file for each core (I am using 8x10GB), and about 10-20 GB enough space for TempDB log.

  • Community Member Profile Picture
    Community Member on at
    RE: Cannot select a record in On-hand inventory (InventSum). Closed: No. The SQL database has issued an error.

    What if my query is taking more time to execute? Can this be the possible reason behind this issue?

    As my other queries and forms are working fine on DEV as well as on QA servers.

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at
    RE: Cannot select a record in On-hand inventory (InventSum). Closed: No. The SQL database has issued an error.

    Lack of resources, lack of index/statistics maintenance, or badly designed query (missing covering index, wrong join, not unique filtering criteria) on SQL Server are almost always the cause of performance problems.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans