-
Unable to connect to SQLServer on server using TCP/IP and no encryption
Hello, I am learning to use Rapidminer Studio 10.1 and trying to connect to SQL Server database on a server over TCP/IP, SQL Server version 2019, have set the connection with correct information such as the database username and password, host with instancename, port, and database name , as well as adding parameter…
-
In database nest STRING_AGG() function? throws invalid syntax error
I tried to use string_agg() function in database nest. but it throws error whatever i used as syntax string_agg() WITHIN GROUP BYSTRING_AGG(email,';') WITHIN GROUP (ORDER BY email)I tried above two but no luck for me. Help me with syntax
-
Getting error Process failed: Submitted command failed: Error converting data type varchar to real
Process failed: Submitted command failed: Error converting data type varchar to real for union operator in database nest. Eventhough the value already REAL value.
-
Macro using dates for SQL
Hi: I'm trying to use a macro with date in an SQL statement but I'm getting an error from the SQL side. Here is part of the SQL statement: Declare @fDate date, @tdate date , @processingdate date, @lag int =%{lag}SET @fDate =%{themonth} error message is "Operand type clash: int is incompatible with date." How do I resolve…
-
Rapidminer Web Server Web Page Not Found Error
Dear RapidMiner Community, I was able to successfully install Rapidminer Server on my computer and was also able to successfully run the service. During the installation process, I have also tested my connected to the SQL Server and it was successful. However, whenever I try to use my Google Chrome and Microsoft Edge…
-
OUTPUT clause in not enabled when using Read Database Operator
Hi, I am trying to execute MERGE statement using Read Database operator. Not able to use OUTPUT clause in insert statement throwing syntax error. MERGE statement without OUTPUT clause is working fine in Execute SQL operator. But it is throwing error with output clause and also it doesn't have output port. , Please check…
-
For the 1st time i am using MACROS. I want to set the macro dynamically while reading data.
<?xml version="1.0" encoding="UTF-8"?><process version="9.9.000"> <context> <input/> <output/> <macros/> </context> <operator activated="true" class="process" compatibility="9.4.000" expanded="true" name="Process" origin="GENERATED_TUTORIAL"> <parameter key="logverbosity" value="init"/> <parameter key="random_seed"…
-
Error - execution of standalone.bat | RM AI Hub
Dear Community, I have problems with starting the RM AI Hub/ RM Server and I can not interpret the error message. Does anybody know a solution for this problem? Kind regards Friedrich -- I think this is the first important error-Message (also in the attached .log-file): 2021-03-10 15:57:58,835 ERROR…
-
My SQL connection with Rapid Miner
Hello Hello I'm working on a project at university and there is a "hackathon" coming up ( great stuff in corona time but anyway) in wich we going to receive an .sql file and solve some sort of datamining task. thats all we know. knowing the Professor so far and how chill he is it won't be an insane task but i obviously…
-
Execute SQL Operator - Calling Oracle Stored Procedure - Invalid SQL Statement
Trying to call an Oracle stored procedure using the Execute SQL operator and gettingDatabase error occurred: ORA-00900: invalid SQL statement. The SP I'm trying to call is located within the schema that I've configured the connection for.I can execute the SP successfully while connected via SQL Developer. I've…
-
Disconnected RM Server Repository at Azure
Hello everyone, I used to run some processes through RM Studio on a VM, using a connection to Azure with a free trial. My free trial expired. Does anyone know, if the connection will be restored and if i will retrieve my data in case of a payment? Or everything is gone? Thanks in advance
-
Unable to connect to local SQL Server Express
I'm trying to connect to a local SQL Server Express database and followed recommendations from https://community.rapidminer.com/discussion/comment/60894I added the "IntegratedSecurity=true" property and added the "sqljdbc_auth.dll" library on the driver tab. My URL is…
-
Using macro inside SQL queries
Hi All, I am trying to use Macros very dynamically in the SQL queries used to retrieve data from DW. I am assigning macro values from Excel as input. I am facing some issues in doing so. It shows me error stating "eval is not a recognized built in function name" Please find below screenshot of process: Kindly help resolve…
-
Read Database, query sql in
My query sql is SELECT xxxxxx FROM table.name WHERE columnA in (?) I want to define a macro which name %{list} to instead of ? I've tried %{list} value is A, execute the query success, but when value is A,B, my query result is null, so i want to know, which separate charactor should i use when there is multi value in SQL…
-
MS SQL database connnection
Hi there, I'm not sure the database connection in rapidminer server is still available right now? I was trying to create a new MS SQL connection in rapidminer server which is downloaded from aws marketplace. But the connection has failed. After checking the iptable in the image, I couldn't find the 1433 port which MS SQL…
-
Unable to use macros in Read Database operator
I'm trying to use macros in the Read Database operator but they are not interpreted and it results in an error. I tried two different cases: 1. Dynamic SQL, with macros directly in the SQL query 2. Prepared statements, with macros used in the parameters I need both options to work for different queries, but none of them…
-
How do I specify my Teradata database connection authentication mechanism as LDAP
Hello, I've configured the Teradata drivers according to RapidMiner documentation and verified that I am entering the correct host and port details with my IT department but I still get an error from Teradata saying my account name/account/password is incorrect. I've had the same issue with other analytic applications but…
-
RM Studio 9.5.001 - New Connection SQL Server - tables not showing
I just got a new win10 rebuild and installed RM 9.5.001 -- I went to add my new connection (vs the old legacy method) to a 2017 SQL Server. I connected with following URL (Note - I replaced my real server and db name in string) jdbc:sqlserver://SQLSERVER:1433;databaseName=MYDBNAME;integratedSecurity=true I have a Local…
-
Unable to connect to local SQL db
Hi, I downloaded Rapid Miner and I am really curious if it can help with my task of data analysis. However, I cannot connect to my local MS SQL Express database. I've set up the url which looks like this: jdbc:sqlserver://localhost:1433;databaseName={DbName};integratedSecurity=true; and when I don't provide the name of DB…
-
CONEXION A UNA BASE DE DATOS SQL
BUENAS COMO HAGO UNA CONEXION A UNA BASE DE DATOS SQL SEGURA ?
-
ขอทราบวิธีการเชื่อมต่อกับ Microsoft SQL Server หน่อยครับ
คือผมหามาหลายเว็บเเล้วครับยังเชื่อมต่อไม่ได้อยู่ดี ขอความกรุณาด้วยครับ
-
Challenge with RM Server - Running out of memory
Hi there! I am a newbie and this is my first post in the community. We have got a RM server installation on top of a MS SQL server box. We have a job container with 64GB RAM. I have built some workflows using sample data on studio environment and trying to run those processes after necessary changes in server environment…
-
Does RapidMiner close the DB session after it finishes execution on given SQL query?
Hi, I would like to know if RapidMiner closes the session in database after it finishes the execution of SQL query? In my case I use Teradata driver. Of course while working I ran process several times. I use 1 box for reading database table and another box for writing into datbase. But unfortunately after several…
-
Setup for RapidMinerServer on Microsoft SQL
Since upgrading to 9.2 I cannot get proper access and the error messages are confusing. I am running SQL Server 2017 on Windows Server 2016 What would be the correct Access Rights, Roles and Schemas for: 1. The Install/Administrator ID for RapidMinerSErver DB ? 2. A regular user. Many thanks
-
Manage SQL Server Connection
I'm running RapidMiner Studio 9 and am unable to connect to a SQL Server database thru the manage database connections. My SQL Server is on the same pc as RapidMiner, and I have three other applications which connected to SQL Server in minutes (ESRI ArcMap, Tableau and Excel) so I believe my settings are correct (TCP\IP…