Cube Builds but gets an error on deployment (DDL300_300: FormatString Line Element cannot appear under...
5. srpna 2012 1:37
I am deploying a cube after changing a number of measures and dimensions. The Cube builds sucessfully (warnings only) with no errors. When the cube deploys I get an error message as follows:
Error 17 The ddl300_300:FormatString element at line 11558, column 41 (namespace http://schemas.microsoft.com/analysisservices/2011/engine/300/300) cannot appear under Envelope/Body/Execute/Command/Batch/Alter/ObjectDefinition/Database/Dimensions/Dimension/Attributes/Attribute.
I am using Visual 2010 and the SQL Server is SQL2008R2.
I think this error means that the XML that is being sent to the server to deploy the cube has an XML element in it in a place that is not expected under the 300/300 engine schema.
How can I fix this? Is there a good way to get to the XML that VS2010 is sending to the server so that I can see what line 11558 column 41 is?
Thank You in advance for any help you can provide
5. srpna 2012 3:42
Ok all... Looks like when I update the FormatString of a couple of Attributes, some fun stuff like this got placed into the dimension file I had:
<ID>Calendar Week End</ID>
<Name>Calendar Week End</Name>
<Source xsi:type="ColumnBinding" dwd:design-time-name="f00052f2-d02d-429e-9160-940633332ee5">
So I just deleted out the "offending" and now I am back in the pink... Perhaps my deployment model was in the 11.0 format? I don't know but I think I am on to other problems.
8. dubna 2013 16:56I ran into a similar issue. What worked for me was to download the latest version of BIDSHelper. I suspect a problem with BIDS or BIDSHelper caused my issue in the first place, but getting the latest version resolved it for me... for now.