cancel
Showing results for 
Search instead for 
Did you mean: 

Lumira Edge Server(Team Server) to MySQL Connection issues

Former Member
0 Kudos

Hi All,

Firstly here're the specs:

Windows Box info:

OS: MS Windows 8.1 Pro

RAM: 4GB

Architecture: x64 bit

Processor: Core i3 CPU @3.4GHz

Software Info:

DB: MySQL CE v5.6.23.0

Lumira:

Desktop: SAP Lumira Standard Edition 64bit v1.25.1 build 23 (running as 30 days trail mode)

Cloud: SAP Lumira Cloud Free Edition with 1GB storage

Edge: SAP Lumira Edge Server/Team Server/Server for Teams (running as 30 days trail mode with installed key for 5 users) build v1.25.0.15

All these installed on same machine.

I created a Data Set on Lumira Desktop(Standard Edition running on 30 days trail) from MySQL and exported the same to Lumira Edge.

When I alter my view on MySQL that's used for dataset creation, I'm able to see the updated result set on Lumira Desktop after hitting the refresh button.

Similarly, I tried clicking the 'Refresh Document' (not the 'Refresh' button on visualize mode) on Lumira Edge for the updated result set without re-exporting the data set and then issues started flowing.

Here're the list of errors I faced:

1. Unable to connect. Check your data access driver

         - for this after RnD, I installed generic JDBC driver from Edit Drivers section since there's no option for MySQL connectivity.

2. Forbidden

         - after installing driver and restarting server manually

3. SyntaxError: Unexpected token c

         - after installing driver and restarting server manually

4. SyntaxError: Invalid character

         - after installing driver and restarting server manually

5. Unable to see server info under Maintenance screen since the installation

6.Unable to restart server from 'Maintenance' screen (due to the above error 5)

        - After installing driver

7. Restart failed from the 'Maintenance' screen

8. How do I access this server from different system over internet?

        - Tried using the URL generated with 2 named users but not able to access via different system

PFA screenshots numbered accordingly to the issues.

Please help me out at earliest with any info, documents etc.,

Googled a lot and not able to find any relevant info.
There's lot of naming convention confusion happening all over the internet too.

Let me know any info needed further.

Thank You,

Karthik

Accepted Solutions (0)

Answers (7)

Answers (7)

Former Member
0 Kudos

Hi Pramila

i forgot:

in our productive scenario we have 6 dataset , so in the edge solution  when refreshing he ask 6 time the sql  password !!

thanks

regards

nicky

0 Kudos

Hi

This is currently not there in LUMIRA, Can you please submit in SAP idea place.

Thanks

Pramila

Former Member
0 Kudos

Hi Pramila

thanks a lot

as discussed can you please give me a feedback about the feature :

- pass the name-password for the sql connection from lumira desktop to lumira edge  because the end user of lumira edge has now to put 2 password for refreshing the data : 1 user- password for his edge account and 1 user pw for the sql account

thanks

regards

Nicky

Former Member
0 Kudos

Hi

thanks

i tried twice start and stop, but same errror

has someone at SAP tried to make  simple sql query in lumira desktop, save the document in teams  and refresh the document in internet Explorer (11)  ?

thanks

regards

0 Kudos

Hi

Yes, I have tried, the same workflow, It is working properly.

Thanks

Pramila

Former Member
0 Kudos

This message was moderated.

0 Kudos

Hi

Driver configuration has to be done in Lumira Edge also to refresh a document in Lumira Edge.

This can be done from Configuration tab.

There is section named uploads, expand it then edit , then select the database ,select the driver ,click on done.

Then restart the server.

Thanks

Pramila

0 Kudos

HI

Seems to be server is not started properly. Can you please try to restart using Stop and start services from the start menu.

Thanks

Pramila

Former Member
0 Kudos

hi all

i have the same error in lumira edge when refreshing the document  :unable to connect.check your data access driver

i use lumira edge 1.30

any suggestion?

thanks

regards

nicky

former_member183750
Active Contributor
0 Kudos

Hi Karthic

Please see if the following will help:

KBA 1971847 - Lumira Desktop is unable to connect to a Microsoft SQL server instance?





- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow me on Twitter

Former Member
0 Kudos

HI Ludek,

Thanks for the SAP Note.

I don't have any issue connecting to MySQL from Lumira Desktop, but when connecting to MySQL from Lumira Edge issue exists

Please refer to the attached screenshot named 1,2,3,4.png

Regards.

former_member183750
Active Contributor
0 Kudos

Strange. Reinstalling Lumira Edge an option?

- Ludek

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

which generic driver did you install?

regards

H

Former Member
0 Kudos

Hi,

Thanks for fast response,

I Installed generic JDBC driver since there's no option for MySQL connector as in Lumira Desktop.

I selected the same driver in MySQL installation directory which I installed it for the Desktop which worked fine.

Here's the connector name and version:


MySQL Connector/J 5.1.34

path for the folder is like this:

C:\Program Files (x86)\MySQL\Connector.J 5.1

Regards.