{"id":17820,"date":"2022-07-15T20:26:06","date_gmt":"2022-07-15T18:26:06","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=17820"},"modified":"2025-10-24T09:38:36","modified_gmt":"2025-10-24T07:38:36","slug":"db-crawler-a-database-search-utility-for-documentum","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/","title":{"rendered":"db-crawler, a database search utility for Documentum"},"content":{"rendered":"

Working with Documentum is often a frustrating experience, and one of the main causes is the lack of meaningful error messages. Be it an encouragment to the administrator or developer to refer to the official knowledge base or a gap in the user-friendliness department, this results in the dreaded venture of investigating the origin of the error, which can take hours if not days of laborious and boring work with little chance for a reward, all the while end users are complaining that nothing works any more.
\nThe last time I was confronted to this situation, the error looked quite benine at first:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
1 May 2022 11:33:23,580 ERROR [pool-3-thread-93] (DCTMNewRendition.java:98) - Unable to save document with <\/code>id<\/code>: 090f4517812cbdc7. Got a Dctm Exception<\/code><\/div>\n
com.documentum.fc.client.DfIdNotFoundException: [DM_API_E_EXIST]error:\u00a0 <\/code>\"Document\/object specified by 080f451780000491 does not exist.\"<\/code><\/div>\n
at com.documentum.fc.client.impl.docbase.DocbaseExceptionMapper.newException(DocbaseExceptionMapper.java:49) ~[dfc.jar:?]<\/code><\/div>\n
at com.documentum.fc.client.impl.connection.docbase.MessageEntry.getException(MessageEntry.java:39) ~[dfc.jar:?]<\/code><\/div>\n
at com.documentum.fc.client.impl.connection.docbase.DocbaseMessageManager.getException(DocbaseMessageManager.java:137) ~[dfc.jar:?]<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Just dump the above document with id 090f4517812cbdc7 and look at its permission, the parent folder’s ones, see if the current user is allowed to save the document, nothing particularly transcendent, right ? Wrong. Firstly, the given id is not the same as the current document’s that is being saved. So, where did the server pull it from ? Secondly, an attempt at dumping that id confirms that it does not exist. Now, the nightmare begins. It’s kind of like you just entered the twilight zone actually. Inconsistencies such as this one are difficult to troubleshoot and the crude error message was for sure of no help. I first hypothesized that the given id was somehow linked to the current document either through a relationship or a tbo somewhere but the developers confirmed that they had configured none. So the next obvious step is to doubt them and prove them wrong, and to do this the whole repository had to be searched for that id because somewhere in a type, deeply buried in some attribute, that id had to be contained, referencing the document to be saved, either as a standalone value or embedded in some string. This was challenging enough for me to write this little one-liner – the db-crawler – to search for that string in the whole docbase, actually the whole schema, i.e. at the database level since working from the RDBMS gives access to a considerably much richer set of functions, and this is what I’m going to show you in the next paragraph. To close this anecdotic introduction, I’ll just say that I did found a few occurrences of the given id but they lead nowhere. The actual root cause was a bad DFC cache that somehow desynchronized from the repository and went its own way. The morale of the story is that whenever one encounters weird error messages, the first thing to try is to empty the DFC cache because it probably became stale at some point (maybe the repository was upgraded, new applications deployed, doctypes modified, etc.). The good thing, as it seems there is always some benefit to even the peskiest situations, is that I had the opportunity to dust an ancient technique and share it with you here.<\/p>\n

The crawler<\/h3>\n

As the RDBMS used by that repository was Oracle, we’ll work mainly from within the powerful command-line tool sql*plus. The trick to crawl the database schema is first to get the name of the tables of interest from the dictionary. With Oracle, the view USER_TAB_COLS is the one to consult. Here are the most useful columns:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n<\/td>\n
\n
\n
sqlplus scott<\/code>\/tiger<\/code>@orcl<\/code><\/div>\n
SQL> desc USER_TAB_COLS<\/code><\/div>\n
\u00a0<\/code>Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Null?\u00a0\u00a0\u00a0 Type<\/code><\/div>\n
\u00a0<\/code>----------------------------------------- -------- ----------------------------<\/code><\/div>\n
\u00a0<\/code>TABLE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NOT NULL VARCHAR2(128)<\/code><\/div>\n
\u00a0<\/code>COLUMN_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NOT NULL VARCHAR2(128)<\/code><\/div>\n
...<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

That view contains one row for each column of each table in the user’s schema. So the crawler just has to get the names of all the columns of all the relevant tables returned by USER_TAB_COLS and generate a SELECT statement against those columns with the string to look for as the condition, e.g. the object id 080f451780000491 from the docbase. Here is how:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
select<\/code> 'select '<\/code> || COLUMN_NAME || <\/code>' from '<\/code> || table_name || <\/code>' where '<\/code> || COLUMN_NAME || <\/code>' like '<\/code>'%080f451780000491%'<\/code>';'<\/code> from USER_TAB_COLS where (table_name like <\/code>'%\\_S'<\/code> escape <\/code>'\\' or table_name like '<\/code>\\_%\\_R<\/code>' escape '<\/code>\\') order by 1;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

The relevant tables are the ones that Documentum uses to store the object’s metadata and other technical data, typically the tables ending by _S for single-valued attributes and _R for repeating attributes. All the other objects in the schema, such as the ones named like %_SP or %_SV, are views built upon the previous tables are can therefore be ignored.
\nFor more sophisticated searches, regular expressions are better suited, as shown below:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
select<\/code> 'select '<\/code> || COLUMN_NAME || <\/code>' from '<\/code> || table_name || <\/code>' where regexp_like('<\/code> || COLUMN_NAME || <\/code>', '<\/code>'080f451780000491'<\/code>');'<\/code> from USER_TAB_COLS where (table_name like <\/code>'%\\_S'<\/code> escape <\/code>'\\' or table_name like '<\/code>\\_%\\_R<\/code>' escape '<\/code>\\') order by 2, 1;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Oracle’s regular expressions are quite complete because in addition to being POSIX-compliant, they also support the perl’s non-greedy syntax; see the SQL Reference Manual for details. In the present case, we don’t have many details about the context of the given id so we use the widest possible criteria in our search, and the traditional LIKE pattern-matching condition would be plenty sufficient but let’s switch to regular expressions for generalization (too much is better that not enough, right ?).
\nThe above statement will output a list of SELECT statements, one per column to search, as illustrated below:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n<\/td>\n
\n
\n
select<\/code> ACCESSOR_NAME from DM_AUDIT_POLICY_S where regexp_like(ACCESSOR_NAME, <\/code>'080f451780000491'<\/code>);<\/code><\/div>\n
select<\/code> ACL_CLASS from DM_ACL_S where regexp_like(ACL_CLASS, <\/code>'080f451780000491'<\/code>);<\/code><\/div>\n
select<\/code> ACL_CLASS from DM_AUDITTRAIL_ACL_S where regexp_like(ACL_CLASS, <\/code>'080f451780000491'<\/code>);<\/code><\/div>\n
select<\/code> ACL_DOMAIN from DMI_TYPE_INFO_S where regexp_like(ACL_DOMAIN, <\/code>'080f451780000491'<\/code>);<\/code><\/div>\n
select<\/code> ACL_DOMAIN from DM_AUDITTRAIL_S where regexp_like(ACL_DOMAIN, <\/code>'080f451780000491'<\/code>);<\/code><\/div>\n
...<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

In order to execute them at once, they must be enclosed in an SQL script so let’s add some sugar. Still from within sql*plus:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n<\/td>\n
\n
\n
spool db-crawler.sql<\/code><\/div>\n
select<\/code> 'select '<\/code> || COLUMN_NAME || <\/code>' from '<\/code> || table_name || <\/code>' where '<\/code> || COLUMN_NAME || <\/code>' like '<\/code>'%080f451780000491%'<\/code>';'<\/code> from USER_TAB_COLS where (table_name like <\/code>'%\\_S'<\/code> escape <\/code>'\\' or table_name like '<\/code>\\_%\\_R<\/code>' escape '<\/code>\\') order by 1;<\/code><\/div>\n
spool off<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Finally, let’s execute the generated sql script and capture its output into a file:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n<\/td>\n
\n
\n
spool db-crawler.out<\/code><\/div>\n
@db-crawler.sql<\/code><\/div>\n
spool off<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

The output is redirected to the file db-crawler.out and can be searched using the familiar commands e?grep with the same search string as in the SQL statement.<\/p>\n

Other RDBMS supported by Documentum, such as SQL Server and PostgreSQL, obviously have their own dictionary (sys.tables respectively information_schema) and official administration tools (sqlcmd respectively psql),\u00a0 and thus the same technique can be applied to them.<\/p>\n

Some enhancements<\/h3>\n

As we work inside sql*plus for Oracle RDBMS, let’s make the most of this tool. sql*plus allows us to factor out the searched string using a substitution variables, as follows:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
define search_string = <\/code>\"080f451780000491\"<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

It will be referenced in the script through &search_string<\/em>. This way, the search string can be edited easily without directly modifying the query’s code, always a good practice in scripting and programming.
\nAlso, some formatting of the sql*plus output is needed to remove spurious headers, line-wrapping and trailing blanks; we’ll do this using set statements and the sed command-line utility.
\nBefore executing it, the generated sql script can be cleaned a bit by removing non executable lines such as sql*plus command output, still inside sql*plus:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
!<\/code>vi<\/code> db-crawler.sql<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Putting everything together plus some additional formatting instructions, we get:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n<\/td>\n
\n
\n
define search_string = <\/code>\"080f451780000491\"<\/code><\/div>\n
spool db-crawler.sql<\/code><\/div>\n
set<\/code> pagesize 0<\/code><\/div>\n
set<\/code> linesize 1000<\/code><\/div>\n
set<\/code> trims on<\/code><\/div>\n
set<\/code> term out<\/code><\/div>\n
select<\/code> 'select '<\/code> || COLUMN_NAME || <\/code>' from '<\/code> || table_name || <\/code>' where '<\/code> || COLUMN_NAME || <\/code>' like '<\/code>'%&search_string%'<\/code>';'<\/code> from USER_TAB_COLS where (table_name like <\/code>'%\\_S'<\/code> escape <\/code>'\\' or table_name like '<\/code>\\_%\\_R<\/code>' escape '<\/code>\\') order by 1;<\/code><\/div>\n
spool off<\/code><\/div>\n
!<\/code>vi<\/code> db-crawler.sql<\/code><\/div>\n
spool db-crawler.out<\/code><\/div>\n
@db-crawler.sql<\/code><\/div>\n
spool off<\/code><\/div>\n
less<\/code> -S db-crawler.out<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

That’s a lot of typing so look down below for an easy to use wrapper script.<\/p>\n

One use case: looking for IP addresses<\/h3>\n

Let’s seach the whole repository’s schema for any ip v4 address expressed as a dot-separated list of 4 quadruplets of 1-byte numbers each. This is useful for example when they should be replaced by their host name counterparts for portability.
\nThe regular expression for an IP adress is:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n<\/td>\n
\n
\n
([01]?[0-9][0-9]?|2[0-4][0-9]|25[0-5])\\.([01]?[0-9][0-9]?|2[0-4][0-9]|25[0-5])\\.([01]?[0-9][0-9]?|2[0-4][0-9]|25[0-5])\\.([01]?[0-9][0-9]?|2[0-4][0-9]|25[0-5])<\/code><\/div>\n
<\/div>\n
# or shorter:<\/code><\/div>\n
(([01]?[0-9][0-9]?|2[0-4][0-9]|25[0-5])\\.){3}([01]?[0-9][0-9]?|2[0-4][0-9]|25[0-5])<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

IP v6 addresses are similarly constructed, except the list is an octuplet of colon-separated 16-bit words expressed in hexadecimal:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n<\/td>\n
\n
\n
[A-F0-9]{1,4}:[A-F0-9]{1,4}:[A-F0-9]{1,4}:[A-F0-9]{1,4}:[A-F0-9]{1,4}:[A-F0-9]{1,4}:[A-F0-9]{1,4}:[A-F0-9]{1,4}<\/code><\/div>\n
<\/div>\n
# or shorter:<\/code><\/div>\n
([A-F0-9]{1,4}:){7}[A-F0-9]{1,4}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

So, to look for any hard-coded IP v4 address in a complete repository’s schema, we would only set the variable search_string to the above regexp and use the regexp_like condition, as follows:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n<\/td>\n
\n
\n
define search_string = <\/code>\"([01]?[0-9][0-9]?|2[0-4][0-9]|25[0-5])\\.([01]?[0-9][0-9]?|2[0-4][0-9]|25[0-5])\\.([01]?[0-9][0-9]?|2[0-4][0-9]|25[0-5])\\.([01]?[0-9][0-9]?|2[0-4][0-9]|25[0-5])\"<\/code><\/div>\n
spool db-crawler.sql<\/code><\/div>\n
set<\/code> pagesize 0<\/code><\/div>\n
set<\/code> linesize 1000<\/code><\/div>\n
set<\/code> trims on<\/code><\/div>\n
select<\/code> 'select '<\/code> || COLUMN_NAME || <\/code>' from '<\/code> || table_name || <\/code>' where regexp_like('<\/code> || COLUMN_NAME || <\/code>', '<\/code>'&search_string'<\/code>');'<\/code> from USER_TAB_COLS where (table_name like <\/code>'%\\_S'<\/code> escape <\/code>'\\' or table_name like '<\/code>\\_%\\_R<\/code>' escape '<\/code>\\') order by 1;<\/code><\/div>\n
spool off<\/code><\/div>\n
!<\/code>vi<\/code> db-crawler.sql<\/code><\/div>\n
spool db-crawler.out<\/code><\/div>\n
@db-crawler.sql<\/code><\/div>\n
spool off<\/code><\/div>\n
less<\/code> -S db-crawler.out<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Still in sql*plus, let’s grep the output file db-crawler.out using the same regexp and from the sql*plus environment:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n<\/td>\n
\n
\n
SQL> !<\/code>egrep<\/code> '&search_string'<\/code> db-crawler.out<\/code><\/div>\n
6.5.0.033<\/code><\/div>\n
6.5.0.031<\/code><\/div>\n
6.5.0.031<\/code><\/div>\n
6.5.0.031<\/code><\/div>\n
6.5.0.031<\/code><\/div>\n
6.5.0.031<\/code><\/div>\n
6.5.0.031<\/code><\/div>\n
6.5.0.278SP2P2400<\/code><\/div>\n
6.5.0.037<\/code><\/div>\n
6.5.0.037<\/code><\/div>\n
6.5.0.150<\/code><\/div>\n
5.3.0.0<\/code><\/div>\n
aspose-email-4.4.0.0-jdk16.jar<\/code><\/div>\n
castor-0.9.5.3.jar<\/code><\/div>\n
\/app\/dctm\/product\/16<\/code>.4<\/code>\/lib\/castor-0<\/code>.9.5.4-xml.jar<\/code><\/div>\n
\/app\/dctm\/product\/16<\/code>.4<\/code>\/install\/composer\/workspace\/MailApp\/bin\/content\/19\/-740608919\/aspose-email-4<\/code>.4.0.0-jdk16[1].jar<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Some manual editing is necessary here as the above regexp also matches strings such as these, which are obviously version numbers of the content server’s components. Fortunately, in the present case, those are rare.
\ngrepping can also be done from the shell’s command-line as follows:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
$ <\/code>egrep<\/code> \"([01]?[0-9][0-9]?|2[0-4][0-9]|25[0-5])\\.([01]?[0-9][0-9]?|2[0-4][0-9]|25[0-5])\\.([01]?[0-9][0-9]?|2[0-4][0-9]|25[0-5])\\.([01]?[0-9][0-9]?|2[0-4][0-9]|25[0-5])\"<\/code> db-crawler.out<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Factoring the search string regexp, especially such complex ones, would increase the readability and lesser the likelihood of typing or copy\/pasting mistakes. See down below for a wrapper that takes into account the above point, all the sql*plus statements and the final grepping.<\/p>\n

Looking for dates<\/h3>\n

Let’s now look for all the attributes containing a date. While the format of a displayed date depends on the current locale, dates are stored using the database’s internal format, which is likely some binary one, e.g. a counter of elapsed seconds since some reference date in the past. However, our search expression directly accesses the attribute, which is silently converted to a string by the database server using some criteria (e.g. the time zone and locale). We need therefore to force the date column to a representation that can be compared to the given search string. The easiest way to do this is to tell the sql*plus session to format dates using a conventional, common format which we will also use in the search string, as shown below:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
-- force the <\/code>time<\/code> zone to UTC;<\/code><\/div>\n
ALTER SESSION SET TIME_ZONE = <\/code>'0:0'<\/code>;<\/code><\/div>\n
<\/div>\n
-- force the <\/code>date<\/code> representation to a conventional <\/code>format<\/code>:<\/code><\/div>\n
alter session <\/code>set<\/code> NLS_DATE_FORMAT = <\/code>'DD\/MM\/YYYY HH24:MI:SS'<\/code>;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

A regular expression for this date format could be:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n<\/td>\n
\n
\n
[0-9]{2}\/[0-9]{2}\/[0-9]{4} [0-9]{2}:[0-9]{2}:[0-9]{2}<\/code><\/div>\n
<\/div>\n
# or more precisely but without checking its validity during leap years:<\/code><\/div>\n
([1-9]|1[0-9]|2[0-9]|3[01])([1-9]|1[0-2])([1-9][1-9]+)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

A popular date format in IT is the basic ISO one:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
alter session <\/code>set<\/code> NLS_DATE_FORMAT = <\/code>'YYYYMMDDHH24MISS'<\/code>;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

but it is less user-friendly so we won’t use it here.
\nHowever, forcing the session date format only works when comparing stand-alone values in date columns, and not always for a date embedded in strings where it may have been converted to some format by the application or the content server itself. For example, the following values are returned from my test repository:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>select<\/code> OBJECT_NAME from DM_AUDITTRAIL_S where regexp_like(OBJECT_NAME, <\/code>'2022'<\/code>);<\/code><\/div>\n
2<\/code>\/18\/2022<\/code> 19:41:29 dm_DataDictionaryPublisher<\/code><\/div>\n
2<\/code>\/18\/2022<\/code> 19:41:29 dm_DataDictionaryPublisher<\/code><\/div>\n
2<\/code>\/18\/2022<\/code> 19:41:29 dm_DataDictionaryPublisher<\/code><\/div>\n
2<\/code>\/12\/2022<\/code> 16:10:48 dm_DataDictionaryPublisher<\/code><\/div>\n
...<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Here a conversion to M\/D\/YYYY HH24:MI:SS was performed by the content server while setting DM_AUDITTRAIL_S.OBJECT_NAME. A search for the first date regexp would not be able to return those values because their day part uses one digit instead of two; similarly, the second date regexp would not match either because their month part is greater than 12. So, searching dates exhaustively may require several passes with different, more relaxed search strings until all the formats used in strings, or a slightly more flexible regexp such as the following one, are tried out:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
[0-9]{1,2}.[0-9]{1,2}(.[0-9]{2}|[0-9]{4})?.[0-9]{1,2}.?[0-9]{1,2}.?[0-9]{1,2}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

where the date components days and months may have 1 or 2 digits, the date and time field separators can be any character (common ones are \/ and – for dates, : for times), the separator between the date and time part is anything (commonly a space or the letter T such as in logs produced by a java program), and the optional year component has 2 or 4 digits, although this is quite ambiguous even though the rule in Oracle “RRRR” datetime format can help solve the ambiguity.<\/p>\n

An interesting fact is shown in the output below:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>select<\/code> A_NEXT_CONTINUATION from DM_JOB_S where regexp_like(A_NEXT_CONTINUATION, <\/code>'[0-9]{1,2}\/[0-9]{1,2}\/[0-9]{4}'<\/code>);<\/code><\/div>\n
01<\/code>\/01\/0001<\/code> 00:00:00<\/code><\/div>\n
01<\/code>\/01\/0001<\/code> 00:00:00<\/code><\/div>\n
01<\/code>\/01\/0001<\/code> 00:00:00<\/code><\/div>\n
01<\/code>\/01\/0001<\/code> 00:00:00<\/code><\/div>\n
...<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Those seemingly meaningless dates are actually NULLDATEs and show how the content server stores them in the Oracle database. This is RDBMS-dependent; for example, in PostgreSQL (and also in SQL Server), the content server uses 1\/1\/1753 for the NULLDATE. Therefore, the underlying RDBMS is to be considered when searching NULLDATEs and the appropriate date literal be used in such cases.<\/p>\n

A cool wrapper<\/h3>\n

To simplify the usage of the db crawler and include the date considerations above, the bash wrapper script below can be used:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n<\/td>\n
\n
\n
#!\/bin\/bash<\/code><\/div>\n
# Usage:<\/code><\/div>\n
#\u00a0\u00a0 db-crawler.sh connect_info search_string<\/code><\/div>\n
# The script invokes sql*plus with the given connect_info and passes it the search_string; <\/code><\/div>\n
# the connect_info are username[\/password][@connect_string];<\/code><\/div>\n
# if the password is omitted, sqlplus prompts for one;<\/code><\/div>\n
# If the search string contains spaces, it must be quoted;<\/code><\/div>\n
# a sql file with a random file name $$.sql will be produced containing the appropriate SELECT statement to search the dictionary for tables in _S and _R;<\/code><\/div>\n
# that file will be executed and generate another SQL file named db-crawler-$$.sql containing all the SELECT statements to search for the given string across all the _S and _R tables;<\/code><\/div>\n
# finally, db-crawler-$$.sql will be executed with its output in db-crawler-$$.out;<\/code><\/div>\n
<\/div>\n
if<\/code> [[ $<\/code># -ne 2 ]]; then<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>echo<\/code> \"Expected syntax: db-crawler.sh connect_info search_string\"<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>exit<\/code> 1<\/code><\/div>\n
fi<\/code><\/div>\n
<\/div>\n
connect_info=$1<\/code><\/div>\n
search_string=<\/code>\"$2\"<\/code><\/div>\n
<\/div>\n
cat<\/code> - <<-eoq > .\/$$.sql<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>define search_string = &1<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>spool db-crawler_$$.sql<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>set<\/code> pagesize 0<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>set<\/code> linesize 1000<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>set<\/code> trims on<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>ALTER SESSION SET TIME_ZONE = <\/code>'0:0'<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>alter session <\/code>set<\/code> NLS_DATE_FORMAT = <\/code>'DD\/MM\/YYYY HH24:MI:SS'<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>select<\/code> 'select '<\/code> || COLUMN_NAME || <\/code>' from '<\/code> || table_name || <\/code>' where regexp_like('<\/code> || COLUMN_NAME || <\/code>', '<\/code>'&search_string'<\/code>');'<\/code> from USER_TAB_COLS where (table_name like <\/code>'%\\_S'<\/code> escape <\/code>'\\' or table_name like '<\/code>\\_%\\_R<\/code>' escape '<\/code>\\') order by 1;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>spool off<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>set<\/code> echo<\/code> on<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>set<\/code> trims on<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>@db-crawler_$$.sql<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>spool off<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>quit<\/code><\/div>\n
eoq<\/code><\/div>\n
<\/div>\n
sqlplus ${connect_info} @$$.sql <\/code>\"${search_string}\"<\/code> | <\/code>sed<\/code> -e <\/code>'0,\/EXIT\/d'<\/code> -e <\/code>'\/quit\/,$d'<\/code> > db-crawler_$$.out<\/code><\/div>\n
<\/div>\n
# browse the result output and jump to the first match;<\/code><\/div>\n
less<\/code> -S --pattern=<\/code>\"${search_string}\"<\/code> db-crawler_$$.out<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Let’s apply this wrapper to the use case below.<\/p>\n

Looking for a given host name<\/h3>\n

Let’s suppose now that we want to move or clone a docbase from a host to another one, maybe running a different O\/S with some differences due to the implementation. After we applied to procedure, we suspect that the former host name is still referenced elsewhere in the new repository but we have no idea where. We changed it in the well-known places such as DM_SERVER_CONFIG and DM_MOUNT_POINT but there may still be references to it elsewhere. Clearly, we must search all the columns in all the tables of the repository’s schema for the given host name string, which is very easy now by using the wrapper:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n<\/td>\n
\n
\n
export<\/code> TWO_TASK=orcl<\/code><\/div>\n
.<\/code>\/db-crawler<\/code>.sh dmtest<\/code>\/dmtest<\/code> hostname<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Example of execution:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n<\/td>\n
\n
\n
.<\/code>\/db-crawler<\/code>.sh dmtest<\/code>\/dmtest<\/code> docker<\/code><\/div>\n
egrep<\/code> -B 1 <\/code>\"^docker\"<\/code> db-crawler_19815.out | <\/code>less<\/code><\/div>\n
SQL> <\/code>select<\/code> HOST_NAME from DM_AUDITTRAIL_S where regexp_like(HOST_NAME, <\/code>'docker'<\/code>);<\/code><\/div>\n
docker<\/code><\/div>\n
docker<\/code><\/div>\n
...<\/code><\/div>\n
--<\/code><\/div>\n
SQL> <\/code>select<\/code> HOST_NAME from DM_CLIENT_REGISTRATION_S where regexp_like(HOST_NAME, <\/code>'docker'<\/code>);<\/code><\/div>\n
docker<\/code><\/div>\n
...<\/code><\/div>\n
--<\/code><\/div>\n
SQL> <\/code>select<\/code> HOST_NAME from DM_CLIENT_RIGHTS_S where regexp_like(HOST_NAME, <\/code>'docker'<\/code>);<\/code><\/div>\n
docker<\/code><\/div>\n
--<\/code><\/div>\n
SQL> <\/code>select<\/code> HOST_NAME from DM_MOUNT_POINT_S where regexp_like(HOST_NAME, <\/code>'docker'<\/code>);<\/code><\/div>\n
docker<\/code><\/div>\n
--<\/code><\/div>\n
SQL> <\/code>select<\/code> OBJECT_NAME from DM_SYSOBJECT_S where regexp_like(OBJECT_NAME, <\/code>'docker'<\/code>);<\/code><\/div>\n
dockerACS1<\/code><\/div>\n
--<\/code><\/div>\n
SQL> <\/code>select<\/code> R_HOST_NAME from DM_SERVER_CONFIG_S where regexp_like(R_HOST_NAME, <\/code>'docker'<\/code>);<\/code><\/div>\n
docker<\/code><\/div>\n
--<\/code><\/div>\n
SQL> <\/code>select<\/code> R_LOCK_MACHINE from DM_SYSOBJECT_S where regexp_like(R_LOCK_MACHINE, <\/code>'docker'<\/code>);<\/code><\/div>\n
docker<\/code><\/div>\n
docker<\/code><\/div>\n
docker<\/code><\/div>\n
--<\/code><\/div>\n
SQL> <\/code>select<\/code> SET_CLIENT from DMR_CONTENT_S where regexp_like(SET_CLIENT, <\/code>'docker'<\/code>);<\/code><\/div>\n
docker<\/code><\/div>\n
docker<\/code><\/div>\n
...<\/code><\/div>\n
SQL> <\/code>select<\/code> WEB_SERVER_LOC from DM_SERVER_CONFIG_S where regexp_like(WEB_SERVER_LOC, <\/code>'docker'<\/code>);<\/code><\/div>\n
docker<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We can see that the host name docker<\/em> was referenced in the attributes DM_AUDITTRAIL.HOST_NAME, DM_CLIENT_REGISTRATION.HOST_NAME, DM_CLIENT_RIGHTS.HOST_NAME, DM_MOUNT_POINT.HOST_NAME, DM_SERVER_CONFIG.R_HOST_NAME but also in DM_SYSOBJECT.OBJECT_NAME and R_LOCK_MACHINE (there were likely locked documents in the source repository), DM_SERVER_CONFIG.WEB_SERVER_LOC, and DMR_CONTENT.SET_CLIENT. Some of those attributes such as DM_MOUNT_POINT.HOST_NAME could explain a potential issue in the new repository if not set adequately, while others such as DMR_CONTENT.SET_CLIENT should have no impact if carried over as-is into the new repository.<\/p>\n

A note about DM_SYSOBJECT_S<\/h3>\n

Since DM_SYSOBJECT sits at the top of the type hierarchy of most persistent objects, it is linked by most repository objects and search results such as the ones below may be confusing:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n<\/td>\n
\n
\n
$ .<\/code>\/db-crawler<\/code>.sh dmtest73<\/code>\/dmtest73<\/code> dmtest<\/code><\/div>\n
...<\/code><\/div>\n
SQL> <\/code>select<\/code> OBJECT_NAME from DM_SYSOBJECT_S where regexp_like(OBJECT_NAME, <\/code>'dmtest'<\/code>);<\/code><\/div>\n
dmtest.cecACS1<\/code><\/div>\n
dmtest73<\/code><\/div>\n
dmtest73<\/code><\/div>\n
dmtest73<\/code><\/div>\n
ContTransferConfig_dmtest73.dmtest73<\/code><\/div>\n
dfc_dmtest.cec_c0XP4a<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Clearly, due to their technical apparence, these rows may belong to objects deriving from DM_SYSOBJECT and belonging to different types; in order to determine which ones, further digging is necessary, e.g.:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n<\/td>\n
\n
\n
$ idql dmtest73 -Udmadmin -Pxxx <\/code><\/div>\n
1> <\/code>select<\/code> r_object_id, r_object_type, OBJECT_NAME from DM_SYSOBJECT where OBJECT_NAME like <\/code>'%dmtest%'<\/code>);<\/code><\/div>\n
2> go<\/code><\/div>\n
r_object_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 r_object_type\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 object_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code><\/div>\n
----------------\u00a0 --------------------------------\u00a0 ----------------------------------------<\/code><\/div>\n
0c00c35080000104\u00a0 dm_cabinet\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 dmtest73\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code><\/div>\n
3c00c35080000103\u00a0 dm_docbase_config\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 dmtest73\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code><\/div>\n
3d00c35080000102\u00a0 dm_server_config\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 dmtest73\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code><\/div>\n
0800c35080000495\u00a0 dm_acs_config\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 dmtest.cecACS1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code><\/div>\n
0800c350800004ba\u00a0 dm_cont_transfer_config\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ContTransferConfig_dmtest73.dmtest73\u00a0\u00a0\u00a0 <\/code><\/div>\n
0800c35080000585\u00a0 dm_client_rights\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 dfc_dmtest.cec_c0XP4a\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code><\/div>\n
(6 rows affected)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We can see for example that lines 8 and 9 from the crawler’s output correspond to repository’s types dm_cont_transfer_config and dm_client_rights. Thus, if something needs to be corrected in the repository, that’s where it should be done preferably in order to minimize the likelyhood of introducing corruptions.<\/p>\n

Renaming a docbase\/changing its docbase id<\/h3>\n

Another use case, albeit a far fetched and fragile one, is when a repository must be renamed or its id changed. While the safe, traditional approach is to create a new docbase with the new name\/id and exporting\/importing the content, a more acrobatic approach would use the crawler to identify all the places in the underlying tables where those values are referenced, and change them.
\nClearly, in addition to the docbase’s schema, there are several locations in configuration files where such information is referenced too that should be edited. As most of those files are text files, the find command with a sed invocation can quickly do that in one pass. As to the schema’s tables, a search with the regexp ‘[0-9]{2}docbase_id<\/em>[0-9a-f]{8} can identify all the ids to change. Something similar could be used for the repository’s name to change. Of course, a great deal of testing should be done, and maybe a call to OpenText to discuss this approach wouldn’t hurt either. Moreover, since they also distribute their own docbase renaming\/id changing tool, MigrationUtil (see the following blog articles Documentum \u2013 MigrationUtil \u2013 1 \u2013 Change Docbase ID<\/a> and Documentum \u2013 MigrationUtil \u2013 2 \u2013 Change Docbase Name<\/a>), it could be interesting to compare both techniques.<\/p>\n

Conclusion<\/h3>\n

The db-crawler has a lot of potential to help troubleshoot puzzling problems, and identify inconsistencies and corruptions in repositories. As all the RDBMS have a dictionary, it is easy to adapt it to a different underlying one. It can even be used outside the context of Documentum repositories, directly in the context of databases.
\nAs a typical repository’s schema contains more than 2’000 tables (more if customized doctypes have been introduced), with possibly millions of documents (corresponding to one or more rows spread over several\u00a0 database tables), a possible enhancement is to speed the search up by parallelizing the execution of the generated SELECT statements, an easy to do task using a divide-and-conquer technique or a tool such as GNU Parallel.
\nCurrently, the tool is very basic as it addresses a simple need but it does not have to stay this way so feel free to add useful features and optimizations.<\/p>\n","protected":false},"excerpt":{"rendered":"

Working with Documentum is often a frustrating experience, and one of the main causes is the lack of meaningful error messages. Be it an encouragment to the administrator or developer to refer to the official knowledge base or a gap in the user-friendliness department, this results in the dreaded venture of investigating the origin of […]<\/p>\n","protected":false},"author":40,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[525,59],"tags":[129,2611,985],"type_dbi":[],"class_list":["post-17820","post","type-post","status-publish","format-standard","hentry","category-enterprise-content-management","category-oracle","tag-documentum","tag-search-database","tag-sqlplus"],"acf":[],"yoast_head":"\ndb-crawler, a database search utility for Documentum - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"db-crawler, a database search utility for Documentum\" \/>\n<meta property=\"og:description\" content=\"Working with Documentum is often a frustrating experience, and one of the main causes is the lack of meaningful error messages. Be it an encouragment to the administrator or developer to refer to the official knowledge base or a gap in the user-friendliness department, this results in the dreaded venture of investigating the origin of […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-15T18:26:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-24T07:38:36+00:00\" \/>\n<meta name=\"author\" content=\"Middleware Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Middleware Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"18 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/\"},\"author\":{\"name\":\"Middleware Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\"},\"headline\":\"db-crawler, a database search utility for Documentum\",\"datePublished\":\"2022-07-15T18:26:06+00:00\",\"dateModified\":\"2025-10-24T07:38:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/\"},\"wordCount\":2517,\"commentCount\":0,\"keywords\":[\"Documentum\",\"search database\",\"sqlplus\"],\"articleSection\":[\"Enterprise content management\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/\",\"name\":\"db-crawler, a database search utility for Documentum - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2022-07-15T18:26:06+00:00\",\"dateModified\":\"2025-10-24T07:38:36+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"db-crawler, a database search utility for Documentum\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\",\"name\":\"Middleware Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"caption\":\"Middleware Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/middleware-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"db-crawler, a database search utility for Documentum - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/","og_locale":"en_US","og_type":"article","og_title":"db-crawler, a database search utility for Documentum","og_description":"Working with Documentum is often a frustrating experience, and one of the main causes is the lack of meaningful error messages. Be it an encouragment to the administrator or developer to refer to the official knowledge base or a gap in the user-friendliness department, this results in the dreaded venture of investigating the origin of […]","og_url":"https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/","og_site_name":"dbi Blog","article_published_time":"2022-07-15T18:26:06+00:00","article_modified_time":"2025-10-24T07:38:36+00:00","author":"Middleware Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Middleware Team","Est. reading time":"18 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/"},"author":{"name":"Middleware Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1"},"headline":"db-crawler, a database search utility for Documentum","datePublished":"2022-07-15T18:26:06+00:00","dateModified":"2025-10-24T07:38:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/"},"wordCount":2517,"commentCount":0,"keywords":["Documentum","search database","sqlplus"],"articleSection":["Enterprise content management","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/","url":"https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/","name":"db-crawler, a database search utility for Documentum - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2022-07-15T18:26:06+00:00","dateModified":"2025-10-24T07:38:36+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/db-crawler-a-database-search-utility-for-documentum\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"db-crawler, a database search utility for Documentum"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1","name":"Middleware Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","caption":"Middleware Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/middleware-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17820","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=17820"}],"version-history":[{"count":13,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17820\/revisions"}],"predecessor-version":[{"id":19632,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17820\/revisions\/19632"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=17820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=17820"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=17820"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=17820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}