Hi everyone,
I have cube on On-prem and cube source also On-prem, my team migrated on-prem cube tables with structure and data to Azure Synapse. after then I'm changed cube source(to azure synapse) and Data Base Name using SSDT, In SSMS I'm changed schema(replaced existing with new schema name) name using alter xml script. After then i tried to process cube getting error as above and showing warning message as The size specified for a binding was too small, resulting in one or more column values being truncated.
Question 1 : I'm working on SSAS Cube 2003 version, Is the Cube support to take source as Azure Synapse ?
Question 2 : warning message showing The size specified for a binding was too small, resulting in one or more column values being truncated, How to increase data size in cube ?
Error :
Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: A severe error occurred on the current command. The results, if any, should be discarded.
Operation cancelled by user.
Operation cancelled by user..Errors in the OLAP storage engine: An error occurred while the <dimension name> attribute of the <dimension col name> dimension from the <DB name> database was being processed.
Warning message :
Errors in the back-end database access module. The size specified for a binding was too small, resulting in one or more column values being truncated.
and upvote
for the same. And, if you have any further query do let us know.