Who's On?

	Membership:
	Latest: Zac Shields
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5210

	People Online:
	Visitors: 548
	Members: 0
	Total: 548

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

PERSACTION direct manual insert

2 Replies

0 Subscribed to this topic

17 Subscribed to this forum

Sort:

Author

Messages

EBassett

Basic Member

Posts: 6

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

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

EBassett

Basic Member

Posts: 6

11/5/2012 8:53 PM

Thanks, I think will help.