英文:

Dynamic Process Properties passed from database cause an error, but static values do not

问题 {#heading}

我们有多台Microsoft SQL服务器，我们通过链接服务器访问它们。以前，我们在Boomi中有一个查找表来记录这些信息，因为它存储在一个位置上，但是由于这些信息不断变化，所以将其移到了SQL数据库中。

当我们尝试通过从数据库调用中检索值来连接到链接服务器时，我们会收到以下错误消息：

嵌入式消息：在构建或执行SQL语句时发生错误：为链接服务器"**已移除**"指定了无效的架构或目录；原因是：为链接服务器"**已移除**"指定了无效的架构或目录。

然而，如果我使用设置属性形状静态地传递这些值，我们就不会收到此错误，并且会得到预期的结果。我已经检查了从数据库中检索到的DPP（可能是数据处理程序）的值以及手动设置它们后的值，它们是相同的。

有什么建议吗？ 英文:

We have a number of Microsoft SQL servers we access via linked servers. Before we had a lookup table in Boomi to record this information as it is stored against a location, however this is constantly in flux so it was moved to a SQL database.

When we attempt to connect to a linked server by retrieving the values from the database call we get:

Embedded message: Errors occurred while building or executing SQL statement: An invalid schema or catalog was specified for the provider "MSOLEDBSQL" for linked server "**removed**".; Caused by: An invalid schema or catalog was specified for the provider "MSOLEDBSQL" for linked server "**removed**".

However if I set the values that are being passed statically with a set properties shape we do not get this error and retrieve the expected result. I have checked the values of the DPP's both after retrieving them from the database and after setting them manually and they are identical.

Any suggestions?

答案1 {#1}

得分: 0

事实证明，这与Boomi无关，问题是它正确检索了信息，但是SQL数据库处于ANSI模式，意味着响应被填充了空格，这些空格在输出值时不可见，但一旦我将其转换为JSON，它们就会显示出来。 英文:

Turns out this had nothing to do with Boomi, what was happening is it was retrieving the information correctly, however the SQL DB was in ANSI mode meaning the response was padded with spaces, these didn't show when outputing the values but as soon as I converted it to JSON they showed.