Skip to main content

Posts

There were more rows than could be returned Siebel SBL-DAT-00500

[1]Wrong field values or value types detected in field Street. Please re-enter your field values. If you need additional assistance, please refer to the documentation.(SBL-UIF-00299) [2]An error occurred while attempting to look up the transcode for the value 'Value-10' in table 'S_LST_OF_VAL' and of type 'LOV_TYPE' with language 'ENU'.(SBL-DAT-00592) [3]There were more rows than could be returned.  Please refine your query to bring back fewer rows(SBL-DAT-00500) See Also: There were more rows than could be returned error occurs when executing LookupValue in an UI data map (Doc ID 1925807.1) Changing the cursor configuration parameter from the Application CFG file will only work for dedicated Web client. In order to set this parameter value for the Siebel Web Client (thin client) you need to set named subsystem parameter DSMaxFetchArraySize. This parameter controls the maximum number of records that can be returned by a business component in ForwardBackw...

How to increse font size in Oracle SQL Developer

In Oracle SQL Developer go to Tools and select Preferences. In New window go to Code Editor and expand, select Fonts. Change the font side to desired.

Revised Trading timings of the PSX due to COVID-19 situation 2021

In line with the decision of National Command & Operation Centre (NCOC) regarding the COVID- 19 situation and subsequent reduction in banking hours by the State Bank of Pakistan notified today April 28, 2021, PSX has also revised its Market and office timings keeping in view the smooth clearing and settlement within the reduced banking hours. The revised timings, as appended, shall take effect from trading day April 29, 2021 and shall remain in force till further notice.    MARKET TIMINGS MONDAY TO THURSDAY FRIDAY Pre-Open 09:00 a.m. to 09:15 a.m. 09:00 a.m. to 09:15 a.m. Order Matching & Confirmation Period 09:15 to 09:17 a.m. 09:15 to 09:17 a.m.   Opening of Market 09:17 a.m. 09:17 a.m.   Restrictive Period 09:17 a.m. to 09:18 a.m. 09:17 a.m. to 09:18 a.m. Closing of Market 12:30 pm 11:30 am Post-Close Session 1:00 p.m. to 1:15 p.m. 12:00 p.m. to 12:15 p.m. Source: BMA

How to Add XML Sitemap to your Blogger Blog

A Sitemap is an XML file that lists the URLs for a site. This allows search engines to crawl the site more efficiently and to find URLs that may be isolated from the rest of the site's content and search bots may have otherwise missed during regular crawling. Google supports several sitemap formats, mentioned below. Google expects the standard sitemap protocol in all formats. Google does not currently consume the <priority> attribute in sitemaps. XML RSS, mRSS, and Atom 1.0 Text How to add site map in Blogger Go to your Blogger.com dashboard, navigate to Settings –> Crawlers and indexing, enable Custom robots.txt option (available in the Crawling and Indexing section). Paste the XML sitemap here and save your changes.  Replace the blogger address with yours in below. User-agent: * Disallow: /search Allow: / Sitemap: https://itcanopy.blogspot.com/atom.xml?redirect=false&start-index=1&max-results=500 Sitemap: https://itcanopy.blogspot.com/atom.xml?redirect=false...

How to import a CSV file into SQL Developer

Title: How to import a CSV file into SQL Developer? Loading Data into a Table Procedure: After create a connection to the database in SQL Developer. 1. Right click on tables folder and Choose Import data. 2 .Select xls. 3. Follow the wizard     - Provide table name     - Select columns     - Define datatype per column and provide the length     - Finish.

There were more rows than could be returned error occurs when executing LookupValue in Siebel

APPLIES TO: Siebel CRM - Version 8.1.1.11 [IP2013] and later Information in this document applies to any platform. *** Checked for currency JUL-22-2016 *** SYMPTOMS Environment: ------------ Siebel CRM 8.1.1.11 [23030] Microsoft Windows (32-bit) 2003 Statement of Issue: ------------------- An external application sends a record to Siebel. An UI data map is used to convert the record. This includes the expression LookupValue("MSC_WARD",[MSC Ward]) to convert an incoming WARD code into the required value in Siebel. In Siebel there are 11400 List Of Value records where Type = MSC Ward, but there is only 1 record with the relevant Type and LIC combination. When the external application sends a record to Siebel, an error is occurring. Error: ------ Error invoking service 'EAI Data Transformation Engine', method 'Execute' at step 'DataMap'.(SBL-BPR-00162) -- An error occurred while attempting to look up the LOV value of '0512005' of type 'MSC_WAR...

DSMaxFetchArraySize = -1 Could Result IN High Memory Usage / Crash Of OM PIDs in Siebel

APPLIES TO: Siebel CRM - Version 7.5.3 SIA [16157] to 18.8 [Release V7 to V17] Information in this document applies to any platform. Area(s):Client Functionality, System Administration Release(s):V7 (Enterprise), V7 (MidMarket), V7 (Professional) and Later (IP2013, IP2014, IP2015, IP2016 and IP2017) Database(s):All Supported Databases App Server OS(s):All Supported Platforms Latest release tested against:V7 (Enterprise) Keywords:crash, SBL-DAT-00500, fetch, 10000, DSMaxFetchArraySize, leak, exception DESCRIPTION This Alert applies to all versions. In Siebel 7 there are two cursor modes specified with the ExecuteQuery method, ForwardOnly and ForwardBackward. ForwardOnly: Selected records can be processed only from the first record to the last record. Focus cannot return to a record. ForwardBackward: Selected records can be processed from first to last or from last to first. This is the default if no value is specified. DSMaxFetchArraySize is a named subsystem parameter that controls the...