从昨天开始,当我在 Data Hub 上运行我们的 Exact Online 库存导出时,出现了以下错误:
Error itgencun016: Waarschuwing itgendhb005: Connection not established. Application is being closed.
Invantive SQL 脚本没有改变,批处理文件也没有改变。脚本不再输出库存概览。
批处理文件内容为:
@echo off
rem
rem Script to run an Invantive SQL file with possible Invantive Data Hub scripting language statements.
rem
rem Please note that the encrypted password is bound to the PC used to generate this file.
rem When you want to run this batch file on another PC, please generate a new encrypted password at that PC.
rem
rem Created by Invantive Control for Excel on 11/11/2016 9:08:38 AM.
rem
rem $Id: $
rem
set INVANTIVE_PRG=C:\Program Files\Invantive Software BV\Invantive Data Hub 2016R1 stable channel (LNUMBER)\Invantive.Producer.QueryEngine.exe
set INVANTIVE_USR=Invantive
set INVANTIVE_PWD=SECRET
set INVANTIVE_CONN=Exact Online\EOL-ACME-COM
set INVANTIVE_SQL_FILE=c:\jobs\invantive-extract-stock-positions.sql
set INVANTIVE_LOG_FILE=c:\jobs\invantive-extract-stock-positions.log
set INVANTIVE_INTERACTIVE=False
"%INVANTIVE_PRG%" /user:"%INVANTIVE_USR%" /connection:"%INVANTIVE_CONN%" /password:"%INVANTIVE_PWD%" /file:"%INVANTIVE_SQL_FILE%" /logfile:"%INVANTIVE_LOG_FILE%" /logoverwrite:"%INVANTIVE_LOG_FILE_OVERWRITE%" /interactive:%INVANTIVE_INTERACTIVE%
连接出了什么问题?
答案1
请检查您的日志文件。此消息仅在身份验证失败时出现,但由于日志文件非常详细,因此可能不会显示该消息。
可能是这样的:
Type: Invantive.Data.OAuthException
或者
Warning itgenerr024: Your session has expired. (Or whatever translation)
在 Exact Online 上,当密码或用户或连接字符串不正确时,错误可能会令人困惑。通常,它表示用户、密码或连接字符串错误(请指定apiUrl
以设置国家/地区)。