Prev
Next
Forums S3 Customization/Development

PERSACTION direct manual insert

Sort:
You are not authorized to post a reply.
Author
Messages
EBassett
Basic Member
Posts: 6
Basic Member
11/5/2012 4:31 PM
    I have some user fields that I want to update periodically. I wan to build a project using Sql Server integration Services that will check a few things determin the value of the user field then use the persaction to update it. At first I tried just setting the columns that I thought it would need but, got cannot insert null in most of the columns, so I am inserting a value for all fields in the table. But when I do so I get the following error.

    Error: 0xC0024104 at Execute SQL Task: The Execute method on the task returned error code 0x80131509 (This type has a ComVisible(false) parent in its hierarchy, therefore QueryInterface calls for IDispatch or class interfaces are disallowed.). The Execute method must succeed, and indicate the result using an "out" parameter.

    Has anyone found a way to create persaction records in an automated way? Is there a PA5xx file I can create to load them? I do not want to have to use add-ins or much manual work to create these records each week.

    Any assistance is appreciated.

    Thank you.

    Woozy
    Veteran Member
    Posts: 709
    Veteran Member
    11/5/2012 6:06 PM
      We don't do this through SSIS, but we do it all the time with other tools, like pflow. 

      You will need to do an AGS call against PA52.  There is a document in the Infor Documentation Library named "IOS Application Program Interfaces" that provides quite a bit of information about AGS calls, though it is a little short on details.  There are also a number of articles in the KG relating to this issue - search for "PA52 Add-Ins" and you should find lots of resources.

      Here is a thread that addresses may provide more help:  https://www.lawsonguru.co...te-new-value-fields/

      There are a number of tricks to the PA Searching the InforGuru forums for "PA52" is another good place to look.

      Good Luck!

      Kelly
      Kelly Meade
      J. R. Simplot Company
      Boise, ID
      EBassett
      Basic Member
      Posts: 6
      Basic Member
      11/5/2012 8:53 PM
        Thanks, I think will help.
        You are not authorized to post a reply.