Other configuration

i2 TextChart provides a few ways to modify its behavior so that it works better in your environment. For example, you can adjust the amount of memory available to the extraction process, and change the way TextChart authenticates with the database.

Memory configuration

If you experience poor performance, especially during processing of large files, you can change the size of the JVM heap by editing the configuration file at C:\Program Files\TextChart\RosokaServiceCore.l4j.ini.

To adjust memory allocation, which defaults to 4 GB, change:

-Xms4g
-Xmx4g

to:

-Xms<GB_OF_RAM_TO_ALLOCATE>g
-Xmx<GB_OF_RAM_TO_ALLOCATE>g

For example, to set it to 8 GB, the two lines would be:

-Xms8g
-Xmx8g

Database configuration (SQL Server)

TextChart authenticates with SQL Server through database user credentials rather than operating system credentials. You need to ensure that your installation of SQL Server is configured appropriately.

Setting mixed authentication

  1. Open SQL Server Management Studio.

  2. From the Authentication drop-down list, select Windows Authentication .

  3. Click Connect.

  4. Right-click the SQL instance and choose Properties to open the Server Properties window.

  5. In the Select a page list, click Security.

  6. In the Server authentication section, choose SQL Server and Windows Authentication mode.

  7. Click OK to close the Server Properties window.

  8. Right-click the SQL instance and choose Restart.

  9. Click Yes to restart the SQL server.

Enabling the 'sa' user

  1. Open SQL Server Management Studio.

  2. From the Authentication drop-down list, select Windows Authentication.

  3. Click Connect.

  4. In the Object Explorer, expand Security and then expand Logins.

  5. Right-click sa, and click Properties.

  6. In the Select a page list, click Status, and then change the Login setting to Enabled.

    Note: You might need to set a password for this account as well.

  7. Click OK to close the Login Properties window.

  8. Press F5 to refresh the information in the Object Explorer.

Changing TCP and port settings

  1. From the Start menu, right-click My Computer, and then select Manage.

  2. In the Computer Management window, expand Services and Applications > SQL Server Configuration Manager > SQL Server Network Configuration.

  3. Select the instance for your installation. By default, this is Protocols for SQLEXPRESS.

  4. Change the Named Pipes protocol option to Enabled. You do not need to change the default Pipe Name setting.

  5. Change the TCP/IP protocol option to Enabled, and then open its Properties dialog.

  6. In the IP Addresses tab, scroll down to IPAll at the bottom of the list.

  7. Set TCP Port to 1433, and remove any value from TCP Dynamic Ports.

  8. Click Apply. You will be prompted to restart SQL Server.

  9. Restart the server for the changes to take effect.