https://community.fabric.microsoft.com/t5/Report-Server/Error-sign-when-trying-to-refresh-hexagon-reporting/m-p/3063655#M28736 <P>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.<BR />Cluster URI: WABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net<BR />Activity ID: aa66f5f4-b5e5-41f0-b33b-ed34abf5b000<BR />Request ID: 2ba37df2-f7d7-61f9-6aea-f1dc8d215e67<BR />Time: 2023-02-06 11:24:37Z</P> Mon, 06 Feb 2023 11:30:25 GMT RichardS456 2023-02-06T11:30:25Z https://community.fabric.microsoft.com/t5/Report-Server/Error-sign-when-trying-to-refresh-hexagon-reporting/m-p/3063655#M28736 <P>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.<BR />Cluster URI: WABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net<BR />Activity ID: aa66f5f4-b5e5-41f0-b33b-ed34abf5b000<BR />Request ID: 2ba37df2-f7d7-61f9-6aea-f1dc8d215e67<BR />Time: 2023-02-06 11:24:37Z</P> Mon, 06 Feb 2023 11:30:25 GMT https://community.fabric.microsoft.com/t5/Report-Server/Error-sign-when-trying-to-refresh-hexagon-reporting/m-p/3063655#M28736 RichardS456 2023-02-06T11:30:25Z https://community.fabric.microsoft.com/t5/Report-Server/Error-sign-when-trying-to-refresh-hexagon-reporting/m-p/3064049#M28743 <P>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:</P><OL><LI><P>Delete unnecessary files and data from the tempdb database.</P></LI><LI><P>Drop any unused or unnecessary objects within the filegroup of the tempdb database.</P></LI><LI><P>Increase the size of the filegroup in the tempdb database.</P></LI><LI><P>Set the autogrowth property for existing files in the filegroup of the tempdb database to allow for automatic growth.</P></LI></OL><P>It is recommended to consult with a database administrator or your IT support team to resolve this issue.</P> Mon, 06 Feb 2023 14:33:44 GMT https://community.fabric.microsoft.com/t5/Report-Server/Error-sign-when-trying-to-refresh-hexagon-reporting/m-p/3064049#M28743 jaweher899 2023-02-06T14:33:44Z