topic Re: SDE layer fails to draw in Data Management Questions https://community.esri.com/t5/data-management-questions/sde-layer-fails-to-draw/m-p/276301#M15906 <HTML><HEAD></HEAD><BODY><P>Yes, looking at the error message, you seem to be hitting that Bug.</P><P></P><P>What license level of ArcGGIS Desktop do you have? If it is Advanced or Standard, you can use the GP tools to import that shapefile into the enterprise gdb.</P></BODY></HTML> Thu, 02 Oct 2014 14:34:13 GMT AsrujitSengupta 2014-10-02T14:34:13Z SDE layer fails to draw https://community.esri.com/t5/data-management-questions/sde-layer-fails-to-draw/m-p/276300#M15905 <HTML><HEAD></HEAD><BODY><P>I have setup ArcSDE 10.1 on postgres 9.0 and added some shapefiles with shp2sde. When I try to add the layer to the map panel of ArcMap 10.1 I get the following error message :</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><SPAN>One or more layers failed to draw: sde.sde.medford_streets:&nbsp; Invalid SQL syntax [ERROR:&nbsp; syntax error at or near "." LINE 1: ...ord_streets.geom&nbsp; , sde.medford_streets. from&nbsp; sde.sde.medfo... &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ^ ::SQL state: 42601] [sde.sde.medford_streets] ---</SPAN><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Has anyone encountered this problem? I found this (<A class="jive-link-external-small" href="http://support.esri.com/en/bugs/nimbus/TklNMDgxNjcw" rel="nofollow" target="_blank">NIM081670 - Data imported into SDE using the 'shp2sde' command..</A> ), but I do not have the license required for the Register with Geodatabase tool. So any other solutions or suggestions are very welcome. Thanks!</P></BODY></HTML> Thu, 02 Oct 2014 07:31:26 GMT https://community.esri.com/t5/data-management-questions/sde-layer-fails-to-draw/m-p/276300#M15905 AntonBakker 2014-10-02T07:31:26Z Re: SDE layer fails to draw https://community.esri.com/t5/data-management-questions/sde-layer-fails-to-draw/m-p/276301#M15906 <HTML><HEAD></HEAD><BODY><P>Yes, looking at the error message, you seem to be hitting that Bug.</P><P></P><P>What license level of ArcGGIS Desktop do you have? If it is Advanced or Standard, you can use the GP tools to import that shapefile into the enterprise gdb.</P></BODY></HTML> Thu, 02 Oct 2014 14:34:13 GMT https://community.esri.com/t5/data-management-questions/sde-layer-fails-to-draw/m-p/276301#M15906 AsrujitSengupta 2014-10-02T14:34:13Z