locked
Retail Churn Sample Experiment in Azure ML Lab errors out at Execute Python Steps RRS feed

  • Question

  • When I run the sample Retail Churn Template as experiment, it errors out at the Execute Python Script stage.

    Output Log:

    [ModuleOutput] [Start:ConvertTo]
    [ModuleOutput] [Stop:ConvertTo] Elapsed: 0:00:00.3261943
    [ModuleOutput] [Start:ConvertTo]
    [ModuleOutput] [Stop:ConvertTo] Elapsed: 0:00:00.0000598
    [ModuleOutput] Verifying environment for Python execution
    [ModuleOutput] Locating Python 2.7.11
    [ModuleOutput] Available versions: 2.7.11.1
    [ModuleOutput] Protocol::BeginExecute
    [ModuleOutput] Protocol::GenerateInputs
    [ModuleOutput] [Start:WriteToFile]
    [ModuleOutput] [Stop:WriteToFile] Elapsed: 0:00:02.8571722
    [ModuleOutput] [Start:WriteToFile]
    [ModuleOutput] [Stop:WriteToFile] Elapsed: 0:00:00.0050144
    [ModuleOutput] Moving static resource from ..\..\Script Bundle\Script Bundle.zip to W:\Temp\7854aa0035fd49d3a29ba4931bf764e7\temp\Script Bundle.zip
    [ModuleOutput] Protocol::ConstructScript
    [ModuleOutput] Protocol::InvokeLanguage
    [Error]         Caught exception while executing function: Traceback (most recent call last):
    [Information]         Running with Python 2.7.11 |Anaconda 4.0.0 (64-bit)| (default, Feb 16 2016, 09:58:36) [MSC v.1500 64 bit (AMD64)]
    [Information]         (WindowsError(2, 'The system cannot find the file specified'), '(ignoring)')
    [Information]         RReader/__init__.py
    [Information]         BinaryIO/__init__.py
    [Information]         Arg Index [0] = [C:\server\invokepy.py]
    [Information]         Arg Index [1] = [--batch]
    [Information]         Arg Index [2] = [C:\temp]
    [Information]         Arg Index [3] = [64ddb200d11f407ebecfac9a2553d43a]
    [Information]         Arg Index [4] = [2]
    [Information]         Arg Index [5] = [b1e329b5d7874abbac1412f5c8b9efcd.xdr]
    [Information]         Arg Index [6] = [37d4bc4dc8d3499c9b56b71b97deee52.xdr]
    [Information]         Arg Index [7] = [1]
    [Information]         Arg Index [8] = [.maml.oport1]
    [Information]         Started in [C:\temp]
    [Information]         Running in [C:\temp]
    [Information]         Executing 64ddb200d11f407ebecfac9a2553d43a with inputs ['b1e329b5d7874abbac1412f5c8b9efcd.xdr', '37d4bc4dc8d3499c9b56b71b97deee52.xdr'] and generating outputs ['.maml.oport1']
    [Information]         Extracting Script Bundle.zip to .\Script Bundle
    [Information]         File Name                                             Modified             Size
    [Information]         RetailChurnTemplateUtility.py                  2015-11-17 13:43:54        21271
    [Information]         [ READING ] 0:00:15.812000
    [Error]           File "C:\server\invokepy.py", line 199, in batch
    [Error]             odfs = mod.azureml_main(*idfs)
    [Error]           File "C:\temp\64ddb200d11f407ebecfac9a2553d43a.py", line 40, in azureml_main
    [Error]             dataframe1['Timestamp']= dataframe1.apply(lambda x : dt.datetime.fromtimestamp(x['Timestamp']).strftime('%Y-%m-%d'), axis=1)
    [Error]           File "C:\pyhome\lib\site-packages\pandas\core\frame.py", line 4042, in apply
    [Error]             return self._apply_standard(f, axis, reduce=reduce)
    [Error]           File "C:\pyhome\lib\site-packages\pandas\core\frame.py", line 4138, in _apply_standard
    [Error]             results[i] = func(v)
    [Error]           File "C:\temp\64ddb200d11f407ebecfac9a2553d43a.py", line 40, in <lambda>
    [Error]             dataframe1['Timestamp']= dataframe1.apply(lambda x : dt.datetime.fromtimestamp(x['Timestamp']).strftime('%Y-%m-%d'), axis=1)
    [Error]         TypeError: ('a float is required', u'occurred at index 0')
    [Error]         Process returned with non-zero exit code 1
    [Stop]     DllModuleMethod::Execute. Duration = 00:00:39.9160594
    [Critical]     Error: Error 0085: The following error occurred during script evaluation, please view the output log for more information:
    ---------- Start of error message from Python interpreter ----------
    Caught exception while executing function: Traceback (most recent call last):
      File "C:\server\invokepy.py", line 199, in batch
        odfs = mod.azureml_main(*idfs)
      File "C:\temp\64ddb200d11f407ebecfac9a2553d43a.py", line 40, in azureml_main
        dataframe1['Timestamp']= dataframe1.apply(lambda x : dt.datetime.fromtimestamp(x['Timestamp']).strftime('%Y-%m-%d'), axis=1)
      File "C:\pyhome\lib\site-packages\pandas\core\frame.py", line 4042, in apply
        return self._apply_standard(f, axis, reduce=reduce)
      File "C:\pyhome\lib\site-packages\pandas\core\frame.py", line 4138, in _apply_standard
        results[i] = func(v)
      File "C:\temp\64ddb200d11f407ebecfac9a2553d43a.py", line 40, in <lambda>
        dataframe1['Timestamp']= dataframe1.apply(lambda x : dt.datetime.fromtimestamp(x['Timestamp']).strftime('%Y-%m-%d'), axis=1)
    TypeError: ('a float is required', u'occurred at index 0')
    Process returned with non-zero exit code 1
    
    ---------- End of error message from Python  interpreter  ----------
    [Critical]     {"InputParameters":{"DataTable":[{"Rows":252204,"Columns":13,"estimatedSize":91922432,"ColumnTypes":{"System.Int32":5,"System.String":6,"System.DateTime":1,"System.Double":1},"IsComplete":true,"Statistics":{"0":[1395659.5128943236,1586046.0,1113.0,2179605.0,609476.94730008417,10000.0,0.0],"1":[11,0],"2":[8,0],"3":[1,0],"4":[1,0],"5":[126101.5,126101.5,0.0,252203.0,72805.167982774408,252204.0,0.0],"6":[1229770.6395140442,1233476.0,817747.0,1635482.0,235099.20429742028,252204.0,0.0],"7":[120,0],"8":[4468390512676.4014,4710420000000.0,20008819.0,9789580000000.0,1679564087829.9646,3972.0,0.0],"9":[1.3856917416060015,1.0,1.0,1200.0,3.705732324562959,62.0,0.0],"10":[130.91138919287562,76.0,1.0,70589.0,388.14216949190478,1602.0,0.0],"11":[1,0],"12":[1,0]}},{"Rows":1,"Columns":2,"estimatedSize":483328,"ColumnTypes":{"System.Int32":2},"IsComplete":true,"Statistics":{"0":[21.0,21.0,21.0,21.0,"NaN",1.0,0.0],"1":[0.0,0.0,0.0,0.0,"NaN",1.0,0.0]}}],"Generic":{"bundlePath":"..\\..\\Script Bundle\\Script Bundle.zip","pyLibVersion":"Anaconda40Python2711"},"Unknown":["Key: rStreamReader, ValueType : System.IO.StreamReader"]},"OutputParameters":[],"ModuleType":"LanguageWorker","ModuleVersion":" Version=6.0.0.0","AdditionalModuleInfo":"LanguageWorker, Version=6.0.0.0, Culture=neutral, PublicKeyToken=69c3241e6f0468ca;Microsoft.MetaAnalytics.LanguageWorker.LanguageWorkerClientPythonSNR;RunPySNR","Errors":"Microsoft.Analytics.Exceptions.ErrorMapping+ModuleException: Error 0085: The following error occurred during script evaluation, please view the output log for more information:\r\n---------- Start of error message from Python interpreter ----------\r\nCaught exception while executing function: Traceback (most recent call last):\r\n  File \"C:\\server\\invokepy.py\", line 199, in batch\r\n    odfs = mod.azureml_main(*idfs)\r\n  File \"C:\\temp\\64ddb200d11f407ebecfac9a2553d43a.py\", line 40, in azureml_main\r\n    dataframe1['Timestamp']= dataframe1.apply(lambda x : dt.datetime.fromtimestamp(x['Timestamp']).strftime('%Y-%m-%d'), axis=1)\r\n  File \"C:\\pyhome\\lib\\site-packages\\pandas\\core\\frame.py\", line 4042, in apply\r\n    return self._apply_standard(f, axis, reduce=reduce)\r\n  File \"C:\\pyhome\\lib\\site-packages\\pandas\\core\\frame.py\", line 4138, in _apply_standard\r\n    results[i] = func(v)\r\n  File \"C:\\temp\\64ddb200d11f407ebecfac9a2553d43a.py\", line 40, in <lambda>\r\n    dataframe1['Timestamp']= dataframe1.apply(lambda x : dt.datetime.fromtimestamp(x['Timestamp']).strftime('%Y-%m-%d'), axis=1)\r\nTypeError: ('a float is required', u'occurred at index 0')\r\nProcess returned with non-zero exit code 1\r\n\r\n---------- End of error message from Python  interpreter  ----------\r\n   at Microsoft.Analytics.Exceptions.ErrorMapping.Throw(ExceptionID id, Object[] arguments)\r\n   at Microsoft.MetaAnalytics.LanguageWorker.LanguageWorkerClient.Execute(LanguageWorker worker, IReadOnlyDictionary`2 workspaceInputs, IReadOnlyDictionary`2 workspaceOutputs, ISet`1 resourcePaths) in m:\\AzureMLVS15-004\\_work\\117\\s\\Product\\Source\\Modules\\LanguageWorker\\LanguageWorker.Dll\\Client.cs:line 104\r\n   at Microsoft.MetaAnalytics.LanguageWorker.LanguageWorkerClient.DefaultInterfaceRunImpl(LanguageSettings settings, DataTable dataset1, DataTable dataset2, String[] bundlePath) in m:\\AzureMLVS15-004\\_work\\117\\s\\Product\\Source\\Modules\\LanguageWorker\\LanguageWorker.Dll\\Client.cs:line 68\r\n   at Microsoft.MetaAnalytics.LanguageWorker.LanguageWorkerClientPythonSNR.RunPySNRImpl(DataTable dataset1, DataTable dataset2, String bundlePath, StreamReader rStreamReader, ExecutePyScriptExternalResource source, String url, ExecutePyScriptGitHubRepositoryType githubRepoType, SecureString accountToken, ExecutePyScriptPyVer pyLibVersion) in m:\\AzureMLVS15-004\\_work\\117\\s\\Product\\Source\\Modules\\LanguageWorker\\LanguageWorker.Dll\\EntryPoints\\ExecutePyImpl.cs:line 109\r\n   at Microsoft.MetaAnalytics.LanguageWorker.LanguageWorkerClientPythonSNR.RunPySNR(DataTable dataset1, DataTable dataset2, String bundlePath, StreamReader rStreamReader, ExecutePyScriptPyVer pyLibVersion) in m:\\AzureMLVS15-004\\_work\\117\\s\\Product\\Source\\Modules\\LanguageWorker\\LanguageWorker.Dll\\EntryPoints\\PythonEntryPoint.cs:line 102","Warnings":[],"Duration":"00:00:39.9073909"}
    Module finished after a runtime of 00:00:40.2662964 with exit code -2
    Module failed due to negative exit code of -2
    
    Record Ends at UTC 05/22/2020 11:19:24.
    

    Friday, May 22, 2020 11:39 AM

All replies

  • Hi,

    Are you referring to this sample experiment?

    Regards,

    GiftA-MSFT.

    If a post helps to resolve your issue, please click “Mark as Answer” and/or “Vote as helpful”. By marking a post as Answered and/or Helpful, you help others find the answer faster.  Thanks.

    Friday, May 22, 2020 7:55 PM
  • Hi,

    Following up on the above inquiry. Thanks.

    Regards,

    GiftA-MSFT.

    If a post helps to resolve your issue, please click “Mark as Answer” and/or “Vote as helpful”. By marking a post as Answered and/or Helpful, you help others find the answer faster.  Thanks.

    Tuesday, May 26, 2020 2:42 PM