Display Name: BulkProjectShapes

Description: BulkProjectShapes

Category:

Help URL: https://portal.miningcadastre.go.ke/arcgis/rest/directories/arcgisoutput/FlexiCadastreGPService_GPServer/FlexiCadastreGPService/BulkProjectShapes.htm

Execution Type: esriExecutionTypeAsynchronous

Parameters:

Parameter: strServerName

Data Type: GPString
Display Name strServerName
Description: strServerName
Direction: esriGPParameterDirectionInput
Default Value: SDRSA34\SQL2008R2Express
Parameter Type: esriGPParameterTypeRequired
Category:


Parameter: strDatabaseName

Data Type: GPString
Display Name strDatabaseName
Description: strDatabaseName
Direction: esriGPParameterDirectionInput
Default Value: FlexiCadastreBATestBarrickSAM2
Parameter Type: esriGPParameterTypeRequired
Category:


Parameter: strUserName

Data Type: GPString
Display Name strUserName
Description: strUserName
Direction: esriGPParameterDirectionInput
Default Value: sa
Parameter Type: esriGPParameterTypeRequired
Category:


Parameter: strEncryptedPassword

Data Type: GPString
Display Name strEncryptedPassword
Description: strEncryptedPassword
Direction: esriGPParameterDirectionInput
Default Value: phfgbzre
Parameter Type: esriGPParameterTypeRequired
Category:


Parameter: strIntegratedSecurity

Data Type: GPString
Display Name strIntegratedSecurity
Description: strIntegratedSecurity
Direction: esriGPParameterDirectionInput
Default Value: false
Parameter Type: esriGPParameterTypeRequired
Category:


Parameter: strGeoTransformationPrefix

Data Type: GPString
Display Name strGeoTransformationPrefix
Description: strGeoTransformationPrefix
Direction: esriGPParameterDirectionInput
Default Value: FlexiCadastre
Parameter Type: esriGPParameterTypeRequired
Category:


Parameter: blnSuccess

Data Type: GPBoolean
Display Name blnSuccess
Description:
Direction: esriGPParameterDirectionOutput
Default Value: false
Parameter Type: esriGPParameterTypeDerived
Category:


Parameter: strError

Data Type: GPString
Display Name strError
Description:
Direction: esriGPParameterDirectionOutput
Default Value: Type: Value: (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).") Stacktrace: Traceback (most recent call last): File "E:\Data\FlexiCadastreGPService\FlexiCadastreGPService Beta\BulkProjectShapes.py", line 1586, in blnSuccess = ProjectShapes(objDBCon, strGeoTransformationPrefix) File "E:\Data\FlexiCadastreGPService\FlexiCadastreGPService Beta\BulkProjectShapes.py", line 1516, in ProjectShapes CreateShapeGeometriesFromPartGeometries(objDBCons, guidMappingSpatialReference, guidSpatialAnalysisSpatialReference) File "E:\Data\FlexiCadastreGPService\FlexiCadastreGPService Beta\BulkProjectShapes.py", line 1336, in CreateShapeGeometriesFromPartGeometries "AND tblShape.guidSpatialReference <> @guidMappingSpatialReference").format(guidMappingSpatialReference)) File "E:\Data\FlexiCadastreGPService\FlexiCadastreGPService Beta\pypyodbc.py", line 1605, in execute self.execdirect(query_string) File "E:\Data\FlexiCadastreGPService\FlexiCadastreGPService Beta\pypyodbc.py", line 1631, in execdirect check_success(self, ret) File "E:\Data\FlexiCadastreGPService\FlexiCadastreGPService Beta\pypyodbc.py", line 986, in check_success ctrl_err(SQL_HANDLE_STMT, ODBC_obj.stmt_h, ret, ODBC_obj.ansi) File "E:\Data\FlexiCadastreGPService\FlexiCadastreGPService Beta\pypyodbc.py", line 958, in ctrl_err raise IntegrityError(state,err_text) IntegrityError: (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).")
Parameter Type: esriGPParameterTypeDerived
Category:


Parameter: intExecutionTimeMilliSeconds

Data Type: GPString
Display Name intExecutionTimeMilliSeconds
Description:
Direction: esriGPParameterDirectionOutput
Default Value: 0
Parameter Type: esriGPParameterTypeDerived
Category:

Supported Operations:   Submit Job