This content has been marked as final. Show 5 replies
You have to create the mapping again for this error.
Do you changes the existing mapping.
or Create the new Mapping?
Many Internal errors disappear if you:
1) Close and restart OWB Design Client.
2) If that doesn't work, try stopping and restarting OWB Repository DB.
I removed the pre mapping process which calls the stored procedure and the mapping generated and executes fine. The minute I put back the premapping process. I also tried transformation operator to call the stored procedure and I am getting the error.
For sure it has to do with the call to the stored procedure.
I had the same problem, trying to execute a procedure in a mapping, the solution I found (I think there is a bug here in windowing, I was told by expert) is to put your procedure in a workflow and then your problems are gone. Since I can not post images,
In OWB : worflow: start -> «your proc» -> «your mapping» -> end_Success or else...
Hope that helps
I created a very simple mapping with a sequence operator and a output mapping parameter. I connected the nextvalk to the output parameter. when I generate I am getting code cannot be generated.
Can this be done at all. basically I am trying to get the nextval of a database sequence and use it for all my records in my mapping.