SAP Contact Center issues with installation of Standard Reports

[Former Member]

Hello,

I would be grateful for any help or advice with the following problem:

I have just built a new Contact Centre 7 FP12 development system on Windows Server 2016 and SQL 2016. I've successfully set up the Databases VU and the Reporting Database VU. The reports sites open okay. The Reports databases created without error (_VWU and _DSArea). I've followed the installation manual carefully and placed my Standard Reports in their own VU separare from the Reporting Database VU. I've completed the software variables. When I come to apply the changes to the system, it fails with the error: "create software instance [Standard Reports] to virtual unit [SAPCCTRDEVDB_StandardReports]: fail to run method 'postinstall' in D:\ContactCentre\install\7.0.12.0\Standard Reports\Method' : Method returned an error: Exit code=-1=0xFFFFFFFF. I have no idea what is causing this issue. Pre-reqs for the build are all present (i.e. the various Visual C++ runtimes, certificates, full .Net framework, .Net 3.5 (not in pre-reqs but requested during installation of Std Reports).

Logs show no clue (this section is the bottom of latest Standard Reports VU log - previous sections just repeat the same as this) :

31/05/2018 11:25:08 : Create or upgrade MS Reporting services with default reports:
31/05/2018 11:25:08 : - WDU server = SAPCCTRDEVDB
31/05/2018 11:25:08 : - OLAP server = SAPCCTRDEVDB
31/05/2018 11:25:08 : - OLAP database = ContactCenter_OLAP
31/05/2018 11:25:08 : - Customer = CCTRDEV
31/05/2018 11:25:08 : - Reporting Services 'Report Server' server = HTTP: //$VU_IP$/REPORTSERVER
31/05/2018 11:25:08 : - Reporting Services 'Reports' server = HTTP://$VU_IP$/REPORTS
31/05/2018 11:25:08 : - Reporting Services site = ContactCenter Reporting
31/05/2018 11:25:08 : - Product documentation site = https://help.sap.com/viewer
31/05/2018 11:25:08 : - Temporary directory used: D:\ContactCenter\logs\SAPCCTRDEVDB_StandardReports\
31/05/2018 11:25:08 : Connecting to reporting site HTTP://$VU_IP$/REPORTSERVER
31/05/2018 11:25:08 : Site check for 'HTTP://$VU_IP$/REPORTS' : Site connecting succeeded. Response: 12007
31/05/2018 11:25:08 : Folder name provided by user: C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services
31/05/2018 11:25:08 : Setup rssrvpolicy.config
31/05/2018 11:25:08 : Backup file allready exists: "C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\ReportServer\rssrvpolicy.config.Orig"
31/05/2018 11:25:08 : Permission for WicomTranslator.dll had allready granted. Configuration has not modified.
31/05/2018 11:25:08 : Setup rssrvpolicy.config finished
31/05/2018 11:25:08 : Setup RSWebApplication.config
31/05/2018 11:25:08 : Prepare installation files
31/05/2018 11:25:08 : Checking SQL Server connection: DRIVER=SQL Server;SERVER=SAPCCTRDEVDB;DATABASE=CCTRDEV_VWU
31/05/2018 11:25:08 : Time reference solved: FK_Time_Default
31/05/2018 11:25:08 : Installation files prepared
31/05/2018 11:25:08 : Install and setup WicomTranslator and translator.txt
31/05/2018 11:25:08 : Old file C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\ReportServer\bin\WicomTranslator.dll deleted succesfully.
31/05/2018 11:25:08 : New file C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\ReportServer\bin\WicomTranslator.dll copied successfully.
31/05/2018 11:25:08 : Old file C:\Program Files\SAP\ContactCenter\Translator.txt deleted succesfully.
31/05/2018 11:25:08 : New file C:\Program Files\SAP\ContactCenter\Translator.txt copied successfully.
31/05/2018 11:25:08 : WicomTranslator and translator.txt installed.
31/05/2018 11:25:08 : Next calling separate process 'RS.exe Utility' to create reports
31/05/2018 11:25:08 : rs -i "D:\ContactCenter\logs\SAPCCTRDEVDB_StandardReports\\PublishReports.rss" -l 360 -s HTTP://$VU_IP$/REPORTSERVER -v USERNAME=XXX -v PASSWORD=XXX

Any help or advice would be most gratefully received. I've been banging my head against this for too many hours now !!

Best regards,

Adele

[alexander_kupke]

Hi,

at first glance you might have an issue with Standard Reports installation. Specifically the server instance path.

Please go to the IA and check for the standard Reports, if the Path is right, no trailing empty characters, correct path...

• For 32-bit servers, enter the name or path. In the default SQL Instance, the name is MSSQLSERVER.
• For 64-bit servers enter the path of the server instance where the SQL Reporting Services component is installed. The path is for example PATH:C:\Program Files\Microsoft SQL Server\[Instance Name]\Reporting Services. (Path may differ according to your installation.)

Best Regards

Alexander

[Former Member]

Just to add a bit of further information to the above. Following the apparently successful installation of the Reporting Database VU, as well as the databases being visible in SQL Management Studio, I see two jobs in the SQL Server Agent list: "Reporting OLAP database management" and "SAP Contact Center Reporting installation, create OLAP database: ContactCenter_OLAP". Neither of these appear to have ever run (no history for either) and there are no OLAP cubes or databases under the Analysis Server.

Thanks,

Adele