Metastorm BPM forums

Refresh Blank Forms List

hdolliner — Fri, 30 Jul 2010 19:40:23 GMT

Hello,
Does anyone knows how to automaticly refresh Blank Forms List after submitting a form using jscript code?
We have a process and there is a dynamic role on first action, after form is submitted, user is removed from that role and the process should not be available in blank forms for that user. If the user manualy does not refresh the blank forms list and attemping to open the blank form, error is appearing, because the user does not have acces to that blank form anymore.
Any idea?
We are using Metastorm V7.6 SP2.

Thank You in advance.

Forum: Web Client

Passing data to a linked process

stevenlee100 — Thur, 29 Jul 2010 16:25:18 GMT

Hi,

The Flag that gets created automatically when you link a process to its parent, doesn't appear to be configurable. You can access the default (system) parameters (Name and FolderID) from the linked process, but you can't add additional ones for passing user data.

I've managed to grab field values from the parent process via a straight DB look up, but this seems a little clunky to me. Does anyone know how it should be done?

Any help greatly appreciated.

Forum: Metastorm BPM 9 Designer

Ghost folders

Arnold — Thur, 29 Jul 2010 14:34:09 GMT

Hi,

In a production environment we can see a lot of "Ghost folders" (action cancelled by the red cross on the top right of the form and so never submitted).
In order to identify the ghost folders and ONLY the ghost folders I use this query (oracle):
select efolderid
from efolder
where ((efolder.eactionname is not null AND
eactioncount = 0)
or estagename is null)
AND eactiontime < (sysdate -3) --action started at least 3 days ago

Is it correct or I miss something?

Another point is: On what tables I need to delete the corresponding folderid?
For now I have identified efolder, ewait, eattachment, elog and of course the tables of your procedures.

Anything else ?

Thanks in advance

Forum: Engine

Misleading error messages for Business Object params

Jerome — Thur, 29 Jul 2010 07:43:29 GMT

Half a frickin day tracking this one down!

I kept getting a fault "Conversion failed when converting date and/or time from character string"

I looked at everything, and it took some hours to narrow down, and it was a BO integer value. Every time I used it, this error came up. Even when I just traced it to the log.

Eventually I go look at the BO, and the three params are text, date, date, but had been all defined as text. What had happened was the designer must have made some conversion to text at the point where I entered th4e params when using the BO, and the engine could not convert that text back to a date when using it. I say that as changing the type forced me to replace the params as used (even though they 'appeared' to be set).

It also is strange that the engine only barfed when the value was read. If I did not use the value, it was ignored. That gives some interesting insight into when the BO is initialised. I thought it would be on form load, but it may not be until used (which may be optimal, but I can foresee issues there).

Anyway, in case anyone gets a similar error, it may be the BO params.

Forum: Metastorm BPM 9 Engine

using EraiseFlag command on Citrix Desktop

rfromm — Wed, 28 Jul 2010 11:16:16 GMT

I am trying to run an EraiseFlag command, it works on the Metastorm Server fine, with data and all. I am defining the Metastorm Server name in the command.
If I run it on my Fat client it runs with no errors but nothing is added to the table, no events etc. either. This must be a connection error or block somewhere in our Network ??

If I run it on a Citrix Desktop it errors with a 'Failed to create e-work Event Manager object. Reason:Interface not registered' - maybe I need to get the ERaiseFlag registered on the Citrix Servers ??

I am in the RaiseFlag group, both as me and as part of a Windows User group.

I have administrator access on the Server and on my PC

any suggestions ?

Forum: Designer

can a button on a stage form open an action?

jatin — Tue, 27 Jul 2010 19:36:56 GMT

Hi,
We are using 7.6.

Is it possible to open an action on click of a button from a stage form?

Thanks,
Jatin

Forum: Designer

Set highlighted row in a grid

Krondeau — Tue, 27 Jul 2010 14:06:52 GMT

How do I set the highlighted row on a grid? I have a detail grid that is dependant upon the selection of a row in a header grid. This works fine, however, I need the first row of the detail grid to be highlighed whenever it is refreshed by a selection in the header grid. If the user has previously selected a row in the detail grid, it stays highlighed even when the grid data changes.

Forum: Designer

Finding User in LDAP using JScript.net

agrawars — Tue, 27 Jul 2010 13:59:25 GMT

Hi,

I am trying to search user using jscript.net
When I am doing this thing from Integration Wizard using LDAPSearch method. It is working fine. But when I am trying to do the same thing using DirectoryServices class. It is not returning the result.

Code snapshot.

directoryEntry1 = new DirectoryEntry("LDAP://" + strDomain,"username","password");

directorySearch1 = new DirectorySearcher(directoryEntry1);

strFilter="(&(objectclass=user)(samaccountname="+ strUserName +"))";

directorySearch1.Filter = strFilter;

directorySearch1.PropertiesToLoad.Add("givenName");

//Not returning anything here. That's why searchResult1 is coming as

null.

searchResult1 = directorySearch1.FindOne();

directoryEntrySearch = searchResult1.GetDirectoryEntry();

This code is running fine in C# and out of Metastorm in JScript.net

Is this using any metastorm account for firing this query.

Can any budy help?

Thanks in advance.

Regards,

Agrawars

Forum: Designer

Folder on Folder 7.6 sr2

MetaWorker — Tue, 27 Jul 2010 13:22:15 GMT

Hi folks,

Had some headache using Folder on Folder, a concept I find useful in the right circumstances. I have this table storing lots of different folderids with I use to display some interesting data. Following the instructions from the help file, Folder on Folder kept on failing. Well, hurray for Jerome who noted that the column (as well as the caption) must be named eFolderID. Problem is, none of my columns is named eFolderID. What to do? If you stumble across this, simply type in "as eFolderID" after the definition for the first column:

Code:

dbo.myCustomTable.myCustomColumn as eFolderID

Did this on a MS 7.6 sr2.

Good luck!

Forum: Designer

eSSO_Web.js

sbeswick — Mon, 26 Jul 2010 15:47:46 GMT

Hello:

I was looking changing the eSSO_Web.js script so I could change the fields within the eUser table.

The only thing I want to do is edit the following line in eSSO_Web.js:
var sql = "SELECT eUserName FROM eUser WHERE UPPER(eDirectoryTree) = UPPER('" + username + "')"

The main goal is to have a unique ID withing the eUserName field since the AD will reuse the SAM Account name after 45 days of someone leaving.

Forum: Metastorm BPM 9 Installation and Configuration

Sending the form I want to open in link

ColleenCal — Fri, 23 Jul 2010 20:18:46 GMT

Hello everyone

I have a link to a folder that I send an email. Based upon the stage that the folder is in, the appropriate form opens up. Understood.
Can I override that default form by putting a parameter referencing another form in the link?

My link looks something like this:
http://octans/MetastormSSO/eexternalform.asp?service=Metastorm%20BPM%20Server&redirect=http://octans/Metastorm/eFolder.aspx?FolderID=0000000000000000000000000022116%2526Client=External

Forum: Designer

Metastorm 7.6 with SQL Server 2008?

JeffreyB — Fri, 23 Jul 2010 15:05:41 GMT

Is anynone using Metastorm 7.6 with SQL Server 2008 successfully?
(We are currenty using SQL Server 2005 and plan to move to SQL Server 2008 and want to know if there are any problems with using SQL 2008 with Metastorm 7.6)
Thanks!

Forum: Installation

Moving servers to virtual machines

JeffreyB — Thur, 22 Jul 2010 19:30:58 GMT

Hi everyone,

We will be moving our web server and our database server to a virtual machine soon. Has anyone done this before? If so any tips, lessons learned etc would be greatly appreciated (especially since I have never done this before).

I have been given the following list as a guide of what needs to be done.

Install Metastorm on the new virtual machine
Restore back up of the database on the new virtual machine
Make ODBC connections and registry connections so that the engine can find the new location of the database

Does this look good or are there any steps missing?

Thanks!

Forum: Installation

Importing Data

jonmcwee — Thur, 22 Jul 2010 12:01:14 GMT

Hello all,

Quick question:

I have a table set up, for the purposes of this explanation, we will call it Table1. This table is accessed by x7 users. Information is processed and an outcome is generated to each field.

The question is that I want to import data from a CSV file into the table and then assign this data to users randomly.

What is the best way for this to be done?

Best,

Jon

Forum: Designer

Forms fail to load

Jerome — Thur, 22 Jul 2010 05:05:49 GMT

I had an incident where all action forms failed to load.
Reboot, no change.
Redeploy solutions, no change.
I deleted all temporary files, no change.
I turned on script debugging and the error was 'Type' is undefined, and then more similar errors.
I tried firefox - it worked fine.
I went back to IE, deleted all temp files AND un-checked the box 'Preserve favourites website data' and it was OK.
This is IE 8

Just thought I'd share in case others have the same issue in the future.

Forum: Metastorm BPM 9 Clients