Skip to main content
Kofax

How to set WCDataService in the mode to display the queries executed for each command done by WCDataService

22625
QAID # 22625 NOT Published
Please do NOT provide the article number (QAID) and/or URL of this Knowledgebase article or its contents to external customers, as it is NOT Published and/or * INTERNAL ONLY *.

Question / Problem:

How to set WCDataService in the mode to display the queries executed for each command done by WCDataService

Answer / Solution:

Edit Web.config file for WCDataServices located in "C:\Program Files\Kofax\Insight 5.4.0\WcfDataService\Web.config"

Search for the key and changed it to “true”:

Refresh the KAFC dashboard view
Then look at the WCDatabaseService.log “C:\Temp\Insight_5.4.0\” location and it will contain the queries with results

2017-11-21 15:00:09,826 [47] INFO WcfDataService.Code.InsightService.LoginProvider - Getting values of property 'Batch Class'.
2017-11-21 15:00:09,826 [45] DEBUG AltoSoft.Insight.DatabaseManager.SQLQueryExecutor -
Executing query:
SELECT RightTablePrimaryKey FROM Relationships
WHERE RightTablePrimaryKey IN (SELECT NAME FROM BatchDef WHERE PublishedBatchDefID = 0)
AND 1 = (SELECT EnableUserProfiles FROM KGlobal) AND RightTableType = 3 AND ProfilePrimaryKey IN
(
(SELECT Users.ProfilePrimaryKey
FROM Users
WHERE Users.UserID = 'Administrator'
UNION
SELECT GroupProfilePrimaryKey AS ProfilePrimaryKey
FROM User_Group
INNER JOIN Users
ON User_Group.UserProfilePrimaryKey = Users.ProfilePrimaryKey
WHERE Users.UserID = 'Administrator')
)
UNION
SELECT NAME FROM BatchDef WHERE PublishedBatchDefID = 0
AND 0 = (SELECT EnableUserProfiles FROM KGlobal)
TimeOut 300

This data is useful when troubleshooting connection problems and data integrity.

Applies to:

Product Version Category
KAFC 2.0 Event Listener
  • Was this article helpful?