My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.