|
POST
|
Thanks Julie Powell ! Measurement in 2D | ArcGIS API for JavaScript 4.10
... View more
12-17-2018
01:28 PM
|
0
|
1
|
2332
|
|
POST
|
The analyst with my case suggested using arcpy.sharing instead of the overwrite function in arcgis python api. Introduction to arcpy.sharing—Sharing module | ArcGIS Desktop
... View more
12-17-2018
09:26 AM
|
0
|
2
|
6228
|
|
POST
|
This is in fact associated with the bug. The severity is logged as low. BUG-000115253: When using the overwrite method from arcgis.features.managers.FeatureLayerCollectionManager, ArcGIS API for Python returns the error "Exception: Job Failed.'' BUG-000115253: When using the overwrite method from arcgis.features..
... View more
12-12-2018
02:31 PM
|
1
|
3
|
6228
|
|
POST
|
ArcGIS Pro hasn't updated the arcgis python API since 1.4.1, yet the API is at 1.5. How might I access the help docs for previous versions? It would make sense that docs be made available for whatever version is being used in the flagship software.
... View more
12-11-2018
11:25 AM
|
0
|
0
|
532
|
|
POST
|
I guess Assumed Answered is legit because OPENQUERY does work! I just have no idea why im getting this intermittent error!
... View more
11-27-2018
03:59 PM
|
0
|
0
|
1843
|
|
POST
|
Give this a try: Problem: Unable to create environments or install packages after upgrading to ArcGIS Pro 2.2
... View more
11-27-2018
02:10 PM
|
0
|
0
|
2660
|
|
POST
|
Ghislain ghosted you! Give this a try: Problem: Unable to create environments or install packages after upgrading to ArcGIS Pro 2.2
... View more
11-27-2018
02:10 PM
|
1
|
0
|
5251
|
|
POST
|
The error is still occurring intermittently. Please remove the 'Assumed Answered' mark.
... View more
11-27-2018
12:50 PM
|
0
|
2
|
1843
|
|
POST
|
Oh, SSMS functions. Right. They are returning my user, and user with domain as prefix (Domain\user). Like magic, it is now running properly. I have no idea why. I'll come back to this thread if the problem occurs again. Thanks for your help.
... View more
11-27-2018
11:51 AM
|
0
|
4
|
1843
|
|
POST
|
Hi Joshua- Thanks for the reply. Have you used OPENQUERY in this context? Connection File Properties: I'm connecting as Operating System User. Execute: These attributes are not available. Could you share example syntax. Maybe im not calling them right. They aren't described on the help page. Security: SQL Server and Windows Authentication I'm going to try a connection file created with Pro.
... View more
11-27-2018
11:06 AM
|
0
|
6
|
1843
|
|
POST
|
Summary: Running ArcSDESQLExecute fails when using OPENQUERY. Error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.(18456) System: SQL Server 2008r2 (Enterprise Database - "DB1") and 2016 SP2 (Non-Enterprise Database connected with OPENQUERY - "DB2") Driver: ODBC Driver 13 for SQL Server Python: Pro 2.2.2 instance (3.6.5) Connection Files Created with Catalog 10.3.1 Details: Executing a simple query with ArcSDESQLExecute is successful. When OPENQUERY is used it appears credentials are not passed to the joined server/database. I've tested this with several users that are added as Logins to the Servers and Databases. This query runs properly in SQL Server Management Studio. Other SQL Log Errors: There is already an object named '##SDE_8868_184399_DB1' in the database. Invalid object name 'DB1.dbo.SDE_branches'. (208) Statement(s) could not be prepared. (8180) Invalid object name 'DB1.PSLARKIN.SDE_logfiles'. (208) <- Will reference my user name regardless of which OS user is set in the SDE connection file. Query: SELECT gis_ACO_NUM , PID_NUM FROM
(SELECT
LTRIM(RTRIM(ACO_NUM)) ACO_NUM
,LTRIM(RTRIM(PID_NUM)) PID_NUM
FROM DB1.DB1SCHEMA.SEGPOINTS
WHERE ( SUBSTRING(PID_NUM,6,1) = '.' AND LEN(PID_NUM) = 10 ) OR ( SUBSTRING(PID_NUM,6,1) = '.' AND LEN(PID_NUM) = 11 AND SUBSTRING(PID_NUM,11,1) NOT LIKE '%[^a-zA-Z]%' )
UNION
SELECT
LTRIM(RTRIM(ACO_NUM)) ACO_NUM
,LTRIM(RTRIM(PID_NUM)) PID_NUM
FROM DB1.DB1SCHEMA.SEGHISTORYPOINT
WHERE ( SUBSTRING(PID_NUM,6,1) = '.' AND LEN(PID_NUM) = 10 ) OR ( SUBSTRING(PID_NUM,6,1) = '.' AND LEN(PID_NUM) = 11 AND SUBSTRING(PID_NUM,11,1) NOT LIKE '%[^a-zA-Z]%' )
) AS segPoints
--section above the join will run correctly with ArcSDESQLExecute. Section below will not.
LEFT JOIN
(SELECT DISTINCT
CASE WHEN SUBSTRING(seg_merge_nbr,3,1) = '-' AND SUBSTRING(seg_merge_nbr,1,2) IN ('97','98','99') THEN '19' + REPLACE(seg_merge_nbr,'-','')
WHEN SUBSTRING(seg_merge_nbr,3,1) = '-' AND SUBSTRING(seg_merge_nbr,1,2) IN ('00') THEN '20' + REPLACE(seg_merge_nbr,'-','')
ELSE seg_merge_nbr
END gis_ACO_NUM
,parent_parcel
FROM OPENQUERY(DB2Server,'SELECT seg_merge_nbr,parent_parcel,seg_status_cd FROM DB2Server.DB2.DB2Schema.seg_merge')
where seg_status_cd = 'DONE'
) AS asc_seg
ON ACO_NUM = gis_ACO_NUM AND PID_NUM = parent_parcel
WHERE gis_ACO_NUM is not null
... View more
11-27-2018
09:55 AM
|
1
|
9
|
2028
|
|
POST
|
Thanks Kory Kramer Do you have any idea if this will integrated into arcpy? Specifically the method exportToPDF in the Map Series Class? MapSeries—ArcPy | ArcGIS Desktop
... View more
11-15-2018
01:57 PM
|
0
|
18
|
2926
|
|
POST
|
I ended up tearing down this widget and starting over again.
... View more
10-25-2018
01:26 PM
|
0
|
3
|
823
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 07-06-2022 02:52 PM | |
| 1 | 07-27-2023 10:51 AM | |
| 2 | 11-14-2023 08:48 AM | |
| 1 | 10-27-2021 11:50 AM | |
| 2 | 12-11-2023 04:10 PM |
| Online Status |
Offline
|
| Date Last Visited |
04-29-2024
11:30 AM
|