Behavior:
An "LDS Error" occurs while utilizing the Local Data Connector in an Autoindex job or a select list. Upon inspection of the LocalDataConnector.log (default location: C:\ProgramData\DocuWare\Logs), you find the error:
"Invalid object name 'TableName' "
Note: 'TableName' will be different based on the name of your external database table.
Solution:
This error occurs when using a non-default database schema in MSSQL. The database schema must be "DBO." Any other schema is not supported by the DocuWare Local Data Connector.
To resolve this, create a database view under the "DBO" schema that pulls the data from the non-default schema table.
KBA is applicable to DocuWare Cloud Organizations ONLY.