Export Issue (Doc ID 519046.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 7.5.3 [103] to 8.1.1 [21112] [Release V7 to V8]
z*OBSOLETE: Microsoft Windows 2000
Database: Oracle 8.1.7.4
Application Server OS: Microsoft Windows 2000 Advanced Server SP 4
Database Server OS: Sun Solaris 7
***Checked for relevance on 30-Oct-2013***

This document was previously published as Siebel SR 38-1590955721.


Symptoms

Follow the below steps:
1. Query on Accounts using City as "Anywhere's"
2. Export the result set with All Rows selected
3.  "An error has occurred finding your prior place in the system. Please try a new query.(SBL-DAT-00252)" is observed.

However the export successfully works for
"Anywhere's Corp" or
"The Anywhere's" or
Anywhere*

It will also work if Only Current Row is selected in the export dialog.

There are some custom scripts written on Pre-Query and Query events of Account BC. If we comment these scripts, the above problem could not be replicated. The above scripts help to force case-sensitive queries on Account name (and has been implemented after discussion with Siebel), thus improving performance for Local users, who use a case insensitive application.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms