Why do my Web Service invocations result in FAILURE
4 September, 2012
[Platform: Yellowfin 6.1 / Build: 20120531]
Hi,
I am currently developing an app which connects to Yellowfin via Web Services to retrieve Tab information. At this point, I (think) I have been successful in performing a round-trip between the app the Yellowfin Administration webservice, however I consistently receive status code �FAILURE� following a ws invocation.
The app I am developing is in ASP.NET (vb), and I have attached a Word document showing a test routine with the values being passed to the Yellowfin webservice, and what I understand are the important settings within Yellowfin configuration which may be affecting the response.
Following all ws invocations, I receive the FAILURE status code but do not understand whether this is due to configuration, authentication, or invocation.
My troubleshooting steps/process thus far is:
1. Confirm correct Web Service URL: COMPLETED [http://sdbi.sagedev.local:8080/services/AdministrationService]
2. Confirm correct username: COMPLETED [admin@yellowfin.com.au]
3. Confirm correct password: COMPLETED [test]
4. Confirm correct YF role: COMPLETED [YFADMIN]
5. Confirm YF role has Web Services enabled: COMPLETED [Role Management -> Admin -> Web Services -> Web Services -> TRUE]
6. Confirm YF role can create users: COMPLETED [Role Management -> Admin -> User Administration -> User Management -> CRUD = TRUE]
7. Confirm app can connect to Web Service: COMPLETED [response object is updated following invocation: statusCode = FAILURE]
8. Attempt invocation of different Methods: COMPLETED [ADDUSER / LISTCLIENTS - response is the same: statusCode = FAILURE]
9. Update licence to new Dev licence: COMPLETED [No issues with hitting licensed user limits � 9999 users allowed / 3 users exist]
Hi,
I am currently developing an app which connects to Yellowfin via Web Services to retrieve Tab information. At this point, I (think) I have been successful in performing a round-trip between the app the Yellowfin Administration webservice, however I consistently receive status code �FAILURE� following a ws invocation.
The app I am developing is in ASP.NET (vb), and I have attached a Word document showing a test routine with the values being passed to the Yellowfin webservice, and what I understand are the important settings within Yellowfin configuration which may be affecting the response.
Following all ws invocations, I receive the FAILURE status code but do not understand whether this is due to configuration, authentication, or invocation.
My troubleshooting steps/process thus far is:
1. Confirm correct Web Service URL: COMPLETED [http://sdbi.sagedev.local:8080/services/AdministrationService]
2. Confirm correct username: COMPLETED [admin@yellowfin.com.au]
3. Confirm correct password: COMPLETED [test]
4. Confirm correct YF role: COMPLETED [YFADMIN]
5. Confirm YF role has Web Services enabled: COMPLETED [Role Management -> Admin -> Web Services -> Web Services -> TRUE]
6. Confirm YF role can create users: COMPLETED [Role Management -> Admin -> User Administration -> User Management -> CRUD = TRUE]
7. Confirm app can connect to Web Service: COMPLETED [response object is updated following invocation: statusCode = FAILURE]
8. Attempt invocation of different Methods: COMPLETED [ADDUSER / LISTCLIENTS - response is the same: statusCode = FAILURE]
9. Update licence to new Dev licence: COMPLETED [No issues with hitting licensed user limits � 9999 users allowed / 3 users exist]
Hi Michael,
That 'FAILURE' error you were receiving was in fact caused by a bug introduced in the build before the last one, and fixed in the last build (20120828). So if you upgrade to the latest build then that error should be no more.
Apologies for the inconvenience caused, please let us know how you go with it.
Regards,
David
That 'FAILURE' error you were receiving was in fact caused by a bug introduced in the build before the last one, and fixed in the last build (20120828). So if you upgrade to the latest build then that error should be no more.
Apologies for the inconvenience caused, please let us know how you go with it.
Regards,
David
Hi David,
I upgraded our Yellowfin server to 6.1 build 20120828 (using the "yellowfin-20120828-update" package) but am still receiving the FAILURE status code.
Can you please confirm that I am invoking the web service method correctly (please refer to the doc attached to the original message for information regarding the peroprties I am setting in the Service and Request objects).
Thanks for your assistance,
Michael C.
I upgraded our Yellowfin server to 6.1 build 20120828 (using the "yellowfin-20120828-update" package) but am still receiving the FAILURE status code.
Can you please confirm that I am invoking the web service method correctly (please refer to the doc attached to the original message for information regarding the peroprties I am setting in the Service and Request objects).
Thanks for your assistance,
Michael C.
Hi David,
I have attached a new document showing the actual context of the call I am trying to make, which is to retrieve a list of Tabs from Yellowfin.
Thanks for your assistance,
Michael C.
I have attached a new document showing the actual context of the call I am trying to make, which is to retrieve a list of Tabs from Yellowfin.
Thanks for your assistance,
Michael C.
Hi Michael,
sorry but the attachment doesn't seem to have come through, could you try again please, or email it to support@yellowfin.bi.
thanks,
David
sorry but the attachment doesn't seem to have come through, could you try again please, or email it to support@yellowfin.bi.
thanks,
David
doc attached
This issue has been resolved - advice from Steve J highlighted that the OrgId in the request object needed to be set to the number 1.
Integration is working now - thanks to all for assistance.
-Michael C
Integration is working now - thanks to all for assistance.
-Michael C
hi!
now this time i wrote code like this follows dev/examples/webservices
my code like this
public void CreateUser() throws ServiceException, RemoteException {
AdministrationServiceResponse rs = new AdministrationServiceResponse();
AdministrationServiceRequest rsr = new AdministrationServiceRequest();
AdministrationServiceService ts = new AdministrationServiceServiceLocator(
"localhost", 8080, "/services/AdministrationService", false);
AdministrationServiceSoapBindingStub rssbs = (AdministrationServiceSoapBindingStub) ts
.getAdministrationService();
rsr.setLoginId("admin@yellowfin.com.au");
rsr.setPassword("test");
rsr.setOrgId(new Integer(1));
rsr.setFunction("ADDUSER");
AdministrationPerson ap = new AdministrationPerson();
ap.setUserId("admin12@yellowfin.com.au");
ap.setPassword("test");
ap.setFirstName("Admin 21");
ap.setSalutationCode("DR");
ap.setLastName("System");
ap.setRoleCode("ADMIN");
ap.setPassword("test");
ap.setEmailAddress("admin21@yellowfin.com.au");
rsr.setPerson(ap);
rs = rssbs.remoteAdministrationCall(rsr);
System.out.println("Report" + rs.getStatusCode());
}
but out put is :FAILURE
THANKS
SANDEEP
now this time i wrote code like this follows dev/examples/webservices
my code like this
public void CreateUser() throws ServiceException, RemoteException {
AdministrationServiceResponse rs = new AdministrationServiceResponse();
AdministrationServiceRequest rsr = new AdministrationServiceRequest();
AdministrationServiceService ts = new AdministrationServiceServiceLocator(
"localhost", 8080, "/services/AdministrationService", false);
AdministrationServiceSoapBindingStub rssbs = (AdministrationServiceSoapBindingStub) ts
.getAdministrationService();
rsr.setLoginId("admin@yellowfin.com.au");
rsr.setPassword("test");
rsr.setOrgId(new Integer(1));
rsr.setFunction("ADDUSER");
AdministrationPerson ap = new AdministrationPerson();
ap.setUserId("admin12@yellowfin.com.au");
ap.setPassword("test");
ap.setFirstName("Admin 21");
ap.setSalutationCode("DR");
ap.setLastName("System");
ap.setRoleCode("ADMIN");
ap.setPassword("test");
ap.setEmailAddress("admin21@yellowfin.com.au");
rsr.setPerson(ap);
rs = rssbs.remoteAdministrationCall(rsr);
System.out.println("Report" + rs.getStatusCode());
}
but out put is :FAILURE
THANKS
SANDEEP