Error: Could not open stream(-903)

[Former Member]

Hi,

on 7.7  on Win 2008 , 64 bits,server

I have created a medium which is on a mapped drive.

Other applications can write on this mapped drive.

But MAXDB backup fails with :

Error: Could not open stream(-903)

Thanks for help.

[former_member188883 · Accepted solution]

Hi ,

For eg: sapbackup is your backup folder where you intend to store backup files.

I suppose you have defined the backup medium as

Y:\sapbackup  ( Where Y:\ is the mapped drive )

Instead you try with this option

\\<IP address of share folder>\spabackup

Ensure share folder ( for eg: sapbackup) has full permission to everyone.

Hope this helps

Regards,

Deepak Kori

[Former Member · Accepted solution]

realy thank you.

I did this : \\<IP address of share folder>\spabackup

But unfortunately always the same error :

Error: Could not open stream(-903)

Regards.

[former_member188883 · Accepted solution]

Hi,

Is this backup folder shared and has full permission to everyone ??

Please share dbm.prt, dbm.ebp and dbm.ebl log file details when you get this error

Regards,

Deepak Kori

[Former Member · Accepted solution]

Thank you.

The only file among those is dbm.prt ,

and right now I ran a bckup. And this file says :

2013-04-23 11:20:48 0x00001080 INF	1 DBMSrvCo A DBM Server client connection was established at 2013-04-23 11:20:48 (client process has process ID 7656 on computer SAP01).
2013-04-23 11:20:48 0x00001080 WRN	400 DBMSrv   Usage of the old name 'RUNDIRECTORY' for parameter 'RunDirectoryPath'
2013-04-23 11:20:48 0x00001080 WRN	400 DBMSrv   Usage of the old name 'INSTANCE_TYPE' for parameter 'InstanceType'
2013-04-23 11:20:50 0x00001080 WRN	400 DBMSrv   Usage of the old name 'MAXBACKUPDEVS' for parameter 'MaxBackupMedia'
2013-04-23 11:20:50 0x00001080 WRN	400 DBMSrv   Usage of the old name 'LOG_BACKUP_TO_PIPE' for parameter 'EnableLogBackupToPipe'
2013-04-23 11:20:58 0x00001080 INF	283 DBMSrv   Command 'backup_save "Cold_Bck_Full_Data_SSM" DATA RECOVERY' is being executed.
2013-04-23 11:20:59 0x00001080 INF	1 DBMKnl   Sending an administrative statement to the database
	0x00001080 INF	8 DBMKnl   Statement:  SAVE DATA QUICK TO '\\Server\SAP\SSM\Full\Data\Cold_Bck_Full_Data_SSM.bck' FILE BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'Cold_Bck_Full_Data_SSM'
2013-04-23 11:21:04 0x00001080 ERR	3 DBMKnl   Received the result of an administrative statement from the database
	0x00001080 ERR	9 DBMKnl   Statement:  SAVE DATA QUICK TO '\\Server\SAP\SSM\Full\Data\Cold_Bck_Full_Data_SSM.bck' FILE BLOCKSIZE 8 NO CHECKPOINT MEDIANAME 'Cold_Bck_Full_Data_SSM'
	0x00001080 ERR	10 DBMKnl   Returncode: -903
	0x00001080 ERR	5 DBMKnl   Errortext:  Host file I/O error
2013-04-23 11:21:04 0x00001080 ERR	-24580 DBMSrv   ERR_COMMAND_FAILED: Command 'backup_save' has ended and failed with return code -24988.
	0x00001080 ERR	-24988 DBMSrv   ERR_SQL: SQL error
	0x00001080 ERR	-24778 DBMSrv   -903,Host file I/O error
	0x00001080 ERR	-24778 DBMSrv   3,Data backup failed
	0x00001080 ERR	-24778 DBMSrv   Servertask Info: because Error in backup task occured
	0x00001080 ERR	-24778 DBMSrv   Job 1 (Backup / Restore Medium Task) [executing] WaitingT111 Result=3700
	0x00001080 ERR	-24778 DBMSrv   Error in backup task occured, Error code 3700 "hostfile_error"
	0x00001080 ERR	-24778 DBMSrv   Backupmedium #1 (\\Server\SAP\SSM\Full\Data\Cold_Bck_Full_Data_SSM.bck) Could not open stream
	0x00001080 ERR	-24778 DBMSrv   Backup error occured, Error code 3700 "hostfile_error"
2013-04-23 11:21:21 0x00001080 INF	2 DBMSrvCo A DBM Server client connection was released (client process has process ID 7656 on computer SAP01).
2013-04-23 11:21:21 0x00001080 INF	1 DBMKnl   Sending an administrative statement to the database
	0x00001080 INF	8 DBMKnl   Statement:  SAVE DATA CANCEL
2013-04-23 11:21:21 0x00001080 ERR	3 DBMKnl   Received the result of an administrative statement from the database
	0x00001080 ERR	9 DBMKnl   Statement:  SAVE DATA CANCEL
	0x00001080 ERR	10 DBMKnl   Returncode: -104
	0x00001080 ERR	5 DBMKnl   Errortext:  DBM command impossible at this time

Regards.

[former_member188883 · Accepted solution]

Hi,

Do the following

1) Post the ouput of

dbmcli -d <db_name> -u control,<pwd> medium_getall

2) Secondly check the owner and permissions to

      \\Server\SAP\SSM\Full\Data\Cold_Bck_Full_Data_SSM.bck

    It should sdb as the owner or it should have full permission to everyone user.

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Thanks again.

If I run the following as user who runs backup , it fails but if run as administrator it's OK.

dbmcli -d <db_name> -u control,<pwd> medium_getall

OK

SolMan Log Backup       G:\SSM\LOG\SSM.log      FILE    AUTO    0       8       NO      NO          20111206220039      20111206220039          NONE

0

Cold_Bck_Incr_Log_SSM   \\Server\SAP\SSM\Incr\Logs\Cold_Bck_Incr_Log_SSM.bck  FILE    LOG     0   8   NO      NO              20120202122321  201202

02122321                NONE    0

Warm_Bck_Full_Log_SSM   \\Server\SAP\SSM\Full\Logs\Warm_Bck_Full_Log_SSM.bck  FILE    LOG     0   8   NO      NO              20120202122408  201202

02122408                NONE    0

Warm_Bck_Incr_Data_SSM  \\Server\SAP\SSM\Incr\Data\Warm_Bck_Incr_Data_SSM.bck FILE    PAGES   0   8   NO      NO              20120202122422  201202

02122422                NONE    0

Warm_Bck_Incr_Log_SSM   \\Server\SAP\SSM\Incr\Logs\Warm_Bck_Incr_Log_SSM.bck  FILE    LOG     0   8   NO      NO              20120202122429  201202

02122429                NONE    0

Cold_Bck_Incr_Data_SSM  \\Server\SAP\SSM\Incr\Data\Cold_Bck_Incr_Data_SSM.bck FILE    PAGES   0   8   NO      NO              20120202122646  201202

02122646                NONE    0

Cold_Bck_Full_Log_SSM   \\Server\SAP\SSM\Full\Logs\Cold_Bck_Full_Log_SSM.bck  FILE    LOG     0   8   NO      NO              20120202122700  201202

02122700                NONE    0

Warm_Bck_Full_Data_SSM  \\Server\SAP\SSM\Full\Data\Warm_Bck_Full_Data_SSM.bck FILE    DATA    0   8   YES     NO              20120202163109  201202

02163109                NONE    0

Backup_Full_SSM G:\BDD_Backup\Full\Data\SSM_COM FILE    DATA    0       8       NO      NO          20121119081352      20121119081352          NONE

0

SSM_INCR_BACKUP G:\SSM\DATA\SSM_INC     FILE    PAGES   0       8       YES     NO              20121119123022  20121119123022          NONE    0

Backup SolMan FULL      G:\SSM\DATA\SSM.bak     FILE    DATA    0       8       YES     NO          20121119154500      20121119154500          NONE

0

Backup_Full_Manuel      G:\BDD_Backup\Full\Data\SSM_FULL        FILE    DATA    0       8       NO  NO          20130328151634  20130328151634

NONE    0

Cold_Bck_Full_Data_SSM  \\Server\SAP\SSM\Full\Data\Cold_Bck_Full_Data_SSM.bck FILE    DATA    0   8   NO      NO              20130412160023  201304

12160023                NONE    0

Cold_Bck_Full_Data_SSM_2        \\182.16.0.41\Full\Data\Cold_Bck_Full_Data_SSM.bck      FILE    DATA    0       8       YES     NO              201304

19124903        20130419124903          NONE    0

For

permissions to

      \\Server\SAP\SSM\Full\Data\Cold_Bck_Full_Data_SSM.bck

backup fails before then there is no file to see the owner.

When medium is local (G:\BDD_Backup\Full\Data) the owner is sdb operator.

Thanks and regards.

[former_member188883 · Accepted solution]

Hi,

You need to get full permissions to this medium for user sdb:operator.

\\Server\SAP\SSM\Incr\Logs\Cold_Bck_Incr_Log_SSM.bck

Regards,

Deepak Kori

[Former Member · Accepted solution]

yes thank you.

[former_member229109 · Accepted solution]

Hello,

1.

Answer on your question could be found in the MAXDB library,

please review the document "Backing Up and Restoring with Remote Computers"

at

http://maxdb.sap.com/doc/7_7/44/d7a7baa8f42754e10000000a1553f6/content.htm

2.

Please review "Restricting Access to Database Resources (Microsoft Windows)" at 

   http://maxdb.sap.com/doc/7_8/44/bb6c57e00215b2e10000000a155369/content.htm

Regards, Natalia Khlopina