We’ve developed some resources to help you work effectively from home during COVID-19 Click to learn more

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