Jump to content


CurtisZ

Member Since 23 Sep 2008
Offline Last Active Jan 20 2015 12:26 AM
-----

Posts I've Made

In Topic: PROIV

16 January 2015 - 11:46 PM

Well, firstly, have you had a chance to explore the PROIV Control Panel? Is a Gateway setup?

 

The Gateway is the listener for the Task call. It has the port that would be invoked. Topic 250007 in the help has info on the various Gateway settings. I may be able to help with a few, but I'm sure there are differences between Windows and UNIX.

 

We also use a transparent login for our Task calls. We usually use the p4task.exe utility that comes with PROIV to invoke our Task execution or we use PROIV web services. I am unaware if there is a UNIX equivalent to the p4task, however there are some other resources available to help build an app to execute a Task.

 

Let me know how much of the process needs to be worked through, and I can try and be more or less detailed in a full explanation.

 

Thanks!

 

Curtis


In Topic: PROIV

16 January 2015 - 03:54 PM

I have authored various nightly scheduled jobs for PROIV 7.1.x, however we are Windows based, and our client's utilize the standard Windows scheduler. I am familiar with the process of utilizing PROIV Tasks and how the PROIV Gateway interacts, though. Let me know if you think I can be helpful, and I may try and at least help in that regard. Possibly understanding how the Tasks and Gateway work together may help in setting up the call and scheduling it via CRON.


In Topic: capture crash on windows server

26 June 2014 - 02:58 PM

I typically write my bat file to output to a logfile. Whenever there are issues, I can see when things ran, and how long it ran. I can also see what was returned by PROIV.

ECHO PROCESS STARTED %date% %time%>>logfile.txt
P4TASK /task:<task_info> /oper:<operator_credentials> /codiv:<company_info> /params:<parameters> >> logfile.txt
ECHO PROCESS COMPLETE %date% %time%>>logfile.txt

This is a simple example of how I usually put together the piece of my bat file that executes the task.

 

Here is an example logfile:

 

PROCESS STARTED Tue 05/06/2014 16:10:07.07
p4ExecTask returned: # out params 1, length 15, # out sysvars 0, length 0:
  recordCount=469
PROCESS COMPLETE Tue 05/06/2014 16:10:09.91
 
This might help as far as something that could be implemented. I'm not stating I'm a batch file expert, so if someone has any ways to write this better, please chime in. Without any more information about the given process, this is really the only advice I have.

In Topic: Connecting to Multiple SQL DB's?

13 February 2014 - 04:07 PM

One option:

 

Setup a linked server via SQL. Then in embedded SQL statement you can refer to the table by server.database.owner.table in your query. I just ran a quick test on V7 and it looked to work selecting data from another server into a shell of a file definition.


In Topic: Computer Scientist/Glovia/Enterprise Asset Mgmt Position at Lawrence L

27 August 2010 - 06:13 PM

You had me at laser!

:-"

Maybe I should apply?!?