[mapguide-users] DB XML Error and Packages

[David Bowen]

Based on articles I've come across online, it seems that the following
settings have resolved the issue:

LibraryCacheSize                   = 32
#SessionCacheSize                   = 2
SessionCacheSize                   = 4
DBPageSize                         = 32
DBXMLPageSize                      = 32
LibraryLogBufferSize               = 12
SessionLogBufferSize               = 1
#DBMaxTransactions                  = 1000
DBMaxTransactions                  = 2000
SessionDBPageSize                  = 2
SessionDBXMLPageSize               = 0.5
#DBTimeout                          = 0.2
DBTimeout                          = 0.6
#DBMaxLockers                       = 1000
DBMaxLockers                       = 2000

On Fri, Mar 31, 2023 at 10:30 AM David Bowen <dbowenrci at gmail.com> wrote:

> I'm encountering an issue when trying to load packages using Maestro. For
> example, I'm attempting to load the package created from our Production
> environment into the Development environment and I get the following errors:
>
> The remote server returned an error: (559) MgDbXmlException.:
> An exception occurred in DB XML component.
> Error: DB_BUFFER_SMALL: User memory too small for return value
>
> - MgResourceServiceHandler.ProcessOperation() line 80 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\ResourceServiceHandler.cpp
> - MgOpApplyResourcePackage.Execute() line 96 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\OpApplyResourcePackage.cpp
> - MgServerResourceService.ApplyResourcePackage() line 815 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\ServerResourceService.cpp
> - MgLibraryRepositoryManager.ApplyResourcePackage() line 148 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\LibraryRepositoryManager.cpp
> - MgLibraryRepositoryManager.LoadResourcePackage() line 183 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\LibraryRepositoryManager.cpp
> - MgResourcePackageLoader.Start() line 145 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\ResourcePackageLoader.cpp
> - MgResourcePackageLoader.PerformOperation() line 223 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\ResourcePackageLoader.cpp
> - MgResourcePackageLoader.SetResource() line 303 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\ResourcePackageLoader.cpp
> - MgRepositoryManager.SetResource() line 559 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\RepositoryManager.cpp
> - MgRepositoryManager.AddResource() line 532 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\RepositoryManager.cpp
> - MgResourceContentManager.AddResource() line 178 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\ResourceContentManager.cpp
> - MgResourceContentManager.PutDocument() line 619 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\ResourceContentManager.cpp
> - MgResourceDefinitionManager.PutDocument
> (MgLibraryResourceContents.dbxml)() line 545 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\ResourceDefinitionManager.cpp
>
>
> System.Exception: The remote server returned an error: (559)
> MgDbXmlException.:
> An exception occurred in DB XML component.
> Error: DB_BUFFER_SMALL: User memory too small for return value
>
> - MgResourceServiceHandler.ProcessOperation() line 80 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\ResourceServiceHandler.cpp
> - MgOpApplyResourcePackage.Execute() line 96 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\OpApplyResourcePackage.cpp
> - MgServerResourceService.ApplyResourcePackage() line 815 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\ServerResourceService.cpp
> - MgLibraryRepositoryManager.ApplyResourcePackage() line 148 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\LibraryRepositoryManager.cpp
> - MgLibraryRepositoryManager.LoadResourcePackage() line 183 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\LibraryRepositoryManager.cpp
> - MgResourcePackageLoader.Start() line 145 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\ResourcePackageLoader.cpp
> - MgResourcePackageLoader.PerformOperation() line 223 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\ResourcePackageLoader.cpp
> - MgResourcePackageLoader.SetResource() line 303 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\ResourcePackageLoader.cpp
> - MgRepositoryManager.SetResource() line 559 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\RepositoryManager.cpp
> - MgRepositoryManager.AddResource() line 532 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\RepositoryManager.cpp
> - MgResourceContentManager.AddResource() line 178 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\ResourceContentManager.cpp
> - MgResourceContentManager.PutDocument() line 619 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\ResourceContentManager.cpp
> - MgResourceDefinitionManager.PutDocument
> (MgLibraryResourceContents.dbxml)() line 545 file
> c:\working\build_area\mapguide\3.1.2\x64\mgdev\server\src\services\resource\ResourceDefinitionManager.cpp
>
>  ---> System.Net.WebException: The remote server returned an error: (559)
> MgDbXmlException.
>    at System.Net.HttpWebRequest.GetResponse()
>    at OSGeo.MapGuide.MaestroAPI.HttpServerConnection.UploadPackage(String
> filename, StreamCopyProgressDelegate callback) in
> C:\projects\mapguide-maestro\OSGeo.MapGuide.MaestroAPI\Http\HttpServerConnection.cs:line
> 1511
>    --- End of inner exception stack trace ---
>    at OSGeo.MapGuide.MaestroAPI.HttpServerConnection.UploadPackage(String
> filename, StreamCopyProgressDelegate callback) in
> C:\projects\mapguide-maestro\OSGeo.MapGuide.MaestroAPI\Http\HttpServerConnection.cs:line
> 1525
>    at Maestro.Packaging.PackageBuilder.UploadPackage(String sourceFile) in
> C:\projects\mapguide-maestro\Maestro.Packaging\PackageBuilder.cs:line 183
>    at
> Maestro.Packaging.PackageProgress.<>c__DisplayClass10_0.<UploadPackage>b__0()
> in C:\projects\mapguide-maestro\Maestro.Packaging\PackageProgress.cs:line
> 175
>    at Maestro.Packaging.PackageProgress.backgroundWorker_DoWork(Object
> sender, DoWorkEventArgs e) in
> C:\projects\mapguide-maestro\Maestro.Packaging\PackageProgress.cs:line 395
>    at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
>    at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object
> argument)
>
> Based on previous threads, I've attempted to increase the following
> parameters in the serverconfig.ini file but have had no success.
>
> #SessionDBXMLPageSize = 0.5
> SessionDBXMLPageSize = 1.0
> #SessionDBPageSize = 2
> SessionDBPageSize = 4
> #SessionLogBufferSize = 1
> SessionLogBufferSize = 5
> #LibraryLogBufferSize = 12
> LibraryLogBufferSize = 24
> #DBXMLPageSize = 32
> DBXMLPageSize = 64
> #DBPageSize = 32
> DBPageSize = 64
>
> Has anyone else encountered this issue and have figured out a solution?
>
> Thanks,
> David
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20230414/73a2ff18/attachment.htm>