Error: identity==null. (rsAuthenticationExtensionError) while Loading a Azure Report in Java

All Replies

• Friday, May 18, 2012 4:56 PM

  Moderator

   

   
  

  0

  Hi Riddhi,

  Could you provide more detail about how you are connecting and authenticating?

  Please see:

  http://msdn.microsoft.com/en-us/library/gg552871#Authentication

  Thanks,

  Cathy Miller

  • Reply
  • Quote

   
• Monday, May 21, 2012 5:57 AM

   

   
  

  0

  Thanks, Cathy for the useful link.

  I have accessed existing web service (https://INSTANCE.reporting.windows.net/reportserver/ReportExecution2005.asmx?wsdl) and generated java proxy classes using Apache Axis web service runtime.

  Below is the method call to invoke the report:

  String result = SSRSUtil.getReports("USERNAME", "PASS", 
  				"https://INSTANCE.reporting.windows.net/reportserver/ReportExecution2005.asmx", 
  				"/Report Project1/ReportName");

  Below is the java util program:

  package reportClient;
  import java.net.URL;
  import javax.xml.rpc.holders.ByteArrayHolder;
  import javax.xml.rpc.holders.StringHolder;
  import javax.xml.soap.SOAPException;
  import org.apache.axis.message.SOAPHeaderElement;
  import com.microsoft.schemas.sqlserver._2005._06._30.reporting.reportingservices.ExecutionInfo;
  import com.microsoft.schemas.sqlserver._2005._06._30.reporting.reportingservices.ReportExecutionServiceLocator;
  import com.microsoft.schemas.sqlserver._2005._06._30.reporting.reportingservices.ReportExecutionServiceSoapStub;
  import com.microsoft.schemas.sqlserver._2005._06._30.reporting.reportingservices.holders.ArrayOfStringHolder;
  import com.microsoft.schemas.sqlserver._2005._06._30.reporting.reportingservices.holders.ArrayOfWarningHolder;
  public class SSRSUtil {
  public static String getReports(String userName, String password,
  String endPoint, String report) {
  ReportExecutionServiceSoapStub service = getService(endPoint, userName, password);
  /*
  * ParameterValue[] parameters = new ParameterValue[1]; parameters[0] =
  * new ParameterValue(); parameters[0].setName("<PARAMETER_1_NAME>");
  * parameters[0].setValue("<PARAMETER_1_VALUE>");
  */
  try {
  ExecutionInfo info = service.loadReport(report, null); // Load // report
  setExecutionId(service, info.getExecutionID()); // You must set the session id before continuing
  // service.setExecutionParameters(parameters, "en-us"); // Set report parameters
  String format = "HTML4.0"; // Valid options are HTML4.0, MHTML,
  // EXCEL, CSV, PDF, etc
  String deviceInfo = "<DeviceInfo><Toolbar>False</Toolbar><HTMLFragment>True</HTMLFragment></DeviceInfo>"; // Only generate an HTML fragment
  ByteArrayHolder result = new ByteArrayHolder();
  StringHolder extension = new StringHolder();
  StringHolder mimeType = new StringHolder();
  StringHolder encoding = new StringHolder();
  ArrayOfWarningHolder warnings = new ArrayOfWarningHolder();
  ArrayOfStringHolder streamIDs = new ArrayOfStringHolder();
  service.render(format, deviceInfo, result, extension, mimeType, encoding, warnings, streamIDs); // Render report to HTML
  return new String(result.value);
  } catch (Exception e) {
  e.printStackTrace();
  }
  return null;
  }
  public static void setExecutionId(ReportExecutionServiceSoapStub service,String id) throws SOAPException {
  SOAPHeaderElement sessionHeader = new SOAPHeaderElement(
  "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices", "ExecutionHeader");
  sessionHeader.addChildElement("ExecutionID").addTextNode(id);
  service.setHeader(sessionHeader);
  }
  public static ReportExecutionServiceSoapStub getService(String endPoint,String userName, String password) {
  try {
  ReportExecutionServiceSoapStub service = (ReportExecutionServiceSoapStub) new ReportExecutionServiceLocator().getReportExecutionServiceSoap(new URL(endPoint));
  service.setUsername(userName);
  service.setPassword(password);
  //service.logonUser(userName, password, "INSTANCE.reporting.windows.net"); 
  service.setMaintainSession(false);
  return service;
  } catch (Exception e) {
  e.printStackTrace();
  }
  return null;
  }
  public static org.apache.axis.EngineConfiguration getEngineConfiguration() {
  java.lang.StringBuffer sb = new java.lang.StringBuffer();
  sb.append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n");
  sb.append("<deployment name=\"defaultClientConfig\"\r\n");
  sb.append("xmlns=\"http://xml.apache.org/axis/wsdd/\"\r\n");
  sb.append("xmlns:java=\"http://xml.apache.org/axis/wsdd/providers/java\">\r\n");
  sb.append("<globalConfiguration>\r\n");
  sb.append("<parameter name=\"disablePrettyXML\" value=\"true\"/>\r\n");
  sb.append("<parameter name=\"enableNamespacePrefixOptimization\" value=\"true\"/>\r\n");
  sb.append("</globalConfiguration>\r\n");
  sb.append("<transport name=\"http\" pivot=\"java:org.apache.axis.transport.http.CommonsHTTPSender\"><parameter name=\"PROTOCOL\">HTTP/1.1</parameter> <parameter name=\"Transfer-Encoding\">chunked</parameter></transport>\r\n");
  sb.append("<transport name=\"https\" pivot=\"java:org.apache.axis.transport.http.CommonsHTTPSender\"/>\r\n");
  sb.append("<transport name=\"local\" pivot=\"java:org.apache.axis.transport.local.LocalSender\"/>\r\n");
  sb.append("<transport name=\"java\" pivot=\"java:org.apache.axis.transport.java.JavaSender\"/>\r\n");
  sb.append("</deployment>\r\n");
  return new org.apache.axis.configuration.XMLStringProvider(sb.toString());
  }
  }

  For using Forms Authentication,

  service.setUsername(userName);
  service.setPassword(password);

  is used to provide the Credentials.

  I have also tried using

  service.logonUser(userName, password, "INSTANCE.reporting.windows.net");

  instead of forms authentication but it results in another Exception

  org.xml.sa​x.SAXExcep​tion: Bad envelope tag: HTML

  • Edited by Riddhi M Monday, May 21, 2012 5:59 AM
  • Edited by Riddhi M Monday, May 21, 2012 6:04 AM
  • Edited by Riddhi M Monday, May 21, 2012 6:40 AM
  • Edited by Riddhi M Monday, May 21, 2012 11:29 AM
  • Edited by Riddhi M Monday, May 21, 2012 11:30 AM
  •  
  • Reply
  • Quote

   
• Friday, May 25, 2012 1:56 PM

  Moderator

   

   
  

  0

  Hi Riddhi,

  Your question falls into the paid support category which requires a more in-depth level of support.  Please visit the below link to see the various paid support options that are available to better meet your needs. http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone

  Thanks,

  Cathy

  • Reply
  • Quote

   
• Wednesday, June 06, 2012 5:11 AM

   

   
  

  0

  Hi Cathy,

  I also tried to get technical assistance from Microsoft support for SQL Azure Reporting but came to know that Azure Reporting Services is still in CTP phase.

  I am quoting the mail response here:

  At the present time Reporting Services in Azure is still in Customer Technical Preview (CTP) mode and as such does not have engineer based assistance.  This will change as soon as it is comes out of CTP and is officially released.
   
  While in CTP support is only offered via the forums on http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/threads which are monitored by our developers.
   
  Sorry for the inconvenience but we will have to ask you to please post this same question on the forums.
   

  So, When SQL Azure Reporting Services is expected to come out of CTP?

  ---

  Thanks, Riddhi Mohan

  • Reply
  • Quote

   
• Tuesday, June 12, 2012 6:43 PM

  Moderator

   

   
  

  0

  Hi Riddhi,

  I apologize for misinforming you. But, support is now available, as of June 7th. Support should be able to assist you in troubleshooting what might be missing in the HTTP request.

  Thanks,

  Cathy

  • Reply
  • Quote