Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Register Latest Topics
 
 
 


Reply
  Author   Comment  
kenyon

Avatar / Picture

Member
Registered:
Posts: 12
Reply with quote  #1 
I've inherited a process that's now throwing an ambiguous error while working within a form.  The full error is:

Message from webpage
An error occurred in this process. Please report the problem to your administrator.

I've checked eLog but nothing appears there.

It pops up while working with Grids on a form after clicking an "add" button.  The button calls a stored procedure to update a record which, in isolation, works fine.

It seems like it might have something to do with refreshing the grids on the form after the update.

Are there any "usual suspects" for this error that I can investigate more closely?
0
kenyon

Avatar / Picture

Member
Registered:
Posts: 12
Reply with quote  #2 
I've been able to narrow it down to a code activity that tries to execute a store procedure using Mstm.SelectSql.

Code:

Mstm.SelectSql
(
  new SQLServer(), "exec [dbo].[Hzd_Take_PNUFI_Snapshot_new]"
);


I've completely emptied the store procedure but it still throws an error.  This is about as basic as I can get it without removing the reference all together.

I tried the below and it did not throw an error.

Code:

Mstm.SelectSql
(
  new SQLServer(), "select 'hello'"
);


Do you normally need to set execute rights on stored procedures called within Metastorm?
0
kenyon

Avatar / Picture

Member
Registered:
Posts: 12
Reply with quote  #3 
Okay I think I have it sorted now.

Being unfamiliar with Mstm.SelectSql, I didn't realise "new SQLServer" was actually a custom connection, not the default Metastorm database.  And it was pointing to our production database.

There was an issue in the stored procedure but any changes I made and tested in development were irrelevant as it was always pointing at production.

Another historic case of terrible ambiguous error messages.
0
jwoodhull

Member
Registered:
Posts: 10
Reply with quote  #4 
kenyon, glad you were able to resolve this issue on your own.  In the future, you may want to try using SQL Profiler or Oracle equivalent (if that's your DB) to check what is actually executing on the database whenever you are debugging a database-based issue.  Keep in mind that Metastorm intentionally keeps the user messages vague as a security measure.  I would also seriously question why your development environment is able to connect to the Production database at all.  Based on your description of the issue, I am guessing you are running at a minimum MBPM v9, which should give you the ability to define your database connections in the Metastorm Administration site so that you never run into a "is this DEV or PROD?" situation.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!