Hi - We are experiencing intermittent issues with Process Flow Server - we have a simple SQL ETL flow which normally takes 2-3 minutes to run - however at some points in the day it can take 1.5 hours to run and throws an error in our log. Our pfrmi.log shows the following error message: (DB Return Code = 0) [Jun 11, 2010 9:51:36 AM] User not found in Lawson. Resource not found com.lawson.lawrm.api.RMDirectoryException: Resource not found I'm thinking this is an issue with LDAP con...

Does anyone have an example of using E4X in the xml node I can't find any examples in the documentation. This would be for building an XML document. Any pointers greatly appreciated. thanks, Steve

Does anyone have an example of how to build the WebRun node to process an 'approve' action  I am unsure how to code the 'Web Program' node. Is it bpm/inbasket or inbasket/inbasket.js

Hello everyone! I just discovered something out of sheer curiosity which some of you may already know, but I'm betting many do not.  I wanted to share.  If you are on/using/implementing LTM and ProcessFlow/Process Automation (PFPA), this will make more sense. We are implementing Lawson HR - HRM & LTM together (not all the applications, but some now and some later).  This has given me a great, mostly fun, sometimes frustrating challenge of locating data I see in a Rich Client/Smart Office f...

Friends. I have developed a process flow that pulls the comments using getattachrec.exe via the WebRun node for an email that we send out when ACH's are processed via our AP160. The flow works fine, no errors (trust me on this). We pull data from APPAYMENT and then build a html email. A part of that email include comments that were inputted in for the ACH. The call looks as attached. For most ACH's we do, works fine. But for a couple, we received the following error today: H...

Has anyone been able to call a SQL stored procedure using process flow  Is this possible  I tried calling a SQL stored procedure using the SQL QUERY and SQL UPDATE nodes, but got an error 'invalid SQL statement.'   I would prefer to call one stored procedure in process flow than use multiple SQL UPDATE nodes to update multiple tables.

I need to strip a variable of certain characters (& / \ etc).  I'm using the replace method like this wname=qryPL.replace('&','') wname=wname.replace('','') wname=wname.replace('/','') The only replacement that works is whichever character I place in the first_ line.  Once I'm acting on the variable wname it doesnt work.  I can change the characters to be replaced around and only the one in the first line works. Is there something different I need when acting on the vairiable

Does anybody know what the Return Code would be from an AGS call HR11 Change for a successful 'Change Complete - Continue' I'm making a flow which will be putting new employee's e-mail addresses into Lawson, but need to know whether the change was successful or not and make a branch in the flow accordingly. The simplest way that I can see to do that would be a branch where, if the Return Code = whatever the return code is for a successful change do x, otherwise do y. Thanks.

Does anyone have information they can share on modify the index.htm file for mobile inbasket.  Specifically, is there a way to add the work category to the inbasket line which already includes the requisition number.  Also is there a way to add accounting information to the line detail without the need to drill.  Any insight would be helpful.  The documentation states that the htm file was commented to help in modifications but that just isn't the case.

hi all Trying to find the original pdf file which has some details about how to do this. Does anyone have a copy or can send some instructions on how to do this- as i would like to try and implement a similar system especially as we have just implemented EDI processing to run every 15 mins (3 separate jobs) and would like to track any errors immediately Regards Saurabh

Is there a Work Instruction document that most developers follow in order to release a process flow into I am knew to Lawson PF but I can see using a mix method exporting and importing LOGAN tables and manually setting  the service or triggers  in Production. Also, my understanding is that rngdbdump/importdb exports the entire LOGAN tables unless parameters can be used for especific flows.   Please advice on how to release process flows into production or point me to the right direction. Th...

I have a TAB delimited file I am trying to parse but it is ignoring the tabs. The outer Data Iterator reads each line and inside this loop, I have the Line Data Iterator 'DLINE' with the setting 'Parse By = Delimiter String'. For the delimiter value, I am using the variable vTAB='\t'. The value of 'DLine_outputData1' is the same as the entire line which indicates that it is ignoring the TABs. I opened the input file in note and I can see the tabs in each line. How should I setup Data Iterators...

We are in the midst of doing our upgrade from 8.0.3 to 9.0. We are on the AS400 platform. We have several process flows where we use the MsgBuilder node to build up a string variable with a list of PO's or Req's or whatever it maybe that the flow is iterating through. At the end of the flow we use the MsgBuilder variable in an email node to notify someone of all the PO's or Req's that were processed. In version 9 now we are getting warning errors that these MsgBuilder variables exceed 250 c...

I'm sort of new to using the XML functionality in Process Flow Integrator. I'm looking to write an interface that reads data out of an .xml file. I've got an .xml file that seems to be formatted correctly, but I can't figure out how to setup the xml node to read the file. It seems to me that you can only write xml files with this node...is that correct If I enter the XML Schema file it can read that ok but not the actual xml file that contains the records I want to interface. Any suggestions on...

Hi Guru, Is there any way to get the current work unit number within the flow during run time Thanks,

How can I configure the ScanFile.cfg configuration file in order to run and execute the process flow I have assigned values to the parameters in the CFG file as shown below and then recycled the pf services. It is not calling the process flow because the work unit did not increment and the dropped txt file still in the same Unix directory. We prefer setting up the parameters in the config file rather than executing the ScanFileClient from the command line. Also, how can I setup in the config fi...

Does anyone know of a way to display the ActivityName in the email node  We have 'failure' emails that are sent out and need to be researched.  We would like to include the ActivityName in the footer for the actual email node that was sent.  The ActivityName in each email would make troubleshooting much faster to find where the email came from in the flow.

Hi, On a form with pf service trigger set up, there is a Category Value field listed on the same page where the service name is defined. What is the usage of that field It looks like it is designed so that we can pass in a category value when a work unit is generated as result of triggering. However, it seems only taking ONE constant value. Is there a way to enter a variable name and pass in a category value during runtime based on some kind of conditions If it is not the way I thoug...

Hello, What I am trying to do is do a transaction call to PO20 to inquire on a PO.  Next I want to write out an XML file using the data returned in the PO20 inquire.  I know that the transaction call returns an XML string, but I am unsure how to reference that data in the next node.  How can I do this Thanks.

Hi All, When i am access from SQL node from PFI,i am getting following error, SQLException: JDBC Driver not found: com.microsoft.jdbc.sqlserver.SQLServerDriver Please add jdbc driver to ProcessFlow Server classpath. Even configured in desigenr.bat but  still i am facing same problem. Please help me .

Hello, When I attempt to run a flow not on server that contains a SQL Query node, I get this message:   Flows that use  SQL Query nodes must be run on the server.   Please use the 'Run on Server' option. I'm in PFI Designer 9.0.1.6.  Tried against two different servers. From the documentation and other posts here it seems that I should be able to run locally but I found nothing searching for this message in the KB.  I copied my jdbc driver .jar file to C:\Program Files\Lawson Softwa...

I am using processflow to create a peope resource using the Resource Update node when I receive the following error:           AddResource error: Unable to store LM1159975 object, creation failed. Original Exception: Could not create object of type People AddResource error details: com.lawson.lawsec.external.ExternalException:Unable to store LM1159975 object, creation failed. Original Exception: Could not create object of type People Error while executing ResourceUpdate activity com.lawso...

Hi, When trying to connect to a remote windows server using ScanFileClient, it needs the port the tool is going to talk to. What is the default port of a windows server the scanfile client can talk to that I can specify in my .cfg file Thanks,

For the flow I am attempting to make, I have to get both the employee's information and their supervisor's information, which means I need to have two instances of the Employee table, one for Emp and one for Supervisor, linking across them to get the Supervisor employee info. I have my SQL query built and I know that it works. My problem comes in attempting to assign the values. The way it is setup, it means I have to referene the table names as there are duplicate field names which would res...

I have an odd problem with a process flow I have created to edit RM attributes for MSS access.  I have a resource query that once it finds the RM account it will add a bookmark group (GROUP attribute) as well as a security role (ROLE attribute) to the account.  After a few minutes, the group change takes effect and the bookmarks assigned to the group are visible to the user.  However, the security doesn't seem to be applied. When the RM account is inspected in the resource manager we can s...