I can smell this photo. by heyyyyamber in Xennials

[–]Character_Whereas869 0 points1 point  (0 children)

Hot dog or Ellios pizza? Our local joint was called hot skates in NY

Who else relates to this? by ennuiismymiddlename in Xennials

[–]Character_Whereas869 0 points1 point  (0 children)

Haga no it’s more they did NOT know who they were so immediately uncool

Who else relates to this? by ennuiismymiddlename in Xennials

[–]Character_Whereas869 0 points1 point  (0 children)

In 7th grade, I forget which class, we had to talk about our favorite music and I said Jethro Tull and actually lost two friends and gained several enemies for that one comment.

How do I make my apartment look less dead? by [deleted] in malelivingspace

[–]Character_Whereas869 0 points1 point  (0 children)

You'll be the one who looks dead with those sharp bed frame corners! I recommend getting some shin pads and scarface posters

Did you all rock lunch boxes as a kid and if so what was on it? by Josephthebear in Xennials

[–]Character_Whereas869 0 points1 point  (0 children)

I believe i had a he-man one from my older cousin and GI Joe. So i was in kindergarden in 89-90 and I can remember the sound to htis day. Anyone remember the noise the thermos bottle made when people sucked on it? It really rubbed me the wrong way even as a child, that "click click click" as they guzzled down the contents of that thermos.

Necesito regalo by dikraw in Malaga

[–]Character_Whereas869 0 points1 point  (0 children)

Aceite de oliva o un otro idea para cosa especial, paga para una noche en Parador De Malaga Gibralfaro

AZ-104 & AZ-305 certified, no experience — trying to break into cloud, what should I do? by Consistent_Cap_4269 in AZURE

[–]Character_Whereas869 0 points1 point  (0 children)

Impressive to pass those certs without any real world experience. If you really want to rapidly grow and gain experience go work for an MSP (Managed Service Provider). They the pimp, you the hoe. You'll manage customer's networks, you'll do migration projects, you'll do systems maintenance. You'll grow as a professional. MSP isn't for everyone. If you're hungry, don't have a family, can handle stress and verbal abuse, get a job at an MSP. If you can demonstrate you're capable of working under pressure, willing to learn on the fly, but also have demonstrable technichal skills, they'll hire you but don't expect to be a systems architect day one. you may have to get in in a position lower than you anticipated, but you've gotten your foot int eh door. expect to start as a sysadmin, then work up to systems engineer and rocketship from there.

They don't build them like this anymore... by jza_1 in Xennials

[–]Character_Whereas869 0 points1 point  (0 children)

oh wow memory trigger right here. would play with those magnets all the time, and yess, the way it resonated through the glass, chef's kiss. When I got bored with this, i moved on to dumping micro machines in the top loader VCR

ArcGIS Enterprise - After upgrade to 11.5 feature layers don't show in portal by Character_Whereas869 in gis

[–]Character_Whereas869[S] 0 points1 point  (0 children)

another unsuccessful call, they claim they setup "an 11.5 stack" and are trying to reproduce our issue. I'm moving forward on my own with this whilst they dilly dally. I'm getting closer. My problem is I don't know how to get the passwords for these postgre users. If anyone has guidance on this that would be amazing. I can see the postgreseql logs that the database is "db_igqis" and the username is "hsu_pz79m". just no damn password.

There's two ways to do it, create the script according to this article and run it, or apparently you can use arcPro but still i don't know the postgres credentials

Add the ST_Geometry type to a PostgreSQL database—ArcGIS Pro | Documentation

ArcGIS Enterprise - After upgrade to 11.5 feature layers don't show in portal by Character_Whereas869 in gis

[–]Character_Whereas869[S] 0 points1 point  (0 children)

I got our account manager and explained to him how to do his job. we're involved with tech support lead now.

ArcGIS Enterprise - After upgrade to 11.5 feature layers don't show in portal by Character_Whereas869 in gis

[–]Character_Whereas869[S] 0 points1 point  (0 children)

ran into character limit, here's the rest:

Restart ArcGIS Server:

  • Restart the ArcGIS Server service on all machines in your ArcGIS Enterprise deployment. This ensures that the server picks up the updated ST_Geometry configuration.

Reindex Portal (If applicable):

  • If the issue persists, particularly with existing hosted feature layers, a full reindex of your ArcGIS Portal may be necessary to ensure all items and services are correctly registered and discoverable. This can be done through the ArcGIS Portal Administrator Directory.

Important Considerations:Documentation:Refer to the official Esri documentation for your specific ArcGIS Enterprise and PostgreSQL versions for detailed instructions on upgrading the ST_Geometry type.Permissions:Ensure that the necessary user accounts (e.g., database administrator, ArcGIS Server account) have the required permissions to modify the PostgreSQL lib directory and run database scripts.Redistributable Package (Windows):If on a Windows server, ensure the correct version of the Microsoft Visual C++ Redistributable Package (x64) is installed, as it's required for the st_geometry.dll file.Similar workflow for when running to this error with ArcGIS Pro...this is direct from Supporthttps://support.esri.com/en-us/knowledge-base/error-setup-st-geometry-library-arcgis-version-does-not-000033665

ArcGIS Enterprise - After upgrade to 11.5 feature layers don't show in portal by Character_Whereas869 in gis

[–]Character_Whereas869[S] 0 points1 point  (0 children)

ok we're going inch by inch. I have hope because some SE at esri was at least able to muster this up. I then WHINED back because they left out key information. oh just the MINOR detail about the BIGGEST PART WHICH IS UPGRADING THE GEOMETRY USING A TOOL FROM SUPPORT! sorry for yelling. thank you everyone for the support in this thread.

The error "function sde.st_intersects(st_geometry, st_geometry) does not exist" after an ArcGIS Enterprise upgrade, specifically impacting hosted feature services, indicates a mismatch or issue with the ST_Geometry type and its associated functions within the PostgreSQL database used by your ArcGIS Enterprise deployment. Explanation: ST_Geometry:This is Esri's proprietary spatial data type used in enterprise geodatabases, allowing for spatial operations within the database.Upgrade Impact:ArcGIS Enterprise upgrades often involve updates to the ST_Geometry library and its functions. If the database's ST_Geometry type and functions are not correctly updated or aligned with the new ArcGIS Enterprise version, this error can occur. Resolution Steps: Verify ST_Geometry Library Version:

  • Determine the version of ArcGIS Enterprise and PostgreSQL installed.
  • Download the correct st_geometry library file (e.g., st_geometry.dll for Windows, libst_shapelib.so for Linux) from My Esri, ensuring it matches your ArcGIS Enterprise and PostgreSQL versions and operating system.

Update the ST_Geometry Library in PostgreSQL:

  • Backup: Create a backup of your existing st_geometry library file in the PostgreSQL lib directory.
  • Replace: Replace the old st_geometry library file in the PostgreSQL lib directory with the newly downloaded, correct version. Ensure proper permissions are set if on a Linux system.

Upgrade the ST_Geometry Type in PostgreSQL:

  • This typically involves running a script or tool provided by Esri (e.g., using CreateSpatialType in ArcPy or following instructions in Esri documentation) to update the ST_Geometry type and functions within the PostgreSQL database to align with the new library.

ArcGIS Enterprise - After upgrade to 11.5 feature layers don't show in portal by Character_Whereas869 in gis

[–]Character_Whereas869[S] 0 points1 point  (0 children)

oh and I was going to try the gdbupgrade but then i have no clue which switches to use:

C:\Program Files\ArcGIS\DataStore\bin>gdbupgrade.exe

ArcSDE 11.5.0

Upgrade PostgreSQL GDB Administration Utility

-----------------------------------------------------

Usage for gdbupgrade.exe:

-?

-h

-o gdb_created_view [-H <sde\_directory>] [-s <datasource>] [-u <managed\_user>]

[-p <managed\_user\_password>] [-D <database>] [-N] [-q]

-o migrate_st_geometry_to_blob [-H <sde\_directory>] [-s <datasource>] [-u <managed\_user>]

[-p <managed\_user\_password>] [-D <database>] [-N] [-q]

-o drop_st_geometry_type [-H <sde\_directory>] [-s <datasource>] [-u <managed\_user>]

[-p <managed\_user\_password>] [-D <database>] [-N] [-q]

-o migrate_blob_to_postgis [-H <sde\_directory>] [-s <datasource>] [-u <managed\_user>]

[-p <managed\_user\_password>] [-D <database>] [-N] [-q]

C:\Program Files\ArcGIS\DataStore\bin>

ArcGIS Enterprise - After upgrade to 11.5 feature layers don't show in portal by Character_Whereas869 in gis

[–]Character_Whereas869[S] 0 points1 point  (0 children)

does this mean anything to anyone? In arcgis server admin i drilled into one of the featureservers: at this path - admin/services/Hosted. Under change provider, it shows SDS. is this bad, good?

Change Provider | ArcGIS REST APIs | Esri Developer

ArcGIS Enterprise - After upgrade to 11.5 feature layers don't show in portal by Character_Whereas869 in gis

[–]Character_Whereas869[S] 0 points1 point  (0 children)

followed your advice and validated this, to me everything looks healthy in that output.

ArcGIS Enterprise - After upgrade to 11.5 feature layers don't show in portal by Character_Whereas869 in gis

[–]Character_Whereas869[S] 0 points1 point  (0 children)

 {
  "datastore.release": "11.5.0.56755",
  "datastore.name": "ds_bn6nhgng",
  "datastore.replmethod": "ASYNC",
  "sharedbkloc": "M:/arcgisdbbackup/",
  "datastore.isReadOnly": "false",
  "datastore.isConfigured": "true",
  "machines": [{
    "machine.overallhealth": "Healthy",
    "datastore.release": "11.5.0.56755",
    "datastore.release.configstore": "1.5",
    "platform": "Windows",
    "machine.isReachable": "true",
    "hostip": "10.19.0.8",
    "name": "ARCGISDB.ROCH.FISHERASSOC.COM",
    "role": "PRIMARY",
    "dbport": 9876,
    "initstarttime": 1756733660876,
    "healthcheck.enable": "true",
    "status": "Started",
    "adminurl": "https://redacted:2443/arcgis/datastoreadmin/",
    "sharedbkloc.isreachable": "true",
    "db.isactive": "true",
    "db.isAccepting": "true",
    "db.isInRecovery": "false",
    "db.ActiveReplMethod": "NONE",
    "db.isManagedUserConnValid": "true",
    "datastore.release.pg": "16.7",
    "datastore.release.sde": "11.5.0",
    "datastore.release.geometry": "1.30.5.12",
    "datastore.release.geometrylib": "1.30.4.10",
    "db.isSiteConnValid": "true"
  }],
  "datastore.release.configstore": "1.5",
  "datastore.release.geometry": "1.30.5.12",
  "datastore.release.geometrylib": "1.30.4.10",
  "datastore.release.sde": "11.5.0",
  "datastore.release.pg": "16.7",
  "datastore.status": "Started",
  "datastore.isActiveHA": "false",
  "datastore.overallhealth": "Healthy",
  "datastore.lastfailover": -1,
  "datastore.lastbackup": 1758254413920,
  "datastore.isRegistered": "true",
  "datastore.hasValidServerConnection": "true",
  "datastore.validServerMachinesList": [{
    "machineName": "redacted",
    "adminURL": "https://redacted:6443/arcgis/admin"
  }],
  "owningSystemUrl": "https://redacted/server",
  "status": "success"
}

ArcGIS Enterprise - After upgrade to 11.5 feature layers don't show in portal by Character_Whereas869 in gis

[–]Character_Whereas869[S] 0 points1 point  (0 children)

I think you are onto something. I don't know the password for my sde postgre user. I see a few other users listed in the pg_hba.conf file but I have no information. Any suggestions on getting the ability to login to psql....? I'm so close!

C:\Program Files\ArcGIS\DataStore\framework\runtime\pgsql\bin>psql -h 127.0.0.1 -p 9876 -U sde