VU - Reporting DB Failed - FP14

[former_member340454]

Hi Guys,

I am upgrading a SAP CCtr to the new version FP14, but when I was installing the the report VU DB, I got the error below, but I recheck everything in OS and shows me that it is Ok.

1. All the SQL services are running

2. All the mandatory requirements were installed.

6/9/2019 7:25:44 PM : - OLAP Maintenance = yes

6/9/2019 7:25:44 PM : - Temporary directory used: D:\SAP\ContactCenter\logs\XXXXXXXX\

6/9/2019 7:25:44 PM : Checking SQL Server connection: XXXX;DATABASE=master

6/9/2019 7:25:44 PM : Checking SQL Server connection: XXXX;DATABASE=XXXX

6/9/2019 7:25:44 PM : Microsoft SQL Server is not installed or not running or invalid database name/SQL account/password. For more information, please refer to the Wicom CSS Installation guide.

I dont know what can I do to solve this!!!

I have tried all the possibilities....

All the best

Rodrigo Lucas

[former_member158363 · Accepted solution]

Hi Rodrigo,

I have tested the fresh installation and ran into same problem.

Then from the SQL error logs my colleague realized that user used for connection is trying to connect using SQL authentication, while he is configured for Windows authentication.

Is this your case?

I think there is bug in the installation VBS script, in the test connection procedure. I have changed one line in file

install_wdu_db.vbs located in

Install\7.0.14.0\Reporting Database Server\contents\script .

Locate following lines (somewhere around line 400):

' Helper function: CheckSQLServer

Sub CheckSQLServer (sDatabaseServer, sDatabase, sSQLLogin, sSQLPassword)

and change line:

sConnectionString = CreateDsn(sDatabaseServer, sDatabase, "no", sSQLLogin, sSQLPassword)

to this:

sConnectionString = CreateDsn(sDatabaseServer, sDatabase, "yes", sSQLLogin, "")

this fixed the problem for me and the Reporting DB server installation went fine.

I think the bug is actually only in the helper test connection function, rest of the script is probably correctly handling the connection string.

Hope this helps.

Regards,

Dawood

[Former Member · Accepted solution]

Once again, very grateful for your support Dawood. I too ran into this issue on the database installation of FP14. I had skimmed over the pre-reqs thinking I had them all and totally missed the 64-bit SQL ODBC driver 😐

I do wish these freeware pre-reqs (C++ runtimes, ODBC drivers) would just be bundled for install with the Contact Center product itself.

Would be good to get Java bundled too as we've just been quoted an exorbitant fee from Oracle for installing the JRE latest version on our server VMs. We've been told that we have to license all cores on the VMWare host. Given we have 1000s of cores by host, it's outrageously expensive (every month!). But anyway, that's for another thread. (Sorry for the Friday rant !!)

Thanks again for your help!

Best wishes,

Adele

[former_member650538 · Accepted solution]

Thank you so much, Dawood!

Your advice helped me install the report VU DB FP15.

[former_member158363]

Hi,

thanks for feedback 🙂 I will create an OSS incident for this. My "solution" is not universal, I am afraid. It would work for situation where the reporting user and HAC/IA user are the same only.

But let's see what SAP says.

BR,

D.

[former_member340454]

Hi Dawood,

Pretty good. Awesome!

Your solution also works for me 🙂

Thanks a lot

BR

Rodrigo Lucas

[former_member340454]

Hello, Dawood,

So, I read but the ODBC is already up to date, because I am doing a server migrate from Windows 2008 to Windows 2014 is a new server and the version ODBC Driver 17 for SQL Server,

And I am upgrating the SAP BCM 7.0.6.0 to SAP CCtr FP14.

I ran the upgrade of the report server via IA on the same server and remotely.

By the way I am tried to do a new instalation without ugrade the VU, I got the same error.

Regards,

Rodrigo

[former_member158363]

Hello Rodrigo,

did you check prerequisite software, namely upgrade of the ODBC driver, as mentioned in release notes?

What is the legacy version from which you want upgrade?

Do you run the upgrade of report server via IA on the very same server or remotely?

Regards,

Dawood

[former_member340454]

Hi Sergio,

The connection to BD is OK. I can connect with SSMS and using ODBC, Data Link Properties and etc...

I can´t install the reporting DB 😞

BR

Rodrigo

[Former Member]

Hi Rodrigo,

please, try to test the effective connectivity to the BD server with some free-tool from which you can download from the Internet.

Sergio,.