CCTV processor error

[JoshWhite]

I tried to run the model and get the following error.  I do have some information already in each of the tables.  I don't find any help on this with the CCTV processor as it focuses on using ArcGIS Online which is not something I was interested in.  What in the world does this error mean?  How do I fix it? 

ERROR 999999: Error executing function.

The Microsoft Jet database engine cannot find the input table or query 'GDB_ObjectClasses'.  Make sure it exists and that its name is spelled correctly.

Failed to execute (Add Attachments).

Failed at Wed Sep 10 15:57:29 2014 (Elapsed Time: 0.14 seconds)

Failed to execute (CCTVtoAGOL).

Failed at Wed Sep 10 15:57:29 2014 (Elapsed Time: 14.97 seconds)

I want to run this model and just have my new results added to CCTVCondtions each time.  Is that not what the intent is here?  This model looks to create everything the first time, how do I alter it to just do what I want it to do?

[JoshWhite]

WOW!  That model is much more complicated!  This also means it works quite differently.  Since this has not been updated on the resource center yet I have some questions.

First, what does the option to Delete PACP table copies do?

Second, I notice the output schema is changed for CCTVConditions and Images or snapshots are no longer there.  I am unable to use the url for the photos path in the model parameter as it appears to want a local file path, this wont work in a web map as I'll need the url.

Third, what is the PACP XML Geodatabse schema?  I presume that creates the CCTVConditions table a certain way and then also eliminates the need to Enable Domains as in the previous version?

I may have other questions but I think this will get me started.

I keep getting an error that MediaCondID already exists and the model fails.  I don't understand why it already exists because I had to deal with the same thing with ArcGIS converting that first field to ObjectID so my model included that too.

[MikeMillerGIS]

First, what does the option to Delete PACP table copies do?

- This model copies the original PACP tables from Access into a FGDB and copies the ID fields to new fields to avoid the issue where is auto creates ObjectID fields.  This options will delete these copies to provide a clean output GDB.

Second, I notice the output schema is changed for CCTVConditions and Images or snapshots are no longer there.  I am unable to use the url for the photos path in the model parameter as it appears to want a local file path, this wont work in a web map as I'll need the url.

- Not sure I understand, the original never did this.  The photos were always embedded in the points as attachments.  Only the video paths were calculated from this parameter.  The photo path parameter allows the model to find the photos for loading.

Third, what is the PACP XML Geodatabse schema?  I presume that creates the CCTVConditions table a certain way and then also eliminates the need to Enable Domains as in the previous version?

- This model creates a new FGDB to save the result to. This is created from the XML workspace so the domains are all in place.

[JoshWhite]

First point, so is it recommended to have this box checked all of the time?  Would having this box checked avoid the error I got then?  I honestly can't remember if I had it checked or not.

Sorry Michael, the second point I figured out.  I had altered the original as I was having issues with attachments and just changed it to links.  I'm not sure that will be an option with this newer model so I may go back to trying attachments and working with you as necessary if for whatever reason they done work.

Third,  I think this is probably a good thing, I could easily alter this schema slightly if the need arose.

[MikeMillerGIS]

It is up to you if you want to delete the copies.  This has nothing to do with the error you are getting.  You are probably getting that error because you already processes the PACP output tables.  Start with a fresh export. 

[JoshWhite]

Well I finally got around to running it with clean copies straight from the access db.  I thought I fixed everything and I still have a whole slew of errors:

Start Time: Wed Oct 22 16:58:04 2014
Succeeded at Wed Oct 22 16:58:05 2014 (Elapsed Time: 1.15 seconds)
Executing (Points Along a Polyline by Distance): PointsAlongLineDistance "Database Connections\Connection to GIS-SERVER.sde\acgis.DBO.SanitarySewer\acgis.DBO.ssGravityMain" FACILITYID C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\Conditions Pipe_Segment_Reference Distance Direction Upstream Downstream C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb CCTVConditions
Start Time: Wed Oct 22 16:58:05 2014
Running script PointsAlongLineDistance...
Completed script PointsAlongLineDistance...
Succeeded at Wed Oct 22 16:58:26 2014 (Elapsed Time: 20.33 seconds)
Executing (Join TAPPOINTS+VIDEO): JoinField C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\CCTVConditions InspectionID C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\Media_Inspections InspectionID Video_Name;Video_Location
Start Time: Wed Oct 22 16:58:26 2014
Succeeded at Wed Oct 22 16:58:26 2014 (Elapsed Time: 0.35 seconds)
Executing (Calculate Field (2)): CalculateField C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\CCTVConditions Video_Location "http://70.167.59.150/Sewer/Videos" VB #
Start Time: Wed Oct 22 16:58:26 2014
WARNING 000405: No records within table
Succeeded at Wed Oct 22 16:58:26 2014 (Elapsed Time: 0.25 seconds)
Executing (Add VIDEO Field): AddField C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\CCTVConditions VIDEO_URL TEXT # # 150 "Video URL" NULLABLE NON_REQUIRED #
Start Time: Wed Oct 22 16:58:27 2014
Adding VIDEO_URL to C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\CCTVConditions...
Succeeded at Wed Oct 22 16:58:27 2014 (Elapsed Time: 0.38 seconds)
Executing (Calculate Field): CalculateField C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\CCTVConditions VIDEO_URL "[Video_Location] & [Video_Name]" VB #
Start Time: Wed Oct 22 16:58:27 2014
WARNING 000405: No records within table
Succeeded at Wed Oct 22 16:58:27 2014 (Elapsed Time: 0.26 seconds)
Executing (Assign Domain To Field): AssignDomainToField C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\CCTVConditions PACP_Code PACP_Codes #
Start Time: Wed Oct 22 16:58:27 2014
Succeeded at Wed Oct 22 16:58:28 2014 (Elapsed Time: 0.46 seconds)
Executing (Enable Attachments): EnableAttachments C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\CCTVConditions
Start Time: Wed Oct 22 16:58:28 2014
Succeeded at Wed Oct 22 16:58:29 2014 (Elapsed Time: 0.52 seconds)
Executing (Add Attachments): AddAttachments C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\CCTVConditions ConditionID C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\Media_Conditions ConditionID Image_Reference C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-24-2014\Mainline\Snapshots
Start Time: Wed Oct 22 16:58:29 2014
Succeeded at Wed Oct 22 16:58:29 2014 (Elapsed Time: 0.39 seconds)
Executing (Join Inspections To Pipe): AddJoin DBO.ssGravityMain_Layer FACILITYID C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\Inspections Pipe_Segment_Reference KEEP_COMMON
Start Time: Wed Oct 22 16:58:29 2014
Succeeded at Wed Oct 22 16:58:29 2014 (Elapsed Time: 0.08 seconds)
Executing (Copy Feature Custom): CopyFeatureCustom DBO.ssGravityMain_Layer C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb TelevisedMains
Start Time: Wed Oct 22 16:58:29 2014
Running script CopyFeatureCustom...
Completed script CopyFeatureCustom...
Succeeded at Wed Oct 22 16:58:31 2014 (Elapsed Time: 1.45 seconds)
Executing (Join Inspections Media): JoinField C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\TelevisedMains Inspections_InspectionID C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\Media_Inspections InspectionID Video_Name;Video_Location
Start Time: Wed Oct 22 16:58:31 2014
Succeeded at Wed Oct 22 16:58:31 2014 (Elapsed Time: 0.25 seconds)
Executing (Remove Join): RemoveJoin DBO.ssGravityMain_Layer #
Start Time: Wed Oct 22 16:58:31 2014
Succeeded at Wed Oct 22 16:58:31 2014 (Elapsed Time: 0.01 seconds)
Executing (Delete): Delete C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\Media_Conditions #
Start Time: Wed Oct 22 16:58:31 2014
Succeeded at Wed Oct 22 16:58:32 2014 (Elapsed Time: 0.16 seconds)
Executing (Delete (2)): Delete C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\Media_Inspections #
Start Time: Wed Oct 22 16:58:32 2014
Succeeded at Wed Oct 22 16:58:32 2014 (Elapsed Time: 0.16 seconds)
Executing (Delete (3)): Delete C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\Inspections #
Start Time: Wed Oct 22 16:58:32 2014
Succeeded at Wed Oct 22 16:58:32 2014 (Elapsed Time: 0.17 seconds)
Executing (Delete (4)): Delete C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\Conditions #
Start Time: Wed Oct 22 16:58:32 2014
Succeeded at Wed Oct 22 16:58:32 2014 (Elapsed Time: 0.17 seconds)
Executing (Calculate Field (3)): CalculateField C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\TelevisedMains Video_Location "http://70.167.59.150/Sewer/Videos" VB #
Start Time: Wed Oct 22 16:58:32 2014
WARNING 000405: No records within table
Succeeded at Wed Oct 22 16:58:32 2014 (Elapsed Time: 0.43 seconds)
Executing (Add VIDEO Field (2)): AddField C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\TelevisedMains VIDEO_URL TEXT # # 150 "Video URL" NULLABLE NON_REQUIRED #
Start Time: Wed Oct 22 16:58:33 2014
Adding VIDEO_URL to C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\TelevisedMains...
Succeeded at Wed Oct 22 16:58:33 2014 (Elapsed Time: 0.38 seconds)
Executing (Calculate Field (4)): CalculateField C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\TelevisedMains VIDEO_URL "[Video_Location] & [Video_Name]" VB #
Start Time: Wed Oct 22 16:58:33 2014
WARNING 000405: No records within table
Succeeded at Wed Oct 22 16:58:34 2014 (Elapsed Time: 0.43 seconds)
Executing (Add Trimmed Flag Field): AddField C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\TelevisedMains TRIMMEDFLAG TEXT # # 25 "Trimmed Flag" NULLABLE NON_REQUIRED #
Start Time: Wed Oct 22 16:58:34 2014
Adding TRIMMEDFLAG to C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\TelevisedMains...
Succeeded at Wed Oct 22 16:58:34 2014 (Elapsed Time: 0.38 seconds)
Executing (Trim Lines By Distance): TrimLinesByDistance C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\TelevisedMains Inspections_Length_Surveyed Inspections_Direction TRIMMEDFLAG Upstream Downstream
Start Time: Wed Oct 22 16:58:34 2014
Running script TrimLinesByDistance...
error on line: line 51
error in file name: C:\GIS\OTHER\ArcGISTemplates\CCTV processor\MapsandGDBs\CCTVTools.tbx#TrimLinesByDistance.py
with error message: RuntimeError: cannot open 'C:/Work/ArcGIS for Utilities/_Water/Staging/A4W-CCTVProcesser-v1_2/MapsandGDBs/CCTVOutput.gdb/TelevisedMains'
Completed script TrimLinesByDistance...
Failed to execute (Trim Lines By Distance).
Failed at Wed Oct 22 16:58:34 2014 (Elapsed Time: 0.06 seconds)
Failed to execute (CCTVObservationsToFeatures).
Failed at Wed Oct 22 16:58:35 2014 (Elapsed Time: 42.76 seconds)

[MikeMillerGIS]

It looks like the output is defaulting to my output location and not yours. Can you check the model and see if it is hard coded somewhere, it is would be around the trim lines python script.

[MikeMillerGIS]

Also, only the trimming of the lines to the survey length is failing, everything else is working, so you should be all set, just remove that part if you cannot figure it out.  I will look into why it is not getting the correct location. 

[MikeMillerGIS]

ok, stupid me, I had it hard code in the script, duh!

[JoshWhite]

I'm still getting a warning about no records being within the table.  I don't know what else to do to make this right.  There are no other errors, it even says it ran the TrimLinesByDistance successfully even though the output is empty.  I ran it a second time without deleted the tables and those tables returned with results without an issue but CCTVcondtions, the attachment table and TelevisedMains are empty.  I did replace the script with the above file.

[MikeMillerGIS]

Can you email me your stuff?