Skip to main content
  • EN

Hello :)

 

I have some workbenches on the FME Server 2022 and I get for all of them the error:
2024-12-11 13:37:46 | java.sql.SQLException: Query failed (#20241211_123746_28965_mxxee): Unknown transaction ID: f6d2afb3-c2fa-4417-970c-375bf47d1c9f. Possibly expired? Commands ignored until end of transaction block

Is that something I can fix or is it a Server error that only admins can fix? 

It is some time ago I was running the workbench. I tested one on my Laptop for a small country and it went good. all other countries are too big that is why I choose the FME Server.

 

Any suggestions of what I can do?

Vanessa

HI Vanessa, probably need a little more information. Is this Oracle or MSSQL (the exact format in FME terminology is most helpful) and are you using a reader/writer/sqlexecutor? 

Have you inspected the geometry, for countries? and determined if the sql geometry in the database has a limit in disk size? With country polygons, there might be issues that the GeometryValidator can help to identiy, refer to the geometry section of this great article https://fme.safe.com/blog/2014/11/data-quality-checklist/ 

This article might help you identify duplicate vertices in the polygon, should that be the problem , though more a CAD/DGN issue https://support.safe.com/hc/en-us/articles/25407574340877-Data-QA-Identifying-Non-Consecutive-Duplicate-Vertices-with-FME

 

 

 

Hi ​@j.botterill, 

oh, yes sure.

I am using an SQLCreator for Starburst SQL query. I have to use an embed connection to use starburst on FME server.  It is awfully slow I think. 

Polygons look fine on the Laptop. It is boundaries of city level and a polygon created from OSM according to the speed limit (maxspeed). But I will consider your suggestions. 

 Thank you :)

Reply


Community Stats

30,351
Posts
115,336
Replies
38,078
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.