My Oracle Support Banner

RepositoryUpgrade Utility failed with error "Please execute a query that returns at least one record or add a new record.(SBL-DAT-00215)" (Doc ID 2512823.1)

Last updated on JULY 09, 2020

Applies to:

Siebel CRM - Version 18.12 and later
Information in this document applies to any platform.

Symptoms


Siebel binaries are updated to 18.12 and while running RepositoryUpgrade utility it is failing.


Error:

Repository Import Starts

------------------------------------------

There is an error in the file C:\Siebel\Tools/log/RepositoryUpgrade_20190122_184759/18.9/ALL_import_repo_sif.log.


ERROR
-----------------------
ALL_import_repo_sif.log


Comparing import objects with repository objects ...

Checking that projects are already locked ...

Applying changes to repository at 02/26/19 09:10:56

Inserting object: Symbolic String 'SBL_CREATE_MANIFEST' of Project 'Symbolic Strings'

-> 3error setting 'Name' = 'SBL_CREATE_MANIFEST' -- This operation is not allowed when there are no records displayed.

Please execute a query that returns at least one record or add a new record.(SBL-DAT-00215)!

Rolling back transaction for all changes ...

!!ERROR::This operation is not allowed when there are no records displayed.

Please execute a query that returns at least one record or add a new record.(SBL-DAT-00215)--

No transaction is in progress(SBL-DAT-00473)

Importing objects from file C:\Siebel\Tools/log/RepositoryUpgrade_20190226_085645/RepositoryUpgrade/18.9/Repository/ALL\B_Class.sif

Done importing

Done loading F:\Siebel\Tools/log/RepositoryUpgrade_20190226_085645/RepositoryUpgrade/18.9/Repository/ALL\B_Class.sif

Loading Repository 'Siebel Repository' ...

Loading Repository 'Siebel Repository' ... found

Loading Project 'D2P Migration' ...

Loading Project 'D2P Migration' ... found

Loading Class 'CSSMIGRATIONUTILITYSVC' ...

Loading Project 'ISS Promotion Admin' ...

Loading Project 'ISS Promotion Admin' ... found

Loading Class 'CSSISSPGSearchMembershipVBC' ...

Loading Project 'LS Clinical Protocol Site' ...

Loading Project 'LS Clinical Protocol Site' ... found

Loading Class 'CSSBCLSClinicalSiteVisitAttachment' ...

Comparing import objects with repository objects ...

Checking that projects are already locked ...

Applying changes to repository at 02/26/19 09:11:03

Resolving foreign keys on object: Class 'CSSMIGRATIONUTILITYSVC' of Project 'D2P Migration'

Resolving foreign keys on object: Class 'CSSISSPGSearchMembershipVBC' of Project 'ISS Promotion Admin'

Resolving foreign keys on object: Class 'CSSBCLSClinicalSiteVisitAttachment' of Project 'LS Clinical Protocol Site'

Inserting object: Class 'CSSMIGRATIONUTILITYSVC' of Project 'D2P Migration'

-> 3error setting 'Name' = 'CSSMIGRATIONUTILITYSVC' -- This operation is not allowed when there are no records displayed.

Please execute a query that returns at least one record or add a new record.(SBL-DAT-00215)!

Rolling back transaction for all changes ...

!!ERROR::This operation is not allowed when there are no records displayed.



Also in siebdev.log it can be seen that the bellow query

SELECT /*+ ALL_ROWS */
     T5.CONFLICT_ID,
     T5.LAST_UPD,
     T5.CREATED,
     T5.LAST_UPD_BY,
     T5.CREATED_BY,
     T5.MODIFICATION_NUM,
     T5.ROW_ID,
     T4.MODULE_NAME,
     T5.FKEY_TBL_ID,
     T5.MODULE_NAME,
     T5.NAME,
     T5.NULLABLE,
     T4.OBJ_LOCKED_LANG,
     T4.OBJ_LOCKED_FLG,
     T4.OBJ_LOCKED_BY,
     T5.TBL_ID,
     T4.NAME,
     T5.DATA_TYPE,
     T4.PROJECT_ID,
     T3.LOCKED_FLG,
     T3.LOCKED_BY,
     T3.NAME,
     T3.UIFREEZE_FLG,
     T3.UIFREEZE_BY,
     T5.REPOSITORY_ID,
     T5.SCALE,
     T5.LENGTH,
     T5.TYPE,
     T5.USER_NAME,
     :1
  FROM 
      (SELECT * FROM SIEBEL.S_LST_OF_VAL WHERE WS_ID = '1-8-4' AND  ( WS_MIN_VER <= 9999 AND  WS_MAX_VER > 9999 )  AND WS_INACTIVE_FLG = 'N' ) T1,
      (SELECT * FROM SIEBEL.S_LST_OF_VAL WHERE WS_ID = '1-8-4' AND  ( WS_MIN_VER <= 9999 AND  WS_MAX_VER > 9999 )  AND WS_INACTIVE_FLG = 'N' ) T2,
      SIEBEL.S_PROJECT T3,
      SIEBEL.S_TABLE T4,
      SIEBEL.S_COLUMN T5
  WHERE 
     T5.CASCADE_CLEAR = T2.VAL AND
     T5.TBL_ID = T4.ROW_ID AND
     T5.DATA_TYPE = T1.VAL AND
     T4.PROJECT_ID = T3.ROW_ID (+) AND
     ((T5.REPOSITORY_ID = :2) AND
     (T1.TYPE = 'COLUMN_DATA_TYPE' AND T2.TYPE = 'CASCADE_MODE')) AND
     (T5.ROW_ID = :3)
  ORDER BY
     T5.REPOSITORY_ID, T5.NAME

returns 0 rows

Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.