通过SQL代理作业进行SSAS完整过程 [英] SSAS Full Process via SQL Agent Job
问题描述
运行到我能够通过DAX而不是XMLA处理多维数据集的问题。 运行一个计划的SQL代理作业，似乎处理所有表，但最后会抛出警告代码，使其显示作业失败。 我已经尝试过
来使用下面脚本中的IgnoreError块我无法找到一个能够抑制此错误的元素。   将我当前的脚本复制到底部，但它并没有压制实际的警告信息，任何人都对
我有什么想法可以抑制这个？
警告WarningCode =" 1094320131" Description ="函数MAX接受一个求值为数字或日期的参数，不能使用String类型的值。" Source =" Microsoft SQL Server 2016 Analysis Services" HelpFile ="">
&NBSP; &NBSP; &NBSP; < Location xmlns =" http://schemas.microsoft.com/analysisservices/2003/engine"的xmlns：DDL2 = QUOT; HTTP：//schemas.microsoft.com/analysisservices/2003/engine/2"的xmlns：ddl2_2 = QUOT; HTTP：//schemas.microsoft.com/analysisservices/2003/engine/2/2"
xmlns：ddl100 =" http://schemas.microsoft.com/analysisservices/2008/engine/100"的xmlns：ddl100_100 = QUOT; HTTP：//schemas.microsoft.com/analysisservices/2008/engine/100/100"的xmlns：ddl200 = QUOT; HTTP：//schemas.microsoft.com/analysisservices/2010/engine/200"
xmlns：ddl200_200 =" http://schemas.microsoft.com/analysisservices/2010/engine/200/200"的xmlns：ddl300 = QUOT; HTTP：//schemas.microsoft.com/analysisservices/2011/engine/300"的xmlns：ddl300_300 = QUOT; HTTP：//schemas.microsoft.com/analysisservices/2011/engine/300/300"
xmlns：ddl400 =" http://schemas.microsoft.com/analysisservices/2012/engine/400"的xmlns：ddl400_400 = QUOT; HTTP：//schemas.microsoft.com/analysisservices/2012/engine/400/400"的xmlns：ddl410 = QUOT; HTTP：//schemas.microsoft.com/analysisservices/2012/engine/410"
xmlns：ddl410_410 =" http://schemas.microsoft.com/analysisservices/2012/engine/410/410"的xmlns：ddl500 = QUOT; HTTP：//schemas.microsoft.com/analysisservices/2013/engine/500" xmlns：ddl500_500 =" http://schemas.microsoft.com/analysisservices/2013/engine/500/500">
&NBSP; &NBSP; &NBSP; &NBSP; <开始>
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < Line> 6< / Line>
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; <列> 47< /列>
&NBSP; &NBSP; &NBSP; &NBSP; < /开始>
&NBSP; &NBSP; &NBSP; &NBSP; <结束>
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < Line> 6< / Line>
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; <列> 68< /列>
&NBSP; &NBSP; &NBSP; &NBSP; < / End>
&NBSP; &NBSP; &NBSP; &NBSP; < LineOffset> 179< / LineOffset>
&NBSP; &NBSP; &NBSP; &NBSP; < TextLength> 22< / TextLength>
&NBSP; &NBSP; &NBSP; &NBSP; < ddl200：SourceObject>
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < ddl200：Cube>型号< / ddl200：多维数据集>
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < ddl200：MeasureGroup> Pipeline< / ddl200：MeasureGroup>
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < ddl200：MemberName>管道网址M< / ddl200：会员名称>
&NBSP; &NBSP; &NBSP; &NBSP; < / ddl200：SourceObject>
&NBSP; &NBSP; &NBSP; < / Location>
&NBSP; &NBSP; < /警告>
&NBSP; < /邮件>
SCRIPT：
< Process xmlns =" http：//schemas.microsoft.com/analysisservices/2003/engine">
< ErrorConfiguration xmlns：xsd =" http：//www.w3.org/2001/XMLSchema"的xmlns：的xsi = QUOT; HTTP：//www.w3.org/2001/XMLSchema-instance"的xmlns：DDL2 = QUOT; HTTP：//schemas.microsoft.com/analysisservices/2003/engine/2"
xmlns：ddl2_2 =" http://schemas.microsoft.com/analysisservices/2003/engine/2/2">
< KeyNotFound> IgnoreError< / KeyNotFound>
< NullKeyNotAllowed> IgnoreError< / NullKeyNotAllowed>
< / ErrorConfiguration>
<类型> ProcessFull< /类型>
<对象>
< DatabaseID>仅限机构服务数据表格< / DatabaseID>
< ; / object>
< / Process>
您好RSBHM，
感谢您的提问。
根据上面的警告信息，问题来自measureGroup"Pipeline"， MemberName"管道URL M"在立方体"模型"中。此外，它告诉我们函数MAX采用一个参数来计算数字或日期，并且
不能使用String类型的值。基于此，我们可以得出结论，该问题属于数据类型转换问题，因此请进一步检查此问题。
最好的问候，
威尔
Running in to an issue where I'm able to process a cube via DAX but not XMLA. Have a scheduled SQL agent job that runs, appears to process all the tables but throws a warning code at the end making it appear the job failed. I've tried to use the IgnoreError block in the below script I can't find an element that is value that suppresses this error. Copied my current script down at the bottom, but it's not suppressing the actual warning message, anyone have any ideas on how I can suppress this?
Warning WarningCode="1094320131" Description="The function MAX takes an argument that evaluates to numbers or dates and cannot work with values of type String." Source="Microsoft SQL Server 2016 Analysis Services" HelpFile=""><Location xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100="http://schemas.microsoft.com/analysisservices/2008/engine/100" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200" xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300" xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300" xmlns:ddl400="http://schemas.microsoft.com/analysisservices/2012/engine/400" xmlns:ddl400_400="http://schemas.microsoft.com/analysisservices/2012/engine/400/400" xmlns:ddl410="http://schemas.microsoft.com/analysisservices/2012/engine/410" xmlns:ddl410_410="http://schemas.microsoft.com/analysisservices/2012/engine/410/410" xmlns:ddl500="http://schemas.microsoft.com/analysisservices/2013/engine/500" xmlns:ddl500_500="http://schemas.microsoft.com/analysisservices/2013/engine/500/500">
<Start>
<Line>6</Line>
<Column>47</Column>
</Start>
<End>
<Line>6</Line>
<Column>68</Column>
</End>
<LineOffset>179</LineOffset>
<TextLength>22</TextLength>
<ddl200:SourceObject>
<ddl200:Cube>Model</ddl200:Cube>
<ddl200:MeasureGroup>Pipeline</ddl200:MeasureGroup>
<ddl200:MemberName>Pipeline URL M</ddl200:MemberName>
</ddl200:SourceObject>
</Location>
</Warning>
</Messages>
SCRIPT:
<Process xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"><ErrorConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2">
<KeyNotFound>IgnoreError</KeyNotFound>
<NullKeyNotAllowed>IgnoreError</NullKeyNotAllowed>
</ErrorConfiguration>
<Type>ProcessFull</Type>
<Object>
<DatabaseID>Institutional Services Data Only Tabular</DatabaseID>
</Object>
</Process>
Hi RSBHM,
Thanks for your question.
Per the warning message above, the issue is from the measureGroup "Pipeline", MemberName "Pipeline URL M" in the cube "Model". Also, it told us that the function MAX takes an argument that evaluates to numbers or dates and cannot work with values of type String. Based on this, we could conclude that the issue belongs to data type conversion issue, so please take a further check about this.
Best Regards,
Will
这篇关于通过SQL代理作业进行SSAS完整过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
