I have a couple of Direct SQL calls to update a Date value in another component from Remedy. I also added a Commit at the end of the call. Eg:

BEGIN EXP_ORDER.CREATE_ORDER_DATES('Rajesh-save/update Billing Start Date -16/09/2009 13:56:23','Rajesh',REMDATEINT_TO_ORADATE(1252882800),'7','','','878135',''); COMMIT; END;

This invokes a procedure at the other component's end and then updates the date in one of their tables.

However after a day or 2 when we try to retrieve the same date again from the component's table it is empty.

Any idea why this happening? Have you come a/c this issue before? This does not happen for all the orders.

Thanks,
Rajesh

Hi,

This issue is resolved. The users were logged in using the Preference server option. I asked them to use the IP address of the server instead in the Accounts Information box. Once this was done the Direct SQL worked fine.

Any reason why the Preference server sometimes results in this issue? Please comment.

Thanks,
Rajesh