Technical Rockers

SMS alerts in India now comes with Suffix

technicalrocker@gmail.com (Technical Rocker-k@run@) — Wed, 30 Jul 2025 20:56:00 +0530

🚨 BIG UPDATE: Every SMS in India now comes with a TAG! 🚨

Thanks to TRAI’s new rule, all SMS headers now end with a suffix showing the type of message you’re getting. No more guessing!

Here’s what those new suffixes mean:

- **“-P” → Promotional** (Offers, sales)

- **“-S” → Service** (Balance updates, confirmations)

- **“-T” → Transactional** (OTPs, payment alerts)

- **“-G” → Government** (Official notices)

For example:

- VK-FKRT-**P** → Promotional (Sale alert)

- JM-BOBTXN-**S** → Service (Balance update)

- JD-ZOMATO-**T** → Transactional (OTP)

**Why this change?**

To make SMSes safer by preventing fraud, reducing spam, and making messages easier to identify at a glance. The suffix is auto-assigned based on how the sender registers the message.

*Pro Tip:* The prefix still tells you about the operator and region (e.g., JD- = Jio Delhi).

🛡️ Share to help your friends & family spot spam and avoid scams! #TRAI #SMSUpdate #DigitalIndia #FraudPrevention

K@run@

Gemini AI Pro Plan free for Students

technicalrocker@gmail.com (Technical Rocker-k@run@) — Tue, 15 Jul 2025 22:42:00 +0530

Google is offering a 1-year FREE subscription to the Gemini AI Pro plan for all eligible students (18+).

•Study & job prep help
•Premium AI tools (Gemini, Veo 3, etc.)
•2 TB storage for Drive, Gmail & Photos

Link:
https://one.google.com/ai-student?utm_source=gemini&utm_medium=paid_media&utm_campaign=gemini_students_in_others&g1_landing_page=75

K@run@

TDS Level Chart for Drinking Water

technicalrocker@gmail.com (Technical Rocker-k@run@) — Wed, 17 Jul 2024 15:51:00 +0530

What are Different TDS levels? What do they mean for you?

The TDS level helps indicate whether the drinking water is fit for consumption, requires filtration or is highly contaminated. Parts per million (PPM) is the measurement used for measuring TDS level in the water.

TDS Level Chart for Drinking Water

TDS in Water (measured in PPM)	Suitability for Drinking Water
Between 50-150	Excellent for drinking
150-250	Good
250-300	Fair
300-500	Poor, not good for drinking
Above 1200	Unacceptable

K@run@

Snowflake Optimization on top of any Table

technicalrocker@gmail.com (Technical Rocker-k@run@) — Fri, 26 Apr 2024 17:55:00 +0530

There are several optimization techniques you can implement on a table to reduce storage and compute costs:

1. Partitioning: Partitioning your table can significantly improve query performance and reduce storage costs. You can partition your table based on a specific column, such as date, so that data is stored in separate parts. This can be particularly useful if you often query data for specific date ranges.

2. Indexing: Proper indexing can greatly improve query performance. However, it's important to find the right balance as too many indexes can increase storage costs and slow down write operations. Indexes should be created on columns that are frequently used in WHERE, JOIN, and ORDER BY clauses.

3. Data Compression: Depending on the database system you're using, you might be able to use data compression techniques to reduce storage costs. This can include techniques like row-level or page-level compression, or even using columnar storage for large data warehousing workloads.

4. Data Archiving and Purging: If your table contains historical data that is no longer needed for day-to-day operations, consider archiving or purging this data. This can significantly reduce storage costs and improve query performance on the remaining data.

5. Normalization: If your table contains redundant data, consider normalizing it. This involves splitting the table into two or more tables and defining relationships between them. This can reduce storage costs and improve data integrity, but it can also increase the complexity of your queries.

6. Use Appropriate Data Types: Using the appropriate data type for each column can also help reduce storage costs. For example, using a smaller integer type (like INT instead of BIGINT) can save space if the larger range of values isn't needed.

7. Column Store Indexes: If you're using a database system that supports column store indexes, these can provide significant performance improvements for read-heavy workloads. Column store indexes store data column-wise instead of row-wise, which can be more efficient for querying large datasets

K@run@

Copilot for Power BI

technicalrocker@gmail.com (Technical Rocker-k@run@) — Wed, 17 Apr 2024 17:00:00 +0530

About

Copilot for Power BI is a feature introduced by Microsoft to provide users with AI-powered assistance while creating reports and dashboards in Power BI Desktop. It uses natural language processing (NLP) capabilities to understand user queries and provide relevant suggestions and guidance in real-time as users build their data visualizations.

This feature is designed to make it easier for users, especially those who may not have extensive experience with data analytics or Power BI, to create effective and insightful reports. Copilot can suggest visualizations, recommend data transformations, and offer explanations or insights into the data being analyzed.

This feature need to be enabled in the tenant settings of the Admin Portal either at Org level or can be based on AD groups.

Pricing/Consumption

Requests to Copilot consume Fabric Capacity Units (CU). Copilot usage is measured by the number of tokens processed. Tokens can be thought of as pieces of words. As a reference, 1,000 tokens approximately represent 750 words. The Fabric Copilot cost is calculated per 1,000 tokens, and input and output tokens are consumed at different rates. This table defines how many CUs are consumed as part of Copilot usage.

Operation in Metrics App	Description	Operation Unit of Measure	Consumption rate
Copilot in Fabric	The input prompt	Per 1,000 Tokens	400 CU seconds
Copilot in Fabric	The output completion	Per 1,000 Tokens	1,200 CU seconds

Capacity Units (CU) in pricing refer to the computing resources allocated to your Power BI deployment in the cloud. They are a measure of the performance and scalability of your Power BI environment.

If you’re utilizing Copilot for Power BI and your request involves 500 input tokens and 100 output tokens, then you’ll be charged a total of (500*400+100*1,200)/1,000 = 320 CU seconds in Fabric.

The cost of Fabric Capacity Units can vary depending on the region. Regardless of the consumption region where GPU capacity is utilized, customers are billed based on the Fabric Capacity Units pricing in their billing region.

For example, if a customer’s requests are mapped from region 1 to region 2, with region 1 being the billing region and region 2 being the consumption region, the customer is charged based on the pricing in region 1.

Data Security

The data such as prompts, grounding data included in prompts, and AI output will be processed and temporarily stored by Microsoft and may be reviewed by Microsoft employees for abuse monitoring.

To generate a response, Copilot uses:

The user's prompt or input and, when appropriate,
Additional data that is retrieved through the grounding process.

This information is sent to Azure OpenAI Service, where it's processed and an output is generated. Therefore, data processed by Azure OpenAI can include:

The user's prompt or input.
Grounding data.
The AI response or output.

Grounding data may include a combination of dataset schema, specific data points, and other information relevant to the user's current task. Review each experience section for details on what data is accessible to Copilot features in that scenario.

Interactions with Copilot are specific to each user. This means that Copilot can only access data that the current user has permission to access, and its outputs are only visible to that user unless that user shares the output with others, such as sharing a generated Power BI report or generated code. Copilot doesn't use data from other users in the same tenant or other tenants.

Copilot uses Azure OpenAI—not OpenAI's publicly available services—to process all data, including user inputs, grounding data, and Copilot outputs. Copilot currently uses a combination of GPT models, including GPT 3.5. Microsoft hosts the OpenAI models in Microsoft's Azure environment and the Service doesn't interact with any services by OpenAI (for example, ChatGPT or the OpenAI API). Your data isn't used to train models and isn't available to other customers.

Copilot in Power BI Service for Consumers

New Report/Page

Create a blank report by picking any published semantic model. In the copilot tab you can give the input prompt that best describes the business needs that you want to fulfill for the report that you want to create.

The semantic model that we are intended to use for creating any new report needs to be built with all best practices to get the best out of the copilot. The terminologies used in the semantic model and the naming conventions used should be user friendly so that Azure Open AI can recognize.

Summarize Visuals

You can summarize the report visuals into bullet points or you can generate high level gist of the contents for quick references. Most of the cases these quick insights generated on top of the existing reports can be used for executive reporting and for presentations.

Copilot in Power BI Desktop for Developers

If you are unable to see the copilot in the tool bar in Power BI desktop, then you have to explicitly enable it from the Options as in below

EU Data Boundary

Customers can configure their service to be in-scope for the EU Data Boundary by provisioning their tenant and all Microsoft Fabric capacities in an EU datacenter location. Customer Data and pseudonymized personal data is stored and processed in the EU Data Boundary aside from specific residual transfers that are documented in Services that transfer a subset of Customer Data or pseudonymized personal data out of the EU Data Boundary on an ongoing basis.

Fabric also enables the option to select an Azure region where Customer Data is stored when creating new Microsoft Fabric capacity. The default option listed is your tenant home region. If you select that region, all associated data, including Customer Data, is stored in that Geo. If you select a different region, some Customer Data is still stored in the home Geo. By selecting a region in the EU, Customer Data will be stored in the EU Data Boundary.

MS Fabric Capacity Metrics

Starting from February 2024, you can view the total capacity usage for Copilot under the operation name “Copilot in Fabric” in your Fabric Capacity Metrics App.

K@run@

Plan your long weekends for 2024 - India

technicalrocker@gmail.com (Technical Rocker-k@run@) — Fri, 22 Dec 2023 16:34:00 +0530

January - 26th to 28th long weekend due to Republic day.

February - Nothing just consume your leaves.

March - Take leave on 26th to 28th , for days off Holi.

April - Take leave on 8th, 10th, 12th to get 9 days off due to Ugadi, Eid, RamaNavami, Ambedkar jayanti.

May - Take leave on 24th to get 4 days off.

June - 15th to 17th long weekend due to Bakrid.

July - No chances

August - Take a leave on 16th to get 4 days off due to Independence day.

September - 14 to 16th long weekend due to Onam.

October - Take leave on 3rd and 4th for 4 days off due to Gandhi Jayanthi.

November - Take leave on 1st and 4th for 5 days off. 15th to 17th is long weekend.

December - Take leave on 26th and 27th for 5 days off due to Christmas.

Extracting Private key and certificate from .PEM file using OpenSSL

technicalrocker@gmail.com (Technical Rocker-k@run@) — Sun, 10 Dec 2023 12:11:00 +0530

OpenSSL, a popular open-source tool for working with cryptographic operations, can be used to extract the.pem and.key files from a.pfx (or.p12) file.

The steps are as follows:

Extraction of.pem and.key from.pfx File:

Install OpenSSL as follows:

Check that your system has OpenSSL installed. You can get it from the OpenSSL website or install it with a package manager such as Homebrew on macOS or apt-get on Linux.

Conversion Method:

OpenSSL is used to extract the private key and certificate from the.pfx file.

Code:-

openssl pkcs12 -in yourfile.pfx -nocerts -out privatekey.key

Change yourfile.pfx to the name of privatekey.key file. The private key will be extracted and saved to privatekey.key using this command.

Code:-

openssl pkcs12 -in yourfile.pfx -clcerts -nokeys -out certificate.pem

This command will extract the certificate and save it to certificate.pem.

K@run@

You can now get verified Badge using Aadhaar Authentication

technicalrocker@gmail.com (Technical Rocker-k@run@) — Mon, 16 Oct 2023 01:07:00 +0530

T20 Cricket is about to feature in Summer Olympics 2028

technicalrocker@gmail.com (Technical Rocker-k@run@) — Mon, 16 Oct 2023 01:06:00 +0530

CRED Garage - One stop solution to manage everything about your Vehicle

technicalrocker@gmail.com (Technical Rocker-k@run@) — Sat, 30 Sep 2023 22:00:00 +0530

CRED our famous app that was initially introduced as a credit card payment gateway app, has been flourishing in many other features over the years.

And it is worth mentioning that every new feature that the CRED team has introduced has been a gem in the making as their app features and navigation are second to none.

Now with the latest CRED Garage introduced for personalized and private experience to manage all your vehicle needs and maintenance. This has been carefully considered by the company with the interest of security and privacy as the utmost importance.

You can manage your insurance renewals, fast tag recharges, pollution check documents, traffic violation challans and vehicle details all at one place. The good thing is we can manage multiple 2 wheelers and 4 wheelers in one profile.

The look and feel of the virtual vehicle is so cool with the 360 degree view, and this shows how serious the IT team is working for the CRED board. (That's an amazing feat to pull).

You can manage all your spends and in a way can forecasts about your fuel charges for the upcoming months.

Another good thing to worth considering is the integration of the CRED app to the world class DigiLocker from our Indian govt. That's a nice glovebox for your garage where you can maintain all your personal documents in one go.

Good going CRED , keep up the good work and the customers will sure appreciate your efforts for the seamless experience you are providing.

CRED App :- Link

DigiLocker :- Post

K@run@

Migration of Traditional Reports to Power BI - Quick Guide

technicalrocker@gmail.com (Technical Rocker-k@run@) — Sat, 9 Sep 2023 16:27:00 +0530

Moving reports from traditional analytical tools to Power BI represents a significant stride in harnessing advanced visualization and data analysis capabilities. Below is an initial guide to assist you in the process.

Evaluation and Strategy:

Ascertain which reports to transfer, prioritizing them based on their business significance and complexity.
Gain insight into the data sources utilized in current reports. Determine if they are compatible with Power BI or proceed with prerequisites and pre-processing to achieve the state.
Clearly outline the migration's scope and objectives. Consider whether you're merely relocating reports or if there are opportunities to enhance them using Power BI's functionalities.

Data Readiness:

Ensure that your data sources possess appropriate structure and have been thoroughly cleansed. Power BI performs optimally with well-organized, clean data.
If your data resides in a database, confirm that you possess the requisite credentials and permissions to access it via Power BI.

Power BI Desktop:

Download and install Power BI Desktop if you haven't already. This is the tool you'll employ to design and craft your reports.
Launch Power BI Desktop and acquaint yourself with its interface and capabilities.

Establishing Data Connections:

Within Power BI Desktop, navigate to the "Home" tab and select "Get Data." Choose the relevant data source (e.g., Excel, SQL Server).
Connect to your data source by supplying the necessary connection particulars.
Opt for data import or establish a direct connection, depending on your data source and specific requirements.

Data Transformation:

Utilize Power Query Editor (accessible from the "Home" tab) to modify and structure your data as required.
Undertake data cleansing, establish calculated columns, and implement any necessary transformations.

Report Development:

Construct your reports by dragging and dropping visuals onto the canvas.
Customize the visuals using the formatting choices found in the "Format" and "Visualizations" panels.
Establish relationships between tables if your data necessitates such connections.

DAX Formulas:

Familiarize yourself with Data Analysis Expressions (DAX), Power BI's formula language used for crafting custom calculations.
Compose DAX calculations to derive insights that may not be readily accessible within your data source.

Report Design:

Concentrate on creating reports that are visually captivating and easily comprehensible.
Exploit Power BI's array of visualization options to effectively convey insights.

Interactive Elements:

Leverage Power BI's interactive capabilities, including drill-through functionality, slicers, and bookmarks, to augment user engagement.

Publication:

After finalizing your report, save it as a Power BI Desktop (.pbix) file.
Log in to your Power BI account (or sign up for a free account if you don't have one).
Select the "Publish" button to upload your report to the Power BI service.

Sharing and Collaboration:

Configure suitable permissions to govern report access. Use AD groups to provide access to the workspaces and any published App for the business.
Disseminate the report to colleagues and stakeholders via direct links, embedded reports, or dashboards.

Maintenance and Oversight:

Make sure the scheduled refreshes are working fine and the data quality checks are in place.
Monitor report usage and gather feedback to facilitate continuous enhancement.

Note:-

Bear in mind that transitioning reports to Power BI might entail a learning curve, especially for newcomers to the platform. Exercise patience and make the most of the abundant online resources, encompassing tutorials, forums, and documentation, to aid in your journey.

Learning:

For starting the Power BI journey as a Novice , refer to my previous post on training/learning library.

Quick Start with Power BI - No prerequisites

technicalrocker@gmail.com (Technical Rocker-k@run@) — Wed, 6 Sep 2023 00:31:00 +0530

I have been in the IT space for almost 15 years now and out of all available analytical tools like

Oracle Analytics, Tableau, Google Analytics, Cognos and Power BI , I would easily pick Power BI to fulfill all my needs. And the reason is Microsoft.

Power BI is widely used in businesses and organizations to gain insights from their data and make data-driven decisions.

I would like to suggest the below path and libraries for learning the Power BI in a fast paced learning path.

Download the Power BI Desktop from the Microsoft store, it is free for all windows users.(No luck for mac users yet). Make sure you only download the Desktop application.
This is the best in detail learning course you can get in the Udemy for references and I had great time in learning through this course.
Learning Power BI will unlock lot of opportunities in the Business Analytics vertical and having good knowledge inn SQL and MS-Excel is obviously a plus.
Learning power query in transforming the source data is a key factor in flourishing in Power BI as that is where most of your brain work goes into. (Data Modelling).
I would segregate Power BI into 2 categories as Easy part and Hard part.

Easy part

Get Data from data sources as Microsoft has good integration with almost all available technologies including Snowflake.
Check the data quality and transform the data to fulfill basic needs in generating the insights.
Power BI Service where you can see the published workspace and managing the data of your organisation with corporate license from Microsoft.
Power Query which can be generated with usual navigational features available in the Power BI desktop tool.
Security management of your reports and data with in Power BI cloud.
Refreshing your data online using gateway connections and scheduled refreshes.

Hard part

Writing DAX queries to fulfill advanced requirements using custom measures and attributes.
Power BI report builder which is used to generate pixel perfect reports also known as Paginated Reports.
Transforming the data by massaging the source data to the actual requirement of the report and insights which are to be fulfilled.

As Microsoft is already a most trusted vendor across all formats of IT market, the integration with different systems are made easy and new preview features are released very frequently for the developers to explore and leverage most of out of Power BI platform.
There are so many free resources online for Power BI and you can see mainstream developers in youtube with many tutorials.
These day with so many visual changes and preview features Microsoft has stepped up into the nextGen reporting as Microsoft Fabrics.

Note:- Remember that Power BI can be a powerful tool, but it may take some time to become proficient. Start with simple projects and gradually work your way up to more complex ones as you gain confidence and experience.

References :-

Power BI get started documentation - Power BI | Microsoft Docs

Power BI - Tips and Tricks

Power BI Youtube

Published by K@run@

DigiLocker - An App from Indian Govt.

technicalrocker@gmail.com (Technical Rocker-k@run@) — Sat, 26 Aug 2023 01:42:00 +0530

DigiLocker was an initiative which would be used as a one stop solution for all your authentic ID proofs with verified bar codes.

But now it has achieved its feat more than expected where millions of users are getting benefitted with the features of DigiLocker.

Personally I have been using the below which have been playing a major role in my life everytime some govt offical asks me for an ID.

But that's not the only benefit we get out of it. I have seen slowly the IT has introduced number of options by collaborating with individual state govt's across the nation.

I am using the below as an example which is very helpful for my daily routines.

1. Aadhar Card virtual

2. Driving licence

3. EPFO card for Provident Fund

4. Vehicle Registration

5. Vehicle Insurance

6. Term Insurance from HDFC life

7. SBI - ulip policy

8. ABHA card

9. COVID vaccination certificate.

If you are the genZ , then you can even retrieve your marks list from multiple universities these days.

So I would really suggest everyone to use Digilocker for their own benefits.

DigiLocker Android App

Chandrayaan 3 Mission from Sriharikota is a Success

technicalrocker@gmail.com (Technical Rocker-k@run@) — Fri, 14 Jul 2023 14:56:00 +0530

With all the phases behavior in Normal state , ISRO once again launched a successful mission into the Space that's The Chandrayaan 3.

The graph has retraced the path of the projection as expected and hopefully all the phases for the moon lander will be successful in near future.

https://www.youtube.com/watch?v=q2ueCg9bvvQ

K@run@

Visakhapatnam Quick Guide on the places to visit - Vizag

technicalrocker@gmail.com (Technical Rocker-k@run@) — Sat, 24 Jun 2023 23:58:00 +0530

The are many places in Visakhapatnam that excites the tourists when they visit , I don't think that the below listed are widely covered in other travel Blogs.

1) Indira Gandhi Zoological Park

2) Chaparai waterfalls - Aruku

3) Sariya waterfalls -Devarapalli

4) Kondakarla Ava

5) Kothapalli Waterfalls

6) Visakha Museum

7) Swarna Jyothi Naval Museum

8) Jagadamba Center

9) Gangavaram Beach

10) Vanajangi

K@run@

2023 Best AI Tools to check for better Productivity

technicalrocker@gmail.com (Technical Rocker-k@run@) — Tue, 20 Jun 2023 01:11:00 +0530

After considering the fact that ChatGPT paved path to many AI tools and solutions that can minimize human efforts drastically in our daily routines. I thought why not list out some useful AI tools in the market. (Of course they are not free though)

Solves Anything - ChatGPT

Writes Anything - Writesonic

Generates Art - MidJourney

Generates Code - Replit

Generates Video - Synthesia

Generates Music - Soundraw

Generates Tiktoks - Fliki

Generates Avatars - Starrytars

Generate PPTs - Slides AI

Edit Pictures - Remini

Edit Videos - Pictory

K@run@

Income tax proposed new rates for each slab - Budget 2023 India

technicalrocker@gmail.com (Technical Rocker-k@run@) — Sat, 4 Feb 2023 19:39:00 +0530

New tax regime is default tax regime

If income is under Rs 7 lakh then no income tax will be charged

If income is more than 7 lakh then pay as per slabs:
0 to 3L - Nil
3 to 6L - 5%
6 to 9L - 10%
9 to 12L - 15%
12 to 15L - 20%
Above 15L - 30%

You can also opt for old tax regime.

Regards

K@run@

Devarapalli Sariya Waterfalls - Devarapalli Visakhapatnam

technicalrocker@gmail.com (Technical Rocker-k@run@) — Sat, 13 Nov 2021 13:06:00 +0530

Trip to Sariya waterfalls:

Sariya waterfalls is in Visakhapatnam district near Devarapalli village. Approximately 14 KMs from Devarapalli village and 50 KMs from Visakhapatnam city.

Perfect weekend getaway for nature lovers with lush greens and hills on the way, away from city life.This waterfall is one of the most beautiful less explored destinations near Visakhapatnam.

We can reach by driving a car or bike till 3 to 4 KMs to the exact location. Roads are little bit rough after Devarapalli and bit difficult to drive during rainy season. Once reached the near by location to falls, park the vehicle and walk for few kilometres while enjoying the deep forest views, thick greens around, and sound of water flowing silently around until you reach the actual trekking position to the falls.

Need to cross a small water channel, once crossing it trek for about 2 to 3 KMs, trek is a combination of simple walk, climbing steps and hiking a hill. There is an entry ticket of rupees 10 per head.

Best waterfalls in Visakhapatnam, just 50 kms from the main city center.

If you are looking for adventure combined with fun and deep forest hiking, then Devarapalli waterfalls is the best.

R@g@ K@run@

Vizag to Hyderabad - Toll Gate Price List for Light Motor Vehicle

technicalrocker@gmail.com (Technical Rocker-k@run@) — Sun, 31 Oct 2021 11:51:00 +0530

A total of 920 rupees is being contributed to Govt for a single vehicle in one day. The overall forecasted money that our govt gets is in many crores per day.

Aganampudi NH-16 Toll plaza - Rs55

Vempadu Toll Gate - Rs115

Krishnavaram Toll Gate - Rs90

VeeraValli Toll Plaza - Rs120

Kalaparru Toll Plaza - Rs35

Pottipadu Toll Gate - Rs45

Keesara NH65 Toll Gate - Rs60

Chillakallu Toll Plaza - Rs90

Koralaphad Toll Plaza - Rs110

Pantangi Toll Gate - Rs80

Nanakramguda Toll Gate - Rs120

K@run@

Blood Donation - Do's and Dont's

technicalrocker@gmail.com (Technical Rocker-k@run@) — Sun, 3 Oct 2021 13:49:00 +0530

You can donate blood if

• you are between age group of 18-60 years

• your weight is 45 kgs or more

• your haemoglobin is 12.5 gm% minimum

• Your last blood donation was 3 months earlier

• you are healthy and have not suffered from malaria, typhoid or other transmissible disease in the recent past

• you have eaten a low fat healthy diet few hours before donating blood

Do not donate blood if you have any of the following conditions:

• cold / fever in the past 1 week

• under treatment with antibiotics or any other medication

• major surgery in the last 6 months

• taken any vaccination in the last 24 hours

• had a miscarriage in the last 6 months or have been pregnant / lactating in the last one year

• had fainting attacks during last donation

• have regularly received treatment with blood products

• shared a needle to inject drugs/ have history of drug addiction

• consumed alcohol in the last 24 hours

• suffered dengue, chicken pox or typhoid in the last 2 years

• Taken any allergy medicine in last 2-4 weeks

R@g@

K@run@

Significant Advantage of Electric Car over a Traditional Car

technicalrocker@gmail.com (Technical Rocker-k@run@) — Sat, 29 May 2021 10:27:00 +0530

Torque can be very high and helpful during initial lower RPM for a Gas Engine, but the uniform torque that an Electric vehicle provides will give you more advantage that we can dream of.

Consider the power of a Lamborghini at gear one, what it feels like if you have that power under your foot for the entire cruise...that's the Electric vehicle for you.

K@run@

Automation of Dashboard Refresh in OBIEE 11G

technicalrocker@gmail.com (Technical Rocker-k@run@) — Mon, 13 Apr 2020 11:22:00 +0530

If we want the dashboard to be refreshed for every 'n' minutes then below HTML will be helpful, where you have to give (n x 60) seconds.

Insert the below html in the dashboard text layout and check the HTML markup checkbox.

<META HTTP-EQUIV = "REFRESH" CONTENT = "60">
<META HTTP-EQUIV="CACHE-CONTROL" CONTENT="NO-CACHE">

Don't forget to enable the "Contains HTML Markup"

So in this way the page which is being displayed in the browser can be refreshed automatically without manual intervention.

K@run@

Unable to open session logs from Load plan executed in ODI 11g

technicalrocker@gmail.com (Technical Rocker-k@run@) — Fri, 29 Nov 2019 12:46:00 +0530

Hello there,

I have faced this strange issue which is related to ODI 11g navigation and would like to discuss about the fix that we used in our Linux environment.

We have been using ODI 11g since 5 years and as the days pass by the no of jobs and no of loadplans got increased dramatically and hence the session logs sequence number is very high.

Basically the difficulty here will be from the operations team where they have to filter the logs and check the errors (Time consuming task) rather than directly opening the errored session log from the load plan.

Issue and cause:- ODI 11g has a bug where if the sequence generator of the session logs reach to certain threshold then the link between session logs and executed loadploan will break and you wont be able to open the session logs from the load plans.

Fix:- The sequence generators of various elements will be stored in SNP_ID table of the work repository so we need to rest the SNP_SESSION element in the table.

1) Take backup of your work repository.
2) Shut down all ODI services and Agents (Standalone if any).
3) Make sure there are no running sessions in the repository.
4) Purge all logs from the work repository with scenario reports. make sure there are no abandoned sessions left.
5) Connect to work repository and execute the below queries just to make sure all session logs are purged.

##########################################################################

update snp_id set id_next = 1 where id_tbl = 'SNP_SESSION';

/* >>> Delete all the Session-related records, using a combination of DELETE and TRUNCATE SQL commands. <<< */

/* Naming conventions used in this script:
*
*   PRD_BIA_ODIREPO is the name of the Work Repository Schema.
*
* Replace in this document all the occurrences of PRD_BIA_ODIREPO with the name of schema containing the Work Repository tables.
*/

/*
* 0. First switch off the AutoCommit mode
*/
    set autocommit off ;

/*
* 1. Delete Session parameters and messages
*/

    delete from PRD_BIA_ODIREPO.SNP_EXP_TXT where I_TXT in
    (select I_TXT_TASK_MESS from PRD_BIA_ODIREPO.SNP_SESS_TASK_LOG) ;

    delete from PRD_BIA_ODIREPO.SNP_EXP_TXT where I_TXT in
    (select I_TXT_STEP_MESS from PRD_BIA_ODIREPO.SNP_STEP_LOG) ;

    delete from PRD_BIA_ODIREPO.SNP_EXP_TXT where I_TXT in
    (select I_TXT_VAR from PRD_BIA_ODIREPO.SNP_VAR_SESS) ;

    delete from PRD_BIA_ODIREPO.SNP_EXP_TXT where I_TXT in
    (select I_TXT_DEF_T from PRD_BIA_ODIREPO.SNP_VAR_SESS) ;

    delete from PRD_BIA_ODIREPO.SNP_EXP_TXT where I_TXT in
    (select I_TXT_SESS_PARAMS from PRD_BIA_ODIREPO.SNP_SESSION) ;

    delete from PRD_BIA_ODIREPO.SNP_EXP_TXT where I_TXT in
    (select I_TXT_SESS_MESS from PRD_BIA_ODIREPO.SNP_SESSION) ;

/*
* 2. Delete Session Header parameters and messages
*/
    delete from PRD_BIA_ODIREPO.SNP_EXP_TXT_HEADER where I_TXT in
    (select I_TXT_TASK_MESS from PRD_BIA_ODIREPO.SNP_SESS_TASK_LOG) ;

    delete from PRD_BIA_ODIREPO.SNP_EXP_TXT_HEADER where I_TXT in
    (select I_TXT_STEP_MESS from PRD_BIA_ODIREPO.SNP_STEP_LOG) ;

    delete from PRD_BIA_ODIREPO.SNP_EXP_TXT_HEADER where I_TXT in
    (select I_TXT_VAR from PRD_BIA_ODIREPO.SNP_VAR_SESS) ;

    delete from PRD_BIA_ODIREPO.SNP_EXP_TXT_HEADER where I_TXT in
    (select I_TXT_DEF_T from PRD_BIA_ODIREPO.SNP_VAR_SESS) ;

    delete from PRD_BIA_ODIREPO.SNP_EXP_TXT_HEADER where I_TXT in
    (select I_TXT_SESS_PARAMS from PRD_BIA_ODIREPO.SNP_SESSION) ;

    delete from PRD_BIA_ODIREPO.SNP_EXP_TXT_HEADER where I_TXT in
    (select I_TXT_SESS_MESS from PRD_BIA_ODIREPO.SNP_SESSION) ;

/*
* 3. Delete Session execution reports
*/

    /* (a). Deactivate the constraints */
    alter table PRD_BIA_ODIREPO.SNP_SESS_TXT_LOG disable constraint FK_SESS_TXT_LOG ;
    alter table PRD_BIA_ODIREPO.SNP_SESS_TASK_LS disable constraint FK_SESS_TASK_LS ;
    alter table PRD_BIA_ODIREPO.SNP_SESS_TASK_LS disable constraint FK_SESS_LS_SEQ ;
    alter table PRD_BIA_ODIREPO.SNP_SESS_TASK_LOG disable constraint FK_SESS_TASK_LOG ;
    alter table PRD_BIA_ODIREPO.SNP_SESS_STEP_LV disable constraint FK_SESS_STEP_LV ;
    alter table PRD_BIA_ODIREPO.SNP_SESS_STEP_LV disable constraint FK_SESS_LV_VAR ;
    alter table PRD_BIA_ODIREPO.SNP_STEP_LOG disable constraint FK_STEP_LOG ;
    alter table PRD_BIA_ODIREPO.SNP_TASK_TXT disable constraint FK_TASK_TXT ;
    alter table PRD_BIA_ODIREPO.SNP_SESS_TASK disable constraint FK_SESS_TASK ;
    alter table PRD_BIA_ODIREPO.SNP_SESS_STEP disable constraint FK_SESS_STEP ;
    alter table PRD_BIA_ODIREPO.SNP_SEQ_SESS disable constraint FK_SEQ_SESS ;
    alter table PRD_BIA_ODIREPO.SNP_VAR_SESS disable constraint FK_VAR_SESS ;
    alter table PRD_BIA_ODIREPO.SNP_PARAM_SESS disable constraint FK_PARAM_SESS ;

    /* (b). Delete */
    truncate table PRD_BIA_ODIREPO.SNP_SESS_TXT_LOG ;
    truncate table PRD_BIA_ODIREPO.SNP_SESS_TASK_LS ;
    truncate table PRD_BIA_ODIREPO.SNP_SESS_TASK_LOG ;
    truncate table PRD_BIA_ODIREPO.SNP_SESS_STEP_LV ;
    truncate table PRD_BIA_ODIREPO.SNP_STEP_LOG ;
    truncate table PRD_BIA_ODIREPO.SNP_TASK_TXT ;
    truncate table PRD_BIA_ODIREPO.SNP_SESS_TASK ;
    truncate table PRD_BIA_ODIREPO.SNP_SESS_STEP ;
    truncate table PRD_BIA_ODIREPO.SNP_SEQ_SESS ;
    truncate table PRD_BIA_ODIREPO.SNP_VAR_SESS ;
    truncate table PRD_BIA_ODIREPO.SNP_PARAM_SESS ;
    truncate table PRD_BIA_ODIREPO.SNP_SESSION ;

    /* (c). Reactivate the constraints */
    alter table PRD_BIA_ODIREPO.SNP_SESS_TXT_LOG enable constraint FK_SESS_TXT_LOG ;
    alter table PRD_BIA_ODIREPO.SNP_SESS_TASK_LS enable constraint FK_SESS_TASK_LS ;
    alter table PRD_BIA_ODIREPO.SNP_SESS_TASK_LS enable constraint FK_SESS_LS_SEQ ;
    alter table PRD_BIA_ODIREPO.SNP_SESS_TASK_LOG enable constraint FK_SESS_TASK_LOG ;
    alter table PRD_BIA_ODIREPO.SNP_SESS_STEP_LV enable constraint FK_SESS_STEP_LV ;
    alter table PRD_BIA_ODIREPO.SNP_SESS_STEP_LV enable constraint FK_SESS_LV_VAR ;
    alter table PRD_BIA_ODIREPO.SNP_STEP_LOG enable constraint FK_STEP_LOG ;
    alter table PRD_BIA_ODIREPO.SNP_TASK_TXT enable constraint FK_TASK_TXT ;
    alter table PRD_BIA_ODIREPO.SNP_SESS_TASK enable constraint FK_SESS_TASK ;
    alter table PRD_BIA_ODIREPO.SNP_SESS_STEP enable constraint FK_SESS_STEP ;
    alter table PRD_BIA_ODIREPO.SNP_SEQ_SESS enable constraint FK_SEQ_SESS ;
    alter table PRD_BIA_ODIREPO.SNP_VAR_SESS enable constraint FK_VAR_SESS ;
    alter table PRD_BIA_ODIREPO.SNP_PARAM_SESS enable constraint FK_PARAM_SESS ;

/*
* 4. Delete Scenario associated messages
*/
    delete from PRD_BIA_ODIREPO.SNP_EXP_TXT where I_TXT in
    (select I_TXT_STEP_MESS from PRD_BIA_ODIREPO.SNP_STEP_REPORT) ;

    delete from PRD_BIA_ODIREPO.SNP_EXP_TXT where I_TXT in
    (select I_TXT_SESS_MESS from PRD_BIA_ODIREPO.SNP_SCEN_REPORT) ;

/*
* 5. Delete Scenario Header associated messages
*/
    delete from PRD_BIA_ODIREPO.SNP_EXP_TXT_HEADER where I_TXT in
    (select I_TXT_STEP_MESS from PRD_BIA_ODIREPO.SNP_STEP_REPORT) ;

    delete from PRD_BIA_ODIREPO.SNP_EXP_TXT_HEADER where I_TXT in
    (select I_TXT_SESS_MESS from PRD_BIA_ODIREPO.SNP_SCEN_REPORT) ;

/*
* 6. Delete Scenario associated reports
*/
    /* (a). Deactivate the constraints */
    alter table PRD_BIA_ODIREPO.SNP_STEP_REPORT disable constraint FK_STEP_REPORT ;

    /* (b). Delete */
    truncate table PRD_BIA_ODIREPO.SNP_STEP_REPORT ;
    truncate table PRD_BIA_ODIREPO.SNP_SCEN_REPORT ;

    /* (c). Reactivate the constraints */
    alter table PRD_BIA_ODIREPO.SNP_STEP_REPORT enable constraint FK_STEP_REPORT ;

/*
* 7. Commit the changes
*/
    commit ;

#######################################################################

Clear tmp and Cache folders in ODI server paths, after restart the ODI server will create new TMP folders automatically.

Now you can start back your ODI services and Agents and you can test by triggering a new load plan.
You willsee the sessions will start with 2.... and now you will be able to open the session logs directly from the executed load plans.

Oracle reference:-
Unable to Open The Scenario Object Using The Link Of The Execution Session ID From Load Plan Session Log In ODI Studio Operator (Doc ID 2222817.1 )

How To Manually Delete ODI 10g And 11g Sessions And Scenario-Related Reports (Doc ID 424740.1)

K@run@

T-Series vs PewDiePie

technicalrocker@gmail.com (Technical Rocker-k@run@) — Mon, 1 Apr 2019 15:58:00 +0530

Its finally here, the most subscribed you tube channel title was stolen by T-Series from PewDiePie.

The Indian over a long battle acquired the title and thanks to all the fans all over the world who went over the comfort zone and made this happen.

K@run@

Donate Red, Spread Green, Save Blue

technicalrocker@gmail.com (Technical Rocker-k@run@) — Fri, 30 Mar 2018 15:41:00 +0530

Donate Red ❤️; Spread Green 💚; Save Blue 💙

#triplesavers
K@run@