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

[patelyogesh]

I am writing this blog for people who using ONESOURCE Tax software with SAP

This document will help you to understand installation process and refresh process of this software.

 

Download all required software from Link

Note: Install SQL instance with UTF8-compatible database character set. I have it installed my with :  Latin1_General_CI_AS

Please follow steps below for new software installation.

• Install JDK 1.8 on your server

• Check JAVA home running command ‘java -version’ on command prompt

• Backup SBXTAX and SBXAUD Databases from Production and restore them on target SQL instance (If you are performing system refresh and you already have Database)

• Create 2 new Database SBXTAX and SBXAUD running scripts\createSqlServerDatabases.bat

• Open control panel >> Administrative tools >> Component Services >> Component Services >> Computers >> My Computer >> Distributed Transaction Coordinator >> Local DTC >> Properties >> Security

Check the box on - Enable XA Transaction

• Restart SQL Instance

• Install SQLJDBC 4.0 Drivers for SQL
  
  
  
  • Open ..\sqljdbc_4.0\enu\xa\x64 folder and copy sqljdbc_xa.dll file to Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn
  
  
  • Run xa_install.sql from sqljdbc_4.0\enu\xa on your SQL instance
  
  
  
  

• Restart SQL

• Create ‘sbxaud’ and sbxtax’ users on SQL instance (If you are performing system refresh and you already have Database restored)

• Run following SQL statement on SBXTAX database and SBXAUD
  
  
  
  • sp_change_users_login 'update_one', 'sbxtax', 'sbxtax'
  
  
  • sp_change_users_login 'update_one', 'sbxaud', 'sbxaud'
  
  
  
  

(If you are performing system refresh and you already have Database restored)

• User Security
  
  
  
  • Set security for users as below
  
  
  • Make sure you have set user’s default database
  
  
  
  

• Install TOMCAT (use exe file)
  
  
  
  • Note: Make sure expand Tomcat tree and select both options under it
  
  
  • Use JDK 1.8
  
  
  
  

• Copy .war files from determination source and paste in to Tomcat’s ‘webapp’ folder determination-help.war, sabrix.war, sabrix-extensions.war

• Copy scripts\tomcat-sqlserver-xa-ds_example.xml to Tomcat’s ‘lib’ folder

• Copy sqljdbc4.jar from SQL drivers and paste in to Tomcat’s ‘lib’ folder

• Rename tomcat-sqlserver-xa-ds_example.xml to determination-xa-ds.xml (lib folder in tomcat)

• Change file as below (determination-xa-ds.xml)

<?xml version="1.0" encoding="UTF-8"?>

<datasources xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

			 xsi:noNamespaceSchemaLocation="http://www.jboss.org/ironjacamar/schema/datasources_1_0.xsd">

	<xa-datasource jndi-name="jdbc/TaxDataSource" pool-name="TaxDataSourceDS">

		<xa-datasource-property name="ServerName">Hostname</xa-datasource-property>

		<xa-datasource-property name="PortNumber">1433</xa-datasource-property>

		<xa-datasource-property name="User">sbxtax</xa-datasource-property>

		<xa-datasource-property name="Password">password</xa-datasource-property>

		<xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>

		<xa-pool>

			<is-same-rm-override>false</is-same-rm-override>

			<no-tx-separate-pools>false</no-tx-separate-pools>

			<min-pool-size>16</min-pool-size>

			<max-pool-size>64</max-pool-size>

			<prefill/>

		</xa-pool>



		<validation>

			<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker"></valid-connection-checker>

		</validation>

	</xa-datasource>



	<xa-datasource jndi-name="jdbc/AuditDataSource" pool-name="AuditSourceDS">

		<xa-datasource-property name="ServerName">Hostname</xa-datasource-property>

		<xa-datasource-property name="PortNumber">1433</xa-datasource-property>		

		<xa-datasource-property name="User">sbxaud</xa-datasource-property>

		<xa-datasource-property name="Password">password</xa-datasource-property>

		<xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>

		<xa-pool>

			<is-same-rm-override>false</is-same-rm-override>

			<no-tx-separate-pools>false</no-tx-separate-pools>

			<min-pool-size>16</min-pool-size>

			<max-pool-size>64</max-pool-size>

			<prefill/>

		</xa-pool>



		<validation>

			<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker"></valid-connection-checker>

		</validation>

	</xa-datasource>

</datasources>

 

• Change SQL Server Browser window service start Automatic and Start Service

• Open Tomcat configuration and change memory to 8192 and 8192 in JAVA TAB(bin folder *8w*.exe) (Set as per your requirement)

• Open SBXTAX database in SQL
  
  
  
  • Look for table sbxtax.TB_CONFIG and edit top 200 rows
  
  
  • Delete line 15 (Cluster settings)
  
  
  • In PARM_ID 14 - ENABLE_SERVER_COMMUNICATION = N
  
  
  • Press Execute button
  
  
  
  

Note: Do not perform steps mentioned above on your database. Perform steps through fronted only. You can use mentioned steps for your reference.

(This step is cluster specific installation to Non cluster DB refresh. If you are performing system refresh and you already have Database restored)

• Start Tomcat Service

• Open http://host:port/sabrix/install on tomcat (Log in as 'dba' user Default password is password)
  
  
  
  • Press Run button to start installation
  
  
  • Click on ‘messages’
  
  
  • For any duplication error contact functional team to fix it(Duplicate format will be | |) If you are performing system refresh and you already have Database restored)
    
  
  
  
  

• Login to Determination http://host:port/sabrix
  
  
  
  • Check help and about determination
  
  
  • Look for comment shows May 2017.1 (As per date you are installing)
  
  
  
  

• In determination go to Menu >> System >> Import Export (TAB Import)
  
  
  
  • Import browsing file ‘Sabrix US Master May 2017 G2.zip(As per date you are installing)
  
  
  • Click Next >> Next >> Close
  
  
  
  

• Import international content
  
  
  
  • determination go to Menu >> System >> Import Export (TAB Import)
  
  
  • import Sabrix INTL 3rd Master May 2017 G2.zip (As per date you are installing)
  
  
  
  

You successfully installed sabrix determination. Now next step to install Certificate Manager

 

Thank you

Yogesh