CIP_GoogleSheet_log.txt

2019-02-28 12:53:59.188354 --- Script ran successfully
2019-02-28 12:53:59.194349 --- This process took 56.59048557281494 seconds
2019-02-28 20:01:41.573337 --- Script ran successfully
2019-02-28 20:01:41.588941 --- This process took 81.08369755744934 seconds
2019-03-01 08:55:43 --- Script ran successfully
2019-03-01 08:55:43 --- This process took 71.34 seconds
2019-03-01 17:08:54 --- Script ran successfully
2019-03-01 17:08:54 --- This process took 84.03 seconds
2019-03-01 20:01:47 --- Script ran successfully
2019-03-01 20:01:47 --- This process took 85.22 seconds
2019-03-02 20:01:10 --- Script ran successfully
2019-03-02 20:01:10 --- This process took 66.45 seconds
2019-03-03 20:01:48 --- Script ran successfully
2019-03-03 20:01:48 --- CIP Google Sheet updates have been written to CSV for future checks.
2019-03-03 20:01:48 --- This process took 97.08 seconds
2019-03-05 20:02:05 --- Script ran successfully
2019-03-05 20:02:05 --- CIP Google Sheet updates have been written to CSV for future checks.
2019-03-05 20:02:05 --- This process took 103.31 seconds
2019-03-06 20:00:17 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 47, in <module>
    df['Project Type'] = df['Project Type'].str.upper()
  File "C:\Anaconda3\envs\ArcPro\lib\site-packages\pandas\core\generic.py", line 4372, in __getattr__
    return object.__getattribute__(self, name)
  File "C:\Anaconda3\envs\ArcPro\lib\site-packages\pandas\core\accessor.py", line 133, in __get__
    accessor_obj = self._accessor(obj)
  File "C:\Anaconda3\envs\ArcPro\lib\site-packages\pandas\core\strings.py", line 1895, in __init__
    self._validate(data)
  File "C:\Anaconda3\envs\ArcPro\lib\site-packages\pandas\core\strings.py", line 1917, in _validate
    raise AttributeError("Can only use .str accessor with string "
AttributeError: Can only use .str accessor with string values, which use np.object_ dtype in pandas

2019-03-06 20:02:12 --- Script ran successfully
2019-03-06 20:02:12 --- CIP Google Sheet updates have been written to CSV for future checks.
2019-03-06 20:02:12 --- This process took 122.2 seconds
2019-03-07 20:02:55 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 47, in <module>
    df['Project Type'] = df['Project Type'].str.upper()
  File "C:\Anaconda3\envs\ArcPro\lib\site-packages\pandas\core\generic.py", line 4372, in __getattr__
    return object.__getattribute__(self, name)
  File "C:\Anaconda3\envs\ArcPro\lib\site-packages\pandas\core\accessor.py", line 133, in __get__
    accessor_obj = self._accessor(obj)
  File "C:\Anaconda3\envs\ArcPro\lib\site-packages\pandas\core\strings.py", line 1895, in __init__
    self._validate(data)
  File "C:\Anaconda3\envs\ArcPro\lib\site-packages\pandas\core\strings.py", line 1917, in _validate
    raise AttributeError("Can only use .str accessor with string "
AttributeError: Can only use .str accessor with string values, which use np.object_ dtype in pandas

2019-03-09 20:01:24 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 132, in <module>
    with arcpy.da.SearchCursor(sde_CIP1923, "CIPProjectNumber") as scursor:
RuntimeError: cannot open 'C:\WINDOWS\TEMP\tmpbf2186ih\CARMONA.sde\SDE.SDE.CIPs\SDE.SDE.CIP1923'

2019-03-09 20:02:42 --- Script ran successfully
2019-03-09 20:02:42 --- This process took 127.9 seconds
2019-03-10 20:00:21 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 47, in <module>
    df['Project Type'] = df['Project Type'].str.upper()
  File "C:\Anaconda3\envs\ArcPro\lib\site-packages\pandas\core\generic.py", line 4372, in __getattr__
    return object.__getattribute__(self, name)
  File "C:\Anaconda3\envs\ArcPro\lib\site-packages\pandas\core\accessor.py", line 133, in __get__
    accessor_obj = self._accessor(obj)
  File "C:\Anaconda3\envs\ArcPro\lib\site-packages\pandas\core\strings.py", line 1895, in __init__
    self._validate(data)
  File "C:\Anaconda3\envs\ArcPro\lib\site-packages\pandas\core\strings.py", line 1917, in _validate
    raise AttributeError("Can only use .str accessor with string "
AttributeError: Can only use .str accessor with string values, which use np.object_ dtype in pandas

2019-03-11 09:10:13 --- Script ran successfully
2019-03-11 09:10:13 --- This process took 73.6 seconds
2019-03-11 20:00:45 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 76, in <module>
    arcpy.CalculateField_management(googletable, "StartDate", "makeathing(!Project_Start_Date!)", "PYTHON3", codeblock01)
arcgisscripting.ExecuteError: ERROR 001156: Failed on input OID 1, could not write value 'nan' to output field StartDate
ERROR 001156: Failed on input OID 2, could not write value 'nan' to output field StartDate
ERROR 001156: Failed on input OID 78, could not write value 'nan' to output field StartDate
Failed to execute (CalculateField).


2019-03-11 20:02:11 --- Script ran successfully
2019-03-11 20:02:11 --- CIP Google Sheet updates have been written to CSV for future checks.
2019-03-11 20:02:11 --- This process took 110.36 seconds
2019-03-12 10:01:03 --- Script ran successfully
2019-03-12 10:01:03 --- CIP Google Sheet updates have been written to CSV for future checks.
2019-03-12 10:01:03 --- This process took 87.83 seconds
2019-03-12 20:00:34 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 76, in <module>
    arcpy.CalculateField_management(googletable, "StartDate", "makeathing(!Project_Start_Date!)", "PYTHON3", codeblock01)
arcgisscripting.ExecuteError: ERROR 001156: Failed on input OID 1, could not write value 'nan' to output field StartDate
ERROR 001156: Failed on input OID 2, could not write value 'nan' to output field StartDate
ERROR 001156: Failed on input OID 78, could not write value 'nan' to output field StartDate
Failed to execute (CalculateField).


2019-03-12 20:02:09 --- Script ran successfully
2019-03-12 20:02:09 --- CIP Google Sheet updates have been written to CSV for future checks.
2019-03-12 20:02:09 --- This process took 112.5 seconds
2019-03-13 08:24:04 --- Script ran successfully
2019-03-13 08:24:04 --- This process took 93.79 seconds
2019-03-13 20:00:43 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 77, in <module>
    arcpy.CalculateField_management(googletable, "StartDate", "makeathing(!Project_Start_Date!)", "PYTHON3", codeblock01)

2019-03-14 09:11:12 --- 0    2/21/2017
1    4/17/2017
2    4/18/2017
3    2/21/2017
4             
5             
6             
7    7/21/2017
8     6/8/2018
9             
Name: Project Start Date, dtype: object
2019-03-14 09:11:14 --- 2/21/2017
2019-03-14 09:11:14 --- 4/17/2017
2019-03-14 09:11:14 --- 4/18/2017
2019-03-14 09:11:14 --- 2/21/2017
2019-03-14 09:11:14 --- 
2019-03-14 09:11:14 --- 
2019-03-14 09:11:14 --- 
2019-03-14 09:11:14 --- 7/21/2017
2019-03-14 09:11:14 --- 6/8/2018
2019-03-14 09:12:53 --- This process took 103.28 seconds
2019-03-14 09:29:44 --- 0    nan
1    nan
2    nan
3    nan
4    nan
5    nan
6    nan
7    nan
8    nan
9    nan
Name: Project Start Date, dtype: object
2019-03-14 09:29:46 --- nan
2019-03-14 09:29:46 --- nan
2019-03-14 09:29:46 --- nan
2019-03-14 09:29:46 --- nan
2019-03-14 09:29:46 --- nan
2019-03-14 09:29:46 --- nan
2019-03-14 09:29:47 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 87, in <module>
    arcpy.CalculateField_management(googletable, "StartDate", "makeathing(!Project_Start_Date!)", "PYTHON3", codeblock01)
arcgisscripting.ExecuteError: ERROR 001156: Failed on input OID 1, could not write value 'nan' to output field StartDate
ERROR 001156: Failed on input OID 2, could not write value 'nan' to output field StartDate
ERROR 001156: Failed on input OID 77, could not write value 'nan' to output field StartDate
ERROR 001156: Failed on input OID 78, could not write value 'nan' to output field StartDate
Failed to execute (CalculateField).
                  
2019-03-14 10:18:51 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-03-14 10:20:16 --- Script ran successfully
2019-03-14 10:20:16 --- This process took 87.05 seconds
2019-03-14 20:00:38 ---    Project No Project Start Date
0         NaN                nan
1         NaN                nan
2         NaN                nan
3         NaN                nan
4         NaN                nan
2019-03-14 20:00:38 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 53, in <module>
    raise Exception("'nan' values found.")
Exception: 'nan' values found.

2019-03-14 20:00:38 --- Retrying execution, attempt: 1
2019-03-14 20:01:09 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-03-14 20:03:17 --- Script ran successfully
2019-03-14 20:03:17 --- This process took 168.89 seconds
2019-03-15 20:00:36 ---    Project No Project Start Date
0         NaN                nan
1         NaN                nan
2         NaN                nan
3         NaN                nan
4         NaN                nan
2019-03-15 20:00:36 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 53, in <module>
    raise Exception("'nan' values found.")
Exception: 'nan' values found.

2019-03-15 20:00:36 --- Retrying execution, attempt: 1
2019-03-15 20:01:07 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-03-15 20:03:28 --- Script ran successfully
2019-03-15 20:03:28 --- This process took 178.09 seconds
2019-03-16 20:00:16 ---    Project No Project Start Date
0         NaN                nan
1         NaN                nan
2         NaN                nan
3         NaN                nan
4         NaN                nan
2019-03-16 20:00:16 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 53, in <module>
    raise Exception("'nan' values found.")
Exception: 'nan' values found.

2019-03-16 20:00:16 --- Retrying execution, attempt: 1
2019-03-16 20:00:47 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-03-16 20:02:22 --- Script ran successfully
2019-03-16 20:02:22 --- This process took 131.66 seconds
2019-03-17 20:03:40 ---    Project No Project Start Date
0         NaN                nan
1         NaN                nan
2         NaN                nan
3         NaN                nan
4         NaN                nan
2019-03-17 20:03:40 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 53, in <module>
    raise Exception("'nan' values found.")
Exception: 'nan' values found.

2019-03-17 20:03:40 --- Retrying execution, attempt: 1
2019-03-17 20:04:11 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-03-17 20:07:58 --- Script ran successfully
2019-03-17 20:07:59 --- This process took 266.64 seconds
2019-03-18 20:00:36 ---    Project No Project Start Date
0         NaN                nan
1         NaN                nan
2         NaN                nan
3         NaN                nan
4         NaN                nan
2019-03-18 20:00:36 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 53, in <module>
    raise Exception("'nan' values found.")
Exception: 'nan' values found.

2019-03-18 20:00:36 --- Retrying execution, attempt: 1
2019-03-18 20:01:06 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-03-18 20:03:31 --- Script ran successfully
2019-03-18 20:03:31 --- This process took 180.59 seconds
2019-03-19 20:00:29 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-03-19 20:02:59 --- Script ran successfully
2019-03-19 20:02:59 --- This process took 152.24 seconds
2019-03-20 20:00:39 ---    Project No Project Start Date
0         NaN                nan
1         NaN                nan
2         NaN                nan
3         NaN                nan
4         NaN                nan
2019-03-20 20:00:39 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 53, in <module>
    raise Exception("'nan' values found.")
Exception: 'nan' values found.

2019-03-20 20:00:39 --- Retrying execution, attempt: 1
2019-03-20 20:01:10 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-03-20 20:03:55 --- Script ran successfully
2019-03-20 20:03:56 --- CIP Google Sheet updates have been written to CSV for future checks.
2019-03-20 20:03:56 --- This process took 203.73 seconds
2019-03-21 20:00:25 ---    Project No Project Start Date
0         NaN                nan
1         NaN                nan
2         NaN                nan
3         NaN                nan
4         NaN                nan
2019-03-21 20:00:25 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 53, in <module>
    raise Exception("'nan' values found.")
Exception: 'nan' values found.

2019-03-21 20:00:25 --- Retrying execution, attempt: 1
2019-03-21 20:00:56 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-03-21 20:04:05 --- Script ran successfully
2019-03-21 20:04:06 --- CIP Google Sheet updates have been written to CSV for future checks.
2019-03-21 20:04:06 --- This process took 226.29 seconds
2019-03-22 20:00:32 ---    Project No Project Start Date
0         NaN                nan
1         NaN                nan
2         NaN                nan
3         NaN                nan
4         NaN                nan
2019-03-22 20:00:32 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 53, in <module>
    raise Exception("'nan' values found.")
Exception: 'nan' values found.

2019-03-22 20:00:32 --- Retrying execution, attempt: 1
2019-03-22 20:01:02 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-03-22 20:01:39 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 137, in <module>
    with arcpy.da.SearchCursor(sde_CIP1923, "CIPProjectNumber") as scursor:
RuntimeError: cannot open 'C:\WINDOWS\TEMP\tmpkmp01exq\CARMONA.sde\SDE.SDE.CIPs\SDE.SDE.CIP1923'

2019-03-22 20:01:39 --- Retrying execution, attempt: 2
2019-03-22 20:02:10 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-03-22 20:03:28 --- Script ran successfully
2019-03-22 20:03:28 --- This process took 181.72 seconds
2019-03-23 20:00:11 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-03-23 20:01:28 --- Script ran successfully
2019-03-23 20:01:28 --- This process took 78.93 seconds
2019-03-24 20:00:22 ---    Project No Project Start Date
0         NaN                nan
1         NaN                nan
2         NaN                nan
3         NaN                nan
4         NaN                nan
2019-03-24 20:00:22 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 53, in <module>
    raise Exception("'nan' values found.")
Exception: 'nan' values found.

2019-03-24 20:00:22 --- Retrying execution, attempt: 1
2019-03-24 20:00:53 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-03-24 20:02:13 --- Script ran successfully
2019-03-24 20:02:13 --- This process took 117.14 seconds
2019-03-25 20:00:25 ---    Project No Project Start Date
0         NaN                nan
1         NaN                nan
2         NaN                nan
3         NaN                nan
4         NaN                nan
2019-03-25 20:00:25 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 53, in <module>
    raise Exception("'nan' values found.")
Exception: 'nan' values found.

2019-03-25 20:00:25 --- Retrying execution, attempt: 1
2019-03-25 20:00:55 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-03-25 20:02:44 --- Script ran successfully
2019-03-25 20:02:44 --- CIP Google Sheet updates have been written to CSV for future checks.
2019-03-25 20:02:44 --- This process took 146.44 seconds
2019-03-26 20:00:31 ---    Project No Project Start Date
0         NaN                nan
1         NaN                nan
2         NaN                nan
3         NaN                nan
4         NaN                nan
2019-03-26 20:00:31 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 53, in <module>
    raise Exception("'nan' values found.")
Exception: 'nan' values found.

2019-03-26 20:00:31 --- Retrying execution, attempt: 1
2019-03-26 20:01:01 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-03-26 20:02:49 --- Script ran successfully
2019-03-26 20:02:49 --- CIP Google Sheet updates have been written to CSV for future checks.
2019-03-26 20:02:49 --- This process took 144.06 seconds
2019-03-27 20:00:17 ---    Project No Project Start Date
0         NaN                nan
1         NaN                nan
2         NaN                nan
3         NaN                nan
4         NaN                nan
2019-03-27 20:00:17 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 53, in <module>
    raise Exception("'nan' values found.")
Exception: 'nan' values found.

2019-03-27 20:00:17 --- Retrying execution, attempt: 1
2019-03-27 20:00:48 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-03-27 20:02:21 --- Script ran successfully
2019-03-27 20:02:21 --- This process took 132.71 seconds
2019-03-28 20:00:42 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-03-28 20:02:49 --- Script ran successfully
2019-03-28 20:02:49 --- This process took 129.83 seconds
2019-03-29 20:00:33 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-03-29 20:02:32 --- Script ran successfully
2019-03-29 20:02:32 --- This process took 120.85 seconds
2019-03-30 20:00:15 ---    Project No Project Start Date
0         NaN                nan
1         NaN                nan
2         NaN                nan
3         NaN                nan
4         NaN                nan
2019-03-30 20:00:15 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 53, in <module>
    raise Exception("'nan' values found.")
Exception: 'nan' values found.

2019-03-30 20:00:15 --- Retrying execution, attempt: 1
2019-03-30 20:00:46 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-03-30 20:02:06 --- Script ran successfully
2019-03-30 20:02:06 --- This process took 117.61 seconds
2019-03-31 20:00:07 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-03-31 20:01:17 --- Script ran successfully
2019-03-31 20:01:17 --- This process took 72.47 seconds
2019-04-01 20:00:35 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-04-01 20:02:33 --- Script ran successfully
2019-04-01 20:02:33 --- This process took 120.86 seconds
2019-04-08 08:25:32 ---    Project No Project Start Date
0         NaN                nan
1         NaN                nan
2         NaN                nan
3         NaN                nan
4         NaN                nan
2019-04-08 08:25:32 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 53, in <module>
    raise Exception("'nan' values found.")
Exception: 'nan' values found.

2019-04-08 08:25:32 --- Retrying execution, attempt: 1
2019-04-08 08:26:03 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-04-08 08:26:48 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 137, in <module>
    with arcpy.da.SearchCursor(sde_CIP1923, "CIPProjectNumber") as scursor:
RuntimeError: cannot open 'C:\Users\jcarmona\AppData\Local\Temp\tmpdne8z5oy\CARMONA.sde\SDE.SDE.CIPs\SDE.SDE.CIP1923'

2019-04-08 08:26:48 --- Retrying execution, attempt: 2
2019-04-08 08:27:19 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-04-08 08:28:38 --- Script ran successfully
2019-04-08 08:28:38 --- CIP Google Sheet updates have been written to CSV for future checks.
2019-04-08 08:28:38 --- This process took 194.12 seconds
2019-04-08 20:00:25 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902                   
2019-04-08 20:02:13 --- Script ran successfully
2019-04-08 20:02:13 --- CIP Google Sheet updates have been written to CSV for future checks.
2019-04-08 20:02:13 --- This process took 110.27 seconds
2019-04-09 15:03:34 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-09 15:04:58 --- Script ran successfully
2019-04-09 15:04:58 --- CIP Google Sheet updates have been written to CSV for future checks.
2019-04-09 15:04:58 --- This process took 86.55 seconds
2019-04-09 20:00:33 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-09 20:01:49 --- Script ran successfully
2019-04-09 20:01:49 --- CIP Google Sheet updates have been written to CSV for future checks.
2019-04-09 20:01:49 --- This process took 77.89 seconds
2019-04-10 20:00:11 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-10 20:01:20 --- Script ran successfully
2019-04-10 20:01:20 --- This process took 71.58 seconds
2019-04-11 20:00:33 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-11 20:02:08 --- Script ran successfully
2019-04-11 20:02:08 --- This process took 97.8 seconds
2019-04-12 20:00:14 ---    Project No Project Start Date
0         NaN                nan
1         NaN                nan
2         NaN                nan
3         NaN                nan
4         NaN                nan
2019-04-12 20:00:14 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 53, in <module>
    raise Exception("'nan' values found.")
Exception: 'nan' values found.

2019-04-12 20:00:14 --- Retrying execution, attempt: 1
2019-04-12 20:00:44 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-12 20:02:17 --- Script ran successfully
2019-04-12 20:02:18 --- CIP Google Sheet updates have been written to CSV for future checks.
2019-04-12 20:02:18 --- This process took 128.34 seconds
2019-04-13 20:00:13 ---    Project No Project Start Date
0         NaN                nan
1         NaN                nan
2         NaN                nan
3         NaN                nan
4         NaN                nan
2019-04-13 20:00:13 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 53, in <module>
    raise Exception("'nan' values found.")
Exception: 'nan' values found.

2019-04-13 20:00:13 --- Retrying execution, attempt: 1
2019-04-13 20:00:43 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-13 20:02:17 --- Script ran successfully
2019-04-13 20:02:17 --- This process took 131.53 seconds
2019-04-14 20:00:22 ---    Project No Project Start Date
0         NaN                nan
1         NaN                nan
2         NaN                nan
3         NaN                nan
4         NaN                nan
2019-04-14 20:00:22 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 53, in <module>
    raise Exception("'nan' values found.")
Exception: 'nan' values found.

2019-04-14 20:00:22 --- Retrying execution, attempt: 1
2019-04-14 20:00:52 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-14 20:02:26 --- Script ran successfully
2019-04-14 20:02:26 --- This process took 131.36 seconds
2019-04-15 20:00:32 ---    Project No Project Start Date
0         NaN                nan
1         NaN                nan
2         NaN                nan
3         NaN                nan
4         NaN                nan
2019-04-15 20:00:32 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 53, in <module>
    raise Exception("'nan' values found.")
Exception: 'nan' values found.

2019-04-15 20:00:32 --- Retrying execution, attempt: 1
2019-04-15 20:01:03 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-15 20:03:03 --- Script ran successfully
2019-04-15 20:03:03 --- This process took 156.75 seconds
2019-04-16 20:00:32 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-16 20:02:39 --- Script ran successfully
2019-04-16 20:02:39 --- CIP Google Sheet updates have been written to CSV for future checks.
2019-04-16 20:02:39 --- This process took 130.03 seconds
2019-04-17 20:00:45 ---    Project No Project Start Date
0         NaN                nan
1         NaN                nan
2         NaN                nan
3         NaN                nan
4         NaN                nan
2019-04-17 20:00:45 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 53, in <module>
    raise Exception("'nan' values found.")
Exception: 'nan' values found.

2019-04-17 20:00:45 --- Retrying execution, attempt: 1
2019-04-17 20:01:16 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-17 20:03:30 --- Script ran successfully
2019-04-17 20:03:30 --- This process took 171.57 seconds
2019-04-18 20:00:46 ---    Project No Project Start Date
0         NaN                nan
1         NaN                nan
2         NaN                nan
3         NaN                nan
4         NaN                nan
2019-04-18 20:00:46 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\__Production_Scripts\Google_to_SDE.py", line 53, in <module>
    raise Exception("'nan' values found.")
Exception: 'nan' values found.

2019-04-18 20:00:46 --- Retrying execution, attempt: 1
2019-04-18 20:01:17 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-18 20:03:21 --- Script ran successfully
2019-04-18 20:03:21 --- This process took 163.96 seconds
2019-04-19 11:29:23 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 11:30:53 --- Script ran successfully
2019-04-19 11:30:53 --- CIP Google Sheet updates have been written to CSV for future checks.
2019-04-19 11:30:53 --- This process took 92.65 seconds
2019-04-19 11:32:01 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 11:33:21 --- Script ran successfully
2019-04-19 11:33:21 --- This process took 82.0 seconds
2019-04-19 12:02:20 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 12:03:44 --- Script ran successfully
2019-04-19 12:03:44 --- This process took 86.32 seconds
2019-04-19 14:50:09 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 14:50:49 --- Traceback (most recent call last):
  File "<ipython-input-2-d2e271ec4a32>", line 114, in <module>
    arcpy.AlterVersion_management(sdeTempPath + os.sep + "Editor.sde", '"MCKINNEY\JCARMONA".CARMONA', description = "jcarmona@mckinneytexas.org | ext 7422")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19536, in AlterVersion
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19533, in AlterVersion
    retval = convertArcObjectToPythonObject(gp.AlterVersion_management(*gp_fixargs((in_workspace, in_version, name, description, access), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.
Version not found ["MCKINNEY\JCARMONA".CARMONA]
Failed to execute (AlterVersion).


2019-04-19 14:50:49 --- Retrying execution, attempt: 1
2019-04-19 14:51:19 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 14:51:22 --- Traceback (most recent call last):
  File "<ipython-input-2-d2e271ec4a32>", line 113, in <module>
    arcpy.CreateVersion_management(sdeTempPath + os.sep + "Editor.sde", "sde.DEFAULT" ,"CARMONA", "PUBLIC")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19606, in CreateVersion
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19603, in CreateVersion
    retval = convertArcObjectToPythonObject(gp.CreateVersion_management(*gp_fixargs((in_workspace, parent_version, version_name, access_permission), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 001148: Cannot create a version with the specified name.
Failed to execute (CreateVersion).


2019-04-19 14:51:22 --- Retrying execution, attempt: 2
2019-04-19 14:51:52 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 14:51:54 --- Traceback (most recent call last):
  File "<ipython-input-2-d2e271ec4a32>", line 113, in <module>
    arcpy.CreateVersion_management(sdeTempPath + os.sep + "Editor.sde", "sde.DEFAULT" ,"CARMONA", "PUBLIC")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19606, in CreateVersion
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19603, in CreateVersion
    retval = convertArcObjectToPythonObject(gp.CreateVersion_management(*gp_fixargs((in_workspace, parent_version, version_name, access_permission), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 001148: Cannot create a version with the specified name.
Failed to execute (CreateVersion).


2019-04-19 14:51:54 --- Retrying execution, attempt: 3
2019-04-19 14:52:25 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 14:52:27 --- Traceback (most recent call last):
  File "<ipython-input-2-d2e271ec4a32>", line 113, in <module>
    arcpy.CreateVersion_management(sdeTempPath + os.sep + "Editor.sde", "sde.DEFAULT" ,"CARMONA", "PUBLIC")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19606, in CreateVersion
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19603, in CreateVersion
    retval = convertArcObjectToPythonObject(gp.CreateVersion_management(*gp_fixargs((in_workspace, parent_version, version_name, access_permission), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 001148: Cannot create a version with the specified name.
Failed to execute (CreateVersion).


2019-04-19 14:52:27 --- Retrying execution, attempt: 4
2019-04-19 14:52:57 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 14:52:59 --- Traceback (most recent call last):
  File "<ipython-input-2-d2e271ec4a32>", line 113, in <module>
    arcpy.CreateVersion_management(sdeTempPath + os.sep + "Editor.sde", "sde.DEFAULT" ,"CARMONA", "PUBLIC")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19606, in CreateVersion
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19603, in CreateVersion
    retval = convertArcObjectToPythonObject(gp.CreateVersion_management(*gp_fixargs((in_workspace, parent_version, version_name, access_permission), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 001148: Cannot create a version with the specified name.
Failed to execute (CreateVersion).


2019-04-19 14:52:59 --- Retrying execution, attempt: 5
2019-04-19 14:53:29 --- This process took 201.73 seconds
2019-04-19 14:56:10 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 14:56:12 --- Traceback (most recent call last):
  File "<ipython-input-3-d2e271ec4a32>", line 113, in <module>
    arcpy.CreateVersion_management(sdeTempPath + os.sep + "Editor.sde", "sde.DEFAULT" ,"CARMONA", "PUBLIC")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19606, in CreateVersion
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19603, in CreateVersion
    retval = convertArcObjectToPythonObject(gp.CreateVersion_management(*gp_fixargs((in_workspace, parent_version, version_name, access_permission), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 001148: Cannot create a version with the specified name.
Failed to execute (CreateVersion).


2019-04-19 14:56:12 --- Retrying execution, attempt: 1
2019-04-19 15:01:19 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:01:21 --- Traceback (most recent call last):
  File "<ipython-input-4-ab7ba7252f0b>", line 113, in <module>
    arcpy.CreateVersion_management(sdeTempPath + os.sep + "Editor.sde", "sde.DEFAULT" ,"CARMONA", "PUBLIC")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19606, in CreateVersion
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19603, in CreateVersion
    retval = convertArcObjectToPythonObject(gp.CreateVersion_management(*gp_fixargs((in_workspace, parent_version, version_name, access_permission), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 001148: Cannot create a version with the specified name.
Failed to execute (CreateVersion).


2019-04-19 15:01:21 --- Retrying execution, attempt: 1
2019-04-19 15:02:05 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:02:13 --- Traceback (most recent call last):
  File "<ipython-input-1-ab7ba7252f0b>", line 113, in <module>
    arcpy.CreateVersion_management(sdeTempPath + os.sep + "Editor.sde", "sde.DEFAULT" ,"CARMONA", "PUBLIC")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19606, in CreateVersion
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19603, in CreateVersion
    retval = convertArcObjectToPythonObject(gp.CreateVersion_management(*gp_fixargs((in_workspace, parent_version, version_name, access_permission), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 001148: Cannot create a version with the specified name.
Failed to execute (CreateVersion).


2019-04-19 15:02:13 --- Retrying execution, attempt: 1
2019-04-19 15:03:50 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:03:52 --- Traceback (most recent call last):
  File "<ipython-input-2-224c22a6d21f>", line 113, in <module>
    arcpy.CreateVersion_management(sdeTempPath + os.sep + "Editor.sde", "sde.DEFAULT" ,"CARMONA", "PUBLIC")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19606, in CreateVersion
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19603, in CreateVersion
    retval = convertArcObjectToPythonObject(gp.CreateVersion_management(*gp_fixargs((in_workspace, parent_version, version_name, access_permission), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 001148: Cannot create a version with the specified name.
Failed to execute (CreateVersion).


2019-04-19 15:03:52 --- Retrying execution, attempt: 1
2019-04-19 15:04:50 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:04:58 --- Traceback (most recent call last):
  File "<ipython-input-1-0a173ba9a16a>", line 113, in <module>
    arcpy.CreateVersion_management(sdeTempPath + os.sep + "Editor.sde", "sde.DEFAULT" ,"CARMONA", "PUBLIC")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19606, in CreateVersion
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19603, in CreateVersion
    retval = convertArcObjectToPythonObject(gp.CreateVersion_management(*gp_fixargs((in_workspace, parent_version, version_name, access_permission), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 001148: Cannot create a version with the specified name.
Failed to execute (CreateVersion).


2019-04-19 15:04:58 --- Retrying execution, attempt: 1
2019-04-19 15:07:57 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:07:59 --- Traceback (most recent call last):
  File "<ipython-input-2-7cc64db9c510>", line 113, in <module>
    arcpy.CreateVersion_management(sdeTempPath + os.sep + "Editor.sde", "sde.DEFAULT" ,"CARMONA", "PUBLIC")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19606, in CreateVersion
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19603, in CreateVersion
    retval = convertArcObjectToPythonObject(gp.CreateVersion_management(*gp_fixargs((in_workspace, parent_version, version_name, access_permission), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 001148: Cannot create a version with the specified name.
Failed to execute (CreateVersion).


2019-04-19 15:07:59 --- Retrying execution, attempt: 1
2019-04-19 15:08:34 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:08:36 --- Traceback (most recent call last):
  File "<ipython-input-3-fc3860b91d3d>", line 109, in <module>
    arcpy.AlterVersion_management(sdeTempPath + os.sep + "Editor.sde", '"CARMONA".CARMONA', description = "jcarmona@mckinneytexas.org | ext 7422")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19536, in AlterVersion
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19533, in AlterVersion
    retval = convertArcObjectToPythonObject(gp.AlterVersion_management(*gp_fixargs((in_workspace, in_version, name, description, access), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.
Version not found ["CARMONA".CARMONA]
Failed to execute (AlterVersion).


2019-04-19 15:08:36 --- Retrying execution, attempt: 1
2019-04-19 15:18:10 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:18:14 --- Traceback (most recent call last):
  File "<ipython-input-4-612ec2903d68>", line 113, in <module>
    arcpy.CreateVersion_management(sdeTempPath + os.sep + "Editor.sde", "sde.DEFAULT" ,"CARMONA", "PUBLIC")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19606, in CreateVersion
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19603, in CreateVersion
    retval = convertArcObjectToPythonObject(gp.CreateVersion_management(*gp_fixargs((in_workspace, parent_version, version_name, access_permission), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 001148: Cannot create a version with the specified name.
Failed to execute (CreateVersion).


2019-04-19 15:18:14 --- Retrying execution, attempt: 1
2019-04-19 15:18:47 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:18:48 --- Traceback (most recent call last):
  File "<ipython-input-5-5d2cbddcf012>", line 118, in <module>
    arcpy.CreateDatabaseConnection_management(sdeTempPath, "CARMONA.sde", "SQL_SERVER", "ITT701", "OPERATING_SYSTEM_AUTH", version = '"MCKINNEY\JCARMONA".CARMONA')
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 20170, in CreateDatabaseConnection
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 20167, in CreateDatabaseConnection
    retval = convertArcObjectToPythonObject(gp.CreateDatabaseConnection_management(*gp_fixargs((out_folder_path, out_name, database_platform, instance, account_authentication, username, password, save_user_pass, database, schema, version_type, version, date), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 000622: Failed to execute (CreateDatabaseConnection). Parameters are not valid.
ERROR 000800: The value is not a member of sde.DEFAULT | DBO.CARMONA.
Failed to execute (CreateDatabaseConnection).


2019-04-19 15:18:48 --- Retrying execution, attempt: 1
2019-04-19 15:19:46 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:19:46 --- Traceback (most recent call last):
  File "<ipython-input-6-27ac6eea82af>", line 118, in <module>
    arcpy.CreateDatabaseConnection_management(sdeTempPath, "CARMONA.sde", "SQL_SERVER", "ITT701", "OPERATING_SYSTEM_AUTH", version = "CARMONA")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 20170, in CreateDatabaseConnection
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 20167, in CreateDatabaseConnection
    retval = convertArcObjectToPythonObject(gp.CreateDatabaseConnection_management(*gp_fixargs((out_folder_path, out_name, database_platform, instance, account_authentication, username, password, save_user_pass, database, schema, version_type, version, date), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 000622: Failed to execute (CreateDatabaseConnection). Parameters are not valid.
ERROR 000800: The value is not a member of sde.DEFAULT | DBO.CARMONA.
Failed to execute (CreateDatabaseConnection).


2019-04-19 15:19:46 --- Retrying execution, attempt: 1
2019-04-19 15:22:21 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:22:24 --- Traceback (most recent call last):
  File "<ipython-input-7-79cfc1d358ed>", line 136, in <module>
    with arcpy.da.SearchCursor(sde_CIP1923, "CIPProjectNumber") as scursor:
RuntimeError: cannot open 'C:\Users\jcarmona\AppData\Local\Temp\tmphc7p9f6p\Version.sde\SDE.DBO.TEST_CIP1923'

2019-04-19 15:22:24 --- Retrying execution, attempt: 1
2019-04-19 15:24:54 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:24:58 --- Traceback (most recent call last):
  File "<ipython-input-8-dc6c4001f285>", line 136, in <module>
    with arcpy.da.SearchCursor(sde_CIP1923, "CIPProjectNumber") as scursor:
RuntimeError: cannot open 'C:\Users\jcarmona\AppData\Local\Temp\tmp49fagnd8\CarmonaVersion.sde\SDE.DBO.TEST_CIP1923'

2019-04-19 15:24:58 --- Retrying execution, attempt: 1
2019-04-19 15:28:26 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:28:28 --- Traceback (most recent call last):
  File "<ipython-input-9-49ec46a22989>", line 113, in <module>
    arcpy.CreateVersion_management(sdeTempPath + os.sep + "Editor.sde", "sde.DEFAULT" ,"CarmonaVersion", "PUBLIC")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19606, in CreateVersion
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19603, in CreateVersion
    retval = convertArcObjectToPythonObject(gp.CreateVersion_management(*gp_fixargs((in_workspace, parent_version, version_name, access_permission), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 001148: Cannot create a version with the specified name.
Failed to execute (CreateVersion).


2019-04-19 15:28:28 --- Retrying execution, attempt: 1
2019-04-19 15:40:10 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:40:12 --- Traceback (most recent call last):
  File "<ipython-input-10-1269a2be4546>", line 112, in <module>
    arcpy.CreateVersion_management(sdeTempPath + os.sep + "Editor.sde", "sde.DEFAULT" ,"DBO.Carmona", "PUBLIC")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19606, in CreateVersion
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19603, in CreateVersion
    retval = convertArcObjectToPythonObject(gp.CreateVersion_management(*gp_fixargs((in_workspace, parent_version, version_name, access_permission), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 001148: Cannot create a version with the specified name.
Failed to execute (CreateVersion).


2019-04-19 15:40:12 --- Retrying execution, attempt: 1
2019-04-19 15:41:34 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:41:36 --- Traceback (most recent call last):
  File "<ipython-input-11-5a5bb0db1b4c>", line 112, in <module>
    arcpy.CreateVersion_management(sdeTempPath + os.sep + "Editor.sde", "sde.DEFAULT" ,"DBO.CarmonaVersion", "PUBLIC")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19606, in CreateVersion
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19603, in CreateVersion
    retval = convertArcObjectToPythonObject(gp.CreateVersion_management(*gp_fixargs((in_workspace, parent_version, version_name, access_permission), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 001148: Cannot create a version with the specified name.
Failed to execute (CreateVersion).


2019-04-19 15:41:36 --- Retrying execution, attempt: 1
2019-04-19 15:45:09 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:45:11 --- Traceback (most recent call last):
  File "<ipython-input-12-2310621333e7>", line 113, in <module>
    arcpy.CreateVersion_management(sdeTempPath + os.sep + "Editor.sde", "sde.DEFAULT" ,"DBO.CarmonaVersion", "PUBLIC")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19606, in CreateVersion
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19603, in CreateVersion
    retval = convertArcObjectToPythonObject(gp.CreateVersion_management(*gp_fixargs((in_workspace, parent_version, version_name, access_permission), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 001148: Cannot create a version with the specified name.
Failed to execute (CreateVersion).


2019-04-19 15:45:11 --- Retrying execution, attempt: 1
2019-04-19 15:45:47 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:45:49 --- Traceback (most recent call last):
  File "<ipython-input-13-2310621333e7>", line 113, in <module>
    arcpy.CreateVersion_management(sdeTempPath + os.sep + "Editor.sde", "sde.DEFAULT" ,"DBO.CarmonaVersion", "PUBLIC")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19606, in CreateVersion
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19603, in CreateVersion
    retval = convertArcObjectToPythonObject(gp.CreateVersion_management(*gp_fixargs((in_workspace, parent_version, version_name, access_permission), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 001148: Cannot create a version with the specified name.
Failed to execute (CreateVersion).


2019-04-19 15:45:49 --- Retrying execution, attempt: 1
2019-04-19 15:48:14 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:48:16 --- Traceback (most recent call last):
  File "<ipython-input-14-69f066f70410>", line 115, in <module>
    arcpy.CreateVersion_management(sdeTempPath + os.sep + "Editor.sde", "sde.DEFAULT" ,"DBO.CarmonaVersion", "PUBLIC")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19606, in CreateVersion
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 19603, in CreateVersion
    retval = convertArcObjectToPythonObject(gp.CreateVersion_management(*gp_fixargs((in_workspace, parent_version, version_name, access_permission), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 001148: Cannot create a version with the specified name.
Failed to execute (CreateVersion).


2019-04-19 15:48:16 --- Retrying execution, attempt: 1
2019-04-19 15:50:03 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:50:07 --- Traceback (most recent call last):
  File "<ipython-input-15-a3aa4b8fc0f1>", line 138, in <module>
    with arcpy.da.SearchCursor(sde_CIP1923, "CIPProjectNumber") as scursor:
RuntimeError: cannot open 'C:\Users\jcarmona\AppData\Local\Temp\tmp0l2oz5n9\CarmonaVersion.sde\SDE.DBO.TEST_CIP1923'

2019-04-19 15:50:07 --- Retrying execution, attempt: 1
2019-04-19 15:51:03 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:51:04 --- Traceback (most recent call last):
  File "<ipython-input-16-75bb9a24b9dc>", line 120, in <module>
    arcpy.CreateDatabaseConnection_management(sdeTempPath, "Carmona.sde", "SQL_SERVER", "ITT701", "OPERATING_SYSTEM_AUTH", version = "CarmonaVersion")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 20170, in CreateDatabaseConnection
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 20167, in CreateDatabaseConnection
    retval = convertArcObjectToPythonObject(gp.CreateDatabaseConnection_management(*gp_fixargs((out_folder_path, out_name, database_platform, instance, account_authentication, username, password, save_user_pass, database, schema, version_type, version, date), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 000622: Failed to execute (CreateDatabaseConnection). Parameters are not valid.
ERROR 000800: The value is not a member of sde.DEFAULT | DBO.CarmonaVersion.
Failed to execute (CreateDatabaseConnection).


2019-04-19 15:51:04 --- Retrying execution, attempt: 1
2019-04-19 15:55:06 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:55:06 --- Traceback (most recent call last):
  File "<ipython-input-17-e50a0bfd1bec>", line 120, in <module>
    arcpy.CreateDatabaseConnection_management(sdeTempPath, "Carmona.sde", "SQL_SERVER", "ITT701", "OPERATING_SYSTEM_AUTH", version = "CarmonaVersion")
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 20170, in CreateDatabaseConnection
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 20167, in CreateDatabaseConnection
    retval = convertArcObjectToPythonObject(gp.CreateDatabaseConnection_management(*gp_fixargs((out_folder_path, out_name, database_platform, instance, account_authentication, username, password, save_user_pass, database, schema, version_type, version, date), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 498, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 000622: Failed to execute (CreateDatabaseConnection). Parameters are not valid.
ERROR 000800: The value is not a member of sde.DEFAULT | DBO.CarmonaVersion.
Failed to execute (CreateDatabaseConnection).


2019-04-19 15:55:06 --- Retrying execution, attempt: 1
2019-04-19 15:57:08 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:57:09 --- 	The following projects are new: ['CO1703']
2019-04-19 15:57:09 --- Traceback (most recent call last):
  File "<ipython-input-18-db42362b41ae>", line 166, in <module>
    for urow in ucursor:
RuntimeError: workspace already in transaction mode

2019-04-19 15:57:09 --- Retrying execution, attempt: 1
2019-04-19 15:57:53 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:58:04 --- Traceback (most recent call last):
  File "<ipython-input-1-db42362b41ae>", line 138, in <module>
    with arcpy.da.SearchCursor(sde_CIP1923, "CIPProjectNumber") as scursor:
RuntimeError: cannot open 'C:\Users\jcarmona\AppData\Local\Temp\tmpwjmsc3xr\Carmona.sde\SDE.DBO.TEST_CIP1923'

2019-04-19 15:58:04 --- Retrying execution, attempt: 1
2019-04-19 15:58:14 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 15:58:21 --- 	The following projects are new: ['CO1703']
2019-04-19 15:58:21 --- Traceback (most recent call last):
  File "<ipython-input-1-db42362b41ae>", line 166, in <module>
    for urow in ucursor:
RuntimeError: workspace already in transaction mode

2019-04-19 15:58:21 --- Retrying execution, attempt: 1
2019-04-19 16:00:29 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 16:00:29 --- 	The following projects are new: ['CO1703']
2019-04-19 16:00:29 --- Traceback (most recent call last):
  File "<ipython-input-4-db42362b41ae>", line 166, in <module>
    for urow in ucursor:
RuntimeError: workspace already in transaction mode

2019-04-19 16:00:29 --- Retrying execution, attempt: 1
2019-04-19 16:01:21 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 16:01:21 --- 	The following projects are new: ['CO1703']
2019-04-19 16:01:21 --- Traceback (most recent call last):
  File "<ipython-input-6-db42362b41ae>", line 166, in <module>
    for urow in ucursor:
RuntimeError: workspace already in transaction mode

2019-04-19 16:01:21 --- Retrying execution, attempt: 1
2019-04-19 16:02:03 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 16:02:03 --- 	The following projects are new: ['CO1703']
2019-04-19 16:02:04 --- Traceback (most recent call last):
  File "<ipython-input-8-db42362b41ae>", line 166, in <module>
    for urow in ucursor:
RuntimeError: workspace already in transaction mode

2019-04-19 16:02:04 --- Retrying execution, attempt: 1
2019-04-19 16:02:28 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-19 16:02:40 --- 	The following projects are new: ['CO1703']
2019-04-19 16:02:40 --- Traceback (most recent call last):
  File "<ipython-input-2-db42362b41ae>", line 166, in <module>
    for urow in ucursor:
RuntimeError: workspace already in transaction mode

2019-04-19 16:02:40 --- Retrying execution, attempt: 1
2019-04-20 09:05:04 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-20 09:05:41 --- 	The following projects are new: ['CO1703']
2019-04-20 09:05:41 --- Traceback (most recent call last):
  File "<ipython-input-1-db42362b41ae>", line 166, in <module>
    for urow in ucursor:
RuntimeError: workspace already in transaction mode

2019-04-20 09:05:41 --- Retrying execution, attempt: 1
2019-04-20 09:09:55 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-20 09:10:25 --- Traceback (most recent call last):
  File "<ipython-input-1-3a5ecaffd79e>", line 138, in <module>
    with arcpy.da.SearchCursor(sde_CIP1923, "CIPProjectNumber") as scursor:
RuntimeError: cannot open 'C:\Users\jcarmona\AppData\Local\Temp\tmpe80bbj7w\Carmona.sde\SDE.DBO.TEST_CIP1923'

2019-04-20 09:10:25 --- Retrying execution, attempt: 1
2019-04-20 09:12:58 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-20 09:13:00 --- 	The following projects are new: ['CO1703']
2019-04-20 09:13:01 --- Traceback (most recent call last):
  File "<ipython-input-2-3a5ecaffd79e>", line 166, in <module>
    for urow in ucursor:
RuntimeError: workspace already in transaction mode

2019-04-20 09:13:01 --- Retrying execution, attempt: 1
2019-04-20 09:13:32 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-20 09:13:33 --- 	The following projects are new: ['CO1703']
2019-04-20 09:13:34 --- Traceback (most recent call last):
  File "<ipython-input-2-3a5ecaffd79e>", line 166, in <module>
    for urow in ucursor:
RuntimeError: workspace already in transaction mode

2019-04-20 09:13:34 --- Retrying execution, attempt: 2
2019-04-20 09:15:14 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-20 09:15:29 --- 	The following projects are new: ['CO1703']
2019-04-20 09:15:30 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\SCAUG 2019 PRESENTATION\Google_to_SDE.py", line 166, in <module>
    for urow in ucursor:
RuntimeError: workspace already in transaction mode

2019-04-20 09:15:30 --- Retrying execution, attempt: 1
2019-04-20 09:16:01 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-20 09:16:02 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\SCAUG 2019 PRESENTATION\Google_to_SDE.py", line 104, in <module>
    for version in arcpy.da.ListVersions(sdeTempPath + os.sep + "Editor.sde"):
RuntimeError

2019-04-20 09:16:02 --- Retrying execution, attempt: 2
2019-04-20 09:16:33 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-20 09:16:34 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\SCAUG 2019 PRESENTATION\Google_to_SDE.py", line 104, in <module>
    for version in arcpy.da.ListVersions(sdeTempPath + os.sep + "Editor.sde"):
RuntimeError

2019-04-20 09:16:34 --- Retrying execution, attempt: 3
2019-04-20 09:17:05 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-20 09:17:06 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\SCAUG 2019 PRESENTATION\Google_to_SDE.py", line 104, in <module>
    for version in arcpy.da.ListVersions(sdeTempPath + os.sep + "Editor.sde"):
RuntimeError

2019-04-20 09:17:06 --- Retrying execution, attempt: 4
2019-04-20 09:17:37 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-20 09:17:38 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\SCAUG 2019 PRESENTATION\Google_to_SDE.py", line 104, in <module>
    for version in arcpy.da.ListVersions(sdeTempPath + os.sep + "Editor.sde"):
RuntimeError

2019-04-20 09:17:38 --- Retrying execution, attempt: 5
2019-04-20 09:18:08 --- This process took 175.85 seconds
2019-04-20 09:18:57 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-20 09:19:17 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\SCAUG 2019 PRESENTATION\Google_to_SDE.py", line 138, in <module>
    with arcpy.da.SearchCursor(sde_CIP1923, "CIPProjectNumber") as scursor:
RuntimeError: cannot open 'C:\Users\jcarmona\AppData\Local\Temp\tmpzfwo98im\Carmona.sde\SDE.DBO.TEST_CIP1923'

2019-04-20 09:19:17 --- Retrying execution, attempt: 5
2019-04-20 09:19:27 --- This process took 31.81 seconds
2019-04-20 09:23:26 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-20 09:23:42 --- 	The following projects are new: ['CO1703', 'CO1704', 'CO1705', 'CO1706', 'CO1902', 'CO4238', 'CO4412', 'DR1646', 'DR1808', 'DR1809', 'DR1818', 'DR3251', 'DR5093', 'FA4320', 'ST1219', 'ST1231', 'ST1612', 'ST1613', 'ST1615', 'ST1617', 'ST1618', 'ST1622', 'ST1649', 'ST1719', 'ST1723', 'ST1834', 'ST1835', 'ST1837', 'ST1838', 'ST1839', 'ST1841', 'ST3212', 'ST4227', 'ST4331', 'ST4334', 'ST4372', 'ST4375', 'ST4422', 'ST9115', 'TR1620', 'TR1702', 'TR1843', 'TR1844', 'TR1845', 'TR1846', 'TR1847', 'TR1849', 'TR1850', 'TR4235', 'WA1610', 'WA1624', 'WA1625', 'WA1626', 'WA1630', 'WA1713', 'WA1805', 'WA1810', 'WA4202', 'WA4336', 'WA4337', 'WA4339', 'WA4340', 'WA4341', 'WA4415', 'WA8132', 'WA9145', 'WW1638', 'WW1853', 'WW1855', 'WW2245', 'WW4209', 'WW4213', 'WW4239', 'WW4348', 'WW4350', 'WW4351', 'WW4354', 'WW4404']
2019-04-20 09:23:43 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\SCAUG 2019 PRESENTATION\Google_to_SDE.py", line 166, in <module>
    for urow in ucursor:
RuntimeError: workspace already in transaction mode

2019-04-20 09:23:43 --- Retrying execution, attempt: 5
2019-04-20 09:23:53 --- This process took 28.41 seconds
2019-04-20 09:25:41 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-20 09:25:58 --- 	The following projects are new: ['CO1703']
2019-04-20 09:26:45 --- Script ran successfully
2019-04-20 09:26:45 --- This process took 66.25 seconds
2019-04-20 09:42:53 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-20 09:43:10 --- 	The following projects are new: ['CO1703']
2019-04-20 09:43:10 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\SCAUG 2019 PRESENTATION\Google_to_SDE.py", line 168, in <module>
    for urow in ucursor:
RuntimeError: workspace already in transaction mode

2019-04-20 09:43:10 --- Retrying execution, attempt: 5
2019-04-20 09:43:25 --- This process took 34.77 seconds
2019-04-20 09:44:14 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-20 09:44:32 --- 	The following projects are new: ['CO1703']
2019-04-20 09:45:54 --- Script ran successfully
2019-04-20 09:45:54 --- This process took 102.28 seconds
2019-04-20 09:47:51 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-20 09:47:53 --- Traceback (most recent call last):
  File "<ipython-input-3-395df219a779>", line 104, in <module>
    for version in arcpy.da.ListVersions(sdeTempPath + os.sep + "Editor.sde"):
RuntimeError

2019-04-20 09:47:53 --- Retrying execution, attempt: 5
2019-04-20 09:48:08 --- This process took 17.4 seconds
2019-04-20 09:48:55 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-20 09:49:15 --- 	The following projects are new: ['CO1703']
2019-04-20 09:50:43 --- Script ran successfully
2019-04-20 09:50:43 --- This process took 110.76 seconds
2019-04-20 10:02:26 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-20 10:02:44 --- 	The following projects are new: ['CO1703']
2019-04-20 10:04:13 --- Script ran successfully
2019-04-20 10:04:13 --- This process took 109.92 seconds
2019-04-20 13:01:12 --- The following projects are new: ['CO1703']
2019-04-20 13:57:46 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-20 13:58:02 --- The following projects are new: ['CO1703']
2019-04-20 13:59:27 --- Script ran successfully
2019-04-20 13:59:27 --- This process took 103.24 seconds
2019-04-21 16:29:22 --- The following projects are new: ['CO1703']
2019-04-21 16:30:21 --- The following projects are new: ['CO1703']
2019-04-24 06:37:30 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-24 06:37:45 --- The following projects are new: ['CO1703']
2019-04-24 06:38:12 --- Script ran successfully
2019-04-24 06:38:12 --- CIP Google Sheet updates have been written to CSV for future checks.
2019-04-24 06:38:12 --- This process took 45.42 seconds
2019-04-24 06:39:01 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-24 06:39:10 --- Traceback (most recent call last):
  File "C:\Users\jcarmona\Desktop\SCAUG 2019 PRESENTATION\Google_to_SDE.py", line 139, in <module>
    with arcpy.da.SearchCursor(sde_CIP1923, "CIPProjectNumber") as scursor:
RuntimeError: cannot open 'C:\Users\jcarmona\AppData\Local\Temp\tmp5qzqqnn4\Carmona.sde\SDE.DBO.FullDemo_CIP1923'

2019-04-24 06:39:10 --- Retrying execution, attempt: 5
2019-04-24 06:39:25 --- This process took 26.74 seconds
2019-04-24 06:39:39 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-24 06:39:46 --- The following projects are new: ['CO1703']
2019-04-24 06:40:13 --- Script ran successfully
2019-04-24 06:40:13 --- This process took 36.83 seconds
2019-04-24 07:21:03 --- The following projects are new: ['CO1703']
2019-04-24 07:23:08 --- The following projects are new: ['CO1703']
2019-04-24 15:34:38 --- The following projects are new: ['CO1703']
2019-04-24 15:35:17 --- The following projects are new: ['CO1703']
2019-04-24 15:50:28 ---   Project No Project Start Date
0     CO1703          2/21/2017
1     CO1704          4/17/2017
2     CO1705          4/18/2017
3     CO1706          2/21/2017
4     CO1902          3/19/2019
2019-04-24 15:50:36 --- The following projects are new: ['CO1703']
2019-04-24 15:51:05 --- Script ran successfully
2019-04-24 15:51:05 --- CIP Google Sheet updates have been written to CSV for future checks.
2019-04-24 15:51:05 --- This process took 41.64 seconds
2019-05-16 08:02:31 --- The following projects are new: ['CO1703', 'CO1909']
2019-05-16 08:03:40 --- The following projects are new: ['CO1703', 'CO1909']
2019-05-16 13:51:45 --- The following projects are new: ['CO1703', 'CO1909']
2019-05-16 13:52:30 --- The following projects are new: ['CO1703', 'CO1909']