SQL Connection

Hi Willem,

what exactly do you mean by "changing the SQL connection"? You are apparently using an external database system (Oracle or MS SQL Server) and not the Postgres runnable, that is clear, but what exactly is your intention?

Do you have one database with ARIS data inside it, and now want to switch your ARIS installation to some other database (maybe with different ARIS data inside or maybe still empty)? That is not supported a supported scenario. ARIS stores data in a variety of places, not only in the DB, and if you change the DB under the hood, things will go out of sync. More recent versions have a detection logic that will recognize such a situation and try to recover from it, but many things might still go wrong.

Maybe if you describe more precisely what you have in mind, we can find a way to help you.

Regards

Jürgen

Hi Jürgen,

Thanks for the reply.

When doing an ARIS10 install connecting to SQL 2012, the services do not start up, they stay in "Starting" mode, when I select to start the services "Automatically". I now have installed ARIS10, selecting to start the services "Manually". The DBA are attending to SQL server connection problem, and I just want to change the SQL connection parameter as described in the documentation, unfortunately, the example is written for Oracle, and I need the exact command string for SQL.

Hope that makes sense...

Regards,

Willem

Hi Willem,

I assume you installed via setup, right? And you probably entered a wrong parameter (e.g, hostname, or port, or password...) in the setup's database connection dialog?

In that case, the best approach is just to check how the setup registered your SQL Server instance based on your input. In ACC, make sure that the Zookeeper runnable is started. Then run the command

"list external services"

You should see one or more services, one of type "DB". Its ID will most likely be "db0000000000", e.g.:

ACC+ localhost>list external services
Service Type   Service Kind  Service ID               Alive  HOST                    PORT   AJP_PORT  CONTEXT  SCHEME
DB             external      db0000000000             -      yourdb.host.name        12345  -         /        http
SMTP           external      smtp0000000000           -      yourmailsrv.host.name   25     -         -        -

Run the command "show service db0000000000" (or whatever ID your DB service has) to show the details for the service, e.g.:

ACC+ localhost>show service db0000000000
Service db0000000000 (Type DB)
Parameters:
Key                     Value
[...]
host                    yourdb.host.name
password                *ARIS!1dm9n#
port                    12345
[...]
url                     jdbc:sqlserver://yourdb.host.name:12345/aris
username                oris

(This is a fabricated example, and I left out a number of parameters, as indicated by "[...]")

 

You will then see all the parameter that are currently set for your service (but in newer versions, you will not see the password in plaintext, just "*****"). Here you can check which parameter(s) is/are wrong, and then, using the "update external service" command, you can change only those value(s) that is/are wrong. For example, if the parameter "username" is currently set to "oris" as in my example, but it should be "aris", run the command:

update external service db0000000000 username="aris"

In a similar fashion, you can also change other parameters.

For example, if you entered a wrong port, you will probably have to change two parameters, because the setup puts the port into to parameters, into "port" and also as part of the "url" parameter. So if in the example above you wanted to change the port from 12345 to 12346, you would run the command

update external service db0000000000 port="12346" url="jdbc:sqlserver://yourdb.host.name:12346/aris"

Note that I took the original value of the "url" parameter, and just replaced the port number.

Als note that any parameters that you do NOT explicitly change in the "update external service" command will stay as they were.

Regards

Jürgen

Thanks Jürgen, you're help is much appreciated.

Will implement as suggested.

Have a fantastic day,

Willem