-
IN DOCUMENT clause and a set function appear in the same SELECT."
HI All, I want to sum the r_link_cnt from dm_document(all) in document_id ('r_object_id) descend. select sum (r_link_cnt) from dm_document(all) in Document id('r_object_id') descend where r_link_cnt>=1; getting error like Error occured during query execution :[DM_QUERY_E_COMPOUND_FUNC]error: "IN DOCUMENT clause and a set…
-
DM_QUERY_E_COMPOUND_FUNC
HI All, I want to sum the r_link_cnt from dm_document(all) in document_id ('r_object_id) descend. select sum (r_link_cnt) from dm_document(all) in Document id('r_object_id') descend where r_link_cnt>=1; getting error like Error occured during query execution :[DM_QUERY_E_COMPOUND_FUNC]error: "IN DOCUMENT clause and a set…
-
DM_QUERY_E_COMPOUND_FUNC
HI All, I want to sum the r_link_cnt from dm_document(all) in document_id ('r_object_id) descend. select sum (r_link_cnt) from dm_document(all) in Document id('r_object_id') descend where r_link_cnt>=1; getting error like Error occured during query execution :[DM_QUERY_E_COMPOUND_FUNC]error: "IN DOCUMENT clause and a set…
-
xCP xCelarator homepage
Hi, In the past, the xCP xCelatoro homepage was on the EMC community. https://community.emc.com/docs/DOC-22566 https://community.emc.com/docs/DOC-6143 currently these are not available any more Anybody knows if this will be moving to the OpenText forums ? Or anybody knows where we can download the latest ones ? Many thanks…
-
Audience presentation not working for Countries
I have created a custom component with targeting rule pointing to an Audience in various countries. When i publish on my production environment, the rules are not being evaluated to true in my scenarios. For example , if i do "Audience NOT = UNited States", i still see my component if i am viewing in united states. This is…
-
Docbase creation fails on 16.4 running on RHEL 7.6
Hi Team, We are trying to setup new Documentum 16.4 content server on Rhel 7.6, During docbase creation we are getting below error. Opentext says is Documentum 16.4 not unsupported with RHEL 7.6. Any successful installation on RHEL 7.5 or above ?. Error in docbase log. Thu Dec 20 15:54:24…
-
Exception in getProjects call, for EStudio
Hello, I’ve just made a TeamSite16.4.1. installation on a new server and then brought in a pre-existing content-store (+ templating.cfg etc), prior to installing the Runtime as I think this is the best way to get the content I want on a new server with TS16.4.1. CCPRo is working well, but when I go to EStudio no projects…
-
DQL Query to find out Length of Object name
Hello all, I need help with below queries: 1.) Is there any way using DQL query that I can find the length of the object name in a cabinet? 2.) I know r_folder_path is a repeating attribute, but can I get the length of the folder path for a document object? I have tried using select len(object_name) from dm_document select…
-
Read, using DQL, a particular attribute of a specific document type
Document name: myPdf.pdf Type: xx_record Format: pdf This document has a particular attribute name called event date. How do I go about reading the value of the document using DQL? Thanks in advance
-
list box parameter in report not working
Hello, I'm beginner at Birt. I found an example to create a report where we can display parameter in a list box. The problem is that when I select the one choice in the select list, the report doesn't work (it always display all the data). In attached the rptdesign. Can anyone help me to find a solution ? Thanks,
-
HTML5 chart export pdf issue
Hi, HTML5 charts are not exported as expected in pdf. bars are cutting the xAxi. I tried all the options but no luck. here is the screenshot. I am using iHub 16.4 version. the behaviour is same when we export from designer or server
-
D2 Login page - div id username and password persistent ?
Hello, i use D2 (version 4.2) in my entreprise and i would like to use a service of my IT department to automate the login process. This service allows to fill automatically the fields "Username" and "Password" of my D2 web application login page. For that, i have to give them the name of the div id of my two html input…
-
Dql query for count of linked documents in a cabinet
Hello all, I need a DQL query for count of linked documents in a cabinet.
-
Press Enter for a Button in xCP Designer
Hi, I am trying to implement a project using xCP Designer. I am creating a form and want to perform some operations using a button. I can achieve my wish by clicking that button. However, I want to use the Enter Key as action trigger. Or, in other words, when the user press Enter from the keyboard for button clicking, I…
-
Upgrade TS from 7.5 to 16.4.x
Hi, My company is planning to upgrade TS from 7.5 to 16.4.x. If you have done similar upgrade, could you please share these details. How was your experience? Could you please share what kind of challenges you face? What approach worked for you? Thanks
-
Dql query
I need a DQL query to find all the linked documents in a cabinet. When I am counting the number of documents in a cabinet, I am getting different results when I use i_cabinet_id and when I use Folder ('/Temp', descend) Which one will give the correct answer?
-
How to hide BIRT report columns when no data
Hi, I have a birt report which displays more than hundred columns. When any of the column has no data, I want to hide the header and detail of the column. I tried using Hide in properties and it did not work. Can some one help. Thanks
-
How to integrate iHub Server with OTDS
Hello Friends, Is there any document/link on how to integrate iHub server with OTDS for user authentication ? I have a web application which is already integrated with OTDS so when user access the application, it first gets redirected to OTDS for authentication and after successful authentication , it gets redirected to…
-
Applying D2 LifeCycle Method to multiple selections in Doclist
Hello! Is it possible to initiate lifecycle for multiple selected documents in the doclist widget ? In my lifecycle implementation, I've created a custom job and it has to be initiated for all the documents selected but at this moment, its getting applied only to the document which is selected first. I've even created a…
-
Displaying A non Persistent field from a table in BIRT
HI Guys, I am designing a very simple report in BIRT for Maximo 7.6.1 .The tables that are used in this INVOICE and INVOICECOST Table in Maximo database. The Column and the Fields that are going to be displayed in the report are as follows INVOICE.UNINVOICEDTOTAL The problem here is that UNINVOICEDTOTAL table does not have…
-
Webtop 16.4 "Email as link" not working
Hello Experts, This is the first time I am posting something in OpenText forums, kindly route the query to correct group if I have placed it at wrong community. This is an urgent query, kindly help : We are upgrading webtop to version 16.4. It has 2 installation which need admin rights: WentopBHO installer and WDKNativeCAB…
-
Issue with UserProfile. "iwpers_user" table object is not available.
Hi, Installed Teamsite 16.4 recently. To validate installation created a sample site with user validation. But the validation is failing with exception as shown below. Tried to check the DBs but don't see any table with name "iwpers_user". Can anyone please suggest if any solution available for the above mentioned issue.…
-
Exactly look for a pdf in a emc documentum using rest api using dql
Im trying to use dql. My objective was to search for a pdf. For example the naming conventions of pdfs are like amd-1-prot MA-NI-123-1234.pdf or prot MA-NI-123-1234.pdf. I was able to search the exact folder using the dql query \dql?=select * from dm_folder where object_name="fOLDER_NAME". I dont know how to search for…
-
When I am trying to change the in user_database.xml , the teamsite users are not able to login.
Hi, When I am trying to change the in user_database.xml , the teamsite users are not able to login. It throws error "Wrong username/password". when I checked the logs of iwtrace.log the error is "ERROR:'Can't contact LDAP server' in binding to (ldap.xyz.com) on port 636” though telnet to ldap is working fine. Please help..
-
DFC session count
Is there a way to count number of sessions in DFC client? I know we can set the max_count in dfc.properties which should never exceed number of sessions set in server.ini. In the Method Server, can we count those DFC active sessions? In a custom client DFC program, can we count number of active DFC sessions. I know about…
-
Making our leap from 7.5 to 16.4, any real world experience with using legacy wfts in new versions?
My company is finally going to upgrade our TS system from 7.5 to 16.4.X. One of our major concerns is the backward compatibility with our legacy wfts, tpls, and custom IPLs. Has anyone used legacy wfts, dcts, tpl in the newer 16.4 systems? Of course I do expect some pains in getting the legacy stuff ported over, but I'm…
-
Extra Arguments with Lifecycle Entry Condition Custom Method check D2
Hello! I wrote a custom method to check certain attributes and prerequisites and I'm giving couple of arguments with values but when I submit the documents through this Lifecycle, method does trigger but it's not able to read these arguments which I'm passing. I cleared JMS cache, D2 app server cache and restarted docbase…
-
Migration issue
Hi all, We recently migrated a workarea, which contains 2 sites, from one TeamSite environment to another. One of the sites is a SitePublisher site, the other was done with ExperienceStudio. To migrate this workarea, we simply copied and pasted the folder /iwmnt/default/main/ from one server to the other. This indeed…
-
How to reset variable to be reused in crosstab measure?
I have a crosstab that i want to calculate the ratio of the two values that display per group. i created a global variable on the report onprepare event to capture the data in an array: var ascsil = new Array(); reportContext.setPersistentGlobalVariable("ascsil", ascsil); Then, on the measure in the crosstab i added the…
-
How to sort X-Axis of Bar chart in Custom order.
Hello, I have to display a bar chart. In the dataset i have an custom ordered column values. When i have used that dataset to the chart it was displaying that column values in x-axis. But it was getting ordered in Alphabetical order. But it need to be get displayed in custom order as i have given in sql. Please anyone help…