Error in Table Creation

Situation:
While creating the table in Oracle database, hitting the following error:

Error at Command Line:1 Column:0
Error report:
SQL Error: ORA-01950: no privileges on tablespace 'USERS'
01950. 00000 - "no privileges on tablespace '%s'"
*Cause: User does not have privileges to allocate an extent in the
specified tablespace.
*Action: Grant the user the appropriate system privileges or grant the user
space resource on the tablespace.

Solution:
GRANT RESOURCE to user_name;

SAP BW - Notes #01

Extractor - a set of ABAP programs, database tables, and other objects that BW uses to extract data from the SAP systems.

BW connects with SAP systems (R/3 or BW) and flat files via ALE (Application Link Enabling) and it connects with non-SAP systems via BAPI (Business Application Programming Interface).

DataStage Error - [General repository interface 'other error']

Situation
Today,one of my DataStage job that is scheduled to be run everyday suddenly failed and below is the error message that I captured in DataStage Director.

jobControlForEntity..JobControl (@JA_loadETLStreamFromRelationship): Controller problem: Error calling DSRunJob(loadETLStreamFromRelationship), code = -99
[General repository interface 'other error']

When I saw this error message, I really have no clues on why this error message is thrown as the job is running without fail all the time. Anyway, after spending a couple of hours to debug it and I managed to resolve this.


Solutions

1. Create a new copy of the loadETLStreamFromRelationship by right click on the job and select Create Copy. A new job with the name CopyOfloadETLStreamFromRelationship is created.
2. Change the job sequence to invoke the new copy of the job which is CopyOfloadETLStreamFromRelationship.
3. Recompile and re-run the job. Now the job running fine without throwing any errors as stated above.
4. Delete the previous job loadETLStreamFromRelationship.
5. Rename the new copy of the job to become loadETLStreamFromRelationship and change back the sequence to invoke the loadETLStreamFromRelationship.

Hope this helps.

Error Encountered in Cognos 8.3 with Oracle XE

Below is the error message that I encountered when trying to run a report in Cognos.

CNC-MON-0024 Monitor Service paging error: Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found The Connection descriptor used by the client was: localhost:1521:XE

I am not too sure what is the actual cause of this error but below is the way that I solved it.

Launch SQL Plus and issue the the command as below:

SQL> connect / as sysdba;
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 285212672 bytes
Fixed Size 1287016 bytes
Variable Size 96472216 bytes
Database Buffers 184549376 bytes
Redo Buffers 2904064 bytes
Database mounted.

SQL> alter system set job_queue_process=20;
System altered.

SQL> alter system set PROCESSES=100 scope=SPFILE;
System altered.

SQL> alter system set open_cursors=300 scope=both;
System altered.

SQL> alter database open;
Database altered.

SQL> alter system disable restricted session;
System altered.

Hope this may helps. :)

Install and Configure Cognos 8 Business Intelligence - Part 1

This post shows the step-by-step from installation and configuration of Cognos 8.

Assumption : MS SQL Server 2005 and IIS already installed in your machine.

Install Cognos 8 BI on Windows 2000

Run the issetup.exe in the win32 folder from your download directory. The following screen will be shown.


Ensure that English is selected as the language and click Next.


Accept the license agreement by choosing the I accept radio button. Click Next.


Accept the default as the installation location. Click Next.


A dialog box will be pop-up to ask for confirmation whether you want to create the directory. Click Yes and next screen will be shown.


Ensure that all the components are selected as depicted in above screen and click Next.


Click Next again at this step.


You are now at Installation Summary screen which summarize list of components to be installed in your machine and in the particular drive. Click Next.


The installation process is now starting. Once completed, click Next and you can see the following screen.


Click on finish to close the screen. You just finish with the installation process of Cognos 8 BI.

You shouldn't have any problem with all the steps indicated here as the entire installation process is pretty straight forward. I will be posted the Part 2 end of this week. :)