TeamCity/.sqlproj build via MSBuild -- FAILED -


it started vs2017 runner type within tc. failing without errors or hints (except (default targets) -- failed. message on solution level). narrowed down .sqlproj'ects. these not building via msbuild, compile within vs2017 on build agent. blaming ssdt it... guess checked everything. problem bubbles solution level within tc build:

enter image description here

i noticed vs2017 ssdt comes vs setup. "workload" "data storage , processing" installed , "sql server data tools" under "individual components". noticed on https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt sentence "if using ssdt visual studio 2017, install , rs components". did it. nothing changed. ssdt installed separately previous versions.

this stack related didn't me.

any other ideas?

i came step further. beside vs build tools installed on build agent , teamcity's runner vs2017 uses msbuild build tools. can see above reproducing issue msbuild build tools well. if pick msbuild "version" of vs2017 works charm (as right within vs). make short:

does not work

c:\program files (x86)\microsoft visual studio\2017\buildtools\msbuild\15.0\bin

works

c:\program files (x86)\microsoft visual studio\2017\professional\msbuild\15.0\bin

i found blog post lukie briner, last paragraph pointed me solution (thank buddy!).

still don't know why/how can happen, maybe related order of installations of build tools, ssdt, visual studio etc.?

the reason: ssdt missing in build tools , version of msbuild.

what have done:

copy ssdt folder from

c:\program files (x86)\microsoft visual studio\2017\professional\msbuild\microsoft\visualstudio\v15.0

to

c:\program files (x86)\microsoft visual studio\2017\buildtools\msbuild\microsoft\visualstudio\v15.0.

wow! see real error message:

build-tools-msbuild-error-message

now had copy sqldb , sqleditor (i think sqlcommon existed in destination folder, if not should copied) from

c:\program files (x86)\microsoft visual studio\2017\professional\common7\ide\extensions\microsoft

to

c:\program files (x86)\microsoft visual studio\2017\buildtools\common7\ide\extensions\microsoft

and boom...

success

and yes, vs2017 runner teamcity happy it.


Comments

Post a Comment

Popular posts from this blog

python - Selenium remoteWebDriver (& SauceLabs) Firefox moseMoveTo action exception -

while performing simple hover test on firefox through selenium (3.4.0) python bindings (3.4.3) using of available os in saucelabs (except linux, latest available firefox version old), performing following actionchain: hover = actionchains(driver) hover.move_to_element(elm_men_menu).perform() it throws following error: taceback: file [...] in testhover hover.perform() file "/usr/local/lib/python2.7/dist-packages/selenium/webdriver/common/action_chains.py", line 80, in perform action() file "/usr/local/lib/python2.7/dist-packages/selenium/webdriver/common/action_chains.py", line 290, in <lambda> command.move_to, {'element': to_element.id})) file "/usr/local/lib/python2.7/dist-packages/selenium/webdriver/remote/webdriver.py", line 256, in execute self.error_handler.check_response(response) file "/usr/local/lib/python2.7/...
Read more

html - How to custom Bootstrap grid height? -

why bootstrap grid has height 591.067 ? did height came ? .main-post { padding: 20px; background-color: #fff; border: 1px solid #d8d8d8; margin-bottom: 100px; } .main-post .post-categories { margin-bottom: 10px } .main-post h3 { margin: 0 0 10px; color: #777; letter-spacing: -1px; font-weight: bold } .main-post .post-author, .main-post .post-date, .main-post .post-comments { font-size: 12px } .main-post img { display: block; margin: 10px 0; } .main-post .post-summary { line-height: 1.7; color: #888 } .main-post { color: #999 } <div class="col-sm-6"> <div class="main-post"> <h3 class="post-title"> <a href="#"> post title </a> </...
Read more

transpose - Maple isnt executing function but prints function term -

im using maple im in worksheetmode tried using maple input , 2d input , want transpose matrix a: := `<|>`(`<,>`(1, .5, -2), `<,>`(.5, 9/4+b, 5+3*b), `<,>`(-2, 5+3*b, 18+9*b+4*a)); b:= transpose(a); when exectute sheet dont translated values, there same input. matrix looks same input matrix plus function term. you can see picture in following link: why arent functions executed? meanwhile b:=a^+ doing right way , transposed matrix. other functions return function body instead needed values... if using 2d input mode (the default) space you've got between transpose , bracketed (b) interpreted multiplcation. rid of such space. also, either load package @ start of document like, with(linearalgebra): before calling transpose command package, or call it's full name like, linearalgebra:-transpose(b);
Read more