This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal



~Evelyn Kiboositerynds
Jan 11, 2013, 7:27 PM
50 Posts
topic has been resolvedResolved

DCRs

  • Category: Other Domino Designer Tooling
  • Platform: Windows
  • Release: 8.5.3
  • Role: Developer
  • Tags: data connections
  • Replies: 5
I just viewed Paul Calhoun's talk on Relational Data Access in XPages and am trying to set up DCRs in my application. In the video, Paul states that DECS is NOT required if using DCRs. But every indication I am getting, including Designer Help, is that it is required. I have set up my DCR using an ODBC data source to an Oracle database that I have installed on my workstation (and on my server). The data source itself tests fine but when try to "Browse Metadata" with the DCR I get an error that states it "Cannot browse metadata because DECS is not running on this server". I am also not able to "Import External Records" nor does my form or XPage update the external data. External data is enabled on the database and on the form and fields. I'm pretty sure my DCR is built correctly:
 
Type: ODBC
Username and password are good
Data Source: is the name of the ODBC Data Source in Windows
Object: Table
Owner is provided
Name is the name of the Table i want to access.
 
The form and view are set up per Paul's instructions in the video.
 
So here is my point, DECS is NOT installed on my server (thus it won't load from Administrator). Do I need DECS or not?
 
~Cheryl Elhipigenlen
Jan 11, 2013, 7:48 PM
366 Posts
Re: DCRs
 For clarification, DECS does not have to be installed at all.  It is installed as part of the Domino Server/Notes Designer client automatically but not enabled.
 
To load it on the server simply go to the server or remote console and type in load DECS. 
 
In you local designer under preferences you can "enable DECS". 
 
Neither one of these tasks are required to be running once the DCR's are configured and working, but you might have to turn them on to get your initial connection configured. 
 
In order to import records into the application make sure that you have DISABLED using DCR's in the database properties (I know, sounds counter intuitive but it's required).  Do the import and then re-enable the property. 
 
Let me know if you have any additional questions. 
~Evelyn Kiboositerynds
Jan 12, 2013, 4:12 PM
50 Posts
Re: DCRs
 Thanks Paul. I'll check that Designer setting on Monday. Apparently, though, DECS is not even installed on my server cause it doesn't load from Administrator. I'll have to see what I have to do to get it installed in my environment.
 
~Cheryl Elhipigenlen
Jan 13, 2013, 5:03 AM
366 Posts
Re: DCRs
 what version of Domino?  I didn't think it was an option to or not to install it, just gets installed as part of the server.
 
So on the server console when you type in "load decs" what is the response on the console? 
~Evelyn Kiboositerynds
Jan 15, 2013, 7:26 PM
50 Posts
Re: DCRs
I checked with a server admin and indeed DECS is not loaded by default on our servers unless requested. So I requested it and it is now loaded. Server version is 8.5.3 FP2 with UP1.
 
I set up the Data Connection and when I click "Browse metadata" I get a dialog that says that I can't do this because DECS is not running on the server. Ugh! Server tasks shows that it is running.
 
Incidentally, I have not been able to find any place in Designer preferences to "enable DECS".
 
I am trying 2 different DCRs. One is using the Oracle type and the other is using ODBC. I have an ODBC Data Source on the server that I am using for ODBC. I am failing miserably in both cases. Sigh.
~Evelyn Kiboositerynds
Jan 17, 2013, 6:26 PM
50 Posts
Re: DCRs
Well, somehow the issue is resolved. The last thing I did was replace the design on decsadm.nsf and restart Domino server. Apparently, that also resolved the issue I was also having with ODBCConnection initiated from an XPage.
 
Go figger! Apparently, Domino works in mysterious ways.

This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal