Pervasive

    When I start the agent with either a script or directly from the command line the agent starts and lists the files that

it's enabled for then immediately shuts off listing the files that its not enabled for. When I check the status at that point I find that the agent is off. What do I need todo to fix this issue? I am using backup agent version 1.2.

- stumpped?

Please provide information on the version of the psql and the os environment.  Is this the first time that you use the ba product or are you moving from a  previous BA? Is the BA hook module listed in the registry under the psql engine? I am assuming the gui is failing the same way.   When you installed, were any error messages generated?

Jose 

  We have psql version 10 on a windows 2003 server enterprise edition. This is the first time that I have used the product. BA hook module not sure on this?  I didn't recieve any errors when it installed.

- Ray 

- What version of Backup Agent are you using? 

- What's in the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Server Engine\Version 10\Settings\Hook Modules

- What's in the BA Event Log?  

I am using Backup Agent version 1.2.

The Registry keys at HKEY_LOCAL_MACHINE\SOFTWAE\Pervasive Software\MicroKernal Server Engine\Version 10\Settings\Hook Mdules are:

     (Default)          REG_SZ         (value not set)

     BA Event Handler    REG_SZ     C:\Program Files\Pervasive Software\psql\pba\bin\baeh.dll

Here is a copy of the BA Event log:

E  4088  8/14/2008 11:59:22 PM  Backup Agent is unable to complete the ON request for the file:
                                  "C:\AOD\MAGIC8\AODDATA\USER.WHG30074C010" (Status 59)
E  4088  8/14/2008 11:59:22 PM  Backup Agent is unable to complete the ON request for the file:
                                  "C:\AOD\MAGIC8\AODDATA\USER.WHP20923C030" (Status 59)
E  4088  8/14/2008 11:59:22 PM  Backup Agent is unable to complete the ON request for the file:
                                  "C:\AOD\MAGIC8\AODDATA\USER.WHG30050C010" (Status 59)
E  4088  8/14/2008 11:59:22 PM  Backup Agent is unable to complete the ON request for the file:
                                  "C:\AOD\MAGIC8\AODDATA\USER.WHG30100C010" (Status 59)
E  4088  8/14/2008 11:59:22 PM  Backup Agent is unable to complete the ON request for the file:
                                  "C:\AOD\MAGIC8\AODDATA\USER.WRC40164C040" (Status 59)
I  4088  8/14/2008 11:59:22 PM  Backup Agent is now ON for these files:
                                  "C:\AOD\MAGIC8\C040\PAUNITASSIGNMENTCODES",
                                  "C:\AOD\MAGIC8\C030\PAUNITASSIGNMENTCODES",
                                  "C:\AOD\MAGIC8\C010\PAUNITASSIGNMENTCODES",
                                  "C:\DOCUMENTS AND SETTINGS\ALL USERS\APPLICATION DATA\PERVASIVE SOFTWARE\PSQL\DEFAULTDB\FILE.DDF",
                                  "C:\DOCUMENTS AND SETTINGS\ALL USERS\APPLICATION DATA\PERVASIVE SOFTWARE\PSQL\DBNAMES.CFG",
                                  "C:\AOD\MAGIC8\C040\C_MEDCCTF",
                                  "C:\AOD\MAGIC8\C040\C_MRDOCRE2",
                                  "C:\AOD\MAGIC8\C040\C_STAFCODE",
                                  "C:\AOD\MAGIC8\C040\RSSCHDMST2",
                                  "C:\AOD\MAGIC8\C040\WFTASKS1",
                                  "C:\AOD\MAGIC8\C040\MREMARTAR5",
                                  "C:\AOD\MAGIC8\C040\MDASSM.CTL",
                                  "C:\AOD\MAGIC8\C040\MRPARMMST",
                                  "C:\AOD\MAGIC8\C040\PPPROFILE7",
                                  "C:\AOD\MAGIC8\C030\C_MEDCCTF",
                                  "C:\AOD\MAGIC8\C030\C_MRDOCRE2",
                                  "C:\AOD\MAGIC8\C030\C_STAFCODE",
                                  "C:\AOD\MAGIC8\C030\WFTASKS1",
                                  "C:\AOD\MAGIC8\C030\MREMARTAR5",
                                  "C:\AOD\MAGIC8\C030\PPPROFILE7",
                                  "C:\AOD\MAGIC8\C030\MDASSM.CTL",
                                  "C:\AOD\MAGIC8\C030\MRPARMMST",
                                  "C:\AOD\MAGIC8\C010\C_MEDCCTF",
                                  "C:\AOD\MAGIC8\C010\C_MRDOCRE2",
                                  "C:\AOD\MAGIC8\C010\C_STAFCODE",
                                  "C:\AOD\MAGIC8\C010\WFTASKS1",
                                  "C:\AOD\MAGIC8\C010\MREMARTAR5",
                                  "C:\AOD\MAGIC8\C010\PPPROFILE7",
                                  "C:\AOD\MAGIC8\C010\MDASSM.CTL",
                                  "C:\AOD\MAGIC8\C010\MRPARMMST",
                                  "C:\AOD\MAGIC8\AODDATA\USER.MST",
                                  "C:\AOD\MAGIC8\C010\RSSCHDMST2",
                                  "C:\AOD\MAGIC8\C010\PAPROFPHOTO2",
                                  "C:\AOD\MAGIC8\AODDATA\PASMARTCHARTPARMS",
                                  "C:\AOD\MAGIC8\AODDATA\SYRITEMENUDISPOVERRIDE",
                                  "C:\AOD\MAGIC8\AODDATA\SYRITEMSTELITE80",
                                  "C:\AOD\MAGIC8\AODDATA\TYPE.MST",
                                  "C:\AOD\MAGIC8\MAGIC94\CTL\ADCTL.MCF"
I  2908  8/14/2008 11:59:22 PM  Backup Agent is now ON for this file:
                                  "C:\AOD\MAGIC8\C010\LOGPARAM"
I  2912  8/14/2008 11:59:23 PM  Backup Agent is now ON for this file:
                                  "C:\AOD\MAGIC8\C040\C_MRINTERDISCPATCH"
I  4088  8/14/2008 11:59:27 PM  Backup Agent is now OFF for these files:
                                  "C:\DOCUMENTS AND SETTINGS\ALL USERS\APPLICATION DATA\PERVASIVE SOFTWARE\PSQL\DBNAMES.CFG",
                                  "C:\AOD\MAGIC8\AODDATA\USER.MST",
                                  "C:\AOD\MAGIC8\C040\MREMARTAR5",
                                  "C:\AOD\MAGIC8\AODDATA\SYRITEMSTELITE80",
                                  "C:\AOD\MAGIC8\C010\LOGPARAM",
                                  "C:\AOD\MAGIC8\C040\C_MRDOCRE2",
                                  "C:\AOD\MAGIC8\AODDATA\SYRITEMENUDISPOVERRIDE",
                                  "C:\AOD\MAGIC8\C040\C_MEDCCTF",
                                  "C:\AOD\MAGIC8\C010\PAUNITASSIGNMENTCODES",
                                  "C:\AOD\MAGIC8\C040\C_MRINTERDISCPATCH",
                                  "C:\AOD\MAGIC8\C010\PAPROFPHOTO2",
                                  "C:\AOD\MAGIC8\C030\PAUNITASSIGNMENTCODES",
                                  "C:\AOD\MAGIC8\C010\MDASSM.CTL",
                                  "C:\AOD\MAGIC8\C040\PAUNITASSIGNMENTCODES",
                                  "C:\AOD\MAGIC8\C030\C_STAFCODE",
                                  "C:\AOD\MAGIC8\C040\MDASSM.CTL",
                                  "C:\AOD\MAGIC8\C040\MRPARMMST",
                                  "C:\AOD\MAGIC8\AODDATA\PASMARTCHARTPARMS",
                                  "C:\AOD\MAGIC8\C010\C_MEDCCTF",
                                  "C:\AOD\MAGIC8\C030\PPPROFILE7",
                                  "C:\AOD\MAGIC8\MAGIC94\CTL\ADCTL.MCF",
                                  "C:\AOD\MAGIC8\C040\WFTASKS1",
                                  "C:\AOD\MAGIC8\C010\C_STAFCODE",
                                  "C:\AOD\MAGIC8\C030\MREMARTAR5",
                                  "C:\AOD\MAGIC8\C010\RSSCHDMST2",
                                  "C:\AOD\MAGIC8\C030\C_MEDCCTF",
                                  "C:\AOD\MAGIC8\C010\PPPROFILE7",
                                  "C:\AOD\MAGIC8\C040\C_STAFCODE",
                                  "C:\AOD\MAGIC8\C030\MRPARMMST",
                                  "C:\AOD\MAGIC8\C010\MRPARMMST",
                                  "C:\AOD\MAGIC8\C040\RSSCHDMST2",
                                  "C:\AOD\MAGIC8\C010\WFTASKS1",
                                  "C:\AOD\MAGIC8\C040\PPPROFILE7",
                                  "C:\DOCUMENTS AND SETTINGS\ALL USERS\APPLICATION DATA\PERVASIVE SOFTWARE\PSQL\DEFAULTDB\FILE.DDF",
                                  "C:\AOD\MAGIC8\C030\C_MRDOCRE2",
                                  "C:\AOD\MAGIC8\C030\MDASSM.CTL",
                                  "C:\AOD\MAGIC8\AODDATA\TYPE.MST",
                                  "C:\AOD\MAGIC8\C010\MREMARTAR5",
                                  "C:\AOD\MAGIC8\C030\WFTASKS1",
                                  "C:\AOD\MAGIC8\C010\C_MRDOCRE2"

    Then if I check that status of the agent it tells me that the status is off. I don't know why its starting and then immediately shutting itself back down.

- Ray 

Part of the problem is that you have files with the same name and different extensions (the user file.).  When the delta files get created, we simply drop the extension and add ^^^ as an extension.   In this case user.^^^ already exists when we try to create the delta for the second user file with a different extension (returning a status 59---file already exists, user.^^^^).   Is there a way, that you can open only one user file to test this?  Open up the application, activate the backup agent, and then check the data directory to see if the deltas are active.   You would have to guarantee that the user file would reside in a different directory for each user, otherwise, BA will not work for you.  

Jose

Another approach would be to exclude the file user.*  From the documentation:

To exclude files from being placed into Continuous Operations

   I  will try and schedule a test at the end of the day. We actually have multiple databases in the same directory with users having access to mutiple databases across 5 seperate facilities. I will try and test this today then I will contact the

software vendor who wrote the databases and see if they have a solution that would allow the user files to reside in a different directory for each user. Thank You for your help I will try this and let you know afterwards what I find out.

- Ray

   I tried running the backup agent with just one person logged in and it did the same thing. Here is what appeared in the BA event log:

E  4088  8/20/2008 5:12:43 PM   Backup Agent is unable to complete the ON request for the file:
                                  "C:\AOD\MAGIC8\AODDATA\USER.LNE" (Status 59)
I  4088  8/20/2008 5:12:43 PM   Backup Agent is now ON for these files:
                                  "C:\DOCUMENTS AND SETTINGS\ALL USERS\APPLICATION DATA\PERVASIVE SOFTWARE\PSQL\DEFAULTDB\FILE.DDF",
                                  "C:\DOCUMENTS AND SETTINGS\ALL USERS\APPLICATION DATA\PERVASIVE SOFTWARE\PSQL\DBNAMES.CFG",
                                  "C:\AOD\MAGIC8\AODDATA\USER.RIT",
                                  "C:\AOD\MAGIC8\AODDATA\COMPMST.EX2",
                                  "C:\AOD\MAGIC8\AODDATA\COMPMSTEXT",
                                  "C:\AOD\MAGIC8\AODDATA\COMP.MST",
                                  "C:\AOD\MAGIC8\MAGIC94\CTL\ADCTL.MCF"
I  4088  8/20/2008 5:12:44 PM   Backup Agent is now OFF for these files:
                                  "C:\DOCUMENTS AND SETTINGS\ALL USERS\APPLICATION DATA\PERVASIVE SOFTWARE\PSQL\DBNAMES.CFG",
                                  "C:\AOD\MAGIC8\AODDATA\USER.RIT",
                                  "C:\AOD\MAGIC8\AODDATA\COMPMST.EX2",
                                  "C:\AOD\MAGIC8\MAGIC94\CTL\ADCTL.MCF",
                                  "C:\AOD\MAGIC8\AODDATA\COMPMSTEXT",
                                  "C:\DOCUMENTS AND SETTINGS\ALL USERS\APPLICATION DATA\PERVASIVE SOFTWARE\PSQL\DEFAULTDB\FILE.DDF",
                                  "C:\AOD\MAGIC8\AODDATA\COMP.MST"

  If now one is in the system the Backup Agent turns on without error ( I tried this just to see). Any ideas??

- Ray 

Even with one person, you still have two files with the same name and different extensions i.e. user.lne and user.rit.  Try excluding the user file in the efl.txt--see the documentation.  

 I tried it here with demodata.  I made a copy of billing.mkd and and renamed the copy billing.dat.  With these two files open, the BA acted exactly like you describe.  Then I excluded billing in the efl.txt with the filename billing.*   The problem did not occur.

Jose