Salesforce.com Web Service Call

[Ilan]

Hi Sudheer,

In answer to your questions:

1. How can i know whether my Operations are running or not?Where i can see the Error messages of the Operations?

Your operations should appear in the message queue if they have not completed and in the log once they have completed. To view the log, click on the Log button in your operations page, or right-click in the operations tag in the tree on the left and choose Operation Log and you will see all logs for all operations run.

2. When i saw the System Queue also, I am getting NO MATCHES FOUND entry only, Can u please tell me what to do?

This means that the operations have already run and there should be a corresponding message in the log. Messages are recoved from the queue once the operation runs.

3.How can I know that I am successfully connecting to salesforce?even CREATE ACCOUNT also not working?

Please look at the log.

4.Iam not able to see the .txt files on shared folder. why?

Did you change the target settings to a file share that is valid for your machine? Did you test connection to this share? If you have and the operation failed then please look at the log and it should tell you why it failed.

5. Is this problem arised due to reindexing of some of my tables at the begining?

Please tell us what the log says to determine what the issue is.

6. Whenever I changed some parameters of project, is it necessary to depoly that project again on server?

Yes, however, the system should automatically detect any dependant settings that were changed and should tell you that its going to deploy them before running an operation.

[tumusudheer]

HI Ilan , Thank you for u r valuable reply...

Now I am seeing the logs by VIEW>Operaton Activity>Operatin Logs.

Here I am getting whether the Operation is comleted or not& the final result of operation. But How i can get the exact reason of why my operation failed?
Is there any log file that consists of this info o my harddisk?


Where can i see the log file? please tell me..

Thank you,
Sudheer.

[Ilan]

What error messages are you seeing?

[jstone]

I have followed the included pdf instructions perfectly. I even left in the default username/password. When i click the "Lightning Bolt" I instantly get two error messages:

"ERROR: index "uploadedfilestab_pkey" is not a btree

Details:
Unable to execute statement "INSERT INTO UPLOADEDFILESTAB VALUES(1, 2, 'ec9b5e18-6b55-4e3c-beb4-2889f1b87b97', '13ec289d-1c2d-486e-98fb-16d5edbc5fbb/', 'sfdc_enterise.wsdl', 'fd32d85681887d87d02732aaa73469ab', '2006-12-01 16:50:39.0')"
SQL Errors:
(0) SQL Error! SQLSTATE = HY000 Native err = 7 msg = ERROR: index "uploadedfilestab_pkey" is not a btree



Client version: 1.1.0
Server version: 1.1.0"

Once i close that window, i get:
"ERROR: index "uploadedfilestab_pkey" is not a btree

Details:
Unable to execute statement "INSERT INTO UPLOADEDFILESTAB VALUES(1, 2, 'ec9b5e18-6b55-4e3c-beb4-2889f1b87b97', '13ec289d-1c2d-486e-98fb-16d5edbc5fbb/', 'sfdc_enterise.wsdl', 'fd32d85681887d87d02732aaa73469ab', '2006-12-01 16:50:39.0')"
SQL Errors:
(0) SQL Error! SQLSTATE = HY000 Native err = 7 msg = ERROR: index "uploadedfilestab_pkey" is not a btree



Client version: 1.1.0
Server version: 1.1.0"

When i close that window it takes me back to the "Login to Query Account" window.

Please help.

Thanks.

[tom.ewing]

The Jitterpak already has the standard enterprise WSDL. If you have a customized WSDL please tell us so that we can guide you on loading that.

Could you please tell me how to load a customized WSDL?

Thank you,

Tom

[Ilan]

Login to your salesforce, click in the setup link at the top of the screen. Choose integrate from the setup tree. Then choose AppExchange API. Then click to download your Enterprise WSDL. This is generated and downloaded with all custom objects and field created for your organization.

Ilan.

[tom.ewing]

Login to your salesforce, click in the setup link at the top of the screen. Choose integrate from the setup tree. Then choose AppExchange API. Then click to download your Enterprise WSDL. This is generated and downloaded with all custom objects and field created for your organization.

Ilan.

Thank you, Ilan. Actually, what I was asking is how to "install" the WSDL into Jitterbit.

Thank you,

Tom

[Ilan]

Tom, you should be able to just dbl-click on the jitterpak and the project should open. If that does not work please tell me which version of Jitterbit you are using. Thanks. Ilan.

[Henrik Nordberg]

Thank you, Ilan. Actually, what I was asking is how to "install" the WSDL into Jitterbit.

You use a WSDL by creating a Web Service method call in Jitterbit. The web service method call wizard will prompt you to upload the WSDL.

Cheers
- Henrik

[pbulacz]

Has anyone had any experience using Salesforce outbound message to call on Jitterbit Webservice to invoke an "operation" ?
I would much rather prefer to use salesforce workflows and triggers as my scheduling mechanism.

Any help would be much appreciated. Thanks :)

P.S love the product :)

P.P.S perhaps this post should have added to this thread http://jitterbit.com/PhpBB/viewtopic.php?t=81 :oops:

[norwin]

Hi.
I've been trying out the salesforce jitterpak, and I'm getting the following error when I try to run the Login To Query Account operation:

Code: Select all

Failed to perform transformation The webservice call failed. Reported error: Failed to post the file "C:\Program Files\Jitterbit Integration Server\DataInterchange/Temp/op_3_03d620e6-92f3-4cbc-a7e3-95889efa23fc/t6_req.xml" to the web service at "https://www.salesforce.com/services/Soap/c/7.0". Reason: Failed to put data to the url https://www.salesforce.com/services/Soap/c/7.0. Couldn't connect to server. Could not connect to host. A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. Request headers: Content-Type: text/xml; charset="utf-8" SOAPAction: "" The server returned no response. [CODE:10721]

In fact, I get the same error 3 times in my log file. I'm wondering if it's to do with the recent Salesforce upgrade.
Can anyone help?

Thanks,
Norwin.

[NinoJose]

Hi norwin, what version of jitterbit are you using? I also downloaded the jitterpack but was unable to open it. Im using version 1.3.2.5

[norwin]

I'm also using 1.3.2.5.
Jitterbug complains about the jitterpack, but it imported okay, and deployed okay, and I was able to set the configuration items, but it doesn't talk to salesforce.com.

[NinoJose]

yeah me too. could it be because of the server url? its pointing to https://www.salesforce.com/services/Soap/c/7.0 where in fact salesforce is now 13.0 since summer release. Hey norwin, when you downloaded the jitterpak does it include the sfdc_enterise.wsdl?

[Ilan]

I've just downloaded the Jitterpak, deployed it to my server and ran it fine. I could not replicate this issue. Can you confirm that you deployed before testing? If you deployed did not get an error?