Jag har installerat Invantive Data Hub version 26. Jag har angett en ny licensnyckel. Jag har ändrat settings.xml-filen och ändå fungerar det inte:
itgenobr051
Det går inte att ansluta till databasen ACME\exact-online-nl-sql-server.
Saknad användarinloggningskod i referenser.
Anropsstack:
13:58:30.751 InvantiveSystemException
ValidationException
vid Invantive.Basics.ValidationException..ctor(GlobalState owner, ExecutionOptions executionOptions, String messageCode, String errorMessage, String kindRequest, String localStackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable1 uid, Nullable1 isRecoverable, String poolIdentityId, String url, Nullable1 partyUid, String partitionCode, String tableName, String parameter1, String parameter2, String parameter3, String parameter4, String parameter5, String clientId)
vid Invantive.Basics.InvantiveSystemException..ctor(GlobalState owner, ExecutionOptions executionOptions, String validationCode, String errorMessage, String kindRequest, String stackTr...DecryptionErrors, Boolean& decryptionErrorsOccurred)
vid Invantive.Data.ConnectionManager.Open(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, CredentialsContainer credentialsContainer, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
vid Invantive.Data.ConnectionManager.Open(GlobalState owner, ExecutionOptions executionOptions, CredentialsContainer credentialsContainer, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
vid Invantive.Producer.UtilityBaseCore.OpenDatabase(GlobalState owner, ExecutionOptions executionOptions, String databaseFullName, CredentialsContainer credentialsContainer, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred) Exception under uppstart: Invantive.Basics.ValidationException: itgendhb005: Kan inte ansluta till databas 'C. van Heezik\exact-online-nl-sql-server'. Applikationen stängs.
vid Invantive.Basics.ValidationException..ctor(GlobalState owner, ExecutionOptions executionOptions, String messageCode, String errorMessage, String kindRequest, String localStackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable1 uid, Nullable1 isRecoverable, String poolIdentityId, String url, Nullable1 partyUid, String partitionCode, String tableName, String parameter1, String parameter2, String parameter3, String parameter4, String parameter5, String clientId)
vid Invantive.Producer.Data.Hub.QueryEngine.Run(GlobalState owner, ExecutionOptions executionOptions, String
arguments)
vid Invantive.Producer.Data.Hub.Program.Main(String
args)
vid Invantive.Producer.Data.Hub.QueryEngine.Run(GlobalState owner, ExecutionOptions executionOptions, String
arguments) in c:\smoke\ws-26.0\Invantive.Data.Hub\src\Invantive.Producer.Data.Hub\QueryEngine.cs:line 612.
settings-acme.xml:
<?xml version="1.0" encoding="utf-8"?>
<settings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
version="5"
forcedefault="false">
<group name=“ACME”
sortingOrder=“0”
<connection name="exact-online-nl-sql-server"
>
<credentials
order="10"
description="My Exact Online"
database="bedrijfsnaam-exact-online"
datacontainers="*"
userLogonCodeMode="Hidden"
passwordMode="Hidden"
defaultUserLogonCode="ict@acme.eu"
defaultPassword="secret"
/>
<database alias="sqlserver"
provider="SqlServer"
userLogonCodeMode="Hidden"
passwordMode="Hidden"
connectionString="Data Source=SQLSERVER;Database=ExactOnline;UID=LOGIN;PWD=Password;Encrypt=false"
AllowConnectionStringRewrite="false"
/>
</connection>
</group>
</settings>
När jag testar Exact Online-anslutningen i Invantive Cloud fungerar allt. Information hämtas och visas korrekt från Exact Online i Invantive Cloud. Men jag behöver få informationen lokalt på SQL-servern.