SBL-DAT-00252: An error has occurred finding your prior place in the system. Please try a new query.

Applies to:

Siebel Tools - Version: 7.8.2 [19213] and later   [Release: V7 and later ]
Information in this document applies to any platform.
Error Message Area:Data Manager - DAT
Version:Siebel 7.8

Purpose

This document is intended to provide cause and corrective action information about Siebel Error Message SBL-DAT-00252: An error has occurred finding your prior place in the system. Please try a new query.

Scope

This document is informational and intended for any user.

SBL-DAT-00252: An error has occurred finding your prior place in the system. Please try a new query.

Explanation

1. The Object Manager was unable to go back to the previous view. This could either be a configuration error (for example, applet and business component search specifications are not consistent), or the user performed an operation to change the ownership of a record, making it invisible to him/her.

2. You have executed an incorrect query. Although records are returned, the error occurs when you try to export.

3. MaxCursorSize is set to a value lower than the default fetch size in the Show More mode.

Corrective Action

1. Verify that the applet and business component search specifications are consistent and that the user has visibility to the record.

Investigate the user actions prior to this error. SQL spooling can also be useful.

2. Verify that you are performing a correct query and that the result set appears appropriate before exporting.

Change request 12-IK04J5 has been logged and has been addressed in Siebel application version 7.7.

3. Check if the Show More mode had been selected on the list applet in the previous view and if MaxCursorSize is set to a value less than the default fetch size in the Show More mode. MaxCursorSize is typically set in DB2390 environments.

Applies to:

Siebel Tools - Version: 7.8.2.7 [19234] and later   [Release: V7 and later ]
Information in this document applies to any platform.

Symptoms

When user executes a particular query which contains huge amount of row Ids to search for in the "Opportunities list view ( across all organizations)", the results are returned. However, when the user right clicks and chooses the export option with "all columns", the following error is shown:

We detected an Error which may have occurred for one or more of the following reasons:

An error has occurred finding your prior place in the system. Please try a new query.(SBL-DAT-00252)

An example of the search criteria:

12KY-TH1IIN OR 12KY-11CHW5J OR 12KY-123Z7B9 OR 12KY-10UDSED OR 12KY-10QEC2L OR 12KY-ZZ96BX OR 12KY-110DAAB OR 12KY-PWD8BN OR 12KY-110FN0S OR 12KY-110FN4R OR 12KY-11BJ9SU OR 12KY-10KDD8B OR 12KY-Z9EOSB OR 12KY-11UUHXP OR 12KY-ZIOEDD OR 12KY-118PDFD OR 12KY-QCQF1V OR 12KY-118727Q OR 12KY-ZJ68L7 OR 12KY-ZE1YXN OR 12KY-U41VEJ OR 12KY-11D9IQD OR 12KY-ZN5ELZ OR 12KY-ZN41FQ OR 12KY-11G0URW OR 12KY-11FVAR1 OR 12KY-YQASZ0 OR 12KY-11H2IX1 OR 12KY-106KSSW OR 12KY-YIH30P OR 12KY-SZNVMS OR 12KY-ZRC7AZ OR 12KY-ZC2JKP OR 12KY-111OZ5T OR 12KY-PPPZQ0 OR 12KY-105MRDI OR 12KY-10Z6VHQ OR 12KY-1072EE6 OR 12KY-11343CB OR 12KY-Y7PH1B OR 12KY-Y1QO83 OR 12KY-ZS4H0P OR 12KY-TNVL8O OR 12KY-11PCE1B OR 12KY-ZE7NOS OR 12KY-ZEC2NF OR 12KY-YEFRQU OR 12KY-Y89SHZ OR 12KY-Y04B17 OR 12KY-WZ6GYP OR 12KY-SOL5BV OR 12KY-YIBJBI OR 12KY-RKZ94B OR 12KY-R03155 OR 12KY-VMX0IP OR 12KY-ZGF6P6 OR 12KY-1103JW6 OR 12KY-SEIC5Y OR 12KY-Y5ZXZN OR 12KY-Z7G4AN OR 12KY-11R1UUV OR 12KY-10SH0HD OR 12KY-108LKPB OR 12KY-X2RQLH OR 12KY-XH00CI OR 12KY-WA03UB OR 12KY-ONCQTU OR 12KY-YULSBR OR 12KY-U1SUPK OR 12KY-YGGBAD OR 12KY-UP1YP1 OR 12KY-WOYLUL OR 12KY-SA6ZF7 OR 12KY-ZCUQ0N OR 12KY-YDHTD8 OR 12KY-ZB387T OR 12KY-11114X1 OR 12KY-ZYMTIF OR 12KY-ZJJX09 OR 12KY-109S5S5 OR 12KY-YST3BD OR 12KY-TVKM7P OR 12KY-VR49M4 OR 12KY-YY1U57 OR 12KY-YAPGWP OR 12KY-Z5GCG3 OR 12KY-Z0DQ31 OR 12KY-VURA3O OR 12KY-YTPT7F OR 12KY-WC2X9X OR 12KY-W3CSTF OR 12KY-URDWZN OR 12KY-YV0V72 OR 12KY-YYNALF OR 12KY-YOJEN3 OR 12KY-10JBNAL OR 12KY-10ALZW0 OR 12KY-YRVRFI OR 12KY-TMVBML OR 12KY-10E6RIF OR 12KY-VU5KWD OR 12KY-REF7GO OR 12KY-ZDT4XP OR 12KY-12W45JN OR 12KY-12POBDV OR 12KY-11QQ6SM OR 12KY-124KO39 OR 12KY-10852RX OR 12KY-10O98TE OR 12KY-11VBA9X OR 12KY-10STCVO OR 12KY-10STCSQ OR 12KY-10YNL2G OR 12KY-11NX8W1 OR 12KY-WGDH2F OR 12KY-RQ8YWY OR 12KY-S6M23T OR 12KY-ZOERRQ OR 12KY-ZALSVV OR 12KY-WRM3JJ OR 12KY-Z1HC83 OR 12KY-S9OI6R OR 12KY-R9F7EW OR 12KY-Z1MWD9 OR 12KY-X014CV OR 12KY-109CGWB OR GB1162976303727 OR 12KY-SG8DY4 OR 12KY-X4V3B2 OR 12KY-YQOEV0 OR 12KY-YRW94V OR 12KY-YQF3UD OR 12KY-XIPDYN OR 12KY-Z18L2C OR 12KY-YI4AX6 OR 12KY-S1F6RZ OR 12KY-11ETFRJ OR 12KY-YQUIEM OR 12KY-SIFNAD OR 12KY-105KF1T OR 12KY-Q2FYQN OR 12KY-YIXGGA OR 12KY-YOR6BE OR 12KY-YOU51C OR 12KY-WOHGOG OR 12KY-WXFL4B OR 12KY-OP3Z6X OR 12KY-W0KQ7O OR 12KY-UFJ7SL OR 12KY-QH3JI1 OR 12KY-SO8QYK OR 12KY-WUEQ1Z OR 12KY-WOHFBY OR 12KY-PWT5UM OR 12KY-Z0YQBF OR 12KY-YJK6FI OR 12KY-XDE178 OR 12KY-W18J99 OR 12KX-IKX8JZ OR 12KY-LJCX18 OR 12KX-HB4KHZ OR 12KY-LKEP2J OR 12KX-HP9QQ0 OR 12KY-MFCKYH OR 12KY-OFTJQX OR 12KY-OHWRZ3 OR 12KY-P00Q9V OR 1JF-5UEM3H OR 1JF-3SEDBR OR 1JF-1XOPW1 OR 1JF-3AB7JN OR 1JF-UNN26 OR 1JF-3AB7KG OR 12KY-MRKUVE OR 12KY-137N6TZ OR 12KY-WJ949F OR 12KY-12Z39XN OR 12KY-SWBSTG OR 12KY-13FDQ5D OR 12KY-12RCU0B OR 12KY-13JJKHS OR 12KY-13SE1UU OR 12KY-138NJIP OR 12KY-13S84Y5 OR 12KY-149WT9C OR 12KY-140VIJ9 OR 12KY-146WM6F OR 12KY-S6YF2L OR 12KY-12YSH2D OR 12KY-14C0ZTA OR 12KY-1306GGX OR 12KY-14E87MS OR 12KY-14FRD9C OR 12KY-144YJRH OR 12KY-13YL0HP OR 12KY-14GDX0X OR 12KY-14GDX49 OR 12KY-YIFW4N OR 12KY-14GJALQ OR 12KY-13PXPV5 OR 12KY-14GHSMX OR 12KY-YIC5LB OR 12KY-XQFWKZ OR 12KY-142NJ1B OR 12KY-1419T0G OR 12KY-1419SY2 OR 12KY-13BTR6B OR 12KY-12R9JLR OR 1JF-W49MG3 OR 12KY-11QPOEP OR 12KY-136TDTF OR 12KY-YRRLVQ OR 12KY-P83CD0 OR 12KY-136KVXP OR 12KY-136KVUF OR 12KY-13FEK8D OR 12KY-110QE6C OR 12KY-10K5Y5L OR 1JF-OGB2C1 OR 1JF-8YZ8R9 OR 1JF-TFVHAJ OR 12KY-R7TF5E OR 1JF-UE0FRO OR 12KY-TBHDUC OR 1JF-UE0FR5 OR 12KY-12W3RRJ OR 12KY-12W3RU2 OR 12KY-12W3RWP OR 12KY-11XJJVL OR 12KY-Z0BSF4 OR 12KY-PYWYGX OR 12KY-VBJTYT OR 12KY-QIZLBX OR 12KY-VPE6AZ OR 12KY-PA2ZMF OR 12KY-U81S8M OR 12KY-W44AM7 OR 1JF-2I66VD OR 1JF-2QAMQH OR 1JF-4Y5RN4 OR 1JF-2I66UF OR 1JF-2I66VV OR 1JF-421BK3 OR 1JF-42P74P OR 1JF-421BKO OR 1JF-3AFX0H OR 1JF-4Y4GKN OR 12KY-RA7QII OR 1JF-9HLR89 OR 1JF-4HG5J OR 12KY-RNE47J OR 12KY-T7XPZ9 OR 12KY-T954IU OR 12KY-SIV7OE OR 12KY-N6R4QE OR 12KY-SQJQ0S OR 12KY-RDDD4V OR 12KY-W4RE61 OR 1JF-WO8GD OR 12KY-VGHM99 OR 12KY-WGJ813 OR 12KY-RW1AMP OR 12KY-WOK1KU OR 12KY-WM1KX8 OR 12KY-YT6KU9 OR 12KY-ZBMDI8 OR 12KY-ZGKZOF OR 12KY-WKXKID OR 12KY-WKXKUL OR 12KY-WZKTEN OR 12KY-WKXKR8 OR 12KY-WWRTRM OR 12KY-WIV2EM OR 12KY-ZGLPZN OR 12KY-WG7S0T OR 12KY-WGFPBV OR 12KY-Y7F9LD OR 12KY-TG3HKY OR 12KY-TG6H1W OR 12KY-TG7PQN OR 1JF-ELX1B OR 12KY-QK9Y1I OR 1JF-3Y1SF OR 12KY-OPXTEN OR 12KY-P4NAQU OR 1JF-9L6HKN OR 12KY-YEODHZ OR 12KY-X22PTU OR 12KY-TV319N OR 12KY-TX2PF5 OR 12KY-VT7NPC OR 12KY-TVQZHA OR 12KY-UTS3QL OR 12KY-UP1AOS OR 12KY-YRV0EV OR 12KY-Q4DS7A OR 12KY-10GCBJX OR 12KY-10KRU3R OR 12KY-10J921M OR 12KY-11I21E3 OR 12KY-12TDI7O OR 12KY-15PZX53 OR 1JF-1VYZS7 OR 1JF-1VYZSL OR 1JF-2QH15D OR 12KY-R3D64K OR 12KY-XYEOX3 OR 12KY-1250ZXG OR 12KY-S6HZ1L OR 12KY-T3PPL6 OR 12KY-S2VZ2M OR 12KY-S3FGXL OR 1JF-UDWHJP OR 1JF-V5KGLD

Cause

The cause of the error is due to the system not able to retrieve the full prior search expression. From the siebel.log file, it is observed that the condition is truncated, thus giving an error in the SQL statement. It appears that a maximum size might have been hit when the system is trying to retrieve the previous search expression.

Here is the condition used in the query when the "Export" button is performed.

'[Name] ~= "12KY-TH1IIN" OR [Name] ~= "12KY-11CHW5J" OR [Name] ~=
"12KY-123Z7B9" OR [Name] ~= "12KY-10UDSED" OR [Name] ~= "12KY-10QEC2L"
OR [Name] ~= "12KY-ZZ96BX" OR [Name] ~= "12KY-110DAAB" OR [Name] ~=
"12KY-PWD8BN" OR [Name] ~= "12KY-110FN0S" OR [Name] ~= "12KY-110FN4R"
OR [Name] ~= "12KY-11BJ9SU" OR [Name] ~= "12KY-10KDD8B" OR [Name] ~=
"12KY-Z9EOSB" OR [Name] ~= "12KY-11UUHXP" OR [Name] ~= "12KY-ZIOEDD" OR
[Name] ~= "12KY-118PDFD" OR [Name] ~= "12KY-QCQF1V" OR [Name] ~=
"12KY-118727Q" OR [Name] ~= "12KY-ZJ68L7" OR [Name] ~= "12KY-ZE1YXN" OR
[Name] ~= "12KY-U41VEJ" OR [Name] ~= "12KY-11D9IQD" OR [Name] ~=
"12KY-ZN5ELZ" OR [Name] ~= "12KY-ZN41FQ" OR [Name] ~= "12KY-11G0URW" OR
[Name] ~= "12KY-11FVAR1" OR [Name] ~= "12KY-YQASZ0" OR [Name] ~=
"12KY-11H2IX1" OR [Name] ~= "12KY-106KSSW" OR [Name] ~= "12KY-YIH30P"
OR [Name] ~= "12KY-SZNVMS" OR [Name] ~= "12KY-ZRC7AZ" OR [Name] ~=
"12KY-ZC2JKP" OR [Name] ~= "12KY-111OZ5T" OR [Name] ~= "12KY-PPPZQ0" OR
[Name] ~= "12KY-105MRDI" OR [Name] ~= "12KY-10Z6VHQ" OR [Name] ~=
"12KY-1072EE6" OR [Name] ~= "12KY-11343CB" OR [Name] ~= "12KY-Y7PH1B"
OR [Name] ~= "12KY-Y1QO83" OR [Name] ~= "12KY-ZS4H0P" OR [Name] ~=
"12KY-TNVL8O" OR [Name] ~= "12KY-11PCE1B" OR [Name] ~= "12KY-ZE7NOS" OR
[Name] ~= "12KY-ZEC2NF" OR [Name] ~= "12KY-YEFRQU" OR [Name] ~=
"12KY-Y89SHZ" OR [Name] ~= "12KY-Y04B17" OR [Name] ~= "12KY-WZ6GYP" OR
[Name] ~= "12KY-SOL5BV" OR [Name] ~= "12KY-YIBJBI" OR [Name] ~=
"12KY-RKZ94B" OR [Name] ~= "12KY-R03155" OR [Name] ~= "12KY-VMX0IP" OR
[Name] ~= "12KY-ZGF6P6" OR [Name] ~= "12KY-1103JW6" OR [Name] ~=
"12KY-SEIC5Y" OR [Name] ~= "12KY-Y5ZXZN" OR [Name] ~= "12KY-Z7G4AN" OR
[Name] ~= "12KY-11R1UUV" OR [Name] ~= "12KY-10SH0HD" OR [Name] ~=
"12KY-108LKPB" OR [Name] ~= "12KY-X2RQLH" OR [Name] ~= "12KY-XH00CI" OR
[Name] ~= "12KY-WA03UB" OR [Name] ~= "12KY-ONCQTU" OR [Name] ~=
"12KY-YULSBR" OR [Name] ~= "12KY-U1SUPK" OR [Name] ~= "12KY-YGGBAD" OR
[Name] ~= "12KY-UP1YP1" OR [Name] ~= "12KY-WOYLUL" OR [Name] ~=
"12KY-SA6ZF7" OR [Name] ~= "12KY-ZCUQ0N" OR [Name] ~= "12KY-YDHTD8" OR
[Name] ~= "12KY-ZB387T" OR [Name] ~= "12KY-11114X1" OR [Name] ~=
"12KY-ZYMTIF" OR [Name] ~= "12KY-ZJJX09" OR [Name] ~= "12KY-109S5S5" OR
[Name] ~= "12KY-YST3BD" OR [Name] ~= "12KY-TVKM7P" OR [Name] ~=
"12KY-VR49M4" OR [Name] ~= "12KY-YY1U57" OR [Name] ~= "12KY-YAPGWP" OR
[Name] ~= "12KY-Z5GCG3" OR [Name] ~= "12KY-Z0DQ31" OR [Name] ~=
"12KY-VURA3O" OR [Name] ~= "12KY-YTPT7F" OR [Name] ~= "12KY-WC2X9X" OR
[Name] ~= "12KY-W3CSTF" OR [Name] ~= "12KY-URDWZN" OR [Name] ~=
"12KY-YV0V72" OR [Name] ~= "12KY-YYNALF" OR [Name] ~= "12KY-YOJEN3" OR
[Name] ~= "12KY-10JBNAL" OR [Name] ~= "12KY-10ALZW0" OR [Name] ~=
"12KY-YRVRFI" OR [Name] ~= "12KY-TMVBML" OR [Name] ~= "12KY-10E6RIF" OR
[Name] ~= "12KY-VU5KWD" OR [Name] ~= "12KY-REF7GO" OR [Name] ~=
"12KY-ZDT4XP" OR [Name] ~= "12KY-12W45JN" OR [Name] ~= "12KY-12POBDV"
OR [Name] ~= "12KY-11QQ6SM" OR [Name] ~= "12KY-124KO39" OR [Name] ~=
"12KY-10852RX" OR [Name] ~= "12KY-10O98TE" OR [Name] ~= "12KY-11VBA9X"
OR [Name] ~= "12KY-10STCVO" OR [Name] ~= "12KY-10STCSQ" OR [Name] ~=
"12KY-10YNL2G" OR [Name] ~= "12KY-11NX8W1" OR [Name] ~= "12KY-WGDH2F"
OR [Name] ~= "12KY-RQ8YWY" OR [Name] ~= "12KY-S6M23T" OR [Name] ~=
"12KY-ZOERRQ" OR [Name] ~= "12KY-ZALSVV" OR [Name] ~= "12KY-WRM3JJ" OR
[Name] ~= "12KY-Z1HC83" OR [Name] ~= "12KY-S9OI6R" OR [Name] ~=
"12KY-R9F7EW" OR [Name] ~= "12KY-Z1MWD9" OR [Name] ~= "12KY-X014CV" OR
[Name] ~= "12KY-109CGWB" OR [Name] ~= "GB1162976303727" OR [Name] ~=
"12KY-SG8DY4" OR [Name] ~= "12KY-X4V3B2" OR [Name] ~= "12KY-YQOEV0" OR
[Name] ~= "12KY-YRW94V" OR [Name] ~= "12KY-YQF3UD" OR [Name] ~=
"12KY-XIPDYN" OR [Name] ~= "12KY-Z18L2C" OR [Name] ~= "12KY-YI4AX6" OR
[Name] ~= "12KY-S1F6RZ" OR [Name] ~= "12KY-11ETFRJ" OR [Name] ~=
"12KY-YQUIEM" OR [Name] ~= "12KY-SIFNAD" OR [Name] ~= "12KY-105KF1T" OR
[Name] ~= "12KY-Q2FYQN" OR [Name] ~= "12KY-YIXGGA" OR [Name] ~=
"12KY-YOR6BE" OR [Name] ~= "12KY-YOU51C" OR [Name] ~= "12KY-WOHGOG" OR
[Name] ~= "12KY-WXFL4B" OR [Name] ~= "12KY-OP3Z6X" OR [Na

...

ObjMgrQueryLog    Warning    2    0    2010-08-16 10:20:58   
(query.cpp (371)) SBL-DAT-00403: The query could not be run because there is an invalid character in the field 'Name'.  Please ensure that the value in the field is formatted correctly with only valid characters.

Solution

A solution to this error is to reduce the search expression as much as possible. Alternatively, a script option can be used here.

The idea here is to intercept and set the search expression entered by user again in "BusComp_PreQuery" to prevent the truncation of the expression from "ExportQuery" method (used by "Export" menu item).

Here are some suggested steps:
(1) In "WebApplet_PreInvokeMethod" event of "Opportunity List Applet", add the following script:
function WebApplet_PreInvokeMethod (MethodName)
{
if(MethodName == "ExportQuery")
{
with(this.BusComp())
{
var SearchExpr = GetSearchExpr();
var ViewMode = GetViewMode();

TheApplication().SetSharedGlobal("SearchExpr", SearchExpr);
TheApplication().SetSharedGlobal("ViewMode", ViewMode);
}
}
return (ContinueOperation);
}

(2) In "BusComp_PreQuery" event of "Opportunity" business component:
var SearchExpr = TheApplication().GetSharedGlobal("SearchExpr");
var ViewMode = TheApplication().GetSharedGlobal("ViewMode");

if (SearchExpr != "")
{
this.ClearToQuery();
this.SetViewMode(ViewMode);
this.SetSearchExpr(SearchExpr);
}

(3) In "WebApplet_InvokeMethod" event of "SWE Export Applet":
if (MethodName == "CloseApplet")
{
TheApplication().SetSharedGlobal("SearchExpr", "");
TheApplication().SetSharedGlobal("ViewMode", "");
}

Step (1) is to store the search expression entered by user. Step (2) is to reset the search expression and view mode when "Export" menu item is used. Step (3) is to reset the shared variables. Note that the script is tested with limited test cases. Do test and modify the suggestion accordingly.

Change Request 12-1ZE4HJB has been logged to address the truncation of the search expression when "Export" button is used.

References

BUG:12-1ZE4HJB - (SBL-DAT-00252) WHEN TRYING TO EXPORT THE RECORDS WHICH USED MASSIVE CONDITIONS

Applies to:

Siebel CRM Call Center - Version: 8.0.0.6 [20423] and later   [Release: V8 and later ]
Information in this document applies to any platform.

Goal

Customer was querying for multiple Account records in the Accounts list applet and getting the "An Error Has Occurred Finding Your Prior Place In The System" error.

The steps to reproduce this were:

1) Navigate to Account list applet
2) Query for >1000 records to be returned . The query run for this was (Account1 OR Account2 OR Account3 ...... to Account1000
3) Select Menu > Record Count
4) Select Menu > Export

Error message of : We detected an Error which may have occurred for one or more of the following reasons:


An error has occurred finding your prior place in the system. Please try a new query.(SBL-DAT-00252)

If in step 2 the query returns <1000 records the export works.

The db Oracle 10 has this issue but is not re-producible in sample db.

Solution

CR#12-1YZND7N has been raised for this issue and the intended fix pack is for 8.0.0.11. However, please be aware that while it is our intention to include a fix for this issue in this fixpack, until it is actually released, this cannot be confirmed. Issues may arise during the last stages of the development and testing cycles prior to the release of the fixpack, which may cause the fix delivery to be delayed to a subsequent FixPack

The suggested workaround would be reformulate the search criteria that you are using in a way that uses less than 1000 'OR' conditions.

References

BUG:12-1XRKKN7 - SBL-DAT-00252 ERROR WHEN EXPORTING ALL ROWS IN CURRENT QUERY
BUG:12-1YZND7N - AN ERROR HAS OCCURRED FINDING YOUR PRIOR PLACE IN THE SYSTEM