Update Registry Settings to Avoid SmartView Time Out Errors

SmartView has come a long way over the years, especially the Planning Ad-Hoc capabilities. Even though the developers have added a ton of new features to SmartView, clients and end users still like to use the tried and true HSGetValue and HSSetValue functions.

While there are many performance settings for Analytic Provider Services and Essbase to increase the performance of SmartView retrievals, nothing can prepare an administrator for a power user that shares their 10 MB excel file containing 100’s of HSGetValue functions and calls each user to hit the refresh button at the same time.

This can turn out to be an administrators worst nightmare especially if a company is right in the middle of their planning or forecast cycle.

So hopefully you are being proactive and reading this prior to this issue appearing, but if not the following should help you fix the issue.

Fix Number 1 – Internet Explorer Timeout Setting on Client Machine

See Support Article #744559.1

Internet Explorer has a very low default timeout setting for retrieving data. SmartView uses Internet Explorer to connect to the Analytic Provider Services (APS) server.

The instructions described below will update Registry Settings in order to avoid the following Smart View Time Out error:

“Request Timed Out. Contact your smartview client system administrator to extend your Windows Internet Explorer timeout settings (Receive Timeout, KeepAlive Timeout and ServerInfo Timeout).”

1. Select Start button on Windows > Type “Run” in the “Search programs and files” bar > Enter

Start

2. In the new Run window, type “regedit” as shown in the image below:

regedit

3. In the registry editor, navigate to Computer > HKEY_LOCAL_MACHINE > Software > Microsoft > Windows > Current Version > Internet Settings

Note: It is possible you may need administrative rights to change or modify these settings.

As displayed in the error message, the following keys with their corresponding values must be created:

  • ReceiveTimeout: 480000
  • KeepAliveTimeout: 180000
  • ServerInfoTimeout: 180000

In order to create the new keys,

4. Right click on Internet Settings > New > DWORD (32-bit) Value

key

5. Type in the key name. For instance, “ReceiveTimeout” > Enter

6. Right Click on “ReceiveTimeout” and select Modify

WEBINAR

Building to the ‘Top’ with OneStream: HFM Replacement Story

7. Enter the value of the key and select Hexadecimal

val

8. Repeat the same steps for the other two keys (KeepAliveTimeout, ServerInfoTimeout)

The updated keys and values should be displayed as shown below:

keys

9. Restart your computer to ensure the changes are updated.

Fix Number 2

See Support Article 852716.1

Locate the Analytic Provider Services (APS) server.

Locate the essbase.properties file in the Oracle Home Directory.

<Drive Letter>OracleMiddlewareEPMSystem11R1productsEssbaseapsbin

Add the following entries to the essbase.properties file:

netRetryCount=6000
netConnectRetry=30
netDelay=2000
netSocketTimeOut=20000

Restart the APS service.

Fix Number 3

See Support Article 1096414.1

Locate the Analytic Provider Services (APS) server.

Ask an end user to run the offending SmartView template.

Open a command prompt and type netstat -an.

Check to see if all the ports are being used up. Windows can only open ~64,000 ports. By default, Windows leaves the ports open for two long so when another user tries to run another query, the query errors out.

To decrease the timeout you can modify the TIME_WAIT delay on the APS server to around 30 seconds.

 

A Better Solution Through OneStream Software

At the time of the original publication of this article in January 2015, SmartView was once a premier software tool in the Enterprise Performance Management (EPM) or Corporate Performance Management (CPM) toolbox. 

Since our origination in 2012, HollandParker is a CPM software consulting firm that specializes in best-of-breed CPM software implementation solutions for Fortune 500 corporations and global enterprise companies to medium and small businesses across North America. From 2012 to 2017, we supported Oracle performance management products. Now, the market has changed. OneStream Software is the leader in corporate performance management solutions for global organizations of all sizes, providing a single platform, OneStream XF, that replaces fragmented legacy applications.

In 2015, our partnership with OneStream began. And, due to client demand, we made a 100 percent business commitment to the OneStream partnership in 2017. OneStream has created a series of capabilities that all naturally live and work together so that organizations don’t have to do the hard part of integrating or connecting separate technologies together. OneStream built one product that has a full set of capabilities to solve the most sophisticated business problems. We are proud of our 100 percent company dedication to OneStream and to be a top OneStream Implementation Partner with Diamond status. Find out more about migrating to OneStream and our Diamond OneStream Implementation process by contacting HollandParker today.

Share this

About the author

Philip Parker

The Pre-Transformation Checklist for Finance

An 11-Step Risk Reduction Tool for CFOs and CAOs Who Aren’t Sure Where to Start

By following this checklist, organizations can systematically approach their finance technology transformation, ensuring that all critical aspects are addressed and that the transition is smooth and successful.

Related posts you might like

Transformation program leaders guide

THE TRANSFORMATION PROGRAM LEADER’S GUIDE TO FINANCE ROADMAPS

View Post
BUILDING A SCALABLE FINANCE STACK: WHAT HIGH-GROWTH CFOS NEED TO KNOW

BUILDING A SCALABLE FINANCE STACK: WHAT HIGH-GROWTH CFOS NEED TO KNOW

View Post
Why CFOs Should Lead the Finance Transformation Agenda

Why CFOs Must Lead the Finance Transformation Agenda

View Post

Privacy Policy

Introduction

Welcome to Holland Parker. We are committed to protecting your personal information and your right to privacy. If you have any questions or concerns about our policy or our practices with regard to your personal information, please contact us at [email protected].

Information We Collect

We collect personal information that you provide to us when expressing an interest in obtaining information about us or our products and services, when participating in activities on the website, or otherwise contacting us.

The personal information that we collect depends on the context of your interactions with us and the website, the choices you make, and the products and features you use. The personal information we collect can include the following:

  • Name and Contact Data: We collect your first and last name, email address, postal address, phone number, and other similar contact data.
  • Payment Data: We collect data necessary to process your payment if you make purchases, such as your payment instrument number (e.g., a credit card number), and the security code associated with your payment instrument.
  • Login Credentials: We collect passwords, password hints, and similar security information used for authentication and account access.
  • Other Information: We collect any other information you directly provide to us through our website.

How We Use Your Information

We use personal information collected via our website for a variety of business purposes described below. We process your personal information for these purposes in reliance on our legitimate business interests, in order to enter into or perform a contract with you, with your consent, and/or for compliance with our legal obligations.

We use the information we collect or receive:

  • To send administrative information to you.
  • To fulfill and manage your orders.
  • To post testimonials.
  • To request feedback.
  • To send you marketing and promotional communications.
  • To deliver targeted advertising to you.
  • For other business purposes.

Sharing Your Information

We may process or share your data that we hold based on the following legal basis:

  • Consent: We may process your data if you have given us specific consent to use your personal information for a specific purpose.
  • Legitimate Interests: We may process your data when it is reasonably necessary to achieve our legitimate business interests.
  • Performance of a Contract: Where we have entered into a contract with you, we may process your personal information to fulfill the terms of our contract.
  • Legal Obligations: We may disclose your information where we are legally required to do so in order to comply with applicable law, governmental requests, a judicial proceeding, court order, or legal process.
  • Vital Interests: We may disclose your information where we believe it is necessary to investigate, prevent, or take action regarding potential violations of our policies, suspected fraud, situations involving potential threats to the safety of any person, and illegal activities.

Cookies and Other Tracking Technologies

We may use cookies and similar tracking technologies to access or store information. Specific information about how we use such technologies and how you can refuse certain cookies is set out in our Cookie Policy.

Data Security

We aim to protect your personal information through a system of organizational and technical security measures. We have implemented appropriate technical and organizational security measures designed to protect the security of any personal information we process.

Retention of Data

We will only keep your personal information for as long as it is necessary for the purposes set out in this privacy policy unless a longer retention period is required or permitted by law.

Your Privacy Rights

In some regions, such as the European Economic Area (EEA), you have certain rights under applicable data protection laws. These may include the right to (i) request access and obtain a copy of your personal information, (ii) request rectification or erasure; (iii) restrict the processing of your personal information; and (iv) if applicable, to data portability.

Updates to This Policy

We may update this privacy policy from time to time in order to reflect changes to our practices or for other operational, legal, or regulatory reasons.

Contact Us

If you have questions or comments about this policy, you may contact us by email at [email protected].

The Pre-Transformation Checklist for Finance

Tap into wisdom gained through 300+ finance transformations to uncover answers to questions you have and those you should.

This field is for validation purposes and should be left unchanged.