question

RamakrishnaMandalapu-6041 avatar image
0 Votes"
RamakrishnaMandalapu-6041 asked RamakrishnaMandalapu-6041 commented

Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: 111202;Query QID3142316 has been cancelled. Operation cancelled by user..

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 :

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

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

azure-synapse-analyticssql-server-analysis-servicessql-server-migrationsql-server-migration-assistant
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @RamakrishnaMandalapu-6041 ,

Just checking in to see if the below answer helped. If this answers your query, do click 130616-image.png and upvote 130671-image.png for the same. And, if you have any further query do let us know.

0 Votes 0 ·

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered RamakrishnaMandalapu-6041 commented

Hi @RamakrishnaMandalapu-6041 ,

According to your description and the error messages, it seems that the data length have changed after migrated to Azure Synapse, while the data length in you SSAS cube did not change, thus you might encounter this error.

You can change the data size as shown below.
182507-1.png

data-types-in-analysis-services

Or you may find out the specific dimensions which have this error , remove and add it back to the cube, then re-deploy it to your SSAS.

Regards,

Zoe


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



1.png (25.0 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Actually we didn't change any data type or Data Size in migration.

I didn't saw above option in my SSAS cube and dimensions properties.

Can you please explain step by process how to change Data Size?


Really is the issue related to Cube Data Size or any other issue ?



0 Votes 0 ·