Question
Expose Hyperlinks from Excel
+3- Contributor
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.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
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) failedI 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 reader: Read 130000 features
Thu-04-May-2023 02:07:27.490 PM INFORM Thread-868 _Engine1 GEODATABASE_SDE reader: Read 140000 features
Thu-04-May-2023 02:07:30.595 PM INFORM Thread-868 _Engine1 GEODATABASE_SDE reader: Read 150000 features
Thu-04-May-2023 02:07:34.701 PM INFORM Thread-868 _Engine1 GEODATABASE_SDE reader: Read 160000 features
Thu-04-May-2023 02:07:39.561 PM INFORM Thread-868 _Engine1 GEODATABASE_SDE reader: Read 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 "_Engine1" ended unexpectedly. Being 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(s) are in effect.
Thu-04-May-2023 02:07:58.207 PM INFORM _Engine1 393566 : Process "_Engine1" waiting for process output listener threads to terminate...
Thu-04-May-2023 02:07:58.207 PM INFORM _Engine1 393569 : Process "_Engine1" closing process stderr output streamThe 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.