Skip to main content
Nintex Community Menu Bar

DynamicSQLSPService Smart Object Error

  • March 6, 2009
  • 2 replies
  • 19 views
Forum|alt.badge.img+5

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 [Byte[] ExecuteInstance(Byte[], 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


 

    2 replies

    Forum|alt.badge.img+5
    • uekur
    • Author
    • March 6, 2009
    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 [#1f04a126c9e24ec29a4dddf5a8371905]
    )

    , [93a47be333a04bd8aa23b89c562d9ba4] as
    (
    Select * From

    [_dbo___getUsers_]
    )
    SELECT count(*)
    FROM [93a47be333a04bd8aa23b89c562d9ba4]
     WHERE
    UserName1 = 'testuser'
    Forum|alt.badge.img+9
    • srikanthch
    • September 10, 2009
    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...
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement