POST
|
I have a python gp script (all v9.3.1) that runs fine if I run it 'standalone' in the python shell, but when I run it from a GP service in AGS, it immediately throws an error "ERROR 000735: OutZipFile: Value is required". None of the logging nor gp.AddMessage's that I have in the script are being recorded, so it's failing at the get-go. I copied the Portland Clip and Ship example from the 'GP service examples' in ArcTutor as closely as possible (albeit v10) in terms of the way my GP service parameters are set up and how the associated variables are handled in the script, so I wouldn't expect this to fail. But obviously I'm missing something. Some background... python script:
queryExpr = "APINumber in (" + gp.GetParameterAsText(0) + ")"
emailAddr = gp.GetParameterAsText(1)
metadata = gp.GetParameterAsText(2)
outputShapeName = gp.GetParameterAsText(3)
outZipFile = arcpy.GetParameterAsText(4)
if outZipFile == '#' or not outZipFile:
outZipFile = outZipDir + "/" + outputShapeName.replace(".shp",".zip")
GP Service parameters:
Parameter: ApiNumbers
Data Type: GPString
Display Name: ApiNumbers
Direction: esriGPParameterDirectionInput
Default Value:
Parameter Type: esriGPParameterTypeRequired
Category:
Parameter: Email
Data Type: GPString
Display Name: Email
Direction: esriGPParameterDirectionInput
Default Value:
Parameter Type: esriGPParameterTypeRequired
Category:
Parameter: ProdSummary
Data Type: GPString
Display Name: ProdSummary
Direction: esriGPParameterDirectionInput
Default Value:
Parameter Type: esriGPParameterTypeRequired
Category:
Parameter: InFileName
Data Type: GPString
Display Name: InFileName
Direction: esriGPParameterDirectionInput
Default Value:
Parameter Type: esriGPParameterTypeRequired
Category:
Parameter: OutZipFile
Data Type: GPDataFile
Display Name: OutZipFile
Direction: esriGPParameterDirectionOutput
Parameter Type: esriGPParameterTypeRequired
Category:
... View more
05-23-2011
09:54 PM
|
0
|
1
|
311
|
POST
|
Are there any known issues with deleting a feature/row from an SDE feature class with a straight DB 'delete' SQL command, outside of the SDE API? Would that leave any SDE artifacts around that we don't want?
... View more
03-21-2011
09:32 AM
|
0
|
1
|
687
|
POST
|
Works like a charm, thanks Robert! And thanks especially for the UniqueValueRenderer example which is exactly what I needed.
... View more
03-18-2011
12:40 PM
|
0
|
0
|
397
|
POST
|
Thanks for the quick response Robert. After a quick search I couldn't find any other forum threads where the changes to MapManager.mxml were explained. And it looks like the only references to symbology in MapManager.mxml are for drawing tools. Do you know if these changes have done elsewhere and if so, where I could get additional details? Barring that, is the FeatureLayer/AGS MapServer service the only option I have for displaying InfoWindows in v2.2 of the Flex Viewer w/ a 9.3.1 AGS service? Or has someone else overcome that as well? Thanks!
... View more
03-18-2011
10:50 AM
|
0
|
0
|
397
|
POST
|
I'm using the latest v2.2 of the Flex Viewer against v9.3.1 of AGS. In my viewer, I'm using a FeatureLayer as follows: <layer label="Wells" type="feature" visible="true" alpha="1"
info="widgets/InfoTemplates/SimpleInfoWinWidget.swf"
infoconfig="widgets/InfoTemplates/Wells_Simple.xml"
url="http://myServer/ArcGIS/rest/services/myService/MapServer/0"/> The reason for this is so that I can leverage the InfoWindow functionality in the viewer, which doesn't work when the layer 'type=dynamic'. Everything works as expected, but the layer is being symbolized with black circles (looks like a default setting) instead of the symbology from the server, as it does w/ AGS v10. Question: Is there a way to mimic the server-side symbology on the Flex client when using the v2.2 viewer against a v9.3.x service?
... View more
03-18-2011
10:16 AM
|
0
|
26
|
2272
|
POST
|
Success! The last step required was to upgrade the geodb to SP1 (can't do so w/ the dialog in ArcCatalog, since you have to connect to the db to upgrade but you can't upgrade if there are connections -- holy catch 22! -- so got around it by using a python script to do the upgrade, as described here). Next step is to see if I can get SQL SDE 32 running on same server. Will heed Vince's recommendation to have a separate SDEHOME. Fingers crossed... There were so many changes that it's hard to tell what the magic combination was, but in the end these were the material changes: - uninstall all ArcSDE instances besides Oracle (using 10g in this case, v10.2.0.4) - uninstall 64-bit version of ArcSDE for Oracle - install 32-bit version of ArcSDE for Oracle - make sure Oracle client version matches Oracle server version exactly (v10.2.0.4 in this case) - upgrade geodb to match exact ArcSDE version (v10 SP1) - follow instructions for Installing Oracle and ArcSDE on separate servers and Creating an ArcSDE service from a remote Windows server - copy correct versions of required shared libs (st_shapelib.dll, libst_raster_ora.dll) from SDEHOME\bin on SDE server to ORACLE_HOME\bin on Oracle server - copy correct versions of required shared libs (st_shapelib.dll, libst_raster_ora.dll, sg.dll) from SDEHOME\bin to ORACLE_HOME\bin on SDE server (may not be required but took this step nonetheless) - If SDE was upgraded, run post-intall to authorize it - moved SDEHOME(ORA)\bin to front of PATH but just after ORACLE_HOME\bin, which is first - make sure the following are set in dbinit.sde: set LOCAL=<ORACLE NET SERVICE NAME FROM TNSNAMES.ORA> set ORACLE_HOME=<ORACLE CLIENT HOME> set SDEHOME=<SDEHOME FOR ORACLE> - make sure ORACLE_SID is NOT set in dbinit.sde Thanks a ton to Vince A. for all his help.
... View more
03-14-2011
01:12 PM
|
0
|
0
|
430
|
POST
|
Previous post should read: "Would love to know how to kill a geodb lock *WITHOUT* an AS! And/or why there are locks at all after a reboot." Have since had st_shapelib.dll and libst_raster_ora.dll copied to Oracle server, still getting same erorrs when attempting to start the service.
... View more
03-14-2011
11:53 AM
|
0
|
0
|
430
|
POST
|
Quick follow-up: I just noticed that the st_shapelib.dll (and libst_raster_ora.dll) that were originally copied to the Oracle server long ago were the v10 versions, so we have to copy the v10 SP1 versions to Oracle. Though the message reported during the geodb upgrade was a warning only and I don't think of itself is the root cause of my connectivity issues. Would love to know how to kill a geodb lock w/ an AS! And/or why there are locks at all after a reboot.
... View more
03-13-2011
03:40 PM
|
0
|
0
|
430
|
POST
|
Thanks again Vince. Some updates today, but first, w/r/t "... or you can use *only* Direct Connect for accessing the Oracle ArcSDE database (it's not always necessary to run an application server)": Is it possible to: - register spatial views with a direct connection? - run the equivalent of 'sdemon' commands (and other CLI cmds) w/o an AS? If so, I'll happily avoid configuring an AS. That said, here's what I've done since our last correspondence: - uninstalled ORA SDE 64 and installed ORA SDE 32 - applied Oracle 10.2.0.4 patch set to 10.2.0.3 client (now matches Oracle server version) - copied sg.dll from %SDEHOME%\bin to %ORACLE_HOME%\bin (since Oracle is 1st in PATH) - Successfully ran SDE post-installer (did authorization only -- didn't create service or repo) - Created SDE service acc. to instructs - Ran command to start service acc. to instructs: Error: Access denied when starting esri_sde_ora2 instance on ora2. Operation Failed, Unable to start iomgr. If I tried to start the service w/ the Windows service mgr, I get: The ArcSde Service(esri_sde_ora2) service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Log and Alerts service. Windows Event Viewer didn't have any meaningful info. Then saw your most recent note, so: - uninstalled SQL SDE 32 (have not yet reinstalled) - applied v10 SP1 to ORA SDE 32 - ran post-install to authorize - moved SDEHOME(ORA)\bin to front of PATH but just after ORACLE_HOME\bin, which is first Still can't start service, getting: esri_sde_ora2 service failed during initialization. Please check event log or error log files. Error starting esri_sde_ora2 service(0) Could not start ArcSDE -- Check Network, $SDEHOME disk, DBMS settings and dbinit.sde. sde_esri_sde_ora2.log: Error opening Software\ESRI\ArcInfo\ArcSDE\ArcSDE for Oracle\esri_sde_ora2 key (131) ST_Geometry Schema Owner: (SDE) Type Release: 1007 Instance initialized for ((sde)) . . . Connected to instance . . . ERROR in checking system st_geometry type (1). Error checking the existence of system tables. Run the Upgrade Geodatabase tool to install/upgrade system tables (-450). Refer ArcSDE installation guide for instructions. Tried to upgrade the geodatabase (from ArcCatalog): Executing: UpgradeGDB "Database Connections\ORA2_sde_dc.sde" PREREQUISITE_CHECK NO_UPGRADE Start Time: Sun Mar 13 15:42:32 2011 Cannot upgrade because there are other active connections (SDE). Cannot upgrade because there are other active connections (SDE). User has privileges required to upgrade. Connected RDBMS instance is not setup for ST_GEOMETRY configuration. [Unable to determine current version of ST_SHAPELIB The latest ST_GEOMETRY and dependent libraries need to be copied to the correct software location. Please consult ArcSDE for Oracle Installation Guide for further details. ] Running Pre-Requisite check (C:\Documents and Settings\cbeaudette\Application Data\ESRI\Desktop10.0\ArcCatalog\ORA2_sde_dc.sde). Instance supports XML type. Failed to execute (UpgradeGDB). Failed at Sun Mar 13 15:42:34 2011 (Elapsed Time: 2.00 seconds) GDBUpgrade.log: [3/13/2011 3:26:21 PM] Error: Could not pause the database. [3/13/2011 3:26:21 PM] Error: Cannot upgrade because there are other active connections (SDE). [3/13/2011 3:26:21 PM] Error: Cannot upgrade because there are other active connections (SDE). [3/13/2011 3:26:21 PM] User has privileges required to upgrade. [3/13/2011 3:26:21 PM] Warning: Connected RDBMS instance is not setup for ST_GEOMETRY configuration. [Unable to determine current version of ST_SHAPELIB The latest ST_GEOMETRY and dependent libraries need to be copied to the correct software location. Please consult ArcSDE for Oracle Installation Guide for further details. ] [3/13/2011 3:26:21 PM] Running Pre-Requisite check (C:\Documents and Settings\cbeaudette\Application Data\ESRI\Desktop10.0\ArcCatalog\ORA2_sde_dc.sde). [3/13/2011 3:26:21 PM] Instance supports XML type. sdedc_Oracle.log: ST_Geometry Schema Owner: (SDE) Type Release: 1007 Instance initialized for ((sde)) . . . [Sun Mar 13 15:21:48 2011] [129] [GIS4] db_array_fetch_attrs OCI Fetch Error (28575) [Sun Mar 13 15:21:48 2011] [129] [GIS4] load_buffer error -51 on GDB_ITEMS, rowid -1 [Sun Mar 13 15:22:04 2011] [129] [GIS4] db_array_fetch_attrs OCI Fetch Error (28575) [Sun Mar 13 15:22:04 2011] [129] [GIS4] load_buffer error -51 on GDB_ITEMS, rowid -1 [Sun Mar 13 15:26:21 2011] [129] [GIS4] db_array_fetch_attrs OCI Fetch Error (28575) [Sun Mar 13 15:26:21 2011] [129] [GIS4] load_buffer error -51 on GDB_ITEMS, rowid -1 Can't kill connections w/ 'sdemon -o kill' since I don't have AS, so rebooted, tried again to update geodb, same errors. Per this thread, ran: select object_name, object_type, created, last_ddl_time, status from user_objects where object_type in ('OPERATOR','PACKAGE','PACKAGE BODY','INDEXTYPE','FUNCTION','TYPE','TYPE BODY'); The indextype ST_SPATIAL_INDEX is *NOT* missing from my database schema. (Attaching file 'ora_objects.txt'). Through all this, direct connections are still working to Oracle db. However geodb is one version behind (not yet SP1) from SDE.
... View more
03-13-2011
03:06 PM
|
0
|
0
|
430
|
POST
|
Two things to add to previous thread (though would appreciate responses to those as well): - I uninstalled the ORA SDE 64 bit and installed ORA SDE 32 and it installed fine but when attempting to run post-install, got a 'ArcSdeSetupOracle10g.exe - Entry Point Not Found' dialog that said, "The procedure entry point SgShapeGetParametricType could not be loaded in the dynamic link library sg.dll". Ugh. I made sure the 64-bit exes were all removed before installing the 32 bit version, and my SDEHOME is correctly set to C:\ESRI\ArcGIS\ArcSDE\ora10gexe\. - Maybe I can avoid the whole trying to get a 3-tier service-based connection to work if I can just register a spatial view after creating one w/ SQL (i.e. w/o having to run the 'sdelayer �??o register' command).
... View more
03-11-2011
03:48 PM
|
0
|
0
|
573
|
POST
|
Vince: Thanks so much for bearing with me on this... A few things: - If the 64-bit ArcSDE can't function w/ a 32-bit Oracle client, I'm confused as to why it's the only configuration that worked for direct connections (?). - I'll gladly uninstall the 64-bit ArcSDE and install the 32-bit if that will fix my problems. However will that be compatible with the installation of ArcGIS Server on the same machine? It's unclear to me if the ArcGIS Server installation is 32-bit or 64-bit (the installer doesn't differentiate like the SDE installer does, and there doesn't seem to be an easy way to figure it out). Do you think the best course of action at this point is to uninstall ORA SDE 64 and install ORA SDE 32? (What's more, if I have SDE 64 for SQL Server on the same machine, are there any shared DLLs that would hose my installation? If so, then I should also uninstall SQL SDE 64 and install SQL SDE 32?) - RE: " Does the SDEHOME reported by sdeservice -o list correspond to the ORA2 SDEHOME? . . . If you have multiple ArcSDE application servers running, you really should have multiple SDEHOME locations." Not sure what is meant by 'ORA2 SDEHOME' -- as specified where? I think I'm all set, but please let me know if I'm not: >sdeservice -o list SDE service Information -------------------------------------------------------------------- Error querying 5157 service RDBMS: Oracle Name: ArcSde Service(5157) SDEHOME: C:\ESRI\ArcGIS\ArcSDE\ora10gexe\ Version: 10.0 Status: RDBMS: Oracle Name: ArcSde Service(esri_sde_ora2) SDEHOME: C:\ESRI\ArcGIS\ArcSDE\ora10gexe\ Version: 10.0 Status: SERVICE_STOPPED RDBMS: SQLServer Name: ArcSde Service(esri_sde_sqlsvr) SDEHOME: C:\ESRI\ArcGIS\ArcSDE\sqlexe Datasource: GIS4 SDE_DBA_USER: sde Admin_database: sde Version: 10.0 Status: SERVICE_RUNNING That instance of 'service(5157)' is certainly curious -- it doesn't show up in my Windows Services. - What's Vince's *First* Law of Compatibility? 😉 Thanks again.
... View more
03-11-2011
02:07 PM
|
0
|
0
|
573
|
POST
|
Is your Oracle client 32-bit or 64-bit? Is your ArcSDE install 32-bit or 64-bit? Does the SDEHOME reported by sdeservice -o list correspond to the ORA2 SDEHOME? ArcSDE install is v10 SP1 64-bit. Oracle client is 32-bit (v10.2.0.3) which is the only version that enabled a direct connection and the version that I needed to install according to this FAQ. Version 10.2.0.3 of the client is the only 32-bit version that I could find to download on the Oracle Web site (note that Oracle server is v10.2.0.4). SDEHOME referenced by 'sdeservice -o list' reports 'C:\ESRI\ArcGIS\ArcSDE\ora10gexe\', which is correct. Not sure what is meant by 'ORA2 SDEHOME' -- as specified where? SDEHOME env var on local SDE machine *and* SDEHOME in %SDEHOME%\etc\dbinit.sde both match though.
... View more
03-11-2011
12:12 PM
|
0
|
0
|
573
|
POST
|
Thanks for your continued assistance with this Vince. I tried using the mnemonic for both 'sdeservice -o create' and 'sdemon -o start': sdeservice -o create -p <password> -d ORACLE10G,ORA2 -n -i esri_sde_ora2 sdemon -o start -i esri_sde_ora2 -p <password> But am getting the same error: Error starting esri_sde_ora2 service(0) Could not start ArcSDE -- Check Network, $SDEHOME disk, DBMS settings and dbinit.sde. I recalled reading somewhere that a udp entry is also required in the Windows services file, so I made that change as well on the SDE server and had our Oracle admin make the change on the Oracle server (also made to SDE services.sde file, but not sure it matters): esri_sde_ora2 5157/tcp #ArcSDE for Oracle esri_sde_ora2 5157/udp #ArcSDE for Oracle Still getting the same error. Also, not sure if it matters but our Oracle server is Windows 2008 R2, not Windows 2003 as I originally reported. Our SDE server is Windows 2003 SP2 x64.
... View more
03-11-2011
08:50 AM
|
0
|
0
|
573
|
POST
|
Thanks for the help and quick reply Vince -- much appreciated. I have to respectfully decline to open an incident with tech support since we are a development shop (EDN license only) and pay a premium for each ticket that we open. So we have to preserve those incidents for dire needs only. This issue seems like one that should be solvable with trial and error (and forums 🙂 since the documentation is falling short. I've tried recreating the service by passing the '-i <port>' since, as you noted, the service name and port # are interchangeable: sdeservice -o create -p memorial -d ORACLE10G,ORA2 -n -i 5157 I've verified that the %SystemRoot%\system32\drivers\etc\services file has the correct entry: esri_sde_ora2 5157/tcp #ArcSDE for Oracle and I corrected the dbinit.sde file after the sdeservice command was run so that the ORACLE_SID entry was commented and the LOCAL entry was added: ___________________________________________________ # Oracle SID for service esri_sde_ora2. # set ORACLE_SID=ORA2 set LOCAL=ORA2 set ORACLE_HOME=C:\oracle\product\10.2.0\client_1 set SDEHOME=C:\ESRI\ArcGIS\ArcSDE\ora10gexe ___________________________________________________ My Oracle Net service name is 'ORA2' and I can connect via SQLPlus and a SDE direct connection. When attempting to start the SDE service with the sdemon command: sdemon -o start -i 5157 I get the error: Error starting esri_sde_ora2 service(0) Could not start ArcSDE -- Check Network, $SDEHOME disk, DBMS settings and dbinit.sde. One thing that's confusing to me is that if there is no SDE service created on the remote Oracle server, why is it necessary to have an entry in the services file on that machine that corresponds to the entry on the ArcSDE server? Could that be why the error is occurring?
... View more
03-11-2011
08:10 AM
|
0
|
0
|
573
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|