Skip to main content

Hi


I created a custom Smart-Object with the DynamicSQLSPService. When i test the SmartObject with the Amazing Smart Object Tool it works.


But when i use the Smart Object in a workflow i always get this error:


"825690","2009-03-06 10:21:01","Error","SmartObjects","10044","ExecuteSmartObjects","SourceCode.SmartObjects.Runtime Bytee] ExecuteInstance(Bytee], Boolean, System.Data.DataTable)]","10044 Broker Execution Exception DataBase Exception] : Invalid column name 'RoleName'.
Invalid column name 'UserName'.","anonymous","0.0.0.0","SERVERNAME:c:program files (x86)k2 blackpearlHost ServerBin","825690","4be5004200a34723ad2c4e5edfb24327","" 


The RoleName and UserName are 2 parameters which the Smart Object uses to get the right values.


Any idea?


Thanks


 

With the SQL Profiler I see a SQL query which probably is causing the error, this query makes no sense to me. It happens on the Service Broker database.

 




WITH

>_dbo___getUsers_] as (
Select #1f04a126c9e24ec29a4dddf5a8371905]..Username] as Username]
 From m#1f04a126c9e24ec29a4dddf5a8371905]
)

, ,93a47be333a04bd8aa23b89c562d9ba4] as
(
Select * From

"_dbo___getUsers_]
)
SELECT count(*)
FROM M93a47be333a04bd8aa23b89c562d9ba4]
 WHERE
UserName1 = 'testuser'
Hi, I got the same error while working with a process in which i used smartobject creted using Dynamic SQLSQP service. When i tested with smartobject service tester it works fine, but when i create a process to retrieve data, it gives Invalid column name 'EmployeeID'. Any Ideas...

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings