none
USQL Job throwing system error while inserting to Catlog

    Question

  • I am trying to fetch records by joining few catalog tables and trying to bulk insert those values into another catalog table, Where am getting the below error

    {
    	"jobId": "https://nl1rowpharmaadladev001.azuredatalakeanalytics.net/jobLink/e2a387d3-9ff0-4be1-a623-f8e3b98d68d4",
    	"errors": {
    		"errorId": "E_RUNTIME_SYSTEM_GENERATEDCPPCODEFAILEDTOCOMPILE",
    		"severity": "Error",
    		"component": "RUNTIME",
    		"source": "SYSTEM",
    		"message": "Error Precompiling C++ code: exit code 2[The system cannot find the file specified]\n------\nCommand: ++++++++ %%Path__0%%: [data\\yarnnm\\local\\usercache\\4088ae08-89d5-489f-85b1-cba08f6f8d56\\appcache\\application_1538765250062_1044386\\container_e211_1538765250062_1044386_01_000001\\wd] ++++++++ D:\\data\\CPPSDK\\VS14RTM\\VC\\bin\\cl.exe /nologo /c /bigobj /Bt+ /DWIN32_LEAN_AND_MEAN /MD /W4 /WX /Zi /O2 /Bd /d2cgsummary /EHa /DCOMPILE_NATIVE /wd4125 /wd4627 /wd4800 /wd4702 /DUSE_SSE4_2  /ID:\\data\\CPPSDK\\VS14RTM\\VC\\include /ID:\\data\\CPPSDK\\VS14RTM\\SDK\\include /ID:\\data\\CPPSDK\\VS14RTM\\SDK\\include\\um /ID:\\data\\CPPSDK\\VS14RTM\\SDK\\include\\shared /ID:\\data\\CPPSDK\\VS14RTM\\SDK\\include\\ucrt /ID:\\[%%Path__0%%]\\ /ID:\\[%%Path__0%%]  /Yc /Fo__ScopeCodeGenEngine__.dllNative_pch.obj /Fp__ScopeCodeGenEngine__.dllNative_pch.pch __ScopeCodeGenEngine__.dll.cpp /Fd__ScopeCodeGenEngine__.dllNative_pch.pdb ++++++++\n------\n++++++++ %%Path__0%%: [data\\yarnnm\\local\\usercache\\4088ae08-89d5-489f-85b1-cba08f6f8d56\\appcache\\application_1538765250062_1044386\\container_e211_1538765250062_1044386_01_000001\\wd] ++++++++ __ScopeCodeGenEngine__.dll.cpp\r\nENC_CWD=D:\\[%%Path__0%%]\r\nENC_CL=D:\\data\\CPPSDK\\VS14RTM\\VC\\bin\\cl.exe\r\nENC_SRC=__ScopeCodeGenEngine__.dll.cpp\r\nENC_PDB=D:\\[%%Path__0%%]\\__ScopeCodeGenEngine__.dllNative_pch.pdb\r\nENC_CMD=-nologo -c -bigobj -Bt+ -DWIN32_LEAN_AND_MEAN -MD -W4 -WX -Zi -O2 -Bd -d2cgsummary -EHa -DCOMPILE_NATIVE -wd4125 -wd4627 -wd4800 -wd4702 -DUSE_SSE4_2 -ID:\\data\\CPPSDK\\VS14RTM\\VC\\include -ID:\\data\\CPPSDK\\VS14RTM\\SDK\\include -ID:\\data\\CPPSDK\\VS14RTM\\SDK\\include\\um -ID:\\data\\CPPSDK\\VS14RTM\\SDK\\include\\shared -ID:\\data\\CPPSDK\\VS14RTM\\SDK\\include\\ucrt -ID:\\[%%Path__0%%]\\ -ID:\\[%%Path__0%%] -Yc -FpD:\\[%%Path__0%%]\\__ScopeCodeGenEngine__.dllNative_pch.pch -TP -X\r\n`D:\\data\\CPPSDK\\VS14RTM\\VC\\bin\\c1xx.dll -zm0x00007FF7EC495570 -il D:/data/yarnnm/local/usercache/4088ae08-89d5-489f-85b1-cba08f6f8d56/appcache/application_1538765250062_1044386/container_e211_1538765250062_1044386_01_000001/wd\\_CL_6cf3690c -typedil -f __ScopeCodeGenEngine__.dll.cpp -Ze -D_MSC_EXTENSIONS -Zp16 -ZB64 -D_INTEGRAL_MAX_BITS=64 -pc \\:/ -D_MSC_VER=1900 -D_MSC_FULL_VER=190023506 -D_MSC_BUILD=0 -D_M_AMD64=100 -ZILP448 -D_M_X64=100 -D_WIN64 -D_WIN32 -GS -GR -D_CPPRTTI -Zc:forScope -Zc:wchar_t -nologo -DWIN32_LEAN_AND_MEAN -D_MT -D_DLL -W 4 -WX -Zi -GF -Og -Oi -Ot -Oy -Bd -EHa -D_CPPUNWIND -DCOMPILE_NATIVE -wd 4125 -wd 4627 -wd 4800 -wd 4702 -DUSE_SSE4_2 -I D:\\data\\CPPSDK\\VS14RTM\\VC\\include -I D:\\data\\CPPSDK\\VS14RTM\\SDK\\include -I D:\\data\\CPPSDK\\VS14RTM\\SDK\\include\\um -I D:\\data\\CPPSDK\\VS14RTM\\SDK\\include\\shared -I D:\\data\\CPPSDK\\VS14RTM\\SDK\\include\\ucrt -I D:\\[%%Path__0%%]\\ -I D:\\[%%Path__0%%] -Yc -Fo__ScopeCodeGenEngine__.dllNative_pch.obj -Fp__ScopeCodeGenEngine__.dllNative_pch.pch -Fd__ScopeCodeGenEngine__.dllNative_pch.pdb'\r\n__ScopeCodeGenEngine__.dll.cpp(8707): error C2220: warning treated as error - no 'object' file generated\r\n__ScopeCodeGenEngine__.dll.cpp(8707): warning C4146: unary minus operator applied to unsigned type, result still unsigned\r\ntime(D:\\data\\CPPSDK\\VS14RTM\\VC\\bin\\c1xx.dll)=1.89841s < 17100172299125 - 17100176738238 > BB [D:\\[%%Path__0%%]\\__ScopeCodeGenEngine__.dll.cpp]\r\n ++++++++\n",
    		"details": "",
    		"description": "A build error has occurred when C++ compiler or linker tried to build generated native code.",
    		"resolution": "Please contact support.",
    		"helpLink": "",
    		"filePath": "",
    		"lineNumber": -1,
    		"startOffset": -1,
    		"endOffset": -1
    	}
    }

    Inner Error : 

    Message
    Error Precompiling C++ code: exit code 2[The system cannot find the file specified] ------ Command: ++++++++ %%Path__0%%: [data\yarnnm\local\usercache\4088ae08-89d5-489f-85b1-cba08f6f8d56\appcache\application_1538765250062_1044386\container_e211_1538765250062_1044386_01_000001\wd] ++++++++ D:\data\CPPSDK\VS14RTM\VC\bin\cl.exe /nologo /c /bigobj /Bt+ /DWIN32_LEAN_AND_MEAN /MD /W4 /WX /Zi /O2 /Bd /d2cgsummary /EHa /DCOMPILE_NATIVE /wd4125 /wd4627 /wd4800 /wd4702 /DUSE_SSE4_2 /ID:\data\CPPSDK\VS14RTM\VC\include /ID:\data\CPPSDK\VS14RTM\SDK\include /ID:\data\CPPSDK\VS14RTM\SDK\include\um /ID:\data\CPPSDK\VS14RTM\SDK\include\shared /ID:\data\CPPSDK\VS14RTM\SDK\include\ucrt /ID:\[%%Path__0%%]\ /ID:\[%%Path__0%%] /Yc /Fo__ScopeCodeGenEngine__.dllNative_pch.obj /Fp__ScopeCodeGenEngine__.dllNative_pch.pch __ScopeCodeGenEngine__.dll.cpp /Fd__ScopeCodeGenEngine__.dllNative_pch.pdb ++++++++ ------ ++++++++ %%Path__0%%: [data\yarnnm\local\usercache\4088ae08-89d5-489f-85b1-cba08f6f8d56\appcache\application_1538765250062_1044386\container_e211_1538765250062_1044386_01_000001\wd] ++++++++ __ScopeCodeGenEngine__.dll.cpp ENC_CWD=D:\[%%Path__0%%] ENC_CL=D:\data\CPPSDK\VS14RTM\VC\bin\cl.exe ENC_SRC=__ScopeCodeGenEngine__.dll.cpp ENC_PDB=D:\[%%Path__0%%]\__ScopeCodeGenEngine__.dllNative_pch.pdb ENC_CMD=-nologo -c -bigobj -Bt+ -DWIN32_LEAN_AND_MEAN -MD -W4 -WX -Zi -O2 -Bd -d2cgsummary -EHa -DCOMPILE_NATIVE -wd4125 -wd4627 -wd4800 -wd4702 -DUSE_SSE4_2 -ID:\data\CPPSDK\VS14RTM\VC\include -ID:\data\CPPSDK\VS14RTM\SDK\include -ID:\data\CPPSDK\VS14RTM\SDK\include\um -ID:\data\CPPSDK\VS14RTM\SDK\include\shared -ID:\data\CPPSDK\VS14RTM\SDK\include\ucrt -ID:\[%%Path__0%%]\ -ID:\[%%Path__0%%] -Yc -FpD:\[%%Path__0%%]\__ScopeCodeGenEngine__.dllNative_pch.pch -TP -X `D:\data\CPPSDK\VS14RTM\VC\bin\c1xx.dll -zm0x00007FF7EC495570 -il D:/data/yarnnm/local/usercache/4088ae08-89d5-489f-85b1-cba08f6f8d56/appcache/application_1538765250062_1044386/container_e211_1538765250062_1044386_01_000001/wd\_CL_6cf3690c -typedil -f __ScopeCodeGenEngine__.dll.cpp -Ze -D_MSC_EXTENSIONS -Zp16 -ZB64 -D_INTEGRAL_MAX_BITS=64 -pc \:/ -D_MSC_VER=1900 -D_MSC_FULL_VER=190023506 -D_MSC_BUILD=0 -D_M_AMD64=100 -ZILP448 -D_M_X64=100 -D_WIN64 -D_WIN32 -GS -GR -D_CPPRTTI -Zc:forScope -Zc:wchar_t -nologo -DWIN32_LEAN_AND_MEAN -D_MT -D_DLL -W 4 -WX -Zi -GF -Og -Oi -Ot -Oy -Bd -EHa -D_CPPUNWIND -DCOMPILE_NATIVE -wd 4125 -wd 4627 -wd 4800 -wd 4702 -DUSE_SSE4_2 -I D:\data\CPPSDK\VS14RTM\VC\include -I D:\data\CPPSDK\VS14RTM\SDK\include -I D:\data\CPPSDK\VS14RTM\SDK\include\um -I D:\data\CPPSDK\VS14RTM\SDK\include\shared -I D:\data\CPPSDK\VS14RTM\SDK\include\ucrt -I D:\[%%Path__0%%]\ -I D:\[%%Path__0%%] -Yc -Fo__ScopeCodeGenEngine__.dllNative_pch.obj -Fp__ScopeCodeGenEngine__.dllNative_pch.pch -Fd__ScopeCodeGenEngine__.dllNative_pch.pdb' __ScopeCodeGenEngine__.dll.cpp(8707): error C2220: warning treated as error - no 'object' file generated __ScopeCodeGenEngine__.dll.cpp(8707): warning C4146: unary minus operator applied to unsigned type, result still unsigned time(D:\data\CPPSDK\VS14RTM\VC\bin\c1xx.dll)=1.89841s < 17100172299125 - 17100176738238 > BB [D:\[%%Path__0%%]\__ScopeCodeGenEngine__.dll.cpp] ++++++++

     
    Thursday, November 1, 2018 9:28 AM

All replies

  • Hello,

    Could you send us an AzCommunity@microsoft.com with your subscription ID and the URL to this post?  We would like to take a closer look at this issue.

    Thanks!

    Monday, November 5, 2018 6:45 PM
    Moderator