Le portail francophone de la géomatique

Erwan · Mon 19 October 2009 13:53

Bonjour,

J'ai un gros souci avec l'affichage de mes couches liées à des requêtes.
Les erreurs (ci-dessous)
Je suis à la recherche d'indice...

Cordialement

R1

Code:

 
Error

Class : SoapFaultWrapper
Message : MapServer error: Error in msDrawMap(): Failed to draw layer named 'chimique'.

Error in msPOSTGISLayerWhichShapes(): Error executing POSTGIS SQL statement (in FETCH ALL): DECLARE mycursor BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d(geom)),'NDR'),oid::text from (SELECT geom AS geom, tron1 AS oid, method_lib, surface, lieu, revetement, passages
                        FROM (SELECT geom AS geom, tron1, method_lib, tron_surf as surface, lieu_lib as lieu, revet_lib as revetement
                              FROM (SELECT geom, tron1, method_lib, tron_surf, lieu_lib
                                    FROM (SELECT tron1, geom
                                          FROM (SELECT DISTINCT tron_id as tron1, ha_annee as annee, geom, ha_activite_id
                                                FROM troncon, histo_activite 
                                                WHERE tron_id = ha_tron_id AND geom <> '') AS T1
                                          INNER JOIN (SELECT tron_id as tron2, max(ha_annee) as max_annee 
                                                      FROM histo_activite, troncon
                                                      WHERE ha_tron_id = tron_id
                                                      GROUP BY tron_id) AS T2 
                                          ON annee = max_annee AND tron1 = tron2 AND ha_activite_id <> '3') AS T3
                                    INNER JOIN (SELECT DISTINCT tron_id as tron3, method_lib, tron_surf, lieu_lib
                                                FROM troncon, histo_desherb, desherbage, bib_methode, bib_lieu
                                                WHERE tron_lieu_id = lieu_id AND tron_id = hd_tron_id AND hd_desherb_id = desherb_id AND method_lib = 'Chimique'
                                                AND (SELECT EXTRACT (YEAR FROM hd_date)) = (SELECT EXTRACT (YEAR FROM (SELECT CURRENT_DATE)))
                                                AND desherb_method_id = method_id) AS T4
                                    ON tron3 = tron1) AS T5
                              INNER JOIN (SELECT tron_id as tron4, revet_lib 
                                          FROM (SELECT DISTINCT tron_id, hrev_annee as annee, revet_lib
                                                FROM troncon, histo_revet, bib_revetement 
                                                WHERE tron_id = hrev_tron_id AND hrev_revet_id = revet_id) AS T1
                                          INNER JOIN (SELECT tron_id as tron2, max(hrev_annee) as max_


Backtrace:

file: 230 - C:\ms4w\apps\cartoweb3\coreplugins\images\server\ServerImages.php
call: ServerContext->checkMsErrors()

file: 311 - C:\ms4w\apps\cartoweb3\server\Cartoserver.php
call: ServerImages->drawMainmap(Object(Images))

file: 349 - C:\ms4w\apps\cartoweb3\server\Cartoserver.php
call: Cartoserver->doGetMap(Object(MapRequest))

file: 370 - C:\ms4w\apps\cartoweb3\server\Cartoserver.php
call: Cartoserver->callWithExceptionCheck("doGetMap", Object(MapRequest))

file: 76 - C:\ms4w\apps\cartoweb3\server\MapResultCache.php
call: Cartoserver->cacheGetMap(Object(MapRequest))

file: 198 - C:\ms4w\apps\cartoweb3\server\MapResultCache.php
call: MapResultCache->getMapResultFromServer(Object(MapRequest))

file: 380 - C:\ms4w\apps\cartoweb3\server\Cartoserver.php
call: MapResultCache->getMap(Object(MapRequest))

file: 104 - C:\ms4w\apps\cartoweb3\client\CartoserverService.php
call: Cartoserver->getMap(Object(MapRequest))

file: 165 - C:\ms4w\apps\cartoweb3\client\CartoserverService.php
call: CartoserverService->callDirect("getMap", Object(MapRequest))

file: 233 - C:\ms4w\apps\cartoweb3\client\CartoserverService.php
call: CartoserverService->callFunction("getMap", Object(MapRequest))

file: 981 - C:\ms4w\apps\cartoweb3\client\Cartoclient.php
call: CartoserverService->getMap(Object(MapRequest))

file: 1135 - C:\ms4w\apps\cartoweb3\client\Cartoclient.php
call: Cartoclient->getMapResultFromRequest(Object(MapRequest))

file: 1315 - C:\ms4w\apps\cartoweb3\client\Cartoclient.php
call: Cartoclient->doMain()

file: 33 - C:\ms4w\apps\cartoweb3\htdocs\client.php
call: Cartoclient->main()

file: 3 - C:\ms4w\apps\cartoweb3\htdocs\carte_cbvl.php
call: require_once("C:\ms4w\apps\cartoweb3\htdocs\client.php")
/error

Dernière modification par Erwan (Mon 19 October 2009 13:55)

ThomasG · Mon 19 October 2009 16:16

Bonjour,

Ce serait possible d'avoir la partie du code original du mapfile qui génère cette erreur pour vous aider

du genre

Code:

DATA "the_geom FROM (votre_requete_avec_jointure) as foo using unique gid using SRID=27572"

Cordialement

ThomasG

Dernière modification par ThomasG (Mon 19 October 2009 16:16)

Erwan · Tue 20 October 2009 09:25

Bonjour,

Voilà.
Avec mes remerciements.

___________________

Code:

LAYER
        NAME chimique
        STATUS DEFAULT
        TYPE POLYGON
        CONNECTIONTYPE POSTGIS
        CONNECTION "host=localhost dbname=desherbage user=commune password=qcpDRGt5"
        DATA "geom FROM (SELECT geom AS geom, tron1 AS oid, method_lib, surface, lieu, revetement, passages
                        FROM (SELECT geom AS geom, tron1, method_lib, tron_surf as surface, lieu_lib as lieu, revet_lib as revetement
                              FROM (SELECT geom, tron1, method_lib, tron_surf, lieu_lib
                                    FROM (SELECT tron1, geom
                                          FROM (SELECT DISTINCT tron_id as tron1, ha_annee as annee, geom, ha_activite_id
                                                FROM troncon, histo_activite 
                                                WHERE tron_id = ha_tron_id AND geom <> '') AS T1
                                          INNER JOIN (SELECT tron_id as tron2, max(ha_annee) as max_annee 
                                                      FROM histo_activite, troncon
                                                      WHERE ha_tron_id = tron_id
                                                      GROUP BY tron_id) AS T2 
                                          ON annee = max_annee AND tron1 = tron2 AND ha_activite_id <> '3') AS T3
                                    INNER JOIN (SELECT DISTINCT tron_id as tron3, method_lib, tron_surf, lieu_lib
                                                FROM troncon, histo_desherb, desherbage, bib_methode, bib_lieu
                                                WHERE tron_lieu_id = lieu_id AND tron_id = hd_tron_id AND hd_desherb_id = desherb_id AND method_lib = 'Chimique'
                                                AND (SELECT EXTRACT (YEAR FROM hd_date)) = (SELECT EXTRACT (YEAR FROM (SELECT CURRENT_DATE)))
                                                AND desherb_method_id = method_id) AS T4
                                    ON tron3 = tron1) AS T5
                              INNER JOIN (SELECT tron_id as tron4, revet_lib 
                                          FROM (SELECT DISTINCT tron_id, hrev_annee as annee, revet_lib
                                                FROM troncon, histo_revet, bib_revetement 
                                                WHERE tron_id = hrev_tron_id AND hrev_revet_id = revet_id) AS T1
                                          INNER JOIN (SELECT tron_id as tron2, max(hrev_annee) as max_annee 
                                                      FROM histo_revet, troncon
                                                      WHERE hrev_tron_id = tron_id
                                                      GROUP BY tron_id) AS T2 
                                          ON annee = max_annee AND tron_id = tron2) AS T6
                              ON tron1 = tron4) AS T7
                        INNER JOIN (SELECT tron4, passages
                                    FROM (SELECT tron_id AS tron4
                                          FROM troncon
                                          WHERE geom <> '') t6
                                    INNER JOIN (SELECT count(hd_tron_id) AS passages, hd_tron_id
                                                FROM histo_desherb, desherbage, bib_methode
                                                WHERE (SELECT EXTRACT (YEAR FROM hd_date)) = (SELECT EXTRACT (YEAR FROM (SELECT CURRENT_DATE))) 
                                                AND desherb_method_id = method_id AND method_lib = 'Chimique' AND hd_desherb_id = desherb_id
                                                GROUP BY histo_desherb.hd_tron_id) t7
                                    ON t7.hd_tron_id = t6.tron4) t8
                        ON tron1 = tron4) AS new_table USING UNIQUE oid USING SRID=-1" 
        TEMPLATE "ttt"
        METADATA
        "id_attribute_string" "oid|int"
        "query_returned_attributes" "lieu revetement surface passages" 
        "hilight_createlayer" "false"
        "hilight_color" "255 255 0"
        "hilight_outlinecolor" "0 0 255 "
        "hilight_transparency" "100"
        END
        CLASS
            NAME "Chimique"
            STYLE
                COLOR 255 0 0 
                OUTLINECOLOR 32 32 32
            END #style
        END #class
    End #Layer

Erwan · Tue 20 October 2009 18:02

Bonsoir.

Mon problème est résolu, il s'agissait du SRID -1 qui ne semble plus accepté.

EL

Communauté	Ressources	L'emploi	Le marché	L'association	Fils RSS
Forum Blogs Wiki Planet Sites amis	Agenda Biblio Fiches AMO-CNIG Paris PCGIS Téléchargements	Offres d'emploi Banque de CV Formations Démarche Métiers	Geo-Entreprises Geo-Communiqué Appels d'offres	L'association Qui sommes-nous ? Nous aider Bienfaiteurs Partenaires Historique Statuts	Tout le site Job Géomatique Services GeoBlogs ...	Faire un don Mentions légales

Le portail francophone de la géomatique

Annonce

#1 Mon 19 October 2009 13:53

[cartoweb3] :

Code:

#2 Mon 19 October 2009 16:16

Re: [cartoweb3] :

Code:

#3 Tue 20 October 2009 09:25

Re: [cartoweb3] :

Code:

#4 Tue 20 October 2009 18:02

Re: [cartoweb3] :

Pied de page des forums