Error when i excecute VBA macro that import information from JIRA issue

Hi community,

Please if someone can help me to fixe this ussue,

 I get the error below when i execute an VBA macro that i develop since 3 month using SOAP30, the problem is that the macro worked well, i test other Macro in VBA that use the same way (SOAP30) and also i get the same error in the same line of the code, really i don't know what's the problem is because the MSSOAP30.DLL is imported in references also i install the SOAP Toolkit 3.0 but every time the same error. I test the Macro in the computer of 2 of my colleagues and the Macro worked well.

 

téléchargement.jpg

the error apear in this part of the code :

LogIn = client.wsm_login(jiraUser, password)

Thank you so Much !!

1 answer

0 vote

We can't really help you with this because:

1.  JIRA no longer has a SOAP interface, it went away several versions ago.  It doesn't look like it to me, but is it possible that the target JIRA has been upgraded to one that has no SOAP?

2.  If you are still using a version that does have the SOAP interface, the error you're seeing is in your VBA code.  We're a community of Atlassian users, not VBA people.  Some of us might know it, but it's a long shot.  You should really be asking in a VBA forum.

Of course, the correct thing to do here is forget it.  Upgrade the JIRA to a supported version and code for a REST interface.

Hi nic 

The macro worked for two of my collegue and we use the same vesion of jira, the macro worked since 3 month so i think the vba code is not a reason, there is something wrong in the jira configuration or something like this 

I need To solve this issue the earliest possible 

 

Thanks !!

I'm afraid that doesn't change the answer. 

If it connects to JIRA over SOAP, then you have an old version of JIRA.

That is not the problem though, if you say it's working for other people, then it's absolutely somethin on your machine, not the JIRA side.

Yes, i Will try To perform the same code using rest api, a know how to create an issue using this aproach.. if i remenber i tried To update an issue using rest api but does not worked .. the response of the resquest show me that there is a problem so can you show me how it s look like ?

Otherwise i will be so thanksfull if you give me some helpfull vba codes.

Many thanks !!

"It doesn't work" does not give us any information to go on.

Have a look through https://developer.atlassian.com/jiradev/jira-apis/jira-rest-apis/jira-rest-api-tutorials/jira-rest-api-version-2-tutorial to get started on how to use REST.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Jira

Meet the AUG leaders of Northern Virginia

@Rachel Wright (Jira Genie), @Billy Poggi (AUG NOVA, DC), and @Dana Jansen (Confluence Queen) are just some of the folks that lead one of the world's most active Atlassian User Group (AUG)....

125 views 4 9
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you