Error:The job failed. Unable to determine if the owner (ABCIndia\Subhash.subramanyam) of job ssma_oracle data migration package
Tuesday, June 22, 2010 9:28 AM
After synchronizing the database, I tried transferring data from orcle to Sql Server using "Transfer Jobs" option but got an error pasted on Title. I don't know why. If any one of you have already came across this error earlier , kindly enlighten and share the work around.
thanks in advance
Tuesday, June 22, 2010 9:46 AM
Double click the job that is failing in Enterprise Manager. Set the "owner" box to SA and try run it again, if you need aditional information check in the below link
Wednesday, June 23, 2010 5:26 AMI'd like to share my workaround. Open Services.Msc and find the Sql Server Agent Service and Double click or open the properties. Under Log On tab enter in the account credentials having admin privileges. Then restart the Service. I understand that this is related Permission issue.
- Marked As Answer by Keshav RamaraoMicrosoft Employee Friday, June 25, 2010 10:10 PM
Wednesday, June 23, 2010 5:06 PM
Your analysis is spot on, it is a permissions issue.
SSMA migrates data using an applciation called 'BCP Data Migrator' which runs on SQL server machine as an agent job and bulk inserts data into SQL Server from Oracle. This agent job gets deleted once the data migration is successful. The account under which this agent job runs needs to have permissions to read Oracle data.