Hi, I am trying to connect tableau desktop with pi...
# troubleshooting
a
Hi, I am trying to connect tableau desktop with pinot server using these steps (https://docs.pinot.apache.org/integrations/tableau), but Tableau gives me following error.
Copy code
An error occurred while communicating with Other Databases (JDBC)
Bad Connection: Tableau could not connect to the data source.
Error Code: FAB9A2C5
org/apache/commons/configuration/Configuration
Generic JDBC connection error
org/apache/commons/configuration/Configuration
I checked through postman that the broker and server endpoint are working. anyone here knows how to fix this or troubleshoot ??
k
Try copying the
pinot-all
jar from
lib
to the Drivers directory as well.
🦜 1
a
ok, trying
where will i find this folder ?
k
which folder? the lib one should be besides the plugin folder in pinot
a
its not there for me? could it mean their is some problem in build process ?
i am running this $ mvn clean install -DskipTests -Pbin-dist
k
can you send the list of directories. The command seems correct
a
IMG_20220705_161746.jpg
k
can you scroll above, there should be a
build
folder as well.
a
no build folder
k
ok. Then, can you check the
target
directory inside
pinot-distribution
module. It should have a
apache-pinot-bin-xxxx
folder
a
can't find target directory inside there too
k
Then the build didn't run/complete I guess. Can you send me the final output of the build
a
ok, starting build again.
Got killed automatically after long run
k
mvn -T4 clean package -DskipTests -Pbin-dist
try this
also make sure java version is set to java 11
a
Version looks fine
Running new command
Same result..killed
k
Then it is something wrong in the environment. It generally takes 5-6 minutes to run. Can take more for the first time since it needs to pull all the dependencies from maven.
a
Ok, i'll run it on another machine..thanks for the help
Hi @Kartik Khare, i copied the pinot-all to tableau's drivers folder...it still didn't connect
k
Can you check the
jprotocol.log
file. It is in the
My Tableau Repository
directory generally
That should contain the full stacktrace
a
Screenshot 2022-07-05 at 5.45.27 PM.png
do you think this problem is from my side ? (configuration, environment etc) or its in pinot codebase ??