Forum Discussion

RichardS456's avatar
RichardS456
New Member
3 years ago

Error sign when trying to refresh hexagon reporting

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailN...
Hexagon reporting error
jaweher899's avatar
jaweher899
Icon for Impactful Individual rankImpactful Individual
3 years ago

The error message "Could not allocate space for object 'dbo.SORT temporary run storage: 140738639167488' in database 'tempdb' because the 'PRIMARY' filegroup is full" is indicating that the database 'tempdb' is running out of space. This error occurs when SQL Server is unable to allocate sufficient space to perform operations in the tempdb database. To resolve this issue, you may try to do the following:

  1. Delete unnecessary files and data from the tempdb database.

  2. Drop any unused or unnecessary objects within the filegroup of the tempdb database.

  3. Increase the size of the filegroup in the tempdb database.

  4. Set the autogrowth property for existing files in the filegroup of the tempdb database to allow for automatic growth.

It is recommended to consult with a database administrator or your IT support team to resolve this issue.