NAV Language Settings in TIBCO Scribe® Insight

Products	Versions
TIBCO Scribe Insight	7.02 and above

Description

TIBCO Scribe® Insight using the Dynamics NAV adapter generates the following error:

Error: Target adapter user count invalid (Invalid Query: Table 'LicenseInformation' not found, Scribe.NavAdapter.Table - Error opening table or query.)

kA20e000000fxTYCAY_en_US_1_0

When the Dynamics NAV Adapter encounters a foreign language version of Dynamics NAV, the adapter cannot find the system tables because the table names have been modified.

Issue/Introduction

If you are using a foreign language version of Dynamics NAV and the names of the system tables for that version are not in English, you may need to modify the SCRIBE.KSYNC tables in the Scribe Internal Database. The Scribe Internal Database (default name SCRIBEINTERNAL) is a SQL Server database that contains information used by TIBCO Scribe® Insight and is stored in the TIBCO Scribe® Insight installation directory. When the Dynamics NAV Adapter encounters a foreign language version of Dynamics NAV, the adapter cannot find the system tables because the table names have been modified

Resolution

Modify the SCRIBE.KSYNC tables.

The SCRIBE.KSYNC tables in the Scribe Internal Database contain the names of the system tables. Use SQL statements to update the system table names in your Scribe Internal Database.

Example

Assume that you are using a Spanish language version of Dynamics NAV and the system table names are in Spanish.

Note: The Spanish language table names used in this example are not the table names used by the Spanish language version of Dynamics NAV, they are provided only to illustrate how to modify the Scribe Internal Database

In the table above the English names are the table names expected by TIBCO Scribe® Insight. The Spanish table names are the ones currently in the system tables. To modify the Scribe Internal Database to recognize the Spanish table names do the following:

1. Open SQL Server Management Studio or another tool that allows you to run SQL statements.
2. Locate the Scribe Internal Database.
3. Below are a set of SQL statements with the table names in English. These are only for illustration purposes.

update SCRIBE.KSYNC set KEYVALUE='LicenseInformation' where SECTION='ADAPTERS' and KEYNAME='DYNAMICSNAVADAPTER.LICENSEINFOTABLENAME'

update SCRIBE.KSYNC set KEYVALUE='Text' where SECTION='ADAPTERS' and KEYNAME='DYNAMICSNAVADAPTER.LICENSEINFOCOLUMNNAME' update SCRIBE.KSYNC set KEYVALUE='Session' where SECTION='ADAPTERS' and KEYNAME='DYNAMICSNAVADAPTER.SESSIONTABLENAME'

update SCRIBE.KSYNC set KEYVALUE='UserID' where SECTION='ADAPTERS' and KEYNAME='DYNAMICSNAVADAPTER.USERIDCOLUMNNAME'

update SCRIBE.KSYNC set KEYVALUE='User' where SECTION='ADAPTERS' and KEYNAME='DYNAMICSNAVADAPTER.USERTABLENAME'

update SCRIBE.KSYNC set KEYVALUE='ExpiryDate' where SECTION='ADAPTERS' and KEYNAME='DYNAMICSNAVADAPTER.2013EXPIRATIONDATECOLUMNNAME'

update SCRIBE.KSYNC set KEYVALUE='UserName' where SECTION='ADAPTERS' and KEYNAME='DYNAMICSNAVADAPTER.2013USERNAMECOLUMNNAME'

4.Modify the KEYVALUE with the Spanish table name and execute the following SQL statements to change the SCRIBE.KSYNC tables:

update SCRIBE.KSYNC set KEYVALUE='Licencia' where SECTION='ADAPTERS' and KEYNAME='DYNAMICSNAVADAPTER.LICENSEINFOTABLENAME'

update SCRIBE.KSYNC set KEYVALUE='Texto' where SECTION='ADAPTERS' and KEYNAME='DYNAMICSNAVADAPTER.LICENSEINFOCOLUMNNAME'

update SCRIBE.KSYNC set KEYVALUE='Sesiones' where SECTION='ADAPTERS' and KEYNAME='DYNAMICSNAVADAPTER.SESSIONTABLENAME'

update SCRIBE.KSYNC set KEYVALUE='NumeroUsuario' where SECTION='ADAPTERS' and KEYNAME='DYNAMICSNAVADAPTER.USERIDCOLUMNNAME'

update SCRIBE.KSYNC set KEYVALUE='Usuario' where SECTION='ADAPTERS' and KEYNAME='DYNAMICSNAVADAPTER.USERTABLENAME'

update SCRIBE.KSYNC set KEYVALUE='FechaCaducidad' where SECTION='ADAPTERS' and KEYNAME='DYNAMICSNAVADAPTER.2013EXPIRATIONDATECOLUMNNAME'

update SCRIBE.KSYNC set KEYVALUE='NombreUsuario' where SECTION='ADAPTERS' and KEYNAME='DYNAMICSNAVADAPTER.2013USERNAMECOLUMNNAME'

5. As each statement is executed, the table names are updated in the Scribe Internal Database.

Welcome to "KB Articles"