Installing Workflow Solution 7.0

This issue has been solved. See solution.
phiestand's picture

Hello Everyone

Recently I tried to install workflow solution 7 on my notification server for testing environment. The problem was after the std. installation procedures I couldn't open process manager. It always stopped with following error:

imagebrowser image
During the installation I checked database connection succesfully. The Designer works great just this connection won't work. Has anyone an idea, what I can do to solve this problem?

Tech-O's picture

we had that same problems

 Did you have any errors on the install? maybe with the analysis database? is the SQL off-box ?

You may want to try changing the port the process manager is running under and setup AD authenication during the install

phiestand's picture

questions

I didn't had any errors on install and the analysis database wasn't installed. The SQL is off-box.

Where do you want to change the port? I saw on the settings two areas where I can change this option.

1. Under Server Details the connection port for accessing through the process manager. With actual value 80

2. Under Server Details => Server Extensions => Server Port Number with actual value 11434

 imagebrowser image

Which port do you want to change?

Thanks for answers.

reecardo's picture

Just curious... can you

Just curious... can you actually hit the service http://Altiris02/ProcessManager/Userman/Userman.asmx with the admin@logicbase.com/admin login in a browser session? Also, can you verify that your task tray tool is in fact pointing to that Altiris02 box (and not some other box like (local))?

phiestand's picture

Curious part 2

With your changes I couldn't reach the Userman.asmx page. Following the settings I changed:

imagebrowser image

I also add the Event Viewer error:
-----------------------------------------------------------------------------

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 02.09.2009 16:29:30
Event time (UTC): 02.09.2009 14:29:30
Event ID: 750fbe4cf1794e77a44195c97b687e9e
Event sequence: 2
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/1/ROOT/ProcessManager-1-128963753671463448
    Trust level: Full
    Application Virtual Path: /ProcessManager
    Application Path: C:\Program Files\Altiris\Workflow Designer\Ensemble\
    Machine name: ALTIRIS02
 
Process information:
    Process ID: 1868
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: TypeInitializationException
    Exception message: The type initializer for 'LogicBase.Ensemble.Global' threw an exception.
 
Request information:
    Request path: /ProcessManager/Userman/Userman.asmx
    User host address: 172.16.100.25
    User: 
    Is authenticated: False
    Authentication Type: 
    Thread account name: NT AUTHORITY\NETWORK SERVICE
 
Thread information:
    Thread ID: 1
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    at LogicBase.Ensemble.Global..ctor()
   at ASP.global_asax..ctor()
 
 
Custom event details:
 
For more information, see Help and Support Center at
-----------------------------------------------------------------------------

Do have any other ideas?

Thanks for answers.

stuper's picture

Phiestand, where did you

Phiestand, where did you install Process Manager? Local or Altiris02? It sounds like you have off-box SQL but you ran the installer locally...

phiestand's picture

Answeres

The Process Manager is installed on Altiris02 but the SQL Server is on a different server. Can the process manager only run on the SQL Server?
On the Installation I didn't saw any connection problems between Altiris02 (Workflow Server) and SQL01 (Database Server).

For explanations:

In my test environment I've got 5 Servers

1. DC with DNS / DHCP etc.
2. Altiris01 with Altiris Version 6.x
3. Altiris02 with Workflow Solution
4. Altiris03 with Altiris Version 7.0
5. SQL01 with all Databases

Now I want to run Workflow Solution on Altiris02 with the database installed in SQL01.

Do you see any problems with this configuration?

Thanks for answers.

phiestand's picture

Solution for problems with connection/login to process manager

Solution

Found the Solution:

The Problem was with the std installation of Workflow Solution. Under the ASP.NET Tab in IIS. Workflow Solution configured a wrong ASP.NET Connection string. It always wanted to find a SQLEXPRESS Server which didn't exists.

imagebrowser image

I changed the connection string to the right server. After this action I could found all necessary files but the service always stopped when I tried to login in the Process Manager.

After searching through the event logs a found this log

imagebrowser image

And with a little bit help from eventid.net a found the right solution

From a newsgroup post: "Verify if your user in the Windows local group IIS_WPG. Any account used for an app pool has to be a member of this group."

So I changed the user which starts the DefaultAppPool from network service to Altiris Service Account and added the account to the local group IIS_WPG.

imagebrowser image

imagebrowser image

After all this I could successfully connect to the process manager.

Thanks for your time.

Tech-O's picture

nice, wish the install was better

 I'm currently having problems with getting the Cube reporting to work .. WF7 is running but now we have the reporting to find a solution . i hope that the SD7 documentation will help with this .. Calling support is worthless effort .. I hope they drop a ton of documentation this Friday on the install of SD7