Database
Manage, update, and troubleshoot the database.
By Yusef1 author41 articles
- 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.