UBAQ BPM DLL Assembly - Does it exist, and where?

Kinetic ERP
1

Say if I am inside a UBAQ BPM, and I try to get →

this.GetType().Module

I get this returned “MyCompany_MyBAQName.RunCustomAction.dll”

Does this file physically exist? Can I retrieve it?

I know it’s an odd request. but I’m working on something fun and useful, and it would make my life easier.

2

if you enable source dump yes you can view the source

3

That’s not what I’m asking. I want the location of the dll file, if it exist somewhere other than memory.

4

It exists in database: [Ice].[CustomizationStore] table

5

Thank you ! @Olga

Thank you too @jgiese.wci

6

Although this is not what I wanted, I’m intrigued and ashamed I don’t have any idea what you are talking about? Can you expand on that ?

7

If you don’t want to see the source code, what’s the need to see where it is?

8

@klincecum It is under the IIS folder for the app server. BPM/Sources then BO, DT or Ubaq

Also in the you did not ask for it category. I use @hkeric.wci’s recommended tool of cmnder a ton to do grep searches thru these folders.

9

I’m a secret agent for Hydra. I’ve come to infiltrate from the inside. MUWHAHAHHAHHA

But seriously, I’ll share soon if I can get enough time.

10

I search the database directly especially if I’m dealing with tech debt.

Find code in EFX

SELECT
	EfxFunction.LibraryID,
	EfxFunction.FunctionID,
	EfxFunction.Description,
	CONVERT (nvarchar(MAX), Body, 0) AS MyText
FROM
	Ecf.EfxFunction
WHERE
	CONVERT (nvarchar(MAX), Body, 0) LIKE '%Ice.Diag%'
ORDER BY
	EfxFunction.LibraryID ASC,
	EfxFunction.FunctionID ASC

Find code in Method, Data, UBAQ directives

SELECT
	BpDirective.DirectiveID,
	BpDirective.Source,
	BpDirective.DirectiveType,
	BpDirective.DirectiveGroup,
	BpDirective.Name,
	BpDirective.Company,
	BpDirective.BpMethodCode,
	CONVERT (nvarchar(MAX), Body, 0) AS MyText
FROM
	Ice.BpDirective
WHERE
	CONVERT (nvarchar(MAX), Body, 0) LIKE '%.CreditHold%'
ORDER BY

	BpDirective.Source ASC,
	BpDirective.DirectiveGroup ASC,
	BpDirective.BpMethodCode ASC,
	BpDirective.DirectiveType ASC,
	BpDirective.Name ASC

Find in screen customization

SELECT
  XXXDef.Key1,
  XXXDef.Key2,
  XXXDef.Content
FROM
  Ice.XXXDef
WHERE
  TypeCode = 'Customization' AND
  Content LIKE '%RestClient%'

Auxiliary note here

On latest versions of Epicor to get the source to show up in these folders you will want to enable dump sources
image

4 Likes
11

Well it wasn’t exactly what I needed, but I’m glad I’m educated.

Sharing what I got will have to wait a bit. I was working on a bunch of things at once, and got confused and deleted 8 hours of work that I hadn’t backed up.

Live and learn.

12

@jgiese.wci Dude, that sql pattern is awesome, learned something new!

13

Again, you rock, anyway…

Packaged Up For Convenience:

https://www.epiusers.help/t/findincode-db-baq-or-why-we-all-love-jgiese-wci/104658/