Skip to main content
Question

Expose Hyperlinks from Excel

  • March 17, 2014
  • 1 reply
  • 18 views

dos_gis
Contributor
Forum|alt.badge.img+3
Hi, I'm wondering if there's a way to expose the hyperlink values from hyperlink defined text from an Excel file?  The FME reader shows the values as varchar.  If possible, I'd like to convert the values through FME rather than doing in Excel first.  

 

 

 

1 reply

david_r
Evangelist
  • March 19, 2014

We are running desktop and server at version 2022.1.2.0 (20220831 - Build 22627 - WIN64). One particular workbench that we published runs to completion in desktop, but fails in server. I've checked some other cases and articles (such as this one), but none of the causes (including available memory) or workarounds seem applicable.

When reviewing the job's log it seems to consistently fail at this step:

156	2023-5-4 15:09:41 | AttributeFilter_NBI <MISSING> Transformer Output Nuker (TeeFactory): Cloned 0 input feature(s) into 0 output feature(s)
157	2023-5-4 15:09:41 | AttributeFilter_NBI <NULL> Transformer Output Nuker (TeeFactory): Cloned 0 input feature(s) into 0 output feature(s)
158	2023-5-4 15:09:41 | StringFormatter_NBI_Leading_Zeros_2 (TestFactory): Tested 7132 input feature(s) -- 7132 feature(s) passed and 0 feature(s) failed
159	2023-5-4 15:09:41 | GeometryRemover (TeeFactory): Cloned 1238 input feature(s) into 1238 output feature(s)
160	2023-5-4 15:09:41 | StringFormatter_NBI_Leading_Zeros_1 (TestFactory): Tested 1238 input feature(s) -- 1238 feature(s) passed and 0 feature(s) failed

I checked the two cases where we were using string formatter in that workbench and updated them to a new version. Ran it in desktop and then republished it to server, but still had the same issue.

The engine's log looks like this when it fails:

Thu-04-May-2023 02:07:24.176 PM   INFORM   Thread-868   _Engine1   GEODATABASE_SDE readerRead 130000 features
Thu-04-May-2023 02:07:27.490 PM   INFORM   Thread-868   _Engine1   GEODATABASE_SDE readerRead 140000 features
Thu-04-May-2023 02:07:30.595 PM   INFORM   Thread-868   _Engine1   GEODATABASE_SDE readerRead 150000 features
Thu-04-May-2023 02:07:34.701 PM   INFORM   Thread-868   _Engine1   GEODATABASE_SDE readerRead 160000 features
Thu-04-May-2023 02:07:39.561 PM   INFORM   Thread-868   _Engine1   GEODATABASE_SDE readerRead 170000 features
Thu-04-May-2023 02:07:44.616 PM   INFORM   Thread-868   _Engine1   Emptying factory pipeline
Thu-04-May-2023 02:07:58.205 PM   WARN     _Engine1   393562 : Process "_Engine1ended unexpectedlyBeing restarted on attempt 1...
Thu-04-May-2023 02:07:58.206 PM   WARN     _Engine1   393563 : 
 
 1) Review the log file for the job that was running when the problem occurred.
 2) Check that the terminated program is not already running on the system.
 3) Check that correct license(sare in effect.
Thu-04-May-2023 02:07:58.207 PM   INFORM   _Engine1   393566 : Process "_Engine1waiting for process output listener threads to terminate...
Thu-04-May-2023 02:07:58.207 PM   INFORM   _Engine1   393569 : Process "_Engine1closing process stderr output stream

The portion where it says that the 'process ended unexpectedly' appears to be the issue, I'm just unsure how to troubleshoot it. Any suggestions would be appreciated.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings