I generated a JXL file from my JTX 9.3 environment and when I tried to import it into Workflow Manager 10.2.2 I got the following errors: * Popup saying that The select JXL is invalid. Please see log for details. * The log revealed a level 3 message - 7/16/2014 13:58:45.986Level: 3Could not parse JXL file due to error -1072896760: "An invalid character was found in text content." at line 205 position 6179 Navigating to that location in the JXL using a text editor leads me to the middle of a GUID GUID="{003656DD-B777-46AB-8B3C-3A875E4643E9}" Does anyone know of a way I could fix this issue and import my configuration? Our system has over 30 jobs and it would be a lot of work reconfiguring each one. I should also note that I have successfully exported another instance of JTX 9.3 from our environment and imported into 10.2.2. Thanks! Heather

I have also tried to copy the queries from a simple restore of our production environment to the combined restore/minimum configuration and I have been unsuccessful...

Michael, I ran the process as you described above and I still lost my queries. Any idea why my production import will not work? Or, is there something I can check for in the WMX repository to ensure that all the 10.2.2 functionality has been added? Also, should I be opening a support ticket to get this looked at? Thanks, Heather

Hi Heather, Yes, getting your jxl to work as an import would be the desired option. We have put a task in our queue to look into it. The issue of the queries getting overridden is my mistake, however, as it slipped my mind that it wouldn't merge the configurations. To get yourself up and running fully please. - Delete the tables again - Run the post install with the custom config and your jxl, resolve the conflict etc. - Open the Workflow Manager Administrator - Right click on the connection and select Import/Export->Import Configuration - Go to C:\Program Files (x86)\ArcGIS\WMX\Desktop10.2\config\Database Configurations and pick Minimum Configuration - Click No to Merge At that point the new elements will be in and nothing from your original db will be over ridden. Apologies for the confusion, have a great weekend. Michael

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Workflow Manager: Could not parse JXL file due to error

AllWeatherHeather

I generated a JXL file from my JTX 9.3 environment and when I tried to import it into Workflow Manager 10.2.2 I got the following errors:

Popup saying that The select JXL is invalid. Please see log for details.
The log revealed a level 3 message -
7/16/2014 13:58:45.986 Level: 3 Could not parse JXL file due to error -1072896760: "An invalid character was found in text content." at line 205 position 6179
Navigating to that location in the JXL using a text editor leads me to the middle of a GUID

GUID="{003656DD-B777-46AB-8B3C-3A875E4643E9}"

Does anyone know of a way I could fix this issue and import my configuration? Our system has over 30 jobs and it would be a lot of work reconfiguring each one.

I should also note that I have successfully exported another instance of JTX 9.3 from our environment and imported into 10.2.2.

Thanks!

Heather

Find more posts tagged with

Accepted answers

All comments

AllWeatherHeather

Thanks Michael. I had figured this was the case so I tried it out. The post-install failed again this time reporting out of client memory [JTX_JOB_ATTACHMENTS].

I am trying to remove records from some of the oldest jobs but this process is taking a long time.

Anonymous User

Hi Heather,

You actually don't want to version any of the Workflow Manager tables when they're in the system. Workflow Manager works great with versioned spatial data, but it isn't required for the system tables and is contributing to the issue you're seeing.

If you try again without versioning it should work.

Cheers,

Michael

AllWeatherHeather

I started by deleting all the JTX tables and feature classes out of my development environment and copied our production JTX content in its place. I was sure to assign privileges to the copied content and register as versioned. I then ran the post install (which found the existing system table repository) and I selected "Minimum configuration". Unfortunately, the post install failed! Last part of the log is below:

Creating schema...

Field ACT_ID already exists in table JDI_GIS_NB.DBO.JTX_ACTIVITY_TYPES

Field DESCRIPTION already exists in table JDI_GIS_NB.DBO.JTX_ACTIVITY_TYPES

Field MESSAGE already exists in table JDI_GIS_NB.DBO.JTX_ACTIVITY_TYPES

Field NAME already exists in table JDI_GIS_NB.DBO.JTX_ACTIVITY_TYPES

Field OBJECT_GUID already exists in table JDI_GIS_NB.DBO.JTX_ACTIVITY_TYPES

Field OBJECT_MODIFIED already exists in table JDI_GIS_NB.DBO.JTX_ACTIVITY_TYPES

Field LAST_SYNC created successfully in table JDI_GIS_NB.DBO.JTX_ACTIVITY_TYPES

Unable to update GUIDs on table JDI_GIS_NB.DBO.JTX_ACTIVITY_TYPES

Upgrade failed: Objects in this class cannot be updated outside an edit session [JDI_GIS_NB.DBO.JTX_ACTIVITY_TYPES]

Updating GUIDs in field OBJECT_GUID for JDI_GIS_NB.DBO.JTX_HOLD_TYPES

Could not update GUIDs due: Objects in this class cannot be updated outside an edit session [JDI_GIS_NB.DBO.JTX_HOLD_TYPES]

Updating GUIDs in field OBJECT_GUID for JDI_GIS_NB.DBO.JTX_STATUS

Could not update GUIDs due: Objects in this class cannot be updated outside an edit session [JDI_GIS_NB.DBO.JTX_STATUS]

Updating GUIDs in field OBJECT_GUID for JDI_GIS_NB.DBO.JTX_ACTIVITY_TYPES

Could not update GUIDs due: Objects in this class cannot be updated outside an edit session [JDI_GIS_NB.DBO.JTX_ACTIVITY_TYPES]

Updating GUIDs in field OBJECT_GUID for JDI_GIS_NB.DBO.JTX_NOTIFICATIONS

Could not update GUIDs due: Objects in this class cannot be updated outside an edit session [JDI_GIS_NB.DBO.JTX_NOTIFICATIONS]

Updating GUIDs in field OBJECT_GUID for JDI_GIS_NB.DBO.JTX_PRIVILEGES

Could not update GUIDs due: Objects in this class cannot be updated outside an edit session [JDI_GIS_NB.DBO.JTX_PRIVILEGES]

Updating GUIDs in field PRIV_UID for JDI_GIS_NB.DBO.JTX_PRIV_XREF

Could not update GUIDs due: Objects in this class cannot be updated outside an edit session [JDI_GIS_NB.DBO.JTX_PRIV_XREF]

Anonymous User

Also, when you used the Post Install tool to create your 10.2.2 database did you select Custom Configuration and import the jxl that way? Or did you import it after the fact with a different configuration?

We would recommend you try to include it as part of the post install setup, or ensure to choose No Configuration before importing it otherwise.

Cheers,

Michael

Anonymous User

Hi Heather,

That's unfortunate, but we'll get it working. As opposed to importing a 9.3 jxl into a 10.2.2 Workflow Manager database, you may instead want to try taking a copy of your 9.3 database and running the 10.2.2 Post Installation tool on it.

This will preserve it's existing state and simply add the necessary schema changes for the change in Workflow Manager version. This may also resolve your step issue that you also posted about.

We generally recommend updating database through the use of the Post Install tool. If you'd like to send me the jxl I can try to import it on my end as well to diagnose the problem.

Cheers,

Michael

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.