Dovetail

"Class doesn't support Automation" error thrown by fcSDK API Toolkit COM Compatibility Layer

(Article # 168) When calling various toolkit APIs on the fcSDK API Toolkit COM Compatibility Layer, you may receive an error: "Class doesn't support Automation".

"Index -1 is out of range for list" error message in form 412 for Comm Center

(Article # 41) 1) Have a contact that has created 40+ cases (they are all open) 2) Open the New Ticket form 3) Press the Find caller button (Rolodex button) 4) Then, in S...

"Operation Not Allowed" error using aspSmartUpload to upload files

(Article # 181) Uploading a file in fcClient can result in an "Operation Not Allowed" error using aspSmartUpload to upload files

"Specified cast is not valid" error is table_hgbst_show.last_mod_time is NULL

(Article # 257) If table_hgbst_show.last_mod_time is NULL, then fcSDK and DataVerifier both throw an error: "Specified cast is not valid" stack trace: System.Reflect...

'OSList' is null or not an object using GetHgbstList with the fcSDK

(Article # 188) Opening a CR created this error: Error Type: Microsoft JScript runtime (0x800A138F) 'OSList' is null or not an object cr.asp, line 341 .... CPUL...

'undefined' is undefined

(Article # 95) Error Type: Microsoft JScript runtime (0x800A1391) 'undefined' is undefined

A worker process with process id of 'XXXX' serving application pool 'First Choice' has requested a recycle because the worker process reached its allowed processing time limit.

(Article # 110) Users see this error in their Windows 2003 event log: A worker process with process id of 'XXXX' serving application pool 'First Choice' has requested a ...

Add help to a page

(Article # 150) 1. Create a new help page, such as site_help.htm 2. Place this new file in the same directory as the page you want to post it form, i.e. /pages/site/ ...

Adding and removing multiple users from a queue

(Article # 321) You cannot add or remove multiple users from a queue at one time.

Adding Unicode text to the TABLE_ACT_ENTRY.ADDNL_INFO field can throw an error if the DB is not set up as a Unicode DB

(Article # 320) An ORA-12899: value too large for column "TABLE_ACT_ENTRY"."ADDNL_INFO" (actual: 260, maximum: 255) error can occur when calling the FChoice.Toolkits.Clar...

ADODB.Fields error when calling GetTimeZoneList

(Article # 260) When calling fcApplication.GetTimeZoneList(), the following error can occur: ADODB.Fields: Arguments are of the wrong type, are out of acceptable range, ...

Application pool setup

(Article # 164) For Windows 2003 web applications, it is recommended that you place them in separate Application Pools.

Applying updates using SchemaEditor fail with the error "Could not save object"

(Article # 282) Applying schema changes to MS SQL Server 2005 databases using SchemaEditor can sometimes fail when adding a new table having a relation. The failure wil...

Archiving Oracle LONG fields truncates data from fields with more than 32K in them

(Article # 311) When archiving data using Archive Manager (formerly known as DIET) from an Oracle database containing records with fields of type LONG having more than 32...

ASP application using FCFL.Net does not respond or throws the error: Couldn't get process information from remote machine.

(Article # 135) This applies to FCFL.Net versions 1.2 and earlier. When attempting to run an .asp application using fcfl.net v1.2 or earlier you may run into a probl...

ASP error about apartment model behavior in fcAdmin or fcClient (Windows 2003, IIS 6)

(Article # 101) After successful installation of fcAdmin or fcClient, you may still receive this error in the browser (if "Show Friendly HTTP Errors" is unselected in Int...

Asp page blocking issue

(Article # 173) One particular customer ran into an issue in that while one long running query was executing, the user could not start another query, or do any other oper...

Attachment can't open if file has no extension

(Article # 229) From the attachment page within fcClient, attempt to open an existing attachment that does not have a file extension. The page cannot be found The page ...

autodest example

(Article # 204) The fcSDK documentation for AutoDest does not currently have any usage examples. keywords: AutoDest AutoDestination Auto-Destination Auto-Dest

Avoid unhelpful HTTP 500 - Internal server errors in your browser

(Article # 274) When installing Dovetail web applications it is common to run into minor configuration errors. You need to be able to see the error message being returned...

Biz rule message to include a URL screen pop

(Article # 156) http:// <Path to fcclient>/console/console.asp?command=casebyid¶m1=[Object ID] where <path to fcclient> will be something like myserver/fcclient Av...

Can I make the SEC or SLAM daemons into an NT Service?

(Article # 65) Can I make the SEC or SLAM daemons into an NT Service?

Can I use Office 2007 with EEO?

(Article # 251) Enhanced Email Out (EEO) uses Collaborative Data Objects (CDO) to communicate with Outlook. Beginning in Exchange 2007 Beta 2 and Outlook 2007 Beta 2, CD...

Can SchemaEditor be used to create a new Clarify database?

(Article # 266) Can SchemaEditor be used to create a new Clarify database?

Can you have business rules on batches in RF/Shipping?

(Article # 24) Is it possible to trigger business rules on the create, close, etc. of batches? Keywords: RF, Shipping, Batch, Business Rule

Can you merge Customer and Internal sites in Site Merge?

(Article # 23) Can you merge internal and customer sites together in Contact/Site merge? Because if you can, you could end up with employees at customer sites. Keywords:...

case hangup_time is null

(Article # 215) Create a case using fcClient and the fcSDK, but do not add any phone notes. Expected: table_case.hangup_time is set to the current time. Actual: table_cas...

case history not being updated via classic client

(Article # 230) In Clarify 11.5 and 12.5, if the case modify stamp value (modify_stmp) contains millisecond values (ex: 2006-12-24 10:23:14.110) instead of '000' millise...

Cases pages time-out when opening, seeing really slow performance on specific pages

(Article # 306) Case pages fail to load, and a time-out error occurs. The log file shows the following query timed out before completion. SELECT count(*) FROM table_...

CaseTimeAndExpenses not working as expected

(Article # 220) Using the CaseTimeAndExpenses object can result in an error, such as: Input string was not in a correct format. Example: Dim CaseCloseSetup As New Suppo...

CB Debugging

(Article # 72) Please send me the exact steps to reproduce. Also, please start clarify.exe with the following options: -msg -cbtrace -sqllogsql.log -sqltrace -sqlhint -d...

cbbatch and extended or accented characters

(Article # 76) cbbatch seems to corrupt extended characters. Example program: Option Explicit Const first_name = "Larrañaga" Const last_name = "Núñez" Const phone = "5...

change_contact API wrote wrong phone number field to activity log text

(Article # 25) In the change_contact API, the activity log's additional info field was using the alt_phone field when it should have been using the alt_phone_num field. T...

Changing a setting on Session does not have any effect

(Article # 312) CreateCase was not truncating string fields after setting TruncateStringFields = true - instead it was throwing an exception. The error from the log file...

Changing the login info in bolt results in a Permission denied error

(Article # 277) Using the admin page in BOLT to set the BOLT database connection infomation, and then clicking submit can result in the following error: HTTP 500.100 - I...

Character restrictions for schema elements (tables, columns, etc.)

(Article # 267) Are there any restrictions on the characters used in defining a schema object, such as a view, table, column, field, etc?

Checkbox label click the checkbox

(Article # 155) 1. Use the "for" property of the label control Example: <input type=radio name="product_type" id=by_site value="site_part" checked> <label for=by...

Class doesn't support Automation using fccl.update_pr_detail_list method

(Article # 223) Caling the update_pr_detail_list on the clearlogistics toolkit can cause an error such as: Microsoft JScript runtime (0x800A01AE) Class doesn't support A...

Code which runs after a date/time has been picked from the calendar control

(Article # 151) Add a hidden element with an id of cal_callback, and have this element's click handler do the code you want. <input type="hidden" id="cal_callback" onc...

Coloring the selected row in a grid

(Article # 145) 1. Make sure you're including client_utility.js: <script language="javascript" src="../code/client_utility.js"></script> 2. Make sure your table has a...

Connection refused error when sending an email via SMTP

(Article # 291) The Rulemanager service will not start. The log file indicates a socket error sending email. When Rulemanager starts up, it sends a test email. The log f...

Corrupt date format in DIET archive files

(Article # 262) When performing a purge, archive, or export using DIET, and explicitly setting a date_format, the resulting dates in the output file can be corrupt. For ...

Corrupt user defined list causes license installer to die

(Article # 133) The license installer simply dies when clicking the install license key and fcadmin just seems to hang.

Could not retrieve field 'x_num_recent_obj' for object type 'user'

(Article # 256) After applying schema changes using SChemaEditor 1.2 or below, and then starting the Clarify Classic Client, the following error can occur: "Could not re...

Count does not display with large number of wipbins or queues in Oracle 7

(Article # 167) For select users, the wipbin and queue counts do not display on the console. Related error messages: ORA-06502: PL/SQL: numeric or value error ORA...

Create CR API in CBCQ set wrong table_condition.condition value

(Article # 28) In the create_cr APIs in CBCQ, a bug was found. The condition was set to 2 (Open) or 10 (Open-Dispatch) for the new CRs. In reality, it shouldn't be the 2 ...

Creating sessions using the fcSDK application user is disabled for security reasons.

(Article # 275) The following error can be thrown by the fcSDK: Creating sessions using the fcSDK application user is disabled for security reasons. If you wish to allow...

Custom API Invocations crash Email Agent with a BadImageFormatException

(Article # 335) When using Email Agent's API Invoke mode an attempt to invoke a custom API that resides in a .Net 2.0 assembly (e.g. built using Visual Studio 2005 or abo...

Custom counters file view is out of memory.

(Article # 241) The following error can occur using applications that use Dovetail SDK (e.g. Dovetail Admin, and Dovetail Agent): Custom counters file view is out of mem...

Custom menu items do not show up on non-English versions of Clarify

(Article # 45) For example, setting up SEC on a French version of Clarify, the following code is compiled: Sub initialize_app() Dim pc_menu As New AppMenu ' Policies & ...

Customize the tabs and tab headers

(Article # 148) Many pages in fcClient have regions that use tabs to group user interface elements together. You can customize the size and location of the tab collecti...

Data Restriction (RES) Toolkit Errors

(Article # 11) Installed RES, Form 2020 has problems. Try to open form 2020 in UI Editor, UI Editor crashes. Try to open form 2020 in Clarify client, error: Cannot assig...

Data type is not supported error on Oracle using BOLT

(Article # 112) You may receive an error such as "Data type is not supported error " when using an application that uses ADO (such as BOLT) This solution discusses the is...

Data Verifier error: There are countries related to non-existant time zones

(Article # 206) While running Data Verifier (part of the fcSDK), the following data issue is shown: Description: Test to check to make sure all countries are pointed to ...

Database SQL error using a between operator with a changeable parameter

(Article # 255) Create a new query that uses a changeable betwen operator. For example, I setup a new query for cases where the creation_time was between 1/1/2007, 12/31/...

Databinding with ClarifyGeneric objects

(Article # 179) When creating ASP.NET or Windows Forms applications is can be very handy to use .NET's databinding capabilites. This solution will walk you through a basi...

Date$ function has Y2k issues on UNIX

(Article # 29) If the Clarify/UNIX environment is not configured properly, the Date$ function returns an invalid value.

Datetime localization issues can occur when APIs are invoked using non-US cultures.

(Article # 319) In earlier versions of the fcSDK invalid date string errors could occur when the APIs were invoked using non-US date formats.

Debugging contact/site merge - C/S Merge

(Article # 64) Identify 2 contacts that need to be merged. Identify them using first,last, & phone. i.e. Contact1: Joe Customer, 555-123-4567 Contact2: Joseph Customer, ...

Details about create_employee on Microsoft SQL Server

(Article # 263) The create_employee API within the Interfaces toolkit (fcinter) is used to create new users/employees in the system. As Clarify uses the database for sto...

DIET ( ArchiveManager ) error: File 'file.arc' has a bad check sum

(Article # 279) DIET ( PARE DIET, ArchiveManager ) can throw the following error: ERROR - File 'zip.arc' has a bad check sum

DIET ERROR - ORA-01403: no data found

(Article # 300) When importing, exporting, or purging data using DIET ( Archive Manager ), the following Oracle error can occur: ORA-01403: no data found

DIET error: Checksum parameter is not the license key

(Article # 281) DIET can throw the following error when trying to add a checksum to a directive file: FATAL - Checksum parameter is not the license key diet –archive –di...

DIET error: Objid can not be a unique field unless -objid is used

(Article # 280) DIET can throw an error such as: ERROR - Objid can not be a unique field unless -objid is used

DIET errors when the username is not "sa" on Oracle databases

(Article # 353) When using DIET on Oracle databases, and the username is not SA, then errors can occur, such as: Unique field 'login_name' not specified

DIET Fatal error message: Can not export on Clarify version 12 or above on Oracle

DIET would hang in input mode.

(Article # 310) When executing DIET against a Microsoft SQL Server or Oracle database. Execution stops after displaying this message: DIET version 2.1.12(d) for Oracle 9...

difference in demand_dtl2pick_part relation between classic clarify and fccl.fulfill API

(Article # 194) The fcSDK is not clearing or updating the demand_dtl relations correctly in the PFSR processes.

Dirty bit processing

(Article # 147) Add dirty bit: 1. Make sure you're including client_utility.js and open_window.js: <script language="javascript" src="../code/client_utility.js"></scr...

Display localized time

(Article # 153) Example code: <% if (!bFindCaller){ var now = FCSession.GetCurrentDate(); var cust_tz = boTZ('full_name'); var cust_tz_name = b...

Display the age in the console

(Article # 152) Here's an example of displaying "age" in the console. However, like the Clarify Classic client, this would display how long the case has been in the wi...

Does Dovetail Agent have spell check functionality?

(Article # 302) Does Dovetail Agent have spell check functionality? keywords: fcClient spell-check spelling

Does EmailAgent support many custom fields when calling APIs?

(Article # 284) How many custom fields can be processed in a single email? Does EmailAgent support many custom fields when calling APIs? EmailAgent mode: API Invoke key...

Does the user credentials in the application connection string need to be a valid clarify user?

(Article # 286) Applications that use the Dovetail SDK need to specificy a database connection string containing the application user credentials. It is easy to think t...

Dovetail Admin 2.6 - Managing Queues - error on the membership tab

(Article # 308) The Queues page in Dovetail Admin 2.6 generates the following error on the membership tab. (15079) CLFY_GENERIC_NO_TABLE[user_empl] This occurs on l...

Dovetail Mobile Agent on IIS 6 - pages return a HTTP 403 or 404 error

(Article # 343) Any page visited returns a HTTP 403 Forbidden or 404 Page not found error.

Dovetail Mobile Agent web pages are not being refreshed on BlackBerry phones

(Article # 347) Users of Dovetail Mobile Agent having Blackberry phones can have problems with web pages being cached locally and not getting refreshed. It appears that t...

Dovetail SDK Web Service calls return a Could Not Load Assembly error

(Article # 348) Trying to use Dovetail SDK Web Services on a machine where the Dovetail SDK installer has not been run will result in the following error when trying to i...

Dovetail Search error: Server Application Unavailable

(Article # 287) Trying to perform a search against Dovetail Search results in the following error: Server Application Unavailable The web application you are attempting...

Dovetail Seeker Administration page returns 403 error : You are not authorized to view this page

(Article # 351) Using a browser to view the Dovetail Seeker Administration page (http://server/seeker/) returns a 403 error (you are not authorized to view this page) Er...

DovetailAdmin 2.4 :: part.asp :: Either BOF or EOF is True, or the current record has been deleted.

(Article # 245) In DovetailAdmin 2.4 , opening the parts page (part.asp) can result in the following error: Either BOF or EOF is True, or the current record has been del...

DovetailAgent error: The system cannot locate the resource specified in search_utility.asp

(Article # 316) msxml3.dll (0x800C0005) The system cannot locate the resource specified. /agent/search/search_utility.asp, line 19 Page: GET /agent/console/console.asp

EEO issues when display names use commas

(Article # 211) When using EEO in fcClient, and EEO tries to resolve names, there can be some confusing behavior if the display name has commas in it. For example, if th...

Enabling Dr. Watson to capture crash dump files and logs

(Article # 166) If you have a program crashing with an access violation and no way to get an unmanaged stack trace or any type of information about the crash, you can swi...

Enabling Storage of Unicode Data

(Article # 253) The fcSDK is fully Unicode-ready. Fields in your database can be flagged as Unicode fields and the fcSDK will process data in these columns correctly.

Error changing a password to a string starting with non letter characters

(Article # 341) Affects: Any application that uses the Dovetail SDK against an Oracle database Users will get the following error when attempting to change their passwo...

error closing a case: Invalid decimal value 'NaN' specified for field used_unit.

(Article # 192) An error occurrs when you try to close a case. (20084) (20147) Invalid decimal value 'NaN' specified for field used_unit. Value must be between -7922816...

Error compiling merge cb files

(Article # 124) Run cbex -batch -overwrite and it prompts for login info.

Error installing fcSDK: Error writing to file: FChoice.Common.dll.

(Article # 271) Installing the fcSDK errors: Executing op: AssemblyCopy(SourceName=FCHOIC_2.DLL|FChoice.Common.dll,SourceCabKey=gac fileCommon.dll,DestName=FChoice.Com...

error loading fcSDK state manager: Could not load file or assembly 'FChoice.Common'

(Article # 221) When trying to configure the statemanager for the fcSDK, an error can occur, such as: COMMON_RS_CANT_LOAD_STATEMANAGER_TYPE [FChoice.Common.State.MemoryS...

Error using FCSession.ChangePassword: Only members of the sysadmin role can use the loginame option.

(Article # 225) Error using FCSession.ChangePassword: FChoice.Common: Only members of the sysadmin role can use the loginame option. The password was not changed. This...

Error Value 'XXX' is too long to fit in field 'action_type'. Max length is 20.

(Article # 122) Error Number: -12020 API: fcInter.create_interact Ex. "Error Number = -12020 Error Message = Value 'Inbound:3rd Party Order' is too long to fit in f...

Error viewing CHM files: The page cannot be displayed

(Article # 265) Trying to read can result in the CHM file showing an error such as "The page cannot be displayed". There are several possible reasons why your CHM e-book...

Error: "-16 : This part has unique serialization(from the domain) that would be violated by the install"

(Article # 125) We want to install a Serial number against a site if it does not exists, Incase if its already existing then we want to deactive the existing Serial numbe...

Error: "The installer was interrupted before FCFL.NET could be installed. You need to restart the installer to try again. Click 'Close' to exit."

(Article # 134) When running the 'FCFL.NET_Setup.msi' installer, you may encounter the following error: "The installer was interrupted before FCFL.NET could be install...

Error: Clarify product is not installed at this site

(Article # 250) Trying to start the Clarify Classic Client ( clarify.exe ) or another Amdocs/Clarify application, the following error is displayed: Clarify product is no...

Error: csp_new_oid must be declared

(Article # 172) After a fresh install of FCFL you may encounter this error. The error may occur when updating the license key for the new installation.

Error: Incorrect syntax near 'xxx' on Generic.Query() FCFL.Net with SQL v6.5 compatibility

(Article # 139) RowLimit property is set to '2000' which generates the following error: System.Data error '80131904' Line 1: Incorrect syntax near '2000'. Generi...

error: SQL Server does not exist or access denied.

(Article # 246) The following behaviour was observed in Microsoft SQL Server 2005 (MSSQL 2005) In fcClient, in console_left.asp, the following error can appear: SQL Serv...

Error: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect

(Article # 236) Performing a query, especially one that involves a traversal ( traversefromparent , traversefromroot, etc.) can thron an unexpected error: The incoming ta...

example CSS for turning links into buttons

(Article # 210) example CSS for turning links into buttons. OK - they're not actually buttons, but they look like buttons.

Extra characters added in API invoke template emails sent to SEC.NET

(Article # 115) This problem has been observed on Microsoft Exchange 2003, but First Choice believes it applies to all versions of Microsoft Exchange since (at least) 5.5...

Extra query in change status for CBCL

(Article # 26) The stat.cbs routine in CBCL had two extra variables and an extra query to table_condition that was not needed. It had no adverse impact on correctness. K...

FCApp.Log can result in log entries with the wrong session user

(Article # 184) For web applications output of session information from FCApp.Log( message ) can be confusing in the rare situation that it is called before the current p...

fcclient 2.3: hyperlinks dont always show up in solutions

(Article # 89) fcclient 2.3: hyperlinks dont always show up in solutions

fcClient error: Directory Listing Denied

(Article # 198) Certain operations in fcClient fail with the error: Directory Listing Denied This Virtual Directory does not allow contents to be listed. Looking at the...

fcclient windows show URL in title bar before actual title

(Article # 208) When popup windows are opened in internet explorer (fofr example a case page), the title is expected to be: Case 1234. Instead, the title bar shows the UR...

fcclient: how to have biz rule messages include a URL that can pop a page

(Article # 97) fcclient: how to have biz rule messages include a URL that can pop a page

fcClient: Notifications when license limits are near

(Article # 252) The fcSDK is responsible for tracking and enforcing licensing. There is typically a license limit, then a small number of grace licenses that can be used...

fcfl error: "ORA-01840: input value not long enough for date format"

(Article # 99) fcfl error: "ORA-01840: input value not long enough for date format" Error only happens on Oracle 7 databases addnl keywords: fcfl, fcclient, fcadmin, fcs...

FCFL.NET initialize fails on Oracle 8.0

(Article # 118) FCFL.NET 1.1 contained a bug which prevented it from initializing the SchemCache against Oracle 8.0.x (8.0.6 in one specific case). The error message may ...

FChoice.Common: ORA-00936: missing expression error when using "is in" filter

(Article # 237) When using a large number of parameters for an "is in" filter on a query, and when there are many duplicate entries in the list, the fcSDK may generate in...

fcSDK Error initializing PerfManager: Category does not exist.

(Article # 207) When trying to run an application that uses the fcSDK, an error is thrown during the Initialization of the FCApplication object: 2006-03-29 16:31:09,534 ...

fcsdk error: Can not add an item of type long to an FCList containing

(Article # 197) Example Code: siteSetup.AdditionalFields.Append("x_comments", AdditionalFieldType.String, siteCol("x_comments")) siteSetup.AdditionalFields.Append("x_do...

fcSDK Error: This row has been removed from a table and does not have any data.

(Article # 209) fcSDK can throw an error: System.Data (0x80131928) This row has been removed from a table and does not have any data. BeginEdit() will allow creation of ...

fcSDK Install issues or problems,

(Article # 183) Error installing fcSDK: >> “failed to read IISWebstable (-2147023728)” keywords: IIS Installer fcSDK Wix Webs table Failed to read IIsWebs table

fcSDK Installer - ASPNET is not a valid user or group

(Article # 238) During installation of fcSDK on Windows operating systems with IIS5 a dialog appears with the text: "An error occurred while applying security settings ...

fcSDK Installer ends prematurely then uninstall fails to remove fcSDK

(Article # 235) The fcSDK installer through version 2.2.2 requires that the .Net 1.1 framework be present, although it doesn't properly verify this requirement. If only ...

fcSDK Installer fails on bad MDAC version (Requires 2.7)

(Article # 171) The fcSDK installer checks the registry to see what version of the MDAC you have installed. It does not proceed if you have a version less than 2.7. T...

fcSDK Issue when attempting to cache unexpected data types

(Article # 259) During the FCApplication Initialization, the fcSDK can throw an exception, such as: FChoice.Common: (5036) Unexpected DataSet row data type 'System.Byte[...

fcSDK on Clarify 6 (CFO 98)

(Article # 301) The fcSDK assumes that there is certain baseline schema present. Specifically, it assumes the following columns are present: table_state_prov.display_ord...

fcSDK Web Demo install fails with error " Mapping of accounts did not occur.."

(Article # 169) During the install of the fcSDK web demo an error can occur if ASP.NET is not setup properly on the target machine.

fcSDK: Compatibility Bulk: Records being inserted out of order.

(Article # 224) The fcSDK does not appear to save generics for the same table in the same order that they were added to the bulk. Normally, this isn't an issue. However...

fcSelfService Installation Error: 'length' is null or not an object

(Article # 93) I have successfully installed the FCFL and the FcClient. I can view/change cases, so I know that the FCFL is working. The SerfService web page, however, wi...

fcSelfService performance enhancement when searching for public solutions using FTS

(Article # 108) fcSelfService performance enhancement when searching for public solutions using FTS. When an FTS search is done, it queries the FTS database using ADO....

fcSqlExec limitation in Unicode characters when connecting to a different database

(Article # 299) The fcSDK COM interface allows programmers to use an fcSqlExec object. fcSqlExec is commonly used to execute arbitrary SQL against your Clarify/Dovetail d...

File or assembly name FChoice.Foundation.Clarify.Compatibility.Toolkits, or one of its dependencies, was not found.

(Article # 226) Using SEC.NET in apiinvoke mode can produce an error: File or assembly name FChoice.Foundation.Clarify.Compatibility.Toolkits, or one of its dependencies...

Finding the line number of a server-side error

(Article # 154) Often, while developing, you will run into a server-side error that you wish to debug. Most of the fcClient pages have a try/catch around the entire page,...

Flashes Anywhere error trying to open a flash: This Record object has an unknown RecordType.

(Article # 187) Install Flashes Anywhere for teh Clarify Classic Client. Add the sample new case code. (This sample code adds a new flashes tab, along with a grid of fla...

Font size of attached emails is too small to read

(Article # 318) If you use Dovetail Email Agent to automatically save incoming emails as a .mht attachment to a case, the font, when opened in Internet Explorer, of the ....

FTS error with fcClient: System Configuration File is inaccessible or corrupt.

(Article # 96) When performing an FTS search on fcClient, the following error is shown: [Fulcrum][SearchServer]System Configuration File is inaccessible or corrupt. Logg...

FTS search on fields with a "." does not work as a word separator

(Article # 132) Incident Description: I am modifying the FTS search to include some additional fields from the table_probdesc solution table. It appears to be working...

Getting BOLT running when set up in IIS on a Windows Server 2003 machine

(Article # 283) BOLT shows 404 Error when set up in IIS on a Windows Server 2003 machine. The virtual directory is configured as instructed in the documentation. The B...

Hosting Dovetail Mobile Agent using IIS5

(Article # 344) IIS 5 is not officially supported as a deployment platform for Dovetail Mobile Agent. It is possible to use IIS 5.1 on Windows XP do development testing...

How can I create a specific log just for fcQuery queries?

(Article # 298) How can I create a specific log just for fcQuery queries?

How can I tell if there is an initialize_app function in the db?

(Article # 36) When starting the install of First Choice products, it is sometimes necessary to merge initialize_app routines. Customer wanted to know how to tell if one ...

How can UNIX based customers use CR, RCR, SEC?

(Article # 33) A few of our products require processes to be run on a Windows NT or Windows 2000 machine. However, some customers are UNIX based. How can we make this wo...

How do I create a database in Clarify 12 or 12.5?

(Article # 294) I'm trying to create a new blank database for Clarify 12 (SQL Server version). I can't find the makedb utility. The dbcreate utility is there, but when I ...

How do I know which version of MDAC, ADO, OLEDB I have installed on my computer?

(Article # 79) How do I know which version of MDAC I have installed on my computer? There are multiple ways to do this - so view the multiple resolutions to this solut...

How do I set all users notifier to off using a SQL Script?

(Article # 322) How do I set all users notifier to off using a SQL Script?

How to add "Log Case/Subcase Notes" to the Context menu in the fcClient console when multiple items are selected

(Article # 105) Example on how to add "Log Case/Subcase Notes" to the Context menu in the fcClient console when multiple items are selected

How to add custom relations in our APIs

(Article # 30) Our APIs (ClearBasic and Bus Obj) allow you to set x_ fields (custom fields) to the tables. In some cases, customers want to set custom relations as well...

How to Add Extra Output Columns to QA

(Article # 10) How to Add Extra Output Columns to Query Anything (QA)

How to best use index analyze & index save in DIET

(Article # 131) How to best use index analyze & index save in DIET

How to configure timeout for in-memory fcSessions

(Article # 202) How to configure timeout for in-memory fcSessions for ASP or other COM based applications.

How to create business rules for custom objects

(Article # 234) How to create business rules for custom objects

How to customize Contact/Site Merge for custom fields/relations

(Article # 53) Question: How do you add custom relations in Contact/Site Merge? Question: How do I handle updating custom fields?

How to display a multi-level user-defined drop-down list in a web app such as fcClient

(Article # 174) How to display a multi-level user-defined drop-down list in a web app such as fcClient

How to enable fcSDK install logging

(Article # 182) How to enable fcSDK install logging

How to enable logging for the FC Data Verifier application

(Article # 160) If unexpected problems occur while running the FC Data Verifier application (which can be a separate application, or bundled with the FCFL.NET product), a...

How to find the 2nd level of a heirarchical table from the value in the 1st level?

(Article # 121) There are three tables: hgbst_lst (the overall list header with the title of the list), hgbst_show (each sublist in the user-defined list has one show (he...

How to have DIET import multiple files at one time

(Article # 328) DIET (Archive Manager) can import multiple DAT files at one time. This allows for import flexibility, such as having all your common references in one fi...

How to migrate fc_query information from one data base to another data base

(Article # 288) How to migrate fc_query information from one data base to another data base. For example, the client can put a lot of time and effort into their test env...

How to run the EEO Redirect Service (EEORS) in console mode

(Article # 104) If EEORS malfunctions and does not log adequate information to the Event Log (or stops logging altogether) it may be necessary to run EEORS in "console mo...

How to set the default TimeZone in Clarify

(Article # 186) By default Clarify will have a timezone of 'No Time Zone Specified' which is basically GMT. fcClient uses this default timezone when users login to aut...

How to tell which version of the .NET Framework is installed (including service packs)

(Article # 350) How to tell which version of the .NET Framework is installed (including service packs)

How to troubleshoot invalid user-defined lists (hgbst lists)

(Article # 200) When running the First Choice Data Verifier, customers may find that they have invalid user-defined lists in their system. Troubleshooting these lists can...

how to use an alternate provider in fcfl (com version), such as the oracle oledb driver provider

(Article # 103) how to use an alternate provider in fcfl (com version), for example the oracle oledb driver. Also - where do I get the Oracle9i Release 2 Data Provider f...

How to use Log4Net to log to a database table

(Article # 205) The fcSDK and fcSDK based applications (such as fcClient, SEC.NET, and fcSelfService) utilize Log4Net for robust logging capabilities. In addition to logg...

How to validate a user is a supervisor?

(Article # 128) 1)I'm looking to validate a whether user is a supervisor or not, how to do that? 2)In one of our application case, once user-agent is login using Sess...

HTTP Error 403 - Forbidden error using fcClient

(Article # 219) Using fcClient, the following error is displayed: You are not authorized to view this page You might not have permission to view this directory or page ...

IE crashes, or Windows blue-screen of death

(Article # 261) One customer reported that they occasionally Internet Explorer would crash when using fcClient. In addition, an occasional Windows blue screen of death co...

Implicit cross joins error occurs when editting a view

(Article # 285) When using Dovetail Schema Editor to create a new view or edit an existing one it is possible to get this error when previewing or applying a schema chang...

Indexes not successsfully added with DDCOMP on Oracle database

(Article # 177) When attempting to add an Index to an Oracle database using DDEditor (DDCOMP), I received the following message: (Trying to add index to alert_to-othe...

Information on Unified Login (sometimes referred to as Integrated Windows Security)

(Article # 336) Information on Unified Login (sometimes referred to as Integrated Windows Security)

Installing Dovetail Admin or Dovetail Agent on Windows 2003 Server

(Article # 100) There are some special requirements for installing the Dovetail Admin and/or Dovetail Agent ASP web applications on a Windows 2003 Server.

Installing Dovetail Classic ASP Web Applications on IIS7

(Article # 327) Blog post regarding Installing Dovetail Classic ASP Web Applications on IIS7:

Installing updates to Dovetail SDK requires that you uninstall existing versions.

(Article # 330) When installing newer versions of Dovetail SDK with an older version of the SDK already present. You will see a dialog that ask you if you want to 1) Modi...

Installing web applications on IIS7 (Vista and Widows Server 2008) fails.

(Article # 338) Changes to how Internet Information Server (IIS) is configured have caused problems with installers for Dovetail applications which create virtual web dir...

Insufficient memory during Clarify install

(Article # 157) You may encounter an insufficient memory error although there apprears to be plenty of free memory. Error 111.

Invalid column name 's_login_name' OR Invalid column name 's_alias_name'.

(Article # 240) On MSSQL databases, after applying schema changes using SchemaEditor, and then running fcClient, the following error can occur: Invalid column name s_logi...

Invalid Procedure Call - cbbatch on UNIX using cdate

(Article # 22) Example: now_time = CDate(now_str) The cbbatch engine returns CDate as invalid procedure call.

Invalid procedure call or argument on Initialize method using vbscript

(Article # 196) Code in vbScript: Set FCCS = Server.CreateObject("FCCompatToolkit.CS") InitFCCS = FCCS.Initialize(FCApp, FCSession) Result: Invalid procedure call or a...

Is Dovetail Mobile Agent compatible with BlackBerry devices?

(Article # 352) Is Dovetail Mobile Agent compatible with BlackBerry devices?

Is fcSDK and applications using it compatible with the .Net 2.0 framework?

(Article # 213) As of version 2.2.1 the fcSDK is build using version 1.1 of the .Net framework. Is it ok to run application utilizing the fcSDK on systems with only versi...

Is the create_case_objid_list API obsolete, or just not documented?

(Article # 331) I happen to notice that the case2.asp file calls the method create_case_objid_list on the FCCS object. However, this method is not found in the SDK docume...

Is there a way to display the list of timezones alphabetically?

(Article # 83) Is there a way to display the list of timezones alphabetically?

Is there any functionality in the FChoice APIs to de-install serial numbers?

(Article # 126) Is there any functionality in the FChoice APIs to de-install serial numbers?

Javascript compare object to string evaluates to false

(Article # 161) The following example comparison will always evaluate to FALSE: var sampleString = 'test string'; var sampleList = FCApp.GetGbstList('sample'); if ...

javascript: Unspecified error in web apps such as fcClient

(Article # 176) Trying to perform a Find By ID or open an item from the Recent Objects list can cause a javascript error, such as "unspecified error".

level_to_part and level_to_bin fields are always set to 1 in fcfo.install_sp

(Article # 232) When using the fcfo.install_sp method to install a part under another part, the level_to_part and level_to_bin fields are set to 1 instead of the appropri...

License Installer fails with error 'null' is not valid value for 'stream'

(Article # 162) License Installer fails with error 'null' is not valid value for 'stream'

Logs are not appearing for web applications.

(Article # 307) Dovetail web applications: Dovetail Agent, Dovetail Admin, Dovetail Seeker have logging mechanisms that are useful for application administrators to provi...

Make a field required

(Article # 149) 1. Give it a required attribute, and set it to true 2. Give it an errShow attribute, and set its value. This is the value that will be displayed if the f...

Manually setup Dovetail WebServices on Windows 2003 Server

(Article # 239) How to Manually setup Dovetail WebServices on Windows 2003 Server

MAPILogonEx failed for profile error when sending email through rule manager

(Article # 159) Error: MAPILogonEx failed for profile

Maximun size of archive/import in DIET

(Article # 130) Is there a maximum size of archive/import in DIET?

Missing field in Dovetail Admin 2.4

(Article # 243) In the new part manager screens, the following message can appear, on implementations using version 8.0 and earlier of Clarify: (20064) COMPAT_FIELD_DOES...

Missing or lost pages from pager_clerk (Paging Interface)

(Article # 337) If multiple pager_clerk.exe processes started and finished within the same second, the output file could be overwritten, causing outgoing pages to be “lo...

MQ Series Interfaces

(Article # 75) How can we integrate and/or interface with MQ Series?

Multiple Event ID 1003 messages when using FCFL.NET-based products

(Article # 117) On some Windows 2000 systems, when an application that uses FCFL.NET starts up (such as the SEC.NET service) FCFL.NET will load the PerfManager and some (...

No license when running DIET.

(Article # 129) When trying to run DIET is gives no licenses error.

Notification failure with temporary yank

(Article # 43) Business Rule notifications using Temp Yank as a condition can fail. Example Biz Rule: Name: Temporary yank of case/subcase Rule Status: Active Object Ty...

OCI-22053: overflow error

(Article # 254) Performing a query with a decimal field on Oracle using the fcSDK can throw an error: OCI-22053: overflow error One particular customer saw this error w...

Opening Dovetail.Agent.Mobile.sln throws an error: The application for the project is not installed.

(Article # 346) Opening Dovetail.Agent.Mobile.sln using Visual Studio 2008 throws an error: One or more projects in the solution could not be loaded for the following re...

Oracle 9i from ASP issue

(Article # 106) When connecting from ASP app using Oracle 9i drivers I received the following error: ORA-12638: Credential retrieval failed (related to solution # 92)

Oracle connection issues - BOLT, FCFL, fcClient, fcAdmin

(Article # 92) Error: Microsoft OLEDB Error Microsoft Odbc driver The Oracle(tm) client and networking components were not found. These components are supplied by Oracle...

Outlook security settings for EEO

(Article # 98) When using EEO in both classic client and in fcClient, Outlook client may prompt users if it is OK for another program to interact with Outlook. Example p...

Page Changes in fcClient from version 3.7 to version 3.8

(Article # 185) Page Changes in fcClient from version 3.7 to version 3.8

Parameter 'index' is out of bound for this collection. Max index: -1 Actual index: 0

(Article # 218) Error Type: FChoice.Common (0x80131600) (10003) Parameter 'index' is out of bound for this collection. Max index: -1 Actual index: 0 /mvsdpro/address/M...

Password algorithms in Clarify and in FCFL

(Article # 94) How are the password algorithms implemented in Clarify and in fcfl? FCFL uses the same password algorithms as Clarify does.

Permission denied when using an attachment directory over a Windows UNC file share

(Article # 114) When the application is configured to us a windows share (UNC path) as the attachment directory. It is common to run into permissions problems. When the...

Popup windows in fcClient and fcAdmin shows the location URL in the title bar in IE7

(Article # 231) Popup windows (for example, the case page, site page, etc.. (basically everything but the console)) display the location URL in the title bar. This is be...

potential issues on MSSQL 7 with fcfl.net, fcclient, toolkits, etc.

(Article # 120) We have seen a few problems on our internal Clarify ststem (focus9) which runs on MSSQL7. In earlier versions of MSSQL, an empty string could be returned...

Query Anything - missing keyword error with changeable date

(Article # 113) If you create a query with a date parameter between 2 dates, it builds the sql fine in the query screen, but if you make it changeable, it builds the sql ...

Quick start guide for setting up logging for Dovetail Agent and Dovetail Admin.

(Article # 136) All Dovetail applications that use our SDK have a logging capability that can be enabled. The following steps will get you up and running quickly with SDK...

Receive PR Workaround

(Article # 216) If Receive is being performed through the fcClient Receive tab, the Condition for the Part Request is not being changed.

(Article # 116) Recommended Application Protection for First Choice Web Apps (fcClient, fcAdmin, fcSelfService)

(Article # 109) recommended configuration for IIS and Win2K servers to support FCFL

(Article # 165) To appropriately monitor performance of the application you will need to turn on monitoring for the application. We recommend setting the below counters ...

Requests for static files return 404 error (IIS 6.0)

(Article # 276) When trying to view (download) an attachment (such as a log file) from within Dovetail Agent or Dovetail SelfService, a 404 (page not found) error happens...

Requiring that a web applicaton in IIS only use secure (SSL) communications.

(Article # 293) When your IIS web server has a server certificate installed it is possible to use the secure https protocol for your web applications. You may wish to req...

RES and Select Sampler issue on Form 425 when expanding queue title

(Article # 77) If you expand the length of the queue.title field, i.e. expand it from 24 to 36 characters, and you have queues that have the first 24 characters the same,...

RES in Clarify 11.5 can cause error: The given form for this operation is invalid (possibly already closed)

(Article # 90) RES (data restriction) in Clarify 11.5 can cause error: The given form for this operation is invalid (possibly already closed). The problem occurs when tr...

Results appear differently between Clarify and fcClient

(Article # 143) You may run accross an issue where results appear to return differently in the Clarify Classic Client and fcClient for the same screen.

Return code -5 in create_inv_bin when it should be OK

(Article # 27) In the create_inv_bin or update_inv_bin API (CBCL), a return code of -5 (bin already exists) could be returned when it shouldn't. The reason is that the ch...

Rulemanager error: System.InvalidOperationException: Cannot start process because a file name has not been provided.

(Article # 270) When RuleManager attempts to send a execute a process or send a page (using the NotificationConfig.PagerApplicationPath), the following error can occur: ...

Running DIET on SQL Server 2005 throws error: ntwdblib.dll not found

(Article # 247) DIET (at least as of version 2.1.11) uses SQL Server db library (ntwdblib.dll) to connect to SQL Server databases. As of SQL Server 2005, this library is ...

Running Dovetail Web Applications on Vista or Windows Server 2008 64-bit with IIS 7

(Article # 303) When attempting to run any of the Dovetail ASP web applications (Agent, Self Service, Admin, Bolt, etc) on Windows Vista x64 or Windows Server 2008 x64 ed...

Save, Discard, Cancel not available on workflow actions

(Article # 144) If a Case, CR, PR Detail, etc. is modified in fcClient, and then a "workflow action" (discard, assign, move, etc.) is performed before the changes are sav...

SchemaEditor Error Occurred : a different object with the same identifier value was already associated with the session:

(Article # 313) When applying a schema script, the preview is successful, but the apply action throws an error. An error occurred while applying schema changes to the da...

SchemaEditor error: Could not find column for SpecFieldID 5

(Article # 315) SchemaEditor can throw the following error: Could not find column for SpecFieldID 5 Note that the number 5 could be almost any integer.

SEC daemon shows a message was processed successful, but the message doesn't show up in database

(Article # 57) While running the SEC daemon, an email was sent in that should have created a case. The message was moved to the Success folder, but the case was never cr...

SEC error: The operation failed. An object could not be found.

(Article # 189) Running SEC produces an error: TRACE:>> 0 CALL sec_daemon in SEC_daemon.cbs by vba_exec_run_subroutine The operation failed. An object could not be foun...

SEC.NET installer fails

(Article # 201) The SEC.NET installer can fail to complete when installation instructions are not followed correctly.

SEC: Cannot find the specified case or other error due to extra CRLF

(Article # 38) When running SEC, customers may get an unexpected return code from an API call, such as: Cannot find the specified case This may be due to the fact that t...

SEC: Extra blank lines at the beginning of email sent from Lotus causes problems

(Article # 39) This was sent in by a customer. It has not been tested and verified here.

SEC: Get a "Cannot create contact because a "first_name:last_name:phone" already exists

(Article # 34) In some cases, with freeform emails, the customer will see something like the unique index violation error message in the title of this solution, and the d...

SEC: How to create multiple daemons

(Article # 37) Customer wants more info on how to create multiple daemons.

SEC: Infinite number of cases created. Have to kill daemon to get them to stop

(Article # 35) The customer sends in one email to an SEC mailbox. The daemon continues to create new cases until it is killed. This is very easy. The customer sent the e...

Seeker give a "The page cannot be displayed (404) error when performing a search.

(Article # 317) When using a virtual directory for Dovetail Seeker other than the default virtual directory created during the install of the application, the .aspx and ....

Seeker web application returns 404 error

(Article # 305) Internet Information Server (IIS) on Windows Server 2003 and Windows Server 2008 default behavior is to have ASP.Net web applications disabled. Dovetai...

Session state with multiple load balanced web servers

(Article # 127) A custom web application using fcfl is loaded on two web servers which is handled by a load balancer. The end-user is not able to keep the session creat...

Skype add-on can cause Internet Explorer to crash when using Dovetail Agent

(Article # 333) NOTE: This problem encountered on Windows 2008 x64 and Internet Explorer 7. However, other platform combinations may be affected as well. Internet Explor...

Some foreign characters are not recorded when performing a Log Email using EEO

(Article # 334) Retrieve an existing case in Dovetail Agent. Log an e-mail, using the EEO Log Email form. Enter the message: "Hej på er! Ni som är experter på Clarify ...

Sql Server connectivity issues

(Article # 258) One customer reported an intermittent problem connecting to microsoft sql server 7 (mssql 7) using fcClient and the fcSDK after upgrading to the 2.0 versi...

Sub Queue Group Loses Connection To Parent

(Article # 137) Using the Queue Groups product, it was noticed that if a user updated a queue group, and that queue group was listed as a sub group of another queue group...

Sub Queue Group Loses Connection To Parent

(Article # 138) Using the Queue Groups product, it was noticed that if a user updated a queue group, and that queue group was listed as a sub group of another queue group...

Support for IE7 ( Internet Explorer 7)

(Article # 228) Support for IE7 ( Internet Explorer 7) ( ie 7 ) in fcClient and fcAdmin

Switch To Retry Busy dialog during OLE operation

(Article # 227) When performing an OLE operation, the user can be presented with a SwitchTo/Retry/Cancel dialog. For example, the MailMerge product uses OLE to communi...

SwitchUser: If switch user is used without proper setup, the session fails

(Article # 180) Scenario: Login to fcClient Select User -> Switch User Select an employee to switch to Select "Switch" Result: Error: (10158) Creating sessions w...

System running low on virtual memory.

(Article # 158) An application using fc APIs may runs low on virtual memory.

System.Security.SecurityException

(Article # 175) Trying to run a .NET application (such as hgbstutils.exe) can result in an error: An unhandled exception of type 'System.Security.SecurityException' oc...

The HTTP headers are already written to the client browser.

(Article # 88) The following error was displayed in fcAdmin: Response object error 'ASP 0156 : 80004005' Header Error /fcadmin/login/login2.asp, line 95 The HTTP head...

There is no script engine for file extension ".js".

(Article # 268) Trying to use cscript to execute a Javascript script can result in the following error: Input Error: There is no script engine for file extension ".js".

This service has been marked for deletion

(Article # 269) If you uninstall a Windows service (such as SEC.NET or Rulemanager) , it may still show in the Services console (services.msc) If you try to start it, sto...

Timeout expired. The timeout period elapsed prior to completion

(Article # 278) When using a Dovetail product, the following exception can occur: Exception: Timeout expired. The timeout period elapsed prior to completion of t he ope...

Toolkits APIs with contact sessions that do not specifying usernames can error.

(Article # 170) The fcSDK Toolkit API is called using a Contact based session and the username property on the API call is not set. The API will attempt to use the "user....

All Knowledge Base Articles

There are 272 articles for "All Articles".