i am using Arcgis for Server and Arcgis Portal webmaps with Postgresql db.
Created a Feature Class with ArcCatalog and shared as Feature Service, so i am trying to add data to this Feature Class with a Sql Query.
(Geometry column name "shape")
i made success adding data with these queries;
<SPAN style="color: #101094; border: 0px; font-weight: inherit; font-size: inherit;">INSERT</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> </SPAN><SPAN style="color: #101094; border: 0px; font-weight: inherit; font-size: inherit;">INTO</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> sde</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">.</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">data_table </SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">(</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">objectid</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">,</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> name</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">,</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> globalid</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">,</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> shape</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">)</SPAN><SPAN style="color: #101094; border: 0px; font-weight: inherit; font-size: inherit;">VALUES</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> </SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">(</SPAN><SPAN style="color: #7d2727; border: 0px; font-weight: inherit; font-size: inherit;">21</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">,</SPAN><SPAN style="color: #7d2727; border: 0px; font-weight: inherit; font-size: inherit;">'dataname'</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">,</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">sde</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">.</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">next_globalid</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">(),</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">sde</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">.</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">ST_Geometry</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">(</SPAN><SPAN style="color: #7d2727; border: 0px; font-weight: inherit; font-size: inherit;">'point (622000 4122000)'</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">,</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> </SPAN><SPAN style="color: #7d2727; border: 0px; font-weight: inherit; font-size: inherit;">32635</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">)</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">);</SPAN>
or
<SPAN style="color: #101094; border: 0px; font-weight: inherit; font-size: inherit;">INSERT</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> </SPAN><SPAN style="color: #101094; border: 0px; font-weight: inherit; font-size: inherit;">INTO</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> sde</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">.</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">data_table </SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">(</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">objectid</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">,</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> name</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">,</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> globalid</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">,</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> shape</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">)</SPAN><SPAN style="color: #101094; border: 0px; font-weight: inherit; font-size: inherit;">VALUES</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> </SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">(</SPAN><SPAN style="color: #7d2727; border: 0px; font-weight: inherit; font-size: inherit;">21</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">,</SPAN><SPAN style="color: #7d2727; border: 0px; font-weight: inherit; font-size: inherit;">'dataname'</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">,</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">sde</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">.</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">next_globalid</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">(),</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">sde</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">.</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">ST_Geometry</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">(</SPAN><SPAN style="color: #7d2727; border: 0px; font-weight: inherit; font-size: inherit;">'point (622000 4122000)'</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">,</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> </SPAN><SPAN style="color: #7d2727; border: 0px; font-weight: inherit; font-size: inherit;">32635</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">)</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">);</SPAN>
or
<SPAN style="color: #101094; border: 0px; font-weight: inherit; font-size: inherit;">INSERT</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> </SPAN><SPAN style="color: #101094; border: 0px; font-weight: inherit; font-size: inherit;">INTO</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> sde</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">.</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">data_table </SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">(</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">objectid</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">,</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> name</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">,</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> globalid</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">,</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> shape</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">)</SPAN><SPAN style="color: #101094; border: 0px; font-weight: inherit; font-size: inherit;">VALUES</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> </SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">(</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">sde</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">.</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">next_rowid</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">(</SPAN><SPAN style="color: #7d2727; border: 0px; font-weight: inherit; font-size: inherit;">'sde'</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">,</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> </SPAN><SPAN style="color: #7d2727; border: 0px; font-weight: inherit; font-size: inherit;">'data_table'</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">),</SPAN><SPAN style="color: #7d2727; border: 0px; font-weight: inherit; font-size: inherit;">'dataname'</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">,</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">sde</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">.</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">next_globalid</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">(),</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">sde</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">.</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">ST_Geometry</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">(</SPAN><SPAN style="color: #7d2727; border: 0px; font-weight: inherit; font-size: inherit;">'point (622000 4122000)'</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">,</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;"> </SPAN><SPAN style="color: #7d2727; border: 0px; font-weight: inherit; font-size: inherit;">32635</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">)</SPAN><SPAN style="color: #303336; border: 0px; font-weight: inherit; font-size: inherit;">);</SPAN>
My problem is;
I can see data with Arcmap's and Webmap created with Portal Attribute Table, but i cannot see point symbol on the map, it is there but no symbol, also i cannot identify with a mouse click. Just like a hidden object.
PostgreSQL 9.4.5 / Arcmap 10.4 / Arcgis For Server / Arcgis Portal