This content has been marked as final. Show 2 replies
It could be possible that the package which is being executed to do the transformation is throwing exception for certain data. Try to execute the package seperately by passing the value for the data that has errored out. Seems like package is throwing some exception which is not being caught in the code.
Let me know if that helps.
"oracle.oai.agent.server.transform.database.DBTransformationException: PLSQLTransformation.transform: Transformation failed" in the log file means this error occured at agent level /application level.So,using metadata interconnect is not able to convert input data in to application view.
Error is transformation failed.So reason can be
--> any unhandled exceptions
--> mismatch in data type of fields/parameters used.
--> mis match in number of field/elements in input data.
Transformation failed indicates interconnect not able to transform input data in to sepcified format in Application view or common view.
As you mentioned,this is happening only with few records.
--> check if failed records are to test negative cases.
--> check if failed records have all values expected as mandatory for transformation.
--> check if failed records have the data with expected datatypes(For eg field a is defined as number and field a in record have value 'abc' instea dof 123).
Hope this information helps you.