(TR0112) There isn't enough memory available

Error:
(TR0112) There isn't enough memory available.

Reason:
"Enable Mutli-Processing" enabled on datasources and the addition of the new datasource appears to push the limitations of this feature based on the size of the data being pulled.
Remove multi-processing from datasources


1. Open the model in Transformer
2. Right click the datasource and select "properties"
3. Click on the General tab
4. Uncheck "enable multi-processing" and click OK
5. Repeat steps 2 through 4 for all data source entries
6. Test / Build


Also ensure that there are enough system resources available when building the cube. This includes plenty of free memory, diskspace, and processor time. For example, if your database is using up 90% of the memory while you attempt to launch rsserver to build cubes, the cube build will fail at some point due to lack of memory available. Lack of memory in this case can also seen via monitoring the syslog (on unix system only) file.

TR1907 Transformer cannot gain access to database

When a cube is automated to rebuild on a regular basis, transformer fails to create the cube due to the failed authentication. Transformer prompts for user password even if the prompt for password box is unchecked in the Signon Property Sheet and Include Access Manager auto-access in the model is checked in the authentication tab of Model Property Sheet.
Error Details:
(TR1907) Transformer can't gain access to database 'Database Name' with signon information 'username'. [->Cancel] PowerPlay Transformer
Reason:
The Database signon is not recognized by Transformer via Access Manager due to an incorrect database name. Database name specified within transformer needs to be exactly the same as the one set up within Access Manager. This is also case sensitive.

Use Access Manager to record the database authentication and set the auto-access to access manager's signon. Cognos common signons are set to flown from Access Manager user class as well as the database signon

Steps:

1. Create the data source in Access Manager Admin Console
2. Add user signos into the user class Administrator
3. Uncheck the box against Prompt for Password in the user signon property sheet
4. Within datasource property sheet, specify the datasource name, which should be exactly the same as the one in Access Manager. The datasource name is case sensitive.
5. Activate "Include Access Manager auto-access in the model" from Authentication tab of the Model Property Sheet

Interesting article……

Interesting article……

What killed Ranjan Das and Lessons for Corporate India

A month ago, many of us heard about the sad demise of Ranjan Das from Bandra, Mumbai. Ranjan, just 42 years of age, was the CEO of SAP-Indian Subcontinent, the youngest CEO of an MNC in India. He was very active in sports, was a fitness freak and a marathon runner. It was common to see him run on Bandra's Carter Road. Just after Diwali, on 21st Oct, he returned home from his gym after a workout, collapsed with a massive heart attack and died. He is survived by his wife and two very young kids.

It was certainly a wake-up call for corporate India. However, it was even more disastrous for runners amongst us. Since Ranjan was an avid marathoner (in Feb 09, he ran Chennai Marathon at the same time some of us were running Pondicherry Marathon 180 km away), the question came as to why an exceptionally active, athletic person succumb to heart attack at 42 years of age.

Was it the stress?
A couple of you called me asking about the reasons. While Ranjan had mentioned that he faced a lot of stress, that is a common element in most of our lives. We used to think that by being fit, one can conquer the bad effects of stress. So I doubted if the cause was stress.

The Real Reason
However, everyone missed out a small line in the reports that Ranjan used to make do with 4-5 hours of sleep. This is an earlier interview of Ranjan on NDTV in the program 'Boss' Day Out':
http://connect.in.com/ranjan-das/play-video-boss-day-out-ranjan-das-of-sap-india-229111-807ecfcf1ad966036c289b3ba6c376f2530d7484.html < http://connect.in.com/ranjan-das/play-video-boss-day-out-ranjan-das-of-sap-india-229111-807ecfcf1ad966036c289b3ba6c376f2530d7484.html >
Here he himself admits that he would love to get more sleep (and that he was not proud of his ability to manage without sleep, contrary to what others extolled).

The Evidence
Last week, I was working with a well-known cardiologist on the subject of ‘Heart Disease caused by Lack of Sleep’. While I cannot share the video nor the slides because of confidentiality reasons, I have distilled the key points below in the hope it will save some of our lives.

Some Excerpts:

· Short sleep duration (<5> compared to those who slept longer than 6 hours per night. Paper published in 2009.
As you know, high BP kills.

· Young people (25-49 years of age) are twice as likely to get high BP if they sleep less. Paper published in 2006.

· Individuals who slept less than 5 hours a night had a 3-fold increased risk of heart attacks .. Paper published in 1999.

· Complete and partial lack of sleep increased the blood concentrations of High sensitivity C-Reactive Protein (hs-cRP), the strongest predictor of heart attacks. Even after getting adequate sleep later, the levels stayed high!!

· Just one night of sleep loss increases very toxic substances in body such as Interleukin-6 (IL-6), Tumour Necrosis Factor-Alpha (TNF-alpha) and C-reactive protein (cRP). They increase risks of many medical conditions, including cancer, arthritis and heart disease . Paper published in 2004.

· Sleeping for <=5 hours per night leads to 39% increase in heart disease. Sleeping for <=6 hours per night leads to 18% increase in heart disease. Paper published in 2006.

Ideal Sleep
For lack of space, I cannot explain here the ideal sleep architecture. But in brief, sleep is composed of two stages: REM (Rapid Eye Movement) and non-REM. The former helps in mental consolidation while the latter helps in physical repair and rebuilding . During the night, you alternate between REM and non-REM stages 4-5 times.

The earlier part of sleep is mostly non-REM. During that period, your pituitary gland releases growth hormones that repair your body. The latter part of sleep is more and more REM type.

For you to be mentally alert during the day, the latter part of sleep is more important. No wonder when you wake up with an alarm clock after 5-6 hours of sleep , you are mentally irritable throughout the day ( lack of REM sleep ). And if you have slept for less than 5 hours , your body is in a complete physical mess ( lack of non-REM sleep), you are tired throughout the day, moving like a zombie and your immunity is way down (I’ve been there, done that L )

Finally, as long-distance runners, you need an hour of extra sleep to repair the running related damage.

If you want to know if you are getting adequate sleep , take Epworth Sleepiness Test below.



Interpretation : Score of 0-9 is considered normal while 10 and above abnormal. Many a times, I have clocked 21 out the maximum possible 24, the only saving grace being the last situation, since I don’t like to drive (maybe, I should ask my driver to answer that line J )

In conclusion:

Barring stress control, Ranjan Das did everything right: eating proper food, exercising (marathoning!), maintaining proper weight. But he missed getting proper and adequate sleep, minimum 7 hours. In my opinion, that killed him.
If you are not getting enough sleep (7 hours), you are playing with fire, even if you have low stress.

I always took pride in my ability to work 50 hours at a stretch whenever the situation warranted. But I was so spooked after seeing the scientific evidence last week that since Saturday night, I ensure I do not even set the alarm clock under 7 hours. Now, that is a nice excuse to get some more sleep. J

Unfortunately, Ranjan Das is not alone when it comes to missing sleep. Many of us are doing exactly the same, perhaps out of ignorance.