Skip to Content
Author's profile photo Yogesh Patel

ONESOURCE – Tax & Accounting – Thomson Reuters:- DataServices (MS SQL/Windows) Installation

You successfully installed Reporting and now you are on next step to install Data Services

  • Run setup.exe from extracted source
    • Use same CMS and business object you installed previously
    • Install with default configuration
    • Select next on components selection screen
    • Registration Name of CMS: ETL_REPO
    • DB:ETL_REPO
    • User: ETL_REPO
    • Password:
    • Run as system account

 

  • Stop SIA and restart Server after installation completed

 

  • Login to Data Service Server and open Data Service Server Manager
    • Open Configuration Editor> job server > edit
      • Uncheck Use SSL Protocol for…. (2nd option)
      • Checked Support adapter…(1st option)
    • On miscellaneous tab
      • Configure email settings
    • Click close and restart

 

  • Stop and Start SIA (SAP BusinessObject)

 

  • Open CMC

 

  • Open Servers in CMC and open properties of EIMAdaptiveProcessingServer (Server)
    • In Command line edit between -server….-Djava.awt.headless=true {-Dcom.sun.net.ssl.enableECC=false} “-Dbobj.enterprise.home
    • Restart Server Service

 

  • Add Administrator user in to all Data Services * groups

 

  • Open Administration > web services > web Services configuration (right side)
    • Change remove to disable session security (Make sure you select all check boxes)

 

  • In Adaptive > job adapter configuration > web services
    • Adapter retry = 5
    • 30000 = 150000

  • TAB (Adapter Instance Status)
    • Web service select > shutdown and start

 

  • Open reporting installation source and run install\ONESOURCEInstallationConfigurator.jar
    • Reporting Server DB, Version, Server Name
    • Password, DB Name, Create DB URL, Test DB Connection (sqlijdbc4.jar from tomcat lib folder)
    • Uncheck Use Reporting Database, Server name (If this is not on same server)
    • Password, DB Name, Create DB URL, Test DB Connection
    • Server Name (CMS), Password, Tomcat Server Name, Test Web Service
    • Create ‘recon’ folder in Program Files (x86)\SAP BusinessObjects
      • Source : R:\Program Files (x86)\SAP BusinessObjects\recon
      • Error : R:\Program Files (x86)\SAP BusinessObjects\recon
    • Server name, Create URL
    • Save and close
    • Provide file name ‘installation-config’
    • Copy Documents\installation-config.xml to ONESOURCEIDTReporting_6600\
    • Copy sqljdbc4.jar to C:\temp
    • Edit install.bat
      • scripts\reporting-install.bat -o “C:\temp\sqljdbc4.jar” -c “C:\source\TAX\Reporting\ONESOURCEIDTReporting_6600\install\Installation-config.xml”
    • Run query on SBXAUD DB: alter table sbxaud.RS_INVOICE_LINE_TAXES ADD COMPLIANCE_AREA_UUID varchar(32)
    • Run install.bat in administrator mode

 

  • Stop Reporting tomcat

 

  • Copy reporting.war and reporting-private-ws.war from deployments\tomcat to tomcat’s webapp

 

  • Copy reporting-configuration.jar from deployments\tomcat to tomcat’s lib

 

  • Open deployments\tomcat\reporting-combined-context.xml and copy content between line 6 to 30 to tomcat\conf\context.xml at line 34

 

  • Stop Data Service through windows services
    • Open C:\ProgramData\SAP BusinessObjects\Data Services\conf\admin.xml
    • Edit admin.xml
      • Line 43 <js-socket-timeout> 900000</js-socket-timeout>
    • Edit DSConfig.txt
      • Line 136 Replace_Substr_Max_Return_Size_Characters = 500500
    • Start Data Services service on window

 

  • Start Reporting Tomcat

 

  • Open Sabrix http://host:port/sabrix/
    • Menu > System > Config> change : REPORTING_URL =
    • Open reporting from menu on sabrix

 

  • Login to data services
    • Administration > Batch > ETL_REPO > Batch job configuration > SBX_STAGE_Load (Run this once)
      • Type: ‘CUSTOM’
      • Start date: ‘yyyy.mm.dd’ (According to requirement)
      • End date: ‘yyyy.mm.dd’ (According to requirement)
      • G_PERFORM_JOB_AUDIT has value N
    • Administration > Batch > ETL_REPO > Batchjob configuration > OP_User_Access_Load > execute > execute button (Run this once)

 

Note: Make sure functional consultant schedule jobs as per requirements.

 

You successfully installed DataServices software. Now we are going to configure SAP and ONESOURCE integration

Thank you

Yogesh

Assigned tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Gabrielle Ennes
      Gabrielle Ennes

      Thanks Yogesh for detailed steps!

      I just finished upgrading to OneSource 6.8, Business Object 4.2 sp08 and Data Service 4.2 sp14 and steps you mentioned were performed. However when login in to Data Service Management Console to run the ETL_Repo batch jobs OP_User_Access_Load_Cleanup and OP_User_Access_Load, batch job configuration tab is empty. How do I recover the ETL_REPO batch jobs?

      Please suggest

      Thanks, Gabrielle

      Author's profile photo Gabrielle Ennes
      Gabrielle Ennes

      Hi while further checking found some issues on the Reporting Installer log. The script collects the info but aborts with the following error:

      Installation of SabrixReportsInfoGatherer complete.

      Component SabrixReportsTaxEngineAuditSchemaExtensions will be upgraded from 0.0.0.0.0 to 6.8.0.0.17.
      Creating schema using definitions in data model 'reportsDeterminationAuditSchemaExtensionsDataModel' version '6.8.0.0.17'.
      SQL execution is enabled. All changes will be committed.
      Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
      SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
      Exception in thread "main" java.lang.reflect.InvocationTargetException
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      at com.sabrix.jarrunner.JarRunner.run(JarRunner.java:589)
      at com.sabrix.jarrunner.JarRunner.main(JarRunner.java:388)
      Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [alter table RS_INVOICE_LINE_TAXES
      ADD COLUMN FILING_AUTHORITY_NAME varchar(100)
      ADD COLUMN COMPLIANCE_AREA_UUID varchar(32)]; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'COLUMN'.
      at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
      at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

       

      We also upgrade to MSSQL 2016 and OS Windows 2016.

       

      Please advise if you have seen this error before and how it was fixed.

      Thanks, Gabrielle

      Author's profile photo Umesh Chaudhari
      Umesh Chaudhari

      Hello Gabrielle,

       

      We are also facing same issue which you are facing during installation of reporting 6.8

      Is your issue has been fixed.If yes how you have fixed the issue.Please suggest.

       

      ERROR [com.sabrix.installer.Installer] (main:) Unable to find installation note with where clause 'note_type = 'CSV' order by last_update_date desc'.
      2021-03-05 12:55:42,977 67373 WARN [com.sabrix.installer.Installer] (main:) The installation notes table was detected but the current system version cannot be determined. Will assume version is 0.0.0 and continue.
      2021-03-05 12:55:42,977 67373 INFO [com.sabrix.installer.CommandLineInstaller] (main:) Component SabrixReportsControl will be upgraded from 0.0.0.0.0 to 6.8.0.0.17.
      2021-03-05 12:55:42,977 67373 ERROR [com.sabrix.installer.Installer] (main:) Unable to find installation note with where clause 'note_type = 'CSV' order by last_update_date desc'.
      2021-03-05 12:55:42,977 67373 WARN [com.sabrix.installer.Installer] (main:) The installation notes table was detected but the current system version cannot be determined. Will assume version is 0.0.0 and continue.
      2021-03-05 12:55:43,024 67420 ERROR [com.thomsonreuters.reports.installer.actions.v6500.ShrinkUsernameColumnInstallerAction] (main:) Unable to find installation note with where clause 'version = '6.5.0.0.0' and note_key = 'ShrinkReportingUsernameColumnInstallerActionNotesId''.
      2021-03-05 12:55:43,039 67435 ERROR [com.thomsonreuters.reports.installer.actions.v6500.ShrinkUsernameColumnInstallerAction] (main:) Unable to find installation note with version '6.5.0.0.0' and key 'ShrinkReportingUsernameColumnInstallerActionNotesId'.
      2021-03-05 12:55:43,039 67435 WARN [com.sabrix.installer.actions.RegExpMatchingInstallerAction] (main:) An error occurred during execution of action 1, class com.thomsonreuters.reports.installer.actions.v6500.ShrinkUsernameColumnInstallerAction.
      com.sabrix.installer.common.InstallerRuntimeException: Unable to find installation note with version '6.5.0.0.0' and key 'ShrinkReportingUsernameColumnInstallerActionNotesId'.
      at com.sabrix.installer.common.AbstractInstallerObject.findInstallationNote(AbstractInstallerObject.java:602)
      at com.sabrix.installer.common.AbstractInstallerObject.findInstallationNote(AbstractInstallerObject.java:575)
      at com.sabrix.installer.actions.AbstractDatabaseManipulationInstallerAction.shouldExecute(AbstractDatabaseManipulationInstallerAction.java:105)
      at com.thomsonreuters.reports.installer.actions.v6500.ShrinkUsernameColumnInstallerAction.shouldExecute(ShrinkUsernameColumnInstallerAction.java:80)
      at com.sabrix.installer.actions.AbstractDatabaseManipulationInstallerAction.install(AbstractDatabaseManipulationInstallerAction.java:74)
      at com.sabrix.installer.actions.RegExpMatchingInstallerAction.doInstall(RegExpMatchingInstallerAction.java:333)
      at com.sabrix.installer.actions.AbstractDatabaseManipulationInstallerAction.install(AbstractDatabaseManipulationInstallerAction.java:76)
      at com.sabrix.installer.actions.CompositeInstallerAction.doInstall(CompositeInstallerAction.java:58)
      at com.sabrix.installer.actions.AbstractDatabaseManipulationInstallerAction.install(AbstractDatabaseManipulationInstallerAction.java:76)
      at com.sabrix.installer.CommandLineInstaller.run(CommandLineInstaller.java:258)
      at com.sabrix.installer.CommandLineInstaller.main(CommandLineInstaller.java:67)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      at com.sabrix.jarrunner.JarRunner.run(JarRunner.java:589)
      at com.sabrix.jarrunner.JarRunner.main(JarRunner.java:388)
      Caused by: com.sabrix.installer.common.InstallerRuntimeException: Unable to find installation note with where clause 'version = '6.5.0.0.0' and note_key = 'ShrinkReportingUsernameColumnInstallerActionNotesId''.
      at com.sabrix.installer.common.AbstractInstallerObject.findInstallationNotesUsingWhereClause(AbstractInstallerObject.java:734)
      at com.sabrix.installer.common.AbstractInstallerObject.findInstallationNote(AbstractInstallerObject.java:596)
      ... 16 more
      Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select installation_note_id, note_type, version, note_key, note_value, creation_date, last_update_date from RC_INSTALLATION_NOTES where version = '6.5.0.0.0' and note_key = 'ShrinkReportingUsernameColumnInstallerActionNotesId']; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'RC_INSTALLATION_NOTES'.
      at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:237)
      at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:456)
      at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:464)
      at com.sabrix.installer.common.AbstractInstallerObject.findInstallationNotesUsingWhereClause(AbstractInstallerObject.java:711)
      ... 17 more
      Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'RC_INSTALLATION_NOTES'.
      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)
      at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:616)
      at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
      at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:441)
      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
      ... 20 more
      2021-03-05 12:55:43,086 67482 ERROR [com.sabrix.installer.actions.RegExpMatchingInstallerAction] (main:) Maximum number of errors reached. Details are shown below.

      Author's profile photo Gabrielle Ennes
      Gabrielle Ennes

      My issue has been resolved.

      There was a bad SQL code making the Reporting Installer script to abort.

      It was found the below 2 columns to be missing on table RS_INVOICE_LINE_TAXES. These were added to Reporting and Determination Databases and after that Installer script ran correctly. Also Reporting definitions and ETL batch jobs were populated after that.

      COLUMN FILING_AUTHORITY_NAME
      COLUMN COMPLIANCE_AREA_UUID

      Hope it helps,

      Thanks, Gabrielle

      Author's profile photo Gabrielle Ennes
      Gabrielle Ennes

      Hi Reporting experts,

      I'm running the Reporting Installer script version 6.8.0 on our Prod system and facing issue with TempDB filling up 100%. Script is running "Component SabrixReportsAudit will be upgraded from 6.3.0.0.54 to 6.8.0.0.17" phase "Adjusting 'RS_INVOICE_LINE_TAXES.FEE_AMOUNT'" and it runs for a very long time and fills up our DB filesystem TempDB. We already expend it to 200GB but still fails.

      Component SabrixReportsAudit will be upgraded from 6.3.0.0.54 to 6.8.0.0.17.
      Creating schema using definitions in data model 'Reports Audit' version '6.8.0.0.17'.
      SQL execution is enabled. All changes will be committed.
      Unsupported column alteration. Cannot morph column 'com.sabrix.dblib.domainmodel.Column [name=BATCH_DATE, table=RS_AUTH_CATEGORY_LOOKUPS, type=93, length=null, precision=23, scale=3, nullable=true, audited=true, defaultValue='null']' into column 'com.sabrix.dblib.domainmodel.Column [name=BATCH_DATE, table=RS_AUTH_CATEGORY_LOOKUPS, type=91, length=null, precision=null, scale=null, nullable=true, audited=true, defaultValue='null']' on table 'RS_AUTH_CATEGORY_LOOKUPS'.

      ...

      Adjusting 'RS_INVOICE_LINE_TAXES.FEE_AMOUNT' column precision and scale.

      Any suggestions?

      Thanks, Gabrielle