Jobs to backup SO Windows with sdb doesn't works

Hi,

we have daily jobs with cmd file to backup SO 8.4 R07 WIN Database with dbsetup, for example:

C:\SuperOffice\MHO\dbSetup.exe EXPORT ODBC:superoffice_mho crm7 xxxxx crm7 \\cmcfile01\edpdept$\Superoffice\SuperOffice_Backup\CtreeBackup_MHO.sdb

But if i check in destination folder, there is only 425 kb for sdb file:

It works earlier to backup SO 7 in sda file before our SO Upgrade to 8.

What is wrong in the scripts?

 

Thanks a lot!

 

RE: Jobs to backup SO Windows with sdb doesn't works

Hi, I'm seeing the same when testing locally here.

Seems like related to this bug. And this bug.

By: Frode Lillerud 10 Apr 2019

RE: Jobs to backup SO Windows with sdb doesn't works

When backing up a database that is created from version 8.1 or above, is the DbSetup being used from the same directory as the currently installed SuperOffice application? Same versions?

There is also a lot of logging going on as well, so what does the log say? If it's not in the same directory as DbSetup, check the Temp folder (so_log.Database.txt).

 

 

By: Tony Yates 11 Apr 2019

RE: Jobs to backup SO Windows with sdb doesn't works

Hi Frode,

Thanks! i have followed bugs and commented.

 

Hi Tony,

the jobs runs on same SO Server "crmapp" and take dbsetup from same directory as where SO Server-side installed on "crmapp" in its local C:\SuperOffice\MHO\ daily begins from 20:30:

There are two so_log.database.log i found in local of crmapp of my Account jyou, it is also Owner of this Job:

from C:\Users\jyou\AppData\Local\Temp at nearly 20:30 from yesterdaay, I don't see logs at about 20:30, just at 5:00 morning on 11th Apr.:

019-04-10 18:30:31.155 Info DatabaseExport 4 493 rows in 00:00:00, 10.816 rows per second
2019-04-10 18:30:31.170 Info DatabaseExport 1 Export complete
#Time(UTC) Type Category TID Message
2019-04-11 05:00:11.718 Info DatabaseManagment 1 Reading database model
2019-04-11 05:00:12.077 Info Travel 1 Create destination database tables
2019-04-11 05:00:12.702 Info PhysicalTableApplicator 1 Applying structural commands to the physical database
2019-04-11 05:00:12.718 Info AddTable 1 Create table 'sequence'
2019-04-11 05:00:12.718 Info AddTable 1 Create table 'company'
2019-04-11 05:00:12.733 Info AddTable 1 Create table 'associate'
2019-04-11 05:00:12.749 Info AddTable 1 Create table 'AssociateGroupLink'
2019-04-11 05:00:12.749 Info AddTable 1 Create table 'AssociateHeadingLink'
2019-04-11 05:00:12.764 Info AddTable 1 Create table 'contact'
2019-04-11 05:00:12.764 Info AddTable 1 Create table 'person'

...

2019-04-11 05:00:18.093 Info AddTable 1 Create table 'Webhook'
2019-04-11 05:00:18.499 Info Unicode 1 Writing IsDatabaseUnicode = True
#Time(UTC) Type Category TID Message
2019-04-11 05:00:19.999 Info DatabaseManagment 1 Reading database model
2019-04-11 05:00:20.343 Info DatabaseManagment 1 Reading database model
2019-04-11 05:00:21.343 Info Travel 1 Copy table area
2019-04-11 05:00:21.359 Info Travel 1 Starting transfer of area, 13 fields, 0 rows
2019-04-11 05:00:21.390 Info Travel 1 Ending transfer of area; 0 transferred in 00:00:00 -> 0/sec, 0 skipped
2019-04-11 05:00:21.390 Info Travel 1 Copy table areauserassignment
2019-04-11 05:00:21.390 Info Travel 1 Starting transfer of areauserassignment, 8 fields, 1 rows
2019-04-11 05:00:21.406 Info Travel 1 Ending transfer of areauserassignment; 1 transferred in 00:00:00 -> 133/sec, 0 skipped
2019-04-11 05:00:21.421 Info Travel 1 Copy table areauserinclusion
2019-04-11 05:00:21.421 Info Travel 1 Starting transfer of areauserinclusion, 8 fields, 3 rows
2019-04-11 05:00:21.421 Info Travel 1 Ending transfer of areauserinclusion; 3 transferred in 00:00:00 -> 20.174/sec, 0 skipped
2019-04-11 05:00:21.452 Info Travel 1 Copy table associate

...

2019-04-11 05:09:21.663 Info Travel 1 Ending transfer of ConsentPerson; 13.556 transferred in 00:00:00 -> 29.931/sec, 0 skipped
2019-04-11 05:09:22.210 Info Travel 1 Create destination database Indexes
2019-04-11 05:09:22.210 Info PhysicalIndexApplicator 1 Applying index commands to the physical database
2019-04-11 05:09:22.225 Info AddIndex 1 Applying indexes to table 'sequence'.
2019-04-11 05:09:22.225 Info AddIndex 1 Add index [id] UC
2019-04-11 05:09:22.241 Info AddIndex 1 Add index [TableName] U
2019-04-11 05:09:22.256 Info AddIndex 1 Add index [TableNumber] U
2019-04-11 05:09:22.272 Info AddIndex 1 Applying indexes to table 'company'.
2019-04-11 05:09:22.272 Info AddIndex 1 Add index [company_id] UC
2019-04-11 05:09:22.288 Info AddIndex 1 Applying indexes to table 'associate'.
2019-04-11 05:09:22.288 Info AddIndex 1 Add index [associate_id] UC
2019-04-11 05:09:22.303 Info AddIndex 1 Add index [name] U
2019-04-11 05:09:22.303 Info AddIndex 1 Add index [person_id]
2019-04-11 05:09:22.319 Info AddIndex 1 Add index [type]

...

2019-04-11 05:13:34.523 Info AddIndex 1 Add index [webhook_id] UC
2019-04-11 05:13:34.538 Info Travel 1 Create destination database Fulltext Indexes
2019-04-11 05:13:34.538 Warning Fulltext 1 Failed to create fulltext indexes

 

------------

from C:\Users\jyou\AppData\Local\SuperOffice\SO_LOCAL\DATA there is also so_log.Database.log, but at about 20:30 also no logs, but from 1:30 morning on 11th Apr.:

 

2019-04-05 12:23:34.948 Info DatabaseManagment 1 Updating sequence.next_id on Webhook from 1 to 2113929217
#Time(UTC) Type Category TID Message
2019-04-05 12:24:13.511 Info DatabaseManagment 1 Reading database model
#Time(UTC) Type Category TID Message
2019-04-11 01:37:12.205 Info DatabaseManagment 1 Reading database model
2019-04-11 01:37:12.564 Info DatabaseManagment 1 Updating sequence.next_id on sequence from 502 to 2113929217
2019-04-11 01:37:12.564 Info DatabaseManagment 1 Updating sequence.next_id on company from 2 to 2113929217
2019-04-11 01:37:12.595 Info DatabaseManagment 1 Updating sequence.next_id on associate from 81 to 2113929217
2019-04-11 01:37:12.642 Info DatabaseManagment 1 Updating sequence.next_id on AssociateGroupLink from 1 to 2113929217
2019-04-11 01:37:12.673 Info DatabaseManagment 1 Updating sequence.next_id on AssociateHeadingLink from 1 to 2113929217
2019-04-11 01:37:12.720 Info DatabaseManagment 1 Updating sequence.next_id on contact from 12455 to 2113929217

....

2019-04-11 01:37:23.548 Info DatabaseManagment 1 Updating sequence.next_id on Webhook from 1 to 2113929217
#Time(UTC) Type Category TID Message
2019-04-11 01:37:29.533 Info DatabaseManagment 1 Reading database model

Thanks a lot!

 

 

 

By: Jianchun You 11 Apr 2019

RE: Jobs to backup SO Windows with sdb doesn't works

and here is backup from yesterday at 20:30 when jobs begins:

 

You see all backups with *.sdb have same file size 425 kb.

By: Jianchun You 11 Apr 2019

RE: Jobs to backup SO Windows with sdb doesn't works

Hi,

is there any updates to get Jobs to backup SO Windows in SO 8.4?

Thanks!

By: Jianchun You 6 Jun 2019