vscott1

Geoprocessing dilemma

Discussion created by vscott1 on May 26, 2017

Very odd situation here!

 

I'm trying to create a super easy geoprocessing service. Select a record from one table, then append it into another.

 

Development Database:

  • The model in ArcCatalog runs with no issues and adds the record as intended when using the development SQL Server database.
  • The results get shared as a geoprocessing service with no errors
  • From the rest end point I run a query to see if it works and the Job looks as follows:

 

Job Message:

 

esriJobMessageTypeInformative: Executing (FinForSaleEntDev12): FinForSaseEntDev12 105-01-073esriJobMessageTypeInformative: Start Time: Fri May 26 15:15:35 2017esriJobMessageTypeInformative: Executing (FinForSaseEntDev12): FinForSaseEntDev12 105-01-073esriJobMessageTypeInformative: Start Time: Fri May 26 15:15:35 2017esriJobMessageTypeInformative: Executing (Select): Select E:\arcgisserver\directories\arcgissystem\arcgisinput\Secure\FinForSaseEntDev12.GPServer\extracted\v101\EntDev12_Map_County_gisrun1.sde\MapCounty.GIS.CITY_PARCELS in_memory\FinForSale ""APN" = '105-01-073'"esriJobMessageTypeInformative: Start Time: Fri May 26 15:15:35 2017
esriJobMessageTypeInformative: Succeeded at Fri May 26 15:15:35 2017 (Elapsed Time: 0.25 seconds)

 

NOTE: compare to below/production bolded
esriJobMessageTypeInformative: Executing (Append): Append in_memory\FinForSale E:\arcgisserver\directories\arcgissystem\arcgisinput\Secure\FinForSaseEntDev12.GPServer\extracted\v101\EntDev12_Map_County_gisrun11.sde\MapCounty.GIS.FinanceForSale NO_TEST "APN "APN" true true false 16 Text 0 0 ,First,#,in_memory\FinForSale,APN,-1,-1;ADDRESS "ADDRESS" true true false 96 Text 0 0 ,First,#,in_memory\FinForSale,ADDRESS,-1,-1;CITY "CITY" true true false 40 Text 0 0 ,First,#,in_memory\FinForSale,CITY,-1,-1;ZIP "ZIP" true true false 24 Text 0 0 ,First,#,in_memory\FinForSale,ZIP,-1,-1;ASSESSOR_LOT_AREA "ASSESSOR_LOT_AREA" true true false 8 Double 8 38 ,First,#,in_memory\FinForSale,ASSESSOR_LOT_AREA,-1,-1;COUNCIL_DISTRICT "COUNCIL_DISTRICT" true true false 2 Short 0 5 ,First,#,in_memory\FinForSale,COUNCIL_DISTRICT,-1,-1;ZONING "ZONING" true true false 50 Text 0 0 ,First,#,in_memory\FinForSale,ZONING,-1,-1;MAJOR_XSTREETS "MAJOR_XSTREETS" true true false 254 Text 0 0 ,First,#,in_memory\FinForSale,MAJOR_XSTREETS,-1,-1;CURRENT_USE "CURRENT_USE" true true false 50 Text 0 0 ,First,#,in_memory\FinForSale,CURRENT_USE,-1,-1;CONTACT "CONTACT" true true false 100 Text 0 0 ,First,#,in_memory\FinForSale,CONTACT,-1,-1;CONTACT_PHONE "CONTACT_PHONE" true true false 15 Text 0 0 ,First,#,in_memory\FinForSale,CONTACT_PHONE,-1,-1;FLIER "FLIER" true true false 254 Text 0 0 ,First,#,in_memory\FinForSale,FLIER,-1,-1;LIST_PRICE "LIST_PRICE_NEW" true true false 8 Double 8 38 ,First,#,in_memory\FinForSale,LIST_PRICE,-1,-1;RFP "RFP" true true false 254 Text 0 0 ,First,#,in_memory\FinForSale,RFP,-1,-1;Shape.STArea() "Shape.STArea()" false false true 0 Double 0 0 ,First,#;Shape.STLength() "Shape.STLength()" false false true 0 Double 0 0 ,First,#" #esriJobMessageTypeInformative: Start Time: Fri May 26 15:15:35 2017esriJobMessageTypeInformative: Succeeded at Fri May 26 15:15:36 2017 (Elapsed Time: 0.39 seconds)esriJobMessageTypeInformative: Succeeded at Fri May 26 15:15:36 2017 (Elapsed Time: 0.92 seconds)esriJobMessageTypeInformative: Succeeded at Fri May 26 15:15:36 2017 (Elapsed Time: 0.92 seconds)

 

 

 

Production Database:

  • The model in ArcCatalog runs with no issues and adds the record as intended when using the production SQL Server database.
  • The results get shared as a geoprocessing service with no errors
  • From the rest end point I run a query to see if it works and the Job looks as follows:

 

Job Messages:
esriJobMessageTypeInformative: Executing (FinForSaleEntPrd12): FinForSaleEntPrd12 105-01-073
esriJobMessageTypeInformative: Start Time: Fri May 26 14:11:54 2017
esriJobMessageTypeInformative: Executing (FinForSaleEntPrd12): FinForSaleEntPrd12 105-01-073
esriJobMessageTypeInformative: Start Time: Fri May 26 14:11:54 2017esriJobMessageTypeInformative: Executing (Select): Select E:\arcgisserver\directories\arcgissystem\arcgisinput\Secure\FinForSaleEntPrd12.GPServer\extracted\v101\mapcounty.gdb\CITY_PARCELS in_memory\FinForSale ""APN" = '105-01-073'"
esriJobMessageTypeInformative: Start Time: Fri May 26 14:11:54 2017
esriJobMessageTypeInformative: Succeeded at Fri May 26 14:11:57 2017 (Elapsed Time: 2.95 seconds)

 

NOTE: Compare to above/development bolded
esriJobMessageTypeInformative: Executing (Append): Append in_memory\FinForSale E:\arcgisserver\directories\arcgissystem\arcgisinput\Secure\FinForSaleEntPrd12.GPServer\extracted\v101\mapcounty.gdb\FinanceForSale NO_TEST "APN "APN" true true false 16 Text 0 0 ,First,#,in_memory\FinForSale,APN,-1,-1;ADDRESS "ADDRESS" true true false 96 Text 0 0 ,First,#,in_memory\FinForSale,ADDRESS,-1,-1;CITY "CITY" true true false 40 Text 0 0 ,First,#,in_memory\FinForSale,CITY,-1,-1;ZIP "ZIP" true true false 24 Text 0 0 ,First,#,in_memory\FinForSale,ZIP,-1,-1;ASSESSOR_LOT_AREA "ASSESSOR_LOT_AREA" true true false 8 Double 0 0 ,First,#,in_memory\FinForSale,ASSESSOR_LOT_AREA,-1,-1;COUNCIL_DISTRICT "COUNCIL_DISTRICT" true true false 2 Short 0 0 ,First,#,in_memory\FinForSale,COUNCIL_DISTRICT,-1,-1;ZONING "ZONING" true true false 50 Text 0 0 ,First,#,in_memory\FinForSale,ZONING,-1,-1;MAJOR_XSTREETS "MAJOR_XSTREETS" true true false 254 Text 0 0 ,First,#;CURRENT_USE "CURRENT_USE" true true false 50 Text 0 0 ,First,#;CONTACT "CONTACT" true true false 100 Text 0 0 ,First,#;CONTACT_PHONE "CONTACT_PHONE" true true false 15 Text 0 0 ,First,#;FLIER "FLIER" true true false 254 Text 0 0 ,First,#;LIST_PRICE "LIST_PRICE_NEW" true true false 8 Double 0 0 ,First,#;RFP "RFP" true true false 254 Text 0 0 ,First,#;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#,in_memory\FinForSale,Shape_Length,-1,-1,in_memory\FinForSale,Shape_length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0 ,First,#,in_memory\FinForSale,Shape_Area,-1,-1,in_memory\FinForSale,Shape_area,-1,-1" #
esriJobMessageTypeInformative: Start Time: Fri May 26 14:11:57 2017
esriJobMessageTypeInformative: Succeeded at Fri May 26 14:11:57 2017 (Elapsed Time: 0.39 seconds)
esriJobMessageTypeInformative: Succeeded at Fri May 26 14:11:58 2017 (Elapsed Time: 3.77 seconds)
esriJobMessageTypeInformative: Succeeded at Fri May 26 14:11:58 2017 (Elapsed Time: 3.77 seconds)

 


I'm totally stumped with this! ESRI Support is looking at this with me as well, but you brainiac's might be able to spot something as well (I hope!) It appears in the Append process if I use our development database, it uses the desired .sde database connection. If I use our production database it wants to append some non-existant file geodatabase?

 

Another set of eyes can't hurt!

 

SQL Server databases (same versions, same table structures, same permissions, etc)

ArcGIS Server 10.3.1

ArcGIS Desktop 10.3.1

Outcomes