Symantec IGA

i created one table in ostore for storing userid and fullname values through PX

here is the error i was facing when iam trying to do

Hi Vmani,

This is normal that such a prepared SQL statement fails when testing.
The interactive test cannot perform dynamic statements but only static ones.
Because the prepared statement is built only during the task execution with the argument values coming at this time.

Regards,

Philippe.

When using the "test" button, put in real values instead of the variables

E.g. replace "{'setuid'}" with "mytestuid1" (without the double-quotes).

yes it is working , i was able to add data into my table

how can I get those inserted records,how i need to configure in PX 

Hi Vmani,

The question mark works fine into SQL queries dealing with the respective passed argument(s).
I performed a quick test in data element of my PX (only one argument).
In order a query1 is as following:
SELECT [id] FROM [Issues].[dbo].[tblUsers] WHERE [loginid] = ?;
with argument as: selfreguser.

And a query2 is as following:
SELECT [loginid] FROM [Issues].[dbo].[tblUsers] WHERE [id] = ?;
with argument as: {'query1'}

The value returned by my query1 is the [id] passed to the query2

Into the action rules I have the following warning message:
GUIPH01 **** : {'query2'}

The server log show:

14:05:00,698 WARN [ims.policyxpress.userlog] (Thread-207 (HornetQ-client-global-threads-562153832)) [EVENT:AFTER:ModifyUserEvent] GUIPH01 **** : selfreguser

Please review the doc and if you still experience issues writing/running your PX then open a ticket with CA Support.

Best Regards,

Philippe.