Stored procedure fails

A forum for User Initated & Scheduled Workflows
sdmeyer
Posts: 2
Joined: Wed Mar 01, 2017 12:42 pm
Deltek Vision Version: 7.0
Number of Employees: 250
Company Position: Automation Specialist
Number of Offices: 0
Year Vision Installed: 1999

Stored procedure fails

Postby sdmeyer » Wed Mar 01, 2017 12:50 pm

I have created a stored procedure in SQL to run a program that creates project folders. When I run it from the SQL management console, it all works great and will create the folders. When I try to run it in a User Initiated Workflow it fails. I see no error message when it runs. In the SP code I need to pass a variable of the WBS1, so in my UIW I pass it what I think is the WBS1 but it does not create the folders. In the SQL Management Console, I log in as the administrator, In Vision I have access to create SP Actions.

aadilnaeem
Posts: 16
Joined: Mon Jun 06, 2016 9:21 pm
Brief Company Description: antechsol

email: adil@antechsol.com
Deltek Vision Version: 7.0
Number of Employees: 0
Number of Offices: 0
Year Vision Installed: 2009

Re: Stored procedure fails

Postby aadilnaeem » Tue Mar 07, 2017 1:49 am

Hi

This seems to be permission issues. I have done the same long back ago (creating a project folder through stored procedure)

Try to run the SP from workflow without passing parrametter and check if it runs fine and then investigate with parrameter

Regards

sdmeyer
Posts: 2
Joined: Wed Mar 01, 2017 12:42 pm
Deltek Vision Version: 7.0
Number of Employees: 250
Company Position: Automation Specialist
Number of Offices: 0
Year Vision Installed: 1999

Re: Stored procedure fails

Postby sdmeyer » Thu Mar 09, 2017 9:46 am

Turns out when Vision creates a project (WBS1), it take a few seconds to save to SQL. By putting a 30 second wait in my code, everything works great now.

aadilnaeem
Posts: 16
Joined: Mon Jun 06, 2016 9:21 pm
Brief Company Description: antechsol

email: adil@antechsol.com
Deltek Vision Version: 7.0
Number of Employees: 0
Number of Offices: 0
Year Vision Installed: 2009

Re: Stored procedure fails

Postby aadilnaeem » Thu Mar 09, 2017 12:16 pm

It also depends uppn when and which sequence you are calling this workflow becuase first Vision creates a project and once project is created then this (WBS1) can be passed as a parrametter to other workflow.

I suggest to put this workflow as a last to execute


Return to “User Initiated & Scheduled Workflows”

Who is online

Users browsing this forum: No registered users and 2 guests