migration error

Question

Hi,

when ever I try to migrate data from oracle to sql server ,At the last step of 'data migrate' I get the following error :-

Preparing data migration package...

Starting data migration agent...

Data migration failed with the following message: Unable to start execution of step 1 (reason: The CMDEXEC subsystem failed to load [see the SQLAGENT.OUT file for details]; The job has been suspended).  The step failed..

Data migration complete.

0 table(s) successfully migrated. 

0 table(s) partially migrated. 

57 table(s) failed to migrate.

 

reading this error I understood that there is some problem with cmdexec file.

but i am unable to find a solution.

please help...

Answer 1

Can you post the content of the SQLAGENT.OUT file?

Tom

---

Tom Van Zele | Blog | Twitter | LinkedIn

Answer 2

Sir may I know the path of SQLAGENT.OUT  file.

bcoz I already tried searching it.

I am unable to find ...

Answer 3

Normally you can find it in your log directory (same directory where you find the default trace and the SQL error logs)

..\INSTANCENAME\MSSQL\Log\

Tom

---

Tom Van Zele | Blog | Twitter | LinkedIn

Answer 4

Content of SQLAGENT.OUT file is :- 

 

2010-09-13 12:08:01 - ! [LOG] Step 1 of job 'ssma_oracle data migration package {25031BA5-F01D-4C93-99A5-22D3BC1C07D0}' (0x834BD3D880ABCA408D2D7C229057F4BD) cannot be run because the CMDEXEC subsystem failed to load.  The job has been suspended

2010-09-13 12:33:45 - ! [LOG] Step 1 of job 'ssma_oracle data migration package {2A342596-CC46-4DEC-874C-B11625A8913C}' (0x36D3E5BFEE936D4FB5123B83E9A1DFE2) cannot be run because the CMDEXEC subsystem failed to load.  The job has been suspended

2010-09-13 12:43:24 - ! [LOG] Step 1 of job 'ssma_oracle data migration package {2ABF00E5-8969-4790-8D9F-EA228714FD5D}' (0xB2D66F5C1763424F86DAF7C258612332) cannot be run because the CMDEXEC subsystem failed to load.  The job has been suspended

Answer 5

This is the content of the file SQLAGENT.OUT 

2010-09-13 12:08:01 - ! [LOG] Step 1 of job 'ssma_oracle data migration package {25031BA5-F01D-4C93-99A5-22D3BC1C07D0}' (0x834BD3D880ABCA408D2D7C229057F4BD) cannot be run because the CMDEXEC subsystem failed to load.  The job has been suspended

2010-09-13 12:33:45 - ! [LOG] Step 1 of job 'ssma_oracle data migration package {2A342596-CC46-4DEC-874C-B11625A8913C}' (0x36D3E5BFEE936D4FB5123B83E9A1DFE2) cannot be run because the CMDEXEC subsystem failed to load.  The job has been suspended

2010-09-13 12:43:24 - ! [LOG] Step 1 of job 'ssma_oracle data migration package {2ABF00E5-8969-4790-8D9F-EA228714FD5D}' (0xB2D66F5C1763424F86DAF7C258612332) cannot be run because the CMDEXEC subsystem failed to load.  The job has been suspended

Answer 6

While migrating data, SSMA executes CmdExec jobs which requires Sys admin access. Make sure you are running under Sysadmin previlages.