Tag Archives: DM database

DM backup database Error: [-7169]:bakres failed to communicate with DMAP message.

[error reporting]

SQL> backup database backupset 'dm3bak01';
backup database backupset 'dm3bak01';
[-7169]:bakres failed to communicate with DMAP message.
Used time: 00:00:10.033. execution number:0.

[log content]

2022-04-27 09:08:01 [CMD] database P0000048762 PPID4294967295  backup database backupset 'dm3bak01';


2022-04-27 09:08:01 [CMD] database P0000048762 PPID4294967295  BACKUP DATABASE [dm03]
2022-04-27 09:08:01 [INFO] database P0000048762  PPID4294967295  CMD START....
2022-04-27 09:08:01 [INFO] database P0000048762  PPID4294967295  BACKUP DATABASE [dm03],execute......
2022-04-27 09:08:01 [INFO] database P0000048762  PPID4294967295  check limits of huge data
2022-04-27 09:08:01 [INFO] database P0000048762  PPID4294967295  CMD CHECK LSN ......
2022-04-27 09:08:01 [INFO] database P0000048762  PPID4294967295  adjust checkpoint lsn to maximal apply lsn 0
2022-04-27 09:08:11 [INFO] database P0000048762  PPID4294967295  connect to dmap with portnum[4236], tsk_num: [4], code: [-7169].
2022-04-27 09:08:11 [WARNING] database P0000048762  PPID4294967295  CMD END.CODE:[-7169], DESC:[bakres fails to communicate with DMAP messages], COST:[00:00:10]

[reason for error reporting]
because dmapservice is not started or there is a problem with dmapservice

[problem handling]

[pwd:/u01/dm8/dmdbms/bin]$ ./DmAPService start
DmAPService (pid 101899) is running.    # I find it is started

[pwd:/u01/dm8/dmdbms/bin]$ ./DmAPService restart    # try to restart
Stopping DmAPService:                                      [ OK ]
Starting DmAPService:                                      [ OK ]

[pwd:/u01/dm8/dmdbms/bin]$ !disql
SQL> backup database backupset 'dm3bak01';      # backup successfully
The operation has been executed
Time used: 00:00:03.660. Execution number: 55700.

DM database data migration DTS error solution

Project scenario:

When using DTS data migration tool to migrate from Mysql to DM, ten tables reported errors. There are two kinds of errors

Problem Description:

error number: – 2670
error message: Object [draft]_ The constraint expression of message] default is invalid
click the details query to find that the table definition is in disorder. You need to manually create this table in Dameng database </ font>

Error number: – 6169
error message: column [is]_ MOBILE_ Text] the length exceeds the definition
first, take out the table definition and create the table manually in DM database. If it is found that there is no problem, it should be the problem of data. Check that the character sets on both sides are consistent, and they are UTF-8. In the table definition, this column is varchar (20)
check that there is an obviously long field in this column of data in the source MSYQL. In DM calculation, it is found that this data occupies 22 bytes, so you need to change the field length