Skip to main content

Posts

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...

SBL-DAT-00590 Error While Trying to Pick A Value For A Picklist Field in Siebel

Doc ID 1335003.1 APPLIES TO: Siebel Tools - Version 8.1.1.4 SIA [21225] and later Information in this document applies to any platform. Checked for Relevance on 15-Mar-2013 Checked for Relevance on 03-Nov-2015 SYMPTOMS When attempting to create a new record in Campaign Applet in Asset > Campaign screen for the first time, the following error occurs. These errors will happen for the first time only per session. For second time, "new" button it's ok and no error. The problem in Campaign BC is with 'Call Status' field, which has predefault value= Expr: "LookupValue(""CAMPAIGN_STATUS_OUTCOME"",""New Added"")" ERROR ----------------------- [1] An error occurred calculating the default value for field 'Call Status' in business component 'AIS Asset Campaigns'.(SBL-DAT-00412) [2] Could not evaluate expression 'Expr: "LookupValue(""CAMPAIGN_STATUS_OUTCOME"",""New Add...

Oracle SQL concatenate multiple columns and add text

You have two options for concatenating strings and column values in Oracle: CONCAT Using || CONCAT example: select CONCAT(ROW_ID,'text') from s_contact; Using || example: select ROW_ID || 'text' from s_contact; Source: StackOverflow