Question

使用产品：iserver 9D  操作系统：contos 7 x64
数据类型： PostGIS ,Postgresql 9.6

数据显示不出来是咋回事？

Answer 1

您好，如果是显示不出来，您可以首先排查下，1.postgresql数据库的机器和您服务器上的机器之前相互是否正常ping通，2.可以尝试将您的工作空间存在postgresql里面，发布的时候发布postgresql的工作空间。

然后请您贴一下support\objectsjava\bin\log中的组件日志

Comments

getMapStatus 发生异常:当 mapParam.rectifyType 为 BYCENTERANDMAPSCALE 时，传入参数 mapParam.viewBounds([[0.0,0.0], [0.0,0.0]])非法。

2020-7-14 06:03:30

信息

rect ViewBounds的高度必须大于0 java.lang.IllegalArgumentException: rect ViewBounds的高度必须大于0 at com.supermap.mapping.Map.setViewBounds(Unknown Source) at com.supermap.services.providers.InnerUGCMapProvider.viewEntire(SourceFile:488) at com.supermap.services.providers.UGCMapProvider.viewEntire(SourceFile:459) at sun.reflect.GeneratedMethodAccessor139.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.supermap.server.impl.PerformanceProxyFactory$PerformanceProxyHandler.invoke(SourceFile:216) at com.sun.proxy.$Proxy34.viewEntire(Unknown Source) at com.supermap.services.components.impl.MapImpl.viewEntire(SourceFile:865) at com.supermap.services.rest.resources.impl.ThumbnailsResource.a(SourceFile:136) at com.supermap.services.rest.resources.impl.ThumbnailsResource.getResourceContent(SourceFile:60) at com.supermap.services.rest.DefaultMethodHandler.a(SourceFile:864) at com.supermap.services.rest.DefaultMethodHandler.handleGet(SourceFile:164) at com.supermap.services.rest.resources.ResourceBase.handleGet(SourceFile:927) at com.supermap.services.rest.resources.ResourceBase.handle(SourceFile:1350) at org.restlet.resource.Finder.handle(Finder.java:246) at org.restlet.routing.Filter.doHandle(Filter.java:159) at org.restlet.routing.Filter.handle(Filter.java:206) at org.restlet.routing.Router.doHandle(Router.java:431) at org.restlet.routing.Router.handle(Router.java:648) at org.restlet.routing.Filter.doHandle(Filter.java:159) at org.restlet.routing.Filter.handle(Filter.java:206) at org.restlet.routing.Filter.doHandle(Filter.java:159) at org.restlet.routing.Filter.handle(Filter.java:206) at org.restlet.routing.Filter.doHandle(Filter.java:159) at org.restlet.routing.Filter.handle(Filter.java:206) at org.restlet.routing.Filter.doHandle(Filter.java:159) at org.restlet.engine.application.StatusFilter.doHandle(StatusFilter.java:155) at org.restlet.routing.Filter.handle(Filter.java:206) at org.restlet.routing.Filter.doHandle(Filter.java:159) at org.restlet.routing.Filter.handle(Filter.java:206) at org.restlet.engine.CompositeHelper.handle(CompositeHelper.java:211) at org.restlet.engine.application.ApplicationHelper.handle(ApplicationHelper.java:84) at org.restlet.Application.handle(Application.java:384) at org.restlet.ext.servlet.ServletAdapter.service(ServletAdapter.java:206) at com.supermap.services.rest.servlets.ManagementServlet.service(SourceFile:174) at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) at com.supermap.server.host.webapp.handlers.WebAppRequestDispatcher.forward(SourceFile:63) at com.supermap.server.host.webapp.handlers.SelectForward.a(SourceFile:32) at com.supermap.server.host.webapp.handlers.ManagerServiceHandler.handle(SourceFile:237) at com.supermap.server.host.webapp.handlers.AbstractHandler.process(SourceFile:196) at com.supermap.server.host.webapp.handlers.AbstractHandler.a(SourceFile:222) at com.supermap.server.host.webapp.handlers.AbstractHandler.invokeLowerPriorityHandlers(SourceFile:211) at com.supermap.server.host.webapp.handlers.AbstractHandler.process(SourceFile:198) at com.supermap.server.host.webapp.handlers.BasicHandler.process(SourceFile:315) at com.supermap.server.host.webapp.ApplicationFilter.doFilter(SourceFile:247) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.filters.CorsFilter.handleNonCORS(CorsFilter.java:423) at org.apache.catalina.filters.CorsFilter.doFilter(CorsFilter.java:169) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.filters.HttpHeaderSecurityFilter.doFilter(HttpHeaderSecurityFilter.java:124) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1457) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748)

---

怎么发布 postgresql的工作空间？发布工作空间，远程连接，里面让选文件，怎么选数据库里的工作空间呀？还有我这是9D版本，发布服务的时候就没有 发布 PostGIS 数据服务这个选项

---

1.桌面保存为postgresql类型工作空间，2快速发布服务的选择工作空间类型为数据库有postgresql选项。3.发布的数据源是pogis类型，那么发布的数据服务就是pgis服务，4.您这个贴的不是组件日志，请您贴下组件日志，具体位置给你说明了

---

好的，服务器的还是连不上，本机连同一台postgis是可以的

发布存储到数据库里的工作空间，服务器上连的时候输入工作空间名称数据库用户名密码等信息后，到选择服务类型的时候是空白的列表，正常是 选择地图服务数据服务之类的，然后下一步就进行不下去了

2020-07-15 10:50:33 [error] 致命错误:  用户 "root" Password 认证失败
, ThreadID: , Timespan(ms): -14723414, ResourceID: -100, SourceCode: ()
2020-07-15 10:50:33 [error] fe_sendauth: no password supplied
, ThreadID: , Timespan(ms): 2, ResourceID: -100, SourceCode: ()
2020-07-15 10:50:33 [error] 连接数据库失败，请检查连接参数, ThreadID: , Timespan(ms): 0, ResourceID: ELf005, SourceCode: ()
2020-07-15 10:51:40 [error] 错误:  字段 "smindexlevel" 不存在
LINE 1: ...tName, SmTableName, SmDatasetType, SmRecordCount, SmIndexLev...
                                                             ^
, ThreadID: , Timespan(ms): 66835, ResourceID: -100, SourceCode: ()
2020-07-15 10:51:40 [error] 读取数据源系统表信息失败, ThreadID: , Timespan(ms): 0, ResourceID: ELc140, SourceCode: ()
2020-07-15 10:51:40 [error] 打开数据源supermap失败, ThreadID: , Timespan(ms): 0, ResourceID: ELc009, SourceCode: ()
2020-07-15 10:51:40 [error] 错误:  字段 "smindexlevel" 不存在
LINE 1: ...tName, SmTableName, SmDatasetType, SmRecordCount, SmIndexLev...
                                                             ^
, ThreadID: , Timespan(ms): 793, ResourceID: -100, SourceCode: ()
2020-07-15 10:51:40 [error] 读取数据源系统表信息失败, ThreadID: , Timespan(ms): 1, ResourceID: ELc140, SourceCode: ()
2020-07-15 10:51:40 [error] 打开数据源supermap失败, ThreadID: , Timespan(ms): 0, ResourceID: ELc009, SourceCode: ()
2020-07-15 10:51:41 [error] 错误:  字段 "smindexlevel" 不存在
LINE 1: ...tName, SmTableName, SmDatasetType, SmRecordCount, SmIndexLev...
                                                             ^
, ThreadID: , Timespan(ms): 674, ResourceID: -100, SourceCode: ()
2020-07-15 10:51:41 [error] 读取数据源系统表信息失败, ThreadID: , Timespan(ms): 0, ResourceID: ELc140, SourceCode: ()
2020-07-15 10:51:41 [error] 打开数据源supermap失败, ThreadID: , Timespan(ms): 0, ResourceID: ELc009, SourceCode: ()
2020-07-15 10:52:01 [error] 错误:  字段 "smindexlevel" 不存在
LINE 1: ...tName, SmTableName, SmDatasetType, SmRecordCount, SmIndexLev...
                                                             ^
, ThreadID: , Timespan(ms): 19826, ResourceID: -100, SourceCode: ()
2020-07-15 10:52:01 [error] 读取数据源系统表信息失败, ThreadID: , Timespan(ms): 0, ResourceID: ELc140, SourceCode: ()
0-07-15 10:50:33 [error] 致命错误:  用户 "root" Password 认证失败
, ThreadID: , Timespan(ms): -14723414, ResourceID: -100, SourceCode: ()
2020-07-15 10:50:33 [error] fe_sendauth: no password supplied
, ThreadID: , Timespan(ms): 2, ResourceID: -100, SourceCode: ()
2020-07-15 10:50:33 [error] 连接数据库失败，请检查连接参数, ThreadID: , Timespan(ms): 0, ResourceID: ELf005, SourceCode: ()
2020-07-15 10:51:40 [error] 错误:  字段 "smindexlevel" 不存在
LINE 1: ...tName, SmTableName, SmDatasetType, SmRecordCount, SmIndexLev...
                                                             ^
, ThreadID: , Timespan(ms): 66835, ResourceID: -100, SourceCode: ()
2020-07-15 10:51:40 [error] 读取数据源系统表信息失败, ThreadID: , Timespan(ms): 0, ResourceID: ELc140, SourceCode: ()
2020-07-15 10:51:40 [error] 打开数据源supermap失败, ThreadID: , Timespan(ms): 0, ResourceID: ELc009, SourceCode: ()
2020-07-15 10:51:40 [error] 错误:  字段 "smindexlevel" 不存在
LINE 1: ...tName, SmTableName, SmDatasetType, SmRecordCount, SmIndexLev...
                                                             ^
, ThreadID: , Timespan(ms): 793, ResourceID: -100, SourceCode: ()
2020-07-15 10:51:40 [error] 读取数据源系统表信息失败, ThreadID: , Timespan(ms): 1, ResourceID: ELc140, SourceCode: ()
2020-07-15 10:51:40 [error] 打开数据源supermap失败, ThreadID: , Timespan(ms): 0, ResourceID: ELc009, SourceCode: ()
2020-07-15 10:51:41 [error] 错误:  字段 "smindexlevel" 不存在
LINE 1: ...tName, SmTableName, SmDatasetType, SmRecordCount, SmIndexLev...
                                                             ^
, ThreadID: , Timespan(ms): 674, ResourceID: -100, SourceCode: ()
2020-07-15 10:51:41 [error] 读取数据源系统表信息失败, ThreadID: , Timespan(ms): 0, ResourceID: ELc140, SourceCode: ()
2020-07-15 10:51:41 [error] 打开数据源supermap失败, ThreadID: , Timespan(ms): 0, ResourceID: ELc009, SourceCode: ()
2020-07-15 10:52:01 [error] 错误:  字段 "smindexlevel" 不存在
LINE 1: ...tName, SmTableName, SmDatasetType, SmRecordCount, SmIndexLev...
                                                             ^
, ThreadID: , Timespan(ms): 19826, ResourceID: -100, SourceCode: ()
2020-07-15 10:52:01 [error] 读取数据源系统表信息失败, ThreadID: , Timespan(ms): 0, ResourceID: ELc140, SourceCode: ()
2020-07-15 10:53:18 [error] 几何对象非法, ThreadID: 1611392768, Timespan(ms): 53704, ResourceID: EFa005, SourceCode: ../../../Src/Geometry/UGGeoLine.cpp(868)
2020-07-15 10:53:18 [error] 几何对象非法, ThreadID: 1477699328, Timespan(ms): 180, ResourceID: EFa005, SourceCode: ../../../Src/Geometry/UGGeoLine.cpp(868)
2020-07-15 10:53:21 [error] 创建数据源失败, ThreadID: 1611392768, Timespan(ms): 3116, ResourceID: ELc017, SourceCode: ../../../Src/Engine/UGDataSources.cpp(434)
2020-07-15 10:53:21 [error] 创建数据源集合失败, ThreadID: 1611392768, Timespan(ms): 0, ResourceID: ELc112, SourceCode: ../../../Src/Engine/UGDataSources.cpp(435)
2020-07-15 10:53:21 [error] Path of SCI_file is invalid!!!  UGStrategyMapCacheFile::FromConfigFile.strPath =/opt/ly/data/dem/dem@chongqing_dem/dem@chongqing_dem.sct, ThreadID: 1611392768, Timespan(ms): 213, ResourceID: -100, SourceCode: ../../../Src/CacheFile/UGStrategyMapCacheFile.cpp(145)

---

服务器的iserver版本是9D，小版本是(V9.1.0)，这个不正常

本地iserver的版本是10i，连同一个postgis数据库这个是正常的

---

网络是通的

发布的时候的截图

---

您这个数据库是连接成功，请您在桌面中打开改pgis是否成功，因为从组件报错看，您的表是有损坏的，某些数据集类型不明确，请您检查下，打开的桌面版本要低于iserver版本