Estoy ejecutando un script de python contra la Geodatabase en Oracle, ArcGis Pro 3.1.6. , ArcGis Server 11.1, la conexion la paso por un archivo .sde, y el script se conecta, si existe borra la vista (OK), luego crea la Vista (ok, query en el debug), y luego registra en metadata, ahi falla con el codigo 999999 ¿alguna idea?
C:\Windows\system32>D:\Apps\ArcGIS\Server\framework\runtime\ArcGIS\bin\Python\envs\arcgispro-py3\python.exe D:\VRED\Pasajes\GISA-3547\crearVista_P.py "A001888" "D:\VRED\SharedTools\SDE.sde" "VIS_FC_OUTAGEAREA_EDIF_V"
2025-04-10 10:35:08,385 - INFO - Proceso iniciado...
2025-04-10 10:35:08,385 - INFO - Aguarde por favor...
2025-04-10 10:35:11,953 - INFO - Inicio
2025-04-10 10:35:11,954 - DEBUG - WITH OUTAGES
AS (SELECT table_outage.EXTERNALAREAID AS EXTERNALAREAID,
MAX (STATUSTYPE) AS STATUSTYPE,
LISTAGG (EQUIPMENTNAME || ' -> ' || TYPE || ' -> ' || SOURCESYSTEM || ':' || ORIGENID, CHR (10) ON OVERFLOW TRUNCATE) WITHIN GROUP (ORDER BY EQUIPMENTNAME) AS RESUME,
SUM(CLIENTS) AS CLIENTS
FROM(
SELECT Y.EXTERNALAREAID,
y.ALARMID,
y.ORIGENID,
y.SOURCESYSTEM,
y.EQUIPMENTNAME,
y.STATUSTYPE,
y.STATUSCODE,
y.PERCEIVEDSEVERITY,
y.ALARMDETAILS,
y.ALARMSTATE,
y."TYPE",
CASE
WHEN Y."TYPE" IN ('CAJA_DE_EDIFICIO', 'CAJA_DE_EDIFICIO_FTTH') THEN 'EDIFICIO'
ELSE 'AREA'
END AS TYPE_OUTAGE,
y.PLANT,
y.CLIENTS,
y.ADDRESS,
y.CPE,
TO_CHAR(y.OUTAGESTARTTIME, 'YYYY-MM-DD HH24:MI:SS') AS OUTAGESTARTTIME,
TO_CHAR(y.ALARMREPORTINGTIME, 'YYYY-MM-DD HH24:MI:SS') AS ALARMREPORTINGTIME,
TO_CHAR(y.OUTAGEENDTIME, 'YYYY-MM-DD HH24:MI:SS') AS OUTAGEENDTIME
FROM A001888.VIS_OUTAGES y
WHERE 1 = 1
AND y.ALARMSTATE NOT IN ('CLEARED')
) table_outage
group by table_outage.EXTERNALAREAID
HAVING LISTAGG(TYPE_OUTAGE, ',' ON OVERFLOW TRUNCATE) WITHIN GROUP (ORDER BY EQUIPMENTNAME) NOT LIKE '%AREA%'
),
AREAS AS (
SELECT vfta.areaid AS AREAID,
vfta.AREANAME AS AREACODE,
vfta.AREANAME AS NAME,
vfta.AREANAME AS DESCRIPTION,
VFTA.SHAPE
FROM sde.VIS_FC_TECHNICAL_AREAS vfta
)
SELECT
CAST (AREAID AS NUMBER (38, 0)) AS ID,
A.AREACODE,
O.RESUME,
STATUSTYPE,
O.CLIENTS,
A.SHAPE
FROM OUTAGES O, AREAS A
WHERE O.EXTERNALAREAID = A.AREAID
2025-04-10 10:35:17,960 - INFO - Vista borrada correctamente
2025-04-10 10:35:19,735 - INFO - Se creo la vista
2025-04-10 10:35:19,736 - INFO - Se registra la vista...
2025-04-10 10:35:20,069 - INFO - Posee campo Shape, registrando como vista geografica...
2025-04-10 10:35:21,984 - ERROR - ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.
Underlying DBMS error [Success]
Failed to execute (RegisterWithGeodatabase).
Gracias
Anibal M
Argentina
