Popular Tags

  • Delete field in dbdict (v9.80)

    Hi All, How can i delete a field in dbdict system navigator? i only know it can be deleted in db -> dbdict- >tablename But i'm not sure if it is risky? please help me solve that problem as soon as possible. Thanks a lot in advance!!

  • Remapping with out data migration in SM

    Hello Experts, We have a table cm3rm1 currently contains the field that contains control characters and contains multiple individual items in the single record. We want to break this out into a separate table. We found the below documentation to…

  • probsummary stuck

    Hello, One of my customer has a very strange issue. After DB upgrade from SQL 2012 to SQL 2017 the probsummary table only gets stuck (Cannot view, insert or update any record) on random intervals (some times every 1 day sometimes every 3 days) issue being…

  • Service Manager - recommendation for querying database which is not SM-s db

    Hello experts, Do you have a recommendation on how to connect to a database which is not SM and it should be "Real-Time"? Which middleware is best for this since CIT has problems with this kind of integration. Case: I need to connect to a database which…

  • Save actions are slow: I/O exception, Connection refused: connect

    We see this error message several times in the log for each save: I/O exception (java.net.ConnectException) caught when processing request: Connection refused: connect Example: adding a journaled update to an Incident takes 40 seconds. Theory: can not…

  • How do I configure Deployment Manager to accept database connections

    I am trying to install Service Manager via the DM module and i am finding that I am having problems connecting to the database instance on the same host machine. The error is occuring whenever I'm trying to connect to any database in order to complete…

  • Creating a field in RDBMS, how does it show up in SM?

    If I create a field/column in SM SQL db, how does it show up in SM dbdict? I added a test field in ProbsummaryA2 and saved it and went to look for it in SM but its not there. Is there a way to sync SM with SQL?

  • Support tip: Case sensitive to case insensitive in Oracle

    Hello all, Just a quick tip and clarification of what you cannot do. The steps to change from Case Sensitive to Case Insensitive or CI to CS is to: system_unload, drop Oracle database and recreate in Case Sensitive (or reconfigure to Case Sensitive…

  • Trouble Shooting Performance Issues and identifying what SQL is being passed to database

    We are experiencing performance issues in Service Manager 9.21 running on an oracle 11.2.0. 2 DB on an AIX server. We have a good understanding where the slowdowns happen but not sure what’s happening behind the scenes. Example: When bringing up the interaction…

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.