Verified Answers


If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Verified Answer
  • Replies replies
    2
  • Subscribers subscribers
    16
  • Views views
    170
  • Users 0 members are here
Related
Options

Getting an 9D,18 Error

AmyM1

When we log into our software - the program is giving us an 9D,18 error.  According to the documentation, that means that "An Error occurred when creating the primary key for a secondary table".

But when I get this error - that is not what is going on in the software - we are just opening and reading files. 

I also found that the 9D,18 error could mean that both types of SQL Authentication is being run in the ACUFH.TXT file.  That is not the case here either.  

Can anyone help with this error? Our customer is dead in the water until we get this fixed. 

  • 0  

    Hi Amy,

    I don't have an immediate fix for you but I have some questions.

    On what statement in your program are you receiving this error?
    Did the application used to work OK on this system and now the error just started or is this a new system and the application has never worked?

    You should probably try tracing the DB Connectors component using CTF and tracing set in the ACU config file.

    This is documented here:

    Chris Glazier
    Rocket Software - Principal Technical Support Specialist
    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button

  • Verified Answer

    +1 in reply to   

    We actually figured out what the issue was - because we are using Database Connectors, and not all of our users are using the Windows Authentication, we needed to add the A_MSSQL_PASSWD and A_MSSQL_LOGIN fields in our ACUFH.TXT file

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.