cancel
Showing results for 
Search instead for 
Did you mean: 

Client Copy process terminated while doing local copy .

Former Member
0 Kudos

Hi

I am trying to do local client copy in my system , after copying some table process got canceled . SM21 saying below show screen shoot can any one do help in this .

Thank and regards

Kumar

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Kumar,

during client copy it might be the case that the compression info pool size is too small.

Do you see a dump in st22 like?

"[ASE Error SQL716]Unable to allocate memory of size xxxx bytes from the 'compression info' pool"

If yes then you have to increase the compression info pool

sp_configure 'compression info pool size', xxxx

go

Note 1539125 - SYB: Configuration Guide for SAP Sybase ASE 15.7.0

> compression info pool size >= 32768 [REQ]

Maybe this helps...

Kind regards

Arne

former_member188958
Active Contributor
0 Kudos

Hi Kumar,

I can't see the picture either.

If you think ASE terminated the connection, have a look in the

ASE errorlog.  There may be a more explicit fatal error reported there,

perhaps with a stack trace.  Please post the message and

stacktrace if there is one.

-bret

Former Member
0 Kudos

Hi Bret,

Where can i find stack trace

Regards

Kumar

former_member184473
Active Contributor
0 Kudos

Hi Kumar,

The picture did not load, could you post as plain text?

Regards,

Eduardo Rezende

Former Member
0 Kudos

Hi Eduardo Rezende

Thanks for your reply , please find below error.

Run-time error "DBIF_DSQL2_DEFAULT_CR_ERROR" occurred

Database error 1105 at EXE

> [ASE Error SQL1105]Can't allocate space for object 'SNAP' in

> database 'DV1' because 'default' segment is full/has no free

> extents. If you ran out of space in syslogs, dump the

> transaction log. Otherwise, use ALTER DATABASE to increase

> the size of the segment.#

> Include LSYDBU27 line 0007.

Run-time error "DBIF_DSQL2_SQL_ERROR" occurred

Unexpected return value 1 when calling up DbSlC

Function COMMIT on connection R/3 failed

> Short dump "130422 091503 PALSAPDE V_DV1_00 " generated

Transaction Canceled 00 671 ( DBIF_DSQL2_DEFAULT_CR_ERROR 20130422091503PALSAPDEV_DV1_00 SAPSYS 000 )

Regards

kumar


former_member184473
Active Contributor
0 Kudos

Hi Kumar,

Kindly increase your database free space and retry.

Regards,

Eduardo

former_member188883
Active Contributor
0 Kudos

Hi Kumar,

Please use the commands to increase space in database in the below example.

Please Log on from sapsa user

use master

go

disk resize name='dataDEV_1', size='40G'

go

alter database DEV on dataDEV_1= '40G' log on logDEV_1='4G'

go

Hope this helps.

Regards,

Deepak Kori