Skip Navigation and Search to Content

Centric CRM 4.1 (Stable and Released)

	Open File in New Window
	Download File

Ticket # 1 Details

Ticket Information
Entered	Kailash B. - 8/24/2006 7:56 AM
Last Modified	Kailash B. - 10/31/2006 12:26 PM

Classification
Issue	Reported by a community member. As with the previous two issues that I reported, when using Oracle clicking on the Maintain Users link in the admin section of Centric, you will get an "ORA-00918: column ambiguously defined" error. The solution to this is to modify the UserList.buildList() function as follows: @@ -1502,7 +1502,7 @@ "a.last_ip, a.timezone, a.startofday AS access_startofday, " + "a.endofday AS access_endofday, a.expires, a.alias, " + "a.contact_id AS contact_id_link, a.user_id AS access_user_id, " + - "a.enabled AS access_enabled, a.assistant, " + + "a.enabled AS access_enabled, " + "a.entered AS access_entered, a.enteredby AS access_enteredby, " + "a.modified AS access_modified, a.modifiedby AS access_modifiedby, " + "a.currency, a.\"language\", a.webdav_password, a.hidden, a.allow_webdav_access, a.allow_httpapi_access, " + @@ -1512,8 +1512,7 @@ "b.description AS site_id_name, " + "lind.description AS industry_name, " + "lcs.description AS source_name, " + - "lcr.description AS rating_name, " + - "o.name AS org_name, o.enabled AS orgenabled " + + "lcr.description AS rating_name " + "FROM \"access\" a " + "LEFT JOIN contact c ON (a.contact_id = c.contact_id) " + "LEFT JOIN lookup_industry lind ON (c.industry_temp_code = lind.code) " + This is a problem on Oracle because the whole select statement gets wrapped in a seperate statement such as: SELECT * FROM (...) WHERE ROWNUM < 10 where ... represents the original statement. Because there are identically named columns from several tables in the original statement in this case, Oracle cannot deal with them and barfs out an error. My solution removes the duplicate named columns. Could someone with access to the ticketing system please raise this with the development team so that it can get corrected in core. Cheers, Primoz
Category	Blocker
Severity	Normal

Assignment
Priority	Scheduled
Assigned To	Matt R.

Resolution
Solution

File Attachments
No files attached.

Ticket Log History
Kailash B. 8/24/2006 7:56 AM	[ Ticket Opened ]
Kailash B. 8/24/2006 7:56 AM	[ Assigned to Bhoopalam, Kailash ]
Kailash B. 8/24/2006 7:56 AM	[ Priority set to Scheduled ]
Kailash B. 8/24/2006 7:56 AM	[ Severity set to Normal ]
Kailash B. 10/31/2006 12:26 PM	[ Reassigned from Bhoopalam, Kailash to Rajkowski, Matt ]
Kailash B. 10/31/2006 12:26 PM	Matt.. your thoughts.

Distribution List
sateesh n., Phil K., Phil K., Phil K., David M., Vineet D., Vineet D., Ricardo M.

About Concursive

Concursive Corporation is a software and social media company that's part of Intel Capital's portfolio. We are headquartered in Norfolk, Virginia and have offices in Melbourne, Australia and Bangalore, India.

We are the developer of ConcourseConnect, an integrated web-based software platform that brings together Social Business Software, Corporate Social Networking, Online Community, Business Directory, and CRM capabilities, as well as ConcourseSuite, a dedicated CRM solution that's deployable either on-premise or on-demand.

Concursive products are used by large enterprises, governments, universities and thousands of small businesses alike. Our developer and user community has more than 17,000 registered community members. (read more)