-
Date(Yesterday) function
Hello All, My current query is select count(*) from dm_user where r_creation_date > DATE('09/01/2019 21:00:00','mm/dd/yyyy HH:MM:SS') BUT, instead of explicitly specifying the date I want to use date (yesterday) in the above query without changing anything else. This is the requirement. Eg: select count(*) from dm_user…
-
display data in BIRT
Dear Open text community, I am new to birt and sql, kindly be with me if its a very basic question for u. I have two tables in DB 1.COMPANY- companyid, name, phone, address, and other info 2.COMPANY_OWNER- company id, ownername , percentage share my requirement is as below display a simple table report ,one row per company…
-
Change State Task Failed in D2 Lifecycle
Hi, I have automated my business process using workflows and lifecycle combination in D2-Config. In workflow design, the automated activity represents the lifecycle's state. When the automated activity (ie lifecycle state change) is executed post first manual approver, I see change task state failed message with below JMS…
-
Can someone give me access to this resource
https://forums.opentext.com/forums/discussion/173736/documentum-rest-services-tutorials-fundamentals-and-essentials my user id is - gsakthivel@systemautomation.com
-
BIRT_retrieving Data (from Data sets) in scripted Chart
Hello everyone, I'm using BIRT All-in-one Version working on a report where i created a chart using script. I added a chart through Chart-builder( any charts type), and then went to the script button and in the beforeGeneration() i coded the chart and changed it's type to Bar chart When you open my attached report, you'll…
-
Corrupt PDF and TIFF file issue with files uploaded to AWS S3 using Documentum
Hello Experts, I had created a storage through Storage Management (in DA) using AWS S3 URL, Access Key ID, and secret key. Mapped this storage to a custom type and was able to upload and download the files to/from S3 bucket. I tried file upload for following formats .txt, .pdf, and .tiff and I noticed .pdf and .tiff files…
-
Oracle 9.2.0.8 compatibility with Content Server 5.3 SP1
Subject: Is Oracle 9.2.0.8 compatible with CS 5.3 SP1 ? Hello, We are running CS 5.3 SP1 on Windows Server 2003 and with Oracle DB version 9.2.0.6. We are looking at bringing Oracle version up to 9.2.0.8 (Oracle’s “terminal release” for that version). If the DB is upgraded to 9.2.0.8, is this compatible with 5.3 SP1? Has…
-
Documentum Server 16.4 Oracle DB Settings
Hi All, Iam planning to install Documentum server 16.4 by using Oracle 12C Database. As per Installation guide i could see below requirements to install Oracle DB instance. Iam not sure what values i need set for these environment variables. If any one installed 16.4 with Oracle DB, Kindly suggest me the values that i can…
-
D2 Smartview Error
Deployed Documentum d2 smart view in tomcat server. It is displaying the below error "Failed loading the application. Please contact the administrator." Can anyone help me with this? Thanks, Ganesh P.
-
Documentum D2- Security Update
can i update the security on a particular set of documents or on a single document from the D2 config based on users requirement. If yes, how? if not, why?
-
CSV file document File properties showing error - Failed to open MS office Item
Hi Experts, We uploaded .Docx & .CSV file into content server, but while checking file properties of .CSV file it showing as Failed to open MS office item where as .docx file properties showing app name, Author and other option. Pls suggest is that any config missing or how we can rectify that error in file properties.…
-
OpenText Rest Api Error
Error : Access to XMLHttpRequest at 'http:///api/v1/auth' from origin 'http://localhost:3002' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource. While calling OpenText Rest Api throwing above error using below code : var otcsticket = ''; $.ajax({ // Authenticate…
-
Remove Supplemental Markings using CWS/REST API ?
How to remove Supplemental Markings?
-
Making xCP preview mode a privileged dfc client
Our xCP web app relies on being a privileged dfc client (uses the dm_superusers_dynamic role). When I try to use the preview mode in xCP, it fails with: The requested role (dm_superusers_dynamic) is marked protected and the requesting application was either not known in this docbases dm_client_rights table or its…
-
How to display three different tables columns in a single bar chart?
Hello team, Could you please tell me how to display three different tables columns in a single bar chart. If so, please help me how to do it. Thanks in advance.
-
xCP 16.4 Application – Advanced Viewer is not working in Chrome Browser (version 76)
Hi, We are implementing xCP Advance Viewer in xCP 16.4 version. The application is working as expected but the xCP Advance viewer (Brava HTML Viewer) is not working in Chrome Browser(version 76). it is working in Edge and FireFox as expected. Please fine the Chrome Browser console error below, Appreciate any pointers to…
-
java.io.ioexception invalid constant type :15 Error while logging into DA
While logging into Documentum Administrator, below exception is being thrown: java.io.ioexception invalid constant type :15 JAVA_Version : Tried on both 7 and 8. Not working in both.
-
BIRT: Highlighting the Series Label of the max Value in a bar-Chart
Hello everyone, I'm working on a report using BIRT All-in-one-version. Is there any way using scripting to highlight the max value of the Series Label of the bar? Please Take a look at this example in order to understand what i want. Would be grateful if i could get some Help Khaled
-
Shellscript for running DQL commands
Hi everyone, I need to create a shellscript to run a few DQL commands on unix environment, but I dont know how to run/use DQL commands via shellscript. Any ideas on how I can do this? (Example scenario: first run select query and then use result of that in update dql query in shell script)
-
Count of files in a Cabinet (DQL)
Howdy, What DQL query can i use to get a count of all files in a Cabinet? Thanks!
-
Documentum 7.3: Duplicate Docbase ID
I have a full working Documentum system having Content, Application, Rendition, Index and Database server working with one repository. Now we have cloned all the VM servers and restore all of them. After restoration, we have changed the IP address of the server and all the configuration of the server and created a new…
-
Recover deleted folder
Hi All, I need to recover a deleted folder for a user and know where the folder was including the name. Can you provide me a simple DQL query with example? dmFileScan and dmClean have not been active for a year so that should make it easier i would think. I searched the forums and there is a lot of information about this…
-
Opentext Big Data Analytics
Hi, wondering if anyone help me with OpenText's Big Data Analytics. Trying to get the AVG of 6 columns loaded in FastDB. Kinda got stuck.
-
Cascading new ACL Name to existing folder and files
Hi All, Basically what the title says. I have a Folder that needs to be restricted to a certain group but the issue is the current ACL Name is associated with the entire company, and everyone has access. I created a new ACL Name and Group which will include only a handful of users. In the Folder properties I changed the…
-
I want to download a new version of Actuate BIRT reporting tool (open source)
Hello Team, Good day! I would like to download a new version of Actuate BIRT reporting tool (open source) and to use it. But I didnt have good knowledge in downloading the latest version. Could anyone of you please provide me the link to download the free BIRT tool. Thanks in advace.
-
D2 Job
How can I increase the timelimit for any job in D2. I am facing timeout error for a D2 Job.
-
Documentum Workflow Tracking
Hello, In webtop or DA, for workflows, you can go to inbox for a particular workflow task and then in the progress TAB you can see the History of the Workflow, which shows the activity names, whether they have been finished/acquired etc. performer names and Dates. We don't have any workflow auditing enabled in our…
-
orphan Oscript
Hi I need to modify Action-PermissionsView in WEBNODE::WebNode::DefaultWebNode. I did the orphan of Action-PermissionsView but when I do debug it doesen't execute my function have you suggestion ? thanks
-
What are the system requirements needed to install the Opentext birt tool
Hello Team, Good day! I would like to install the Opentext birt tool in my system. Could you anyone of you please tell me what are the system requirements needed to install the tool in my Windows OS. Thanks, Sai
-
Questions about BPM Integration with TeamSite
Hi, We want to use BPM to automating the tasks. Can any one briefly explain how to integrate BPM with TeamSite? We are using TeamSite 16.4 (Windows Environment with IIS). Thanks,