Skip to Content
avatar image
Former Member

Lumira Edge Server(Team Server) to MySQL Connection issues

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

7.png (39.7 kB)
5.png (40.9 kB)
1,2,3,4.png (210.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    May 18, 2016 at 08:03 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 18, 2016 at 08:18 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

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

      Thanks

      Pramila

  • Jun 04, 2015 at 10:51 AM

    Hi,

    which generic driver did you install?

    regards

    H

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • Jun 04, 2015 at 08:35 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 09, 2016 at 02:49 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 10, 2016 at 04:39 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 11, 2016 at 09:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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