Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Error:The job failed. Unable to determine if the owner (ABCIndia\Subhash.subramanyam) of job ssma_oracle data migration package

Answered 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
     
     
    Sign In to Vote
    0

    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

     

     

All Replies

  • Tuesday, June 22, 2010 9:46 AM
     
     
    Sign In to Vote
    0

    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

    http://support.microsoft.com/kb/883551/en-us

     

     
  • Wednesday, June 23, 2010 5:26 AM
     
     Answered
    Sign In to Vote
    0
    I'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.
     
  • Wednesday, June 23, 2010 5:06 PM
     
     
    Sign In to Vote
    0

    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.