WorkflowGen.com | Knowledge Base | Documentation | Downloads | Support | RSS

Display KB articles by Category, by Month

Entries from June 1, 2008 - July 1, 2008

RemoteLaunch Security options

Posted on Sunday, June 29, 2008 at 14:29 by Registered CommenterWFG Team in | CommentsPost a Comment

There are 2 possible security cases that could be used in RemoteLaunch.

Case 1: The connected user is a known user in WorkflowGen

  • Use the .NET DefaultCredentials
  • The user is requester of the process.


Case 2: The connected user is not a known user in WorkflowGen

  • Use the .NET NetworkCredentials or Impersonification option throught the web.config (E.g. WorkflowGenUsername)
  • The WorkflowGenUsername is requester of the process.

Note: The connected user is the user who is executing the remote launch script.

WorkflowGen installation for Oracle fails to create the database structure.

Posted on Sunday, June 22, 2008 at 14:21 by Registered CommenterWFG Team in | CommentsPost a Comment

Description

One of the common errors that occurs during the WorkflowGen installation for Oracle is due to unsupported character set settings of the database instance. WorkflowGen is a multi-lingual software application which requires storage in UTF-8 encoding.

Solution

The database must use CHARACTER SET and NATIONAL CHARACTER SET in UTF8. If the character sets could not be changed then a new database instance is required. Use the following query to verify the character sets in the Oracle SQL Command Line tool.

When the tablespace is created, you should specify the Database and National Character Set to UTF-8.

(Ordinary) character set
The (ordinary) character set for a database can be determined with:
select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET';

National character set
The national character set for a database can be determined with:
select value from nls_database_parameters where parameter = 'NLS_NCHAR_CHARACTERSET';


Reference

WorkflowGen Technical Guide - Chapter 3.1.2 Installation on Oracle 9i / 10g database.

http://community.workflowgen.com/downloads/documentation

 

Sporadic SQL exception errors caused by Anti-Virus Software

Posted on Sunday, June 15, 2008 at 15:15 by Registered CommenterWFG Team in | CommentsPost a Comment

Issue

If a Symantec Anti-Virus such as Symantec Endpoint Protection is installed and running on the WorkflowGen web server, you may experience sporadic SQL exception errors such as those listed below:

* Incorrect syntax near ''.

* Must declare the scalar variable "@USERNAME".

Workaround

Disable Symantec anti-virus for DLL files or restrict the scan from verifying the WorkflowGen bin folders.

Data menu is showing up blank when clicked from an IE browser

Posted on Sunday, June 8, 2008 at 14:50 by Registered CommenterWFG Team in , | CommentsPost a Comment

Problem

The Data menu in an action running mode is showing a blank pop up dialog when clicked from an IE browser.

Explanation

If your IIS web server has the HTTP compression setting turned ON and users attempts to open the data list from the running action header menu in IE, a blank windows dialog will be displayed.

The data list uses client-side dynamic HTML functionality to download and display compressed information from the IIS web server which appears to have compatibility issues as indicated by Microsoft.

Workaround

The solution is to turn off compression on IIS for maximum compatibility. This applies to IIS version 6.0 and higher. Prior versions do not support HTTP Compression.

http://support.microsoft.com/kb/308168

References

BUG: When You Use Behaviors with Compressed Data in Internet Explorer, the data may not decompress

http://support.microsoft.com/kb/328498

Enabling/Disabling HTTP Compression:

http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/502ef631-3695-4616-b268-cbe7cf1351ce.mspx?mfr=true

Directory synchronization takes several hours and I receive a "timeout" error in IIS, how can I resolve this?

Posted on Sunday, June 1, 2008 at 10:00 by Registered CommenterWFG Team in | CommentsPost a Comment

Problem

Depending on the speed of your web server hardware, your database server, and the number of users and groups you want to synchronize with WorkflowGen, Directory Synchronization can take from a few minutes to several hours.

By default, the IIS .Net "State Management" is set up to have a 20 minute session timeout.  This means any web pages that run without completion for over 20 minutes will be terminated - including synchronizations that may require more than 20 minutes.

Solution

You can increase the session timeout at the IIS level for WorkflowGen by doing the following:

    1. Open IIS
    2. Expand the WorkflowGen web site
    3. Right-click on the "wfgen" application and select "Properties"
    4. Select the "ASP.NET" tab and click on "Edit Configuration"
    5. Select the "State Management" tab and increase the "Session timeout (minutes)" to a value greater than the amount of time required to synchronize.
    6. Select "OK" until you return to the main IIS page.