{
 "name": "BulkProjectShapes",
 "displayName": "BulkProjectShapes",
 "description": "BulkProjectShapes",
 "category": "",
 "helpUrl": "https://portal.miningcadastre.go.ke/arcgis/rest/directories/arcgisoutput/FlexiCadastreGPService_GPServer/FlexiCadastreGPService/BulkProjectShapes.htm",
 "executionType": "esriExecutionTypeAsynchronous",
 "parameters": [
  {
   "name": "strServerName",
   "dataType": "GPString",
   "displayName": "strServerName",
   "description": "strServerName",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "SDRSA34\\SQL2008R2Express",
   "parameterType": "esriGPParameterTypeRequired",
   "category": ""
  },
  {
   "name": "strDatabaseName",
   "dataType": "GPString",
   "displayName": "strDatabaseName",
   "description": "strDatabaseName",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "FlexiCadastreBATestBarrickSAM2",
   "parameterType": "esriGPParameterTypeRequired",
   "category": ""
  },
  {
   "name": "strUserName",
   "dataType": "GPString",
   "displayName": "strUserName",
   "description": "strUserName",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "sa",
   "parameterType": "esriGPParameterTypeRequired",
   "category": ""
  },
  {
   "name": "strEncryptedPassword",
   "dataType": "GPString",
   "displayName": "strEncryptedPassword",
   "description": "strEncryptedPassword",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "phfgbzre",
   "parameterType": "esriGPParameterTypeRequired",
   "category": ""
  },
  {
   "name": "strIntegratedSecurity",
   "dataType": "GPString",
   "displayName": "strIntegratedSecurity",
   "description": "strIntegratedSecurity",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "false",
   "parameterType": "esriGPParameterTypeRequired",
   "category": ""
  },
  {
   "name": "strGeoTransformationPrefix",
   "dataType": "GPString",
   "displayName": "strGeoTransformationPrefix",
   "description": "strGeoTransformationPrefix",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "FlexiCadastre",
   "parameterType": "esriGPParameterTypeRequired",
   "category": ""
  },
  {
   "name": "blnSuccess",
   "dataType": "GPBoolean",
   "displayName": "blnSuccess",
   "description": "",
   "direction": "esriGPParameterDirectionOutput",
   "defaultValue": false,
   "parameterType": "esriGPParameterTypeDerived",
   "category": ""
  },
  {
   "name": "strError",
   "dataType": "GPString",
   "displayName": "strError",
   "description": "",
   "direction": "esriGPParameterDirectionOutput",
   "defaultValue": "Type: <class 'pypyodbc.IntegrityError'>\nValue: (u'23000', u\"[23000] [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of UNIQUE KEY constraint 'UX_tblShapeGeometry'. Cannot insert duplicate key in object 'dbo.tblShapeGeometry'. The duplicate key value is (2203d525-12f9-4a74-8bb1-2db6e0cb8fa3, 27dcfa6a-c212-45aa-9191-dbda87fd7d46).\")\nStacktrace: Traceback (most recent call last):\n  File \"E:\\Data\\FlexiCadastreGPService\\FlexiCadastreGPService Beta\\BulkProjectShapes.py\", line 1586, in <module>\n    blnSuccess = ProjectShapes(objDBCon, strGeoTransformationPrefix)\n  File \"E:\\Data\\FlexiCadastreGPService\\FlexiCadastreGPService Beta\\BulkProjectShapes.py\", line 1516, in ProjectShapes\n    CreateShapeGeometriesFromPartGeometries(objDBCons, guidMappingSpatialReference, guidSpatialAnalysisSpatialReference)\n  File \"E:\\Data\\FlexiCadastreGPService\\FlexiCadastreGPService Beta\\BulkProjectShapes.py\", line 1336, in CreateShapeGeometriesFromPartGeometries\n    \"AND tblShape.guidSpatialReference <> @guidMappingSpatialReference\").format(guidMappingSpatialReference))\n  File \"E:\\Data\\FlexiCadastreGPService\\FlexiCadastreGPService Beta\\pypyodbc.py\", line 1605, in execute\n    self.execdirect(query_string)\n  File \"E:\\Data\\FlexiCadastreGPService\\FlexiCadastreGPService Beta\\pypyodbc.py\", line 1631, in execdirect\n    check_success(self, ret)\n  File \"E:\\Data\\FlexiCadastreGPService\\FlexiCadastreGPService Beta\\pypyodbc.py\", line 986, in check_success\n    ctrl_err(SQL_HANDLE_STMT, ODBC_obj.stmt_h, ret, ODBC_obj.ansi)\n  File \"E:\\Data\\FlexiCadastreGPService\\FlexiCadastreGPService Beta\\pypyodbc.py\", line 958, in ctrl_err\n    raise IntegrityError(state,err_text)\nIntegrityError: (u'23000', u\"[23000] [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of UNIQUE KEY constraint 'UX_tblShapeGeometry'. Cannot insert duplicate key in object 'dbo.tblShapeGeometry'. The duplicate key value is (2203d525-12f9-4a74-8bb1-2db6e0cb8fa3, 27dcfa6a-c212-45aa-9191-dbda87fd7d46).\")\n\n",
   "parameterType": "esriGPParameterTypeDerived",
   "category": ""
  },
  {
   "name": "intExecutionTimeMilliSeconds",
   "dataType": "GPString",
   "displayName": "intExecutionTimeMilliSeconds",
   "description": "",
   "direction": "esriGPParameterDirectionOutput",
   "defaultValue": "0",
   "parameterType": "esriGPParameterTypeDerived",
   "category": ""
  }
 ]
}