IBM i Global

IBM i 

A space for professionals working with IBM’s integrated OS for Power systems to exchange ideas, ask questions, and share expertise on topics like RPG and COBOL development, application modernization, open source integration, system administration, and business continuity.


#Power


#IBMi
#Power
 View Only
Back to discussions
Expand all | Collapse all

Problem Accessing Schemas and Content Assist

  • 1.  Problem Accessing Schemas and Content Assist

    Posted Fri March 08, 2024 10:58 PM

    After installing ACS 1.1.9.4, connecting to machine running v7r3, most things work.  

    Things that don't work are:

    Schemas.  If i click on that link, I get an error message saying, "SQL State: 38501, Vendor code: -443, Message: [CPF3EC0] Add relational database directory entry failed.  Cause.....:See previously listed messages in the job log for the cause of the failure.  Recovery....:Correct any problems and try the request again.

    I believe the above message is caused by the difference in the machine name and the name listed in the DNS and I'm not sure how I can resolve that.

    Content Assist.  When accessing Content Assist from Run SQL Scripts, instead of getting a list of columns or fields within a select statement, I get a list starting with MAX, MIN...

    I have reviewed the configuration for the connection, I have the latest version of Java installed.  

    Would it be better if I installed IBMOpenJ9?  

    Thank you.



    ------------------------------
    MaryAnn Martin
    ------------------------------

    #IBMiAccessClientSolutions


Related Content