cancel
Showing results for 
Search instead for 
Did you mean: 

Restore SQL Database

Vdang
Level 4

Hello Guys,

I am having problem restoring SQL database and what is old is the fact that something the job will run and be successfully; however, the majority of the issue I am seeing is below capture from the Sgmon log. 

If anyone has any thoughts please let me know I have tried googling the issue and nothing appears to be working.

ActiveState::doStatusEvent('MAGNUS plant4D1'): JobStatus=16 OperationStatus=2 EngineStatus=0 ActiveResourceContainerID=A99AD71D-F6B8-4224-ABFC-395507C2CE53 AbortStatus=0

 [ndmp\ndmpcomm]      - ndmpSendRequest: message:0x400

 [ndmp\ndmpcomm]      - ndmp_writeit: len:28

 [ndmp\ndmpcomm]      - sent          seq#: 21 msg: 0x400

 [ndmp\ndmpcomm]      - ndmp_process_messages: reply_expected:TRUE

 [ndmp\ndmpcomm]      - ndmp_recv_msg

 [ndmp\ndmpcomm]      - ndmp_readit: len:4000

 [ndmp\ndmpcomm]      - got expected reply     msg: 0x400

 [ndmp\ndmpcomm]      - ndmp_process_messages: no more messages in stream buffer

 [ndmp\ndmpcomm]      - ndmpFreeMessage: message:0x400

ActiveState::doStatusEvent('MAGNUS plant4D1'): JobStatus=16 OperationStatus=2 EngineStatus=0 ActiveResourceContainerID=A99AD71D-F6B8-4224-ABFC-395507C2CE53 AbortStatus=0

 [ndmp\ndmpcomm]      - ndmpSendRequest: message:0x400

 [ndmp\ndmpcomm]      - ndmp_writeit: len:28

 [ndmp\ndmpcomm]      - sent          seq#: 22 msg: 0x400

 [ndmp\ndmpcomm]      - ndmp_process_messages: reply_expected:TRUE

 [ndmp\ndmpcomm]      - ndmp_recv_msg

 [ndmp\ndmpcomm]      - ndmp_readit: len:4000

 [ndmp\ndmpcomm]      - got expected reply     msg: 0x400

 [ndmp\ndmpcomm]      - ndmp_process_messages: no more messages in stream buffer

 [ndmp\ndmpcomm]      - ndmpFreeMessage: message:0x400

 [ndmp\ndmpcomm]      - ndmp_process_messages: reply_expected:FALSE

 [ndmp\ndmpcomm]      - ndmp_recv_msg

 [ndmp\ndmpcomm]      - ndmp_readit: len:4000

 [ndmp\ndmpcomm]      - ndmp_process_messages: processing message 0xf337

 [ndmp\ndmpcomm]      - ndmpFreeMessage: message:0xf337

 [ndmp\ndmpcomm]      - ndmp_process_messages: no more messages in stream buffer

ActiveState::doStatusEvent('MAGNUS plant4D1'): JobStatus=16 OperationStatus=2 EngineStatus=0 ActiveResourceContainerID=A99AD71D-F6B8-4224-ABFC-395507C2CE53 AbortStatus=0

 [ndmp\ndmpcomm]      - ndmpSendRequest: message:0x400

 [ndmp\ndmpcomm]      - ndmp_writeit: len:28

 [ndmp\ndmpcomm]      - sent          seq#: 23 msg: 0x400

 [ndmp\ndmpcomm]      - ndmp_process_messages: reply_expected:TRUE

 [ndmp\ndmpcomm]      - ndmp_recv_msg

 [ndmp\ndmpcomm]      - ndmp_readit: len:4000

 [tpfmt]              - MediaServerReadThread: Set channel (0x07989ad0) fragInfoVector to NULL.

 [ndmp\ndmpcomm]      - ndmp_readit: Caught message on closed connection. Socket 0x664 len 0xffffffff

 [ndmp\ndmpcomm]      - ndmp_readit: ErrorCode :: 0 :

 [ndmp\ndmpcomm]      - ndmp_process_messages: detected eof

 [ndmp\ndmpcomm]      - ERROR: ndmpcSendRequest->connection error

 [ndmp\ndmpcomm]      - ERROR: ndmpSendRequest failed:

 [ndmp\ndmpcomm]      - ndmpFreeMessage: message:0x0

 [loops]              - BaseBSDProcessor::PollDataServer(). dataGetDataState failed with NDMP_CONNECT_ERR !!

 [loops]              + basebsdprocessor.cpp (1079):

 [loops]              | BaseBSDProcessor::WaitForDataConnectionToFlush: ControlConnectionLost = true

 [tpfmt]              + tfndmp.cpp (1731):

 [tpfmt]              | TF_NDMPNotifyDataHalted: Setting dataHaltedEvent.

 [tpfmt]              - TF_NDMPGetResult(): MediaServer thread done, channel->dsError is 0x00002746, returning FS_COMM_FAILURE

 [loops]              + basebsdprocessor.cpp (1127):

 [loops]              | BaseBSDProcessor::WaitForDataConnectionToFlush: Retuning result = 0xe000fefd

 [loops]              + basebsdprocessor.cpp (817):

 [loops]              | BaseBSDProcessor::MessagePumpAndWaitForResults: Returning 0xe000fefd.

 [loops]              - RARestoreBSDProcessor: MessagePumpAndWiatForResults() returned -536805635 (0xe000fefd)

 [server]             + job.cpp (1372):

1 REPLY 1

kf2013
Level 6
   VIP   

[ndmp\ndmpcomm] - ERROR: ndmpcSendRequest->connection error

 

Do you check the connection?