Forum Discussion

FabioG's avatar
FabioG
New Contributor III
5 days ago

Using Assembly's XFBRs

Hi all, I'm in trouble in using an XFBR from an Assembly, inside a Data Adapter. I've just discovered that it's possible to use the XFBR function as part of a SQL Command, like this: SELECT * FROM...
Extensibility
FabioG's avatar
FabioG
New Contributor III
4 days ago

Thanks DanielWillis and sameburn for your answers,

Unfortunately, no luck yet.

I made one more test, setting the factory at the MU level, changing the query as:

SELECT * FROM MyTable WHERE MyField = 'XFBR(WSMU, MyFunction, Param1=XYZ)'

I removed the OS Param, so I removed a doubt about it.

If I "Test" the Data Adapter, it works fine.

If I run the Report from Report Designer it works fine.

 If I run the report from my dashboard, I get the following error:

Error processing XFBR String 'MyFunction'. Unable to find the Workspace Assembly Service Factory class for name 'WSMU' in Workspace 'Default' and Maintenance Unit ''

No problems at all if I call a "traditional" XBFR (outside from the Workspace)

Thanks for your effort

FabioG

  • DanielWillis's avatar
    DanielWillis
    Valued Contributor
    3 days ago

    Just tried to remember what our issue was. Someone was having trouble with a parameter that I'm sure was working previously now complaining about the same thing as yours. The parameter referenced an XFBR in a workspace service factory. Had to change to directly reference rather than use WS/WSMU. They were in the middle of UAT and didn't have time to look into it a great deal. Not sure if they ended up figuring out why the original issue occurred.

    Changed to: XFBR(Workspace.WorkspaceNameHere.AssemblyNameHere,XFBRNameHere)

    XFBRNameHere being what lands in args.FunctionName