Hi Team/ <@UDQU92KBK> Facing issue to publish repo...
# troubleshooting
m
Hi Team/ @Mayank Facing issue to publish reports to tableau server. Reports gets published but once I try to view it. It keeps asking for password and does not embeds or accept it. Please help. In desktop tableau I am not facing such issue
m
Not sure if I am following your question. I don't recognize that screen, seems like auth built by your company?
m
Yes this user Id and password is authentication of our pinot prod cluster
nothing much
Hi @Xiang Fu Can you help me here
x
I don't know this either, which tableau connector are you using ?
m
I am using @Xiang Fu Start tree by apache pinot. I dont see if connect pinot using jdbc conection
x
cc: @Kartik Khare in case you know this
m
Hi @Kartik Khare Can you please help?
p
Looks like authentication is not embedded When publishing, if you chose “Prompt user” instead of “Embed password”, Tableau will always ask for credentials. I would check: 1. Go to Server → Publish Workbook or Publish Data Source 2. 2. In the Data Sources tab, look at the Authentication section. 3. Select: Embed the password in the connection 4. You might need to republish with new settings
thanks 1
m
@Pavlo Bakatov Even after doing this does not work and it only happens when I add query options queryOptions=useMultiStageEngine=true. Issue happens
p
On Tableau Server, pls check the VizQL Server logs -> "missing credentials"
m
I will try this out
@Pavlo Bakatov We are able to use apache startree connector in tableau desktop but same connector does not work on server when we use multistage as query options. Can we edit the startree taco file url? The moment additional properties is passed for multistage query the connection starts breaking.
FYI @Mayank
@Mayank or @Pavlo Bakatov Can anyone look here? We have some reports to be build on pinot database and we want to use multistage query options but I see in tableau server issues while adding this property. Who can help me here?
k
Hi for multistage you can simply pass the following
useMultistageEngine=true
in the additional properties no need to prefix it with
queryOptions=
m
Thanks @Kartik Khare Let me try with this
Error logs
@Kartik Khare I tried it but I get this exception
If I dont prefix with queryOptions=
I am stuck here from long time
Like if try to use filter on dates then it fails. Simple report works
@Kartik Khare Anything you can suggest me?
k
That should not happen. What is the pinot jdbc driver jar version you're using?
m
@Kartik Khare I am using this pinot-jdbc-client-1.3.0-shaded.jar
This works on local desktop of tableau but the moment I try to publish report on tableau server using multistage as true. It starts asking for authentication even after passing correct password and reports can not be viewed
@Kartik Khare Please help here I am stuck here from a long time
Hi @Kartik Khare Can you check this thread?
Hi @Kartik Khare Please help here
🍷 1
@Pavlo Bakatov Can you help me
Hi @Kartik Khare Can you take a look?
Hi @Kartik Khare Can you help me to sign a taco file? I unzipped it and passed multistageEngine=true to direct url and test it in local desktop. To use on server I need to sign it again
Hi kartik I am using taco file
k
Hi Madhulika, let’s get on a call tomorrow to resolve this. At what time will you be available?
m
Hi @Kartik Khare I am available around 10am-11 am tomorrow or 3pm to 4pm tomorrow. Let me know which time suggest you?
Hi @Kartik Khare Let me know what time suits you cc: @Mayank
k
let’s connect at 11am
m
Ok 11 am it is
Can you share your email in dm I will send an invite @Kartik Khare
k
Here's what I found from the logs: Root Cause • On Server, secure fields (like password) aren’t passed to the
connectionProperties.js
. • Our connector was still writing an empty password into the JDBC props, which ended up overwriting Server-embedded creds. • Pinot then sees blank password and rejects connection. Why Desktop Works, Server Fails • Desktop: connectionProperties.js gets your typed creds and forwards them. • Server: Password is injected at runtime. If connector sets it to empty string, it overrides the real one.
https://github.com/startreedata/startree-tableau-connector/pull/19/files following patch will fix this, Do you have a way to test this out publishing a certified one can take some time
m
@Kartik Khare Let me check this with Deepak internally and I will revert you, it is really helpful. I will keep you posted here.
m
cc: @Saptarshi Sengupta