Azure Synapse "Message Type Not Found" error when running stored procedure: Appears when lines of code reach certain line length
Hi, We need some technical guidance from either a Azure Synapse specialist to resolve an issue which we are unable to understand / fix despite running through the sql logic bit-by-bit, line-by-line. Any guidance or help would be much appreciated. We have…
Analysis Services reads data from a data source, but gives connection error while processing multidimensional analysis
I have built an Analysis Services Multidimensional project using Microsoft Visual Studio Professional 2022 with the SQL Server Analysis Services 16.0 extension connected to Analysis Services on a remote SQL Server 2019 instance. The Visual Studio…
Why I cannot open SSAS DataSource Connection String in SSMS 20.2.30.0
Trying to manage Analysis Services Cube Data Source connections via SSMS 20.2.30.0 fails with error "tree node should not be null in DropDownTreeView::GetNodeId Parameter name: node" when I click on the three dots to the right side of the…
SSAS cube project
I added a dimension table to the Data Source View (DSV) and refreshed it. I then processed the cube, but I can't see this new dimension table under "New Dimension" in the cube structure to add it to the cube. I have tried refreshing,…
MDX request to System SSAS cube does not display the results
Hello, I'm trying to do some requests to analyse the usage of our cubes. All requests on $SYSTEM.DISCOVER_SESSIONS made in Microsoft SQL Server Studio or even in PowerShell are working well. However, everytime I try to request…
unable to convert unique identifier
Hi Team, unable to convert this value as an unique identifier and getting null values SELECT try_convert(uniqueidentifier,''9UIC32D1-932-4V03-45E9-FGSGDASASDATY'')testid
"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."
One of the users receive this error. is this issue at our end or at microsofts ?
Question on Dimension Security in SSAS cubes
Dear Team, Looking for help on below technical knowledge. This question is for MSBI - "SQL Server Analysis Server " Is it possible to create a security for entire dimension in "dimension data" tab of "Roles" window. For…
Sql join query with total row
Hi , please help create table #temp (LedgerID INT, Amount Decimal(18,3)) insert into #temp (LedgerID,Amount) values (121,100),(121,250),(129,25),(129,200),(158,100),(158,500),(157,250),(157,100),(48625,1000) CREATE TABLE #temp_table ( cid INT, type…
Analysis Service very slow to connect in SQL Management Studio
Hi all, I have a SQL Server, SSAS and SQL Server Management Studio installed on the same PC. Connecting to the SQL Database Engine in SSMS is very fast. However, connecting to SSAS in SSMS is excruciatingly slow, even though it is just a localhost…
How to copy an SSAS cube
Good day, I have a cube in SSAS for one financial period, that I wish to replicate for a new financial period, how can I achieve this? Please assist Many thanks
SQL Server Agent Job "Process Full in SSAS" throws error without details
We have a Tabular Model deployed in SSAS that worked until three days ago but doesnt anymore. It throws errors when calling full process from a sql server agent job. This is basically the Error Message: Column '' in Table '' contains a duplicate value…
I'm using Visual studio 2022 & creating a tabular model but not able to connect to Azure Data lake blob storage - not even able to see that connector
I'm using Visual studio 2022 & creating a tabular model but not able to connect to Azure Data lake blob storage - not even able to see that connector & attaching the screenshot of the connector image. Compatibility level of the SSAS Tabular…
Deploying the tabular cube failed with a timerunot error
Hello everyone, I'm encountering an issue while deploying the cube. It's failing, as shown in the image below. Can anyone help me with this?
SSAS Dimension Processing: Why use ProcessUpdate when ProcessFull is faster?
I have a question about which processing option should be used for SSAS dimensions. I heard that ProcessFull option is faster than ProcessUpdate, and I found that it is the case. I have a big dimension of a cube, which takes about 90 mins to process…
create sp to populate table from one db to another
Hi, how to create Store procedure to populate data from one database table to another database table and do we need to refresh or it will auto sync
Compiling SSAS, SSRS, and SSIS projects under Build Tools for Visual Studio 2022?
I have a build server using Build Tools for Visual Studio 2022 to compile projects. We have several systems that are currently not using the build server because they use SSAS, SSRS, and SSIS projects. Investigating, it looks like Build Tools does not…
Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893606Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
I have been trying to run kestrel in Visual Studio, and then I got this message: System.AggregateException: 'One or more errors occurred. (A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server…
Modelos tabulares no liberan memoria
Buenos dias, paso a consultar por un problema. Tengo varios modelos tabulares, y cada vez que proceso alguna partición, la memoria de mi servidor llega a 85/90%. Una vez terminado el procesamiento, la memoria queda en esos niveles, por lo que si quiero…