How to start a Jitterbit operation from other applications

[emanuel]

How to start a Jitterbit operation from other applications

An operation is what ties sources and targets together with one or several transformations. So when is an operation run? All operations are executed by the Jitterbit Process Engine, a back-end process that always runs. It checks the operation queue on a regular basis and runs the operations in the order that they were put on the queue. So how do you put an operation on the queue? There are several ways to do this. It can be run on demand in the UI using the "Run Now" button (the flash icon) or it can be run on a schedule by assigning a schedule to it.

It is also possible to put an operation on the queue programmatically and there are several ways to do this.

Call the Jitterbit web service method RunOperation

You can call the web service at the url

http://server_name:46908/axis/konga_jobcontrol

called "RunOperation". The method takes three string arguments: The user name, password and the GUID of the operation. The GUID of the operation can be found in the "Additional Details..." menu option on the operation page. The user needs to have execute permission on the given operation. This method is basically a programmatic way of dong a "Run Now". "server_name" is the name or IP number of the machine running Jitterbit Server. If you don't want to pass the password in clear text you can call the method RunOperationMD5Password which takes the MD5 hash of the password as an argument. The WSDL that describes the web service interface is attached to this post.

Implement a hosted web service

Create a hosted web service and assign a success operation. The hosted web service can then be called from any application that can call web services. This option can be a little complicated since you need to generate a WSDL for what is basically a dummy web service whose only purpose is to run another operation.

This article describes in detail how to implement a hosted web service: viewtopic.php?t=123

Use an HTTP Endpoint

Create a new HTTP Endpoint and specify a path for the endpoint URL. Click Add Operation and browse for the operation you want to trigger. When the configured URL is requested your operation will be triggered. You can communicate variables to and from the operation by using the request body, HTTP headers, query strings and response body. The operation can now be triggered by any application that can use http.

Use the JitterbitUtils command (Jitterbit Server 1.3.0 and later)

As of Jitterbit Server version 1.3.0 the JitterbitUtils command line program has an option for adding an operation to the queue. You use the "--add-operation-to-queue" option and supply the operation GUID, name or id:

JitterbitUtils --add-operation-to-queue "My Operation"

adds the "My Operation" operation to the process queue.

[nicanor]

I really appreciated the basic tutorial demo packaged as a Jitterpak, and was eager to find a demo to use as a jumpstart in getting my first hosted web service to work. The referenced article on how to implement a hosted web service provides a link to a hosted web service demojitterpak. I was able to download and open that jitterpak, but when I try to open the transformations, I get a message that indicates that the sample wsdl is missing. I browsed through the unpacked jitterpak and found the wsdl, but perhaps it is not in the place where the demo needs it to be?

[emanuel]

Hi,

you need to deploy the project to a Jitterbit server before you can open the transformations.

/Cheers
Emanuel

[nicanor]

I imported the hosted web service demo jitterpak, after logging into server and starting a fresh project. When doing the import, I get the message "The project Web Service Demo was saved from an earlier version of the Jitterbit Integration Environment. In order to open it with the current version, some of the project data must be updated. Do you want to update the project?

At this point, I responded with Yes, and then declined the offer to do a backup first. The import seems to succeed. But when I attempt to deploy to the server, I get the message "Invalid. The project contains invalid items. You can still deploy ..."

I seem to be able to successfully deploy the transformations and the web service method as individual items. The "CurrentConverter (hosted web service)" Operation is still tagged as Invalid, because the web service, first transformation, and second transformation dropdowns are (none). I can select the ConversionRate web service on the web service drop down, but on the transformation drop downs, only the ConversionRate transformation is listed as a choice. I am guessing that I need to select the "CurrentcyConverter Request" and "CurrencyConverter Response" for the first and second transformations. But they are not listed. So the operation remains Invalid and therefore not subject to being deployed.

I don't know whether the problem is with the older jitterpak with the current client/server releases, or my still very incomplete understanding of everything. (That's why I need the demo!) Any help would be greatly appreciated! In the meantime, I think I'll try to create new transformations like the CurrencyConverter request and response transformations, and see if my new ones show up in the drop down lists.

Thanks

[Henrik Nordberg]

Hi,

I opened that Jitterpak in 1.2.4.1, and, as you said, the CurrencyConverter (hosted web service) operation did not have a web service or transformation assigned to it. I assigned CurrencyConverter for both transformation and web service. I also had to change the URL for the Web Service Method to say jitterbit_ws instead of konga_ws, since we made that change to the server after 1.1 was released. Then it worked. I also removed the HTTP target since it is not needed in 1.2.

I have attached the resulting Jitterpak to this post. Please let me know if it works for you.

Cheers
Henrik

[psteve]

I'm unable to import this jiterpak for 1.24 into the 1.3 that was released the other day.

I get this error:

id cannot be null.

Client version: 1.3.0.72
Server version: [Not connected]
Client platform: Windows XP - Java 1.6.0_03

It's discouraging that the subversion page for this jitterpak still contains the 1.1 version, and not this one, which seems necessary for those using 1.24.

It would be very nice to have a central place where one could find all the files you have put onto the forums, instead of having to chase all over after them.

[Henrik Nordberg]

Hmm, it works fine for me. I downloaded the file above and dragged it onto the Jitterbit client and it opened it fine. I have exported it using 1.3 and attached it to this post.

And to answer your second question/suggestion: yes, that would be good. We will release a new site that should help in this regard within a couple of weeks.

Cheers
Henrik

[psteve]

Thanks for the response.

I get the same error as I got before. When I proceed, the Web Service Demo appears in Recent Projects on the first screen. Trying to open it, I get this message:

The project "Web Service Demo" was saved in an earlier version of the Jitterbit Integration Environment. In order to open it with the current version, some of the project data must be updated.

Clicking OK, and trying to proceed, I get another error, about id cannot be 0. Here's a stack trace:

java.lang.IllegalArgumentException: id cannot be null.
at org.jitterbit.integration.data.project.IntegrationProject.createExistingProjectShell(IntegrationProject.java:141)
at org.jitterbit.integration.client.project.ProjectLoaderWorker.loadProjectImpl(ProjectLoaderWorker.java:53)
at org.jitterbit.integration.client.project.ProjectLoaderWorker.loadProject(ProjectLoaderWorker.java:38)
at org.jitterbit.integration.client.project.ProjectManager.loadProject(ProjectManager.java:236)
at org.jitterbit.integration.client.ui.interchange.entity.factory.IntegrationProjectFactory.loadExistingProject(IntegrationProjectFactory.java:81)
at org.jitterbit.integration.client.ui.interchange.entity.factory.IntegrationProjectFactory.loadExistingProject(IntegrationProjectFactory.java:120)
at org.jitterbit.integration.client.ui.interchange.ProjectLoader$Loader.loadProject(ProjectLoader.java:163)
at org.jitterbit.integration.client.ui.interchange.ProjectLoader.loadSynchronously(ProjectLoader.java:85)
at org.jitterbit.integration.client.ui.interchange.component.launcher.OpenLocalProjectOption.getProjectUi(OpenLocalProjectOption.java:115)
at org.jitterbit.integration.client.ui.interchange.component.launcher.InterchangeLauncher$ProjectLoader.displayProject(InterchangeLauncher.java:276)
at org.jitterbit.integration.client.ui.interchange.component.launcher.InterchangeLauncher$ProjectLoader.run(InterchangeLauncher.java:254)
at org.jitterbit.integration.client.ui.core.DefaultUiWorker$RunnableWrapper.run(DefaultUiWorker.java:197)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

[Torgil Zethson]

We cannot reproduce this problem. In order for us to find out what is going on, can you give a detailed, step-by-step account of what you did to get this error message?

Cheers,
- Torgil

[tbrtbr]

I have been receiving the same message, although with a different set of circumstances. Some background:

Running jitterbit Server 1.3.2.19 with PostgreSQL Install, running on an WinXP SP2 machine.
Running jitterbit Client 1.3.2.5, running on the same machine as the server as well as on a different ('remote') machine.
Same behavior experienced on both the client running on the server, and the client running on a different ('remote') machine.

Now, here is what occurred:

I have a project with multiple operations, transforms, etc, which was working fine on 4/27/08 when operations were last run using client on the 'remote' machine.
Nothing was intentionally changed since then and today, 5/18/08, when I attempted to load the same project using the client on the 'remote' machine.
When trying to load the project, I receive this message:

======================================================
"The project "project59" was saved in an earlier version of the Jitterbit Integration Environment. In order to open it with the current version, some of the project data must be updated.
Do you want to update the project?"
====
1.) If I click YES to update the project, this happens:

"Do you want to create a Jitterpak backup of the project before upgrading it?"

--
1.a) If I click YES to create jitterpak backup, this happens:

"Failed to create the project backup.

id cannot be null.

Client version: 1.3.2.5
Server version: 1.3.2.19
Client platform: Windows XP - Java 1.6.0_05
Server platform: Microsoft Windows XP Home Edition, 32-bit 5.1 SP 2.0 (Service Pack 2) Build 2600
CPU: AuthenticAMD x86 AMD Athlon(tm) 64 Processor 3200+ - x86 Family 15 Model 47 Stepping 2, 1 cores total.
RAM: 0.5403 GB in use, 1.164 GB available, 1.874 GB total.
Swap: 0.1293 GB in use, 1.883 GB available, 2 GB total.
Disk (where Jitterbit is installed): 78.13 GB in use, 66.14 GB available, 144.3 GB total.


java.lang.IllegalArgumentException: id cannot be null.
at org.jitterbit.integration.data.project.IntegrationProject.createExistingProjectShell(IntegrationProject.java:141)
at org.jitterbit.integration.client.project.ProjectLoaderWorker.loadProjectImpl(ProjectLoaderWorker.java:53)
at org.jitterbit.integration.client.project.ProjectLoaderWorker.loadProject(ProjectLoaderWorker.java:38)
at org.jitterbit.integration.client.project.ProjectLoaderWorker.loadProjectSilently(ProjectLoaderWorker.java:43)
at org.jitterbit.integration.client.project.JitterPackCreator.createJitterPack(JitterPackCreator.java:38)
at org.jitterbit.integration.client.project.ProjectManager.createJitterPack(ProjectManager.java:282)
at org.jitterbit.integration.internal.project.versionhandler.v_1_2_0_99.PreLoader.doBackup(PreLoader.java:116)
at org.jitterbit.integration.internal.project.versionhandler.v_1_2_0_99.PreLoader.run(PreLoader.java:51)
at org.jitterbit.integration.internal.project.versionhandler.v_1_2_0_99.Handler.preLoading(Handler.java:24)
at org.jitterbit.integration.client.project.ProjectVersionHandlerManager.preLoading(ProjectVersionHandlerManager.java:93)
at org.jitterbit.integration.client.project.ProjectManager.loadProject(ProjectManager.java:233)
at org.jitterbit.integration.client.ui.interchange.entity.factory.IntegrationProjectFactory.loadExistingProject(IntegrationProjectFactory.java:81)
at org.jitterbit.integration.client.ui.interchange.entity.factory.IntegrationProjectFactory.loadExistingProject(IntegrationProjectFactory.java:120)
at org.jitterbit.integration.client.ui.interchange.ProjectLoader$Loader.loadProject(ProjectLoader.java:163)
at org.jitterbit.integration.client.ui.interchange.ProjectLoader$Loader.run(ProjectLoader.java:152)
at org.jitterbit.integration.client.ui.core.UiWorker$1$1.run(UiWorker.java:212)
at org.jitterbit.integration.client.ui.core.DefaultUiWorker$RunnableWrapper.runSafely(DefaultUiWorker.java:203)
at org.jitterbit.integration.client.ui.core.DefaultUiWorker$RunnableWrapper.run(DefaultUiWorker.java:194)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)"

Followed by:

"Failed to load the project "project59" from Q:\jitterbit\projects\project59.

Reason: Required project data conversion was cancelled or denied.

Client version: 1.3.2.5
Server version: 1.3.2.19
Client platform: Windows XP - Java 1.6.0_05
Server platform: Microsoft Windows XP Home Edition, 32-bit 5.1 SP 2.0 (Service Pack 2) Build 2600
CPU: AuthenticAMD x86 AMD Athlon(tm) 64 Processor 3200+ - x86 Family 15 Model 47 Stepping 2, 1 cores total.
RAM: 0.5403 GB in use, 1.164 GB available, 1.874 GB total.
Swap: 0.1293 GB in use, 1.883 GB available, 2 GB total.
Disk (where Jitterbit is installed): 78.13 GB in use, 66.14 GB available, 144.3 GB total."

--
1.b) If I click NO to create jitterpak backup, this happens:

"id cannot be null.

Client version: 1.3.2.5
Server version: 1.3.2.19
Client platform: Windows XP - Java 1.6.0_05
Server platform: Microsoft Windows XP Home Edition, 32-bit 5.1 SP 2.0 (Service Pack 2) Build 2600
CPU: AuthenticAMD x86 AMD Athlon(tm) 64 Processor 3200+ - x86 Family 15 Model 47 Stepping 2, 1 cores total.
RAM: 0.5403 GB in use, 1.164 GB available, 1.874 GB total.
Swap: 0.1293 GB in use, 1.883 GB available, 2 GB total.
Disk (where Jitterbit is installed): 78.13 GB in use, 66.14 GB available, 144.3 GB total."


====
2.) If I click NO to update the project, this happens:

"Failed to load the project "project59" from Q:\jitterbit\projects\project59.

Reason: Required project data conversion was cancelled or denied.

Client version: 1.3.2.5
Server version: 1.3.2.19
Client platform: Windows XP - Java 1.6.0_05
Server platform: Microsoft Windows XP Home Edition, 32-bit 5.1 SP 2.0 (Service Pack 2) Build 2600
CPU: AuthenticAMD x86 AMD Athlon(tm) 64 Processor 3200+ - x86 Family 15 Model 47 Stepping 2, 1 cores total.
RAM: 0.5403 GB in use, 1.164 GB available, 1.874 GB total.
Swap: 0.1293 GB in use, 1.883 GB available, 2 GB total.
Disk (where Jitterbit is installed): 78.13 GB in use, 66.14 GB available, 144.3 GB total."
====
======================================================



This has happened before, the last time I needed to add to and/or alter jitterbit projects after leaving them sit for a few weeks. Nothing has been intentionally changed about jitterbit between when they work, and when they produce the "saved in an earlier version" error. The server version is the same, and the client version is the same, and the files in the project directory have not been intentionally changed. The last time it happened (around 4/27 when I last got the project working again), I ended up tracking down a reference in another forum post detailing where jitterpak backups are automatically kept on the server, copied the backup into the projects directory, and re-imported (or something similar... I'm going from my memory as I assumed it wouldn't happen again ;-) ).

So, there is some info on what produced the message for me. I'm going to try to find that forum post about where backups are kept and try to find and restore from whatever backup I can find, but I'd *really* like to figure out what is going on with the "saved in an earlier version" message as I plan on adding a bunch of new projects using jitterbit and I need to resolve this problem beforehand.

Any advice would be appreciated... if I need to start a new forum topic for this particular issue, let me know and I'll do that.

Thanks in advance.

[Torgil Zethson]

Hi,

This is an odd error. If the client version has not changed since last time the project was saved then something must be wrong with the project file, tricking the client to believe the project is old and needs upgrading.

Please do the following:

1. Locate the location on disk where this faulty project is stored (the path to the project folder is shown in the opening screen, where you select which project to open)

2. In the project folder you'll find a file called "[project name].jip" (substitute [project name] with the actual name of the project). Send that file to support@jitterbit.com, so that we can look at it and see if something is wrong.

The .jip file does not contain any sensitive data, just some basic information about when the project was created, in which version it was saved, etc.

Cheers,
- Torgil

[tbrtbr]

Torgil -

.jip sent by email. Thanks.