Infrastructure at your Service


Troubleshooting Archives - Page 2 of 5 - Blog dbi services

Gérard Wisson

Documentum story – dm_LogPurge and dfc.date_format

By | Entreprise content management | No Comments

What is the relation between dfc.date_format and dm_LogPurge? This is the question we had to answer as we hit an issue. An issue with the dm_LogPurge job. As usual once a repository has been created we are configuring several Documentum jobs for the housekeeping. One of them is the dm_LogPurge. It is configured to run once a day with a cutoff_days of 90 days. So all ran fine until we did another change. On request of…

Read More
Stephane Biehler

Documentum Administrator UCF Troubleshooting

By | Application integration & Middleware | 2 Comments

Maybe you had some issues with UCF in DA as me. I had this for no reason since few days at a customer. The problem was that we use SSL with DA and the Unified Content Facilities (UCF) wasn’t happy about it. Thus, in this short blog I’ll speak about troubleshooting UCF. The error I got happened when trying to edit, view or create documents; I had a popup saying an error occured with UCF….

Read More
Stéphane Haby

SSISDB is too big and it is not every time the retention period’s fault!

By | Database Administration & Monitoring, Database management, Technology Survey | 4 Comments

In all blogs that I read, the solution is just to change the retention period to a reasonable value. Yes, it is true but in some case you need to go deeper in the analysis… Like you, I changed the retention period, ran the cleanup but finally, I had always a big database… Why, Why, Why? My first step for this analysis, is to see in the SSISDB, the Disk Usage by Table Reports from…

Read More
Daniel Westermann

quickly exchange code or text between workstations or teams

By | Database management | One Comment

In a recent project I faced the following situation: One the one hand I had to execute scripts on a customer’s workstation while on the other hand I had to integrate the results of these scripts into a report on my own workstation. The question was how to efficiently do this without sending dozens of mails to myself. One solution would be to create one script which produces all output and send the results by…

Read More
Oracle Team

Oracle OPatch and “Archive not applied” error

By | Database management | One Comment

Recently, I have installed an Oracle RDBMS on a server, and I wanted to install the latest Patch Set Update (PSU) from October 2014. During the execution, I fell on the error “Archive not applied” and the job failed. This is how to quickly fix this issue. While installing the PSU from October 2014 on my Oracle database server, I experienced the following error: The following actions have failed: Archive not…

Read More
Gérard Wisson

Documentum upgrade project – ActiveX and D2-Client 3.1Sp1

By | Application integration & Middleware | No Comments

This is another blog posting an our Documentum upgrade project. This time, the following issue occured: the ActiveX could not be installed using the D2-Client. We had to access the D2-Config url to have it installed. For a normal user, this could not be used. Analyzes The workstation had the ActiveX for D2 3.0 installed, the version before the upgrade. Under C:\Windows\Downloaded Program Files, we had: ctx ctx.ocx D2UIHelper.dll On my workstation where I could…

Read More
David Barbarin

SQL Server 2014: sys.dm_exec_query_profiles, a new promising feature

By | Application integration & Middleware | 3 Comments

Among the hidden features provided by SQL Server 2014 there is a very interesting dynamic management view named sys.dm_exec_query_profiles. This feature will help the database administrators and experienced developers to troubleshoot long running queries in real-time. I’m pretty sure you had to deal with the following questions: When will this query finish? What percentage of total workload is performed by this request? Which steps are the longest? Before SQL Server 2014 it was impossible to…

Read More