Model Failing on Translate LRM to LRM

anayoung · ‎07-06-2018

Hello,

I've been trying to edit a model (which I inherited) that keeps failing on the Translate Events from LRM to LRM. The message says that the XY tolerance is different between the source and target files. The problem appears to me that the source file is a shapefile and the target file is a feature class; the source shapefile is created by the Identity tool which uses a temporary folder on the C:\drive to store the shapefile and then goes through a series of geoprocessing steps before being entered into the LRM to LRM tool with the feature class.

I tried changing the output location of the source file to be the same geodatabase as the target file in the Identity tool step but then the tool fails to create an output in the geodatabase.

The weird thing is that there's another very similar model which works fine but I cannot find what the difference between them is other than the inputs and outputs. I'm a novice model maker so it's quite possible that I'm missing some fundamentals of model building here.

I have attached a copy of both models for your review; the one that fails is called " Recreate GP_MetroPlanningArea" and the one that works is called "Recreate GP Municipality". Also, attached, are screen shots of the error messages I have described above. The database I use for the original two files (i.e. "BM Metro Planning Areas" and "StatewideRoutes") is way to large to attach here.

Thanks,

Ana

curtvprice · ‎07-08-2018

Interestingly the example in the help has the input and the output in the same geodatabase. The example also has the same database set as the default workspace in the environment.

I think the issue is you the output workspace you are defining doesn't include the '.gdb' at the end of the path. Without that it will try to write the output a folder (not .gdb) which will not work. Hard to tell as your error messages are cut off so I can't see the complete paths. (By the way, you can copy and paste the complete error messages as text by opening the Geoprocessing > Results window, right click Messages, View.)

View solution in original post

curtvprice · ‎07-08-2018

Interestingly the example in the help has the input and the output in the same geodatabase. The example also has the same database set as the default workspace in the environment.

I think the issue is you the output workspace you are defining doesn't include the '.gdb' at the end of the path. Without that it will try to write the output a folder (not .gdb) which will not work. Hard to tell as your error messages are cut off so I can't see the complete paths. (By the way, you can copy and paste the complete error messages as text by opening the Geoprocessing > Results window, right click Messages, View.)

anayoung · ‎07-10-2018

Thank you, Curtis. I am looking into it.

>

anayoung · ‎07-11-2018

Hi Curtis,

It looks like the model is naming two different outputs: "Recreate_GP_MetroPlanningArea_20180706.gdb" and "%Staging.gdb%". I've been assuming that the %Staging.gdb% was just a reference to Recreate_GP_MetroPlanningArea_20180706.gdb

I don't get why the model creates the source event layer as a shapefile and the target is created as a feature class. I have highlighted in bold the creation of those files and the failure message below:

Executing: RecreateGPMetroPlanningArea U:\GPModels\MetropolitanPlanningAreas U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\BaseMap\BM_Metropolitan_Planning_Areas U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\StatewideRoutes "ToDate IS NULL AND "RouteID" = '999_LA 1_1_1_010'" 2017

Start Time: Fri Jul 06 11:31:41 2018

Executing (Calculate Value (Date)): CalculateValue time.strftime("%Y%m%d") # Variant

Start Time: Fri Jul 06 11:31:41 2018

Value = 20180706

Succeeded at Fri Jul 06 11:31:42 2018 (Elapsed Time: 0.12 seconds)

Executing (Create File GDB): CreateFileGDB U:\GPModels\MetropolitanPlanningAreas Recreate_GP_MetroPlanningArea_20180706 CURRENT

Start Time: Fri Jul 06 11:31:42 2018

Succeeded at Fri Jul 06 11:31:44 2018 (Elapsed Time: 2.30 seconds)

Executing (Feature Class to Feature Class (2)): FeatureClassToFeatureClass U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\StatewideRoutes U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb fc_StatewideRoutes "ToDate IS NULL AND "RouteID" = '999_LA 1_1_1_010'" "FromDate "FromDate" true true false 8 Date 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\StatewideRoutes,FromDate,-1,-1;ToDate "ToDate" true true false 8 Date 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\StatewideRoutes,ToDate,-1,-1;RouteID "RouteID" true true false 255 Text 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\StatewideRoutes,RouteID,-1,-1;SystemCode "SystemCode" true true false 4 Text 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\StatewideRoutes,SystemCode,-1,-1;RouteNameFull "RouteNameFull" true true false 100 Text 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\StatewideRoutes,RouteNameFull,-1,-1;InventoryDirection "InventoryDirection" true true false 3 Text 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\StatewideRoutes,InventoryDirection,-1,-1;FeatureTypeCode "FeatureTypeCode" true true false 2 Text 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\StatewideRoutes,FeatureTypeCode,-1,-1;SequenceNumber "SequenceNumber" true true false 3 Text 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\StatewideRoutes,SequenceNumber,-1,-1;DescriptionFrom "DescriptionFrom" true true false 255 Text 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\StatewideRoutes,DescriptionFrom,-1,-1;DescriptionTo "DescriptionTo" true true false 255 Text 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\StatewideRoutes,DescriptionTo,-1,-1;DominanceOrder "DominanceOrder" true true false 3 Text 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\StatewideRoutes,DominanceOrder,-1,-1;RouteNumber "RouteNumber" true true false 6 Text 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\StatewideRoutes,RouteNumber,-1,-1;created_user "created_user" false true false 255 Text 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\StatewideRoutes,created_user,-1,-1;created_date "created_date" false true false 8 Date 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\StatewideRoutes,created_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\StatewideRoutes,last_edited_user,-1,-1;last_edited_date "last_edited_date" false true false 8 Date 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\StatewideRoutes,last_edited_date,-1,-1;SHAPE_Length "SHAPE_Length" false true true 8 Double 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\StatewideRoutes,SHAPE_Length,-1,-1" #

Start Time: Fri Jul 06 11:31:44 2018

Succeeded at Fri Jul 06 11:31:54 2018 (Elapsed Time: 10.25 seconds)

Executing (Delete Field (2)): DeleteField U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_StatewideRoutes SystemCode;RouteNameFull;InventoryDirection;FeatureTypeCode;SequenceNumber;DescriptionFrom;DescriptionTo;DominanceOrder;RouteNumber;created_user;created_date;last_edited_user;last_edited_date

Start Time: Fri Jul 06 11:31:54 2018

Dropping SystemCode from U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_StatewideRoutes...

Dropping RouteNameFull from U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_StatewideRoutes...

Dropping InventoryDirection from U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_StatewideRoutes...

Dropping FeatureTypeCode from U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_StatewideRoutes...

Dropping SequenceNumber from U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_StatewideRoutes...

Dropping DescriptionFrom from U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_StatewideRoutes...

Dropping DescriptionTo from U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_StatewideRoutes...

Dropping DominanceOrder from U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_StatewideRoutes...

Dropping RouteNumber from U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_StatewideRoutes...

Dropping created_user from U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_StatewideRoutes...

Dropping created_date from U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_StatewideRoutes...

Dropping last_edited_user from U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_StatewideRoutes...

Dropping last_edited_date from U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_StatewideRoutes...

Succeeded at Fri Jul 06 11:32:00 2018 (Elapsed Time: 5.38 seconds)

Executing (Feature Class to Feature Class): FeatureClassToFeatureClass U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\BaseMap\BM_Metropolitan_Planning_Areas U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb fc_BM_City_Limits # "UUID "UUID" true true false 20 Text 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\BaseMap\BM_Metropolitan_Planning_Areas,UUID,-1,-1;MPO_Name "MPO_Name" true true false 50 Text 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\BaseMap\BM_Metropolitan_Planning_Areas,MPO_Name,-1,-1;Metro_Area_Code "Metro_Area_Code" true true false 5 Text 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\BaseMap\BM_Metropolitan_Planning_Areas,Metro_Area_Code,-1,-1;Date_Adopted "Date_Adopted" true true false 8 Date 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\BaseMap\BM_Metropolitan_Planning_Areas,Date_Adopted,-1,-1;Square_Miles "Square_Miles" true true false 8 Double 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\BaseMap\BM_Metropolitan_Planning_Areas,Square_Miles,-1,-1;created_user "created_user" false true false 255 Text 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\BaseMap\BM_Metropolitan_Planning_Areas,created_user,-1,-1;created_date "created_date" false true false 8 Date 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\BaseMap\BM_Metropolitan_Planning_Areas,created_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\BaseMap\BM_Metropolitan_Planning_Areas,last_edited_user,-1,-1;last_edited_date "last_edited_date" false true false 8 Date 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\BaseMap\BM_Metropolitan_Planning_Areas,last_edited_date,-1,-1;SHAPE_Length "SHAPE_Length" false true true 8 Double 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\BaseMap\BM_Metropolitan_Planning_Areas,SHAPE_Length,-1,-1;SHAPE_Area "SHAPE_Area" false true true 8 Double 0 0 ,First,#,U:\GPModels\MetropolitanPlanningAreas\RHWORK_20180615_1_1_1.gdb\BaseMap\BM_Metropolitan_Planning_Areas,SHAPE_Area,-1,-1" #

Start Time: Fri Jul 06 11:32:00 2018

Succeeded at Fri Jul 06 11:32:03 2018 (Elapsed Time: 3.17 seconds)

Executing (Delete Field): DeleteField U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_BM_City_Limits UUID;MPO_Name;Date_Adopted;Square_Miles;created_user;created_date;last_edited_user;last_edited_date

Start Time: Fri Jul 06 11:32:03 2018

Dropping UUID from U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_BM_City_Limits...

Dropping MPO_Name from U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_BM_City_Limits...

Dropping Date_Adopted from U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_BM_City_Limits...

Dropping Square_Miles from U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_BM_City_Limits...

Dropping created_user from U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_BM_City_Limits...

Dropping created_date from U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_BM_City_Limits...

Dropping last_edited_user from U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_BM_City_Limits...

Dropping last_edited_date from U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_BM_City_Limits...

Succeeded at Fri Jul 06 11:32:06 2018 (Elapsed Time: 2.96 seconds)

Executing (Identity): Identity U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_StatewideRoutes U:\GPModels\MetropolitanPlanningAreas\Recreate_GP_MetroPlanningArea_20180706.gdb\fc_BM_City_Limits C:\Temp\arcDEA9\fc_StatewideRoutes_Identity.shp ALL # NO_RELATIONSHIPS

Start Time: Fri Jul 06 11:32:07 2018

Reading Features...

Cracking Features...

Assembling Features...

Succeeded at Fri Jul 06 11:32:07 2018 (Elapsed Time: 0.82 seconds)

Executing (Dissolve): Dissolve C:\Temp\arcDEA9\fc_StatewideRoutes_Identity.shp C:\Temp\arcDEA9\fc_StatewideRoutes_Identity_.shp RouteID;Metro_Area # MULTI_PART DISSOLVE_LINES

Start Time: Fri Jul 06 11:32:08 2018

Sorting Attributes...

Dissolving...

Succeeded at Fri Jul 06 11:32:09 2018 (Elapsed Time: 0.45 seconds)

Executing (Multipart To Singlepart (2)): MultipartToSinglepart C:\Temp\arcDEA9\fc_StatewideRoutes_Identity_.shp C:\Temp\arcDEA9\fc_StatewideRoutes_Identity_1.shp