OnBase Technical Forum

Resolved! SQL Select Script to View Which Unity Forms Have Which Attachments

Unity Forms now allow attachments. That is a beautiful thing. I'd like to write a SQL select statement to show each unity form and the related attachments. I assume this information has to be in the database somewhere? If not, anyone know how thi...

Resolved! Get details of a particular document

Hi All,I have a keyword type "Customer Name" in my document type. I have uploaded a document with multiple customer name values. (by pressing F6, and selecting the customer name). So my uploaded document have 7 customer names. I am able to retrieve t...

Resolved! OnBase Data Dictionary

I need a data dictionary for OnBase. The reporting database guide is helpful for illustrating the relationships among the core tables, but it does not provide a great description of how each column is intended to be used (i.e. what business function ...

Resolved! DR Options

Many times we are asked about DR what is needed and how to do it. I was wondering what other customers / resellers have done. I would assume it depends on if the DR will be full production or just retrieval.What are the basics needed?How do you handl...

Resolved! Moving Database

Hello: We are looking to move the OnBase database to another server.From Oracle Server 10g to Oracle Server 12c. We are using OnBase 11.We would like to use expdp/impdp.Our plan is to 1. Use expdp to export HSI, HSICORE, and HSINET to files.2. Use im...

Resolved! Recovering data from backup

What would be best practice to retrieve specific data from backup db. One of our clients deleted bulk documents and we need to retrieve them from backup and restore to production.

Resolved! Auto Update Statistics - Synchronous vs. Asynchronous

Hello,Which mode of auto update stats is recommended to use with the OnBase database-- asynchronous or synchronous?Thanks,John

Resolved! SQL Server Admin User Locked and Unable to run daily backup

Guys,One of our installation at customer office had a problem with their SQL database. The following are the issues:-1. IT Security changed SQL System Admin name and password. Due to this, the backup schedule not running as usual.2. SQL System Admin ...

Resolved! MS SQL Settings:Allow Snapshot Isolation and Is Read Committed Snapshot On

Working with our DBA, he has found the following on the OnBase database, currently on SQL 2008:"Performance wise – the biggest thing I’m seeing in logs is wait time for table locks. During business hours this appears to range from 5 ms to 90 ms daily...

Resolved! hsi.trashcan -vs- hsi.docmainXXX -vs- hsi.docmainfXXX

Hi All -I've seen reference to these three tables in various OnBase posts but have not seen any documentation that defines them.I can infer from the names that these two tables ( hsi.docmainXXX and hsi.docmainfXXX) are used as part of the Document Ma...

Hyland Connect

Forum Posts

Resolved! SQL Select Script to View Which Unity Forms Have Which Attachments

Resolved! Get details of a particular document

Resolved! OnBase Data Dictionary

Resolved! DR Options

Resolved! Moving Database

Resolved! Recovering data from backup

Resolved! Auto Update Statistics - Synchronous vs. Asynchronous

Resolved! SQL Server Admin User Locked and Unable to run daily backup

Resolved! MS SQL Settings:Allow Snapshot Isolation and Is Read Committed Snapshot On

Resolved! hsi.trashcan -vs- hsi.docmainXXX -vs- hsi.docmainfXXX

OnBase Forms - what is the cause of pending status...

Issue Adding Reference to Unity Script

Specs of a server if installing Hyland IdP and API...

IdP/IAM Docpop question

OnBase IdP Admin Portal - doesn't allow mods (all ...

WAMcon : cannot copy Application due to IIS access...

User assigment in unity life cycles

Read only field in workview with unityscript

Total number of user accounts in Perceptive Conten...

Sybase SQL Anywhere to Azure SQL Managed Instance ...