Dieser Fehler wird durch eine fehlerhafter Registrierung der COM+-Anwendung IDUObjectHelper ausgelöst.

Betroffene Betriebssysteme

• Windows 2008, 64Bit

Fehlermeldung

Problem beim Auflösen eines Namens zur Berechtigungsprüfung
Ojektname: "WinNT://...."

Meldung: 006~ASP 0177~Server.CreateObject-Fehler~8007007e

Lösung

Starten Sie den Registrierungseditor. Navigieren Sie zum Schlüssel:
[HKEY_CLASSES_ROOT\Wow6432Node\CLSID\{610AD9B8-10CA-438D-AD7A-2B862EAB566A}]

Ändern Sie den Pfad-Teil im String Wert "InprocServer32".

Alter Wert: C:\Programme\
Neuer Wert: C:\Program Files (x86)\

Nach der Änderung sind keiner weiteren Aktionen erforderlich.

Beim Aufrufen einer beliebigen .asp-Datei im Browser erscheint folgende Meldung:

Die angeforderte Ressource wird bereits verwendet

Finden Sie unter http://support.microsoft.com/kb/920722/de eine Lösung des Problems.

Dieser Fehler hängt nicht direkt mit cardo zusammen.

Für Verbindungszeichenfolgen zu Datenbanken oder gewisse Konfigurationen im cardo werden die Namen der Datenbanktreiber benötigt, die auf dem System installiert sind. Bei 64-Bit Systemen ist darauf zu achten, dass die 32-Bit Treiber betrachtet werden. Gehen Sie wie folgt vor.

Wechseln Sie in den  Ordner "..\Windows\SysWOW64" (64-Bit System) bzw. "..\windows\System32" (32-Bit System) und führen Sie die Datei "odbcad32.exe" aus. Im Karteireiter "Drivers" bzw. "Treiber" finden Sie die Auflistung der installierten 32-Bit Treiber.
 

Systemvariablen wie %PATH_DATA% u.a. werden von cardo vorgegeben und können in den Einstellungen im cardo4 eingesehen werden. Die Systemvariablen sind nicht zu ändern.

Die Systemvariablen sind in den cardo4 Einstellungen unter Variablen zu finden.

Systemfehler (makeRedLine) INVALID-GEOM: Fehler bei der Konvertierung der Geometrie aus einem WKB Bytearray

Systemfehler (SAVECARDOINTERN): INVALID-GEOM: Fehler bei der Konvertierung der Geometrie aus einem WKB Bytearray

Beide Fehler können durch die gleiche Einstellung behoben werden. Auftreten tun diese Fehler im toPg oder im Geodateneditor.

In beiden Fällen müssen Sie die Variable bytea_output für die PostgreSQL-Datenbank definieren und den Wert escape zuweisen. Dies können Sie u.a. direkt im PgAdmin an der Datenbank erledigen.

Wenn cardo eine instabile Verbindung zur Postgres-Datenbank hat und Meldungen anzeigt wie :

'Die Verbindung zum Remotehost wurde geschlossen'

und im Log des Postgres-Servers Verbindungsabbrüche mit SocketError 10038 vermerkt sind, kann das an einer Drittanwendung liegen, die sich nicht mit Postgres verträgt.

In einem Fall stellte sich die VPN-Anwendung Astrill als Ursache heraus. Es könnten auch andere Programme wie Antivirensoftware eine Rolle spielen.

Der Startlink von cardo4 kann über die web.config (..\cardoSystem\CoreWeb3\IIS\net3) ausgeblendet werden. Die Vorlage ist in der web.config.template zu finden. Ergänzt werden muss folgender Eintrag:

<add key="PROJEKT.PREVENTCARDO4STARTLINK" value="true" />

(PROJEKT bitte mit Ihrem Projektnamen ersetzen!)

set search_path to km_meta,public

-> diese Abfrage zurvor in der cardo DB ausführen

select  * from (
select layerTitle,kurz,sourceId,coalesce(theServer,connectionString) as verbindung,coalesce(source,theLayer) as quelle
from
(
select    
                (select title from sec_mt_admin_tree where id = adm.parent_id) as parentFolderTitle,
                adm.title as layerTitle,                  --Title aus dem Admin-Tree
                lyr.id as sourceId,            --Id der Ebene
                lyr.kurz                --Name des Treibers, z.B. SQLSERVER
,AsBinaryFunction.val as AsBinaryFunction
,allowAsync.val as allowAsync
,bgColorAsName.val as bgColorAsName
,convertToGrayscale.val as convertToGrayscale
,epsgToCrsMap.val as epsgToCrsMap
,geomCacheDbKey.val as geomCacheDbKey
,httpProxyLogin.val as httpProxyLogin
,httpProxyServer.val as httpProxyServer
,httpSrvLogin.val as httpSrvLogin
,onlyInUserScope.val as onlyInUserScope
,theAccessHints.val as theAccessHints
,theAlign.val as theAlign
,theAlphaValue.val as theAlphaValue
,theAngleField.val as theAngleField
,theBGMode.val as theBGMode
,theBasePoint.val as theBasePoint
,theCacheMode.val as theCacheMode
,theConnectionTag.val as theConnectionTag
,theCountInfo.val as theCountInfo
,theDataBase.val as theDataBase
,theDrawMode.val as theDrawMode
,theDrawOrderHint.val as theDrawOrderHint
,theExtentInfo.val as theExtentInfo
,theField.val as theField
,theFieldList.val as theFieldList
,theFile.val as theFile
,theFilter.val as theFilter
,theFormatString.val as theFormatString
,theIdField.val as theIdField
,theImageType.val as theImageType
,theInitExtent.val as theInitExtent
,theJustifyField.val as theJustifyField
,theLabelField.val as theLabelField
,theLabelFontSymbol.val as theLabelFontSymbol
,theLayer.val as theLayer
,theLegTextField.val as theLegTextField
,theLegendImage.val as theLegendImage
,theMaxDrawCount.val as theMaxDrawCount
,theMaxScale.val as theMaxScale
,theMinScale.val as theMinScale
,thePALColor.val as thePALColor
,theParameterFields.val as theParameterFields
,thePrecision.val as thePrecision
,theProjection.val as theProjection
,thePwd.val as thePwd
,theRadiusField.val as theRadiusField
,theSRID.val as theSRID
,theScriptMakeImage.val as theScriptMakeImage
,theSearchPath.val as theSearchPath
,theServer.val as theServer
,theSizeField.val as theSizeField
,theSortField.val as theSortField
,theSrid.val as theSrid
,theSymbol.val as theSymbol
,theSymbolFile.val as theSymbolFile
,theSymbolSet.val as theSymbolSet
,theTableList.val as theTableList
,theTag.val as theTag
,theTextConversion.val as theTextConversion
,theTextField.val as theTextField
,theTransparencyColor.val as theTransparencyColor
,theUser.val as theUser
,theWhereStmt.val as theWhereStmt
,theXField.val as theXField
,theXOffset.val as theXOffset
,theYField.val as theYField
,theYOffset.val as theYOffset
,useDrawSel.val as useDrawSel
,usePool.val as usePool
,wasSessionServiceUrl.val as wasSessionServiceUrl
,wfsForceBBoxAsFilter.val as wfsForceBBoxAsFilter
,wfsForcePostOperation.val as wfsForcePostOperation
,wfsLayers.val as wfsLayers
,wfsSessionState.val as wfsSessionState
,wfsTimeout.val as wfsTimeout
,wfsUrl.val as wfsUrl
,wfsVersion.val as wfsVersion
,wfsXySwitchByEpsg.val as wfsXySwitchByEpsg
,wmsAdditionalAnyWhereArg.val as wmsAdditionalAnyWhereArg
,wmsAdditionalGetMapArg.val as wmsAdditionalGetMapArg
,wmsAlphaValue.val as wmsAlphaValue
,wmsClipRegion.val as wmsClipRegion
,wmsClipRegionBehavior.val as wmsClipRegionBehavior
,wmsFileCache.val as wmsFileCache
,wmsGetFeatureInfoFormatOrder.val as wmsGetFeatureInfoFormatOrder
,wmsGetMapFormatOrder.val as wmsGetMapFormatOrder
,wmsLayers.val as wmsLayers
,wmsMaxImageSize.val as wmsMaxImageSize
,wmsMinTimeout.val as wmsMinTimeout
,wmsScaleHintHandlingFromRemoteOnly.val as wmsScaleHintHandlingFromRemoteOnly
,wmsSessionState.val as wmsSessionState
,wmsTimeOut.val as wmsTimeOut
,wmsTransparentColor.val as wmsTransparentColor
,wmsTransparentColorRange.val as wmsTransparentColorRange
,wmsUrl.val as wmsUrl
,wmsVersion.val as wmsVersion
,source.val as source
,connectionString.val as connectionString
from
                sec_mt_admin_tree adm
inner join (select lyr.id,
                               driver.kurz
                   from
                               src_mt_source lyr
                   left join src_lu_driver driver
                               on lyr.ptr2_driver_id = driver.id
                ) lyr
                on adm.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'AsBinaryFunction' ) AsBinaryFunction on AsBinaryFunction.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'allowAsync' ) allowAsync on allowAsync.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'bgColorAsName' ) bgColorAsName on bgColorAsName.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'convertToGrayscale' ) convertToGrayscale on convertToGrayscale.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'epsgToCrsMap' ) epsgToCrsMap on epsgToCrsMap.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'geomCacheDbKey' ) geomCacheDbKey on geomCacheDbKey.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'httpProxyLogin' ) httpProxyLogin on httpProxyLogin.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'httpProxyServer' ) httpProxyServer on httpProxyServer.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'httpSrvLogin' ) httpSrvLogin on httpSrvLogin.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'onlyInUserScope' ) onlyInUserScope on onlyInUserScope.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theAccessHints' ) theAccessHints on theAccessHints.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theAlign' ) theAlign on theAlign.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theAlphaValue' ) theAlphaValue on theAlphaValue.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theAngleField' ) theAngleField on theAngleField.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theBGMode' ) theBGMode on theBGMode.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theBasePoint' ) theBasePoint on theBasePoint.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theCacheMode' ) theCacheMode on theCacheMode.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theConnectionTag' ) theConnectionTag on theConnectionTag.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theCountInfo' ) theCountInfo on theCountInfo.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theDataBase' ) theDataBase on theDataBase.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theDrawMode' ) theDrawMode on theDrawMode.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theDrawOrderHint' ) theDrawOrderHint on theDrawOrderHint.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theExtentInfo' ) theExtentInfo on theExtentInfo.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theField' ) theField on theField.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theFieldList' ) theFieldList on theFieldList.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theFile' ) theFile on theFile.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theFilter' ) theFilter on theFilter.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theFormatString' ) theFormatString on theFormatString.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theIdField' ) theIdField on theIdField.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theImageType' ) theImageType on theImageType.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theInitExtent' ) theInitExtent on theInitExtent.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theJustifyField' ) theJustifyField on theJustifyField.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theLabelField' ) theLabelField on theLabelField.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theLabelFontSymbol' ) theLabelFontSymbol on theLabelFontSymbol.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theLayer' ) theLayer on theLayer.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theLegTextField' ) theLegTextField on theLegTextField.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theLegendImage' ) theLegendImage on theLegendImage.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theMaxDrawCount' ) theMaxDrawCount on theMaxDrawCount.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theMaxScale' ) theMaxScale on theMaxScale.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theMinScale' ) theMinScale on theMinScale.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'thePALColor' ) thePALColor on thePALColor.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theParameterFields' ) theParameterFields on theParameterFields.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'thePrecision' ) thePrecision on thePrecision.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theProjection' ) theProjection on theProjection.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'thePwd' ) thePwd on thePwd.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theRadiusField' ) theRadiusField on theRadiusField.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theScriptMakeImage' ) theScriptMakeImage on theScriptMakeImage.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theSearchPath' ) theSearchPath on theSearchPath.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theServer' ) theServer on theServer.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theSizeField' ) theSizeField on theSizeField.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theSortField' ) theSortField on theSortField.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theSrid' ) theSrid on theSrid.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theSymbol' ) theSymbol on theSymbol.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theSymbolFile' ) theSymbolFile on theSymbolFile.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theSymbolSet' ) theSymbolSet on theSymbolSet.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theTableList' ) theTableList on theTableList.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theTag' ) theTag on theTag.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theTextConversion' ) theTextConversion on theTextConversion.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theTextField' ) theTextField on theTextField.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theTransparencyColor' ) theTransparencyColor on theTransparencyColor.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theUser' ) theUser on theUser.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theWhereStmt' ) theWhereStmt on theWhereStmt.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theXField' ) theXField on theXField.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theXOffset' ) theXOffset on theXOffset.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theYField' ) theYField on theYField.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'theYOffset' ) theYOffset on theYOffset.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'useDrawSel' ) useDrawSel on useDrawSel.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'usePool' ) usePool on usePool.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wasSessionServiceUrl' ) wasSessionServiceUrl on wasSessionServiceUrl.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wfsForceBBoxAsFilter' ) wfsForceBBoxAsFilter on wfsForceBBoxAsFilter.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wfsForcePostOperation' ) wfsForcePostOperation on wfsForcePostOperation.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wfsLayers' ) wfsLayers on wfsLayers.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wfsSessionState' ) wfsSessionState on wfsSessionState.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wfsTimeout' ) wfsTimeout on wfsTimeout.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wfsUrl' ) wfsUrl on wfsUrl.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wfsVersion' ) wfsVersion on wfsVersion.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wfsXySwitchByEpsg' ) wfsXySwitchByEpsg on wfsXySwitchByEpsg.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wmsAdditionalAnyWhereArg' ) wmsAdditionalAnyWhereArg on wmsAdditionalAnyWhereArg.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wmsAdditionalGetMapArg' ) wmsAdditionalGetMapArg on wmsAdditionalGetMapArg.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wmsAlphaValue' ) wmsAlphaValue on wmsAlphaValue.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wmsClipRegion' ) wmsClipRegion on wmsClipRegion.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wmsClipRegionBehavior' ) wmsClipRegionBehavior on wmsClipRegionBehavior.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wmsFileCache' ) wmsFileCache on wmsFileCache.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wmsGetFeatureInfoFormatOrder' ) wmsGetFeatureInfoFormatOrder on wmsGetFeatureInfoFormatOrder.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wmsGetMapFormatOrder' ) wmsGetMapFormatOrder on wmsGetMapFormatOrder.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wmsLayers' ) wmsLayers on wmsLayers.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wmsMaxImageSize' ) wmsMaxImageSize on wmsMaxImageSize.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wmsMinTimeout' ) wmsMinTimeout on wmsMinTimeout.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wmsScaleHintHandlingFromRemoteOnly' ) wmsScaleHintHandlingFromRemoteOnly on wmsScaleHintHandlingFromRemoteOnly.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wmsSessionState' ) wmsSessionState on wmsSessionState.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wmsTimeOut' ) wmsTimeOut on wmsTimeOut.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wmsTransparentColor' ) wmsTransparentColor on wmsTransparentColor.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wmsTransparentColorRange' ) wmsTransparentColorRange on wmsTransparentColorRange.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wmsUrl' ) wmsUrl on wmsUrl.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'wmsVersion' ) wmsVersion on wmsVersion.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'source' ) source on source.ptr2_source_id = lyr.id
left join (select lyrProp.ptr2_source_id, lyrProp.val from  src_st_source_properties lyrProp inner join src_lu_properties props on props.id = lyrProp.ptr2_properties_id where name = 'connectionString' or name='db') connectionString on connectionString.ptr2_source_id = lyr.id
)a
)b
where not quelle is null
and not verbindung is null;

Hintergrund:

• für Schulungsnutzer nutzereigenen Daten zu löschen

Mein cardo: (gespeicherte Sitzungen, Abfragen, Anwendungen, GeoSQL Abfragen)

km_meta.cdo4_own_documents (Tabelle zur Speicherung meiner Dokumente, Dokument meint hier jegliche Art von persönlichen Informationen, z.B. Geodaten, gespeicherte Abfragen etc. (cardo4))

-> alle Einträge mit Schulungsaccount entfernen

delete from km_meta.cdo4_own_documents
where ds_creator = 'Schulungsnutzer'

Einstellungen (Karteneinstellungen, cardo Einstellungen)

km_meta.cdo4_settings (Tabelle für die benutzerspezifischen cardo-Grundeinstellungen (cardo 4))

-> alle Einträge mit Schulungsaccount entfernen

delete from km_meta.cdo4_settings
where ds_creator = 'Schulungsnutzer'

Favoriten und letzte Sitzung

km_meta.cdo_wellknown_users (Tabelle mit den im cardo bekannten Benutzern)

delete from km_meta.cdo_wellknown_users
where ds_creator = 'Schulungsnutzer'

Hinweis: Danach muss der Application Pool für cardo4 recycelt werden und cardo4 neu geladen werden. Falls im cardo4 dann folgende Meldung erscheint: ERROR: 23505: duplicate key value violates unique constraint "pk_cwo" bitte das cardo4 nochmal neu laden.

Prüfen Sie, ob die Dienste noch aktiv sind, ggf. müssen Sie diese neu starten.

Die Zusatzeigenschaften stehen in der Tabelle km_meta.sec_mt_admin_tree_extensions. Die Eigenschaften stehen dort auch nicht separat drin, sondern in großen XML.

Sie können bspw. eine Abfrage nutzen, um alle Admintreeknoten zu filtern, welche einen Lizenztext enthalten:

Select * from km_meta.sec_mt_admin_tree_extensions where type_name like 'IDU.cardo3.CoreModules.AdminTreeExtensions.AdditionalNodeAndLayerExtension' and serialized_data like '%<LicenseText>%'

Die ptr2_admin_tree_id können Sie im Suchfeld am Administrativen Baum im Managementcenter eingeben.

Das kann an fehlenden Berechtigungen liegen, was auch nach einem Windows-Update passieren kann.

Das Verzeichnis

%WINDIR%\temp\CardoRes

benötigt das Recht „Jeder“ => „Ändern“.

Die Dienste Log-Auswertung finden Sie unter Systemstatus / komplexe Logauswertung:

Die Filterkriterien sind entsprechend den Anforderungen anzugeben.

1. Ermittlung der ID des Ordners (Ebenenname = ein Name einer Ebene in diesem Ordner)

select * from km_meta.sec_mt_admin_tree smat where title like 'Ebenename'

2. Ausgabe der Shapepfade + Titel der Ebenen (parent_id ist die ID des Ordners aus der 1. Abfrage)

select * from km_meta.src_st_source_properties sssp inner join km_meta.sec_mt_admin_tree smat on smat.ptr2_source_id = sssp.ptr2_source_id where sssp.val like '%.shp' and smat.parent_id = XXX