The column %1’s datatype %2 with precision %3 scale %4 is not supported

Hello there!

Today let’s talk about a common error in MicroStrategy while mapping a new Attribute:

The column %1’s datatype %2 with precision %3 scale %4 is not supported…

pic1

Sometimes MicroStrategy can’t get the exact data type from Database while creating a new form attribute.

It’s always a good idea to take a look at “Column Alias” while editing or creating a new attribute, because an unknown data type could appears there, just like the image below:

pic3

That is the reason that makes this error happens. So, lets solve this problem!

1. Edit your attribute -> Click on Modify -> click on Column Alias tab -> click “Modify” -> Click on “New” button” -> Give a name and the correct data type.

pic2

pic4

pic5

pic6

 

After that, update your schema and you will be fine again!

Hope it helps!

God bless you!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s