Invantive Data Hub v26をインストールしました。新しいライセンスキーを入力しました。settings.xmlファイルを調整しましたが、それでもうまくいきません:
itgenobr051
データベース ACME\exact-online-nl-sql-server に接続できません。
資格情報にユーザーのログオンコードが不足しています。
コールスタック:
13:58:30.751 InvantiveSystemException
ValidationException
at 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)
at Invantive.Basics.InvantiveSystemException..ctor(GlobalState owner, ExecutionOptions executionOptions, String validationCode, String errorMessage, String kindRequest, String stackTr...DecryptionErrors, Boolean& decryptionErrorsOccurred)
at Invantive.Data.ConnectionManager.Open(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, CredentialsContainer credentialsContainer, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
at Invantive.Data.ConnectionManager.Open(GlobalState owner, ExecutionOptions executionOptions, CredentialsContainer credentialsContainer, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred)
at Invantive.Producer.UtilityBaseCore.OpenDatabase(GlobalState owner, ExecutionOptions executionOptions, String databaseFullName, CredentialsContainer credentialsContainer, Boolean ignoreDecryptionErrors, Boolean& decryptionErrorsOccurred) Exception during boot: Invantive.Basics.ValidationException: itgendhb005: データベース 'C. van Heezik\exact-online-nl-sql-server' に接続できません。アプリケーションは終了します。
at 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)
at Invantive.Producer.Data.Hub.QueryEngine.Run(GlobalState owner, ExecutionOptions executionOptions, String
arguments)
at Invantive.Producer.Data.Hub.Program.Main(String
args)
at 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>
Invantive CloudでExact Onlineの接続をテストしたところ、すべて正常に機能します。Exact Onlineから情報がきちんと取得され、Invantive Cloudに表示されます。しかし、情報をローカルのSQLサーバー上に取得する必要があります。