Issue with function GETUSERTABS and GETUSERTABSWITHREPORTS in Administration Service

Loc Ngo shared this problem 2 years ago
Defect Logged

Hi Yellowfin team,


I am using Function GETUSERTABS and GETUSERTABSWITHREPORTS in Administration Service but seem publishUUID I recive is not correct, It is a publishUUID of SUBTAB.


Thanks and Regards,

Comments (20)

photo
1

Hi Loc,


Thanks for getting in touch. What build and version are you using here? (You can find this in the system information tab of the admin console)


Regards,

Nathan

photo
1

Hi Nathan,


These are build and version:


Application Version:7.35Current Schema Version:

Original Code Version:20170608

Current Code Version:20170608

Import Version:4.46


Thanks,

photo
1

Hi Loc,

In my tests on your build, the publishUUIDs were appropriate to the item they represented. This call will return a reportgroup array with the following structure:

reportgroups []= 
	(administrationReportGroup){ #first tab for user
		(administrationReport){  #first report on tab
			reportId
			publishUUID  #sub-report UUID
			reportName
			...etc
		}
		(administrationReport){ #second report on tab
			...
		}	
		reportgroupID
		publishUUID    #this is the dashboards UUID
	}
	(administrationReportGroup){ #second tab for user
		...
	}
Is this consistent with what you are noticing? 

Regards,

Nathan

photo
1

Hi Nathan,


I see those functions (GETUSERTABS and GETUSERTABSWITHREPORTS) return all Dashboard subtabs not Dashboard tabs. Is that right?


Thanks,

photo
1

Hi Nathan,


If a comment above is right, so Can you show me Web Service, which I can get all Dashboard tabs.


Thanks,

photo
1

Hi Loc,


In GETUSERTABSWITHREPORTS each sub-tab will have its own reportgroup object.


The GETUSERPARENTREPORTGROUPS sounds more like what you are going for. This is currently undocumented (I am steadily documenting these in my free-time).

Here is the structure returned by this call:


      (parentReportGroup){
         reportGroup =
            (administrationReportGroup){
               publishUUID = "a278e2ac-7bd9-42e5-9667-8614f738b099"
               reportGroupId = 63077
               reportGroupName = "User Prompt"
               reportGroupStatus = "OPEN"
               reportGroupType = "ANALYTIC"
            }
         reportGroupId = 63077
         reportGroupSubTabs[] =
            (administrationReportGroup){
               publishUUID = "93aa2353-2a59-4221-974a-009a32390946"
               reportGroupId = 63080
               reportGroupName = "sub-tab1"
               reportGroupStatus = "OPEN"
               reportGroupType = "SUBTAB"
            },
            (administrationReportGroup){
               publishUUID = "4df04d39-1c3a-4e49-ae5e-314d495687c7"
               reportGroupId = 63087
               reportGroupName = "sub-tab2"
               reportGroupStatus = "OPEN"
               reportGroupType = "SUBTAB"
            },
      },


Does this work for you?

Regards,

Nathan

photo
1

Hi Nathan,


Thanks for your support. I was run with GETUSERPARENTREPORTGROUPS function and I see the exception is

java.io.IOException: No serializer found for class com.hof.mi.web.service.ParentReportGroup in registry org.apache.axis.encoding.TypeMappingDelegate@d5e83cf
Thanks

photo
1

Hi Loc,


All of my tests have been on a very recent build so this might have been added since the build you are using. What build and version are you on (can be found in the system information section of the admin console)?


Regards,

Nathan

photo
1

Hi Nathan,


These are build and version:

Application Version:7.35

Current Schema Version:

Original Code Version:20170608

Current Code Version:20170608

Import Version:4.46


Thanks,

photo
1

Application Version:7.35

Build:20170608

Java Version:1.8.0

Operating System:Windows 8.1 6.3 (amd64)

photo
1

Hi Loc,


My apologies, I forgot you sent that earlier in the conversation!


Is this an upgraded instance or a fresh installation? This error makes me think that something is missing from the web-service library in your build. If this is upgraded, what version and build were you on prior to upgrading?


Regards,

Nathan

photo
1

Hi Nathan,


This is a fresh installation. I was install on Linux and Window, all of them meet with this error,


Thanks

photo
1

Hi Loc,


Can you send me a code snippet of how you are making this call? In all of my tests on your build this works the exact same as GETUSERTABSWITHREPORTS, just returns different objects.


Also can you send me the yellowfin.log file for this time?


Regards,

Nathan

photo
1

Hi Nathan,


I using SoapUI app to call this.

<soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xmlns:xsd="http://www.w3.org/2001/XMLSchema"; xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"; xmlns:ser="http://service.web.mi.hof.com"; xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">;
   <soapenv:Header/>
   <soapenv:Body>
      <ser:remoteAdministrationCall soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">;
         <req xsi:type="ser:AdministrationServiceRequest">
            <function xsi:type="xsd:string">GETUSERPARENTREPORTGROUPS</function>
            <loginId xsi:type="xsd:string">admin@yellowfin.com.au</loginId>
            <orgId xsi:type="xsd:int">1</orgId>
            <password xsi:type="xsd:string">test</password>
            <person xsi:type="ser:AdministrationPerson">
               <userId xsi:type="xsd:string">admin@yellowfin.com.au</userId>
            </person>
         </req>
      </ser:remoteAdministrationCall>
   </soapenv:Body>
</soapenv:Envelope>
Thanks

photo
1

Hi Loc,


Do you have a few minutes to screen-share on this?


Regards,

Nathan

photo
1

Hi Nathan,


What app you want me use for screen-share?


Thanks,

photo
1

Hi Loc,


We typically use ringcentral. I have started a meeting so you can just click on this link and join:


https://meetings.ringcentral.com/j/1480331483


Regards,

Nathan

photo
1

Hi Loc,


I have not been able to replicate this issue on my end, but I am going to go ahead and raise a defect ticket to address it.


In the meantime I would suggest exploring the results of: GETUSERPARENTTABS, and see if this can meet your needs. I will keep you updated on the status of this ticket and hopefully we will get an answer soon.


Please let me know if you have any questions!


Regards,

Nathan

photo
1

Hi Nathan,


I appreciate for your support. Thank you so much,


Thanks and Regards,

photo
1

No problem!