Database
Manage, update, and troubleshoot the database.
Access to a Database using PythonIn this article, we explore how to connect to and access a database using Python.
Check which database reports are running againstIn this article, we show how to check which database your environment runs reports against and where to find this configuration.
Creating a ReportDS datasource for connection to a report database instanceIn this article, we explain how to create a ReportDS datasource to connect to a Report database instance.
Database Table for Worker ReferencesIn this article, we explore where Person, Worker, and Organisation references are stored in the database and how to locate them.
Management of data values in database reports tableIn this article, we explain how to manage report table data, removing codes and updating values outside of defined domain constraints.
Nightly refresh schedule for the databaseIn this article, we explain when the nightly database refresh occurs.
Public API /v3/steps times out when unlocking an incomplete step (SQL Server)In this article, we explain why calling the /v3/steps API to create a subjectless step may timeout due to SQL query cancellation errors.
Request a refresh of live to non-live Alfresco databaseIn this article, we look at how to request a refresh or copy of the live Alfresco database into a non-live environment.
Requests for DBA/Infrastructure overnight tasks timings to be editedIn this article, we explain how to request edits to overnight server/database tasks like backups, refreshes, and restarts in Mosaic.
Retention date is unchanged in database table after date of birth updateIn this article, we explain why retention dates remain unchanged in the back end after a date of birth update.
Team workview current work not loading due to 2000+ different combinations of person and group records (SQL Server only)In this article, we explain why your current Team Workview might not be loading.
Updating database role permissionsIn this article, we explain how to change a database role's permissions.
Upper case letters in Street Name following an apostrophe (SQL Server only)In this article, we explain why letters appear in uppercase in street names after apostrophes.
Report on carer type approvalsIn this article, we explore why Business Objects reports may not return carer type approvals from DM_FOSTER_CARE_APPROVALS.
Availability of Linked ServersIn this article, we will advise if you are able to have Linked Servers.
Character limit for text fieldIn this article, we explain the character limits for each text field element type.
Checking whether reports have runIn this article, we explain how to check if any reports have been run using the appropriate query for your database type.
Cleardown processIn this article, we explain what the cleardown process is, and how it's done.
Log shipping and reports clone methodIn this article, we explain how reports run against a clone of Production and whether it's possible to run them directly on Prod.
Redgate MonitoringIn this article, we explain what's the Redgate Monitor process that runs on the database.
Remove CivicaIn this article, we look at how to remove MIS interface with Civica.
Remove Wisdom interfaceIn this article, we address the WISDOM error and advise removing its config from non-live after copying the live database.
Request the anonymisation scriptIn this article, we explain what the Mosaic anonymisation tool is and where to find it for use in data privacy workflows.
Stop a running job in OracleIn this article, we cover how to stop the DM Population Script, which is still running in Live and affecting system performance.
Creating and Disabling users in MSSQLIn this article, we look at how to create or disable a user in MSSQL.
Checking the database sizeIn this article, we explore how to check the size of your MOSPROD, MOSREP, and MOSDEV databases.
Troubleshooting
Find step-by-step solutions for resolving common issues.
Power BI permissionsIn this article, we explain why you might see an error when a database account doesn’t have the right permissions to run certain functions.
Unable to execute functions on a databaseIn this article, we explain issues with executing functions on Mostest and missing functions in the Mosprod database.
FW.XAK1MO error caused by pasting emojisIn this article, we explain the FW.XAK1MO error caused by pasting emojis into Mosaic form answers and how to avoid it.
Error: 'ORA-00001: unique constraint (FW.XPKDM_PLACEMENT_ADDRESSES) violated in Reports populate log'In this article, we explain why you might see an error in the Reports populate log and what steps you can take to resolve it.
Error: 'The DELETE statement conflicted with the REFERENCE constraint "RGENQSTPSRCHSRS_ENQSESTP_FK'In this article, we look at why when deleting a person records you get an error.
Error: 'Violation of PRIMARY KEY constraint 'XPKDM_CPO_SUMMARY'In this article, we explain the PRIMARY KEY violation error in the Reports log caused by duplicate keys in DM_CJ_CPO_SUMMARY.
Error: 'Violation of PRIMARY KEY constraint'XPKDM_FIN_DELIVERED_ACTUALS'In this article, we explain the PRIMARY KEY error in logs caused by duplicate key values in DM_FIN_DELIVERED_ACTUALS.
SQL job stopped due to errorIn this article, we explain how to resolve the 'EXECUTE AS USER' error that stops SQL Jobs when user 'fw' access fails in database 'XXXX'.
Error 'ORA-00001: Unique Constraint Violation' in Person Delete JobIn this article, we explain the STATUS = FAIL error in MO_PERSON_DELETE_REQUESTS due to a unique constraint violation.
Person deletion failsIn this article, we explain why person delete fails due to a conflict with the PAYMENTS_REAL_COMMIT_FK reference constraint.
Unable to start new relationship when one already existsIn this article, we explain why a new relationship can't be started when one exists but isn't visible on the front end.
Error: 'Communication link failure'In this article, we explain the SQL query error and timeout caused by a communication link failure and how to resolve it.
Error: 'No resources currently available in pool mosprodDS to allocate to applications'In this article, we explain how to resolve the mosprodDS pool error by increasing the connection pool size in WebLogic.
Impact of running the Costed Services (B13) report in production on system performanceIn this article, we explain why running the B13 report in production may cause system slowness or downtime.
Password does not meet the requirements -SQL server onlyIn this article, we explore why SQL Server shows a misleading password error when a user ID exception occurs in MSSQL.