" /> [UCS] Could not create datasource - Genesys CTI User Forum

Author Topic: [UCS] Could not create datasource  (Read 62734 times)

Offline hsujdik

  • Hero Member
  • *****
  • Posts: 541
  • Karma: 30
Re: [UCS] Could not create datasource
« Reply #15 on: July 16, 2018, 01:23:13 PM »
Advertisement
On the UCS host

Offline qoternaud

  • Newbie
  • *
  • Posts: 19
  • Karma: 0
Re: [UCS] Could not create datasource
« Reply #16 on: July 16, 2018, 01:47:46 PM »
[code]PATH=/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/genesys/bin:/home/genesys/bin:/usr/java/jre1.8.0_171-i586/bin/java
PWD=/opt/genesys/GCTI/bin/UCS_P
JAVA_HOME=/usr/java/jdk1.8.0_171-amd64/
LANG=en_US.UTF-8
HISTCONTROL=ignoredups
SHLVL=1
HOME=/home/genesys
LOGNAME=genesys
CLASSPATH=/usr/lib/ojdbc6.jar
[/code]

this is what i have now (UCS Host), but i still get the error, i tried both jdk and jde for the PATH
I might be missing on something but, do i just have to put the jdbc path in the bash_profile as done above, or i have to put the file in the java directory ?
« Last Edit: July 16, 2018, 01:53:51 PM by qoternaud »

Marked as best answer by qoternaud on July 18, 2018, 01:41:09 AM

Offline hsujdik

  • Hero Member
  • *****
  • Posts: 541
  • Karma: 30
Re: [UCS] Could not create datasource
« Reply #17 on: July 16, 2018, 03:44:53 PM »
[quote author=qoternaud link=topic=11046.msg50248#msg50248 date=1531748866]
[code]PATH=/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/genesys/bin:/home/genesys/bin:/usr/java/jre1.8.0_171-i586/bin/java
PWD=/opt/genesys/GCTI/bin/UCS_P
JAVA_HOME=/usr/java/jdk1.8.0_171-amd64/
LANG=en_US.UTF-8
HISTCONTROL=ignoredups
SHLVL=1
HOME=/home/genesys
LOGNAME=genesys
CLASSPATH=/usr/lib/ojdbc6.jar
[/code]

this is what i have now (UCS Host), but i still get the error, i tried both jdk and jde for the PATH
I might be missing on something but, [b]do i just have to put the jdbc path in the bash_profile as done above, or i have to put the file in the java directory ?[/b]
[/quote]

It is up to you. You could put the ojdbc[b]8[/b].jar (should match your Java version) on the /usr/java/hre1.8.0_171-i586/lib/ext (for example) and set it in your classpath. It should be in the bash_profile. If you are starting UCS by the Genesys Management Layer (SCI, GAX or GA), you must also restart LCA on the UCS host after setting it in the bash_profile. If you are starting it directly via command line, you should execute
[code]
source ~/.bash_profile
[/code]
in order for your current session get those variables.

Offline qoternaud

  • Newbie
  • *
  • Posts: 19
  • Karma: 0
Re: [UCS] Could not create datasource
« Reply #18 on: July 17, 2018, 12:44:19 PM »
[quote author=hsujdik link=topic=11046.msg50249#msg50249 date=1531755893]
[quote author=qoternaud link=topic=11046.msg50248#msg50248 date=1531748866]
[code]PATH=/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/genesys/bin:/home/genesys/bin:/usr/java/jre1.8.0_171-i586/bin/java
PWD=/opt/genesys/GCTI/bin/UCS_P
JAVA_HOME=/usr/java/jdk1.8.0_171-amd64/
LANG=en_US.UTF-8
HISTCONTROL=ignoredups
SHLVL=1
HOME=/home/genesys
LOGNAME=genesys
CLASSPATH=/usr/lib/ojdbc6.jar
[/code]

this is what i have now (UCS Host), but i still get the error, i tried both jdk and jde for the PATH
I might be missing on something but, [b]do i just have to put the jdbc path in the bash_profile as done above, or i have to put the file in the java directory ?[/b]
[/quote]

It is up to you. You could put the ojdbc[b]8[/b].jar (should match your Java version) on the /usr/java/hre1.8.0_171-i586/lib/ext (for example) and set it in your classpath. It should be in the bash_profile. If you are starting UCS by the Genesys Management Layer (SCI, GAX or GA), you must also restart LCA on the UCS host after setting it in the bash_profile. If you are starting it directly via command line, you should execute
[code]
source ~/.bash_profile
[/code]
in order for your current session get those variables.
[/quote]


Ok finally i found , it , i had to install [b]jdbc 8[/b] , then delete complety my DAP because it automatically linked to the DB Server (port 4040) and  create a new one configured with [b]the port of my DB[/b], then set the host
( Genesys Administrator automatically put the DB Server port if you choose the host first in the DAP application )

big thanks to hsujdik !