on 06-04-2015 11:46 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
which generic driver did you install?
regards
H
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.