TNG and Microsoft Office Communication Server Lync (OCS)

[Leon van Heerden]

TNG and Microsoft Lync Server
Minimum versions required:
TNG >= 1.0.7.0
TNG Lync Interface >= 1.1.0.15
TNG Lync plugin >= 2011.09.21.2

The TNG Lync Interface is a service that you install on a Window PC that has access to the Lync Server call information database. Once the service is installed, you have change the user the service "runs as", to an user that has SELECT rights to the Lync LCSCDR database.

• This is done under the service manager interface (services.msc).
• Select the TNGLyncInterface service and right click on it;
• Select properties and go to the "Log on" tab.
• Select "This Account" and enter the user credentials that has the appropriate rights

When the service is installed, an INI file will be created in the same folder as the EXE file. (The default location is C:\Program Files\Datatex\TNG\TNGLyncInterface.INI)

This is what a basic TNGLyncInterface.INI file should look like.

Code: Select all

;TNG only allows for line names up to 10 characters.  Use the Gateways section to map gateways to lines.
[GATEWAYS]
;SIPGATEWAY1@MYDOMAIN=GW1
;MyDomain.local=GW1
;This will change the value "SIPGATEWAY1@MyDomain" to a value of "GW1" and place the value in the Trunk field

[GENERAL]
;This option is not used anymore and should be 0;
FILEREAD_ON=0

;This is the database ID that will be read at startup of the service. It is updated on shutdown.
DATA_NEXTID=0

;This is the +2 timezone to adjust the time of call records.
TIMEZONE=2

[EXTENSIONREPLACE_PREFIX]
;Lync Server places the full number for extensions and this is not userfriendly when trying to run reports.
;This lookup will replace the start of the extension value if it matches
;E.g. +27216573123 will be rewritten to 3123
;Multiple extension rules can be configured here. each on their own line.
27216573=3
+27216573=3



In the same folder as the service,must be a text file TngLyncInterface.ado file.
This file contains the database connection information.

Code: Select all

Driver={SQL Native Client};Server=sapserver;Database=LcsCDR;Trusted_Connection=yes

On the LcsCDR table, an incremental number field (DialogId) needs to exist to allow an unique position to be identified for each call record. This allows the TNG services to be restarted and no duplicated call records to be loaded. This field name is case sensitive, so make sure it appears exactly as printed here.

You will need to edit the SessionDetails table in design mode on the database.

Code: Select all

Add a Column called "DialogId"

Datatype = INT
Allow Null = No
Identity = Yes
Identity increment = 1
Identity Seed = 1


Copy the PMicosoftLync.DLL file to the Plugin folder in TNG's home folder if it is not already there. [C:\Program Files\Datatex\TNG\Plugins\]
In TNG, Select this plugin as the PBX format. The version of the plug will be displayed below the drop down box once you have applied it. Make sure it matches the version at the start of this post.

Configure the PBX connection as a Network connection.
Specify the IP address of the PC where the TNGLyncInterface is running and use TCP port 2550.

Now TNG should start reading the call data from the TNGLyncInterface and processing the data.

Troubleshooting:
Problem: TNG doesn't show any call records being processed.
Solution:

• Check the TNGLync.log in the TNG logs folder for the current day. The file should give you more information related to the problem.
• The TNGLyncInterface will not try to connect to the database until TNG has successfully connected to it.
• Check that the DATA_NEXTID in the INI file isn't set to a higher value than is actually available on the database's DialogId column.
• Check on the TNG Call Data view screen, if the Total number of records on the system is increasing. It might be processing data records that are older than the newest 50 records that is displayed on this screen.

Problem: During the install I get an error message

Code: Select all

Service "TNGLyncInterface" failed to install with error: "System Error. Code 1073. The specified service already exists"

Solution: The old service was not uninstalled properly before the new one was installed. try and run the setup again or try and stop the TNGLyncInterface before running the Setup.



Problem: During the install I get an error message

Code: Select all

Unable to execute file:
C:\Program Files\TNG_OCS\TNGOCSInterface.exe

CreateProcess failed; code 267.
The directory name is not valid.


Solution: This can be ignored. The installer tries to stop the old OCS interface and uninstall it if it is installed, before trying to install the new Lync interface.


Problem: After upgrading from OCS to Lync interface, my data is not working properly anymore.
Solution: Check that the INI file and ADO file in you TNG directory contains the correct information. If it doesn't,

1. Stop The TNGLynInterface
2. Check the C:\Program Files\Datatex\TNG_OCS\ folder for the INI and ADO files
3. copy the settings from those files to the new files.
4. Start the TNGLync Service.

Also make sure that you are using the Correct TNG plugin.

[Leon van Heerden]

Version 1.1.1.0
TNG Plugin version 2011.11.25.0 or newer.

This version has been updated to handle the longer string properly. If the Lync addresses were to long, if the total length of the database output was longer than 180 characters, encryption messed up the string and the last part of it could not be decrypted properly

The Service name is now TNGLyncInterface, the OCS is removed. The service needs to be re-installed for this.

PLEASE Note that you should Stop TNG if it is running before installing this update otherwise the Plugin will not be updated.

[Belinda Frick]

RELATED TOPIC:
TNG lost link to Microsoft Office Communication Server Lync