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_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Microsoft SQL: Could not allocate space for object 'dbo.SORT temporary run storage: 140738639167488' 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."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"17"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":".;CXSRetail"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Could not allocate space for object 'dbo.SORT temporary run storage: 140738639167488' 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."}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"1105"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Transactions.
Cluster URI: WABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net
Activity ID: aa66f5f4-b5e5-41f0-b33b-ed34abf5b000
Request ID: 2ba37df2-f7d7-61f9-6aea-f1dc8d215e67
Time: 2023-02-06 11:24:37Z

Hexagon reporting error

1 Reply

  • 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.