Microsoft Dynamics GP Workflow Installation

Last post 03-25-2009 2:35 PM by itjwright. 8 replies.
Page 1 of 1 (9 items)
Sort Posts: Previous Next
  • 02-24-2009 4:03 PM

    • SLIU
    • Top 200 Contributor
    • Joined on 11-17-2008
    • Posts 21

    Microsoft Dynamics GP Workflow Installation

    I have installed all the pre-requisite for installing Workflow for GP 10.0. Now I have - DOMAIN SERVER (containing AD) - WEB SERVER > Microsoft SQL 2005  > Microsoft Dynamics GP 10.0 > MOSS 2007 > dot net framework 2.0 > Microsoft GP web services > KB932394 (patch for workflow foudation) ALL ARE INSTALLED USING DOMAIN USER But when I started installing workflow, it is giving me the following error "Product: Microsoft Dynamics GP Workflow -- C:\Program Files\Microsoft Dynamics\Workflow\Microsoft.Dynamics.Workflow.InstallSystemSecurityMetadata.exe returned '-532459699'" could any one come across or solve this error, reply me urgently. Thanks

  • 02-26-2009 1:28 PM In reply to

    Re: Microsoft Dynamics GP Workflow Installation

    Hi, there are a number of reasons why this could be happening. First it would be best to rule out MOSS...reinstall MOSS using a domain user account as you did already and select Advanced and Complete options when installing. Web services and workflow also need to be installed using a domain user account instead of a local user account which I think you did from your post abovve anyway.

    How many times have you installed workflow? It might also have been installed and uninstalled and the folders are still there. If it was installed before, then this new install could have problems. There are sql scripts for removing install records somewhere in partner / customer source. Do you have access? If not, I can search for you.

    You could also try removing terminal services from application mode on the server running IIS, if installed.

    Other than that I don't know. Hopefully the above will point you in the right direction or spark some ideas from others in the community. Let us know how you get on.

    Ian Stewart
    International Support Services
    Genesys Financial Systems (Ireland)
    Microsoft Gold Certified Partner
    www.Genesys.ie
    http://dynamicsgp.wordpress.com/
  • 03-09-2009 7:12 PM In reply to

    • SLIU
    • Top 200 Contributor
    • Joined on 11-17-2008
    • Posts 21

    Re: Re: Microsoft Dynamics GP Workflow Installation

    thanks for your reply. Here are the steps that i went through to solve my problem:

    SYMPTOMS

    When you try to install Workflow for Microsoft Dynamics GP 10.0, you receive the following error message:

    C:\Program Files\Microsoft Dynamics\Workflow\Microsoft.Dynamics.Workflow.InstallSystemSecurityMetadata.exe returned -532459699

    Cause 1

    The installation of Microsoft Office SharePoint Server 2007 was not done as a complete installation. To resolve this problem, see Resolution 1.

    Cause 2

    SharePoint Server 2007, Web Services for Microsoft Dynamics GP 10.0, or Workflow for Microsoft Dynamics GP 10.0 was installed by using a local user account instead of a domain user account. To resolve this problem, see Resolution 2.

    Cause 3

    Terminal Services is running in Application Mode on the server that is running Internet Information Services (IIS). To resolve this problem, see Resolution 3.

    Cause 4

    The WSInstallStatus table contains a record that indicates that Workflow is already installed. To resolve this problem, see Resolution 4.

    Cause 5

    Workflow was previously installed and then uninstalled, and the workflow feature folders exist. To resolve this problem, see Resolution 5.

    RESOLUTION

    Resolution 1

    Verify that a complete installation was performed for Microsoft Office SharePoint Server 2007. To do this, follow these steps:

    1. On the server that is running IIS, click Start, click Administrative Tools, and then click SharePoint 3.0 Central Administration.    
    2. Click the Operations tab.   
    3. In the Topology and Services area, click Services on Server.    
    4. If Web Server for medium server farms is selected, a complete installation was performed.  

    If a complete installation was not performed, remove and then reinstall SharePoint Server 2007. To do this, follow these steps:

    1. Remove Microsoft Office SharePoint Server 2007.   
    2. Install SharePoint Server 2007 as a complete installation.

    Note Select the Advanced option ,and then select the Complete option.    
    Install Workflow.

    Note You do not have to make any changes to Web Services. 

    Resolution 2

    • If SharePoint Server 2007 was installed by using a local user account, reinstall SharePoint Server 2007 and Workflow by using a domain user account.   
    • If Web Services was installed by using a local user account, reinstall Web Services and Workflow by using a domain user account.    
    • If only Workflow was installed by using a local user account, reinstall Workflow by using a domain user account.  

    Resolution 3

    Remove Terminal Services from Application Mode on the server that is running IIS. To do this, follow these steps: 

    1. Click Start, point to Control Panel, and then click Add or Remove Programs.    
    2. Click Add/Remove Windows Components.    
    3. In the Components area, click to clear the Terminal Server and Terminal Services Licensing check box.   
    4. Click Next, and then click Finish.

    Resolution 4

    1. Make sure that you have a backup of the DYNAMICS database.    
    2. To determine whether the WSInstallStatus table contains a record that indicates that Workflow is already installed, run the following script in SQL Server Management Studio.

    Select * from DYNAMICS..WSInstallStatus where InstallStep = '350DF9B1-F1A1-4859-BBD3-776021116F69' 

    1. If a record is returned, run the following script in SQL Server Management Studio to remove the record.

    Delete  DYNAMICS..WSInstallStatus where InstallStep = '350DF9B1-F1A1-4859-BBD3-776021116F69'

    Resolution 5

    1. Click Start, click Run, type cmd, and then click OK.
    2. Run the following commands from the location of the Stsadm.exe file:• stsadm -o deactivatefeature -name DynamicsApproval -url <DynamicsGPWorkflow URL> -force


    stsadm -o deactivatefeature -name DynamicsWorkflowForms -url <DynamicsGPWorkflow URL> -force
    stsadm -o deactivatefeature -name DynamicsWorkflow -url <DynamicsGPWorkflow URL> -force
    stsadm -o uninstallfeature -name DynamicsApproval -force
    stsadm -o uninstallfeature -name DynamicsWorkflowForms -force
    stsadm -o uninstallfeature -name DynamicsWorkflow -force

    Notes The following location is the default location of the Stsadm.exe file:

    C:\Program Files\Common files\Microsoft shared\Web server extensions\12\Bin

    Replace the <DynamicsGPWorkflow URL> placeholder with the path of the DynamicsGPWorkflow site collection. For example, replace the placeholder with the following path:

    http:// Server_name /Sites/DynamicsGPWorkflow

  • 03-10-2009 3:50 AM In reply to

    Re: Re: Re: Microsoft Dynamics GP Workflow Installation

    Hi,

    Did the above resolve your issue? Do you know the Techknowlge ID of the above?

    Which resolution worked / what was the issue?

    Best regards,

    Ian Stewart
    International Support Services
    Genesys Financial Systems (Ireland)
    Microsoft Gold Certified Partner
    www.Genesys.ie
    http://dynamicsgp.wordpress.com/
  • 03-11-2009 8:16 PM In reply to

    • SLIU
    • Top 200 Contributor
    • Joined on 11-17-2008
    • Posts 21

    Re: Re: Re: Re: Microsoft Dynamics GP Workflow Installation

    yes,  tried solution 2 and 3.

    but now my problem is I cant see the workflow history panel and nothing happens by clicking the "submit for approval" button.

    in GP10 even if I have actived the workflow function.

    I created a PO workflow for testing in the workflow administration site. I got the following error when I went into Purchase Order Approval Documents :

    "one or more field types are not installed properly. Go to the list settings page to delete these fields."

     any thoughts?

    Thanks.

  • 03-19-2009 1:52 PM In reply to

    Microsoft Dynamics GP Workflow Installation

    I am able to install, setup and configure my workflow but now when I create aPO and submitt for approval it bounces back with an error and asks me to resubmit it but again comes back

    Anybody have any idea, what is causing this error to come? 

     

  • 03-20-2009 3:42 AM In reply to

    Re: Microsoft Dynamics GP Workflow Installation

    what error message do you get?

    Ian.

    Ian Stewart
    International Support Services
    Genesys Financial Systems (Ireland)
    Microsoft Gold Certified Partner
    www.Genesys.ie
    http://dynamicsgp.wordpress.com/
  • 03-20-2009 9:13 AM In reply to

    Re: Re: Microsoft Dynamics GP Workflow Installation

    Hi Ian,

    Error Message " A WorkFlow error occurred on PO # ?????? . Please review the document and resubmit if necessary".

    also under events> Dynamics follwoing is the error being produced.

    Event Type: Error
    Event Source: Microsoft.Dynamics.Workflow
    Event Category: None
    Event ID: 0
    Date:  3/20/2009
    Time:  9:20:38 AM
    User:  N/A
    Computer: SP
    Description:
    Action:
    SubmitForApproval

    Current User LogOnName:
    CAS\sdadmin

    Input parameters:
    <RequestObjects>
    <ArrayOfBusinessObjectSubmissionInformation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
      <BusinessObjectSubmissionInformation>
        <WorkflowName>Dynamics GP Purchase Order Approval Workflow</WorkflowName>
        <OriginalDueDays xsi:nil="true" />
        <DueDays xsi:nil="true" />
        <Comment>PO 4005 3/20</Comment>
        <BusinessObjectKey>
          <KeyParts>
            <KeyPart xsi:type="KeyPartOfString">
              <Name>PoNumber</Name>
              <PartValue>004005</PartValue>
            </KeyPart>
          </KeyParts>
        </BusinessObjectKey>
      </BusinessObjectSubmissionInformation>
    </ArrayOfBusinessObjectSubmissionInformation>
    <CompanyKey xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.microsoft.com/dynamics/2006/01">
      <Id>1</Id>
    </CompanyKey></RequestObjects>

    Exception type:
    System.InvalidOperationException

    Exception message:
    The workflow did not start.

    Stack Trace:
       at Microsoft.Dynamics.Workflow.WorkflowManager.StartWorkflow(BusinessObjectSubmissionInformation submissionInformation, WorkflowAssociation wfAssoc, OrganizationKey organizationKey, Int32 itemId, User securityUser)
       at Microsoft.Dynamics.Workflow.WorkflowManager.SubmitForApproval(Collection`1 submissions, OrganizationKey organizationKey)


    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
      

     

  • 03-25-2009 2:35 PM In reply to

    Re: Re: Re: Microsoft Dynamics GP Workflow Installation

    I am getting this error, however none of the above appears to apply. 

    • I installed MOSS 2007 using the complete option (per the workflow install guide)
    • I installed webservices, moss and workflow using a domain user account with administrative rights to the machine
    • Terminal Services/Terminal Services Licensing is not installed on the server
    • The servers being used for this process are new and have never had workflow installed before

    Any thoughts as to what I should do now?

Page 1 of 1 (9 items)